Hello Friends,
i want to change database type from mySQL to msSQL i make necessary changes, and run the file otrs.CheckDB.pl it shows message that "It looks ok !"
but when i try to run index.pl in browser error message display
Oops! An Error occurred.
Error Message: Can't connect to MySQL server on 'localhost' (10061)
Please contact your administrator.
<![CDATA[
Message:
Can't connect to MySQL server on 'localhost' (10061)
Comment:
Please contact your administrator
Traceback:
ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: MSWin32 Time: Fri Feb 11 17:31:46 2011<br/>
<br/>
Message: Can't connect to MySQL server on 'localhost' (10061)<br/>
<br/>
Traceback (576): <br/>
Module: Kernel::System::DB::new (v1.127) Line: 181<br/>
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 140<br/>
Module: ModPerl::ROOT::ModPerl::Registry::D_3a_Program_20Files_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48<br/>
Module: (eval) (v1.89) Line: 204<br/>
Module: ModPerl::RegistryCooker::run (v1.89) Line: 204<br/>
Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170<br/>
Module: ModPerl::Registry::handler (v1.99) Line: 31<br/>
<br/>
"
]]>
You canSend a bugreport or go back to the previous page.
Error Details:
Error Details
Backend ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: MSWin32 Time: Fri Feb 11 17:31:46 2011
Message: Can't connect to MySQL server on 'localhost' (10061)
Traceback (576):
Module: Kernel::System::DB::new (v1.127) Line: 181
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 140
Module: ModPerl::ROOT::ModPerl::Registry::D_3a_Program_20Files_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48
Module: (eval) (v1.89) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
Powered by OTRS 3.0.5 Top of page
I don't know what is the exact matter, please give me hint.
Thanks in advance
databse mysql to mssql
Moderator: crythias
-
- Znuny advanced
- Posts: 148
- Joined: 25 Oct 2010, 10:02
- Znuny Version: 3.2
- Location: Bangalore, India
Re: databse mysql to mssql
I believe that you need to make the necessary changes in Config.pm to connect to MSSQL server.
Best Regards
Chetan
OTRS 3.06
ITSM 3.1
MySQL
Windows 7 Ultimate
Chetan
OTRS 3.06
ITSM 3.1
MySQL
Windows 7 Ultimate
Re: databse mysql to mssql
Thanks chetan for quick response but i already made the changes ... and after running the CheckDB.pl it shows message that "It looks ok !"
it means database connection are OK !!!
do you have any other clue ?
it means database connection are OK !!!
do you have any other clue ?
-
- Znuny advanced
- Posts: 148
- Joined: 25 Oct 2010, 10:02
- Znuny Version: 3.2
- Location: Bangalore, India
Re: databse mysql to mssql
if you can post your config.pm, it may help to debug.
Best Regards
Chetan
OTRS 3.06
ITSM 3.1
MySQL
Windows 7 Ultimate
Chetan
OTRS 3.06
ITSM 3.1
MySQL
Windows 7 Ultimate
Re: databse mysql to mssql
Hi Chetan,
please find the file....
please find the file....
You do not have the required permissions to view the files attached to this post.
-
- Znuny advanced
- Posts: 148
- Joined: 25 Oct 2010, 10:02
- Znuny Version: 3.2
- Location: Bangalore, India
Re: databse mysql to mssql
I have reviewed the config.txt. You seem to connect to system_user2 table. Check if that table exists. Since you have specified the username/password for db (and assuming they are correct:-)), that's the only possibility that i can think causing that issue.
Best Regards
Chetan
Best Regards
Chetan
Best Regards
Chetan
OTRS 3.06
ITSM 3.1
MySQL
Windows 7 Ultimate
Chetan
OTRS 3.06
ITSM 3.1
MySQL
Windows 7 Ultimate