Ad Widget

Collapse

Ошибка при открытие веб-интерфейса

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tom-ek
    Junior Member
    • Nov 2011
    • 4

    #1

    Ошибка при открытие веб-интерфейса

    Добрый день.

    При заходе на веб-интерфейса Zabbix, вверху окна аутентификации выходит ошибка:
    Code:
    Error in query [UPDATE sessions SET lastaccess=1320293591 WHERE sessionid='f1ce8ddc49ff8f57f7a9a1b153c1c79b'] [Lost connection to MySQL server during query]
    Error in query [DELETE FROM sessions WHERE userid=2 AND status=0 AND lastaccess<1320292691] [MySQL server has gone away]
    Error in query [SELECT g.usrgrpid FROM usrgrp g, users_groups ug WHERE ug.userid = 2 AND g.usrgrpid = ug.usrgrpid AND g.debug_mode = 1 LIMIT 1 OFFSET 0] [MySQL server has gone away]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [MySQL server has gone away]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    Unable to select configuration
    Error in query [SELECT * FROM profiles WHERE userid=2 AND ((profileid BETWEEN 000000000000000 AND 099999999999999)) ORDER BY userid ASC, profileid ASC] [MySQL server has gone away]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [MySQL server has gone away]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    Unable to select configuration
    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [MySQL server has gone away]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    Unable to select configuration
    Undefined variable: css[/usr/local/www/zabbix/include/users.inc.php:29]
    Error in query [SELECT * FROM config WHERE ((configid BETWEEN 000000000000000 AND 099999999999999))] [MySQL server has gone away]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    Unable to select configuration

    При попытки аунтентификации выходит:

    Code:
    mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)[/usr/local/www/zabbix/include/db.inc.php:58]
    Заранее спасибо за помощь!
  • dima_dm
    Senior Member
    • Dec 2009
    • 2697

    #2
    MySQL сервер у вас работает?
    Правильно указаны параметры подключения к MySQL?
    Можете ли Вы подключиться к MySQL с этими параметрами и посмотреть содержимое таблиц базы zabbix?
    Загружены ли данные в MySQL базу?

    Comment

    • dotneft
      Senior Member
      • Nov 2008
      • 699

      #3
      вариантов много...
      1. проверить наличие сокета по указанному пути (только если локальный сервер иначе прописывать хост)
      2. проверить права доступа к этому сокету.
      3. Проверить таймаут на соединение с базой.

      Comment

      Working...