Ad Widget

Collapse

database and frontend

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • turi
    Junior Member
    • Feb 2006
    • 13

    #1

    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
    Senior Member
    • Feb 2005
    • 141

    #2
    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

    Comment

    • elkor
      Senior Member
      • Jul 2005
      • 299

      #3
      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.

      Comment

      • elkor
        Senior Member
        • Jul 2005
        • 299

        #4
        heh

        nate, we HAVE to stop meeting like this.. people will start to talk

        Comment

        • turi
          Junior Member
          • Feb 2006
          • 13

          #5
          Originally posted by elkor
          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.

          Comment

          • elkor
            Senior Member
            • Jul 2005
            • 299

            #6
            ? 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

            Comment

            • turi
              Junior Member
              • Feb 2006
              • 13

              #7
              finally back to working on zabbix. Anyways, I figured out what was wrong. gd was misconfigured. I fixed it and every thing works fine.

              Comment

              Working...