hello all,
i am not able to connect my zabbix web interface. it says error connecting to database: no such file or directory. when i checkd my sql service it was showing in this way
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
Active: activating (start-post) (Result: exit-code) since Fri 2018-03-16 10:1
Process: 13423 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
Process: 13414 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exi
Main PID: 13423 (code=exited, status=2); : 13425 (mysql-systemd-s)
Tasks: 2
Memory: 360.0K
CPU: 3.238s
CGroup: /system.slice/mysql.service
└─control
├─13425 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─13458 sleep 1
Mar 16 10:18:57 Zabbix systemd[1]: Stopped MySQL Community Server.
Mar 16 10:18:57 Zabbix systemd[1]: Starting MySQL Community Server...
Mar 16 10:18:59 Zabbix systemd[1]: mysql.service: Main process exited, code=exit
lines 1-17/17 (END)...skipping...
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Fri 2018-03-16 10:18:57 CDT; 10s ago
Process: 13423 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
Process: 13414 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 13423 (code=exited, status=2); : 13425 (mysql-systemd-s)
Tasks: 2
Memory: 360.0K
CPU: 3.238s
CGroup: /system.slice/mysql.service
└─control
├─13425 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─13458 sleep 1
Mar 16 10:18:57 Zabbix systemd[1]: Stopped MySQL Community Server.
Mar 16 10:18:57 Zabbix systemd[1]: Starting MySQL Community Server...
Mar 16 10:18:59 Zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
how to resolve this issue.
thankyou,
~
i am not able to connect my zabbix web interface. it says error connecting to database: no such file or directory. when i checkd my sql service it was showing in this way
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
Active: activating (start-post) (Result: exit-code) since Fri 2018-03-16 10:1
Process: 13423 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
Process: 13414 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exi
Main PID: 13423 (code=exited, status=2); : 13425 (mysql-systemd-s)
Tasks: 2
Memory: 360.0K
CPU: 3.238s
CGroup: /system.slice/mysql.service
└─control
├─13425 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─13458 sleep 1
Mar 16 10:18:57 Zabbix systemd[1]: Stopped MySQL Community Server.
Mar 16 10:18:57 Zabbix systemd[1]: Starting MySQL Community Server...
Mar 16 10:18:59 Zabbix systemd[1]: mysql.service: Main process exited, code=exit
lines 1-17/17 (END)...skipping...
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Fri 2018-03-16 10:18:57 CDT; 10s ago
Process: 13423 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
Process: 13414 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 13423 (code=exited, status=2); : 13425 (mysql-systemd-s)
Tasks: 2
Memory: 360.0K
CPU: 3.238s
CGroup: /system.slice/mysql.service
└─control
├─13425 /bin/bash /usr/share/mysql/mysql-systemd-start post
└─13458 sleep 1
Mar 16 10:18:57 Zabbix systemd[1]: Stopped MySQL Community Server.
Mar 16 10:18:57 Zabbix systemd[1]: Starting MySQL Community Server...
Mar 16 10:18:59 Zabbix systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
how to resolve this issue.
thankyou,
~