Ad Widget

Collapse

DB type not set, Zabbix is temporarily not available.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rehmy082
    Junior Member
    • Jan 2013
    • 4

    #1

    DB type not set, Zabbix is temporarily not available.

    I'm getting these errors while configuring and running zabbix server.

    DB type is not set

    Zabbix is temporarily unavailable in pop up.

    Please help!!

    - New Bee
  • herta
    Senior Member
    • Sep 2011
    • 101

    #2
    need more info

    What OS? Which db type? Which Zabbix version? How did you install/configure it? ...

    Comment

    • heaje
      Senior Member
      Zabbix Certified Specialist
      • Sep 2009
      • 325

      #3
      I assume you're seeing that in the web GUI and not the log file. My guess without more details of what you're trying to do is that you didn't properly set the DB type in your zabbix.conf.php file for the web interface.

      The $DB['TYPE'] variable in that file must be set to a valid DB type. For instance, for MySQL the variable is set like this:

      $DB['TYPE'] = 'MYSQL';

      That file is usually located in the zabbix web root under the "conf" directory. Some Linux distros move that into /etc/zabbix/web though.

      Comment

      • rehmy082
        Junior Member
        • Jan 2013
        • 4

        #4
        [root@master ~]# yum --enablerepo=epel -y install zabbix-server-mysql zabbix-agent zabbix-web-mysql # install from EPEL
        # create a database for ZABBIX
        [root@master ~]# mysql -u root -p
        Enter password:
        Welcome to the MySQL monitor. Commands end with ; or \g.
        Your MySQL connection id is 3
        Server version: 5.1.52 Source distribution
        Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
        This software comes with ABSOLUTELY NO WARRANTY. This is free software,
        and you are welcome to modify and redistribute it under the GPL v2 license
        Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
        mysql> create database zabbix;
        Query OK, 1 row affected (0.00 sec)
        mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'password';
        Query OK, 0 rows affected (0.00 sec)
        mysql> flush privileges;
        Query OK, 0 rows affected (0.00 sec)
        mysql> exit
        Bye
        [root@master ~]# cd /usr/share/doc/zabbix-server-mysql-*/create/schema
        [root@master schema]# cat mysql.sql | mysql -u root -p zabbix
        Enter password:# MySQL root password
        [root@master schema]# cd ../data
        [root@master data]# cat data.sql | mysql -u root -p zabbix
        Enter password:
        [root@master data]# cat images_mysql.sql | mysql -u root -p zabbix
        Enter password:
        [root@master data]# cd
        [root@master ~]# vi /etc/zabbix/zabbix_server.conf
        # line 110: uncomment and add DB password for Zabbix
        DBPassword=password
        [root@master ~]# vi /etc/zabbix/zabbix_agentd.conf
        # line 91: change to your hostname
        Hostname=master.server.world
        [root@master ~]# vi /etc/php.ini
        # line 440: change to Zabbix recomended
        max_execution_time = 600
        # line 449: change to Zabbix recomended
        max_input_time = 600
        # line 457: change to Zabbix recomended
        memory_limit = 256M
        # line 729: change to Zabbix recomended
        post_max_size = 32M
        # line 878: change to Zabbix recomended
        upload_max_filesize = 16M
        # line 946: uncomment and add your timezone
        date.timezone = Asia/Tokyo
        [root@master ~]# vi /etc/httpd/conf.d/zabbix.conf
        Alias /zabbix /usr/share/zabbix
        <Directory "/usr/share/zabbix">
        Options FollowSymLinks
        AllowOverride None
        Order allow,deny
        Allow from 10.0.0.0/24 # change to the range you allow to access
        </Directory>
        [root@master ~]# /etc/rc.d/init.d/zabbix-server start
        Starting ZABBIX server:[ OK ]
        [root@master ~]# /etc/rc.d/init.d/zabbix-agent start
        Starting ZABBIX agent:[ OK ]
        [root@master ~]# /etc/rc.d/init.d/httpd restart
        Stopping httpd:[ OK ]
        Starting httpd:[ OK ]
        [root@master ~]# chkconfig zabbix-server on
        [root@master ~]# chkconfig zabbix-agent on

        Comment

        • rehmy082
          Junior Member
          • Jan 2013
          • 4

          #5
          above are the steps i followed....

          centos 5.5 version...

          zabbix 1.8.1 server

          Comment

          • heaje
            Senior Member
            Zabbix Certified Specialist
            • Sep 2009
            • 325

            #6
            the error you see is for the web GUI, not any of the daemons (I assume). in the steps you showed, you did not do any configuration for the web GUI. please edit the file I mentioned in my previous post. Also, version 1.8.1 is really old. if this is for a new installation, I recommend using the 2.0.x series.

            Comment

            Working...