Mailbox Stopped

jono · Post by **jono** » Tue Nov 22, 2005 6:48 pm

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 · Post by **marcmac** » Tue Nov 22, 2005 6:50 pm

zmlocalconfig | grep mysql returns what?

jono · Post by **jono** » Tue Nov 22, 2005 6:54 pm

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 · Post by **marcmac** » Tue Nov 22, 2005 7:07 pm

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

ls -ld /opt/zimbra/log

jono · Post by **jono** » Tue Nov 22, 2005 8:17 pm

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 · Post by **jono** » Tue Nov 22, 2005 8:19 pm

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 · Post by **marcmac** » Tue Nov 22, 2005 8:32 pm

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 · Post by **jono** » Tue Nov 22, 2005 8:44 pm

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 · Post by **marcmac** » Tue Nov 22, 2005 8:50 pm

++ 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 · Post by **jono** » Tue Nov 22, 2005 9:06 pm

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