[SOLVED] Issue after upgrade to 7.0 from 6.0.10

[borngunners]

Please help

zimbra@zimbra:/var/tmp/zcs-7.0.0$ zmcontrol status
Host zimbra.domain.com
        antispam                Running
        antivirus               Running
        ldap                    Running
        logger                  Running
        mailbox                 Stopped
                mysql.server is not running.
        mta                     Running
        snmp                    Running
        spell                   Running
        stats                   Stopped
        zmconfigd               Running

I also did the following as root to see what is going on
/opt/zimbra/libexec/zmdbintegrityreport
/opt/zimbra/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2) when trying to connect
command failed

[phoenix]

What errors do you see in the log files?

[borngunners]

This is what I see in the log file...

Feb 14 07:44:05 zimbra zmmailboxdmgr[19177]: status OK
Feb 14 07:46:05 zimbra zmmailboxdmgr[19593]: status requested
Feb 14 07:46:05 zimbra zmmailboxdmgr[19593]: status OK
Feb 14 07:46:27 zimbra clamd[12068]: SelfCheck: Database status OK.
Feb 14 07:48:04 zimbra zmmailboxdmgr[20004]: status requested
Feb 14 07:48:04 zimbra zmmailboxdmgr[20004]: status OK
Feb 14 07:50:01 zimbra zimbramon[20169]: 20169:info: 2011-02-14 07:50:01, QUEUE: 0 0
Feb 14 07:50:05 zimbra zmmailboxdmgr[20587]: status requested
Feb 14 07:50:05 zimbra zmmailboxdmgr[20587]: status OK

All seems to be okay but the status is not telling me that:

root@zimbra:~# su - zimbra
zimbra@zimbra:~$ zmcontrol status
Host zimbra.domain.com
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running.
mta Running
snmp Running
spell Running
stats Stopped
zmconfigd Running

[phoenix]

None of those are errors, what do you see in the mysql log files?

[borngunners]

This is what I found in the install log:

