HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   After Update of ISPConfig data base error (http://www.howtoforge.com/forums/showthread.php?t=57363)

DaRKNeSS666NL 21st May 2012 20:22

After Update of ISPConfig data base error
 
Please help me!
I have run the update of ispconfig but now I cant login any more and my joomla sites giving error
Code:

Database Error: Unable to connect to the database:Could not connect to MySQL

any Ideas are welcome.

Some more info:
Code:

mysql: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted

__________________
Updating my server to Debian Squeeze, so here I go again...

DaRKNeSS666NL 21st May 2012 20:28

Also can not log in with phpmyadmin

Code:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

DaRKNeSS666NL 21st May 2012 20:35

And this is the output when I try to start msql again:
Code:

server1:~# /etc/init.d/mysql start
/usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
Starting MySQL database server: mysqld/usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
/usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 ./usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
Fatal error in defaults handling. Program aborted
 failed!


DaRKNeSS666NL 21st May 2012 22:14

I have found in an other forum to remove my my.cnf file. So I renamed the file and now I am able to receive mails and see my sites again.

But I am still thinking there are some isus with the server can sombody give me some clues please....

TIA

Appie

dclardy 21st May 2012 22:29

You probably had an issue with your my.cnf file. I am guessing that you updated something on the software side that does not involve ISPConfig.

DaRKNeSS666NL 21st May 2012 22:38

Quote:

Originally Posted by dclardy (Post 279463)
You probably had an issue with your my.cnf file. I am guessing that you updated something on the software side that does not involve ISPConfig.

Thanks for the quick answer,

Now its running without the my.cnf file but thats not the way it should be I am guessing.. or doesn't it matter I renamed the file.

till 22nd May 2012 08:13

Does the directory /etc/mysql/conf.d/ exist? If not, create it.

DaRKNeSS666NL 22nd May 2012 20:53

Quote:

Originally Posted by till (Post 279477)
Does the directory /etc/mysql/conf.d/ exist? If not, create it.

It doesn't exist, I have seen it in my backup but there was noting in it so I guessed it was left there by some proces.
I will create it and test it again with the my.cnf file.
Till any ideas what happened here with the update?

TIA Appie

DaRKNeSS666NL 25th May 2012 10:17

Quote:

Originally Posted by DaRKNeSS666NL (Post 279524)
I will create it and test it again with the my.cnf file.
Till any ideas what happened here with the update?

That did the trick indeed, thanks all

Appie

till 25th May 2012 10:28

Quote:

It doesn't exist, I have seen it in my backup but there was noting in it so I guessed it was left there by some proces.
The directory is normally empty. It exists as an option to extend my.cnf.

Quote:

Till any ideas what happened here with the update?
The update was aborted as mysql was not running. Just restart the update process after you fixed mysql.


All times are GMT +2. The time now is 15:44.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.