Apache to IIS

[thunter28]

I am testing a conversion from OTRS 3.2.8 using Apache to 3.2.8 using IIS. I copied the config.pm, generic agent.pm, and zzzauto.pm, along with the database file, and installed the new IIS version. The frest install worked fine, but when I imported the config files and database I now get the following error:

[/b] Error Message: Access denied for user 'otrs'@'localhost' (using password: YES)

Please contact your administrator. [/b]

I have not been able to work around this issue yet. Can anyone provide any details as of where to look for a solution?

[crythias]

Access denied for user 'otrs'@'localhost' (using password: YES)

This means the access is denied because the password given is incorrect.

Specifically, it's the otrs mysql user doesn't exist.

Since you copied "the database file", it appears you only copied the file relating to OTRS. The authentication file is the "mysql" database file in the source. If you don't want to do that, a better option will be to read about mysql documentation on how to create users and assign the users access/permissions to the databases. This is important for several reasons. The first is to get past this issue. The second is to understand how to get to your data if you need to change passwords or assign additional users (for instance, reporting/read only users or "back door admins") to your data.

If you don't want to do this anyway, then the fact of running the installer should have provided these permissions and if the password you give in the installer is different from the source config.pm, you will need to edit config.pm to change the stored database password to the one you created during the installer process.

[thunter28]

I always do a mysqldump for the db file when I perform the upgrage process. I have done many other updates that when importing the files and the database file it worked just fine. Here is the output of the error from OTRS:

Backend ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: MSWin32 Time: Tue Jul 2 14:24:23 2013 Message: Access denied for user 'otrs'@'localhost' (using password: YES) RemoteAddress: 172.16.16.230 RequestURI: /otrs/index.pl Traceback (1696): Module: Kernel::System::DB::new (OTRS 3.2. Line: 224 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2. Line: 140 Module: PerlEx::Precompiler::d_::apps::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

It definately seems like a password error, but it should have the default password from all the previous versions.

[crythias]

All connection information is gathered from config.pm unless you're using installer.pl

It applies that information to the mysql executable:
mysql -u DatabaseUser@DatabaseHost -p DatabasePw Database

This information is tested against what's stored in mysql.user for the mysql database server hosted on DatabaseHost

The error is indicative of the same error message that you would encounter had you typed the above entry in a command prompt. This is not an OTRS issue.

[bogdaniosif]

I am testing a conversion from OTRS 3.2.8 using Apache to 3.2.8 using IIS

Was the conversion successful? Any noticeable changes in performance?