COMMAND: zmlocalconfig -s | sed -e "s/ = \(.*\)/=\'\1\'/" > /opt/zimbra/.saveconfig/config.save
COMMAND: zmcontrol shutdown
Host zimbra.domain.com
Stopping stats...Done.
Stopping mta...Done.
Stopping spell...Done.
Stopping snmp...Done.
Stopping cbpolicyd...Done.
Stopping archiving...Done.
Stopping antivirus...Done.
Stopping antispam...Done.
Stopping imapproxy...Done.
Stopping memcached...Done.
Stopping mailbox...Done.
Stopping logger...Done.
Stopping zmconfigd...Done.
Stopping ldap...Done.
COMMAND: /opt/zimbra/libexec/zmslapcat /opt/zimbra/data/ldap
Selecting previously deselected package zimbra-core.
(Reading database ... 15531 files and directories currently installed.)
Unpacking zimbra-core (from .../zimbra-core_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-core (7.0.0_GA_3077.UBUNTU8_64) ...
/var/lib/dpkg/info/zimbra-core.postinst: line 76: openssl: command not found

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Selecting previously deselected package zimbra-ldap.
(Reading database ... 25397 files and directories currently installed.)
Unpacking zimbra-ldap (from .../zimbra-ldap_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-ldap (7.0.0_GA_3077.UBUNTU8_64) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Selecting previously deselected package zimbra-logger.
(Reading database ... 25925 files and directories currently installed.)
Unpacking zimbra-logger (from .../zimbra-logger_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-logger (7.0.0_GA_3077.UBUNTU8_64) ...

Selecting previously deselected package zimbra-mta.
(Reading database ... 25926 files and directories currently installed.)
Unpacking zimbra-mta (from .../zimbra-mta_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-mta (7.0.0_GA_3077.UBUNTU8_64) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
Selecting previously deselected package zimbra-snmp.
(Reading database ... 31757 files and directories currently installed.)
Unpacking zimbra-snmp (from .../zimbra-snmp_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-snmp (7.0.0_GA_3077.UBUNTU8_64) ...

Selecting previously deselected package zimbra-store.
(Reading database ... 32306 files and directories currently installed.)
Unpacking zimbra-store (from .../zimbra-store_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
ln -s /opt/zimbra/jetty-6.1.22.z6 /opt/zimbra/jetty
Relinking mailboxd to /opt/zimbra/jetty-6.1.22.z6

Selecting previously deselected package zimbra-apache.
(Reading database ... 63682 files and directories currently installed.)
Unpacking zimbra-apache (from .../zimbra-apache_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-apache (7.0.0_GA_3077.UBUNTU8_64) ...

Selecting previously deselected package zimbra-spell.
(Reading database ... 64931 files and directories currently installed.)
Unpacking zimbra-spell (from .../zimbra-spell_7.0.0_GA_3077.UBUNTU8_64_amd64.deb) ...
Setting up zimbra-spell (7.0.0_GA_3077.UBUNTU8_64) ...

[borngunners]

This is what I found in /opt/zimbra/log/mysql_error.log file:

110214 05:57:11 mysqld started
110214 5:57:12 InnoDB: Started; log sequence number 1 1362810784
110214 5:57:12 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.90-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution
110214 5:58:32 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown

110214 5:58:32 InnoDB: Starting shutdown...
110214 5:58:34 InnoDB: Shutdown completed; log sequence number 1 1362810824
110214 5:58:34 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 05:58:34 mysqld ended

110214 06:18:30 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
110214 6:18:30 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file''
110214 6:18:30 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
/opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110214 6:18:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110214 6:18:30 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'innodb_buffer_pool_size=633343180'
110214 6:18:30 [ERROR] Aborting

110214 6:18:30 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 06:18:30 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
110214 06:29:02 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
110214 6:29:02 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file''
110214 6:29:02 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
/opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110214 6:29:02 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110214 6:29:02 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'innodb_buffer_pool_size=633343180'
110214 6:29:02 [ERROR] Aborting

110214 6:29:02 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 06:29:02 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
110214 06:36:05 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
110214 6:36:05 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file''
110214 6:36:05 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
/opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110214 6:36:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110214 6:36:05 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'innodb_buffer_pool_size=633343180'
110214 6:36:05 [ERROR] Aborting

110214 6:36:05 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 06:36:05 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
110214 06:45:12 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
110214 6:45:12 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file''
110214 6:45:12 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
/opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110214 6:45:12 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110214 6:45:12 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'innodb_buffer_pool_size=633343180'
110214 6:45:12 [ERROR] Aborting

110214 6:45:12 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 06:45:12 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
110214 07:14:07 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
110214 7:14:08 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file''
110214 7:14:08 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
/opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110214 7:14:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110214 7:14:08 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'innodb_buffer_pool_size=633343180'
110214 7:14:08 [ERROR] Aborting

110214 7:14:08 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 07:14:08 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended
110214 07:58:43 mysqld_safe Starting mysqld daemon with databases from /opt/zimbra/db/data
110214 7:58:43 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file''
110214 7:58:43 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
/opt/zimbra/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
110214 7:58:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110214 7:58:43 [ERROR] /opt/zimbra/mysql/libexec/mysqld: unknown variable 'innodb_buffer_pool_size=633343180'
110214 7:58:43 [ERROR] Aborting

110214 7:58:43 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

110214 07:58:43 mysqld_safe mysqld from pid file /opt/zimbra/db/mysql.pid ended

[borngunners]

I have successfully installed. I can send email to the outside, but can't receive emails back from teh outside. This is what I get:

Feb 14 09:02:29 zimbra postfix/smtpd[28856]: NOQUEUE: reject: RCPT from nm29-vm0.bullet.mail.sp2.yahoo.com[98.139.91.236]: 554 5.7.1 <akargbo@domain.com>: Relay access denied; from=<albsallu@yahoo.com> to=<akargbo@domain.com> proto=SMTP helo=<nm29-vm0.bullet.mail.sp2.yahoo.com>

[phoenix]

According to your install log the following is missing:

/var/lib/dpkg/info/zimbra-core.postinst: line 76: openssl: command not found

Is it installed?

[phoenix]

Originally Posted by borngunners

I have successfully installed. I can send email to the outside, but can't receive emails back from teh outside. This is what I get:

Have you also read this thread: http://www.zimbra.com/forums/install...ual-hosts.html

I'll remove your other post as it's a duplicate of this one on being unable to send email.

[borngunners]

I reinstalled it again since my last post on the logs. After installing, everything was successful except recieving emails from outside. This is what I am getting:

Feb 14 09:02:29 zimbra postfix/smtpd[28856]: NOQUEUE: reject: RCPT from nm29-vm0.bullet.mail.sp2.yahoo.com[98.139.91.236]: 554 5.7.1 <akargbo@domain.com>: Relay access denied; from=<albsallu@yahoo.com> to=<akargbo@domain.com> proto=SMTP helo=<nm29-vm0.bullet.mail.sp2.yahoo.com>

This sound more like my email server is rejecting everything coming in not just to this email account but to literally everything after looking at the email log.