Logger

[jholder]

Hi all,
I know I have been a terrible burden. I have a question:

My logger won't start. From previous posts, I know that my logger password is incorrect.

I have followed logger won't start: /opt/zimbra/bin/zmlogswatchctl: line 69: kill: (5491) - No such
but it seems a little vauge to me.

Is the logger password stored in the mysql database? If so, I know I have to use the skip grant tables option.

After that, what's the command? Do I need to reset the general root password?

I know it uses
zmlocalconfig -e -f mysql_logger_root_password='password';
but I"m not quite sure how to reset it.

Thanks!
jh

[KevinH]

Your on the right track. Take the password from:

zmlocalconfig -e -f mysql_logger_root_password='<>';

Then use:

update user set password=PASSWORD('<>') where user like 'root%';
flush privileges;

To reset it.

Restart logger and hope for the best.

[jholder]

does this reset the logger root, or the root password in general (ie will it effect the mailbox?)

Here's hoping.
(By the way, I've been compliling extensive notes and will be updating the wiki with sql errors and such soon...so it's not all in vain!)

[KevinH]

If you login to the logger MySQL db then it should be root for the logger.

[jholder]

This is going to be dumb,
but baby steps...

Thats
1) start mysql without the grant tables
2) Bash# mysql
3) Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.16-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>logger
-> update user set password=PASSWORD('<>') where user like 'root%';

->flush privileges;

?

[KevinH]

Sorry I should have given the exact commands to get to the logger db.

mysql -P 7307

use zimbra;
update user set password=PASSWORD('pass') where user like 'root%';
flush privileges;

[jholder]

I know it's late.

So Here's the different permutations I've tried on whatcha gave me.
-----------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.16-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use zimbra
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password=PASSWORD('passhere') where user like 'root%';
ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist
mysql> use zimbra
Database changed
mysql> update user set password=PASSWORD('passhere') where user like 'root%';
ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist
mysql> exit
Bye
---------------
So either my table doesn't exist, or I'm doing it wrong
PS-You like family guy?

[KevinH]

zimbra.user not there. Did you start it with some odd way. Maybe try starting it WITH grant tables. I think if you disabled them then they won't be there to reset the password.

[jholder]

Same thing:
ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist

Now, this is only with mysql.server started.

Should I start Zimbra up?

[jholder]

So the use mysql worked, and it let me reset the password.

I also did a flush...restarted many times...

Here's my order of what I did.
mysql> use mysql
mysql> update user set password=PASSWORD('passhere') where user like 'root%';
flush privileges;
zmmypasswd --root passhere
zmlocalconfig -e -f mysql_logger_root_password='passhere';

I'm pretty sure I'm not smart enough to do this right. Everything works but the logger...and I want to upgrade (I'm using an old build), but I don't even want to try to upgrade w/o fixing this dang logger problem.

Am I missing a step?
---------------------------------------------------------
If I run

+ BASE=/opt/zimbra
+ SCRIPTS='logmysql.server zmlogswatchctl'
+ case "$1" in
+ STATUS=0
+ for i in '$SCRIPTS'
+ '[' logmysql.server = logmysql.server ']'
+ /opt/zimbra/bin/logmysqladmin status
+ R=1
+ '[' 1 -ne 0 ']'
+ STATUS=1
+ for i in '$SCRIPTS'
+ '[' zmlogswatchctl = logmysql.server ']'
+ /opt/zimbra/bin/zmlogswatchctl status
/opt/zimbra/bin/zmlogswatchctl: line 69: kill: (4369) - No such process
+ R=1
+ '[' 1 -ne 0 ']'
+ STATUS=1
+ exit 1

-------------------------------------------------------
If I try to start the logmysqladmin
I get
[zimbra@tusd-exch01 bin]$ logmysqladmin start
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[zimbra@tusd-exch01 bin]$ logmysql.server stop
Killing mysqld with pid 30959 ..[zimbra@tusd-exch01 bin]$ logmysql.server start
[zimbra@tusd-exch01 bin]$ Starting mysqld daemon with databases from /opt/zimbra/logger/db/data

I know this is annoying....but any help will be rewarded.