Apache HTTP Server在SQL Server调用后停止工作


Apache HTTP Server stops working after call on SQL Server

我正面临XAMPP v.3.2.1和Microsoft SQL Server驱动程序(php_pdo_sqlsrv_56_ts.dll (v.3.2.0.0))的问题。我按照说明安装这些驱动程序和查询SQL Server的回答。

然而,对于每个答案,XAMPP中的Apache模块都会在httpd.exe (v. 2.4.12.0)上发生APPCRASH。除非我关闭程序,导致Apache重新启动,否则查询不会得到回答。

error.log:

[Mon Sep 07 15:43:08.413266 2015] [ssl:warn] [pid 1902972:tid 512] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:08.491275 2015] [core:warn] [pid 1902972:tid 512] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Mon Sep 07 15:43:09.008546 2015] [ssl:warn] [pid 1902972:tid 512] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:09.815810 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00455: Apache/2.4.12 (Win32) OpenSSL/1.0.1m PHP/5.6.11 configured -- resuming normal operations
[Mon Sep 07 15:43:09.815810 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00456: Apache Lounge VC11 Server built: Mar 20 2015 12:12:41
[Mon Sep 07 15:43:09.815810 2015] [core:notice] [pid 1902972:tid 512] AH00094: Command line: 'c:''xampp''apache''bin''httpd.exe -d C:/xampp/apache'
[Mon Sep 07 15:43:09.818813 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00418: Parent: Created child process 1903580
[Mon Sep 07 15:43:10.697569 2015] [ssl:warn] [pid 1903580:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:11.276463 2015] [ssl:warn] [pid 1903580:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:11.372490 2015] [mpm_winnt:notice] [pid 1903580:tid 384] AH00354: Child: Starting 150 worker threads.
[Mon Sep 07 15:43:46.469985 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00428: Parent: child process 1903580 exited with status 3221225477 -- Restarting.
[Mon Sep 07 15:43:47.150020 2015] [ssl:warn] [pid 1902972:tid 512] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:47.221026 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00455: Apache/2.4.12 (Win32) OpenSSL/1.0.1m PHP/5.6.11 configured -- resuming normal operations
[Mon Sep 07 15:43:47.221026 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00456: Apache Lounge VC11 Server built: Mar 20 2015 12:12:41
[Mon Sep 07 15:43:47.221026 2015] [core:notice] [pid 1902972:tid 512] AH00094: Command line: 'c:''xampp''apache''bin''httpd.exe -d C:/xampp/apache'
[Mon Sep 07 15:43:47.223036 2015] [mpm_winnt:notice] [pid 1902972:tid 512] AH00418: Parent: Created child process 1902296
[Mon Sep 07 15:43:48.064078 2015] [ssl:warn] [pid 1902296:tid 588] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:48.576094 2015] [ssl:warn] [pid 1902296:tid 588] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 07 15:43:48.646099 2015] [mpm_winnt:notice] [pid 1902296:tid 588] AH00354: Child: Starting 150 worker threads.

我认为要缩小错误范围,您必须尝试调试驱动程序dll。您可以尝试使用https://msdn.microsoft.com/en-us/library/windows/hardware/ff551063%28v=vs.85%29.aspx从dll中获取任何消息吗?

您也可以给http://grantschenck.tripod.com/dbwinv2.htm一个尝试…

我认为你的PHP版本和驱动程序。dll版本不匹配。请参阅https://www.microsoft.com/en-us/download/details.aspx?id=20098Url并检查驱动程序需要的PHP版本和
安装后,您将在ext目录中获得"SQLSRV_Readme.htm"文件,该文件将帮助您配置。