Any help on this would be appreciated.
I've been struggling with installing ZCS 8.8.8 on a RH7 server (64bit AMI, on AWS EC2).
Clean RH7 image.
Installed dnsmasq and configured.
Zimbra dnscache deselected to void port 53 conflict.
All goes cleanly with the install, but when server starts the mailbox service fails.
It looks like the chat service is not running, due to database tables not built during install.
There's no option during install to elect to NOT install chat.
zmprov gets connection errors, if I attempt to disable (presumably bc server not running)
Unless something has changed recently in install scripts, I cant imagine this has not encountered by others.
Have I stupidly overlooked something? I dont think so.
I'd LIKE to install chat to see what its like - my main mailserver is running 8.6(and prior) happily for a few years.
thanks!
regards,
--geoff
From install log:
Code: Select all
Sun Jul 8 12:55:12 2018 com_zextras_chat_open...
Sun Jul 8 12:55:12 2018 *** Running as zimbra user: /opt/zimbra/bin/zmzimletctl -l deploy zimlets/com_zextras_chat_open.zip
[] INFO: Deploying Zimlet com_zextras_chat_open in LDAP.
[] INFO: Installing Zimlet com_zextras_chat_open on this host.
[] INFO: Upgrading Zimlet com_zextras_chat_open to 11
[] INFO: Adding Zimlet com_zextras_chat_open to COS default
[] INFO: Enabling Zimlet com_zextras_chat_open
Sun Jul 8 12:55:16 2018 done.
After install:
Code: Select all
zmcontrol status
Host mail.xxxxxxxx.com
amavis Running
antispam Running
antivirus Stopped
zmclamdctl is not running
ldap Running
logger Running
mailbox Stopped
zmmailboxdctl is not running.
memcached Running
mta Running
opendkim Running
proxy Running
service webapp Stopped
zmmailboxdctl is not running.
snmp Running
spell Running
stats Running
zimbra webapp Stopped
zmmailboxdctl is not running.
zimbraAdmin webapp Stopped
zmmailboxdctl is not running.
zimlet webapp Stopped
zmmailboxdctl is not running.
zmconfigd Running
Code: Select all
..
2018-07-08 12:51:05,018 INFO [main] [] mailbox - Starting ZAL version 2.3.0 commit d96c2a7c927535618735047867c2ea1105711670
2018-07-08 12:51:05,071 INFO [main] [] mailbox - File /opt/zimbra/lib/ext/openchat/extension-path not present, using standard boot
2018-07-08 12:51:05,073 INFO [main] [] extensions - Searching ZAL extension in directory /opt/zimbra/lib/ext/openchat
2018-07-08 12:51:05,150 INFO [main] [] extensions - Initialized extension Zimbra Abstraction Layer for: openchat: org.openzal.zal.extension.ZalEntrypointImpl@com.zimbra.cs.extension.ZimbraExtensionClassLoader@75b3673
...
2018-07-08 12:51:07,951 INFO [main] [] pop - Starting Pop3Server on /0.0.0.0:7110
2018-07-08 12:51:07,981 INFO [main] [] pop - Starting Pop3SSLServer on /0.0.0.0:7995
2018-07-08 12:51:08,021 INFO [main] [] imap - Starting ImapServer on /0.0.0.0:7143
2018-07-08 12:51:08,040 INFO [main] [] imap - Starting ImapSSLServer on /0.0.0.0:7993
2018-07-08 12:51:08,086 INFO [main] [] scheduler - Loaded 0 scheduled data source tasks
2018-07-08 12:51:08,089 INFO [main] [] misc - Starting zimbraMailPurgeSleepInterval thread with 1m interval
2018-07-08 12:51:08,115 WARN [main] [] contactbackup - zimbraFeatureContactBackupFrequency is set to 0
2018-07-08 12:51:08,128 INFO [MailboxPurge] [] purge - Purge thread sleeping for 1800000ms before doing work.
2018-07-08 12:51:08,283 INFO [main] [] extensions - Post-Initializing extensions
2018-07-08 12:51:08,285 INFO [main] [] mailbox - OpenChat starting ...
2018-07-08 12:51:10,089 ERROR [main] [] extensions - ################## OpenChat cannot start:com.zextras.lib.switches.Service$ServiceStartException: Unable to preload relationships
at com.zextras.modules.chat.services.DbPreloader.start (DbPreloader.java:52)
..
Caused by: com.zextras.modules.chat.server.exceptions.ChatSqlException: Unable to execute the SQL statement: SELECT * FROM chat.RELATIONSHIP
at com.zextras.modules.chat.services.DbPreloader$RelationshipsPreloadSqlClosure.execute (DbPreloader.java:110)
..
Caused by: java.sql.SQLSyntaxErrorException: Table 'chat.RELATIONSHIP' doesn't exist
Query is:
sql : 'SELECT * FROM chat.RELATIONSHIP'
at org.mariadb.jdbc.internal.SQLExceptionMapper.get (SQLExceptionMapper.java:138)
..
2018-07-08 12:51:10,090 ERROR [main] [] extensions - Startup error in extension com.zextras.modules.chat.ChatExtension
java.lang.RuntimeException: com.zextras.lib.switches.Service$ServiceStartException: Unable to preload relationships
at com.zextras.modules.chat.ChatExtension.startup(ChatExtension.java:239)
..
This appears to build the database tables for chat, however, running it, returns a scheme version mismatch.
Code: Select all
./migrate20180301-ZimbraChat.pl
Sun Jul 8 13:40:28 2018: Schema version mismatch. Expected version 108. Version in the database is 109.