PHP / IIS crash during install (web server edition) |
Author |
Message |
|
Posted : 2006-10-12 06:15:14 |
Hi I follow the instructions written here : http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=33 But when comes the time to test the DCOM setup with a ASP PHP or CF, I'm not able to do it. The web page gives :
"Server Error, unable to connect to fastcgi server."
In the application event logs, I've got this message (nothing else in the others event log category) :
Faulting application php.exe, version 4.4.4.4, faulting module php4ts.dll, version 4.4.4.4, fault address 0x000bc6b8.
The problem is that this web server is running for our web app and no error occured until this one. I've respected all the read/write permissions needed, all the steps to install the drivers.
I just would like to be able to test. Any help would be really appreciated. Thanks.
Php 4.4.4.4 / IIS 6 / W2k3 Srv Enterprise Edition
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-12 11:31:54 |
|
|
|
|
Posted : 2006-10-12 23:35:45 |
When I run the qbcust.asp :
QODBC Customer Web List Demo Page Preparing to Create Connection Object ADO Connection Created ADO Recordset Created - Opening QuickBooks Sample Company File ... and I wait about 20 minutes the page to load, and it doesn't ...
When I run the TestDCOM.asp (not the TestDCOM.php as I did before) :
QODBC ASP DCOM Access Test Page
QB2002 | QB2003 | QB2004 | QB2005 | DCOM | COM | Object Name | Status |
• |
• |
|
|
• |
|
QBXMLRPEQODBCInteractive.exe |
Error: |
• |
• |
|
|
|
• |
QBXMLRP.dll |
Success |
|
|
• |
• |
• |
|
QBXMLRP2EQODBCInteractive.exe |
Error: |
|
|
• |
• |
|
• |
QBXMLRP2.dll |
Success |
• |
• |
• |
• |
|
• |
XERCES-COM.dll |
Success |
Current Logged on User is: Authenticated user is:
I suppose the error status for the QBXMLRP* dcom could be the problem ... |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-13 08:29:48 |
|
|
|
|
Posted : 2006-10-14 07:19:38 |
I had soon configured the both QODBC DCOM objects with the good permissions, and to auto-login. I double-checked each steps of installation, and everithing is ok. I've decided to upgrade my php version from php4 to php5... and I triple-checked again each steps of installation. As a big part of the kernel of php5 is new, I thought it was for working .... but now it gives :
Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `QBXMLRPEQODBCInteractive.RequestProcessor': The server process could not be started because the configured identity is incorrect. Check the username and password. ' in C:\Inetpub\wwwroot\test_odbc\TestDCOM.php:58 Stack trace: #0 C:\Inetpub\wwwroot\test_odbc\TestDCOM.php(58): com->com('QBXMLRPEQODBCIn...') #1 {main} thrown in C:\Inetpub\wwwroot\test_odbc\TestDCOM.php on line 58 QODBC PHP DCOM Access Test Page
QB2002 | QB2003 | QB2004 | QB2005 | DCOM | COM | Object Name | Status |
• |
• |
|
|
• |
|
QBXMLRPEQODBCInteractive.exe |
It's like if there was a problem ........ |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-14 07:32:28 |
The QBXMLRPEQODBCInteractive.exe and QBXMLRP2EQODBCInteractive.exe DCOMs are not configured correctly. Try using:
Automatic DCOM Configuration Click here: qodbcSetDCOM.zip to download the following automated tools:-
|
Dcpinst.exe is an installation setup for the automated DCOM configuration object. This needs to be run first and only once. |
|
QODBCSetDCOM.VBS is a VB script that uses the installed configuration object to setup the DCOM Servers. It will reset and automatically add all necessary security each time it is run. The script can be edited if you need to change the Accounts it is configuring. |
|
The new settings will not take affect until the DCOM servers (qbXMLRPeQODBCInteractive.exe and qbXMLRP2eQODBCInteractive.exe) are removed from memory. Rebooting is the simplest way to accomplish this, but running the Windows Task Manager and Ending Process on any running copies will also work. |
|
Test your DCOM setup using one of the following:-
|
|
|
|
|
|
Posted : 2006-10-17 00:14:05 |
I've got exactly the same messages after running (once more) Dcpinst.exe and QODBCSetDCOM.VBS. With TestDCOM.ASP :
QODBC ASP DCOM Access Test Page
QB2002 | QB2003 | QB2004 | QB2005 | DCOM | COM | Object Name | Status |
• |
• |
|
|
• |
|
QBXMLRPEQODBCInteractive.exe |
Error: |
• |
• |
|
|
|
• |
QBXMLRP.dll |
Success |
|
|
• |
• |
• |
|
QBXMLRP2EQODBCInteractive.exe |
Error: |
|
|
• |
• |
|
• |
QBXMLRP2.dll |
Success |
• |
• |
• |
• |
|
• |
XERCES-COM.dll |
Success |
Current Logged on User is: Authenticated user is:
Current Logged on User is: Authenticated user is:
And with TestDCOM.PHP : Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `QBXMLRPEQODBCInteractive.RequestProcessor': The server process could not be started because the configured identity is incorrect. Check the username and password. ' in C:\Inetpub\wwwroot\Sites WEB\Clients\travaux\test odbc\TestDCOM.php:58 Stack trace: #0 C:\Inetpub\wwwroot\Sites WEB\Clients\travaux\test odbc\TestDCOM.php(58): com->com('QBXMLRPEQODBCIn...') #1 {main} thrown in C:\Inetpub\wwwroot\Sites WEB\Clients\travaux\test odbc\TestDCOM.php on line 58
QODBC PHP DCOM Access Test Page
QB2002 | QB2003 | QB2004 | QB2005 | DCOM | COM | Object Name | Status |
• |
• |
|
|
• |
|
QBXMLRPEQODBCInteractive.exe |
For the fun, I've started manually both files QBXMLRPEQODBCInteractive.exe and QBXMLRP2EQODBCInteractive.exe from "c:\program files\QODBC Drivers for Quickbooks" with my username on the web server but I obtained the same results.
But as you can see with the ASP test, the login and the password to connect the QODBC are empty ... and the message from the PHP test says it's not the good login/password. Maybe there's something in this way.
ps: I need PHP to work, even if I'm using IIS and even if I could use ASP. |
|
|
|
|
Posted : 2006-10-17 02:06:16 |
Ok, after many and many manipulations, I found the property of the both objects (with dcomconfig.exe), in the identity tab, the user account used to tun the application MUST be the launching user. (I did not found this information in all the installation guide, and the faq. It's possible that I've not well searched.)
And I've got all the tests success :
QODBC PHP DCOM Access Test Page
QB2002 | QB2003 | QB2004 | QB2005 | DCOM | COM | Object Name | Status |
• |
• |
|
|
• |
|
QBXMLRPEQODBCInteractive.exe |
Success |
• |
• |
|
|
|
• |
QBXMLRP.dll |
Success |
|
|
• |
• |
• |
|
QBXMLRP2EQODBCInteractive.exe |
Success |
|
|
• |
• |
|
• |
QBXMLRP2.dll |
Success |
• |
• |
• |
• |
|
• |
XERCES-COM.dll |
Success |
Current Logged on User is: Authenticated user is: PHP Current Logged on User is: ?????
Current Logged on User is: Authenticated user is: PHP Current Logged on User is: ?????
The only one probem was the "run application using the launching user". Thanks for your help, I'm watching further now to test if everything is ok before to buy it. |
|
|
|
|
Posted : 2006-10-18 00:12:58 |
Ok it's not over. I've tried again the qbcust.asp file. I've got the same result I had before (see the post created on 2006-10-12 23:35:45) Then I tried the DisplaySQL.php test file without success. I wait but nothing occurs.. When I check the process running on the web server, I do not see any Quickbooks instance nor Quickbooks driver nor Quickbooks connection. But the w3wp.exe (World Wild Web Publishing service) is growing as soon as I launch a test file.
Any help would be welcome. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-18 08:19:07 |
Do other .asp pages with VBScript run ok on your server? Are you running QuickBooks on the server console (local session) logged in as administrator? |
|
|
|