mysql.server is not running.
-
- Posts: 2
- Joined: Mon Nov 06, 2017 7:10 pm
mysql.server is not running.
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
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
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
Re: mysql.server is not running.
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
Code: Select all
mysql.server start
Code: Select all
zmcontrol -v
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
-
- Posts: 2
- Joined: Mon Nov 06, 2017 7:10 pm
Re: mysql.server is not running.
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)
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
Re: mysql.server is not running.
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
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
Re: mysql.server is not running.
Same error occured, and when I manually run mysql.server it says "mysql is not rnunning"
Is there any workaround?
Thanks
Is there any workaround?
Thanks
Re: mysql.server is not running.
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:aurotech wrote:Same error occured, and when I manually run mysql.server it says "mysql is not rnunning"
Code: Select all
zmcontrol -v
Re: mysql.server is not running.
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.
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.
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
Re: mysql.server is not running.
The recovery process is documented here: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.
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
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
Re: mysql.server is not running.
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).
1.number users is 3000.
2. Centos 6.5 (VM)
3. RAM 32 GB(free 700 MB only,using 15GB,cache 17GB).
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
Re: mysql.server is not running.
Load is a number not a percent; are you sure you are reporting Load as reported by top?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).
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
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate