View Full Version : database and frontend
Seems like the frontend (php scripts) and database have to reside on the same machine. Is that right? I my trying to use a log server as my database server and the php scripts are on another server. Was zabbix never meant to work that way?
Nate Bell
10-02-2006, 19:22
As far as I know the frontend and database can exist on seperate machines. You can point the php config file and the zabbix_server at a remote database. Meanwhile, you can host the php files on another server. You just have to grant permission for the webserver to access the remote database.
Nate
nope, you can use a different host for the database
edit the zabbix_frontend_root/include/db.inc.php file
in there you will see definitions for how to connect to your database, change the $DB_SERVER variable from localhost to where you want to host your db.
note: you will also need to configure mysql (I'm guessing that's your database) to allow connections from the machine running the frontend. that's beyond the scope of this reply but you should be able to locate the exact SQL commands in the mysql documentation.
heh
nate, we HAVE to stop meeting like this.. people will start to talk :)
nope, you can use a different host for the database
edit the zabbix_frontend_root/include/db.inc.php file
in there you will see definitions for how to connect to your database, change the $DB_SERVER variable from localhost to where you want to host your db.
That is exactly what I did. And I can log in but all the images are broken. So I cannot see any graphs, screens etc.
? really?
can you get text based representations of your data? (i.e. "latest data")
I'm trying to determine if this is a connection problem or a frontend problem.
at the moment I'm leaning toward connection.
can you do this from the command line of your frontend server as the apache user?:
mysql -h your.database.hostname -u your.zabbix.user --password=your.password your.zabbix.database.name
finally back to working on zabbix. Anyways, I figured out what was wrong. gd was misconfigured. I fixed it and every thing works fine.