Re: Re: PHP & MSSQL on Linux

The error I'm getting is from the PHP function. Both mssql_connect and
PEAR are returning the same error. As far as I can tell, mssql only
returns the last line of an error message so I can't be sure that the
error I'm seeing is from MSSQL or PHP. Running TCPdump shows no
traffic is going to my sql database from the webserver. But when I run
tsql,it shows that communication occurred.

This looks like a problem with my PHP configuration but I'm at a loss as
to what it is.

Robbert

Micah Stevens wrote on 11/01/2005, 11:55:52
PM:
> Is it from php or the mssql driver? If it's from the driver, then the library
> is installed at least partially correctly. If it's from php, perhaps not.
>
> From there you can narrow it down by checking the connection parameters
> outside of php to make sure they're right, is there a mssql client for linux?
>
> If the driver is loading, I would hope it would give better error messages
> than just 'connection failed'.. but as I've never used the driver I might be
> wrong.
>
> You can also packet sniff the network during the connection attempt to see
> what goes on there, there's lots of clues that could be helpful in the packet
> stream.
>
> -Micah
>
> On Tuesday 01 November 2005 2:30 pm, php@swimwebs.com wrote:
> > A few months back I wrote the list asking for help making a connection
> > to a MS SQL database from our linux webserver. At that time I was able
> > to make a successfull connection on Fedora Core 1 after installing
> > php-mssql.rpm and a freetds rpm. When I upgradd to FC4, I was unable
> > to continue my project because the RPMs had not been built for
> > PHP5.0.4, whic is the version we run now.
> >
> > Today, I was able to get the version of php-mssql I needed and installed
> > it successfully. I am able to make a connection to our ms sql server
> > using tsql. There is a mssql.ini file in the php.d directory and the
> > mssql.so file is in /usr/lib/php/modules/. Using the
> > get_loaded_extensions fuction, I see that mssql is a loaded module and
> > the phpinfo() function shows me mssql configuration files. All
> > indicators tell me that I should be able to connect.
> >
> > Obvsiously, since I'm posting to the list, you can guess that it's not
> > working. The error message I get back is useless as I'm only told that
> > the connection failed. Does anyone know anything else I need to check
> > to get the connection working?
> >
> > Thank you,
> > Robbert van Andel
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP & MSSQL on Linux

Hmm.. if you're using a function like mssql_error or something like that, it's
likely coming from the driver and not php..

Did you see this on the docs page?

I have spent the last 2 days trying to get PHP to connect to MSDE on Windows
2003 Web Edition.

Although initally PHP would connect to the database without a problem, it
would then refuse to connect, hitting F5 enough times would eventually
connect to the database. As you can imagine this intermittent problem was
hard to trace.

I was using PHP 5.0.5 (although 5.0.4 has the same problem) on a Windows 2003
Web Edition SP1 server, and was trying to connect to MSDE Rel A.

Solution:
~~~~~~~~~

Firstly MSDE needed to be installed with the following arguments:
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0.

Secondly it was necessary to delete ntwdblib.dll from c:\php

Thirdly I downloaded the SQL 2000 evaluation and installed only the client
tools on a seperate PC (Ent. Manager will now connect to the database).

Lastly I copied the version of ntwdblib.dll from the PC with Ent. Manager on
it (ver 2000.80.2039.0) to c:\windows\system32\

After a re-boot no more connection problems.

Pls note that this is only for 2003 Web Edition with MSDE, this problem does
not seem to occour with Standard Edition

-Micah

On Tuesday 01 November 2005 3:18 pm, php@swimwebs.com wrote:
> The error I'm getting is from the PHP function. Both mssql_connect and
> PEAR are returning the same error. As far as I can tell, mssql only
> returns the last line of an error message so I can't be sure that the
> error I'm seeing is from MSSQL or PHP. Running TCPdump shows no
> traffic is going to my sql database from the webserver. But when I run
> tsql,it shows that communication occurred.
>
> This looks like a problem with my PHP configuration but I'm at a loss as
> to what it is.
>
> Robbert
>
> Micah Stevens wrote on 11/01/2005, 11:55:52
>
> PM:
> > Is it from php or the mssql driver? If it's from the driver, then the
> > library is installed at least partially correctly. If it's from php,
> > perhaps not.
> >
> > From there you can narrow it down by checking the connection parameters
> > outside of php to make sure they're right, is there a mssql client for
> > linux?
> >
> > If the driver is loading, I would hope it would give better error
> > messages than just 'connection failed'.. but as I've never used the
> > driver I might be wrong.
> >
> > You can also packet sniff the network during the connection attempt to
> > see what goes on there, there's lots of clues that could be helpful in
> > the packet stream.
> >
> > -Micah
> >
> > On Tuesday 01 November 2005 2:30 pm, php@swimwebs.com wrote:
> > > A few months back I wrote the list asking for help making a connection
> > > to a MS SQL database from our linux webserver. At that time I was able
> > > to make a successfull connection on Fedora Core 1 after installing
> > > php-mssql.rpm and a freetds rpm. When I upgradd to FC4, I was unable
> > > to continue my project because the RPMs had not been built for
> > > PHP5.0.4, whic is the version we run now.
> > >
> > > Today, I was able to get the version of php-mssql I needed and
> > > installed it successfully. I am able to make a connection to our ms
> > > sql server using tsql. There is a mssql.ini file in the php.d
> > > directory and the mssql.so file is in /usr/lib/php/modules/. Using the
> > > get_loaded_extensions fuction, I see that mssql is a loaded module and
> > > the phpinfo() function shows me mssql configuration files. All
> > > indicators tell me that I should be able to connect.
> > >
> > > Obvsiously, since I'm posting to the list, you can guess that it's not
> > > working. The error message I get back is useless as I'm only told that
> > > the connection failed. Does anyone know anything else I need to check
> > > to get the connection working?
> > >
> > > Thank you,
> > > Robbert van Andel
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP & MSSQL on Linux

