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

Thread: mysql dead

  1. #1
    nspanahi is offline Junior Member
    Join Date
    Oct 2008
    Posts
    8
    Rep Power
    6

    Default mysql dead

    Hi,

    Everything works in my zimbra 5.0.12 except logger. When I go to admin webpage it says logger must be installed. When I zmcontrol status it says logger not started. When I logmysql.server start it says done but then logmysql.server status says it is not running.
    When I try upgrading to 5.0.18 it gets to logger database intergrety check it says:

    Starting mysqld...done.
    /opt/zimbra/logger/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2) when trying to connect
    No Logger DB errors found.
    /opt/zimbra/logger/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.logger.cnf -S /opt/zimbra/logger/db/mysql.sock --silent -u root --password=(***) --auto-repair --databases mysql zimbra_logger command failed:


    I even tried zmmyinit and it says it can't connect to mysql.
    Please help I am stuck

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

    Default

    Hmmm, could be your /etc/hosts file is not correct. So please post the following
    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig yourdomain mx
    dig yourdomain any
    host `hostname` <- note backticks and not single quotes
    Have you also disabled IPTables and SELinux ?

  3. #3
    adeelarifbhatti is offline Advanced Member
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Post

    Hi,
    If 127.0.0.1 is define in names other than localhost, mysql will have issues.

    Regards
    Adeel

  4. #4
    veronica is offline Outstanding Member
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    Did you try changing passowrd of mysql ?

  5. #5
    nspanahi is offline Junior Member
    Join Date
    Oct 2008
    Posts
    8
    Rep Power
    6

    Default I tried all those

    hosts
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    127.0.0.1 localhost.localdomain localhost
    ::1 localhost6.localdomain6 localhost6
    71.216.159.50 metric.shonaz.net mail.shonaz.net metric mail

    resolv.conf

    search shonaz.net
    nameserver 205.171.3.65
    nameserver 205.171.2.65


    I tried changing the password as it says in the wiki but can't get connected to mysql to change the password. The logmysql.server start does not start the server.

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

    Default

    Please post all the details I have asked for

  7. #7
    veronica is offline Outstanding Member
    Join Date
    Jun 2008
    Posts
    594
    Rep Power
    8

    Default

    Are permissions fine? would you mind running zmfixperms ? Also check if there is stale logger/db/mysql.sock file

  8. #8
    nspanahi is offline Junior Member
    Join Date
    Oct 2008
    Posts
    8
    Rep Power
    6

    Default

    I tried fixing permisions... no go.


    ; <<>> DiG 9.3.3rc2 <<>> panahi.com mx
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 51620
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 0, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;panahi.com. IN MX

    ;; ANSWER SECTION:
    panahi.com. 5192 IN MX 50 mx2.mailhop.org.
    panahi.com. 5192 IN MX 5 mail.shonaz.net.

    ;; Query time: 41 msec
    ;; SERVER: 205.171.3.65#53(205.171.3.65)
    ;; WHEN: Fri Jul 24 12:34:57 2009
    ;; MSG SIZE rcvd: 90

    [zimbra@mail ~]$ dig panahi.com any

    ; <<>> DiG 9.3.3rc2 <<>> panahi.com any
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 62348
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 8, AUTHORITY: 0, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;panahi.com. IN ANY

    ;; ANSWER SECTION:
    panahi.com. 9070 IN TXT "v=spf1 a:mx2.mailhop.org a:mail.shonaz.net a:metric.shonaz.net ip4:67.42.72.82 -all"
    panahi.com. 5130 IN MX 5 mail.shonaz.net.
    panahi.com. 5130 IN MX 50 mx2.mailhop.org.
    panahi.com. 5130 IN NS ns3.mydyndns.org.
    panahi.com. 5130 IN NS ns5.mydyndns.org.
    panahi.com. 5130 IN NS ns1.mydyndns.org.
    panahi.com. 5130 IN NS ns2.mydyndns.org.
    panahi.com. 5130 IN NS ns4.mydyndns.org.

    ;; Query time: 42 msec
    ;; SERVER: 205.171.3.65#53(205.171.3.65)
    ;; WHEN: Fri Jul 24 12:35:59 2009
    ;; MSG SIZE rcvd: 285


    [zimbra@mail ~]$ host `hostname`
    mail.shonaz.net has address 71.216.159.50

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

    Default

    You appear to have no A record for your domain, you should fix that.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  10. #10
    nspanahi is offline Junior Member
    Join Date
    Oct 2008
    Posts
    8
    Rep Power
    6

    Default

    I do have an A record, I wonder why dig did not show it.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 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
  •