Dear all, i need your guidens.
Maybe I'm just too stupid to solve my problem, so I'm relying on your help!
I installed Zabbix 6.0 LTS on an Ubuntu 20.04 LTS following the instructions on the Zabbix website. After successful installation, I had a database version problem, which I fixed, so that in the end all the checkpoints were green in the installation. I also stored the MySQL passwords in the config files according to all instructions. -> MySQL & NGINX
PROBLEM:
login website builds quite normally and redirects me to /index.php. After trying to log in with the definitely correct credentials Admin and zabbix, the error message “Login name or password is incorrect” (picture 1) keeps appearing. The interesting thing is that I can't find a log of these login attempts and when I look at the database (picture 2) I don't see any incorrect login attempts. I have already made sure that the DB user and password are correct because I was able to log in manually with these credentials.
MySQL Log:
2024-02-18T07:38:03.992294Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysql>
2024-02-18T07:38:03.992352Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.34-0ubuntu0.20.04.1' socket: '/var/ru>
2024-02-18T07:38:14.799924Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.34-0ubuntu0>
2024-02-18T07:38:16.801064Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 16 user: 'zabbix'.
2024-02-18T07:38:16.801199Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 8 user: 'zabbix'.
2024-02-18T07:38:16.801282Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 9 user: 'zabbix'.
2024-02-18T07:38:16.801319Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 10 user: 'zabbix'.
2024-02-18T07:38:16.801420Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 19 user: 'zabbix'.
2024-02-18T07:38:16.801492Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 12 user: 'zabbix'.
2024-02-18T07:38:16.801531Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 13 user: 'zabbix'.
2024-02-18T07:38:16.801599Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 14 user: 'zabbix'.
2024-02-18T07:38:16.801641Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 15 user: 'zabbix'.
2024-02-18T07:38:17.385979Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34-0ubuntu0.20.04.1) (Ubuntu).
2024-02-18T07:38:36.493652Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.20.04.1) starting as process 96185
2024-02-18T07:38:36.499795Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-18T07:38:36.754855Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-18T07:38:36.929460Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-02-18T07:38:36.929497Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for thi>
2024-02-18T07:38:36.943477Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysql>
2024-02-18T07:38:36.943547Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.34-0ubuntu0.20.04.1' socket: '/var/ru>
nginx.conf:
server {
listen 80;
listen 443;
server_name FWZabbix.was.home;
root /usr/share/zabbix;
index index.php;
location = /favicon.ico {
log_not_found off;
}
location / {
try_files $uri $uri/ =404;
}
location /assets {
access_log off;
expires 10d;
}
location ~ /\.ht {
deny all;
}
location ~ /(api\/|conf[^\.]|include|locale) {
deny all;
return 404;
}
location /vendor {
deny all;
return 404;
}
location ~ [^/]\.php(/|$) {
fastcgi_pass unix:/var/run/php/zabbix.sock;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
fastcgi_index index.php;
php-fpm.conf:
[zabbix]
user = www-data
group = www-data
listen = /var/run/php/zabbix.sock
listen.owner = www-data
listen.allowed_clients = 127.0.0.1,10.250.250.20
pm = dynamic
pm.max_children = 50
pm.start_servers = 5
pm.min_spare_servers = 5
pm.max_spare_servers = 35
pm.max_requests = 200
php_value[session.save_handler] = files
php_value[session.save_path] = /var/lib/php/sessions/
php_value[max_execution_time] = 300
php_value[memory_limit] = 128M
php_value[post_max_size] = 16M
php_value[upload_max_filesize] = 2M
php_value[max_input_time] = 300
php_value[max_input_vars] = 10000
php_value[date.timezone] = Europe/Riga
zabbix.conf.php:
<?php
// Zabbix GUI configuration file.
global $DB;
$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = '127.0.0.1';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'newzabbix';
$DB['USER'] = 'newzabbix';
$DB['PASSWORD'] = 'mySQLPass!123b-not Real';
// Schema name. Used for IBM DB2 and PostgreSQL.
$DB['SCHEMA'] = '';
$ZBX_SERVER = '10.250.250.20';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = '';
$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
Maybe I'm just too stupid to solve my problem, so I'm relying on your help!
I installed Zabbix 6.0 LTS on an Ubuntu 20.04 LTS following the instructions on the Zabbix website. After successful installation, I had a database version problem, which I fixed, so that in the end all the checkpoints were green in the installation. I also stored the MySQL passwords in the config files according to all instructions. -> MySQL & NGINX
PROBLEM:
login website builds quite normally and redirects me to /index.php. After trying to log in with the definitely correct credentials Admin and zabbix, the error message “Login name or password is incorrect” (picture 1) keeps appearing. The interesting thing is that I can't find a log of these login attempts and when I look at the database (picture 2) I don't see any incorrect login attempts. I have already made sure that the DB user and password are correct because I was able to log in manually with these credentials.
MySQL Log:
2024-02-18T07:38:03.992294Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysql>
2024-02-18T07:38:03.992352Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.34-0ubuntu0.20.04.1' socket: '/var/ru>
2024-02-18T07:38:14.799924Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.34-0ubuntu0>
2024-02-18T07:38:16.801064Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 16 user: 'zabbix'.
2024-02-18T07:38:16.801199Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 8 user: 'zabbix'.
2024-02-18T07:38:16.801282Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 9 user: 'zabbix'.
2024-02-18T07:38:16.801319Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 10 user: 'zabbix'.
2024-02-18T07:38:16.801420Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 19 user: 'zabbix'.
2024-02-18T07:38:16.801492Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 12 user: 'zabbix'.
2024-02-18T07:38:16.801531Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 13 user: 'zabbix'.
2024-02-18T07:38:16.801599Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 14 user: 'zabbix'.
2024-02-18T07:38:16.801641Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 15 user: 'zabbix'.
2024-02-18T07:38:17.385979Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34-0ubuntu0.20.04.1) (Ubuntu).
2024-02-18T07:38:36.493652Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.20.04.1) starting as process 96185
2024-02-18T07:38:36.499795Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-18T07:38:36.754855Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-18T07:38:36.929460Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-02-18T07:38:36.929497Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for thi>
2024-02-18T07:38:36.943477Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysql>
2024-02-18T07:38:36.943547Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.34-0ubuntu0.20.04.1' socket: '/var/ru>
nginx.conf:
server {
listen 80;
listen 443;
server_name FWZabbix.was.home;
root /usr/share/zabbix;
index index.php;
location = /favicon.ico {
log_not_found off;
}
location / {
try_files $uri $uri/ =404;
}
location /assets {
access_log off;
expires 10d;
}
location ~ /\.ht {
deny all;
}
location ~ /(api\/|conf[^\.]|include|locale) {
deny all;
return 404;
}
location /vendor {
deny all;
return 404;
}
location ~ [^/]\.php(/|$) {
fastcgi_pass unix:/var/run/php/zabbix.sock;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
fastcgi_index index.php;
php-fpm.conf:
[zabbix]
user = www-data
group = www-data
listen = /var/run/php/zabbix.sock
listen.owner = www-data
listen.allowed_clients = 127.0.0.1,10.250.250.20
pm = dynamic
pm.max_children = 50
pm.start_servers = 5
pm.min_spare_servers = 5
pm.max_spare_servers = 35
pm.max_requests = 200
php_value[session.save_handler] = files
php_value[session.save_path] = /var/lib/php/sessions/
php_value[max_execution_time] = 300
php_value[memory_limit] = 128M
php_value[post_max_size] = 16M
php_value[upload_max_filesize] = 2M
php_value[max_input_time] = 300
php_value[max_input_vars] = 10000
php_value[date.timezone] = Europe/Riga
zabbix.conf.php:
<?php
// Zabbix GUI configuration file.
global $DB;
$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = '127.0.0.1';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'newzabbix';
$DB['USER'] = 'newzabbix';
$DB['PASSWORD'] = 'mySQLPass!123b-not Real';
// Schema name. Used for IBM DB2 and PostgreSQL.
$DB['SCHEMA'] = '';
$ZBX_SERVER = '10.250.250.20';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = '';
$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;