ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    New Zabbix install with Separate MariaDB database

    IT Discussion
    zabbix 3.0 zabbix zabbix server mariadb
    3
    25
    14.6k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • antonitA
      antonit @scottalanmiller
      last edited by antonit

      @scottalanmiller # service zabbix-server start

      1 Reply Last reply Reply Quote 0
      • scottalanmillerS
        scottalanmiller
        last edited by

        Feb 18 16:56:31 lab-lnx-zabbix systemd: zabbix-server.service failed.
        Feb 18 16:56:41 lab-lnx-zabbix systemd: zabbix-server.service holdoff time over, scheduling restart.
        Feb 18 16:56:41 lab-lnx-zabbix systemd: Starting Zabbix Server...
        Feb 18 16:56:41 lab-lnx-zabbix systemd: PID file /run/zabbix/zabbix_server.pid not readable (yet?) after start.
        Feb 18 16:56:41 lab-lnx-zabbix systemd: Started Zabbix Server.
        Feb 18 16:56:41 lab-lnx-zabbix systemd: zabbix-server.service: main process exited, code=exited, status=1/FAILURE
        Feb 18 16:56:41 lab-lnx-zabbix kill: Usage:
        Feb 18 16:56:41 lab-lnx-zabbix kill: kill [options] <pid|name> [...]
        Feb 18 16:56:41 lab-lnx-zabbix kill: Options:
        Feb 18 16:56:41 lab-lnx-zabbix kill: -a, --all              do not restrict the name-to-pid conversion to processes
        Feb 18 16:56:41 lab-lnx-zabbix kill: with the same uid as the present process
        Feb 18 16:56:41 lab-lnx-zabbix kill: -s, --signal <sig>     send specified signal
        Feb 18 16:56:41 lab-lnx-zabbix kill: -q, --queue <sig>      use sigqueue(2) rather than kill(2)
        Feb 18 16:56:41 lab-lnx-zabbix kill: -p, --pid              print pids without signaling them
        Feb 18 16:56:41 lab-lnx-zabbix kill: -l, --list [=<signal>] list signal names, or convert one to a name
        Feb 18 16:56:41 lab-lnx-zabbix kill: -L, --table            list signal names and numbers
        Feb 18 16:56:41 lab-lnx-zabbix kill: -h, --help     display this help and exit
        Feb 18 16:56:41 lab-lnx-zabbix kill: -V, --version  output version information and exit
        Feb 18 16:56:41 lab-lnx-zabbix kill: For more details see kill(1).
        Feb 18 16:56:41 lab-lnx-zabbix systemd: zabbix-server.service: control process exited, code=exited status=1
        Feb 18 16:56:41 lab-lnx-zabbix systemd: Unit zabbix-server.service entered failed state.
        Feb 18 16:56:41 lab-lnx-zabbix systemd: zabbix-server.service failed.
        
        1 Reply Last reply Reply Quote 0
        • scottalanmillerS
          scottalanmiller
          last edited by

          Here is the Zabbix log now...

           15247:20160218:170737.082 using configuration file: /etc/zabbix/zabbix_server.conf
           15247:20160218:170737.086 [Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users limit 1]
           15247:20160218:170737.086 cannot use database "zabbix": database is not a Zabbix database
          

          To me, it looks like the Zabbix SQL Script has not yet been run against the database server to set up the database.

          1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller
            last edited by scottalanmiller

            Suspiciouns confirmed...

            MariaDB [zabbix]> show tables;
            Empty set (0.00 sec)
            
            1 Reply Last reply Reply Quote 0
            • scottalanmillerS
              scottalanmiller
              last edited by

              And there we go, just needed the database installed:

              zcat /usr/share/doc/zabbix-server-mysql-3.0.0/create.sql.gz | mysql -uzabbix -hmaria -ppassword zabbix
              

              Up and running.

              1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller
                last edited by

                Now here is the issue, very odd...

                zabbix database issue

                1 Reply Last reply Reply Quote 1
                • scottalanmillerS
                  scottalanmiller
                  last edited by

                  nothing goes to the logs when this fails, very frustrating.

                  1 Reply Last reply Reply Quote 1
                  • scottalanmillerS
                    scottalanmiller
                    last edited by

                    Can't find any reason why it is not connecting to the database and there is zip in the logs. Not impressed with how it handles this situation.

                    dafyreD 1 Reply Last reply Reply Quote 0
                    • dafyreD
                      dafyre @scottalanmiller
                      last edited by

                      @scottalanmiller said:

                      Can't find any reason why it is not connecting to the database and there is zip in the logs. Not impressed with how it handles this situation.

                      On the Remote mysql server, make sure the zabbix user has been created, and that flush privileges has been run.

                      grant all on zabbix.* to zabbix identified by 'xibbaz'; 
                      flush privileges;
                      
                      1 Reply Last reply Reply Quote 0
                      • scottalanmillerS
                        scottalanmiller
                        last edited by

                        Switched to the local database, all of the same settings. Worked instantly. From what I can tell, this is a Zabbix flaw.

                        1 Reply Last reply Reply Quote 1
                        • 1
                        • 2
                        • 2 / 2
                        • First post
                          Last post