After Update of ISPConfig data base error

Discussion in 'General' started by Appie Thrasher, May 21, 2012.

  1. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    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...
     
  2. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    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)
     
  3. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    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!
    
     
  4. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    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
     
    Last edited: May 21, 2012
  5. dclardy

    dclardy New Member

    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.
     
  6. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    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.
     
  7. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

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

    Appie Thrasher Member HowtoForge Supporter

    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
     
  9. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    That did the trick indeed, thanks all

    Appie
     
  10. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    The directory is normally empty. It exists as an option to extend my.cnf.

    The update was aborted as mysql was not running. Just restart the update process after you fixed mysql.
     
  11. Appie Thrasher

    Appie Thrasher Member HowtoForge Supporter

    That's what was strange, the update was not aborted it came out finished. ISPConfig version says Version: 3.0.4.5 and the msql was running, its my live server, or does the update stops the server, and maybe we ran into some sort of bug...

    Appie
     
  12. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Ok, then you dont have to rerun the update.
     

Share This Page