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

Thread: logmysql login failed.

  1. #1
    nishith's Avatar
    nishith is offline Special Member
    Join Date
    Jun 2008
    Location
    india
    Posts
    125
    Rep Power
    7

    Default logmysql login failed.

    I m using zcs 5.0.5 open source edition.

    I am having problems using Mysql.logger & logmysql.server services.

    So,i was trying to login into mysql through "logmysql" command. But,the error is :-

    ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

    Please tell me what to do.

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Does it work if you specify the password from the local config ?
    Code:
    su - zimbra
    zmlocalconfig -s | grep mysql
    You should also check in /opt/zimbra/logger/db/data/_zmhostname_.err for any error messages.

    Also, http://www.zimbra.com/forums/announc...r-profile.html please

  3. #3
    nishith's Avatar
    nishith is offline Special Member
    Join Date
    Jun 2008
    Location
    india
    Posts
    125
    Rep Power
    7

    Default

    Dear Sir,

    This is the result of you zimbra server.The command is :
    zmlocalconfig -s| grep mysql

    The output is :-

    logger_mysql_bind_address = localhost
    logger_mysql_data_directory = ${zimbra_home}/logger/db/data
    logger_mysql_directory = ${zimbra_home}/logger/mysql
    logger_mysql_mycnf = ${zimbra_home}/conf/my.logger.cnf
    logger_mysql_pidfile = ${zimbra_home}/logger/db/mysql.pid
    logger_mysql_port = 7307
    logger_mysql_socket = ${zimbra_home}/logger/db/mysql.sock
    mysql_bind_address = localhost
    mysql_data_directory = ${zimbra_db_directory}/data
    mysql_directory = ${zimbra_home}/mysql
    mysql_innodb_log_buffer_size = 8388608
    mysql_innodb_log_file_size = 104857600
    mysql_logger_root_password = Stealth
    mysql_memory_percent = 48
    mysql_mycnf = ${zimbra_home}/conf/my.cnf
    mysql_pidfile = ${zimbra_db_directory}/mysql.pid
    mysql_port = 7306
    mysql_read_buffer_size = 1048576
    mysql_root_password = 7tMyy6RyJH3MXYD7DE6lX8AIi
    mysql_socket = ${zimbra_db_directory}/mysql.sock
    mysql_sort_buffer_size = 1048576
    mysql_table_cache = 500
    zimbra_logger_mysql_password = LCDEG7vI11eiFx7J7byLiwaJGQydP
    zimbra_mysql_connector_maxActive = 100
    zimbra_mysql_password = lP_vr_Pw7ADHlN8abGhkwbQNu.3UXT
    zimbra_mysql_user = zimbra

    My "/opt/zimbra/logger/db/data/_zmhostname_.err" file is too big.So,can you provide me your mail address,so that i can send you my server.err file.

    Below is my webmail.err file.


    logger_mysql_bind_address = localhost
    logger_mysql_data_directory = ${zimbra_home}/logger/db/data
    logger_mysql_directory = ${zimbra_home}/logger/mysql
    logger_mysql_mycnf = ${zimbra_home}/conf/my.logger.cnf
    logger_mysql_pidfile = ${zimbra_home}/logger/db/mysql.pid
    logger_mysql_port = 7307
    logger_mysql_socket = ${zimbra_home}/logger/db/mysql.sock
    mysql_bind_address = localhost
    mysql_data_directory = ${zimbra_db_directory}/data
    mysql_directory = ${zimbra_home}/mysql
    mysql_innodb_log_buffer_size = 8388608
    mysql_innodb_log_file_size = 104857600
    mysql_logger_root_password = Stealth
    mysql_memory_percent = 48
    mysql_mycnf = ${zimbra_home}/conf/my.cnf
    mysql_pidfile = ${zimbra_db_directory}/mysql.pid
    mysql_port = 7306
    mysql_read_buffer_size = 1048576
    mysql_root_password = 7tMyy6RyJH3MXYD7DE6lX8AIi
    mysql_socket = ${zimbra_db_directory}/mysql.sock
    mysql_sort_buffer_size = 1048576
    mysql_table_cache = 500
    zimbra_logger_mysql_password = LCDEG7vI11eiFx7J7byLiwaJGQydP
    zimbra_mysql_connector_maxActive = 100
    zimbra_mysql_password = lP_vr_Pw7ADHlN8abGhkwbQNu.3UXT
    zimbra_mysql_user = zimbra
    [zimbra@webmail ~]$
    [zimbra@webmail ~]$ cd /opt/zimbra/
    [zimbra@webmail ~]$ cd logger/
    [zimbra@webmail logger]$ cd db/data/
    [zimbra@webmail data]$ ls
    ib_logfile0 ib_logfile1 ibdata1 mysql test webmail.err zimbra_logger
    [zimbra@webmail data]$ vim webmail.err
    [zimbra@webmail data]$ vim webmail.err
    Version: '5.0.51a-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
    080610 11:32:09 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

    080610 11:32:09 InnoDB: Starting shutdown...
    080610 11:32:09 InnoDB: Shutdown completed; log sequence number 0 43655
    080610 11:32:09 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

    080610 11:32:09 mysqld ended

    080610 11:32:10 mysqld started
    080610 11:32:10 InnoDB: Started; log sequence number 0 43655
    080610 11:32:10 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
    080610 11:40:53 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

    080610 11:40:53 InnoDB: Starting shutdown...
    080610 11:40:55 InnoDB: Shutdown completed; log sequence number 0 43655
    080610 11:40:55 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

    080610 11:40:55 mysqld ended

    080610 11:41:10 mysqld started
    080610 11:41:10 InnoDB: Started; log sequence number 0 43655
    080610 11:41:10 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
    A mysqld process already exists at Tue Jun 10 11:41:35 IST 2008
    080610 11:43:00 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

    080610 11:43:00 InnoDB: Starting shutdown...
    080610 11:43:00 InnoDB: Shutdown completed; log sequence number 0 43655
    080610 11:43:00 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

    080610 11:43:00 mysqld ended

    080610 11:43:25 mysqld started
    080610 11:43:25 InnoDB: Started; log sequence number 0 43655
    080610 11:43:25 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
    A mysqld process already exists at Tue Jun 10 12:47:02 IST 2008
    080610 12:49:04 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown

    080610 12:49:04 InnoDB: Starting shutdown...
    080610 12:49:06 InnoDB: Shutdown completed; log sequence number 0 43655
    080610 12:49:06 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

    080610 12:49:06 mysqld ended

    080610 12:49:12 mysqld started
    080610 12:49:12 InnoDB: Started; log sequence number 0 43655
    080610 12:49:12 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,491
    Rep Power
    56

    Default

    Quote Originally Posted by nishith View Post
    My "/opt/zimbra/logger/db/data/_zmhostname_.err" file is too big.So,can you provide me your mail address,so that i can send you my server.err file.
    [B]
    We don't need to see the whole file, trim the unwanted bits of the log i.e. just attach the last relevant part of the error messages to this thread.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Please post a extract, look for any tables that are showing as corrupt.

  6. #6
    nishith's Avatar
    nishith is offline Special Member
    Join Date
    Jun 2008
    Location
    india
    Posts
    125
    Rep Power
    7

    Default

    Dear Sir,

    Below is the recent log contents of webmail.err file. I didn't get any errors in this file. So,please you tell me where to start.

    Code:
    080610 11:30:53  mysqld started
    080610 11:30:53  InnoDB: Started; log sequence number 0 43655
    080610 11:30:53 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
    080610 11:32:09 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown
    
    080610 11:32:09  InnoDB: Starting shutdown...
    080610 11:32:09  InnoDB: Shutdown completed; log sequence number 0 43655
    080610 11:32:09 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
    
    080610 11:32:09  mysqld ended
    
    080610 11:32:10  mysqld started
    080610 11:32:10  InnoDB: Started; log sequence number 0 43655
    080610 11:32:10 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
    080610 11:40:53 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown
    
    080610 11:40:53  InnoDB: Starting shutdown...
    080610 11:40:55  InnoDB: Shutdown completed; log sequence number 0 43655
    080610 11:40:55 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
    
    080610 11:40:55  mysqld ended
    
    080610 11:41:10  mysqld started
    080610 11:41:10  InnoDB: Started; log sequence number 0 43655
    080610 11:41:10 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
    A mysqld process already exists at  Tue Jun 10 11:41:35 IST 2008
    080610 11:43:00 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown
    
    080610 11:43:00  InnoDB: Starting shutdown...
    080610 11:43:00  InnoDB: Shutdown completed; log sequence number 0 43655
    080610 11:43:00 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
    
    080610 11:43:00  mysqld ended
    
    080610 11:43:25  mysqld started
    080610 11:43:25  InnoDB: Started; log sequence number 0 43655
    080610 11:43:25 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
    A mysqld process already exists at  Tue Jun 10 12:47:02 IST 2008
    080610 12:49:04 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Normal shutdown
    
    080610 12:49:04  InnoDB: Starting shutdown...
    080610 12:49:06  InnoDB: Shutdown completed; log sequence number 0 43655
    080610 12:49:06 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
    
    080610 12:49:06  mysqld ended
    
    080610 12:49:12  mysqld started
    080610 12:49:12  InnoDB: Started; log sequence number 0 43655
    080610 12:49:12 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.51a-log'  socket: '/opt/zimbra/logger/db/mysql.sock'  port: 7307  Source distribution
    Last edited by phoenix; 06-10-2008 at 03:25 AM. Reason: format

  7. #7
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    You can reset your MySQL password by following this Wiki article.

  8. #8
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    nishith please stop creating new threads on the same subject matter

    Please report the following
    Code:
    su - zimbra
    zmcontrol shutdown
    ps -ef | grep mysql
    I can see in your logfile that it appears another instance of MySQL is running on the server. If it is please shut it down and disable it, and then restart ZCS.

  9. #9
    nishith's Avatar
    nishith is offline Special Member
    Join Date
    Jun 2008
    Location
    india
    Posts
    125
    Rep Power
    7

    Default

    Dear Sir,

    This is my result of your command.

    ps -ef | grep mysql
    zimbra 31942 31512 0 12:05 pts/2 00:00:00 grep mysql

    Previously, I got a wiki page to reset "mysql, ldap & logger passwords." To reset the password, it's related service must be in ON position. But,In my case, logmysql.server & mysql.server both service are not working. Then, How should i reset the password?

    Right Now,This is my error regarding "zmcontrol status" command.

    Host webmail.renovau.net
    antispam Running
    antivirus Running
    imapproxy Running
    ldap Running
    logger Stopped
    logmysql.server is not running
    mailbox Stopped
    mysql.server is not running
    mta Running
    snmp Running
    spell Running
    stats Running



    What to do?
    Last edited by nishith; 06-10-2008 at 11:48 PM.

  10. #10
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Please post to check your DNS setup
    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig webmail.renovau.net 
    dig renovau.net mx
    host `hostname` <- note backticks and not double quotes

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Zimbra logwatch.
    By nishith in forum Administrators
    Replies: 5
    Last Post: 06-10-2009, 04:42 PM
  2. upgrading from 5.0.4 to 5.0.5 opensource
    By smoke in forum Installation
    Replies: 4
    Last Post: 10-19-2008, 10:38 AM
  3. Problem with Mail Server - Need help!
    By joeleo in forum Installation
    Replies: 2
    Last Post: 03-04-2008, 12:03 PM
  4. My Zimbra server down ... please help :)
    By frankb in forum Administrators
    Replies: 2
    Last Post: 12-12-2007, 11:29 AM
  5. Lotus migration
    By babou in forum Migration
    Replies: 15
    Last Post: 03-05-2007, 10:33 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
  •