Results 1 to 2 of 2

Thread: Solved : mysql.server is not running. on CentOS 5.6 64 bit installation

  1. #1
    vavai's Avatar
    vavai is offline Special Member
    Join Date
    May 2007
    Location
    Indonesia
    Posts
    149
    Rep Power
    8

    Default Solved : mysql.server is not running. on CentOS 5.6 64 bit installation

    Just sharing in case anyone found similar problem.

    Installing Zimbra 7.1.1 and 7.1.2 (clean install) on CentOS 5.6 64 bit using
    binary installer for RHEL 5 64 bit.

    After installation, all services running OK except mysql.server :

    [zimbra@mail ~]$ zmcontrol status
    Host mail.mydomain.tld
    antispam Running
    antivirus Running
    ldap Running
    logger Running
    mailbox Stopped
    mysql.server is not running.
    mta Running
    snmp Running
    spell Running
    stats Stopped
    zmconfigd Running
    [zimbra@mail ~]$ zmcontrol -v
    Release 7.1.2_GA_3268.RHEL5_64_20110804132448 CentOS5_64 FOSS edition.

    Below are portion of installation logs :
    ...
    * Starting mysql server
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    ...

    I could access mysql without password and found that it doesn' create any
    zimbra user and databases.

    Code:
    [zimbra@mail ~]$ zmlocalconfig -s | grep mysql_root_password
    antispam_mysql_root_password = 
    mysql_root_password = zimbra
    [zimbra@mail ~]$ mysql -u root -p
    
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 119
    Server version: 5.1.55-log Source distribution
    
    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL v2 license
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> select host,user from mysql.user;
    +--------------------+------+
    | host               | user |
    +--------------------+------+
    | 127.0.0.1          | root |
    | localhost          |      |
    | localhost          | root |
    | mail.mydomain.tld |      |
    | mail.mydomain.tld | root |
    +--------------------+------+
    5 rows in set (0.03 sec)
    
    mysql>
    Caused by: java.sql.SQLException: Access denied for user 'zimbra'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:919)
    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 4004)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 84)
    at com.mysql.jdbc.ConnectionImpl.connectWithRetries(C onnectionImpl.java:2172)
    ... 56 more
    It seems that the installation setup not executed /opt/zimbra/libexec/zmmyinit, because zimbra user and zimbra database doesn't exist on mysql server. The problem only hit CentOS 5.6 because I don't have any problem on CentOS 5.5.

    Solution is quite simple, just running
    Code:
    /opt/zimbra/libexec/zmmyinit
    with Zimbra user permission after finishing installation and then restart Zimbra services.
    Best Regards
    ---
    Masim "Vavai" Sugianto
    Zimbra Tutorial
    Personal Blog [ID]

    Release 8.0.6_GA_5922.SLES11_64_20131203103702 SLES11_64 FOSS edition.

  2. #2
    SirGarvin is offline Intermediate Member
    Join Date
    Aug 2012
    Posts
    23
    Rep Power
    2

    Default

    I hit the same problem and saw that solution (/opt/zimbra/libexec/zmmyinit) somewhere else and it didn't help. I still got held up at the sql sever.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] mysql.server is not running!
    By russgalleywood in forum Administrators
    Replies: 10
    Last Post: 04-06-2010, 07:58 AM
  2. [SOLVED] mysql.server not running
    By king0770 in forum Administrators
    Replies: 23
    Last Post: 07-25-2009, 03:07 PM
  3. [SOLVED] mysql.server is not running
    By fogogg in forum Administrators
    Replies: 0
    Last Post: 01-05-2009, 08:43 AM
  4. Replies: 1
    Last Post: 05-30-2008, 12:03 PM
  5. Replies: 14
    Last Post: 01-09-2008, 04:07 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
  •