Update Working with the first error I created a SQLServer.pm with the correct connect string. (I tested using Perl). Now I get this error. DBD::SQLServer initialisation failed: Can't locate object method "driver" via package "DBD::SQLServer" at /usr/lib/perl5/vendor_perl/5.16.2/x86_64-linux-thread-multi/DBI.pm line 820.
Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 [email protected] www.copesan.com "Servicing North America with Local Care" -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bryon Baker Sent: Wednesday, June 26, 2013 11:04 AM To: [email protected] Subject: Re: [rt-users] External Authentication When the DBI_Driver string = SQLServer I get the following error...... [Wed Jun 26 15:48:22 2013] [error]: install_driver(SQLServer) failed: Can't locate DBD/SQLServer.pm in @INC (@INC contains: /srv/www/perl-lib /usr/share/request-tracker/local/lib /usr/lib/perl5/vendor_perl/5.16.2 /usr/lib/perl5/vendor_perl/5.16.2/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.16.2/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.16.2 /usr/lib/perl5/5.16.2/x86_64-linux-thread-multi /usr/lib/perl5/5.16.2 /usr/lib/perl5/site_perl . /srv/www) at (eval 1431) line 3. When the DBI_Driver string = ODBC I get the following error...... [Wed Jun 26 15:51:06 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. I need to know what the proper DBI_driver string should be when using and ODBC connection to a MS-SQL database. I have test tslq and isql so I know that the ODBC configuration is correct. Just need to get the correct information in the RT_SiteConfig.pm Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 [email protected] www.copesan.com "Servicing North America with Local Care" -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bryon Baker Sent: Wednesday, June 26, 2013 10:39 AM To: [email protected] Subject: Re: [rt-users] External Authentication Update I uninstall FreeTDS and UnixODBC, then install FreeTDS first and then UnixODBC and edited the ini files and now I have both isql and tsql working. I am now moving back to try and get Request Tracker to work. Progress I love it. Even when it is slow and painful. Thanks Bryon Baker Network Operations Manager Copesan - Specialists in Pest Solutions 800-267-3726 • 262-783-6261 ext. 2296 [email protected] www.copesan.com "Servicing North America with Local Care" -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bryon Baker Sent: Wednesday, June 26, 2013 9:50 AM To: [email protected] Subject: Re: [rt-users] External Authentication 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 [email protected] www.copesan.com "Servicing North America with Local Care" -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bryon Baker Sent: Tuesday, June 25, 2013 4:26 PM To: [email protected] 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 [email protected] www.copesan.com "Servicing North America with Local Care" -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Sibley Sent: Tuesday, June 25, 2013 4:12 PM To: [email protected] 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).
