Thanks Kevin, it was exactly that, I changed the ID from 0 to 1 and everything seems to be working now.
On Wed, Aug 24, 2011 at 3:18 PM, Kevin Falcone <[email protected]>wrote: > On Wed, Aug 24, 2011 at 03:07:46PM +0100, Francisco Amaro wrote: > > 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... > > The RT_System user should have an id of 1. > Since LastUpdated isn't updated, this means any change happened at the > DB level, or via corruption. > > -kevin > > > 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 <[1] > [email protected]> 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 ([2] > 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: [3][email protected] > > > > References > > > > Visible links > > 1. mailto:[email protected] > > 2. http://bestpractical.com/services/training.html > > 3. mailto:[email protected] > > > -------- > > 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 > > > -------- > 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: [email protected]
-------- 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
