Zabbix Server is not running on Ubuntu 14.04

[batchenr]

Here is the /etc/mysql/my.cnf

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/se...variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
skip-name-resolve
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/


Thanks
Mudit

backup your file and start mysql like this :
i copied your file and made some changes.

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/se...variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
log_error = /var/log/mysql/error.log
pid-file = /var/run/mysqld/mysqld.pid

[mysqld]
#
# * Basic Settings
#
user = mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#
# * Fine Tuning
#
skip-name-resolve
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

[mudit.gupta]

Hello batchenr

I backed up file my.cnf and then pasted the config my.cnf in which you made changes and then restarted mysql , zabbix server and try to connect Zabbix GUI.

But still says :: Zabbix Server is not running .

Error in Zabbix Server logs ::
6518:20170206:135903.106 [Z3001] connection to database 'zabbixdb' failed: [0] FATAL: password authentication failed for user "zabbix"
FATAL: password authentication failed for user "zabbix"

6518:20170206:135903.106 database is down: reconnecting in 10 seconds
6518:20170206:135913.116 [Z3001] connection to database 'zabbixdb' failed: [0] FATAL: password authentication failed for user "zabbix"
FATAL: password authentication failed for user "zabbix"

6518:20170206:135913.116 database is down: reconnecting in 10 seconds


I appreciate your help here but still zabbix server is not running .

Thanks
Mudit

[batchenr]

Hello batchenr

I backed up file my.cnf and then pasted the config my.cnf in which you made changes and then restarted mysql , zabbix server and try to connect Zabbix GUI.

But still says :: Zabbix Server is not running .

Error in Zabbix Server logs ::
6518:20170206:135903.106 [Z3001] connection to database 'zabbixdb' failed: [0] FATAL: password authentication failed for user "zabbix"
FATAL: password authentication failed for user "zabbix"

6518:20170206:135903.106 database is down: reconnecting in 10 seconds
6518:20170206:135913.116 [Z3001] connection to database 'zabbixdb' failed: [0] FATAL: password authentication failed for user "zabbix"
FATAL: password authentication failed for user "zabbix"

6518:20170206:135913.116 database is down: reconnecting in 10 seconds


I appreciate your help here but still zabbix server is not running .

Thanks
Mudit

we can try few things:

post this info here :
ll /etc/zabbix*
ll /var/run/zabbix*
ll /var/lib/mysql
ll /var/lib/mysql/mysql*
ll /var/lib/mysql/zabbixdb*

1. repair mysql
mysqlcheck --auto-repair --all-databases -o

2. try run zbbix user as root.
go to /etc/zabbix/zabbix_server.conf
and set AllowRoot=1
change /etc/passwd like this :
zabbix:x:0:0::/home/zabbix:/bin/bash

restart zabbix server

3.what is tour server recurses ? i saw that you gave key_buffer only 16M
what size is your memmory ? cpu ?
maybe we can try and give zabbix more recurces.

please backup your system first - i dont know what is the problem but we are trying things and maybe we will hit the issue : )

[batchenr]

by the way.. when you connect to mysql using zabbix user
when you hit the quary:
show databases;
do you see zabbixdb?
and if you quary
use zabbixdb;

does it work ?

[Pada]

Can you actually log in using the MySQL credentials in your zabbix_server.conf file by running mysql command line, like follow:

mysql -h"localhost" -u"zabbix" -p"<your DBPassword>" zabbixdb

If that works, then it probably means that you have a funny character or space in the password that Zabbix doesn't handle well when reading the configuration file.

One other thing that you may want to try is to change the "DBUser" value in your zabbix_server.conf and then restart zabbix server to ensure that it gives you the Authentication failure for that user, because there is also the possibility that Zabbix isn't using /etc/zabbix/zabbix_server.conf ...

[mudit.gupta]

Dear batchenr and Pada

Thanks to both of you but no luck !!

For batchenr ::

When I try to access mysql using zabbix user , it allows me and it shows zabbixdb and I can also use zabbixdb .

For Pada ::
I tried this ::
mysql -h"localhost" -u"zabbix" -p"Password" zabbixdb

and connected successfully and this Password is all locations like Zabbix server , front end php file .
I also set DBUser=root and restarted file and it shows error in logs ::
FATAL: password authentication failed for user "root"

