| Welcome to the Zimbra :: Forums! | |
Welcome, if you would like to post a comment please register.
We also encourage you to explore all things Zimbra with our team and members of the community.
|
 | | 
06-10-2008, 12:56 AM
| | Special Member | |
Posts: 123
| |  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.  |
06-10-2008, 02:35 AM
| | |
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 
__________________  |
06-10-2008, 02:55 AM
| | Special Member | |
Posts: 123
| |
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
 |
06-10-2008, 03:01 AM
| | Zimbra Consultant & Moderator | |
Posts: 20,316
| |
Quote:
Originally Posted by nishith  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
|
06-10-2008, 03:03 AM
| | |
Please post a extract, look for any tables that are showing as corrupt.
__________________ |
06-10-2008, 03:03 AM
| | Special Member | |
Posts: 123
| |
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
|
06-10-2008, 03:07 AM
| | |
You can reset your MySQL password by following this Wiki article.
__________________ |
06-10-2008, 11:33 PM
| | |
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.
__________________ |
06-10-2008, 11:41 PM
| | Special Member | |
Posts: 123
| |
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..
|
06-10-2008, 11:46 PM
| | |
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
__________________ | | Thread Tools | Search this Thread | | | | | Display Modes |  Linear Mode | | Why Join? Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.   |
Bugzilla
Wiki
Source
