Mailbox Stopped

[jono]

I seem to have hit another roadblock...

As the zimbra user:

zmcontrol start
Host XXXXXXXXXX
Starting ldap...Done.
Starting antispam...Done.
Starting antivirus...Done.
Starting logger...Done.
Starting mailbox...Done.
Starting mta...Done.
Starting snmp...Done.
Starting spell...Done.



zmcontrol status
Host XXXXXXXXXX
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mta Running
snmp Running
spell Running


So I did some digging and tried starting the mysql.server directly:

202:/opt/zimbra/mysql/bin zimbra$ mysql.server start
202:/opt/zimbra/mysql/bin zimbra$ chown: /opt/zimbra/log/mysqld.log: Operation not permitted
Starting mysqld daemon with databases from /opt/zimbra/db/data
STOPPING server from pid file /opt/zimbra/db/mysql.pid
051123 13:47:31 mysqld ended

I changed permissions (chown and chmod) on the files suggested and still no joy.

[marcmac]

zmlocalconfig | grep mysql returns what?

[jono]

202:/opt/zimbra/mysql/bin zimbra$ zmlocalconfig | grep mysql
logger_mysql_bind_address = localhost
logger_mysql_data_directory = /opt/zimbra/logger/db/data
logger_mysql_directory = /opt/zimbra/logger/mysql
logger_mysql_mycnf = /opt/zimbra/conf/my.logger.cnf
logger_mysql_pidfile = /opt/zimbra/logger/db/mysql.pid
logger_mysql_port = 7307
logger_mysql_socket = /opt/zimbra/logger/db/mysql.sock
mysql_bind_address = localhost
mysql_data_directory = /opt/zimbra/db/data
mysql_directory = /opt/zimbra/mysql
mysql_innodb_log_buffer_size = 8388608
mysql_innodb_log_file_size = 104857600
mysql_logger_root_password = *
mysql_memory_percent = 40
mysql_mycnf = /opt/zimbra/conf/my.cnf
mysql_pidfile = /opt/zimbra/db/mysql.pid
mysql_port = 7306
mysql_read_buffer_size = 1048576
mysql_root_password = *
mysql_socket = /opt/zimbra/db/mysql.sock
mysql_sort_buffer_size = 1048576
mysql_table_cache = 500
zimbra_logger_mysql_password = *
zimbra_mysql_connector_maxActive = 10
zimbra_mysql_password = *
zimbra_mysql_user = zimbra

[marcmac]

ls -l /opt/zimbra/log/mysqld.log
ls -ld /opt/zimbra/log

[jono]

202:/Users/jono zimbra$ ls -l /opt/zimbra/log/mysqld.log
-rw-rw---- 1 zimbra zimbra 14184 Nov 23 14:01 /opt/zimbra/log/mysqld.log

202:/Users/jono zimbra$ ls -ld /opt/zimbra/log
drwxr-xr-x 23 zimbra zimbra 782 Nov 23 15:10 /opt/zimbra/log

[jono]

below is the last 20 lines of the mysqld.log if that will help

202:/Users/jono zimbra$ tail -f -n 20 /opt/zimbra/log/mysqld.log

051123 14:01:54 mysqld started
051123 14:01:54 [Warning] Setting lower_case_table_names=2 because file system for /opt/zimbra/db/data/ is case insensitive
051123 14:01:55 [Warning] One can only use the --user switch if running as root

051123 14:01:55 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
051123 14:01:55 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 30960.
InnoDB: Doing recovery: scanned up to log sequence number 0 30960
051123 14:01:56 InnoDB: Flushing modified pages from the buffer pool...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Cannot create doublewrite buffer: you must
InnoDB: increase your buffer pool size.
InnoDB: Cannot continue operation.
051123 14:01:56 mysqld ended

[marcmac]

You don't have much RAM, do you?

We generate /opt/zimbra/conf/my.cnf with /opt/zimbra/bin/zmmycnf, which computes (or attempts to) the total memory on the system.


What does this return?

sysctl hw.memsize

Also, what's the output of
sh -x bin/zmmycnf

[jono]

That server has 2Gb RAM installed, surely you can't tell me that's not enough for a base install with no users set up?

hw.memsize: 2147483648

I chopped chunks out of this so to remain relevant