7210:20170206:143420.041 database is down: reconnecting in 10 seconds
7210:20170206:143430.051 [Z3001] connection to database 'zabbixdb' failed: [0] FATAL: password authentication failed for user "root"
FATAL: password authentication failed for user "root"

Thanks
Mudit

[batchenr]

Dear batchenr and Pada

Thanks to both of you but no luck !!

For batchenr ::

When I try to access mysql using zabbix user , it allows me and it shows zabbixdb and I can also use zabbixdb .

For Pada ::
I tried this ::
mysql -h"localhost" -u"zabbix" -p"Password" zabbixdb

and connected successfully and this Password is all locations like Zabbix server , front end php file .
I also set DBUser=root and restarted file and it shows error in logs ::
FATAL: password authentication failed for user "root"

7210:20170206:143420.041 database is down: reconnecting in 10 seconds
7210:20170206:143430.051 [Z3001] connection to database 'zabbixdb' failed: [0] FATAL: password authentication failed for user "root"
FATAL: password authentication failed for user "root"

Thanks
Mudit

please try to fix mysql like i posted you
mysqlcheck --auto-repair --all-databases -o

and check this file also to see if this is the correct pass :
/etc/zabbix/web/zabbix.conf.php

[mudit.gupta]

Hello batchenr

File :: /etc/zabbix/web/zabbix.conf.php has correct password=Password .

When I try to run :: mysqlcheck --auto-repair --all-databases -o

It is not working Error ::
mysql> mysqlcheck --auto-repair --all-databases -o
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlcheck --auto-repair --all-databases -o' at line 1

And when I run this on ::
root@mudit-VirtualBox:~# mysqlcheck --auto-repair --all-databases -o
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect


Thanks
Mudit

[batchenr]

Hello batchenr

File :: /etc/zabbix/web/zabbix.conf.php has correct password=Password .

When I try to run :: mysqlcheck --auto-repair --all-databases -o

It is not working Error ::
mysql> mysqlcheck --auto-repair --all-databases -o
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlcheck --auto-repair --all-databases -o' at line 1

And when I run this on ::
root@mudit-VirtualBox:~# mysqlcheck --auto-repair --all-databases -o
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect


Thanks
Mudit

seems like you have an issue connect as root- why ?
and you need to run in outside mysql like second example

can you remove the skip-resolve and restart mysql and then try to run the check ?

if you have mysql pass for root then run it like
mysqlcheck -p --auto-repair --all-databases -o

[mudit.gupta]

Hello batchenr

I can connect with mysql as root using mysql -u root -p .
I removed skip-resolve and run the check below and output is showing like this::

root@mudit-VirtualBox:~# mysqlcheck -p --auto-repair --all-databases -o
Enter password:
mysql.columns_priv Table is already up to date
mysql.db OK
mysql.event Table is already up to date
mysql.func Table is already up to date
mysql.general_log
note : The storage engine for the table doesn't support optimize
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host Table is already up to date
mysql.ndb_binlog_index Table is already up to date
mysql.plugin Table is already up to date
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers Table is already up to date
mysql.slow_log
note : The storage engine for the table doesn't support optimize
mysql.tables_priv OK
mysql.time_zone Table is already up to date
mysql.time_zone_leap_second Table is already up to date
mysql.time_zone_name Table is already up to date
mysql.time_zone_transition Table is already up to date
mysql.time_zone_transition_type Table is already up to date
mysql.user OK
zabbixdb.acknowledges
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.actions
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.alerts
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.application_discovery
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.application_prototype
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.application_template
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.applications

Thanks
Mudit

[batchenr]

Hello batchenr

I can connect with mysql as root using mysql -u root -p .
I removed skip-resolve and run the check below and output is showing like this::

