Ad Widget

Collapse

SQL error on login screen and default login?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rwurttem
    Junior Member
    • Sep 2011
    • 3

    #1

    SQL error on login screen and default login?

    I just installed Zabbix 2.0.0rc2 on a test system. The back-send database is MySQL and the OS is Ubuntu 10.04.4 LTS. I had no issues in compiling Zabbix but after I get everything configured and try to log in, my login screen has the warning:

    Code:
    mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]

    It also looks like the warning pushes the Zabbix logo down over the login prompts (see attachment). Lastly, I can't seem to login with any user name - password configuration.

    -=Raj=-
    Attached Files
  • zalex_ua
    Senior Member
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Oct 2009
    • 1286

    #2
    probably something wrong with installation.
    try to recreate database, check settings in the conf/zabbix.conf.php

    Comment

    • rwurttem
      Junior Member
      • Sep 2011
      • 3

      #3
      I wiped the database and started over, but now I notice that I get an error during the data.sql import.

      Code:
      sudo mysql -D zabbix -uzabbix -pmypassword < data.sql 
      ERROR 1452 (23000) at line 12050: Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))
      What am I doing wrong?

      -=Raj=-

      Comment

      • richlv
        Senior Member
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Oct 2005
        • 3112

        #4
        as per installation instructions, you should import images first
        Zabbix 3.0 Network Monitoring book

        Comment

        • zalex_ua
          Senior Member
          Zabbix Certified Trainer
          Zabbix Certified SpecialistZabbix Certified Professional
          • Oct 2009
          • 1286

          #5
          Yes, it's here: http://www.zabbix.com/documentation/...all/db_scripts
          Read it please <- to ALL

          Comment

          Working...