Hi Mike,<br><br>Asking questions from the questioner.<br><br>Is that a separate database from your RT database?<br><br>If it is a separate database, does your rt db user have access to that database?<br><br>Just trying to help.<br>
<br>Thanks,<br>Bill<br><br><div class="gmail_quote">On Wed, Jan 13, 2010 at 2:36 PM, Michael James <span dir="ltr"><<a href="mailto:MJames@stonebridgebank.com">MJames@stonebridgebank.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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.<br>
<br>
Mike<br>
<br>
>>> William Graboyes <<a href="mailto:william.graboyes@theportalgrp.com">william.graboyes@theportalgrp.com</a>> 1/13/2010 5:30 PM >>><br>
<div><div></div><div class="h5">Hi Mike,<br>
<br>
Purely from a log file perspective, I know nothing about external auth, it<br>
is saying that the column USERS doesn't exist in the table cachemgmt. It<br>
looks like it is trying to then recover gracefully, instead of puking all<br>
over itself and refusing to allow you to log in.<br>
<br>
Again purely from the Log File Perspective, I am sure that there are others<br>
out there with a massive store of knowledge on external auth, that may help<br>
you fix this one.<br>
<br>
Thanks,<br>
Bill<br>
<br>
On Wed, Jan 13, 2010 at 2:20 PM, Michael James<br>
<<a href="mailto:MJames@stonebridgebank.com">MJames@stonebridgebank.com</a>>wrote:<br>
<br>
> Hi, I see an error in my /var/log/messages file when I'm logging in to this<br>
> instance of RT. Fresh install of RT 3.8.7 on SLES10 64-bit. What does this<br>
> imply? The mysql database cashmgt exists and I can login with the default<br>
> root credentials, I just don't how to interpret the message.<br>
><br>
> Thanks, Mike<br>
><br>
><br>
> Jan 13 17:04:41 rt384 RT: DBD::mysql::db selectall_hashref failed: Table<br>
> 'cashmgt.USERS' doesn't exist at<br>
> /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm<br>
> line 219, <DATA> line 514.<br>
> (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219)<br>
> Jan 13 17:04:41 rt384 RT: Issuing rollback() for database handle being<br>
> DESTROY'd without explicit disconnect() at<br>
> /opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm<br>
> line 219, <DATA> line 514.<br>
> (/opt/cashmgt/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/DBI.pm:219)<br>
> Jan 13 17:04:41 rt384 RT: Successful login for root from 172.31.4.144<br>
> (/opt/cashmgt/bin/../lib/RT/Interface/Web.pm:430)<br>
><br>
><br>
><br>
> The information in this message may be proprietary and/or confidential, and<br>
> protected from disclosure. If the reader of this message is not the intended<br>
> recipient, or an employee or agent responsible for delivering this message<br>
> to the intended recipient, you are hereby notified that any dissemination,<br>
> distribution or copying of this communication is strictly prohibited. If you<br>
> have received this communication in error, please notify Stonebridge Bank<br>
> immediately by replying to this message and deleting it from your computer.<br>
> _______________________________________________<br>
> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
><br>
> Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
> Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
><br>
> 2010 RT Training Sessions!<br>
> San Francisco, CA, USA - Feb 22 & 23<br>
> Dublin, Ireland - Mar 15 & 16<br>
> Boston, MA, USA - April 5 & 6<br>
> Washington DC, USA - Oct 25 & 26<br>
><br>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
> Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br>
><br>
<br>
<br>
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.<br>
_______________________________________________<br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
Community help: <a href="http://wiki.bestpractical.com" target="_blank">http://wiki.bestpractical.com</a><br>
Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
<br>
2010 RT Training Sessions!<br>
San Francisco, CA, USA - Feb 22 & 23<br>
Dublin, Ireland - Mar 15 & 16<br>
Boston, MA, USA - April 5 & 6<br>
Washington DC, USA - Oct 25 & 26<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com" target="_blank">http://rtbook.bestpractical.com</a><br>
</div></div></blockquote></div>