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

Thread: Mysql error on install

  1. #1
    tommygun is offline Active Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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
    tommygun is offline Active Member
    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 08:46 AM. Reason: clarify

  4. #4
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Can you run a
    which mysql
    ?

  5. #5
    tommygun is offline Active Member
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default

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

  6. #6
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

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

  7. #7
    tommygun is offline Active Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    okay, now
    su - zimbra
    which mysql

  9. #9
    tommygun is offline Active Member
    Join Date
    Jul 2006
    Posts
    30
    Rep Power
    9

    Default

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

  10. #10
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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

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. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12: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, 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
  •