Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: Mailbox Stopped

  1. #1
    Join Date
    Nov 2005
    Posts
    18
    Rep Power
    10

    Default Mailbox Stopped

    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.

  2. #2
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default mysql

    zmlocalconfig | grep mysql returns what?

  3. #3
    Join Date
    Nov 2005
    Posts
    18
    Rep Power
    10

    Default zmlocalconfig | grep mysql

    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

  4. #4
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default log

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

  5. #5
    Join Date
    Nov 2005
    Posts
    18
    Rep Power
    10

    Default the permissions

    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

  6. #6
    Join Date
    Nov 2005
    Posts
    18
    Rep Power
    10

    Default mysqld.log

    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

  7. #7
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default Ram?

    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

  8. #8
    Join Date
    Nov 2005
    Posts
    18
    Rep Power
    10

    Default Ram size

    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

  9. #9
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default THis is the offender

    ++ 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...

  10. #10
    Join Date
    Nov 2005
    Posts
    18
    Rep Power
    10

    Default

    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

Similar Threads

  1. Replies: 210
    Last Post: 01-17-2012, 01:19 AM
  2. mailbox stopped
    By rene.metaal in forum Installation
    Replies: 10
    Last Post: 06-20-2008, 06:15 AM
  3. Mailbox stopped
    By Phantasmagoria in forum Administrators
    Replies: 1
    Last Post: 01-05-2007, 10:50 AM
  4. Upgrade Trouble woooo
    By RobertW in forum Installation
    Replies: 3
    Last Post: 06-15-2006, 06:24 PM
  5. Tomcat hanging
    By Morg0 in forum Administrators
    Replies: 42
    Last Post: 04-19-2006, 09:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •