Ad Widget

Collapse

problem with mysql database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jimmy4413
    Junior Member
    • Oct 2010
    • 12

    #1

    problem with mysql database

    Good morning to all,

    I'm having a couple of errors in the configuring stages of the install, in the web interface to be exact. First of all my system :
    * RHEL 5
    * MySQL 5.1.51
    * PHP 5.1.67

    Now the errors :

    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.config' doesn't exist]
    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/php/include/db.inc.php:544]
    mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/php/include/db.inc.php:546]
    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.config' doesn't exist]
    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/php/include/db.inc.php:544]
    mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/php/include/db.inc.php:546]
    Undefined variable: css[/var/www/html/php/include/users.inc.php:29]
    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [Table 'zabbix.config' doesn't exist]
    mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/var/www/html/php/include/db.inc.php:544]
    mysql_free_result(): supplied argument is not a valid MySQL result resource[/var/www/html/php/include/db.inc.php:546]

    I'm guessing restricted access to the DB but I already typed this command in MySQL :

    mysql> GRANT DROP,INDEX,CREATE,SELECT,INSERT,UPDATE,ALTER,DELET E ON zabbix.* TO zabbix@localhost IDENTIFIED BY 'zabbix';

    thanks for your replies
  • jimmy4413
    Junior Member
    • Oct 2010
    • 12

    #2
    problem solved!!!!

    stupid me.....the database was inexplicably empty!!!!
    why i dont know but i fixed

    thanks for all of you who thought about my problem

    Comment

    Working...