Upgrade And Move ZCS

[LiMz]

Let me explain my scenario first.

One of our clients wants to re-install their Zimbra server and upgrade the O.S and ZCS as well.

Old Server : Ubuntu 6.06 LTS Server
ZCS 5.0.4_GA_2101

New Server : Ubuntu 8.04 LTS Server
ZCS 5.0.16_GA_2921

So far i have a good backup of the server and im trying to restore it to another server just as a test run.

I followed the instructions on
Moving ZCS to New Server - Zimbra :: Wiki

so anyway i put the dummy copy of zimbra onto the new server.
restore my zimbra backup
run zmfixperms
run the install.sh again.

Everything loads fine until it gets to

Verifying /opt/zimbra/conf/my.cnf
Starting mysql

At this point it just hangs and does nothing...

If i kill this install, then try start mysql manually using

root@zimbra:/opt/zimbra/bin# ./mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

i checked permissions to /opt/zimbra/db

they belong to the user zimbra on both servers...

My question is....can this upgrade be done?

If yes, what am i doing wrong?

Thanks

[phoenix]

Shutdown Zimbra then kill any remaining processes, when you've done that run the following command (as root):

zmfixperms -verbose -extended

After that finishes restart Zimbra and see what happens, post any errors you find in the log files.

[veronica]

for starting mysql better use :
mysql.server start

Also did you try resetting the mysql password

[LiMz]

Still nothing...
Heres before i run ./install.sh without the -s option

root@zimbra:/opt/zimbra/libexec# ./zmfixperms -verbose -extended
Fixing ownership and permisions on /opt/zimbra/java
Fixing ownership and permisions on /opt/zimbra/lib
Fixing ownership and permisions on /opt/zimbra/db
Fixing ownership and permisions on /opt/zimbra/cyrus-sasl
Fixing ownership and permisions on /opt/zimbra/dspam
Fixing ownership and permisions on /opt/zimbra/jetty
Fixing ownership and permisions on /opt/zimbra/ssl
Fixing ownership and permisions on /opt/zimbra/httpd
Fixing ownership and permisions on /opt/zimbra/logger/mysql
Fixing ownership and permisions on /opt/zimbra/logger/db
Fixing ownership and permisions on /opt/zimbra/mysql
Fixing ownership and permisions on /opt/zimbra/snmp
Fixing ownership and permisions on /opt/zimbra/openldap
Fixing ownership and permisions on /opt/zimbra/sleepycat
Fixing ownership and permisions on /opt/zimbra/clamav
Fixing ownership and permisions on /opt/zimbra/amavisd
Fixing ownership and permisions on /opt/zimbra/zimbramon/lib
Fixing ownership and permisions on /opt/zimbra/rrdtool
Fixing ownership and permisions on /opt/zimbra/postfix
Fixing ownership and permisions on /opt/zimbra/data/postfix
Fixing ownership of /opt/zimbra/index
Fixing ownership of /opt/zimbra/backup
Fixing ownership of /opt/zimbra/store

It gets all the way here

Setting defaults from saved config in /opt/zimbra/.saveconfig/config.save
   HOSTNAME=mail.checkout.chk
   LDAPHOST=mail.checkout.chk
   LDAPPORT=389
   SNMPTRAPHOST=mail.checkout.chk
   SMTPSOURCE=admin@checkout.chk
   SMTPDEST=admin@checkout.chk
   SNMPNOTIFY=yes
   SMTPNOTIFY=yes
   LDAPROOTPW=Rlc8WSMw8u
   LDAPZIMBRAPW=Rlc8WSMw8u
   LDAPPOSTPW=Rlc8WSMw8u
   LDAPREPPW=Rlc8WSMw8u
   LDAPAMAVISPW=Rlc8WSMw8u
   LDAPNGINXPW=
Restoring existing configuration file from /opt/zimbra/.saveconfig/config.save...done
Operations logged to /tmp/zmsetup.07152009-103940.log
Starting ldap...done.
Setting defaults...done.
Upgrading from 5.0.4_GA_2101 to 5.0.16_GA_2921
Stopping zimbra services
Verifying /opt/zimbra/conf/my.cnf
Starting mysql

Once again it just sits...
so i (Ctrl + C) the installation then do this

root@zimbra:/zc# su zimbra
zimbra@zimbra:/zc$ zmcontrol stop
zimbra@zimbra:/root$ ps aux | grep zimbra
zimbra   16655  0.0  0.2   3684  1240 pts/0    S    10:45   0:00 su zimbra
zimbra   16656  0.0  0.3   4624  1988 pts/0    S    10:45   0:00 bash
zimbra   16662  0.0  0.1   2644  1012 pts/0    R+   10:45   0:00 ps aux
zimbra   16663  0.0  0.1   3008   768 pts/0    S+   10:45   0:00 grep zimbra

