Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Lost LDAP and MYSQL passwords

  1. #1
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default Lost LDAP and MYSQL passwords

    So I just did the 3.0.1 update from 3.0GA

    During the process, I got an invalid credentials message. (-49)

    Code:
    Port conflict detected: 389 (zimbra-ldap)
    Port conflict detected: 389 (zimbra-ldap)
    Port conflicts detected! - Any key to continue 
    Starting ldap...Done
    Setting defaults from ldap...ERROR: service.FAILURE (system failure: getDirectContext) (cause: javax.naming.AuthenticationException [LDAP: error code 49 - Invalid Credentials])
    ERROR: service.FAILURE (system failure: getDirectContext) (cause: javax.naming.AuthenticationException [LDAP: error code 49 - Invalid Credentials])
    So, I've had this trouble before, but I just erased and started all over again. Now, I can't afford to do that.

    So now, I'm here:
    Code:
    Checking ldap on localhost:389...FAILED ( ldap_bind: Invalid credentials (49) )
    
    Main menu
    I also tried the zmldappasswd --root (PW HERE) command with and without the --root switch; however, when I run zmlocalconfig, the password is *.

    I don't know what to do. I've tried resetting the mysql and ldap passwords, but perhaps I"m doing it wrong... Need help.
    Last edited by jholder; 03-05-2006 at 05:20 PM.

  2. #2
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default

    Try running zmcontrol stop
    then ps auxww | grep slapd

    Verify that ldap is stopped - if it's not, kill it by hand and restart.

    If it still doesn't work

    try shutting ldap down, then reset the password (both for root and zimbra) via:
    zmldappasswd --root newpass
    zmldappasswd newpass

    Make sure you use the same password for both!

  3. #3
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Hey MarcMac

    I well, I did that. I figured out that it's the sql password...atleast I think.

    Ldap is functioning, byt my mailbox and logger arn't, so I think it it's sql

    How would I reset it?

    I tried some other instructions you had in the forum..and here is where I am:

    [zimbra@tusd-exch01 bin]$ safe_mysqld --skip-grant-table
    Starting mysqld daemon with databases from /var/lib/mysql
    /usr/bin/safe_mysqld: line 240: /var/log/mysqld.log: Permission denied
    /usr/bin/safe_mysqld: line 248: /var/log/mysqld.log: Permission denied
    tee: /var/log/mysqld.log: Permission denied
    060305 19:06:21 mysqld ended
    tee: /var/log/mysqld.log: Permission denied

    [zimbra@tusd-exch01 bin]$ /opt/zimbra/mysql/bin/mysql -S /opt/zimbra/db/mysql.sock -u root mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

  4. #4
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default

    the sql password? Verify that that's the problem, then use
    zmmypassword and zmmyloggerpassword

  5. #5
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Well, I think that it's SQL since the logger and mailbox are stopped.

    What do you think?

    I ran zmcontrol start and I got
    Code:
    getService: sasl
    getService: webxml
    getService: perdition
    DO: /opt/zimbra/postfix/sbin/postconf -e content_filter='smtp-amavis:[127.0.0.1]:10024'
    DO: /opt/zimbra/postfix/sbin/postconf -e myhostname='tusd-exch01.tombstone.k12.az.us'
    DO: /opt/zimbra/postfix/sbin/postconf -e recipient_delimiter=''
    DO: /opt/zimbra/postfix/sbin/postconf -e smtpd_sasl_auth_enable='yes'
    DO: /opt/zimbra/postfix/sbin/postconf -e smtpd_tls_auth_only='yes'
    DO: /opt/zimbra/postfix/sbin/postconf -e disable_dns_lookups='no'
    DO: /opt/zimbra/postfix/sbin/postconf -e message_size_limit='10240000'
    DO: /opt/zimbra/postfix/sbin/postconf -e relayhost=''
    DO: /opt/zimbra/postfix/sbin/postconf -e smtpd_recipient_restrictions='reject_non_fqdn_recipient, permit_sasl_authenticated, permit_mynetworks, reject_invalid_hostname, reject_non_fqdn_sender, reject_unauth_destination, permit'
    postsuper: Requeued: 10 messages
    saslauthd[16012] :detach_tty      : Cannot start saslauthd
    saslauthd[16012] :detach_tty      : Another instance of saslauthd is currently running
    and when I run zmcontrol status
    Code:
            antispam                Stopped
            antivirus               Stopped
            ldap                    Running
            logger                  Stopped
            mailbox                 Stopped
            mta                     Stopped
            snmp                    Running
            spell                   Running
    and when I try to use zmmypasswd, I get
    Code:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    **** PASSWORD CHANGE FAILED
    Last edited by jholder; 03-05-2006 at 07:22 PM.

  6. #6
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default

    Look in /opt/zimbra/.saveconfig/config.save for the sql passwords from the pre-upgrade install.

    You can reset them in the local config with
    zmlocalconfig -fe mysql_root_password='password'
    to the previous values

    If that doesn't fix it, you'll have to use the --skip-grant-tables option on sql startup (I think that's in the forums)

  7. #7
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    No luck changing the password. . .
    So I tried the grant tables option:
    [zimbra@tusd-exch01 bin]$ safe_mysqld --skip-grant-tables
    Starting mysqld daemon with databases from /var/lib/mysql
    060305 19:56:37 mysqld ended

  8. #8
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default

    You'll want to run it as it's called in the /opt/zimbra/bin/mysql.server script.

  9. #9
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Ya, I searched and got it reset via the script.

    Unfourtunetly, the logger and mailbox still won't start. I'm trying to run the install script again (I'm thinking that perhaps if I do that, it will resync everything)

  10. #10
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    14

    Default

    sh -x bin/zmmailboxctl status

    What's not running? Tomcat, sql?

Similar Threads

  1. Use external LDAP and MySQL
    By jwilleke in forum Installation
    Replies: 5
    Last Post: 03-11-2010, 07:09 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  3. Installing without MySql and LDAP
    By rwcanary in forum Installation
    Replies: 7
    Last Post: 06-15-2007, 10:18 AM
  4. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  5. Replies: 4
    Last Post: 11-15-2006, 12:16 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
  •