MySQL refuses access to everything...

[ontheweb]

I ran and upgrade from 5.0 to 5.1 using the cPanel upgrade manager (for MySQL) and ever since then nothign has been able to make connections to MySQL, but there is a twist.

Things that already have a connection (for example, my forum and blog work because they were around before the upgrade) but anything added after the upgrade (including new accounts and even a new root account I created) doesn't work.

I've spent the best part of 2 days trying to find a way to fix it but am getting nowhere, please help!

[cPanelTristan]

Please open up a ticket about this issue as it will be difficult to troubleshoot via the forum for a MySQL issue such as this. Please do confirm if you can access MySQL directly from command line:

mysql

Also, does "mysqladmin proc" return any information or error? Next, you might want to check the error logs when trying to connect to a database for the MySQL logs at /var/lib/mysql/hostname.err where hostname is the fully qualified hostname for the machine.

[ontheweb]

I can access mysql using mysql, mysqladmin proc returns:

+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+----+---------+------+-------+------------------+
| 18 | root | localhost | | Query | 0 | | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+


and there are no errors in that file!
I'll create a ticket now, thanks for the reply.

[danissch]

sorry I put this post in another thread before, but really im not sure, because I have many throubles...

I have this in my email every hour:

install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /etc/cron.hourly/modsecparse.pl line 19

I dont know what to do!!, the database connectios are crashing (some accounts, after update MySql and others system updates), the mod security Plugin not work, cPHulk Brute Force Protection dont display settings in Whm and says "Error while connecting to MySQL."

I did everything that indicates these posts

http://forums.cpanel.net/f5/problem-...ob-193281.html

http://forums.cpanel.net/f5/mod-secu...de-143361.html

http://forums.cpanel.net/f5/problem-...tml#post794882

http://forums.cpanel.net/f5/upgraded...100741-p3.html

I have 5 days trying to solved it and nothing is going right.

Please Help!!!

[cPanelTristan]

Hello,

Please try the following:

/scripts/mysqlup --force
/scripts/perlinstaller --force DBD::mysql

Also, what is sending the email? Is it /etc/cron.hourly/modsecparse.pl that sends an hourly cron email?

If the above does not completely correct the issue, please let us know and please clarify what is sending the email out to you. You may also want to consider a ticket if the above does not fix what is happening due to the emergency status of the issue. You can open up a ticket if you have root SSH and root WHM access to the machine by using WHM > Support Center > Contact cPanel or via the link in my signature.

Thank you

[diegoalberto.me]

Hello,

Please try the following:

/scripts/mysqlup --force
/scripts/perlinstaller --force DBD::mysql

Also, what is sending the email? Is it /etc/cron.hourly/modsecparse.pl that sends an hourly cron email?

If the above does not completely correct the issue, please let us know and please clarify what is sending the email out to you. You may also want to consider a ticket if the above does not fix what is happening due to the emergency status of the issue. You can open up a ticket if you have root SSH and root WHM access to the machine by using WHM > Support Center > Contact cPanel or via the link in my signature.

Thank you

Tried this, didn't worked for me. Did you solved it? thanks

[cPanelTristan]

Are you having the same error that the prior user mentioned? This error:

install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /etc/cron.hourly/modsecparse.pl line 19

If you are not having that exact error, then the commands noted wouldn't be the way to resolve whatever issue you are having. Please provide more details on what is happening on your machine, or please submit a ticket as I requested on my last reply if you are having the same exact error and those commands did not fix it.