Hi, I am changing MySQL to MSSQL and need some assistance if I may. I have created the database and set up a login for OTRS in my MSSQL. I have changed the config.pm file as per below: # DatabaseHost # (The database host.) $Self->{DatabaseHost} = '[IP or name to your Database]'; # Database # (The database name.) $Self->{Database} = 'otrs'; # DatabaseUser # (The database user.) $Self->{DatabaseUser} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '[password to sql server for user otrs]'; # DatabaseDSN $Self->{"Database::Type"} = 'mssql'; $Self->{DatabaseDSN} = "DBI:ODBC:otrs"; $Self->{DatabaseUserTable} = 'users'; Perl-DBD-ODBC has also been installed. I ran CheckDB.pl and I'm getting the following error, can anybody please help me. Do I have to change another file? DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data source name not found, and not default driver specified Can anybody help? Thanks Rosanna
Noooo please.... why ??!! :D :D :D On Thu, Sep 17, 2009 at 4:34 PM, Marretta, Rosanna < Rosanna.Marretta@yrclogistics.com> wrote:
Hi,
I am changing MySQL to MSSQL and need some assistance if I may.
I have created the database and set up a login for OTRS in my MSSQL. I have changed the config.pm file as per below:
# DatabaseHost
# (The database host.)
$Self->{DatabaseHost} = '[IP or name to your Database]';
# Database
# (The database name.)
$Self->{Database} = 'otrs';
# DatabaseUser
# (The database user.)
$Self->{DatabaseUser} = 'otrs';
# DatabasePw
# (The password of database user. You also can use bin/CryptPassword.pl
# for crypted passwords.)
$Self->{DatabasePw} = '[password to sql server for user otrs]';
# DatabaseDSN
$Self->{"Database::Type"} = 'mssql';
$Self->{DatabaseDSN} = "DBI:ODBC:otrs";
$Self->{DatabaseUserTable} = 'users';
Perl-DBD-ODBC has also been installed.
I ran CheckDB.pl and I'm getting the following error, can anybody please help me. Do I have to change another file?
DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data source name not found, and not default driver specified
Can anybody help?
Thanks
Rosanna
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Did you create a System DSN in the ODBC settings on the server running the OTRS MSSQL SQL instance? It looks like you would have, but just in case: (Forgive if this is more information that you need - you probably know all of this - more for posterity and others in the future.) In Administrative Tools > Data Sources (ODBC) create a SYSTEM DSN - whatever you name the DSN is the value to enter in your config.pm file:- it does not have to match the actual database name. For instance, my SQL server is named IMUDD, the database itself is named otrs, but the value I enter in the config.pm file is SQLOTRS because that is what I named the System DSN on the SQL Server. Also, try using the value below for $Self->{DatabaseDSN} instead of DBI:ODBC:otrs - $Self->{'DatabaseHost'} = 'IMUDD'; $Self->{'Database'} = 'SQLOTRS'; $Self->{'DatabaseUser'} = 'mssql-user-name'; $Self->{'DatabasePw'} = 'super-secret-password'; $Self->{DatabaseDSN} = "DBI:ODBC:$Self->{Database}"; $Self->{'Database::Type'} = 'mssql'; Good luck! Nathan Campbell Dallas Symphony Orchestra From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna Sent: Thursday, September 17, 2009 9:35 AM To: otrs@otrs.org Subject: [otrs] Changing MySQL to MSSQL Hi, I am changing MySQL to MSSQL and need some assistance if I may. I have created the database and set up a login for OTRS in my MSSQL. I have changed the config.pm file as per below: # DatabaseHost # (The database host.) $Self->{DatabaseHost} = '[IP or name to your Database]'; # Database # (The database name.) $Self->{Database} = 'otrs'; # DatabaseUser # (The database user.) $Self->{DatabaseUser} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '[password to sql server for user otrs]'; # DatabaseDSN $Self->{"Database::Type"} = 'mssql'; $Self->{DatabaseDSN} = "DBI:ODBC:otrs"; $Self->{DatabaseUserTable} = 'users'; Perl-DBD-ODBC has also been installed. I ran CheckDB.pl and I'm getting the following error, can anybody please help me. Do I have to change another file? DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data source name not found, and not default driver specified Can anybody help? Thanks Rosanna
Thank you very much for your email. I haven't set up the System DSN, would make sense! We are using Linux Suse server, do you know how to do this as I'm very new to linux. Thanks, Rosanna ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nathan Campbell Sent: 17 September 2009 15:48 To: User questions and discussions about OTRS. Subject: Re: [otrs] Changing MySQL to MSSQL Did you create a System DSN in the ODBC settings on the server running the OTRS MSSQL SQL instance? It looks like you would have, but just in case: (Forgive if this is more information that you need - you probably know all of this - more for posterity and others in the future.) In Administrative Tools > Data Sources (ODBC) create a SYSTEM DSN - whatever you name the DSN is the value to enter in your config.pm file:- it does not have to match the actual database name. For instance, my SQL server is named IMUDD, the database itself is named otrs, but the value I enter in the config.pm file is SQLOTRS because that is what I named the System DSN on the SQL Server. Also, try using the value below for $Self->{DatabaseDSN} instead of DBI:ODBC:otrs - $Self->{'DatabaseHost'} = 'IMUDD'; $Self->{'Database'} = 'SQLOTRS'; $Self->{'DatabaseUser'} = 'mssql-user-name'; $Self->{'DatabasePw'} = 'super-secret-password'; $Self->{DatabaseDSN} = "DBI:ODBC:$Self->{Database}"; $Self->{'Database::Type'} = 'mssql'; Good luck! Nathan Campbell Dallas Symphony Orchestra From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna Sent: Thursday, September 17, 2009 9:35 AM To: otrs@otrs.org Subject: [otrs] Changing MySQL to MSSQL Hi, I am changing MySQL to MSSQL and need some assistance if I may. I have created the database and set up a login for OTRS in my MSSQL. I have changed the config.pm file as per below: # DatabaseHost # (The database host.) $Self->{DatabaseHost} = '[IP or name to your Database]'; # Database # (The database name.) $Self->{Database} = 'otrs'; # DatabaseUser # (The database user.) $Self->{DatabaseUser} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '[password to sql server for user otrs]'; # DatabaseDSN $Self->{"Database::Type"} = 'mssql'; $Self->{DatabaseDSN} = "DBI:ODBC:otrs"; $Self->{DatabaseUserTable} = 'users'; Perl-DBD-ODBC has also been installed. I ran CheckDB.pl and I'm getting the following error, can anybody please help me. Do I have to change another file? DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data source name not found, and not default driver specified Can anybody help? Thanks Rosanna
_____ Thank you very much for your email. I haven't set up the System DSN, would make sense! We are using Linux Suse server, do you know how to do this as I'm very new to linux. Thanks, Rosanna The DSN is setup on the Windows server in which the MSSQL server is installed. Nathan provided the location in his email... "In Administrative Tools > Data Sources (ODBC) create a SYSTEM DSN - whatever you name the DSN is the value to enter in your config.pm file:- it does not have to match the actual database name."
Microsoft SQL should be installed on a Microsoft Windows Server. Of course, your OTRS installation can run on Linux, but if your database is running MSSQL then it is installed on a Windows server. That is where you need to configure the DSN - On the Windows server Click Start > Control Panel > Administrative Tools > Data Sources (ODBC) Click the second tab labeled - System DSN Proceed through the wizard - it is a fairly easy / self-explanatory wizard. You definitely should configure the System DSN - if that doesn't work, there may be some other issues getting a Linux box to communicate with the Windows / MSSQL server, but my Linux / Windows interaction experience is limited to Samba, which I don't think would apply in this case. Remember, Google is your friend! J Good luck (still), Nathan Campbell Systems Administrator Dallas Symphony Orchestra Morton H. Meyerson Symphony Center Schlegel Administrative Suites 2301 Flora Street Dallas, Texas 75201 214-871-4026 - phone 214-953-1218 - fax n.campbell@DalSym.com mailto:n.campbell@DalSym.com www.dallassymphony.com http://www.dallassymphony.com "To entertain, inspire and change lives through musical excellence" Click Here To Buy Tickets http://dallassymphony.com/Buy_Tickets.aspx From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna Sent: Thursday, September 17, 2009 10:34 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Changing MySQL to MSSQL Thank you very much for your email. I haven't set up the System DSN, would make sense! We are using Linux Suse server, do you know how to do this as I'm very new to linux. Thanks, Rosanna _____ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nathan Campbell Sent: 17 September 2009 15:48 To: User questions and discussions about OTRS. Subject: Re: [otrs] Changing MySQL to MSSQL Did you create a System DSN in the ODBC settings on the server running the OTRS MSSQL SQL instance? It looks like you would have, but just in case: (Forgive if this is more information that you need - you probably know all of this - more for posterity and others in the future.) In Administrative Tools > Data Sources (ODBC) create a SYSTEM DSN - whatever you name the DSN is the value to enter in your config.pm file:- it does not have to match the actual database name. For instance, my SQL server is named IMUDD, the database itself is named otrs, but the value I enter in the config.pm file is SQLOTRS because that is what I named the System DSN on the SQL Server. Also, try using the value below for $Self->{DatabaseDSN} instead of DBI:ODBC:otrs - $Self->{'DatabaseHost'} = 'IMUDD'; $Self->{'Database'} = 'SQLOTRS'; $Self->{'DatabaseUser'} = 'mssql-user-name'; $Self->{'DatabasePw'} = 'super-secret-password'; $Self->{DatabaseDSN} = "DBI:ODBC:$Self->{Database}"; $Self->{'Database::Type'} = 'mssql'; Good luck! Nathan Campbell Dallas Symphony Orchestra From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna Sent: Thursday, September 17, 2009 9:35 AM To: otrs@otrs.org Subject: [otrs] Changing MySQL to MSSQL Hi, I am changing MySQL to MSSQL and need some assistance if I may. I have created the database and set up a login for OTRS in my MSSQL. I have changed the config.pm file as per below: # DatabaseHost # (The database host.) $Self->{DatabaseHost} = '[IP or name to your Database]'; # Database # (The database name.) $Self->{Database} = 'otrs'; # DatabaseUser # (The database user.) $Self->{DatabaseUser} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{DatabasePw} = '[password to sql server for user otrs]'; # DatabaseDSN $Self->{"Database::Type"} = 'mssql'; $Self->{DatabaseDSN} = "DBI:ODBC:otrs"; $Self->{DatabaseUserTable} = 'users'; Perl-DBD-ODBC has also been installed. I ran CheckDB.pl and I'm getting the following error, can anybody please help me. Do I have to change another file? DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data source name not found, and not default driver specified Can anybody help? Thanks Rosanna
participants (4)
-
LQ Marshall -
Marco Vannini -
Marretta, Rosanna -
Nathan Campbell