++ export logger_mysql_bind_address=localhost
++ logger_mysql_bind_address=localhost
++ export logger_mysql_data_directory=/opt/zimbra/logger/db/data
++ logger_mysql_data_directory=/opt/zimbra/logger/db/data
++ export logger_mysql_directory=/opt/zimbra/logger/mysql
++ logger_mysql_directory=/opt/zimbra/logger/mysql
++ export logger_mysql_mycnf=/opt/zimbra/conf/my.logger.cnf
++ logger_mysql_mycnf=/opt/zimbra/conf/my.logger.cnf
++ export logger_mysql_pidfile=/opt/zimbra/logger/db/mysql.pid
++ logger_mysql_pidfile=/opt/zimbra/logger/db/mysql.pid
++ export logger_mysql_port=7307
++ logger_mysql_port=7307
++ export logger_mysql_socket=/opt/zimbra/logger/db/mysql.sock
++ logger_mysql_socket=/opt/zimbra/logger/db/mysql.sock
++ export mysql_bind_address=localhost
++ mysql_bind_address=localhost
++ export mysql_data_directory=/opt/zimbra/db/data
++ mysql_data_directory=/opt/zimbra/db/data
++ export mysql_directory=/opt/zimbra/mysql
++ mysql_directory=/opt/zimbra/mysql
++ export mysql_innodb_log_buffer_size=8388608
++ mysql_innodb_log_buffer_size=8388608
++ export mysql_innodb_log_file_size=104857600
++ mysql_innodb_log_file_size=104857600
++ export mysql_logger_root_password=XXXXremovedXXXX
++ mysql_logger_root_password=XXXXremovedXXXX
++ export mysql_memory_percent=40
++ mysql_memory_percent=40
++ export mysql_mycnf=/opt/zimbra/conf/my.cnf
++ mysql_mycnf=/opt/zimbra/conf/my.cnf
++ export mysql_pidfile=/opt/zimbra/db/mysql.pid
++ mysql_pidfile=/opt/zimbra/db/mysql.pid
++ export mysql_port=7306
++ mysql_port=7306
++ export mysql_read_buffer_size=1048576
++ mysql_read_buffer_size=1048576
++ export mysql_root_password=XXXXremovedXXXX
++ mysql_root_password=XXXXremovedXXXX
++ export mysql_socket=/opt/zimbra/db/mysql.sock
++ mysql_socket=/opt/zimbra/db/mysql.sock
++ export mysql_sort_buffer_size=1048576
++ mysql_sort_buffer_size=1048576
++ export mysql_table_cache=500
++ mysql_table_cache=500
++ export smtp_destination=XXXXremovedXXXX
++ smtp_destination=XXXXremovedXXXX
++ export smtp_notify=yes
++ smtp_notify=yes
++ export smtp_source=aXXXXremovedXXXX
++ smtp_source=XXXXremovedXXXX
++ export snmp_notify=yes
++ snmp_notify=yes
++ export snmp_trap_host=XXXXremovedXXXX
++ snmp_trap_host=XXXXremovedXXXX
++ export ssl_allow_untrusted_certs=TRUE
++ ssl_allow_untrusted_certs=TRUE
++ export stats_img_folder=/opt/zimbra/zimbramon/rrdtool/work
++ stats_img_folder=/opt/zimbra/zimbramon/rrdtool/work
++ export tomcat_directory=/opt/zimbra/tomcat
++ tomcat_directory=/opt/zimbra/tomcat
++ export tomcat_java_heap_memory_percent=30
++ tomcat_java_heap_memory_percent=30
++ export tomcat_java_home=/usr
++ tomcat_java_home=/usr
++ export 'tomcat_java_options=-client -XX:NewRatio=2'
++ tomcat_java_options=-client -XX:NewRatio=2
++ export tomcat_keystore=/opt/zimbra/tomcat/conf/keystore
++ tomcat_keystore=/opt/zimbra/tomcat/conf/keystore
++ export tomcat_pidfile=/opt/zimbra/log/tomcat.pid
++ tomcat_pidfile=/opt/zimbra/log/tomcat.pid
++ export zimbra_db_directory=/opt/zimbra/db
++ zimbra_db_directory=/opt/zimbra/db
++ export zimbra_extension_directory=/opt/zimbra/lib/ext
++ zimbra_extension_directory=/opt/zimbra/lib/ext
++ export zimbra_gid=502
++ zimbra_gid=502
++ export zimbra_home=/opt/zimbra
++ zimbra_home=/opt/zimbra
++ export zimbra_index_directory=/opt/zimbra/index
++ zimbra_index_directory=/opt/zimbra/index
++ export zimbra_index_idle_flush_time=600
++ zimbra_index_idle_flush_time=600
++ export zimbra_index_lru_size=100
++ zimbra_index_lru_size=100
++ export zimbra_index_max_uncommitted_operations=200
++ zimbra_index_max_uncommitted_operations=200
++ export zimbra_java_home=/usr
++ zimbra_java_home=/usr
++ export zimbra_ldap_password=XXXXremovedXXXX
++ zimbra_ldap_password=XXXXremovedXXXX
++ export zimbra_ldap_userdn=uid=zimbra,cn=admins,cn=zimbra
++ zimbra_ldap_userdn=uid=zimbra,cn=admins,cn=zimbra
++ export zimbra_log4j_properties=/opt/zimbra/conf/log4j.properties
++ zimbra_log4j_properties=/opt/zimbra/conf/log4j.properties
++ export zimbra_log_directory=/opt/zimbra/log
++ zimbra_log_directory=/opt/zimbra/log
++ export zimbra_logger_mysql_password=XXXXremovedXXXX
++ zimbra_logger_mysql_password=XXXXremovedXXXX
++ export zimbra_mysql_connector_maxActive=10
++ zimbra_mysql_connector_maxActive=10
++ export zimbra_mysql_password=XXXXremovedXXXX
++ zimbra_mysql_password=XXXXremovedXXXX
++ export zimbra_mysql_user=zimbra
++ zimbra_mysql_user=zimbra
++ export zimbra_server_hostname=XXXXremovedXXXX
++ zimbra_server_hostname=XXXXremovedXXXX
++ export zimbra_store_directory=/opt/zimbra/store
++ zimbra_store_directory=/opt/zimbra/store
++ export zimbra_uid=502
++ zimbra_uid=502
++ export zimbra_user=zimbra
++ zimbra_user=zimbra
+ export zmsetvars=true
+ zmsetvars=true
++ /opt/zimbra/bin/get_plat_tag.sh
+ platform=MACOSX
+ '[' xMACOSX = xMACOSX ']'
++ nvram -p
++ awk '/^ram-size/ {print $2}'
+ memhex=-2147483648
++ printf %d -2147483648
+ mem=-2147483648
++ expr -2147483648 / 1024
+ memkb=-2097152
+ (( mymem=memkb * 1024 * mysql_memory_percent / 100 ))
+ (( computed_innodb_buffer_pool_size = mymem * 75 / 100 ))
+ (( non_buffer_pool_memory = mymem - computed_innodb_buffer_pool_size ))
+ (( per_connection_memory = 2097152 + mysql_sort_buffer_size + mysql_read_buffer_size + mysql_innodb_log_buffer_size ))
+ (( computed_max_connections = non_buffer_pool_memory / per_connection_memory ))
+ '[' -17 -lt 10 ']'
+ computed_max_connections=10
+ (( mysql_read_buffer_size = non_buffer_pool_memory / computed_max_connections * 1 / 10 ))
+ (( mysql_sort_buffer_size = non_buffer_pool_memory / computed_max_connections * 1 / 10 ))
+ (( mysql_innodb_log_buffer_size = non_buffer_pool_memory / computed_max_connections * 8 / 10 ))
+ /opt/zimbra/bin/zmlocalconfig -e zimbra_mysql_connector_maxActive=10
+ (( computed_max_connections = computed_max_connections + 4 ))
+ cat

