Zabbix-Frontend connection error Remote database on another server.

[vincent1890]

Hello

OS:Ubuntu 18.04 / Zabbix 5.2 / Srv Database MariaDB 5.5.57

Unable to install Zabbix-Frontend this blocks the connection of the database with the error "MySQL server hasgone away" see screenshot
I am trying to install Zabbix Server/Front end on one server and Database is on another server.
Yet on the server the connection to the Database is done correctly see screenshot

My my.cnf

[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# The MariaDB server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-storage-engine = MyISAM
#skip-innodb

# Point the following paths to different dedicated disks
#tmpdir = /tmp/

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

What do I have to do and how do I resolve this please?

Thank

[vincent1890]

I managed to find an alternative to finish the installation of the Frontend-Zabbix but this one is not really top and I would need info to secure this alternative install please.

I all just copy paste the file zabbix.conf.php.example into zabbix.conf.php and replace the Database values but then the setup must surely fill in other values in zabbix.conf.php I guess and probably do other actions but I don’t know which ones so If someone would like to help me or if one of the developer of the frontend sees this message I would like him to help me and that we can solve this problem rather recurring apparently but without solution for the moment.

Thank you and have a good day

[tim.mooney]

When you did the CREATE USER within MariaDB, did you specify 'zabbix'@'your-zabbix-server-fqdn-here' as the user? Did you use the same 'zabbix'@'your-zabbix-server-fqdn-here' when you issued the GRANT statement?

Is there a firewall active on your MariaDB server?

[vincent1890]

When you did the CREATE USER within MariaDB, did you specify 'zabbix'@'your-zabbix-server-fqdn-here' as the user? Did you use the same 'zabbix'@'your-zabbix-server-fqdn-here' when you issued the GRANT statement?

Is there a firewall active on your MariaDB server?

Thank you for your reply @tim.mooney
Unfortunately the MySQL user I think is not in question because as I said in my previous message (which was still not visible without moderation) when I manually create the conf php file everything works fine but I guess i would have to perform other manipulation to properly finish the installation.