Skip to Content.
Sympa Menu

freetds - RE: [freetds] Connection Errors...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rick Conner" <rick AT rickconner.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Connection Errors...
  • Date: Sat, 18 Jun 2005 14:09:52 -0400

Ok, I'm not sure why I didn't see this before, but the apache error log
contains the following...

[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_connect in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_pconnect in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_close in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_select_db in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_query in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_free_result in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_get_last_message in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_num_rows in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_num_fields in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_field in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_row in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_array in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_object in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_data_seek in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_field_seek in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_result in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_min_error_severity in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Function registration failed -
duplicate name - mssql_min_message_severity in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: mssql: Unable to register functions,
unable to load in Unknown on line 0
[18-Jun-2005 14:00:33] PHP Warning: Unknown(): Unable to load dynamic
library './php_mssql.dll' - ./php_mssql.dll: cannot open shared object file:
No such file or directory in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_connect in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_pconnect in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_close in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_select_db in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_query in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_free_result in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_get_last_message in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_num_rows in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_num_fields in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_field in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_row in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_array in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_fetch_object in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_data_seek in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_field_seek in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_result in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_min_error_severity in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Function registration failed -
duplicate name - mssql_min_message_severity in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: mssql: Unable to register functions,
unable to load in Unknown on line 0
[18-Jun-2005 14:03:34] PHP Warning: Unknown(): Unable to load dynamic
library './php_mssql.dll' - ./php_mssql.dll: cannot open shared object file:
No such file or directory in Unknown on line 0

What does it mean that it is unable to load the dynamic library? It's odd,
because I would think that it wouldn't be able to even try to connect with
errors like that? Just thought this might help someone figure something
out...


Rick D. Conner
Rick AT wedosites.com

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Rick Conner
Sent: Saturday, June 18, 2005 1:48 PM
To: 'FreeTDS Development Group'
Subject: RE: [freetds] Connection Errors...


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Friday, June 17, 2005 10:39 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Connection Errors...

Rick D Conner wrote:
>
> I have to ask for some help because I'm at the end of my rope with this.
> First off, I'm restricted in that the web host has the "real" control
> over the freetds configurations, but they will take "suggestions".
...
> We are on a unix box, running apache. if it's necessary I can get the
> ver
> #'s .. And we are connecting to a remote mssql server running MsSql
> #server
> 2000.
> 15:33:45.275589 Connecting to 66.208.184.170 port 1433, TDS 7.0.
...
> 15:38:45.787660 goodread: errno=104, "Connection reset by peer"
> 15:38:45.787717 tds_client_msg: #20004: "Read from SQL server failed.".
> Connection state is now 0.
...
> If you notice on the freetds.log file, there is a 5 minute "pause" where
> the connection is finally reset by the peer (mssql server I'm assuming).
> Now, before you say the same thing that my host did, I HAVE checked the
> username and password, and they are correct. I even setup a new account
> on the mssql server and tried it to no avail..

>From the host making the connection, does "telnet 66.208.184.170 1433"
work? I bet it doesn't. Is there a firewall in between?


=========================
Yes, my web host is able to do a telnet to the remote server. And I am able
to connect from my system as well. All the necessary ports are open (1433).

=========================

>If the address were invalid or the server were listening on a different
>port, you'd get an immediate failure. The fact that there's a 5-minute
>pause says to me the server accepted the connection, but couldn't transmit
>it back to the client.

=========================
Is there any possibility that the FreeTDS installation could be installed
into PHP incorrectly? What I'm wondering now is the lines that read:

16:33:45.235066 tds_put_string wrote 0 bytes
16:33:45.235247 tds_process_login_tokens()

Why is the first line writing 0 bytes? Is that not where the login
information is sent? Just prior to the tds_process_login_tokens?

Thanks again for your help!

Rick Conner
Rick AT wedosites.com


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page