DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=37406>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=37406 Summary: Apache 1.3.33 does not free connections ODBC in MSSQL and Informix Product: Apache httpd-1.3 Version: 1.3.33 Platform: Other OS/Version: Windows 2000 Status: NEW Severity: critical Priority: P2 Component: Auth/Access AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] Our project is called IKONOS and we are utilizing Apache/1.3.33 (Win32) PHP/4.3.11 mod_ssl/2.8.22 OpenSSL/0.9.7g on Windows 2000 Server. Our aplications is developed complety in php. We carry out connections (tcp) to Informix and to Microsoft SQL-SERVER. Already it does a pair of months we have noting that the majority of the connections established are not freed correctly. This causes that the new connections are rejected and of way some programs php saturate our servant web apache to ocacionar its imminent blockade, having that resuming the service apache constantly. We have carried out some changes in the configuration of httpd.conf an php.ini with the possibility to stabilizing the problems, but we have not had better results. The Apache.log shows us constantly the following warning: [Tue Nov 08 16:53:43 2005] [error] mod_ssl: SSL handshake failed (server ykonos.gaeto.sescam.jclm.es:443, client 10.36.174.7) (OpenSSL library error follows) [Tue Nov 08 16:53:43 2005] [error] OpenSSL: error:14094416:SSL routines:SSL3_READ_BYTES:sslv3 alert certificate unknown The php-error. log shows us constantly the following warning/error: [08-Nov-2005 13:50:33] PHP Warning: odbc_do(): SQL error: [Microsoft][ODBC SQL Server Driver]Error en el vínculo de comunicación, SQL state 08S01 in SQLExecDirect in d:\apache\htdocsseg\radiologiaxml\image_server.php on line 7 [08-Nov-2005 13:50:33] PHP Warning: odbc_fetch_into(): supplied argument is not a valid ODBC result resource in d:\apache\htdocsseg\radiologiaxml\image_server.php on line 7 [08-Nov-2005 13:50:33] PHP Warning: odbc_free_result(): supplied argument is not a valid ODBC result resource in d:\apache\htdocsseg\radiologiaxml\image_server.php on line 7 [08-Nov-2005 11:40:18] PHP Warning: ldap_bind(): Unable to bind to server: Invalid credentials in d:\apache\htdocsseg\radiologiaxml\listaimagenes.php on line 41 Our present configuration of Apche is like continues: ------------------------------------------------------- --------------------httpd.conf------------------------- ------------------------------------------------------- We have defused these two guidelines: #MaxSpareServers 10 #MinSpareServers 5 We have Paymasters the following guidelines: # Timeout: The number of seconds before receives and sends time out. # Timeout 300 # # KeepAlive: Whether or not to allow persistent connections (more than # one request per connection). Set to "Off" to deactivate. # KeepAlive On # # MaxKeepAliveRequests: The maximum number of requests to allow # during a persistent connection. Set to 0 to allow an unlimited amount. # We recommend you leave this number high, for maximum performance. # MaxKeepAliveRequests 500 # # KeepAliveTimeout: Number of seconds to wait for the next request from the # same client on the same connection. # KeepAliveTimeout 15 MaxRequestsPerChild 0 # # Number of concurrent threads (i.e., requests) the server will allow. # Set this value according to the responsiveness of the server (more # requests active at once means they're all handled more slowly) and # the amount of system resources you'll allow the server to consume. # #ThreadsPerChild 128 ThreadsPerChild 200 # # Listen: Allows you to bind Apache to specific IP addresses and/or # ports, instead of the default. See also the <VirtualHost> # directive. # Listen 80 Listen 443 ------------------------------------------------------- --------------------php.ini-------------------------- ------------------------------------------------------- Our configurations of php.ini is the following: [SQL] sql.safe_mode = Off [ODBC] ;odbc.default_db = Not yet implemented ;odbc.default_user = Not yet implemented ;odbc.default_pw = Not yet implemented ; Allow or prevent persistent links. odbc.allow_persistent = On ; Check that a connection is still valid before reuse. odbc.check_persistent = On ; Maximum number of persistent links. -1 means no limit. odbc.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. odbc.max_links = -1 ; Handling of LONG fields. Returns number of bytes to variables. 0 means ; passthru. odbc.defaultlrl = 4096 ; Handling of binary data. 0 means passthru, 1 return as is, 2 convert to char. ; See the documentation on odbc_binmode and odbc_longreadlen for an explanation ; of uodbc.defaultlrl and uodbc.defaultbinmode odbc.defaultbinmode = 1 [Informix] ; Default host for ifx_connect() (doesn't apply in safe mode). ifx.default_host = ; Default user for ifx_connect() (doesn't apply in safe mode). ; Default password for ifx_connect() (doesn't apply in safe mode). ; Allow or prevent persistent links. ifx.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. ifx.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. ifx.max_links = -1 ; If on, select statements return the contents of a text blob instead of its id. ifx.textasvarchar = 0 ; If on, select statements return the contents of a byte blob instead of its id. ifx.byteasvarchar = 0 ; Trailing blanks are stripped from fixed-length char columns. May help the ; life of Informix SE users. ifx.charasvarchar = 0 ; If on, the contents of text and byte blobs are dumped to a file instead of ; keeping them in memory. ifx.blobinfile = 0 ; NULL's are returned as empty strings, unless this is set to 1. In that case, ; NULL's are returned as string 'NULL'. ifx.nullformat = 0 [MSSQL] ; Allow or prevent persistent links. mssql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mssql.max_persistent = -1 ; Maximum number of links (persistent+non persistent). -1 means no limit. mssql.max_links = -1 ; Minimum error severity to display. mssql.min_error_severity = 10 ; Minimum message severity to display. mssql.min_message_severity = 10 ; Compatability mode with old versions of PHP 3.0. mssql.compatability_mode = Off ; Connect timeout ;mssql.connect_timeout = 5 ; Query timeout ;mssql.timeout = 60 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 ; Limits the number of records in each batch. 0 = all records in one batch. ;mssql.batchsize = 0 ; Specify how datetime and datetim4 columns are returned ; On => Returns data converted to SQL server settings ; Off => Returns values as YYYY-MM-DD hh:mm:ss ;mssql.datetimeconvert = On ; Use NT authentication when connecting to the server mssql.secure_connection = Off ; Specify max number of processes. Default = 25 ;mssql.max_procs = 25 [Sockets] ; Use the system read() function instead of the php_read() wrapper. sockets.use_system_read = On ------------------------------------------------------------------------------- -------------------------- ------------------------------------------------------------------------------- -------------------------- We believe in the possibility to solve this problem without having that to emigrate to versions of apache 2. Nevertheless we expect that the community Apache can have some alternative that permit us to solve this problem. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
