mysql.server is not running.

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
firatcanoglu
Posts: 2
Joined: Mon Nov 06, 2017 7:10 pm

mysql.server is not running.

Post by firatcanoglu »

hello

we are getting the following error. The mail server is not working.

amavis Running
antispam Running
antivirus Running
dnscache Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running.
memcached Running
mta Running
opendkim Running
proxy Running
service webapp Stopped
mysql.server is not running.
snmp Running
spell Running
stats Running
zimbra webapp Stopped
mysql.server is not running.
zimbraAdmin webapp Stopped
mysql.server is not running.
zimlet webapp Stopped
mysql.server is not running.
zmconfigd Running
User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

Re: mysql.server is not running.

Post by L. Mark Stone »

firatcanoglu wrote:hello

we are getting the following error. The mail server is not working.

amavis Running
antispam Running
antivirus Running
dnscache Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running.
memcached Running
mta Running
opendkim Running
proxy Running
service webapp Stopped
mysql.server is not running.
snmp Running
spell Running
stats Running
zimbra webapp Stopped
mysql.server is not running.
zimbraAdmin webapp Stopped
mysql.server is not running.
zimlet webapp Stopped
mysql.server is not running.
zmconfigd Running

Please stop all Zimbra services as the zimbra user account, then make sure none are running:

Code: Select all

zmcontrol stop
ps ax | grep zimbra
Now, as the zimbra user, try starting just mysql. If it starts OK, stop it and start Zimbra in the normal way. If it fails, send us the relevant output from /var/log/zimbra.log.

Code: Select all

mysql.server start
Also please send the output from:

Code: Select all

zmcontrol -v
Mark
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
firatcanoglu
Posts: 2
Joined: Mon Nov 06, 2017 7:10 pm

Re: mysql.server is not running.

Post by firatcanoglu »

Code: Select all

[zimbra@mail root]$ ps ax | grep zimbra
40154 pts/2    T      0:00 vi /opt/zimbra/bin/zmstatctl
50010 pts/2    S      0:00 su zimbra
58216 pts/1    S      0:00 su zimbra
60386 pts/1    R+     0:00 grep --color=auto zimbra

Code: Select all

[zimbra@mail root]$ zmcontrol -v
Release 8.7.10_GA_1829.RHEL7_64_20170524161336 RHEL7_64 FOSS edition.

Code: Select all

[zimbra@mail root]$ mysql.server start
Starting mysqld...

Code: Select all

