Results 1 to 3 of 3

Thread: mysql and ldap authentication issue

  1. #1
    chandu is offline Elite Member
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default mysql and ldap authentication issue

    Hi Guys,

    I was doing some testing on my test server and regenerated self - signed certificate..after that all services were up but i was not able to login in mysql and in mailboxd.log i was keep geting database authentication related error ..so i followed below steps to fix it :

    1. added below line in mysql.server :
    --ledir=${mysql_directory}/libexec < /dev/null > /dev/null 2>&1 --skip-grant-tables &
    mysql> use mysql;
    mysql> select user,password,host from user;
    +--------+-------------------------------------------+-----------------------+
    | user | password | host |
    +--------+-------------------------------------------+-----------------------+
    | root | *F4DB5AEB3837CA8C77C648F90B8A88E2C2F05774 | localhost |
    | root | | mail |
    | root | | 127.0.0.1 |
    | | | localhost |
    | | | mail |
    | zimbra | *5944C10DC1427A97C1CC33D79878E363F453BB30 | &#37; |
    | zimbra | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | localhost |
    | zimbra | *5944C10DC1427A97C1CC33D79878E363F453BB30 | localhost.localdomain |
    | root | *6E6F7B4008B7AD56CE235EE6AB66BC6B8207C6FF | localhost.localdomain |
    +--------+-------------------------------------------+-----------------------+
    9 rows in set (0.00 sec)

    mysql> update user set password=xdcfvgbg' where user='zimbra';
    Query OK, 3 rows affected (0.01 sec)
    Rows matched: 3 Changed: 3 Warnings: 0

    mysql> select user,password,host from user;
    +--------+-------------------------------------------+-----------------------+
    | user | password | host |
    +--------+-------------------------------------------+-----------------------+
    | root | *F4DB5AEB3837CA8C77C648F90B8A88E2C2F05774 | localhost |
    | root | | mail |
    | root | | 127.0.0.1 |
    | | | localhost |
    | | | mail |
    | zimbra | xdcfvgbg | % |
    | zimbra | xdcfvgbg | localhost |
    | zimbra | xdcfvgbg | localhost.localdomain |
    | root | *6E6F7B4008B7AD56CE235EE6AB66BC6B8207C6FF | localhost.localdomain |
    +--------+-------------------------------------------+-----------------------+
    9 rows in set (0.00 sec)


    mysql> UPDATE mysql.user SET Password=PASSWORD(xdcfvgbg) WHERE User='zimbra';
    Query OK, 3 rows affected (0.00 sec)
    Rows matched: 3 Changed: 3 Warnings: 0

    mysql> select user,password,host from user;
    +--------+-------------------------------------------+-----------------------+
    | user | password | host |
    +--------+-------------------------------------------+-----------------------+
    | root | *F4DB5AEB3837CA8C77C648F90B8A88E2C2F05774 | localhost |
    | root | | mail |
    | root | | 127.0.0.1 |
    | | | localhost |
    | | | mail |
    | zimbra | *5944C10DC1427A97C1CC33D79878E363F453BB30 | % |
    | zimbra | *5944C10DC1427A97C1CC33D79878E363F453BB30 | localhost |
    | zimbra | *5944C10DC1427A97C1CC33D79878E363F453BB30 | localhost.localdomain |
    | root | *6E6F7B4008B7AD56CE235EE6AB66BC6B8207C6FF | localhost.localdomain |
    +--------+-------------------------------------------+-----------------------+
    9 rows in set (0.00 sec)

    mysql> exit
    Bye

    ################################################## #

    After thsi i removed entry from mysql.server and now able to get database authentication without eny issue.

    But now when i try to run zmprov command its throughing below error :

    [zimbra@mail ~]$ zmprov gad
    ERROR: account.AUTH_FAILED (authentication failed for zimbra)
    [zimbra@mail ~]$

    And in mailbox.log and audit.log i was getting below error :

    ################################################
    2009-10-29 15:52:08,081 WARN [btpool0-7] [name=zimbra;ip=127.0.0.1;] security - cmd=Auth; account=zimbra; protocol=soap; error=authentication failed for zimbra, account lockout;

    2009-10-29 15:52:08,081 INFO [btpool0-7] [name=zimbra;ip=127.0.0.1;] SoapEngine - handler exception: authentication failed for zimbra, account lockout

    #################################################

    So I have changed ldap password by using below mentioned link

    Resetting LDAP and MySQL Passwords - Zimbra :: Wiki

    and restarted zmibra services...but now still i am not able to use zmprov commands and getting below error .... :-(

    ##################################################

    2009-10-29 15:52:08,081 WARN [btpool0-7] [name=zimbra;ip=127.0.0.1;] security - cmd=AdminAuth; account=zimbra; error=authentication failed for zimbra;

    ################################################## ##

    Please suggest...


    Thanks
    Last edited by chandu; 10-29-2009 at 05:06 AM.

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Code:
    su - zimbra
    zmlocalconfig -s | grep password
    Make sure these are set correctly.

  3. #3
    chandu is offline Elite Member
    Join Date
    Dec 2007
    Posts
    445
    Rep Power
    7

    Default

    Thanks for reply Uxbod.

    Please have a look on output..

    [zimbra@mail ~]$ zmlocalconfig -s | grep password
    ldap_amavis_password = XInPp345
    ldap_nginx_password = XInPp345
    ldap_postfix_password = XInPp345
    ldap_replication_password = XInPp345
    ldap_root_password = zimbra
    mailboxd_keystore_base_password = zimbra
    mailboxd_keystore_password = SVloGkM56Q
    mailboxd_truststore_password = changeit
    mysql_logger_root_password = hnhjn
    mysql_root_password = vgbvgb
    zimbra_ldap_password = zimbra
    zimbra_logger_mysql_password = fvgfbgb
    zimbra_mysql_password = dcfvfv
    [zimbra@mail ~]$

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Zimbra logwatch.
    By nishith in forum Administrators
    Replies: 5
    Last Post: 06-10-2009, 04:42 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. Zimbra Authenticating over MySQL instead of LDAP
    By coryodaniel in forum Installation
    Replies: 2
    Last Post: 08-19-2008, 02:04 AM
  4. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  5. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 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
  •