Hi Mike, I intend no offense, I am just trying to help out, and sometimes we forget to check the easy stuff first (hey we all do some times :) ).
That being said I think we have this figured out: I know it is like a game of 20 questions, but in my current installs 3.8.4 and 3.8.6 with mysql the table USERS does not exist, because the table name is Users. I am not sure if perl dbi is picky about case, but my gut instinct would be that it is, and I know that mysql is picky about case in this sense. Even mysql directly doesn't like case mismatch. select * from `cachemgt`.`USERS`; -- would result in an error because the table USERS doesn't exist -- as a matter of a fact it is the same exact error you are seeing in the logs "Table 'cachemgt.USERS' doesn't exist". select * form `cachemgt`.`Users`; -- works on my instance because the tabke Users does exist. Note that I changed the query to match your database structure. HTH, Thanks, Bill On Wed, Jan 13, 2010 at 3:08 PM, Michael James <[email protected]>wrote: > Bill, that is indeed the RT-database. I posted my RT_SiteConfig.pm file > earlier today if you'd like to peruse it. The rt_user has permissions. > > Thanks, Mike > > >>> William Graboyes <[email protected]> 1/13/2010 5:47 PM > >>> > Hi Mike, > > Asking questions from the questioner. > > Is that a separate database from your RT database? > > If it is a separate database, does your rt db user have access to that > database? > > Just trying to help. > > Thanks, > Bill > > On Wed, Jan 13, 2010 at 2:36 PM, Michael James > <[email protected]>wrote: > > > Thanks, Bill. The database name is cashmgt and the table name is USERS, > > rather than table and column names. In any case, the table does exist. > > > > Mike > > > > >>> William Graboyes <[email protected]> 1/13/2010 5:30 > PM > > >>> > > Hi Mike, > > > > Purely from a log file perspective, I know nothing about external auth, > it > > is saying that the column USERS doesn't exist in the table cachemgmt. It > > looks like it is trying to then recover gracefully, instead of puking all > > over itself and refusing to allow you to log in. > > > > Again purely from the Log File Perspective, I am sure that there are > others > > out there with a massive store of knowledge on external auth, that may > help > > you fix this one. > > > > Thanks, > > Bill > > > > On Wed, Jan 13, 2010 at 2:20 PM, Michael James > > <[email protected]>wrote: > > > > > Hi, I see an error in my /var/log/messages file when I'm logging in to > > this > > > instance of RT. Fresh install of RT 3.8.7 on SLES10 64-bit. What does > > this > > > imply? The mysql database cashmgt exists and I can login with the > default > > > root credentials, I just don't how to interpret the message. > > > > > > Thanks, Mike > > > > > > > > > Jan 13 17:04:41 rt384 RT: DBD::mysql::db selectall_hashref failed: > Table > > > 'cashmgt.USERS' doesn't exist at > > > > > > /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm > > > line 219, <DATA> line 514. > > > > > > (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) > > > Jan 13 17:04:41 rt384 RT: Issuing rollback() for database handle being > > > DESTROY'd without explicit disconnect() at > > > > > > /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm > > > line 219, <DATA> line 514. > > > > > > (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219) > > > Jan 13 17:04:41 rt384 RT: Successful login for root from 172.31.4.144 > > > (/opt/cashmgt/bin/../lib/RT/Interface/Web.pm:430) > > > > > > > > > > > > The information in this message may be proprietary and/or confidential, > > and > > > protected from disclosure. If the reader of this message is not the > > intended > > > recipient, or an employee or agent responsible for delivering this > > message > > > to the intended recipient, you are hereby notified that any > > dissemination, > > > distribution or copying of this communication is strictly prohibited. > If > > you > > > have received this communication in error, please notify Stonebridge > Bank > > > immediately by replying to this message and deleting it from your > > computer. > > > _______________________________________________ > > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > > > Community help: http://wiki.bestpractical.com > > > Commercial support: [email protected] > > > > > > 2010 RT Training Sessions! > > > San Francisco, CA, USA - Feb 22 & 23 > > > Dublin, Ireland - Mar 15 & 16 > > > Boston, MA, USA - April 5 & 6 > > > Washington DC, USA - Oct 25 & 26 > > > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > > Buy a copy at http://rtbook.bestpractical.com > > > > > > > > > The information in this message may be proprietary and/or confidential, > and > > protected from disclosure. If the reader of this message is not the > intended > > recipient, or an employee or agent responsible for delivering this > message > > to the intended recipient, you are hereby notified that any > dissemination, > > distribution or copying of this communication is strictly prohibited. If > you > > have received this communication in error, please notify Stonebridge Bank > > immediately by replying to this message and deleting it from your > computer. > > _______________________________________________ > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > > > Community help: http://wiki.bestpractical.com > > Commercial support: [email protected] > > > > 2010 RT Training Sessions! > > San Francisco, CA, USA - Feb 22 & 23 > > Dublin, Ireland - Mar 15 & 16 > > Boston, MA, USA - April 5 & 6 > > Washington DC, USA - Oct 25 & 26 > > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > > Buy a copy at http://rtbook.bestpractical.com > > > > > The information in this message may be proprietary and/or confidential, and > protected from disclosure. If the reader of this message is not the intended > recipient, or an employee or agent responsible for delivering this message > to the intended recipient, you are hereby notified that any dissemination, > distribution or copying of this communication is strictly prohibited. If you > have received this communication in error, please notify Stonebridge Bank > immediately by replying to this message and deleting it from your computer. > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [email protected] > > 2010 RT Training Sessions! > San Francisco, CA, USA - Feb 22 & 23 > Dublin, Ireland - Mar 15 & 16 > Boston, MA, USA - April 5 & 6 > Washington DC, USA - Oct 25 & 26 > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 & 23 Dublin, Ireland - Mar 15 & 16 Boston, MA, USA - April 5 & 6 Washington DC, USA - Oct 25 & 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
