Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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:57:47 +0000

ZIGLIO, Frediano, VF-IT 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 ?



Usually this is caused by ignoring that apache run with another account and
do not find user configurations.

According to my second email, it seems that apache can find the config of freetds. Here is the dump :

Starting log file for FreeTDS 0.62.4
on 2005-02-04 08:52:25 with debug level 99.
08:52:25.811966 Attempting to read conf files.
08:52:25.812088 ...$FREETDSCONF not set. Trying $FREETDS/etc.
08:52:25.812166 ...$FREETDS not set. Trying $HOME.
08:52:25.813214 Found conf file '/usr/local/freetds/etc/freetds.conf' (default). Reading section '172.30.0.47:1433'.
08:52:25.813345 Looking for section global.
08:52:25.813587 ... Found section global.
08:52:25.813676 Got a match.
08:52:25.813764 option = 'tds version' value = '4.2'.
08:52:25.813899 option = 'text size' value = '64512'.
08:52:25.815420 ... Found section jdbc.
08:52:25.815597 ... Found section jdbc_42.
08:52:25.815716 ... Found section mypool.
08:52:25.815877 Looking for section 172.30.0.47:1433.
08:52:25.816048 ... Found section global.
08:52:25.816202 ... Found section jdbc.
08:52:25.816320 ... Found section jdbc_42.
08:52:25.816436 ... Found section mypool.
08:52:25.816570 ...'172.30.0.47:1433' not found.
08:52:25.816684 Failed in reading conf file. Trying interface files.
08:52:25.816772 Looking for server 172.30.0.47:1433....
08:52:25.817383 Looking for server in /oracle/oracle8/app/oracle/product/8.1.7/.interfaces.
08:52:25.817498 Searching interfaces file //oracle/oracle8/app/oracle/product/8.1.7/.interfaces.
08:52:25.817684 Couldn't open /oracle/oracle8/app/oracle/product/8.1.7/.interfaces.
08:52:25.817788 Looking for server in /etc/freetds/interfaces.
08:52:25.817867 Searching interfaces file /etc/freetds/interfaces.
08:52:25.817993 Couldn't open /etc/freetds/interfaces.
08:52:25.818088 Setting 'ip_port' to 1433 as a guess.
08:52:25.870930 Parsed servername, now 172.30.0.47 on 1433.
08:52:25.871084 Setting 'dump_file' to '/tmp/freetds.log' from $TDSDUMP.

And i have tried to launch the php command line with the apache account, and it works.


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



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