Access Denied & Apache Crash - Windows 7

[spall]

OTRS 3.1.7 for Windows
Installed successfully,

Then a command prompt opens with:

DBI connect('database=otrs;host=localhost;','otrs',...) failed: Access denied fo
r user 'otrs'@'localhost' (using password: YES) at C:/PROGRA~1/OTRS/OTRS/Kernel/
System/DB.pm line 256
ERROR: OTRS-otrs.Scheduler-10 Perl: 5.12.3 OS: MSWin32 Time: Tue Jul 31 13:13:41
2012

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

Traceback (1120):
Module: Kernel::System::DB::new (v1.144.2.1) Line: 227
Module: main::_CommonObjects (v1.22) Line: 607
Module: C:/PROGRA~1/OTRS/OTRS/bin/otrs.Scheduler4win.pl (v1.22) Line: 89

Got no DBObject! at C:/PROGRA~1/OTRS/OTRS/Kernel/System/PID.pm line 81.
The Cron Service (CRONw) service is stopping..


when Apache launches I get an appcrash.

Problem signature:
Problem Event Name: APPCRASH
Application Name: httpd.exe
Application Version: 2.2.17.0
Application Timestamp: 4cbbe9e8
Fault Module Name: StackHash_cb79
Fault Module Version: 6.1.7600.16385
Fault Module Timestamp: 4a5bdadb
Exception Code: c0000374
Exception Offset: 000c283b
OS Version: 6.1.7600.2.0.0.256.48
Locale ID: 2057
Additional Information 1: cb79
Additional Information 2: cb796b8e2fe46c6ca087c841360e16be
Additional Information 3: 2f18
Additional Information 4: 2f18df86d71e62c9b1e63cde471847b7

Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid= ... cid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt


I tried creating the user otrs but wants a password is this otrs too?

[crythias]

Code: Select all

DBI connect('database=otrs;host=localhost;','otrs',...) failed: Access denied fo
r user 'otrs'@'localhost' (using password: YES) at C:/PROGRA~1/OTRS/OTRS/Kernel/
System/DB.pm line 256

This means the database password for the OTRS database is not being accepted. Verify that the database credentials in Kernel/Config.pm match the password for the database in MySQL.
From a command line, type:
mysql -u LoginNameInConfig.pm -p OTRSDatabaseName
You'll be asked for a password. Put in the one that's shown in Config.pm. If it works, you wouldn't get this error. If it doesn't, you'll have to change the otrs database password to match the one.
If you set up the otrs database without a password, you need to add one.
For instance, if
mysql -u LoginName OTRSDatabaseName
works as-is, you still need to add a password for OTRS to work.

[spall]

that worked!

however I cant run the installer now as apache is not running because of the appcrash?

[crythias]

Apache not running is a real problem. Make sure Skype or other applications (TeamViewer? IIS?) aren't already occupying port 80 (netstat -ban | more)

[spall]

nothing on port 80 and I tried changing the port number in httpd.conf but still appcrash?

[crythias]

Code: Select all

Fault Module Name:	StackHash_cb79

StackHashis a rather generic and unspecific indicator that something it's trying to find, it can't, but it doesn't even know what it's trying to find.
Some sites suggest disabling Data Execution Prevention to overcome this. If it works, and doesn't do anything wrong, great, but you may have other systemic issues that might need to be addressed.