Ad Widget

Collapse

Upgrading to Zabbix 1.5 (Using Ubuntu 6.06)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bigZabbixnoob
    Junior Member
    • Feb 2008
    • 5

    #1

    Upgrading to Zabbix 1.5 (Using Ubuntu 6.06)

    I've tried to install Zabbix 1.5 and it's not going so well. Though everything seems to go smoothly, once I finish the install, I get all these errors on the mainpage of the site.

    Code:
        * Error in query [select * from nodes where nodetype=1 order by nodeid] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [SELECT u.* FROM users u WHERE u.alias='guest' AND (u.userid div 100000000000000) in (0) ] [Table 'zabbix.users' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [delete from sessions where sessionid=''] [Table 'zabbix.sessions' doesn't exist]
        * Error in query [SELECT count(u.userid) as user_cnt FROM users u] [Table 'zabbix.users' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select * from nodes where nodeid=0] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select n.nodeid,min(r.permission) as permission, g.userid from nodes n left join rights r on r.id=n.nodeid and r.type=0 left join users_groups g on r.groupid=g.usrgrpid and g.userid=0 where n.nodeid in (0) group by n.nodeid, g.userid order by nodeid desc, userid desc, permission desc] [Table 'zabbix.nodes' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Error in query [select * from config where (configid div 100000000000000) in (0) ] [Table 'zabbix.config' doesn't exist]
        * mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/home/zabbix/public_html/include/db.inc.php:411]
        * Unable to select configuration
    and it says
    [ERROR: Table users is empty. Possible database corruption.]
    I'm pretty confident I put up the database correctly, it isn't my first time making one and I use phpmyadmin =[.

    I really have no idea what I'm doing wrong. There are simply too many documentations for installing other version and none for 1.5 itself. I've tried using the instructions for 1.4 and 1.6. When I use the compiling code for 1.6, it simply isn't able to complete. So, I use the instructions given by the 1.4 doc and it works perfectly until I get past the php page installation.

    Is anyone else having this problem? How can I fix it? Is there a better installation doc out there?

    Thank you in advance .
  • Tenzer
    Senior Member
    • Nov 2007
    • 316

    #2
    It sounds like the configuration of the database settings for the front-end either are wrong, or that you haven't imported the .sql files from the installation. Remember that there are two files that need to be imported, this is in the 1.4 docs.

    Comment

    • bigZabbixnoob
      Junior Member
      • Feb 2008
      • 5

      #3
      It seems you're right =). I created the database but I didn't import anything to it. I didn't realize there was anything to import. I somehow missed that step. I kind of figured that when I installed it that it would just do it by itself if needed.

      Thanks a lot for the help. I have it up and running now.

      Comment

      • suresh
        Junior Member
        • May 2010
        • 1

        #4
        zabbix installation

        how to install the zabbix on centos or fedora

        Comment

        Working...