Results 1 to 7 of 7

Thread: trouble with mysql

  1. #1
    Join Date
    Mar 2007
    Posts
    18
    Rep Power
    8

    Default trouble with mysql

    hello i have just installed zimbra 4.5 under a centos 5 , the install process work like a charm

    but when i try the command

    /opt/zimbra/bin/zmmysqlstatus
    i got :
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Error while running 'mysql --user= --password= --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 250.
    and thanks

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Stop any running mysql processes you have, and run
    which mysql

    It's not looking for the correct .sock file.

  3. #3
    Join Date
    Mar 2007
    Posts
    18
    Rep Power
    8

    Default

    i have erased my mysql database

    which mysql
    /usr/bin/mysql

    /usr/bin/mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    why he doesn't run zimbra mysql ?

    and thanks

  4. #4
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    I just realized that you're installing on CentOS 5, which isn't actively supported.

    Did you try using the CentOS 5 installation guide that some members put together?

    http://www.zimbra.com/forums/showthread.php?t=8726

  5. #5
    Join Date
    Mar 2007
    Posts
    18
    Rep Power
    8

    Default

    like i said , the install work like a charm and didn't nee no particular trick ,

    the zimbra web mail is running perfectly, but the mysql part is in trouble

  6. #6
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Does zmcontrol status say that mysql.server is running?

  7. #7
    Join Date
    Mar 2007
    Posts
    18
    Rep Power
    8

    Default

    nop ,
    under zimbra user :

    /opt/zimbra/bin/zmmysqlstatus -verbose
    sh: mysql.out: Permission denied
    [zimbra@globe ~]$

    under root :
    /opt/zimbra/bin/zmmysqlstatus
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
    Error while running 'mysql --user= --password= --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 250.
    [root@globe log]#

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. Mysql does not start on RHEL 64
    By cryptogram in forum Installation
    Replies: 11
    Last Post: 01-18-2007, 01:39 PM
  3. Replies: 18
    Last Post: 03-20-2006, 01:22 PM
  4. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM
  5. more fedora install problems
    By jlynch3 in forum Installation
    Replies: 13
    Last Post: 09-14-2005, 09:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •