[rt-users] External Authentication
Bryon Baker
bbaker at copesan.com
Wed Jun 26 14:50:45 EDT 2013
Looks like to me that is a little closer.
[Wed Jun 26 18:48:08 2013] [debug]: Calling UserExists with $username (bbaker) and $service (Connect_MSSQL) (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth.pm:227)
[Wed Jun 26 18:48:08 2013] [warning]: DBD::ODBC::db selectall_hashref failed: [unixODBC][FreeTDS][SQL Server]Incorrect syntax near the keyword 'USER'. (SQL-42000) at /usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth/DBI.pm line 219. (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth/DBI.pm:219)
[Wed Jun 26 18:48:08 2013] [warning]: Issuing rollback() due to DESTROY without explicit disconnect() of DBD::ODBC::db handle database=RapidTrax6a;Driver=SQLServer;DSN=SQLServer;host=192.168.250.29;port=1433 at /usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth/DBI.pm line 219. (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth/DBI.pm:219)
[Wed Jun 26 18:48:08 2013] [error]: DBD::ODBC::db selectall_hashref failed: [unixODBC][FreeTDS][SQL Server]Incorrect syntax near the keyword 'USER'. (SQL-42000) at /usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth/DBI.pm line 219.
Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726 • 262-783-6261 ext. 2296
bbaker at copesan.com
www.copesan.com
"Servicing North America with Local Care"
-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: Wednesday, June 26, 2013 1:32 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] External Authentication
On 06/26/2013 10:25 AM, Bryon Baker wrote:
> I agree Thomas.
>
> As stated before I have the correct information and setup for the ODBC
> drivers I have tested this with isql and tsql and I wrote a quick perl
> scrip to test the connection string and that works.
>
> What I can's figure out is what information needs to be put in the "
> 'dbi_driver' => 'DBI_DRIVER'," so that RT will use
> the DSN entry in the ODBC configs.
RT::Authen::ExternalAuth expects to build a DSN like so:
dbi:$dbi_driver:database=$db_database;host=$db_server;port=$db_port
Yet ODBC wants a sub-driver, so try this hack:
dbi_driver => 'ODBC',
database => 'FooBar;driver=FreeTDS',
More information about the rt-users
mailing list