root@mudit-VirtualBox:~# mysqlcheck -p --auto-repair --all-databases -o
Enter password:
mysql.columns_priv Table is already up to date
mysql.db OK
mysql.event Table is already up to date
mysql.func Table is already up to date
mysql.general_log
note : The storage engine for the table doesn't support optimize
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host Table is already up to date
mysql.ndb_binlog_index Table is already up to date
mysql.plugin Table is already up to date
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers Table is already up to date
mysql.slow_log
note : The storage engine for the table doesn't support optimize
mysql.tables_priv OK
mysql.time_zone Table is already up to date
mysql.time_zone_leap_second Table is already up to date
mysql.time_zone_name Table is already up to date
mysql.time_zone_transition Table is already up to date
mysql.time_zone_transition_type Table is already up to date
mysql.user OK
zabbixdb.acknowledges
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.actions
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.alerts
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.application_discovery
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.application_prototype
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.application_template
note : Table does not support optimize, doing recreate + analyze instead
status : OK
zabbixdb.applications

Thanks
Mudit

is this all your zabbix DB tables ??
can you post :

mysql -p -D zabbixdb -e "show tables;"
by the way try to connect now and see if there is any changes

[mudit.gupta]

Output of mysql -p -D zabbixdb -e "show tables;"


root@mudit-VirtualBox:~# mysql -p -D zabbixdb -e "show tables;"
Enter password:
+----------------------------+
| Tables_in_zabbixdb |
+----------------------------+
| acknowledges |
| actions |
| alerts |
| application_discovery |
| application_prototype |
| application_template |
| applications |
| auditlog |
| auditlog_details |
| autoreg_host |
| conditions |
| config |
| dbversion |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| group_discovery |
| group_prototype
| groups |
| history |
| history_log |
| history_str |
| history_text |
| history_uint |
| host_discovery |
| host_inventory |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| httpstep |
| httpstepitem |
| httptest |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| interface_discovery |
| item_application_prototype |
| item_condition |
| item_discovery |
| items |
| items_applications |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| mappings |
| media |
| media_type |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opinventory |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| opmessage_usr |
| optemplate |
| profiles |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_history |
| regexps |
| rights |
| screen_user |
| screen_usrgrp |
| screens |
| screens_items |
| scripts |
| service_alarms |
| services |
| services_links |
| services_times |
| sessions |
| slides |
| slideshow_user |
| slideshow_usrgrp |
| slideshows |
| sysmap_element_url |
| sysmap_url |
| sysmap_user |
| sysmap_usrgrp |
| sysmaps |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| timeperiods |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| triggers |
| users |
| users_groups |
| usrgrp |
| valuemaps |
+----------------------------+

[batchenr]

Output of mysql -p -D zabbixdb -e "show tables;"


root@mudit-VirtualBox:~# mysql -p -D zabbixdb -e "show tables;"
Enter password:
+----------------------------+
| Tables_in_zabbixdb |
+----------------------------+
| acknowledges |
| actions |
| alerts |
| application_discovery |
| application_prototype |
| application_template |
| applications |
| auditlog |
| auditlog_details |
| autoreg_host |
| conditions |
| config |
| dbversion |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| group_discovery |
| group_prototype
| groups |
| history |
| history_log |
| history_str |
| history_text |
| history_uint |
| host_discovery |
| host_inventory |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| httpstep |
| httpstepitem |
| httptest |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| interface_discovery |
| item_application_prototype |
| item_condition |
| item_discovery |
| items |
| items_applications |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| mappings |
| media |
| media_type |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opinventory |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| opmessage_usr |
| optemplate |
| profiles |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_history |
| regexps |
| rights |
| screen_user |
| screen_usrgrp |
| screens |
| screens_items |
| scripts |
| service_alarms |
| services |
| services_links |
| services_times |
| sessions |
| slides |
| slideshow_user |
| slideshow_usrgrp |
| slideshows |
| sysmap_element_url |
| sysmap_url |
| sysmap_user |
| sysmap_usrgrp |
| sysmaps |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| timeperiods |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| triggers |
| users |
| users_groups |
| usrgrp |
| valuemaps |
+----------------------------+

please post :
post this info here :
ll /etc/zabbix*
ll /var/run/zabbix*
ll /var/lib/mysql
ll /var/lib/mysql/mysql*
ll /var/lib/mysql/zabbixdb*
df -h
grep ^DB /etc/zabbix/zabbix_server.conf

be sure that you have :
DBHost=localhost" and "DBPort=3306
uncomment

past this also :
cat /etc/zabbix/web/zabbix.conf.php

and
cat /etc/zabbix/zabbix.conf.php