CustomerUser::DB MS SQL Server probs
Hi folks, I have got a clean copy of OTRS running all fine using mysql. I want to connect to a MSSQL db to get customer details. I've seen the other post on here about it and have done the same things. However it's throwing an error.... ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: freebsd Time: Wed Mar 29 22:58:36 2006 Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|maxdb|oracle|db2|mssql). Traceback (38439): Module: Kernel::System::DB::new (v1.47) Line: 145 Module: Kernel::System::CustomerUser::DB::new (v1.36) Line: 56 Module: Kernel::System::CustomerUser::new (v1.22) Line: 80 Module: Kernel::System::Ticket::new (v1.194) Line: 124 Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 181 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.80) Line: 203 Module: ModPerl::RegistryCooker::run (v1.80) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Wed Mar 29 22:58:36 2006] [error] at /opt/otrs//Kernel/System/CustomerUser/DB.pm line 56.\n I clearly don't want to set that option for the main mysql db otrs uses only for the connection to the customer db. I've added the line below which clears the error, but I'm still working on fixing ODBC errors/probs, no idea yet if related. Type => 'mysql' in Kernel/System/CustomerUser/DB.pm Thoughts? TIA -- Kind regards C D Patrick McEvoy ViaVillas Limited Managing Director email patrick@viavillas.com mobile 07905775504 -- ViaVillas Limited Elmfield, 229 Bury Road, Rossendale, BB4 6DJ Tel: 08700634893 - Fax: 08712362513 Email: support@viavillas.com - Web: http://www.viavillas.com/ Company Number : 4641179 - VAT Number : GB 815 6385 17 --
Hi Patrick, Patrick McEvoy schrieb:
Hi folks,
I have got a clean copy of OTRS running all fine using mysql. I want to connect to a MSSQL db to get customer details. I've seen the other post on here about it and have done the same things. However it's throwing an error....
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: freebsd Time: Wed Mar 29 22:58:36 2006
Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|maxdb|oracle|db2|mssql).
I wonder about this logging. What does this mean? How can a mssql-connection be established within OTRS? I though that it is fairly difficult to connect from linux to MS-SQL. Do you use a direct DBD-MSSQL-connection or ODBC-connection? I use DBD::Sybase to realize a direct connect between linux-perl and MS-SQL (without ODBC). That works fine - see http://freetds.org/ for details. Bye, Alex
Alexander Scholler wrote:
Hi Patrick,
Patrick McEvoy schrieb:
Hi folks,
I have got a clean copy of OTRS running all fine using mysql. I want to connect to a MSSQL db to get customer details. I've seen the other post on here about it and have done the same things. However it's throwing an error....
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: freebsd Time: Wed Mar 29 22:58:36 2006
Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|maxdb|oracle|db2|mssql).
I wonder about this logging. What does this mean? How can a mssql-connection be established within OTRS?
I got ODBC working fine. I have used db2 type and that *seems* to work. ms sql didn't like LIMIT used by mysql db type.
I though that it is fairly difficult to connect from linux to MS-SQL. Do you use a direct DBD-MSSQL-connection or ODBC-connection? As above I use DBD::Sybase to realize a direct connect between linux-perl and MS-SQL (without ODBC). That works fine - see http://freetds.org/ for details.
Bye, Alex Next problem...
ODBC just plain refuses to work with mod_perl. Get this in the logs. [notice] child pid 79347 exit signal Segmentation fault (11) ... Everything works in cgi mode, and OTRS aside from ODBC works with mod_perl. Annoying and strange! I'm using freebsd, used the ports to install everything. Any thoughts? -- Kind regards C D Patrick McEvoy ViaVillas Limited Managing Director email patrick@viavillas.com mobile 07905775504 -- ViaVillas Limited Elmfield, 229 Bury Road, Rossendale, BB4 6DJ Tel: 08700634893 - Fax: 08712362513 Email: support@viavillas.com - Web: http://www.viavillas.com/ Company Number : 4641179 - VAT Number : GB 815 6385 17 --
participants (2)
-
Alexander Scholler -
Patrick McEvoy