[freetds] freeTDS 0.62.4 / PHP 4.3.8 / AIX 4.3.3

Joffrey Pannequin joffrey.pannequin at laposte.net
Fri Feb 4 06:57:47 EST 2005


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 :
>>http://lists.ibiblio.org/pipermail/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
>  
>




More information about the FreeTDS mailing list