Failed to start Zabbix

[glibao]

Good afternoon everyone, I have made an installation from scratch of zabbix, the last step to start its execution gives me an error, I have been several days and I can't get it to work, I'll pass you what I get in case you can help me. Greetings to everybody and thanks.

root@ubuntu-zabbix:~# sudo systemctl start zabbix-server Job for zabbix-server.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status zabbix-server.service" and "journalctl -xeu zabbix-server.service" for details.

root@ubuntu-zabbix:~# systemctl status zabbix-server.service
● zabbix-server.service - Zabbix Server
Loaded: loaded (/lib/systemd/system/zabbix-server.service; disabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: protocol) since Tue 2022-11-01 13:26:47 UTC; 3s ago
Process: 77955 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
CPU: 28ms


zabbix-server.service: Can't open PID file /run/zabbix/zabbix_server.pid (>
Nov 01 13:27:36 ubuntu-zabbix systemd[1]: zabbix-server.service: Failed with result 'protocol'.

[rvanderkooi]

Hi Glibao,

Looks like your zabbix_server.conf is not correct.
Can you check your file?

Do you have output of /var/log/zabbix_server.log?

[glibao]

Good afternoon: the output of
zabbix_server.log is : 83:20221030:123812.997 using configuration file: /etc/zabbix/zabbix_server.conf
983:20221030:123813.004 [Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users>
983:20221030:123813.004 cannot use database "zabbix": database is not a Zabbix database

and zabbix_agentd.log:
4960:20221030:121012.719 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Conn>
4960:20221030:121012.719 Unable to send heartbeat message to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:100>
4960:20221030:121012.719 Unable to connect to [127.0.0.1]:10051 [cannot connect to [[127.0.0.1]:10051]: [111] Conn>
4960:20221030:121012.719 Active check configuration update started to fail
4955:20221030:123535.926 Got signal [signal:15(SIGTERM),sender_pid:5300,sender_uid:114, reason:0]. Exiting ...
4955:20221030:123535.929 Zabbix Agent stopped. Zabbix 6.2.3 (revision 98ee88fc19d)

+------------------+-----------+
| user | host |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
| zabbix | localhost |
+------------------+-----------+
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+



Thanks.

[cyber]

983:20221030:123813.004 [Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users>
983:20221030:123813.004 cannot use database "zabbix": database is not a Zabbix database

Looks like missing db schema...

[glibao]

thanks for your answer, executed:

# zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
gzip: /usr/share/zabbix-sql-scripts/mysql/server.sql.gz: No such file or directory ?¿?¿?¿?¿?¿?¿?¿?¿

Enter password:

-------------------------------------------------
mysql -uroot -p I authenticate well,

output mysql -h localhost -u zabbix -p -P 3306 -s <<< 'show grants;'

GRANT USAGE ON *.* TO `zabbix`@`localhost`
GRANT ALL PRIVILEGES ON `zabbix`.* TO `zabbix`@`localhost`

output ls -1 /usr/share/doc/zabbix-server-mysql*/

changelog.Debian.gz
copyright



The log show:
[Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users limit 1]


I have been reviewing forum posts and tried, as the scheme is missing, there are directories indicated by the zabbix documentation that do not exist in Ubuntu 22, I have searched to download the create.sql.gz file and I cannot find it either, any suggestions? I use latest version of Ubuntu and Zabbix. Thank you very much

[jucatovi]

Hola estoy instalando zabbix y me paso lo mismo, lo corregi instalando el paquete de "zabbix-sql-scripts"

dnf install zabbix-sql-scripts

luego ejecuta el comando
zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

y listo, a mi me funciono.

[prasadeng]

completely installed Zabbix but Zabbix service does not start systemctl start zabbix-server.service
Job for zabbix-server.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status zabbix-server.service" and "journalctl -xe" for details.
here has page error

[prasadeng]

zabbix service not starting here has error systemctl start zabbix-server.service
Job for zabbix-server.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status zabbix-server.service" and "journalctl -xe" for details.

[prasadeng]

here another screen shot

[Markku]

What does your Zabbix server log file tell you?

Markku