MySQL ERROR
-
- Posts: 16
- Joined: Wed Jun 15, 2016 8:40 pm
MySQL ERROR
HI,
I have a problem. My vestaCP server gives this problem:
root@websrv:~# systemctl status mysql.service -l
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Wed 2016-06-15 20:37:06 EDT; 4min 26s ago
Process: 7791 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Jun 15 20:37:06 websrv.launchhost.net mysql[7791]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: mysql.service: control process exited, code=exited status=1
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Unit mysql.service entered failed state.
Can help everbody my please?
The mysql server don't want start after a backup image form the disk image imported on the server. The web server works fine the websites are online but the mysql server don't work only. Anthor things works fine!
I have a problem. My vestaCP server gives this problem:
root@websrv:~# systemctl status mysql.service -l
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since Wed 2016-06-15 20:37:06 EDT; 4min 26s ago
Process: 7791 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Jun 15 20:37:06 websrv.launchhost.net mysql[7791]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: mysql.service: control process exited, code=exited status=1
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jun 15 20:37:06 websrv.launchhost.net systemd[1]: Unit mysql.service entered failed state.
Can help everbody my please?
The mysql server don't want start after a backup image form the disk image imported on the server. The web server works fine the websites are online but the mysql server don't work only. Anthor things works fine!
Re: MySQL ERROR
What about your logs ?
What journalctl -xn return ?
What journalctl -xn return ?
-
- Posts: 16
- Joined: Wed Jun 15, 2016 8:40 pm
Re: MySQL ERROR
Hi,
Jun 15 22:05:01 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:01 websrv.launchhost.net CRON[28198]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:02 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:02 websrv.launchhost.net CRON[28197]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:05:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
~
~
~
Jun 15 22:05:01 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:01 websrv.launchhost.net CRON[28198]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:02 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:02 websrv.launchhost.net CRON[28197]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:05:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
~
~
~
-
- Posts: 16
- Joined: Wed Jun 15, 2016 8:40 pm
Re: MySQL ERROR
Hi,
and this:
Jun 15 22:05:01 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:01 websrv.launchhost.net CRON[28198]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:02 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:02 websrv.launchhost.net CRON[28197]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:05:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
lines 1-11/11 (END)...skipping...
-- Logs begin at Wed 2016-06-15 20:31:01 EDT, end at Wed 2016-06-15 22:06:54 EDT. --
Jun 15 22:05:01 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session opened for user root by (uid=0)
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session opened for user root by (uid=0)
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:01 websrv.launchhost.net CRON[28198]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:02 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:02 websrv.launchhost.net CRON[28197]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21838 PROTO=UDP SPT=17500 DPT
Jun 15 22:05:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21839 PROTO=UDP SPT=17500 DPT
Jun 15 22:06:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21840 PROTO=UDP SPT=17500 DPT
Jun 15 22:06:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21841 PROTO=UDP SPT=17500 DPT
~
~
and this:
Jun 15 22:05:01 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session opened for user root by (uid=
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:01 websrv.launchhost.net CRON[28198]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:02 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:02 websrv.launchhost.net CRON[28197]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:05:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
Jun 15 22:06:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:3
lines 1-11/11 (END)...skipping...
-- Logs begin at Wed 2016-06-15 20:31:01 EDT, end at Wed 2016-06-15 22:06:54 EDT. --
Jun 15 22:05:01 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session opened for user root by (uid=0)
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session opened for user root by (uid=0)
Jun 15 22:05:01 websrv.launchhost.net sudo[28202]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:01 websrv.launchhost.net CRON[28198]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:02 websrv.launchhost.net sudo[28201]: pam_unix(sudo:session): session closed for user root
Jun 15 22:05:02 websrv.launchhost.net CRON[28197]: pam_unix(cron:session): session closed for user admin
Jun 15 22:05:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21838 PROTO=UDP SPT=17500 DPT
Jun 15 22:05:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21839 PROTO=UDP SPT=17500 DPT
Jun 15 22:06:24 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21840 PROTO=UDP SPT=17500 DPT
Jun 15 22:06:54 websrv.launchhost.net kernel: Firewall: *UDP_IN Blocked* IN=eth0 OUT= MAC=ff:ff:ff:ff:ff:ff:00:30:48:bc:92:03:08:00 SRC=188.122.76.50 DST=255.255.255.255 LEN=160 TOS=0x00 PREC=0x00 TTL=128 ID=21841 PROTO=UDP SPT=17500 DPT
~
~
Re: MySQL ERROR
Some errors in mysql error log?
https://vestacp.com/docs/#config-log-lo ... ian-ubuntu
https://vestacp.com/docs/#config-log-lo ... ian-ubuntu