Two Zabbix Web connecting to same Database

[leandro.s.teixeira]

I'm thinking of creating another zabbix web server on my dmz network to grant access to my customers, but i need to connect it to same database that is in use by my zabbix.

Maybe the best scenario is to configure a postgresql replica to a ready-only database and this new zabbix web in dmz connect to this replica database.

Someone have already do this? It will works?

[Hamardaban]

Both options will work. And what you want to achieve from the point of view of security?

[leandro.s.teixeira]

Sorry for the delay, i was on vacation.

The database is behind a firewall and we will have some access rules.

I'm trying to connect a new web to the database but it gives a connection error. I tried through pgadmin, telnet and psql, the 3 work correctly but the zabbix web does not. Does anyone know if it is necessary to do some extra configuration?

[Hamardaban]

The UI accesses the database using the settings from the file zabbix.conf.php and php modules. See the connection configuration examples in the zabbix.conf.php.example file and set them according to your psql settings. When trying to connect, look at the firewall (or tcpdump) is there any traffic? If there is no traffic-look in the PHP error log - most likely there is information about the absence of php functions or modules. And of course check whether there are messages in the logs of the web server!

[leandro.s.teixeira]

Thank you for your help.

I validated the configuration of the zabbix.conf.php file and it was correct.

My mistake was simple, I forgot to disable selinux on the web server. Now everything works perfectly,

I will check the security issues with the network team.

Hugs and thanks again.