[rt-users] External Authentication
Bryon Baker
bbaker at copesan.com
Wed Jun 26 10:49:47 EDT 2013
I am pretty sure the issue is with the install for the unixodbc and Freetds see output below.
linux-jrlt:/usr/bin/gcc # odbcinst -q -d
[FreeTDS]
[SQLServer]
linux-jrlt:/usr/bin/gcc # odbcinst -q -s
[MSSQL]
[Default]
linux-jrlt:/usr/bin/gcc # odbcinst -j
unixODBC 2.2.12
DRIVERS............: /etc/unixODBC/odbcinst.ini
SYSTEM DATA SOURCES: /etc/unixODBC/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini
linux-jrlt:/usr/bin/gcc # isql -v MSSQL
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
ODBC.ini
[ODBC Data Sources]
MSSQL=TDS connection
[MSSQL]
Description = Microsoft SQL Server
Driver = FreeTDS
Server = 192.168.000.000
Database = DBName
Port = 1433
UsageCount = 1
FileUsage = 1
TDS_Version = 8.0
[ODBC]
Trace=255
[Default]
Driver = SQLServer
ODBCinst.ini
[FreeTDS]
Description = FreeTDS unixODBC Driver
Driver = /usr/lib64/libtdsodbc.so.0
UsageCount = 1
FileUsage = 1
Trace = Yes
TraceFile = /tmp/freetds.log
[SQLServer]
Description = FreeTDS unixODBC Driver
Driver = /usr/lib64/libtdsodbc.so.0
Trace = Yes
TraceFile = /tmp/freetds.log
FileUsage = 1
UsageCount = 1
FreeTDS.conf
[global]
timeout = 10
connect timeout = 10
text size = 64512
[MSSQL]
host = 192.168.000.000
port = 1433
tds version = 8.0
instance = SSLSQLDB
dump file = /tmp/dump.log
I think the unixodbc is not reading these files I am not even getting a trace file. I do not know why. Can anyone see the issue?
Thnaks
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 Bryon Baker
Sent: Tuesday, June 25, 2013 4:26 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] External Authentication
I change the dbi_Driver option to ODBC. Now I get the following error
[Tue Jun 25 21:21:29 2013] [error]: DBI connect('database=RapidTrax6a;host=192.168.250.29;port=1433','HelpDeskOTRS',...) failed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002) at /usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth/DBI.pm line 446.
Odbc Information
linux-jrlt:~ # perl -MDBD::ODBC -e 'print $DBD::ODBC::VERSION;'
1.33
linux-jrlt:~ # perl -MDBI -e 'DBI->installed_versions;'
Perl : 5.016002 (x86_64-linux-thread-multi)
OS : linux (3.4.6-2.10-xen)
DBI : 1.627
DBD::mysql : 4.021
DBD::Sponge : 12.010002
DBD::Proxy : 0.2004
DBD::ODBC : 1.33
DBD::Gofer : 0.015326
DBD::File : 0.41
DBD::ExampleP : 12.014310
DBD::DBM : 0.08
Still don't know what I am missing.
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: Tuesday, June 25, 2013 4:12 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] External Authentication
On 06/25/2013 02:05 PM, Bryon Baker wrote:
> Sorry I screwed on both.
>
> Made change and now I get the following messages. LDAP works by the way.
>
> [Tue Jun 25 20:58:13 2013] [debug]: Attempting to use external auth
> service: Connect_MSSQL
> (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth.pm:186)
> [Tue Jun 25 20:58:13 2013] [debug]: SSO Failed and no user to test
> with. Nexting
> (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth.pm:214)
> [Tue Jun 25 20:58:13 2013] [debug]: Attempting to use external auth
> service: Connect_LDAP
> (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth.pm:186)
> [Tue Jun 25 20:58:13 2013] [debug]: SSO Failed and no user to test
> with. Nexting
> (/usr/lib/perl5/vendor_perl/5.16.2/RT/Authen/ExternalAuth.pm:214)
> [Tue Jun 25 20:58:13 2013] [debug]: Autohandler called ExternalAuth.
> Response: (0, No User)
> (/usr/share/request-tracker/local/plugins/RT-Authen-ExternalAuth/html/
> Elements/DoAuth:11)
This means that your MSSQL auth source didn't find a user, so it moved on to your LDAP source where it also didn't find a user (presumably because some users are in MSSQL and others are in LDAP).
More information about the rt-users
mailing list