There's actually a few issues with php5 connecting that have solutions on this
page:

http://us2.php.net/manual/en/function.mssql-connect.php

You may of read it already though..

On Tuesday 01 November 2005 3:24 pm, Micah Stevens wrote:
> Hmm.. if you're using a function like mssql_error or something like that,
> it's likely coming from the driver and not php..
>
> Did you see this on the docs page?
>
> I have spent the last 2 days trying to get PHP to connect to MSDE on
> Windows 2003 Web Edition.
>
> Although initally PHP would connect to the database without a problem, it
> would then refuse to connect, hitting F5 enough times would eventually
> connect to the database. As you can imagine this intermittent problem was
> hard to trace.
>
> I was using PHP 5.0.5 (although 5.0.4 has the same problem) on a Windows
> 2003 Web Edition SP1 server, and was trying to connect to MSDE Rel A.
>
> Solution:
> ~~~~~~~~~
>
> Firstly MSDE needed to be installed with the following arguments:
> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0.
>
> Secondly it was necessary to delete ntwdblib.dll from c:\php
>
> Thirdly I downloaded the SQL 2000 evaluation and installed only the client
> tools on a seperate PC (Ent. Manager will now connect to the database).
>
> Lastly I copied the version of ntwdblib.dll from the PC with Ent. Manager
> on it (ver 2000.80.2039.0) to c:\windows\system32\
>
> After a re-boot no more connection problems.
>
> Pls note that this is only for 2003 Web Edition with MSDE, this problem
> does not seem to occour with Standard Edition
>
> -Micah
>
> On Tuesday 01 November 2005 3:18 pm, php@swimwebs.com wrote:
> > The error I'm getting is from the PHP function. Both mssql_connect and
> > PEAR are returning the same error. As far as I can tell, mssql only
> > returns the last line of an error message so I can't be sure that the
> > error I'm seeing is from MSSQL or PHP. Running TCPdump shows no
> > traffic is going to my sql database from the webserver. But when I run
> > tsql,it shows that communication occurred.
> >
> > This looks like a problem with my PHP configuration but I'm at a loss as
> > to what it is.
> >
> > Robbert
> >
> > Micah Stevens wrote on 11/01/2005, 11:55:52
> >
> > PM:
> > > Is it from php or the mssql driver? If it's from the driver, then the
> > > library is installed at least partially correctly. If it's from php,
> > > perhaps not.
> > >
> > > From there you can narrow it down by checking the connection parameters
> > > outside of php to make sure they're right, is there a mssql client for
> > > linux?
> > >
> > > If the driver is loading, I would hope it would give better error
> > > messages than just 'connection failed'.. but as I've never used the
> > > driver I might be wrong.
> > >
> > > You can also packet sniff the network during the connection attempt to
> > > see what goes on there, there's lots of clues that could be helpful in
> > > the packet stream.
> > >
> > > -Micah
> > >
> > > On Tuesday 01 November 2005 2:30 pm, php@swimwebs.com wrote:
> > > > A few months back I wrote the list asking for help making a
> > > > connection to a MS SQL database from our linux webserver. At that
> > > > time I was able to make a successfull connection on Fedora Core 1
> > > > after installing php-mssql.rpm and a freetds rpm. When I upgradd to
> > > > FC4, I was unable to continue my project because the RPMs had not
> > > > been built for PHP5.0.4, whic is the version we run now.
> > > >
> > > > Today, I was able to get the version of php-mssql I needed and
> > > > installed it successfully. I am able to make a connection to our ms
> > > > sql server using tsql. There is a mssql.ini file in the php.d
> > > > directory and the mssql.so file is in /usr/lib/php/modules/. Using
> > > > the get_loaded_extensions fuction, I see that mssql is a loaded
> > > > module and the phpinfo() function shows me mssql configuration files.
> > > > All indicators tell me that I should be able to connect.
> > > >
> > > > Obvsiously, since I'm posting to the list, you can guess that it's
> > > > not working. The error message I get back is useless as I'm only
> > > > told that the connection failed. Does anyone know anything else I
> > > > need to check to get the connection working?
> > > >
> > > > Thank you,
> > > > Robbert van Andel
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php