i assume all is okay here and continue..

root@zimbra:/opt/zimbra/libexec# ./zmfixperms -verbose -extended
Fixing ownership and permissions on /var/log/zimbra.log
Fixing ownership and permissions on /opt/zimbra/java
Fixing ownership and permissions on /opt/zimbra/lib
Fixing ownership and permissions on /opt/zimbra/db
Fixing ownership and permissions on /opt/zimbra/cyrus-sasl
Fixing ownership and permissions on /opt/zimbra/dspam
Fixing ownership and permissions on /opt/zimbra/conf/spamassassin
Fixing ownership and permissions on /opt/zimbra/jetty
Fixing ownership and permissions on /opt/zimbra/ssl
Fixing ownership and permissions on /opt/zimbra/httpd
Fixing ownership and permissions on /opt/zimbra/logger/mysql
Fixing ownership and permissions on /opt/zimbra/logger/db
Fixing ownership and permissions on /opt/zimbra/mysql
Fixing ownership and permissions on /opt/zimbra/snmp
Fixing ownership and permissions on /opt/zimbra/openldap
Fixing ownership and permissions on /opt/zimbra/sleepycat
Fixing ownership and permissions on /opt/zimbra/clamav
Fixing ownership and permissions on /opt/zimbra/amavisd
Fixing ownership and permissions on /opt/zimbra/zimbramon/lib
Fixing ownership and permissions on /opt/zimbra/rrdtool
Fixing ownership and permissions on /opt/zimbra/conf/localconfig.xml
Fixing ownership and permissions on /opt/zimbra/postfix
Fixing ownership and permissions on /opt/zimbra/data/postfix
Fixing ownership and permissions on /opt/zimbra/conf/ldap-scm.cf
Fixing ownership and permissions on /opt/zimbra/conf/ldap-transport.cf
Fixing ownership and permissions on /opt/zimbra/conf/ldap-vad.cf
Fixing ownership and permissions on /opt/zimbra/conf/ldap-vam.cf
Fixing ownership and permissions on /opt/zimbra/conf/ldap-vmd.cf
Fixing ownership and permissions on /opt/zimbra/conf/ldap-vmm.cf
Fixing ownership of /opt/zimbra/index
Fixing ownership of /opt/zimbra/backup
Fixing ownership of /opt/zimbra/store

it seems to have done more than what it originally did
but anyway i continue

zimbra@zimbra:~/libexec$ zmcontrol start
Host mail.checkout.chk
        Starting ldap...Done.
        Starting logger...Done.
        Starting mailbox...Done.
        Starting antispam...Done.
        Starting antivirus...Done.
        Starting snmp...Done.
        Starting spell...Done.
        Starting mta...Done.
        Starting stats...Done.
zimbra@zimbra:~/libexec$ zmcontrol status
Host mail.checkout.chk
        antispam                Running
        antivirus               Running
        ldap                    Running
        logger                  Running
        mailbox                 Stopped
                mysql.server is not running.
        mta                     Running
        snmp                    Running
        spell                   Running
        stats                   Stopped

Still seems to be the same problem...

root@zimbra:/opt/zimbra/bin#./mysql.server start
Starting mysqld...done.
root@zimbra:/opt/zimbra/bin# ./mysql.server status
mysql is not running
root@zimbra:/opt/zimbra/bin#./mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

i cant access mysql.. any other way to change the password?

[LiMz]

This is my first actual zimbra installation/
please tell me which logs you would like me to post.
Thanks!

[LiMz]

After some research i found that i sould leave the installation
I left the Installation and it says

UPGRADE FAILED---EXITING

No solutions yet or anything i can try?
mysql.sock is not being created...
Please help

[veronica]

Can you show your /etc/hosts file ? Do you have entry for 127.0.0.1 ?

[LiMz]

27.0.0.1 localhost.localdomain localhost
127.0.1.1 zimbra.checkout.chk zimbra
xxx.xxx.xxx.xxx mail.checkout.chk mail

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts



the 127.0.1.1 entry is on the old server as well
the hostname for the server is zimbra


Thanks V

[LiMz]

Any Idea guys?
Ill try any ideas...
else im gonna have to dock this showboat =/

[phoenix]

Well, for a start your hosts file is incorrect.This file:

27.0.0.1 localhost.localdomain localhost
127.0.1.1 zimbra.checkout.chk zimbra
xxx.xxx.xxx.xxx mail.checkout.chk mail

should only contain the following:

127.0.0.1       localhost.localdomain   localhost
x.x.x.x       zimbra.checkout.chk     zimbra

Where x.x.x.x is your LAN IP.

Fix that problem then run the following commands on the zimbra server and post the output:

cat /etc/hosts
cat /etc/resolv.conf
dig yourdomain.com mx
dig yourdomain.com any
host `hostname`  <-- use that exact command with backtick not single quotes