extmail升级1.2 500 Internal Server Error错误

     因为emos1.5默认的extmail版本，在通讯录的“组”中，姓名如果是中文的话，选中组，发邮件时，变为乱码，原因是extmail中的一个bug，只好升级到extmail1.2，在虚拟机下测试访问时遇到错误：

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/2.2.3 (Red Hat) Server at mail.nq.com Port 80

检查日志：

[root@emos extmail]# vi /var/log/httpd/error_log
[Thu May 26 19:35:04 2011] [error] [client 1.1.1.1] Premature end of script headers: index.cgi
[Thu May 26 19:35:05 2011] [error] [client 1.1.1.1] suexec policy violation: see suexec log for more details
提示我们检查suexec日志

[root@emos extmail]# vi /var/log/httpd/suexec.log

[2011-05-26 19:34:09]: uid: (1000/vuser) gid: (1000/1000) cmd: index.cgi
[2011-05-26 19:34:09]: file has no execute permission: (/var/www/extsuite/extmail/cgi/index.cgi)

执行：

[root@emos extmail]# chmod -R 755 cgi/

再次访问，ok了~   （不要忘记cgi 和tmp属主属组皆为vuser vgroup，否则访问时会报另一个错误）

asp.net web.config 配置连接数据库字符串

  <appSettings>
    <!– 连接字符串是否加密 –>
    <add key=”ConStringEncrypt” value=”false”/>
    <!– 连接字符串,(可以扩展支持不同数据库)如果是加密方式，上面一项要设置为true，如果是明文server=127.0.0.1;database=codematic;uid=sa;pwd=,上面设置为false –>
    <add key=”ConnectionString” value=”server=.;database=EnterprisesWebsite;uid=NQ;pwd=NQ“/>
       
  </appSettings>

server=部分可以写为数据库名称、IP、（localhost）、或者是点“.”

EG:

server=.     server=127.0.0.1/172.17.1.19 (可以写回环IP或者是实际IP)    server=(localhost)    server=NQ

mssql2008R2 无法启动 通常每个套接字地址(协议/网络地址/端口)只允许使用一次

启动服务的时候，报如下错误:

 

开始检查日志：

SQL Server 无法生成 FRunCM 线程。请查看 SQL Server 错误日志和 Windows 事件日志，获取有关可能发生的相关问题的信息。

由于网络库中存在内部错误，所以无法启动网络库。要确定原因，请查看错误日志中紧位于此错误之前的那些错误。

TDSSNIClient 初始化失败，出现错误 0x2740，状态代码 0x1。原因: 初始化失败，出现基础结构错误。请检查以前的错误。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

TDSSNIClient 初始化失败，出现错误 0x2740，状态代码 0xa。原因: 无法初始化 TCP/IP 侦听器。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

服务器 TCP 提供程序无法在 [ ‘any’ <ipv4> 1433] 上侦听。TCP 端口已在使用中。

服务器正在侦听 [‘any’ <ipv6> 1433]。

Mysql日志：

2011-05-26 09:46:58.25 Server      Microsoft SQL Server 2008 R2 (RTM) – 10.50.1600.1 (X64)

         Apr  2 2010 15:48:46

         Copyright (c) Microsoft Corporation

         Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

2011-05-26 09:46:58.25 Server      (c) Microsoft Corporation.

2011-05-26 09:46:58.25 Server      All rights reserved.

2011-05-26 09:46:58.25 Server      Server process ID is 7864.

2011-05-26 09:46:58.25 Server      System Manufacturer: ‘OEM’, System Model: ‘OEM’.

2011-05-26 09:46:58.25 Server      Authentication mode is MIXED.

2011-05-26 09:46:58.25 Server      Logging SQL Server messages in file ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG’.

2011-05-26 09:46:58.25 Server      This instance of SQL Server last reported using a process ID of 7576 at 2011/5/26 9:45:21 (local) 2011/5/26 1:45:21 (UTC). This is an informational message only; no user action is required.

2011-05-26 09:46:58.25 Server      Registry startup parameters:

          -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf

          -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG

          -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

2011-05-26 09:46:58.27 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2011-05-26 09:46:58.27 服务器         Detected 2 CPUs. This is an informational message; no user action is required.

2011-05-26 09:46:58.29 服务器         Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.

2011-05-26 09:46:58.34 服务器         Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

2011-05-26 09:46:58.36 spid7s      Starting up database ‘master’.

2011-05-26 09:46:58.47 spid7s      Resource governor reconfiguration succeeded.

2011-05-26 09:46:58.47 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.

2011-05-26 09:46:58.47 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.

2011-05-26 09:46:58.48 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = ‘MSSQLSERVER’.

2011-05-26 09:46:58.51 spid7s      SQL Trace ID 1 was started by login “sa”.

2011-05-26 09:46:58.51 spid7s      Starting up database ‘mssqlsystemresource’.

2011-05-26 09:46:58.55 spid7s      The resource database build version is 10.50.1600. This is an informational message only. No user action is required.

2011-05-26 09:46:58.63 spid10s     Starting up database ‘model’.

2011-05-26 09:46:58.63 spid7s      Server name is ‘NQ’. This is an informational message only. No user action is required.

2011-05-26 09:46:58.78 服务器         A self-generated certificate was successfully loaded for encryption.

2011-05-26 09:46:58.78 服务器         Server is listening on [ ‘any’ <ipv6> 1433].

2011-05-26 09:46:58.78 服务器         错误: 26023，严重性: 16，状态: 1。

2011-05-26 09:46:58.78 服务器         Server TCP provider failed to listen on [ ‘any’ <ipv4> 1433]. Tcp port is already in use.

2011-05-26 09:46:58.79 服务器         错误: 17182，严重性: 16，状态: 1。

2011-05-26 09:46:58.79 服务器         TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: 无法初始化 TCP/IP 侦听器。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

2011-05-26 09:46:58.79 服务器         错误: 17182，严重性: 16，状态: 1。

2011-05-26 09:46:58.79 服务器         TDSSNIClient initialization failed with error 0x2740, status code 0x1. Reason: 初始化失败，出现基础结构错误。请检查以前的错误。 通常每个套接字地址(协议/网络地址/端口)只允许使用一次。

2011-05-26 09:46:58.79 服务器         错误: 17826，严重性: 18，状态: 3。

2011-05-26 09:46:58.79 服务器         Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2011-05-26 09:46:58.79 服务器         错误: 17120，严重性: 16，状态: 1。

2011-05-26 09:46:58.79 服务器         SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

2011-05-26 09:46:58.81 spid10s     Clearing tempdb database.

2011-05-26 09:46:59.00 spid13s     A new instance of the full-text filter daemon host process has been successfully started.

2011-05-26 09:46:59.11 spid13s     Starting up database ‘msdb’.

 协议/IP可以被程序多次利用，但是端口只能被单一程序进程占用。想想吧，最近在服务器上安装过什么？

查看端口被哪个无耻的进程占用了！！！

命令提示符：

C:\>netstat -ano | find “1433” 

  TCP    127.0.0.1:1433         127.0.0.1:3308         ESTABLISHED     1988

  TCP    127.0.0.1:3308         127.0.0.1:1433         ESTABLISHED     2024

C:\>

C:\>tasklist | find “1988”

MuseMailSvr.exe               1988 Services                   0      7,664 K

今早上刚安装了一个邮件服务器软件，就它了，先卸载吧。之后再次启动mssql服务，OK了~