Results 1 to 8 of 8

Thread: [SOLVED] Can't connect to local MySQL server

  1. #1
    akintemel is offline Active Member
    Join Date
    Aug 2010
    Location
    Turkey
    Posts
    43
    Rep Power
    5

    Exclamation [SOLVED] Can't connect to local MySQL server

    Hi,

    I try to find issues my problem but i am not sure what isues is right

    zmcontrol status come out :

    Host mail.yatas.com.tr
    antispam Running
    antivirus Running
    ldap Running
    logger Running
    mailbox Stopped
    mysql.server is not running.
    mta Running
    snmp Running
    spell Running
    stats Stopped

    /etc/hosts file :
    127.0.0.1 localhost.localdomain localhost
    212.175.218.122 mail.yatas.com.tr mail
    ::1 localhost6.localdomain6 localhost6

    /etc/resolv.conf file :
    search yatas.com.tr
    name server 127.0.0.1

    host 'mail.yatas.com.tr' come out:

    mail.yatas.com.tr has address 212.175.218.122

    dig mail.yatas.com.tr come out:

    ;; ANSWER SECTION:
    mail.yatas.com.tr. 86400 IN A 212.175.218.122

    ;; AUTHORITY SECTION:
    yatas.com.tr. 86400 IN NS mail.yatas.com.tr.


    dig -x 212.175.218.122 come out :

    ;; ANSWER SECTION:
    122.218.175.212.in-addr.arpa. 86400 IN PTR mail.yatas.com.tr.

    ;; AUTHORITY SECTION:
    218.175.212.in-addr.arpa. 86400 IN NS ns.yatas.com.tr.


    [zimbra@mail ~]$ mysql mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

    [zimbra@mail ~]$ mysql zimbra
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

    myslow.log file :
    Tcp port: 7306 Unix socket: /opt/zimbra/db/mysql.sock
    Time Id Command Argument

    mysql_error.log :
    thd=(nil)
    Attempting backtrace. You can use the following information to find out
    where mysqld died. If you see no messages after this, something went
    terribly wrong...
    frame pointer is NULL, did you compile with
    -fomit-frame-pointer? Aborting backtrace!
    The manual page at MySQL :: MySQL 5.1 Reference Manual :: B.5.4.2 What to Do If MySQL Keeps Crashing contains
    information that should help you find out what is causing the crash.
    100921 02:29:27 mysqld ended

    ---------------

    what can i do for this error.i found Mysql Crash Recovery wiki page is it right my issues or am i change mysql password .

    Thank you

    Best regards.

  2. #2
    iway is offline Partner (VAR/HSP)
    Join Date
    May 2008
    Posts
    432
    Rep Power
    7

    Default

    Might be some MySQL database corruption.

  3. #3
    akintemel is offline Active Member
    Join Date
    Aug 2010
    Location
    Turkey
    Posts
    43
    Rep Power
    5

    Default

    how to i resolve msyql Colud you show me ?

  4. #4
    akintemel is offline Active Member
    Join Date
    Aug 2010
    Location
    Turkey
    Posts
    43
    Rep Power
    5

    Default

    i wanto know just which way to get my problem issues.I think mysql password is problem.Her is zmmysqlstatus command ;

    [zimbra@mail ~]$ zmmysqlstatus
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
    Error while running 'mysql --user=zimbra --password=E_ubUodH77jvgNhiBRrEq9XNWOZdB --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 248.

  5. #5
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,579
    Rep Power
    57

    Default

    Look in the log files for errors and search the forums and wiki forr some troubleshooting tips and resolutions - the likelihood is this problem has been covered before.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    akintemel is offline Active Member
    Join Date
    Aug 2010
    Location
    Turkey
    Posts
    43
    Rep Power
    5

    Default

    I am so so hapy i did it . problem was innodb crash that way mysql wold not start.
    Thankyou verymuch for your spelling time for me.

    Best regards

    Mysql Crash Recovery - Zimbra :: Wiki <---- great

  7. #7
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,579
    Rep Power
    57

    Default

    Quote Originally Posted by akintemel View Post
    I am so so hapy i did it . problem was innodb crash that way mysql wold not start.
    Excellent, I'm glad you've fixed it.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    doc2354j is offline Starter Member
    Join Date
    Aug 2006
    Posts
    1
    Rep Power
    9

    Default Link to way to fix issue

    All thank you this came in very handy here is the link I used to fix the issue
    Mysql Crash Recovery - Zimbra :: Wiki

    Cheers

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. zmmailboxdctl is not running !!!!!!
    By olibite in forum Administrators
    Replies: 14
    Last Post: 04-28-2011, 05:50 AM
  2. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  3. Replies: 2
    Last Post: 01-17-2007, 10:18 PM
  4. No luck installing on FC4
    By lledynot in forum Installation
    Replies: 10
    Last Post: 10-14-2005, 03:20 PM
  5. more fedora install problems
    By jlynch3 in forum Installation
    Replies: 13
    Last Post: 09-14-2005, 09:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •