Ad Widget

Collapse

Problem with web!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Coder
    Member
    • Mar 2007
    • 38

    #1

    Problem with web!

    Please Help!
    Early i use zabbix 1.1.6 and no problem with web and DB
    Now i configured and setup Zabbbix 1.4 and have problems:

    DB Oracle + Zabbix 1.4 +PHP 5.2.1 + Appach2with SSL

    1) When i 1st time start index.php my connect was ok and starting wizard. After all steps were finished successfull i was redirected to https:/xxx.xxx.xxx.xxx/Zabbix/index.php?message=Database%20corrupted,%20missed%2 0default%20user%20'guest'.

    Now when i try connect on any php i also redirected to:
    https:/xxx.xxx.xxx.xxx/Zabbix/index.php?message=Database%20corrupted,%20missed%2 0default%20user%20'guest'

    in DB user guest consist

    2) Also I see erorrs in zabbix_server.log
    14604:20070609:151142 No records in table 'config'.
    14604:20070609:151142 No records in table 'config'.
    14581:20070609:151142 Cannot login with zabbix/XXX@db_name
    Cannot login with zabbix/XXX@db_name

    In table config i have 1 record
    CONFIGID|ALERT_HISTORY|EVENT_HISTORY|REFRESH_UNSUP PORTED|WORK_PERIOD|ALERT_USRGRPID
    1|365|365|600|1-5,00:00-24:00|7

    I see active zabbix sessions in Oracle.

    full log below
    14581:20070609:151141 Starting zabbix_server. ZABBIX 1.4.
    14581:20070609:151141 **** Enabled features ****
    14581:20070609:151141 SNMP monitoring: YES
    14581:20070609:151141 WEB monitoring: YES
    14581:20070609:151141 Jabber notifications: NO
    14581:20070609:151141 **************************
    14591:20070609:151142 server #6 started [Trapper]
    14592:20070609:151142 server #7 started [Trapper]
    14593:20070609:151142 server #8 started [Trapper]
    14595:20070609:151142 server #9 started [Trapper]
    14597:20070609:151142 server #10 started [Trapper]
    14600:20070609:151142 server #11 started [ICMP pinger]
    14602:20070609:151142 server #12 started [Alerter]
    14604:20070609:151142 server #13 started [Housekeeper]
    14604:20070609:151142 Executing housekeeper
    14605:20070609:151142 server #14 started [Timer]
    14609:20070609:151142 server #16 started [Node watcher. Node ID:0]
    14611:20070609:151142 server #18 started [HTTP Poller]
    14612:20070609:151142 server #19 started [HTTP Poller]
    14613:20070609:151142 server #20 started [HTTP Poller]
    14614:20070609:151142 server #21 started [HTTP Poller]
    14581:20070609:151142 server #0 started [Watchdog]
    14610:20070609:151142 server #17 started [HTTP Poller]
    14604:20070609:151142 Deleted 0 records from history and trends
    14604:20070609:151142 No records in table 'config'.
    14604:20070609:151142 No records in table 'config'.
    14581:20070609:151142 Cannot login with zabbix/XXX@db_name
    Cannot login with zabbix/XXX@db_name
    14607:20070609:151142 server #15 started [Poller for unreachable hosts. SNMP:ON]
    14587:20070609:151142 server #2 started [Poller. SNMP:ON]
    14588:20070609:151142 server #3 started [Poller. SNMP:ON]
  • gaston
    Junior Member
    • Feb 2007
    • 6

    #2
    I have exactly the same problem except that I work with mysql and I don't have any pre-defined user (guest was removed and admin was renamed). Have you found a workaround?

    Comment

    • gaston
      Junior Member
      • Feb 2007
      • 6

      #3
      SO!

      I have probably found something. The first thing you have to check is if the query

      select u.*
      from users u
      where u.alias='guest' and (u.userid div 100000000000000)=0

      returns something... If not, check the content of your table users with:

      SELECT * FROM users;

      You must recieve a user "guest" with userid=0. If not, either add one with for exemple :

      INSERT INTO users (userid,alias,name,surname,passwd,url,autologout,l ang,refresh,type)
      VALUES
      (0,'guest','guest','guest','','',360,'en_gb',30,1) ;

      Or change the userid with

      UPDATE users
      SET userid=0
      WHERE users='guest'
      ;

      Comment

      • Coder
        Member
        • Mar 2007
        • 38

        #4
        Many thanks.
        Addition of the user guest with userid =0 has helped, now index.php is loaded normally.

        But I can't login under any user (has created a few new in a DB), even with the empty password.
        [ERROR: Login name or password is incorrect]
        What problem may be?

        Do you have somebody correct DB-shema and default values for Oracle?
        There are many errors in shema and data in Zabbix package!

        Comment

        Working...