Hi!

I have a nagios instance on a virtualized SME Server 7.5.1

I'm very much interested in evolving my nagios server into one with an NDOUtils Mysql DB.

So I googled and came across this guide for doing it on CentOS: [link]http://www.nagioswiki.com/wiki/index.php/NDOutils_on_CentOS[/link]

I successfully installed mysql-devel and mysql-server packages.

Problem came when I ran the ./configure on the NDOUtils, which retrieved:
[code]
*** MySQL library could not be located... **************************

You chose to compile NDOutils with MySQL support, but I was unable to
locate the MySQL library on your system. If the library is
installed, use the --with-mysql-lib argument to specify the
location of the MySQL library.
installed, use the --with-mysql=DIR argument to specify the
location of the MySQL library, We assume mysql_config is in DIR/dir
NOTE: After you install the necessary libraries on your system:
1. Make sure /etc/ld.so.conf has an entry for the directory in
which the MySQL libraries are installed.
2. Run 'ldconfig' to update the run-time linker options.
3. Run 'make devclean' in the NDBXT distribution to clean out
any old references to your previous compile.
4. Rerun the configure script.

TIP: Try the following....
./configure --with-mysql=/usr/lib/mysql

********************************************************************
[/code]

So, I followed the advice and ran
./configure --with-mysql=/usr/lib/mysql.

The same message came on screen indicating «MySQL library could not be located».

Any sugestions?

Thank you.

to fix this problem, download the libmysqlclient using:

apt-get install libmysqlclient15-dev

worked for me.

Is there any way to select the event log entries from the DB.
I found the _logentries table, but it stores all necessary data in one field 'logentry_data'. It would be nice if this data goes to separate fileds in the database by the ; field separator.

Any ideas?

Thank you

(1) There was an earlier patch to NDOUTILs called NDO_LIGHT that suppressed sending a number of different API records from ndomod to ndo2db via the TCP connection. The patch was conditional on the symbol NDO_LIGHT. All of this appears to have been removed? Was this intentional? Can the patch still be applied to the 1.5 version? Should this be done?

(2) One of the changes to ndo2db has been to move the parsing of NDO API data into a new child process and to implement an IPC message queue between this new child process and it's parent ndo2db instance. The message queue buffer size is fixed at 1K by a define in queue.h
#define NDO_MAX_MSG_SIZE 1024
while the chunk size for the ndo_dbuf in ndo2db.c is set at 2K when ndo_dbuf_init() is invoked. What happens on this invocation
push_into_queue(dbuf->buf);
in ndo2db_check_for_client_input() [ndo2db.c] if the dbuf->buf contains more than 1K? Does this never happen? Has anyone verified this code actually works?

mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

mysql> SHOW VARIABLES LIKE 'collation_%'; +----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+

mysql> select * from test;
+--------+
| a |
+--------+
| ?? |
+--------+

now?all are right, but the data in table from ido2db are unreadble?

| 304 | 1 | 3 | cqtel-cpmis | NULL | 1 |
| 305 | 1 | 3 | 信�技术公�软件部 | NULL | 1 |
| 306 | 1 | 3 | �业部档案管� | NULL | 1 |
| 307 | 1 | 4 | 温度监控 | NULL | 1 |
| 308 | 1 | 1 | ITè¿?ç»´kvm1 | NULL | 0 |
| 309 | 1 | 1 | ITè¿?ç»´kvm2 | NULL | 0 |
| 310 | 1 | 1 | NFS存储 | NULL | 0 |

Using NDOutils to send Nagios results to Centreon. No results anymore in Centreon, no hosts and no services. Reverted back to 1.4b9 and everything is OK again.

Looks like the new ndoutils 1.5 no longer writes to db tables nagios_hosts and nagios_services.

Is this a bug?

Hi, I am having troubles to compile NDOutils 1.5 on OpenBSD 5.0.

I fixed manually the mysql error messages adding the absolute path on include/config.h. Now I am having other error message (not MySQL related) on compilation. Please see the details here:

http://pastebin.com/NpW4h9Lf

Thanks!

what is differrent between 1.5 & 1.4 version? I can't file changelog or document for this version. How can i upgrade from current version (1.4) to new version ?