Ad Widget

Collapse

The frontend does not match Zabbix database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kamyaba
    Junior Member
    • May 2015
    • 4

    #1

    The frontend does not match Zabbix database

    Hi all,
    Here is some problem that i can't understand how it is going on with it.
    Click image for larger version

Name:	Ashkan_Kamyab.jpg
Views:	1
Size:	86.0 KB
ID:	317201
    It start trouble shooting by editing the zabbix_server.conf
    /etc/zabbix/zabbix_server.conf by clear # and the start of scrips below:
    DBHost=Localhost
    DBName=zabbix
    DBUser=zabbix
    DBPassword=zabbix
    but not works.
    i read some where through the net about setup.php file might be corrupt or something but as I'm newbie in php scripts i didn't follow that threat
  • Atsushi
    Senior Member
    • Aug 2013
    • 2028

    #2
    In order to run the Zabbix server, you need create some tables and import the initial data.

    After installing Zabbix, are you import initial schema and data?


    Comment

    • Kamyaba
      Junior Member
      • May 2015
      • 4

      #3
      Originally posted by Atsushi
      In order to run the Zabbix server, you need create some tables and import the initial data.

      After installing Zabbix, are you import initial schema and data?


      https://www.zabbix.com/documentation...itial_database
      Ye I was did,But now I just tried to do it again and it seems smth went wrong...

      ERROR 1146 (42S02) at line 2993: Table 'zabbix.sysmaps_elements' doesn't exist

      Comment

      • Atsushi
        Senior Member
        • Aug 2013
        • 2028

        #4
        Database that you have created is incorrect.
        Because, that error is table doesn't exist.

        Please tell me how to create a database and how to import data.
        Did you run any kind of procedure?
        Did the specified database name at import?
        Error for MySQL was not output ?

        Please re-create the database if possible is.

        sample operation:
        -----
        # mysql -uroot
        mysql> create database zabbix;
        mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>';
        mysql> quit;
        # cd /usr/share/doc/zabbix-server-mysql-2.4.5/create/
        # mysql -uroot zabbix < schema.sql
        # mysql -uroot zabbix < images.sql
        # mysql -uroot zabbix < data.sql
        -----

        Comment

        • Kamyaba
          Junior Member
          • May 2015
          • 4

          #5
          Originally posted by Atsushi
          Database that you have created is incorrect.
          Because, that error is table doesn't exist.

          Please tell me how to create a database and how to import data.
          Did you run any kind of procedure?
          Did the specified database name at import?
          Error for MySQL was not output ?

          Please re-create the database if possible is.

          sample operation:
          -----
          # mysql -uroot
          mysql> create database zabbix;
          mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>';
          mysql> quit;
          # cd /usr/share/doc/zabbix-server-mysql-2.4.5/create/
          # mysql -uroot zabbix < schema.sql
          # mysql -uroot zabbix < images.sql
          # mysql -uroot zabbix < data.sql
          -----
          Yep my friend
          I tried to create zabbix2 and zabbics as alternative database.but it would be possible to do it again,I'll do it.
          Creating DB and Importing data procedure :

          mysql -u root -p

          mysql> CREATE DATABASE zabbix CHARACTER SET UTF8;
          mysql> GRANT ALL PRIVILEGES on zabbix.* to 'zabbix'@'localhost' IDENTIFIED BY 'SECRET_PASSWORD';
          mysql> FLUSH PRIVILEGES;
          mysql> quit
          ---
          mysql -u zabbix -p zabbix < /usr/share/doc/zabbix-server-mysql-2.2.9/create/schema.sql
          mysql -u zabbix -p zabbix < /usr/share/doc/zabbix-server-mysql-2.2.9/create/images.sql
          mysql -u zabbix -p zabbix < /usr/share/doc/zabbix-server-mysql-2.2.9/create/data.sql

          Thanks budd

          Comment

          Working...