M2 -> M3 upgrade

[rjedge]

Originally Posted by marcmac

is this a virtual server? Zimbra doesn't perform well in veritual environments.

Yes. It is running in an ESX VM. It is 1 of 6 VM's (mixture of Linux and Windows) running on this ESX host. Most of our servers are now virtualized using ESX on an IBM Blade Center. We currently have 37 servers as VM's running 6 ESX hosts.

[avisser]

I have successfully upgraded the os M2 to os M3 with a few problems, but it is up and running now.

First I saw this error message (integer expression expected), which was concerning, but doesn't seem to have been a problem

Installing packages

zimbra-core..../util/modules/packages.sh: line 101: [: M3: integer expression expected
./util/modules/packages.sh: line 101: [: M2: integer expression expected
...zimbra-core-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-ldap..../util/modules/packages.sh: line 101: [: M3: integer expression expected
./util/modules/packages.sh: line 101: [: M2: integer expression expected
...zimbra-ldap-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-logger..../util/modules/packages.sh: line 101: [: M3: integer expression expected
...zimbra-logger-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-mta..../util/modules/packages.sh: line 101: [: M3: integer expression expected
./util/modules/packages.sh: line 101: [: M2: integer expression expected
...zimbra-mta-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-snmp..../util/modules/packages.sh: line 101: [: M3: integer expression expected
./util/modules/packages.sh: line 101: [: M2: integer expression expected
...zimbra-snmp-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-store..../util/modules/packages.sh: line 101: [: M3: integer expression expected
./util/modules/packages.sh: line 101: [: M2: integer expression expected
...zimbra-store-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-apache..../util/modules/packages.sh: line 101: [: M3: integer expression expected
...zimbra-apache-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done
zimbra-spell..../util/modules/packages.sh: line 101: [: M3: integer expression expected
...zimbra-spell-3.0.0_M2_740.RHEL4-20051114171614.i386.rpm...done

I didn't want to make any changes to the existing config so I typed 'a' and pressed enter. This however did not keep my existing config completely in tact.

1. TLS authentication only was checked, but should not have been
2. Antivirus was turned off
3. Spam was turned off and the kill/tag percentages reset to the default (It did remember the subject prefix.)
4. POP & IMAP clear text logins were disabled, but should not have been
5. had to modify saslauthd.conf.in just as I had to in the M1 -> M2 upgrade

zmtrainsa seems to be having issues, but I need to look deeper into that to verify if it is or isn't working.

[rhostager]

Originally Posted by marcmac

Is the logger service running?

Yes, ps -A shows:

14670 ? 00:00:00 mysqld
14671 ? 00:00:03 zmlogger
14682 ? 00:00:00 mysqld

- Rob

[marcmac]

What do you get from:
zmcontrol status
logmysqladmin status

[rhostager]

Originally Posted by marcmac

What do you get from:
zmcontrol status
logmysqladmin status

[zimbra@mail ~]$ zmcontrol status
Host mail.hostager.com
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Running
mta Running
snmp Running
spell Running
[zimbra@mail ~]$ logmysqladmin status
Uptime: 85468 Threads: 2 Questions: 138055 Slow queries: 77180 Opens: 21 Flush tables: 1 Open tables: 10 Queries per second avg: 1.615

- Rob

[marcmac]

What do you get from
zmprov gacf | grep -i loghost

Should match the hostname of the server running the logger service.

If the hostname resolves to a public IP on a FW box, can the webmail server access that box at port 7307? (Verify that zmlocalconfig logger_mysql_port matches the port in /opt/zimbra/conf/my.logger.cnf)

[rhostager]

Originally Posted by marcmac

What do you get from
zmprov gacf | grep -i loghost

Should match the hostname of the server running the logger service.

If the hostname resolves to a public IP on a FW box, can the webmail server access that box at port 7307? (Verify that zmlocalconfig logger_mysql_port matches the port in /opt/zimbra/conf/my.logger.cnf)

[zimbra@mail ~]$ zmprov gacf | grep -i loghost
zimbraLogHostname: mail.hostager.com

zmlocalconfig shows:

logger_mysql_port = 3307


my.logger.cnf contains:

[mysqld]

basedir = /opt/zimbra/logger/mysql
datadir = /opt/zimbra/logger/db/data
socket = /opt/zimbra/logger/db/mysql.sock
pid-file = /opt/zimbra/logger/db/mysql.pid
bind-address = localhost
port = 7307

skip-external-locking

log-slow-queries = /opt/zimbra/log/logger_myslow.log
long-query-time = 1
log-long-format
log-queries-not-using-indexes
log-bin

thread_cache = 10
max_connections = 10

# We do a lot of writes, query cache turns out to be not useful.
query_cache_type = 0

[mysqld_safe]

err-log = /opt/zimbra/log/logger_mysqld.log


Looks like they do not match. I did the following:

zmlocalconfig -e logger_mysql_port=7307

to fix this and restarted the server. It works now!

Thanks... You guys are great!

- Rob

FYI -- This was an M1 installation upgraded to M2 with the script and then later upgraded to M3. The Server status showed nothing from M1 on. The errors did not display until M3. With your fix the server staus now works properly with no errors.