freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3

From: Joffrey Pannequin <joffrey.pannequin AT laposte.net>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3
Date: Fri, 04 Feb 2005 11:44:20 +0000

Joffrey Pannequin wrote:

Hello,

I have several problems making freetds and php works together under AIX.
Has anyone successdully used this installation ?

At first, the apps and pools did not link OK. So I had to use the idea
of Fréderic le Guillou :
https://lists.ibiblio.org/sympa/arc/freetds/2004q3/016748.html

Now I have freetds which compiles and links OK. I can test the
connection to a SQL*Server DB with tsql.

I made this PHP test script :

<?php
$con = mssql_connect ("ip:port", "user", "****");
mssql_select_db ("db_name", $con);
$sql= "SELECT * FROM TABLE";
sleep(30);
$rs= mssql_query ($sql, $con);
echo "<html><head>/Title/</head><body>The field number one is:";
echo mssql_result ($rs, 0, 0);
echo " </body></html>";
mssql_close ($con);
?>

It works on the command line of php, but not from apache.
Why ?

Another problem : when I change the code of freetds, i can recompile and
install in /usr/local/freetds the libraries, but it seems php does not
use the libraries (I can delete them, php command line still works).

My compilation directive :

UnixODBC :
./configure --prefix=/usr/local/unixODBC --enable-gui=no

Freetds :

./configure --prefix=/usr/local/freetds
--with-unixodbc=/usr/local/unixODBC --with-tdsver=8.0 --enable-dbmfix

PHP :
./configure --prefix=/usr/local/php
--with-apxs=/usr/local/apache/bin/apxs
--with-oci8=/oracle/oracle8/app/oracle/product/8.1.7
--with-mssql=/usr/local/freetds --without-mysql
--with-unixODBC=/usr/local/unixODBC

Thanks,

Joffrey Pannequin

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

Some info :
The TDSCONFDUMP displays quite a lot of information. But TDSCONF only displays this :
Starting log file for FreeTDS 0.62.4
on 2005-02-04 08:52:25 with debug level 99.
So according to the source code, it locks after reading the conf but before opening the network connection to the DB.

[freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
- Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
- Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
  - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Frediano Ziglio, 02/05/2005
- <Possible follow-up(s)>
- RE: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, ZIGLIO, Frediano, VF-IT, 02/04/2005
  - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005
    - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, James K. Lowden, 02/04/2005
      - Re: [freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3, Joffrey Pannequin, 02/04/2005