Ad Widget

Collapse

Critical error. Field [userid] must be missing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alj
    Senior Member
    • Aug 2006
    • 188

    #1

    Critical error. Field [userid] must be missing

    [ERROR:Invalid URL]

    Critical error. Field [userid] must be missing

    ZABBIX 1.1.3 Copyright 2001-2006 by SIA Zabbix | Connected as Admin

    ----------
    I get this error when trying to access "configuration -> users" dialog. Nothing is being displayed besides this error (so no way to edit or see users).


    I checked users, usrgrp and users_groups tables they look just fine, all userid's are presetn, all group ids that "users_groups" refers to are present in groups and users tables. Also all users can log in fine to zabbix.

    Where should i look for the problem?
  • alj
    Senior Member
    • Aug 2006
    • 188

    #2
    In config->actions it tells me:
    Warning. Field [userid] is not integer

    Please give me a hint what db table to look at at least.

    Comment

    • Alexei
      Founder, CEO
      Zabbix Certified Trainer
      Zabbix Certified SpecialistZabbix Certified Professional
      • Sep 2004
      • 5654

      #3
      Please try ZABBIX 1.1.4. I believe the issue is already fixed.
      Alexei Vladishev
      Creator of Zabbix, Product manager
      New York | Tokyo | Riga
      My Twitter

      Comment

      • alj
        Senior Member
        • Aug 2006
        • 188

        #4
        Originally posted by Alexei
        Please try ZABBIX 1.1.4. I believe the issue is already fixed.
        In zabbix 1.1.4 it tells me
        "Warning. Field [userid] is not integer"
        if i go to Configuration -> Actions page.

        It also wont let me change anything on Actions page,

        on Users page it tells:

        [ERROR:Invalid URL]

        Critical error. Field [userid] must be missing

        And displays empty page.

        If i log in as different user then it shows me that i have default permissions for everythin, everything like it suppose to be.

        Everything else works fine.

        Where that error is coming from? What table should i check?

        Comment

        • alj
          Senior Member
          • Aug 2006
          • 188

          #5
          Ok now i see the same problem spreads out to other users.
          I tried couple accounts and nobody can get to the users page anymore.

          Also i have another problem - sometimes zabbix wont send alarm. I see event and rules match against it but action is not being performed (nothing in action log).

          This problem goes on and off. Because of it we missed one server being down during holidays.

          Comment

          • alj
            Senior Member
            • Aug 2006
            • 188

            #6
            More info, i commented out check_fields($fields); in users.php (just to be able to load page) and thats what i got:
            Error in query [select * from users where userid=X|1|4cy6ch1e47nf3gip|6|ofLCfDrV3RMifscWrtG0 6QxyFtD2dDaX] [Unknown column 'X' in 'where clause']
            Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/share/zabbix/include/db.inc.php on line 104

            + 2 more errors of that kind.

            Comment

            • alj
              Senior Member
              • Aug 2006
              • 188

              #7
              I found where the problem is - userid cookie conflict with the other application on the same host.

              It makes sense to call cookie with less common name such as zabbix_userid (and this is related to the other application as well of course).

              Comment

              • Alexei
                Founder, CEO
                Zabbix Certified Trainer
                Zabbix Certified SpecialistZabbix Certified Professional
                • Sep 2004
                • 5654

                #8
                Fixed. Thanks for the provided information!
                Alexei Vladishev
                Creator of Zabbix, Product manager
                New York | Tokyo | Riga
                My Twitter

                Comment

                Working...