[rt-users] Error, couldn't load 0 from the users database

[Francisco Amaro]

Hello Kevin

And a user id 1, is there one ? Could it be that someone/something changed
that, a 1 to 0 ?
I've already asked around, and the usual suspects all say that didn't change
anything, and the logs agree with them...

Where is the result from the user 0 fields:

mysql> select * from Users
    -> WHERE id=0
    -> ;
+----+-----------+---------------+----------------------------------------------------------------------------------------+-----------+--------------+---------------------+--------------+----------------------+----------+------+---------------+-------------+-----------------------+-------------------+----------------+------------+-------+-----------+-----------+-------------+------------+----------+----------+------+-------+------+---------+----------+--------+---------+---------------------+---------------+---------------------+
| id | Name      | Password      |
Comments
| Signature | EmailAddress | FreeformContactInfo | Organization |
RealName             | NickName | Lang | EmailEncoding | WebEncoding |
ExternalContactInfoId | ContactInfoSystem | ExternalAuthId | AuthSystem |
Gecos | HomePhone | WorkPhone | MobilePhone | PagerPhone | Address1 |
Address2 | City | State | Zip  | Country | Timezone | PGPKey | Creator |
Created             | LastUpdatedBy | LastUpdated         |
+----+-----------+---------------+----------------------------------------------------------------------------------------+-----------+--------------+---------------------+--------------+----------------------+----------+------+---------------+-------------+-----------------------+-------------------+----------------+------------+-------+-----------+-----------+-------------+------------+----------+----------+------+-------+------+---------+----------+--------+---------+---------------------+---------------+---------------------+
|  0 | RT_System | *NO-PASSWORD* | Do not delete or modify this user. It is
integral to RT's internal database structures | NULL      | NULL         |
NULL                | NULL         | The RT System itself | NULL     | NULL
| NULL          | NULL        | NULL                  | NULL              |
NULL           | NULL       | NULL  | NULL      | NULL      | NULL        |
NULL       | NULL     | NULL     | NULL | NULL  | NULL | NULL    | NULL
| NULL   |       1 | 2006-03-10 17:33:35 |             1 | 2006-03-10
17:33:35 |
+----+-----------+---------------+----------------------------------------------------------------------------------------+-----------+--------------+---------------------+--------------+----------------------+----------+------+---------------+-------------+-----------------------+-------------------+----------------+------------+-------+-----------+-----------+-------------+------------+----------+----------+------+-------+------+---------+----------+--------+---------+---------------------+---------------+---------------------+
1 row in set (0.00 sec)

The user fields seem correct,  the comments, the creation time, etc.
But they refer to a user id 1, that is not on the table anymore.

I'm restoring yesterdays backup on another machine, but given the timelines
it probably has the same error.  That means getting the tape from two days
ago, which is going to take some more time...



On Wed, Aug 24, 2011 at 2:48 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Wed, Aug 24, 2011 at 02:32:10PM +0100, Francisco Amaro wrote:
> >    Hello all,
> >
> >    We are having a problem with our RT install, after a few years of
> almost
> >    flawless service, today we noticed that emails weren't being sent.
> >    We are using version 3.4.5, on Linux (FC4, MySQL 4.1).
> >
> >    The web interface works just fine, we can login, create/modify/close
> tickets,
> >    etc, but no emails are sent.
> >
> >    There is no apparent problem with the machine or the MySQL database,
> >    and this is what appears on the RT log:
> >
> >    [Wed Aug 24 12:23:50 2011] [err]: Couldn't load 0 from the users
> database.
> >    (/opt/rt3/lib/RT/CurrentUser.pm:146)
> >    [Wed Aug 24 12:23:50 2011] [warning]: Use of uninitialized value in
> concatenation (.) or
> >    string at /opt/rt3/lib/RT/Principal_Overlay.pm line 425.
> (/opt/rt3/lib/RT.pm:287)
> >    [Wed Aug 24 12:23:50 2011] [warning]: DBD::mysql::st execute failed:
> You have an error in your
> >    SQL syntax; check the manual that corresponds to your MySQL server
> version for the right
> >    syntax to use near 'AND ((ACL.ObjectType = 'RT::Queue' AND
> ACL.ObjectId = 1) OR
> >    (ACL.ObjectType = 'R' at line 1 at
> /usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm
> >    line 505. (/opt/rt3/lib/RT.pm:287)
> >    [Wed Aug 24 12:23:50 2011] [warning]: RT::Handle=HASH(0x80c27d90)
> couldn't execute the query
> >    'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers ...
> >
> >    And them a few lines of failed SQL syntax erros and failed querys.
> >
> >    We browsed the users table, user ID 0 is there, no problem. A MySQL
> check_table
> >    didn't returned any errors. The only thing we saw that seemed strange
> was that there
> >    is reference to a user 1 on the LastUpdatedBy field, but there is no
> user 1 id.
>
> I'm not aware of an RT version that had a User ID 0.
> Sounds like someone renumbered your RT_System user manually in the
> database, or that you have database corruption.
>
> You can try taking a backup and fixing this manually, but if it is
> corruption, there may be other problems.
>
> -kevin
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Chicago, IL, USA — September 26 & 27, 2011
> *  San Francisco, CA, USA — October 18 & 19, 2011
> *  Washington DC, USA — October 31 & November 1, 2011
> *  Melbourne VIC, Australia — November 28 & 29, 2011
> *  Barcelona, Spain — November 28 & 29, 2011
>



-- 
Francisco Amaro
Email: famaro at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110824/21c6fe99/attachment.htm>