Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Server \ OpenNMS separate database     - Linux Kernel 4.2 Installation Instructions (Linux)

- zBackup: A versatile tool to remove duplicate backup (Linux)

- Quick Install software RAID on Linux (Linux)

- Bitmap memory footprint of computing Android memory optimization (Linux)

- Swift defined type conversion and type aliases (typealias) (Programming)

- After installation of Debian 6.0 do a few things first (Linux)

- Linux Getting Started tutorial: Experience KVM Virtual Machine chapter (Linux)

- Docker: installation under Ubuntu (Server)

- Windows SmartGit installation (Linux)

- Generic mechanism C11 standard (Programming)

- Java Generics Introduction --HashMap summary (Programming)

- How VirtualBox and VMware virtual machine conversion (Linux)

- Redis master-slave replication switch (Database)

- Lazarus for Raspbian installation (Linux)

- Oracle create a temporary table space group (Database)

- Upgrade Goldengate to (Database)

- SSH does not require a password to log on to a Linux server (Server)

- Linux Network Programming --TCP and UDP datagram type Explanation (Programming)

- Linux RAID Set RAID 10 or 0 + 1 (Linux)

- How to modify the Linux NIC eth1 to eth0 (Linux)

  OpenNMS separate database
  Add Date : 2017-04-13      
  1. Detach the database
OpenNMS 1.1 configuration file
1. We need to modify the data source datasource in OpenNMS, when OpenNMS in the following directory:


2. Modify the localhost IP address to the host database

< Jdbc-data-source name = "opennms"

                    database-name = "opennms"

                    class-name = "org.postgresql.Driver" url = "jdbc: postgresql: // database host IP: 5432 / opennms"

                    user-name = "opennms"

                    password = "opennms" />

1.2 Installing PostgreSQL database
1. Install PostgreSql database

yum install postgresql postgresql-server command, the system automatically download postgreSQL installed.

2. First start PostgreSQL

As root, run the command:

/ Sbin / service postgresql start

3. If you see an error, you must initialize PostgreSQL, run the following command:

/ Sbin / service postgresql initdb

 / Sbin / service postgresql start

4. to ensure that PostgreSQL will start after the reboot, use "chkconfig" Command to start at boot time, run the following command:

/ Sbin / chkconfig postgresql on

1.2.1 configuration allows the user access to the database
1. Locate /var/lib/pgsql/data/pg_hba.conf content:

ident-> trust

2. Locate the following modifications /var/lib/pgsql/data/postgresql.conf

listen_addresses = '*'

#port = 5432 to remove the "#"

3. After modifying, you need to restart the database, run as root:

/ Sbin / service postgresql restart

1.3 Test
PostgreSql test database on a separate host OpenNMS host

1. Log OpenNMS host putty

2. Run psql -h database host IP -U opennms -d opennms

3. Check the database

Run \ l

To view the user

Run \ du

drop out

Run \ q

Test described above can successfully connect separate databases on the host OpenNMS

1.4 sql statement executed on the client:

1. In the / opt / opennms / etc directory

Upon completion of the implementation of the restart OpenNMS
- Close Pycharm spell check (Programming)
- Compile and install Redis and register as a system service under RedHat5.8 environment (Database)
- Via Twitter how open source library to be used anywhere Emoji emoticons (Linux)
- Two kinds of agents of Spring AOP (Programming)
- Linux 101 hack book reading notes (Linux)
- curl Usage: Being the first site header and status codes (Server)
- Using Maven to download Spring (Linux)
- Linux Proc File System Experiment (Linux)
- Install Web-based monitoring tool: Linux-Dash (Server)
- Examples of safety testing system notes for RedHat Linux (Linux)
- Linux and Unix systems really do network more secure (Linux)
- Use the Find command to help you find those files that need to be cleaned (Linux)
- Python 3.5 will support Async / Await Asynchronous Programming (Programming)
- Internal class broadcasting needs public and static (Programming)
- How apt-get limited use IPv4 or IPv6 protocol to download (Linux)
- Installation of Python2.7.10 under CentOS 6.4 (Linux)
- gzip, bzip2, xz, tar, zip compression, archive Detailed (Linux)
- Sort search algorithm Java - application examples with recursive dichotomy (Programming)
- Summary Linux operating system some tips to prevent attacks (Linux)
- Linux rpm command Detailed (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.