Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Mysql does not start on RHEL 64

  1. #1
    cryptogram is offline Active Member
    Join Date
    Jan 2007
    Posts
    35
    Rep Power
    8

    Default Mysql does not start on RHEL 64

    Mysqld fails to start on RHEL 64 (Linux 2.6.9-42.0.3.ELsmp SMP Mon Sep 25 17:24:31 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux) w/ zcs-NETWORK-4.5.0_GA_612.RHEL4_64

    From zmsetup.log

    * Creating required directories
    * Generating mysql config /opt/zimbra/conf/my.cnf
    * Creating database in /opt/zimbra/db/data
    * Starting mysql server
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...retrying
    * Failed to connect to mysql...giving up!
    Done

    Initializing logger sql database...
    *** Running as zimbra user: /opt/zimbra/libexec/zmloggerinit

    * Creating required directories
    * Creating database in /opt/zimbra/logger/db/data
    * Starting logger_mysql server
    * Loading schema /opt/zimbra/db/loggerdb.sql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    * Setting random password for mysql root user in zimbra local config
    * Setting random password for mysql zimbra user in zimbra local config
    * Changing mysql root user password
    ^G/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!

    Any help would be greatly appreciated.

  2. #2
    anand is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    274
    Rep Power
    9

    Default

    Was this an upgrade from 4.0.x or is this a new install?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  3. #3
    cryptogram is offline Active Member
    Join Date
    Jan 2007
    Posts
    35
    Rep Power
    8

    Default

    Quote Originally Posted by anand View Post
    Was this an upgrade from 4.0.x or is this a new install?
    This was a complete fresh install on a freshly installed RHEL machine.

    Thanks.

  4. #4
    anand is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    274
    Rep Power
    9

    Default

    is selinux turned on?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  5. #5
    cryptogram is offline Active Member
    Join Date
    Jan 2007
    Posts
    35
    Rep Power
    8

    Default

    Quote Originally Posted by anand View Post
    is selinux turned on?
    Yes it is.

    SELinux status: enabled
    SELinuxfs mount: /selinux
    Current mode: permissive
    Mode from config file: permissive
    Policy version: 18
    Policy from config file:targeted

    Policy booleans:
    allow_syslog_to_console inactive
    allow_ypbind inactive
    dhcpd_disable_trans inactive
    httpd_builtin_scripting active
    httpd_disable_trans inactive
    httpd_enable_cgi active
    httpd_enable_homedirs active
    httpd_ssi_exec active
    httpd_tty_comm inactive
    httpd_unified active
    mysqld_disable_trans inactive
    named_disable_trans inactive
    named_write_master_zonesinactive
    nscd_disable_trans inactive
    ntpd_disable_trans inactive
    pegasus_disable_trans inactive
    portmap_disable_trans inactive
    postgresql_disable_transinactive
    snmpd_disable_trans inactive
    squid_disable_trans inactive
    syslogd_disable_trans inactive
    use_nfs_home_dirs inactive
    use_samba_home_dirs inactive
    use_syslogng inactive
    winbind_disable_trans inactive
    ypbind_disable_trans inactive
    Last edited by cryptogram; 01-18-2007 at 12:33 PM.

  6. #6
    anand is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    274
    Rep Power
    9

    Default

    pls try with selinux off.

    Is there anything in the logs directory from the logger mysql (we run two instance of mysql - one for mail and one for syslog data and in your case the logging one is the one that can not be initialized).

    After that if you still have the same problem, (and since this is a new system, and you can afford to trash it) try running bash -x /opt/zimbra/libexec/zmloggerinit and see what the hell it is doing.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  7. #7
    cryptogram is offline Active Member
    Join Date
    Jan 2007
    Posts
    35
    Rep Power
    8

    Default

    Quote Originally Posted by anand View Post
    pls try with selinux off.

    Is there anything in the logs directory from the logger mysql (we run two instance of mysql - one for mail and one for syslog data and in your case the logging one is the one that can not be initialized).

    After that if you still have the same problem, (and since this is a new system, and you can afford to trash it) try running bash -x /opt/zimbra/libexec/zmloggerinit and see what the hell it is doing.
    I will disable SELinux and see what happens and provide an update as soon as the system comes up again.

  8. #8
    cryptogram is offline Active Member
    Join Date
    Jan 2007
    Posts
    35
    Rep Power
    8

    Default

    [root@zimbra ~]# sestatus
    SELinux status: disabled

    Disabled SELinux, but it is still not working. However, I am getting a different error message.

    I am going to reinstall zcs from scratch. Is there anything I need to do before running the install.sh script to ensure that I am doing a clean reinstall of zcs?

    Thanks.

  9. #9
    cryptogram is offline Active Member
    Join Date
    Jan 2007
    Posts
    35
    Rep Power
    8

    Default

    [root@zimbra log]$ cat zmmyinit.log

    Installing all prepared tables
    mysqld got signal 11;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help diagnose
    the problem, but since we have already crashed, something is definitely wrong
    and this may fail.

    key_buffer_size=8388600
    read_buffer_size=1044480
    max_used_connections=0
    max_connections=54
    threads_connected=1
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 118567 K
    bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    thd=(nil)
    Attempting backtrace. You can use the following information to find out
    where mysqld died. If you see no messages after this, something went
    terribly wrong...
    frame pointer is NULL, did you compile with
    -fomit-frame-pointer? Aborting backtrace!
    The manual page at http://www.mysql.com/doc/en/Crashing.html contains
    information that should help you find out what is causing the crash.
    Installation of system tables failed!

    Examine the logs in /opt/zimbra/db/data for more information.
    You can also try to start the mysqld daemon with:
    /opt/zimbra/mysql/libexec/mysqld --skip-grant &
    You can use the command line tool
    /opt/zimbra/mysql/bin/mysql to connect to the mysql
    database and look at the grant tables:

    shell> /opt/zimbra/mysql/bin/mysql -u root mysql
    mysql> show tables

    Try 'mysqld --help' if you have problems with paths. Using --log
    gives you a log in /opt/zimbra/db/data that may be helpful.

    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Please consult the MySQL manual section: 'Problems running mysql_install_db',
    and the manual section that describes problems on your OS.
    Another information source is the MySQL email archive.
    Please check all of the above before mailing us!
    And if you do mail us, you MUST use the /opt/zimbra/mysql-standard-5.0.26-pc-linux-gnu-i686-glibc23/bin/mysqlbug script!
    Starting mysqld daemon with databases from /opt/zimbra/db/data
    STOPPING server from pid file /opt/zimbra/db/mysql.pid
    070118 12:34:26 mysqld ended

  10. #10
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,502
    Rep Power
    57

    Default

    If you want to do a clean install then './install.sh -u' will remove all of the /opt/zimbra directory. You should make sure that SElinux is disabled and not in warn mode and any firewall is also disabled. You can then run the install again.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 02-03-2011, 07:01 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. Is it started or not
    By kwelipatton in forum Installation
    Replies: 10
    Last Post: 03-28-2006, 11:11 PM
  4. No listener on port 7071
    By earthling in forum Installation
    Replies: 3
    Last Post: 11-14-2005, 08:16 AM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

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