Ad Widget

Collapse

MySQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • maxijose
    Member
    • May 2007
    • 36

    #1

    MySQL error

    I'm using zabbix for the first time. I've proceeded to the set up and now I want to display the frontend on mozilla but nothing happens!
    When I look at the httpd error_log it tells me:
    [error] [client 127.0.0.1] PHP Fatal error: Call to undefined function mysql_query() in /var/www/html/zabbix/include/db.inc.php on line 269

    It seems to have no problem with mysql_connect ...

    Can anybody help me?
  • abi
    Member
    • Jun 2006
    • 81

    #2
    seems you dont have your php mysql module installed, or you have
    compiled php without mysql support.
    be sure to install your php mysql client module

    Comment

    • maxijose
      Member
      • May 2007
      • 36

      #3
      I have installed php and mysql with yum (I'm on fedora core 6). I don't know if it installed php with mysql support. How could I?

      Comment

      • maxijose
        Member
        • May 2007
        • 36

        #4
        Thanks obi, you were right I forgot to install the php-mysql module.
        Getting back to you in a few minutes

        Comment

        • maxijose
          Member
          • May 2007
          • 36

          #5
          Now I have access to the frontend. but here is what appears at the top of the page
          # mysql_query(): supplied argument is not a valid MySQL-Link resource[/var/www/html/zabbix/include/db.inc.php:269]
          # Error in query [select * from nodes where nodeid=0] []
          # mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/var/www/html/zabbix/include/db.inc.php:396]

          Comment

          • VeryNewbie
            Member
            • Feb 2007
            • 40

            #6
            I have the same problem... does anybody know how to solve it?

            :::::
            mysql_query(): supplied argument is not a valid MySQL-Link resource[/.../apache/htdocs/zabbix/include/db.inc.php:271]
            Error in query [select * from nodes where nodeid=0] []
            mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/.../apache/htdocs/zabbix/include/db.inc.php:398]
            :::::
            tia
            Last edited by VeryNewbie; 05-06-2007, 14:53.

            Comment

            • Niels
              Senior Member
              • May 2007
              • 239

              #7
              Did you go through the web install?

              Comment

              • VeryNewbie
                Member
                • Feb 2007
                • 40

                #8
                no, when I klick on "next" or "cancel", zabbix don't find the webpage...

                Comment

                • maxijose
                  Member
                  • May 2007
                  • 36

                  #9
                  Originally posted by VeryNewbie
                  I have the same problem... does anybody know how to solve it?

                  tia
                  (First I copied the directory php in frontends to /var/www/html/zabbix)

                  In fact, I solved this problem by setting the variable $DB_SERVER to "localhost" in db.inc.php instead of the IP_adress but if you had configured right zabbix_server.conf I think you shouldn't have had this problem.

                  I hope it helped.

                  Comment

                  Working...