Resetting LDAP & MySQL Passwords: Difference between revisions

No edit summary
Line 7: Line 7:
Try running:
Try running:


  >su zimbra
  > su zimbra


  >zmcontrol stop
  > zmcontrol stop


Just to be safe, you can make sure that all Zimbra services are stopped:
Just to be safe, you can make sure that all Zimbra services are stopped:


  >ps auxww | grep zimbra
  > ps auxww | grep zimbra


  >ps auxww | grep slapd
  > ps auxww | grep slapd




Line 24: Line 24:
First the root(note: these are run as user zimbra)
First the root(note: these are run as user zimbra)


  >zmldappasswd --root '''newpass'''
  > zmldappasswd --root '''newpass'''


Next the zimbra:
Next the zimbra:


  >zmldappasswd '''newpass'''
  > zmldappasswd '''newpass'''


Make sure you use the same password for both!
Make sure you use the same password for both!
== Resetting the Logger Password ==
'''In the event you have lost your logger password, or it has otherwise become out of sync after an upgrade, you can reset it. Keep in mind that the logger is not a required component to have running.'''
First, we need to make sure that Zimbra is stopped.
Try running:
>su zimbra
>zmcontrol stop
Just to be safe, you can make sure that all Zimbra services are stopped:
>ps auxww | grep zimbra
>ps auxww | grep mysql
Kill any left over processes.
Now, we can reset the passwords:
'''root logger account'''<br>
For the root mysql logger account, you need to start the mysql logger instance with the --skip-grant-tables option.  As root, modify the /opt/zimbra/bin/logmysql.server file:
''Change:''
<code>
'start') <br>
<nowiki>#--defaults-file must be first argument</nowiki> <br>
cd ${mysql_directory}; \ <br>
${mysql_directory}/bin/mysqld_safe \ <br>
--defaults-file=${mysql_mycnf} \ <br>
--ledir=${mysql_directory}/bin & <br>
;; <br>
</code>
''To:''
<code>
'start') <br>
<nowiki># --defaults-file must be first argument</nowiki> <br>
cd ${mysql_directory}; \ <br>
${mysql_directory}/bin/mysqld_safe \ <br>
--defaults-file=${mysql_mycnf} \ <br>
<b>--skip-grant-tables \ </b><br>
--ledir=${mysql_directory}/bin & <br>
;;<br>
</code>
<b>NOTE: type carefully or mysql may not start due to syntax errors</b>
Save the file & start the server as the zimbra user:
>su - zimbra
>logmysql.server start
Use the mysql command to connect to the logger database:
>logmysql mysql -D zimbra_logger -P 7307
If your logger database is running on a different port, change it via the -P parameter.  This information is available in the /opt/zimbra/conf/my.logger.cnf file.
Execute the password change:
><code>>update user set password=PASSWORD('newpasswd') where user='root';</code>
>flush privileges;
>(quit or ctrl+d)
Changing "newpasswd" with your desired root password.
Now make sure that the new password you have selected matches the value of mysql_logger_root_password:
> zmlocalconfig -s -m nokey mysql_logger_root_password
If it doesn't, adjust the mysql_logger_root_password parameter in /opt/zimbra/conf/localconfig.xml
Once the passwords match, we must clean up.  As the zimbra user, shutdown the logmysql service:
> logmysql.server stop
Now, as root, edit the logmysql.server and remove the previously added --skip-grant-tables option.
After that, start the service:
> logmysql.server start
And your set!
'''zimbra logger account'''
For the zimbra logger user, we can adjust the password via the zmmylogpasswd command (as zimbra):
  >zmmylogpasswd newpasswd
Of course changing "newpasswd" with your desired password.


== Resetting Mailbox Database Passwords  ==
== Resetting Mailbox Database Passwords  ==
Line 142: Line 44:


== Resetting Logger Database Passwords  ==
== Resetting Logger Database Passwords  ==
'''root account''
'''In the event you have lost your logger password, or it has otherwise become out of sync after an upgrade, you can reset it. Keep in mind that the logger is not a required component to have running.'''
 
'''root account'''


Set ''newpassword'' to your desired password.  Run as user ''zimbra'':
Set ''newpassword'' to your desired password.  Run as user ''zimbra'':

Revision as of 19:27, 27 December 2007

One of the most common problems with installing and starting a service is an incorrect LDAP or MySQL password.


Resetting the LDAP Password

First, we need to make sure that Zimbra is stopped.

Try running:

> su zimbra
> zmcontrol stop

Just to be safe, you can make sure that all Zimbra services are stopped:

> ps auxww | grep zimbra
> ps auxww | grep slapd


Kill any left over processes.

Now, we can reset the passwords:

First the root(note: these are run as user zimbra)

> zmldappasswd --root newpass

Next the zimbra:

> zmldappasswd newpass

Make sure you use the same password for both!

Resetting Mailbox Database Passwords

root account

Set newpassword to your desired password. Run as user zimbra:

 > zmmypasswd --root newpassword

zimbra account

 > zmmypasswd newpasswd

Resetting Logger Database Passwords

In the event you have lost your logger password, or it has otherwise become out of sync after an upgrade, you can reset it. Keep in mind that the logger is not a required component to have running.

root account

Set newpassword to your desired password. Run as user zimbra:

 > zmmylogpasswd --root newpassword

zimbra account

 > zmmylogpasswd newpasswd
Jump to: navigation, search