Error after restore

[ravish78]

Team,
We have installed nagios xi 2.9 on new test server (RHEL 6) which will be replacement of current test server(RHEL 5) version 2.8 c.

After doing install nagios xi is up and accessible.

When we completed backup and restore of current environment then we had issue with ndo2db not starting properly.So i tried below steps to resolve this.

wget -O /usr/lib/libmysqlclient.so.15 http://files.directadmin.com/services/e ... ient.so.15
chmod 755 /usr/lib/libmysqlclient.so.15
ldconfig
yum install libssl.so.6
service ndo2db start

Now ndo2db is starting but we are getting problem with mysqld service.

tmproot@usa0300lv1201>service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld: [FAILED]

mysql is not starting properly but still it shows below process.

tmproot@usa0300lv1201>ps -ef|grep mysql
root 14637 21642 0 19:51 pts/13 00:00:00 grep mysql
root 30541 1 0 19:36 pts/13 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 30643 30541 0 19:36 pts/13 00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock


I am getting blank page when accesing GUI.Can you please help me on this

[ravish78]

Also i see below messages in log files.

Mar 11 16:26:36 usa0300lv1201 abrt-server[24202]: Saved Python crash dump of pid 24201 to /var/spool/abrt/pyhook-2014-03-11-20:26
Mar 11 16:26:39 usa0300lv1201 abrtd: '/var/spool/abrt/pyhook-2014-03-11-19:35:00-28660' is not a problem directory
Mar 11 16:26:39 usa0300lv1201 abrtd: Sending an email...
Mar 11 16:26:39 usa0300lv1201 abrtd: send-mail: error while loading shared libraries: libmysqlclient.so.16: cannot open shared ob irectory
Mar 11 16:26:39 usa0300lv1201 abrtd: Error running '/bin/mailx'
Mar 11 16:26:39 usa0300lv1201 abrtd: 'post-create' on '/var/spool/abrt/pyhook-2014-03-11-20:22:20-19114' exited with 1
Mar 11 16:26:39 usa0300lv1201 abrtd: Corrupted or bad directory '/var/spool/abrt/pyhook-2014-03-11-20:22:20-19114', deleting
Mar 11 16:26:40 usa0300lv1201 abrtd: '/var/spool/abrt/pyhook-2014-03-11-19:35:00-28660' is not a problem directory
Mar 11 16:26:40 usa0300lv1201 abrtd: '/var/spool/abrt/pyhook-2014-03-11-19:35:00-28660' is not a problem directory
Mar 11 16:27:12 usa0300lv1201 nagios: Warning: Return code of 255 for check of service 'BPI Process:Codex BPI test' on host 'usa0

[slansing]

Is this a completely clean, minimal installation of RHEL, from their site, not an internal version? Did you notice any errors during installation? Can you attach your full install.log from the installation directory?

[lmiltchev]

Try stopping the mysqld:

Code: Select all

service mysqld stop

Make sure it's not running:

Code: Select all

ps -ef | grep mysqld

and if for some reason "/var/lib/mysql/mysql.sock" was not removed, you can delete it:

Code: Select all

rm -f /var/lib/mysql/mysql.sock

the start mysqld:

Code: Select all

service mysqld start

If you are still getting errors, run the following commands and show the output:

Code: Select all

tail -50 /var/log/mysqld.log
cat /var/log/messages | grep ndo

[ravish78]

Yes installation was done without errors on clean installed OS.Attached logs.

[slansing]

First thing I noticed is once again you did not register this system with RHEL:

"This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register."

Also, you are not installing XI as root, you are using the user "tmproot" Nagios XI requires that you install with the root user, all things considered, it looks like it made it through the installation. Did you offload the mysql DB? Or was it offloaded on your previous installation?

[lmiltchev]

In addition to this, have you modified the my.cnf file by chance?

Code: Select all

cat /etc/my.cnf

[ravish78]

We did not edit that file /etc/my.cnf.

As per our company policy we were given only tmproot for any installs and we have done 5 installs with this access without any issues.

[abrist]

Is your db offloaded?

wget -O /usr/lib/libmysqlclient.so.15 http://files.directadmin.com/services/e ... ient.so.15
chmod 755 /usr/lib/libmysqlclient.so.15
ldconfig
yum install libssl.so.6
service ndo2db start

Have you used the above procedure in the past? Messing with ld and linking can be dangerous business . . .

[ravish78]

Did you offload the mysql DB? Or was it offloaded on your previous installation?

I did not understand what do mean by offload.Can you please explain.

Have you used the above procedure in the past?

We verified this solution in forums and tried that