Nov  6 03:41:01 mail su: (to zimbra) root on none
Nov  6 03:41:02 mail zmconfigd[15492]: Shutting down. Received signal 15
Nov  6 03:41:13 mail zmconfigd[23583]: zmconfigd started on mail.erenfaktoring.com.tr with loglevel=3 pid=23583
Nov  6 03:41:14 mail zmconfigd[23583]: Fetching All configs
Nov  6 03:41:15 mail zmconfigd[23583]: All configs fetched in 1.08 seconds
Nov  6 03:41:16 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/freshclam.conf with mode 600 (0.13 sec)
Nov  6 03:41:16 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/opendkim.conf with mode 440 (0.04 sec)
Nov  6 03:41:16 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/webapps/service/WEB-INF/web.xml with mode 440 (0.31 sec)
Nov  6 03:41:16 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/webapps/zimbraAdmin/WEB-INF/jetty-env.xml with mode 440 (0.01 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/dspam.conf with mode 440 (0.21 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/webapps/zimbra/WEB-INF/jetty-env.xml with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/clamd.conf with mode 440 (0.09 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/webapps/zimbraAdmin/WEB-INF/web.xml with mode 440 (0.12 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/etc/spnego.conf with mode 440 (0.03 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/common/conf/tag_as_originating.re with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/unbound.conf with mode 440 (0.01 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/webapps/zimbra/WEB-INF/web.xml with mode 440 (0.13 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/etc/jetty.xml with mode 440 (0.24 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/spnego_java_options with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/sasl2/smtpd.conf with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/etc/spnego.properties with mode 440 (0.02 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/postfix_header_checks with mode 440 (0.02 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/opendkim-localnets.conf with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/etc/krb5.ini with mode 440 (0.01 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/stats.conf with mode 440 (0.07 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/common/conf/tag_as_foreign.re with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/saslauthd.conf with mode 440 (0.00 sec)
Nov  6 03:41:17 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/log4j.properties with mode 440 (0.03 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/amavisd.conf with mode 440 (0.11 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/common/conf/master.cf with mode 440 (0.07 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/webapps/zimlet/WEB-INF/web.xml with mode 440 (0.00 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/modules/setuid.mod with mode 440 (0.05 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/data/spamassassin/localrules/salocal.cf with mode 440 (0.01 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/conf/mta_milter_options with mode 440 (0.00 sec)
Nov  6 03:41:18 mail zmconfigd[23583]: Rewrote: /opt/zimbra/mailboxd/start.d/setuid.ini with mode 440 (0.11 sec)

User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

Re: mysql.server is not running.

Post by L. Mark Stone »

So are you saying that when you did "mysql.server start" the command prompt never returned?
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
aurotech
Posts: 2
Joined: Mon Jan 08, 2018 8:42 am

Re: mysql.server is not running.

Post by aurotech »

Same error occured, and when I manually run mysql.server it says "mysql is not rnunning"

Is there any workaround?

Thanks
phoenix
Ambassador
Ambassador
Posts: 27272
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

Re: mysql.server is not running.

Post by phoenix »

aurotech wrote:Same error occured, and when I manually run mysql.server it says "mysql is not rnunning"
If you want help on these (or any other) forum then you need to give some information about your exact problem, let's start with the full output of the following command:

Code: Select all

zmcontrol -v
The next questions, is your server experiencing this problem after an upgrade or has it just started happening? There were several questions asked earlier in this thread, did you read them? How about providing the information that was asked for earlier in this thread?
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
aurotech
Posts: 2
Joined: Mon Jan 08, 2018 8:42 am

Re: mysql.server is not running.

Post by aurotech »

This is happen after the host server experience low disk space. Zimbra was on VM.
I found some possible solution(Mysql Crash Recovery) but I wasn't tested yet since Im a newbie linux. I there any other simple and fastest procedure on how to rebuild mysql, Im seeing mysql has been corrupted.

$ zmcontrol -v
Release 8.7.9_GA_1794.RHEL7_64_20170505054622 RHEL7_64 FOSS edition.
User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

Re: mysql.server is not running.

Post by L. Mark Stone »

aurotech wrote:This is happen after the host server experience low disk space. Zimbra was on VM.
I found some possible solution(Mysql Crash Recovery) but I wasn't tested yet since Im a newbie linux. I there any other simple and fastest procedure on how to rebuild mysql, Im seeing mysql has been corrupted.

$ zmcontrol -v
Release 8.7.9_GA_1794.RHEL7_64_20170505054622 RHEL7_64 FOSS edition.
The recovery process is documented here:
https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery

But, if your databases are so currupted that you can't dump them, you'll need to repair them in place, as described here:
https://dev.mysql.com/doc/refman/5.5/en ... overy.html

Good luck and keep us posted!
Mark
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
bharath81
Posts: 4
Joined: Thu Nov 21, 2019 3:28 am

Re: mysql.server is not running.

Post by bharath81 »

Thanks you for supoort it works for me.but i have one query ,i have 32 GB RAM zimbra server (8.0.7_GA) but load average is high like 12.7%,14.7%,15.8%,ram also is full but in cache it's showing 17GB.Please help regarding this issue.
1.number users is 3000.
2. Centos 6.5 (VM)
3. RAM 32 GB(free 700 MB only,using 15GB,cache 17GB).
User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

Re: mysql.server is not running.

Post by L. Mark Stone »

bharath81 wrote:Thanks you for supoort it works for me.but i have one query ,i have 32 GB RAM zimbra server (8.0.7_GA) but load average is high like 12.7%,14.7%,15.8%,ram also is full but in cache it's showing 17GB.Please help regarding this issue.
1.number users is 3000.
2. Centos 6.5 (VM)
3. RAM 32 GB(free 700 MB only,using 15GB,cache 17GB).
Load is a number not a percent; are you sure you are reporting Load as reported by top?

Please also provide the "%wa" statistic from top.

Thanks,
Mark
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
Post Reply