Hello, we have got a problem with the module php4_unixODBC. There is an error logged in the file /var/log/apache2/error_log: "usr/sbin/httpd2-prefork: error while loading shared libraries: /usr/lib/php/extensions/unixODBC.so: undefined symbol: SQLAllocEnv " Our system ist an 2.6 Linux server based on the SuSE distribution. Apache2 (2.0.49) , php4 (4.3.4), php-unixODBC (4.3.4), unixODBC (2.2.8) and unixODBC-devel (2.2.8) were installed with the admin software yast2. I am pretty sure, that the unixODBC connection ist functional because the command isql -v "ts_dsn" successfully connects to the database server (sybase ASA). The error shown above is logged everytime an "odbc_connection" ist called in php. This is our testfile: <? echo "Begin"; $conn=odbc_connect("ts_dsn","xxx","yyy") or die ("Failure"); echo "End"; ?> This problem was already mensioned in February by Ulrich Stärk and Sven Haberer, but I cannot find any solutions. Have you got an idea, what can be done to solve the problem? Best regards Jens
Hi, unfortunately I did not get any positive response on my mailing in February http://lists.suse.com/archive/suse-linux-e/2005-Feb/2644.html I did not try it using 9.3 though. Several other readers contacted me personally with the same issue, but as far as I am aware nobody was able to get this to work usings SUSE's PHP-unixODBC module. SUSE's tech support declines to work on this issue using the free installation support, their "per-incident billable technical support" could not solve this, and their marketing says they are not to be aware of this issue. My solution was to manually re-compile PHP4 with build-in unixODBC support, which works nicely, but is of course not as smooth as using YaST - and while I had no problems using YOU's, this will require a re-compile when upgrading to a new version... If desired, I could post a short description how I did this... Best regards, Sven Am Freitag, 22. April 2005 09:17 schrieb Jens Reinartz:
Hello,
we have got a problem with the module php4_unixODBC. There is an error logged in the file /var/log/apache2/error_log: "usr/sbin/httpd2-prefork: error while loading shared libraries: /usr/lib/php/extensions/unixODBC.so: undefined symbol: SQLAllocEnv "
Our system ist an 2.6 Linux server based on the SuSE distribution. Apache2 (2.0.49) , php4 (4.3.4), php-unixODBC (4.3.4), unixODBC (2.2.8) and unixODBC-devel (2.2.8) were installed with the admin software yast2.
I am pretty sure, that the unixODBC connection ist functional because the command isql -v "ts_dsn" successfully connects to the database server (sybase ASA).
The error shown above is logged everytime an "odbc_connection" ist called in php. This is our testfile: <? echo "Begin"; $conn=odbc_connect("ts_dsn","xxx","yyy") or die ("Failure"); echo "End"; ?>
This problem was already mensioned in February by Ulrich Stärk and Sven Haberer, but I cannot find any solutions.
Have you got an idea, what can be done to solve the problem?
Best regards Jens
Op zondag 24 april 2005 23:36, schreef Sven Haberer:
If desired, I could post a short description how I did this...
If you can put it own the wiki (http://www.susewiki.org): than we can all maintain it. -- Richard Bos Without a home the journey is endless
participants (3)
-
Jens Reinartz
-
Richard Bos
-
Sven Haberer