Zabbix Cannot connect to the database

[baloc90]

Now please edit the /etc/zabbix/zabbix_server.conf, and correct DBPassword=<password>
here goes your password from zabbix DB user you created

after that

systemctl start zabbix-server

and please provide th following output after that

tail /var/log/zabbix/zabbix_server.log

[kaspars.mednis]

Seems some problems with semaphores

If its only a test system, and selinux is disabled, try removing all semaphores, and then start zabbix-server again

getenforce
ipcrm -a
systemctl start zabbix-server
tail /etc/zabbix/zabbix-server.log

provide the output please

[baloc90]

Seems some problems with semaphores

If its only a test system, and selinux is disabled, try removing all semaphores, and then start zabbix-server again

getenforce
ipcrm -a
systemctl start zabbix-server
tail /etc/zabbix/zabbix-server.log

provide the output please

[kaspars.mednis]

Sorry,

 tail /var/log/zabbix/zabbix_server.log

[baloc90]

Sorry,

 tail /var/log/zabbix/zabbix_server.log

Dear Kaspars,
When i run the above command there is error.

[kaspars.mednis]

Hello !

it seems a problem on OS level with semaphores
Provide please output of commands below

ipcs -su

cat /proc/sys/kernel/sem

[baloc90]

Hello !

it seems a problem on OS level with semaphores
Provide please output of commands below

ipcs -su

cat /proc/sys/kernel/sem

Dear Kaspars,

[kaspars.mednis]

You have run out of semaphore arrays

used arrays = 128
SEMMNI = 128

You can read more about this problem here

https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/5/html/Tuning_and_Optimizing_Red_Hat_Enterprise_Linux_for_Oracle_9i_and_10g_Databases/sect-Oracle_9i_and_10g_Tuning_Guide-Setting_Semaphores-Setting_Semaphore_Parameters.html

SEMMSL maximum number of semaphores per array
SEMMNS maximum semaphores system-wide
SEMOPM maximum operations per semop call
SEMMNI maximum arrays

you can try the following command without rebooting your system

sysctl -w kernel.sem="250 32000 100 256"

and try to start zabbix-server after the change

if everything works as expected, make the change permanent

echo "kernel.sem=250 32000 100 256" >> /etc/sysctl.conf

Regards,
Kaspars

[baloc90]

You have run out of semaphore arrays

used arrays = 128
SEMMNI = 128

You can read more about this problem here

https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/5/html/Tuning_and_Optimizing_Red_Hat_Enterprise_Linux_for_Oracle_9i_and_10g_Databases/sect-Oracle_9i_and_10g_Tuning_Guide-Setting_Semaphores-Setting_Semaphore_Parameters.html

SEMMSL maximum number of semaphores per array
SEMMNS maximum semaphores system-wide
SEMOPM maximum operations per semop call
SEMMNI maximum arrays

you can try the following command without rebooting your system

sysctl -w kernel.sem="250 32000 100 256"

and try to start zabbix-server after the change

if everything works as expected, make the change permanent

echo "kernel.sem=250 32000 100 256" >> /etc/sysctl.conf

Regards,
Kaspars

Dear Kaspars,
Still cannot

[Atsushi]

You have not been able to create a database for Zabbix.
Did not you just create a table before?
Please try creating a database again.

# mysql -u root -p
mysql> drop database zabbix;
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>';
mysql> quit
# zcat /usr/share/doc/zabbix-server-mysql-3.4.4/create.sql.gz | mysql -uzabbix -p zabbix

[kaspars.mednis]

Zabbix Server cannot work with a zabbix proxy database

You somehow managed to made a zabbix proxy, not a zabbix server database
They are completely diferent DBs for different purpouses

Because your database is empty, i suggest you do the following steps

mysql
drop database zabbix;
create database zabbix character set utf8 collate utf8_bin;
grant all privileges on zabbix.* to zabbix@localhost identified by '<password>';
quit;
cat /usr/share/doc/zabbix-server-mysql-3.4.4/create.sql.gz | mysql zabbix -uzabbix -p

[baloc90]

thank you guys for the support. I logged in admin / password but it does not work.

[kaspars.mednis]

https://www.zabbix.com/documentation/3.4/manual/quickstart/login

This is the Zabbix “Welcome” screen. Enter the user name Admin with password zabbix to log in as a Zabbix superuser.

[baloc90]

Thanks all,
There are differences between admin and Admin.

[baloc90]

Dear Kaspars,
I will learn more. However,I thank you very much for your support.Once again thank you so much.
Regards,