[SOLVED] Can't connect to local MySQL server

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
akintemel
Posts: 43
Joined: Sat Sep 13, 2014 1:24 am

[SOLVED] Can't connect to local MySQL server

Postby akintemel » Mon Sep 20, 2010 6:48 pm

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.


iway
Outstanding Member
Outstanding Member
Posts: 425
Joined: Fri Sep 12, 2014 11:31 pm

[SOLVED] Can't connect to local MySQL server

Postby iway » Mon Sep 20, 2010 11:55 pm

Might be some MySQL database corruption.
akintemel
Posts: 43
Joined: Sat Sep 13, 2014 1:24 am

[SOLVED] Can't connect to local MySQL server

Postby akintemel » Tue Sep 21, 2010 12:15 am

how to i resolve msyql Colud you show me ?
akintemel
Posts: 43
Joined: Sat Sep 13, 2014 1:24 am

[SOLVED] Can't connect to local MySQL server

Postby akintemel » Tue Sep 21, 2010 1:41 am

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.
phoenix
Ambassador
Ambassador
Posts: 26729
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] Can't connect to local MySQL server

Postby phoenix » Tue Sep 21, 2010 4:50 am

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

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
akintemel
Posts: 43
Joined: Sat Sep 13, 2014 1:24 am

[SOLVED] Can't connect to local MySQL server

Postby akintemel » Tue Sep 21, 2010 5:53 am

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
phoenix
Ambassador
Ambassador
Posts: 26729
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] Can't connect to local MySQL server

Postby phoenix » Tue Sep 21, 2010 5:57 am

[quote user="akintemel"]I am so so hapy i did it .:) problem was innodb crash that way mysql wold not start.[/QUOTE]Excellent, I'm glad you've fixed it. :)
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
doc2354j
Posts: 1
Joined: Fri Sep 12, 2014 10:15 pm

[SOLVED] Can't connect to local MySQL server

Postby doc2354j » Thu Oct 28, 2010 9:24 pm

All thank you this came in very handy here is the link I used to fix the issue

Mysql Crash Recovery - Zimbra :: Wiki
Cheers

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 11 guests