Skip to Content.
Sympa Menu

freetds - [freetds] Antwort: Re: Crazy FreeTDS/PHP/Apache Problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Markus Jung <Markus.Jung AT tds.de>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Antwort: Re: Crazy FreeTDS/PHP/Apache Problem
  • Date: Thu, 14 Aug 2008 08:43:41 +0200

Hi James!

Thanks for your remarks.

Firewall ist no problem. Telnet connection to the server on 1433 works and
as I wrote
the a connection via the "tsql"-command works too. With the "tsql"-command
I can
connect and query the database.

Maybe I made it not clear enough, I had the problems with 0.82 and solved
them by
using 0.64. So my remedy was to downgrade.

I found out one thing with the PHP version. As I wrote in my first mail,
with a working
FreeTDS-"tsql"-tool (version 0.64) I hat the following experiences:

PHP 5.2.6: PHP-CLI = not working PHP Apache module = not working
PHP 5.2.3: PHP-CLI = working PHP Apache module = not working
PHP 5.2.1: PHP-CLI = working PHP Apache module = working (but
not stable and not always)

For every PHP-Build I used the same compiled version of FreeTDS 0.64.

What's wrong? By and by slowly I'm getting crazy...

Has anyone Apache-PHP-FreeTDS running on Solaris 9/10???? I yes, which
versions with which
compile options???

Thanks, Markus






"James K. Lowden" <jklowden AT freetds.org>
Gesendet von: freetds-bounces AT lists.ibiblio.org
13.08.2008 21:04
Bitte antworten an
FreeTDS Development Group <freetds AT lists.ibiblio.org>


An
FreeTDS Development Group <freetds AT lists.ibiblio.org>
Kopie

Thema
Re: [freetds] Crazy FreeTDS/PHP/Apache Problem






Markus Jung wrote:
>
> If I use th PHP-CLI to execute the script, it works fine. If I use
> apache and the PHP Extension to execute the script I will get the
> following error:
>
> Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
> server: sqlhost:1433 in /opt/httpd-2.2.9/htdocs/son/test.php on line 2
> ERROR: Connection to Server failed
>
>
> Before I got that far I tried FreeTDS 0.82 but with that version no
> connection via tsql could be established so I go back to 0.64. Than with
>
> 0.64 FreeTDS
> worked but PHP 5.2.6 couldn't even connect either with PHP-CLI or
> PHP-Apache-Module. So with the actual configuration I got the best
> results but the
> thing I need, the Apache-Thing, does still not work.

Well, since 0.82 is known to work, you almost certainly have local pilot
error.

Is 1433 the right port?

Likely is that apache needs permission to read freetds.conf. Possible is
some kind of firewall problem. From your description, I wouldn't count
out the possibility of two configurations stepping on each other.

I recommend 0.82. If you do have a problem with 0.64, your first remedy
will be to upgrade.

HTH.

--jkl
_______________________________________________
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