Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Server \ OpenNMS separate database     - Linux and hardware (Linux)

- C ++ 11 feature: auto keyword (Programming)

- Linux Open coredump (Linux)

- How Vim playing a mature IDE (Linux)

- Ubuntu 14.04 / 12.04 subscribe users to install software Liferea 1.10.10 (Linux)

- You may not know the Linux command-line network monitoring tool (Linux)

- Thinking in Java study notes - everything is an object (Programming)

- RHEL5 establish a local yum source (Linux)

- Linux platform host to prevent hacking skills (Linux)

- To compile and install Redis Linux and master-slave replication configuration (Database)

- Ubuntu 14.04 LTS installed Hadoop 1.2.1 (distributed cluster mode) (Server)

- How to configure chroot environment in Ubuntu 14.04 (Linux)

- Dom4j change XML coding (Programming)

- Linux file system (inode and block) (Linux)

- C language keywords Comments (Programming)

- hexdump Linux command (Linux)

- How to install GIMP 2.8.16 in Ubuntu 16.04,15.10,14.04 (Linux)

- Use read command to read user input (Programming)

- Installation of Gitlab under Ubuntu (Linux)

- Build Python3.4 + PyQt5.5.1 + Eric6.1.1 development platform under Mac OS X 10.11.1 (Server)

 
         
  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:

/opt/opennms/etc/opennms-datasources.xml

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
     
         
         
         
  More:      
 
- Android gets the global process information and the memory used by the process (Programming)
- Linux basis: a comprehensive study pwd command (Linux)
- How to Install Linux kernel 4.0 on Ubuntu / CentOS (Linux)
- Ubuntu 15.10 15.04 14.10 14.04 Install Ubuntu Tweak (Linux)
- To install Google Chrome browser under Ubuntu 14.04 LTS (Linux)
- Bash code injection attacks through a special environment variable (Linux)
- How to monitor Linux system performance Nmon (Linux)
- A brief introduction to some important Docker commands (Server)
- Linux use glibc2 library and crypt () function to generate the user password (Programming)
- How to create a bootable USB disk to use MultiSystem on Ubuntu (Linux)
- Three details reflect the Unix system security (Linux)
- GCC library link order problems (Programming)
- Linux group account deletion, and other related operations (Linux)
- Solaris 10 nagios monitoring system (Linux)
- Install Visual Studio Code in Ubuntu (Linux)
- About Leetcode on Binary Tree Algorithm summary (Programming)
- mysqldump implement database logical backup (Database)
- Zabbix monitors the status of TCP connections (Server)
- CentOS-based Kickstart automated installation practice (Linux)
- To install MySQL on Linux (Database)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.