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

Thread: Mysql error on install

  1. #1
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default Mysql error on install

    On install of Zimbra, I get an error:

    Startng mysql
    UPGRADE FAILED -exiting

    Right before this it shows Verifying /opt/zimbra/conf/my.cnf - This wasn't present so I copied what I had from my my.cnf file to this location. I also shutdown Iptables, Httpd, and Mysqld before running the install.

    Can anyone tell me what the problem might be? I'm running 4.5.5_GA_838 and RHEL 4.

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

    Default

    What happens when you
    su - zimbra
    mysql.server start

    Does it start, or fail right away?
    If it starts, then it's a password issue. Go to the wiki, and lookup how to reset the mysql password.

    If it's fails right away, look in /opt/zimbra/db/data/(hostname.domain).err for why.

    -john

  3. #3
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default

    [zimbra@ns1 ~]$ mysql.server start
    [zimbra@ns1 ~]$ cat: /var/run/mysqld/mysqld.pid: Permission denied
    rm: cannot remove `/var/run/mysqld/mysqld.pid': Permission denied
    Fatal error: Can't remove the pid file: /var/run/mysqld/mysqld.pid
    /opt/zimbra/mysql/bin/mysqld_safe: line 352: /var/lib/mysql/ns1.err: Permission denied
    Please remove it manually and start /opt/zimbra/mysql/bin/mysqld_safe again
    mysqld daemon not started

    This was while my current Mysql was running:

    Here is when my mysql isn't running:


    [zimbra@ns1 bin]$ mysql.server start
    [zimbra@ns1 bin]$ Starting mysqld daemon with databases from /var/lib/mysql
    /opt/zimbra/mysql/bin/mysqld_safe: line 379: /var/lib/mysql/ns1.err: Permission denied
    rm: cannot remove `/var/lib/mysql/mysql.sock': Permission denied
    /opt/zimbra/mysql/bin/mysqld_safe: line 387: /var/lib/mysql/ns1.err: Permission denied
    STOPPING server from pid file /var/run/mysqld/mysqld.pid
    tee: /var/lib/mysql/ns1.err: Permission denied
    070529 08:43:57 mysqld ended
    tee: /var/lib/mysql/ns1.err: Permission denied
    Last edited by tommygun; 05-29-2007 at 09:46 AM. Reason: clarify

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

    Default

    Can you run a
    which mysql
    ?

  5. #5
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default

    [root@ns1 /]# which mysql
    /usr/bin/mysql
    [root@ns1 /]#

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

    Default

    That's not the right instance of mysql. Try to run the installer again with:
    ./install.sh -s

  7. #7
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default

    I ran it with ./install.sh -s and it shows install complete. However, upon running zmsetup.pl I get stuck at the same place:


    Upgrading from to 4.5.5_GA_838
    Stopping zimbra services
    Verifying /opt/zimbra/conf/my.cnf
    Starting mysql
    UPGRADE FAILED - exiting

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

    Default

    okay, now
    su - zimbra
    which mysql

  9. #9
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default

    [zimbra@ns1 /]$ which mysql
    ~/bin/mysql
    [zimbra@ns1 /]$

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

    Default

    Okay-
    Can you run the
    mysql.server start

    without the cat? Are you doing the cat, or is the script?

    Also, please post your /opt/zimbra/db/data/host.domain.com.err file

    Thanks
    john

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  2. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  3. Source Install Initialization
    By buttars in forum Developers
    Replies: 1
    Last Post: 01-31-2006, 04:41 PM
  4. Replies: 4
    Last Post: 01-18-2006, 11:58 AM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 07: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
  •