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.

Postby firatcanoglu » Mon Nov 06, 2017 7:13 pm

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
Elite member
Elite member
Posts: 1827
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine
ZCS/ZD Version: 8.8.8 Patch 6 Network Edition
Contact:

Re: mysql.server is not running.

Postby L. Mark Stone » Mon Nov 06, 2017 8:28 pm

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/
Zeta Alliance http://www.zetalliance.org/
firatcanoglu
Posts: 2
Joined: Mon Nov 06, 2017 7:10 pm

Re: mysql.server is not running.

Postby firatcanoglu » Mon Nov 06, 2017 8:43 pm

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
Elite member
Elite member
Posts: 1827
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine
ZCS/ZD Version: 8.8.8 Patch 6 Network Edition
Contact:

Re: mysql.server is not running.

Postby L. Mark Stone » Tue Nov 07, 2017 1:53 pm

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/
Zeta Alliance http://www.zetalliance.org/
aurotech
Posts: 2
Joined: Mon Jan 08, 2018 8:42 am

Re: mysql.server is not running.

Postby aurotech » Mon Jan 08, 2018 9:17 am

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: 25678
Joined: Fri Sep 12, 2014 9:56 pm

Re: mysql.server is not running.

Postby phoenix » Mon Jan 08, 2018 11:02 am

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

If you'd like to see this implemented in a future version of ZCS then please vote on Bugzilla entries 97706 & 108168
aurotech
Posts: 2
Joined: Mon Jan 08, 2018 8:42 am

Re: mysql.server is not running.

Postby aurotech » Mon Jan 08, 2018 11:40 pm

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
Elite member
Elite member
Posts: 1827
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine
ZCS/ZD Version: 8.8.8 Patch 6 Network Edition
Contact:

Re: mysql.server is not running.

Postby L. Mark Stone » Tue Jan 09, 2018 1:41 pm

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/
Zeta Alliance http://www.zetalliance.org/

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 18 guests