[rt-users] Another RT::Authen::ExternalAuth question

Wed Jan 13 18:23:47 EST 2010

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
<MJames at stonebridgebank.com>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 <william.graboyes at theportalgrp.com> 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
> <MJames at stonebridgebank.com>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 <william.graboyes at theportalgrp.com> 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
> > <MJames at stonebridgebank.com>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: sales at bestpractical.com
> > >
> > > 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: sales at bestpractical.com
> >
> > 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: sales at bestpractical.com
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100113/76775b12/attachment.htm>