Mysql error on install

[tommygun]

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.

[jholder]

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

[tommygun]

[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

[jholder]

Can you run a
which mysql
?

[tommygun]

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

[jholder]

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

[tommygun]

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

[jholder]

okay, now
su - zimbra
which mysql

[tommygun]

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

[jholder]

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