Ndoutils (ndo2db) Installation difficulties

1. ndoutils CompilationWhen everything is ready and you need to compile and install it, you still need to pay attention to three points: 1. Specify the database type used, the Lib library of the database, and the header file of the database .. /Configure-enable-mysql -- With-mysql-Inc =... -With-mysql-Lib =... 2. If an error similar to "xxxxxx Ceil" occurs during compilation, modify the cflags value in makefile under SRC and add the-LM parameter. Note that there are two cflags in makefile and the second one needs to be modified because it overwrites the first one. You can also drop one of the marks. 3. The installdb step must go to the DB directory and run./installdb because the program needs to read the scripts in the directory. If the corresponding database fails to be generated after performing this step as required, check whether the database user's permissions are correct ".... /Mysqld. "sock" error, please check MySQL configuration file my. CNF confirms that the MySQL connection pool is in this directory. If not, use ln-s to establish a connection with it. If the database table already exists, you can drop the database and re-create and then execute installdb (in this case, make sure that the existing database is no longer used ). 2. There is no data in the dB of ndoutils Compile ndoutils correctly according to the installation documentation, copy the executable files and configuration files to the specified directory, and configure the files correctly. Run the following command to start ndoutils:/usr/local/Nagios/bin/ndo2db-C/usr/local/Nagios/etc/ndo2db. cfg: 2.1. The database cannot be loaded.The following error occurs: "Support for the specified database server is either not yet supported, or was not found on your system. "Please check. the result of/configure should be that MySQL is not found. h. /Specify the header file directory when configure (refer to ndoutils compilation ).

Ndoutils needs to use MySQL, but a lot of problems occurred some time ago in the use of Mysql itself, and I also fell a lot here.

We often encounter problems similar to "Support for the specified database server is either not yet supported, or was not found on your system. "Because the MySQL database is incomplete or the path is incorrect, ndoutils cannot find the MySQL header file and library.

The solution is to install MySQL and Perl libraries.

Libmysql ++-Dev-mysql C ++ library bindings (Development)

Libmysql ++ 2c2a-mysql C ++ library bindings (runtime)

Libmysqlclient15-dev-MySQL database development files

Libmysqlclient15off-MySQL database client library

Libclass-DBI-mysql-perl-class: DBI: mysql-extensions to class: DBI for MySQL

Libdatetime-format-mysql-perl-parse and format MySQL dates and times

Libdbd-mysql-perl-A perl5 database interface to the MySQL database

Libtime-Piece-mysql-perl-time: piece: mysql-adds mysql-specific methods to time: piece

Libpam-mysql-PAM module allowing authentication from a MySQL Server

Libpam-modules-pluggable authentication modules for Pam

Libpam-runtime support for the PAM library

Libpam0g-Pluggable Authentication Modules Library

Libpam0g-dev-development files for Pam

Kaffe-pthreads-a posix Threads enabled version of The kaffe VM

 

In addition, when ndoutils is compiled, if. /configure: MySQL cannot be found. h. After these are correctly installed, you can take the libmysql library and header file directory from elsewhere and specify it. /configure-with-mysql-lib and-with-mysql-lib directories.

Note: after re-configuring./configure, make clean should be remembered before make; otherwise, the last thing that will make you depressed for several days will happen!

 2.2 ndo2db is started normally, but there is no data in the tableFirst, make sure that the tables in the database have been generated. If no prompt is displayed after the name is changed, it means that ndo2db is started properly and data is written to the data. If the table information is viewed from the database at this time, it is normal that the Nagios information already exists. If no data exists at this time. There is only one reason, that is, the database permission problem: Check that the db_user specified in the configuration file is in db_name, and check the information in the DB table in the MySQL database while ensuring that db_pass is correct, make sure that db_user has the update, insert, select, and delete permissions on db_name. See MySQL permission system and MySQL documentation. Log on to mysqlmysql> use MySQL; mysql> select * From dB as the root user. You will see the db_user permission details for db_name, which can be modified using update. If you do not have db_name authorization for db_user, you can add it using insert.