Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st May 2012, 20:22
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default 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...
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
Sponsored Links
  #2  
Old 21st May 2012, 20:28
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

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)
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #3  
Old 21st May 2012, 20:35
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

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!
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #4  
Old 21st May 2012, 22:14
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

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
__________________
Updating my server to Debian Squeeze, so here I go again...

Last edited by DaRKNeSS666NL; 21st May 2012 at 22:34.
Reply With Quote
  #5  
Old 21st May 2012, 22:29
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 47 Times in 28 Posts
Default

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.
Reply With Quote
  #6  
Old 21st May 2012, 22:38
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

Quote:
Originally Posted by dclardy View Post
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.
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #7  
Old 22nd May 2012, 08:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,083
Thanks: 826
Thanked 5,397 Times in 4,241 Posts
Default

Does the directory /etc/mysql/conf.d/ exist? If not, create it.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 22nd May 2012, 20:53
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

Quote:
Originally Posted by till View Post
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
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #9  
Old 25th May 2012, 10:17
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

Quote:
Originally Posted by DaRKNeSS666NL View Post
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
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #10  
Old 25th May 2012, 10:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,083
Thanks: 826
Thanked 5,397 Times in 4,241 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SquirrelMail login not working glenneh Installation/Configuration 13 9th April 2011 20:01
can't send/recieve email postfix/smtpd archbird Installation/Configuration 6 8th November 2010 14:48
Unbearably slow access speeds CombatGod Installation/Configuration 5 30th May 2006 16:31
configuring IPTABLES firewall adityavpratap HOWTO-Related Questions 9 27th May 2006 21:42
Could not make OpenSSL yontengyatso Installation/Configuration 3 3rd November 2005 10:50


All times are GMT +2. The time now is 06:58.


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