[mysqld]

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

skip-external-locking

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

thread_cache = 14
max_connections = 14

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

sort_buffer_size = -2147483
read_buffer_size = -2147483

# Increase the size of the table cache, since each mailbox has its
# own set of tables
table_cache = 500

innodb_buffer_pool_size = -644245094
innodb_log_file_size = 104857600
innodb_log_buffer_size = -17179868
innodb_file_per_table

[mysqld_safe]

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

[marcmac]

++ nvram -p
++ awk '/^ram-size/ {print $2}'
+ memhex=-2147483648
++ printf %d -2147483648
+ mem=-2147483648
++ expr -2147483648 / 1024
+ memkb=-2097152

That's very strange - on every other mac I've tried, I get a positive hex value here - you've returned a negative integer.

Edit this script, and replace
mem=`printf "%d" $memhex`
with
mem=2147483647

THen rerun zmmycnf and start mysql again...

[jono]

OK, did that, mysql.server start now works... however on status the zmcontrol still says mailbox is stopped.

202:/opt/zimbra/libexec zimbra$ mysql.server start
202:/opt/zimbra/libexec zimbra$ Starting mysqld daemon with databases from /opt/zimbra/db/data

202:/opt/zimbra/libexec zimbra$ zmcontrol start
Host XXXreplacedXXX
Starting ldap...Done.
Starting antispam...Done.
Starting antivirus...Done.
Starting logger...Done.
Starting mailbox...Done.
Starting mta...Done.
Starting snmp...Done.
Starting spell...Done.
202:/opt/zimbra/libexec zimbra$ zmcontrol status
Host XXXreplacedXXX
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mta Running
snmp Running
spell Running