Difference between revisions of "Resetting LDAP and MySQL Passwords"

(tidy)
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 +
{{BC|Community Sandbox}}
 +
__FORCETOC__
 +
<div class="col-md-12 ibox-content">
 +
=Resetting LDAP and MySQL passwords=
 +
{{KB|{{Unsupported}}|{{ZCS 5.0}}||}}
 +
{{Archive}}{{WIP}}
 
Various Zimbra services use passwords stored in [[Zmlocalconfig|localconfig]] when connecting to ldap and mysql. If these passwords are incorrect, or if you just want to change them, this guide explains how to update the passwords.
 
Various Zimbra services use passwords stored in [[Zmlocalconfig|localconfig]] when connecting to ldap and mysql. If these passwords are incorrect, or if you just want to change them, this guide explains how to update the passwords.
  
Line 49: Line 55:
  
 
== Updating Mailbox MySQL Database Passwords  ==
 
== Updating Mailbox MySQL Database Passwords  ==
 +
<pre>
 +
New feature in 7.x /opt/zimbra/libexec/zmresetmysqlpassword (a life saver)
 +
</pre>
 
It is necessary to run the password update commands as the zimbra user.
 
It is necessary to run the password update commands as the zimbra user.
 
  # su - zimbra
 
  # su - zimbra
Line 85: Line 94:
  
 
== Related Articles ==
 
== Related Articles ==
[[Zimbra_CLI_Command_List|Zimbra CLI Command List]]
+
*[[Issues_with_mysql_and_logmysql_passwords|Issues with mysql and logmysql passwords]] may help if the steps in this guide do not work to update the passwords
 +
 
 +
*[http://www.zimbra.com/docs/ne/latest/administration_guide/A_app-command-line.20.1.html CLI Commands ZCS 6.0.x]
 +
 
 +
*[http://www.zimbra.com/docs/ne/latest/administration_guide/A_app-command-line.18.1.html CLI Commands ZCS 5.0.x]
 +
 
 +
*[http://www.zimbra.com/docs/ne/4.5.10/administration_guide/A_app-command-line.14.1.html CLI Commands ZCS 4.5.x]
  
----
 
<br> Keywords: ''ldap, logger, mysql, database, password''
 
  
 
{{Article_Footer|unknown|3/28/2006}}
 
{{Article_Footer|unknown|3/28/2006}}
  
 +
Keywords: ''ldap, logger, mysql, database, password''
 
[[Category: Database]]
 
[[Category: Database]]
 
[[Category: LDAP]]
 
[[Category: LDAP]]
Line 97: Line 111:
 
[[Category: MySQL]]
 
[[Category: MySQL]]
 
[[Category: Pending Certification]]
 
[[Category: Pending Certification]]
[[Category: Troubleshooting]]
+
[[Category: Troubleshooting Authentication]]
 +
[[Category: ZCS 5.0]]

Latest revision as of 20:52, 12 July 2015

Resetting LDAP and MySQL passwords

   KB 2444        Last updated on 2015-07-12  




0.00
(0 votes)

Various Zimbra services use passwords stored in localconfig when connecting to ldap and mysql. If these passwords are incorrect, or if you just want to change them, this guide explains how to update the passwords.

Updating LDAP Passwords

It is necessary to run the password update commands as the zimbra user.

# su - zimbra

In ZCS 5.0.x

 Command Usage: /opt/zimbra/bin/zmldappasswd [-h] [-r] [-p] [-l] newpassword
	-h: display this help message
	-a: change ldap_amavis_password
	-l: change ldap_replication_password
	-n: change ldap_nginx_password
	-p: change ldap_postfix_password
	-r: change ldap_root_passwd
	Only one of a, l, n, p, or r may be specified
	Without options zimbra_ldap_password is changed

Make sure that slapd is running. Note that the actual process id (pid) will vary.

$ ldap status
slapd running pid: 32266

Update the ldap root password.

$ zmldappasswd -r newrootpass

Update the zimbra ldap password.

$ zmldappasswd newpass

If necessary, update the password for other ldap users (amavis, replication, nginx, postfix).

In ZCS 4.5.x

Stop zimbra services.

# su - zimbra
$ zmcontrol stop

Verify that all Zimbra services are stopped.

$ ps auxww | grep zimbra

Now we can reset the passwords. Note: In versions of ZCS up to 4.5.x the zimbra ldap password must be the same as the ldap root password.

Update the ldap root password.

$ zmldappasswd --root newpass

Update the zimbra ldap password.

$ zmldappasswd newpass

Updating Mailbox MySQL Database Passwords

New feature in 7.x /opt/zimbra/libexec/zmresetmysqlpassword (a life saver)

It is necessary to run the password update commands as the zimbra user.

# su - zimbra

Make sure the mailbox mysql database is running. Note that the actual process id (pid) will vary.

 $ mysql.server status
 mysql is running with pid 23830

If that fails to find a running mysql, verify that the mailbox mysqld does not appear in the process list, and then start it.

$ ps a | grep mysqld.*my.cnf
$ mysql.server start
 

Update the mysql root password.

$ zmmypasswd --root newrootpass

Update the zimbra mysql password.

$ zmmypasswd newpass

Updating Logger MySQL Database Passwords

It is necessary to run the password update commands as the zimbra user.

# su - zimbra

Make sure the logger mysql database is running. Note that the actual process id (pid) will vary.

 $ logmysql.server status
 mysql is running with pid 23830

If that fails to find a running mysql, verify that the mailbox mysqld does not appear in the process list, and then start it.

$ ps a | grep mysqld.*my.logger.cnf
$ logmysql.server start

Update the logger mysql root password.

$ zmmylogpasswd --root newrootpass

Update the logger zimbra mysql password.

$ zmmylogpasswd newpass

Related Articles


Verified Against: unknown Date Created: 3/28/2006
Article ID: https://wiki.zimbra.com/index.php?title=Resetting_LDAP_and_MySQL_Passwords Date Modified: 2015-07-12



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »



Keywords: ldap, logger, mysql, database, password
Jump to: navigation, search