Apache + php + openlink odbc

Apache + php + openlink odbc

Post by Charles Sprickma » Tue, 08 Feb 2000 04:00:00


I'm trying to get the Openlink ODBC drivers working so I can connect
to an MS-SQL DB.  The openlink test program is able to connect to the
SQL server and run a query, but my apache (1.3.9), php (3.0.14) combo
is not working well.  I've followed the directions in the php install
doc, replacing their mysql statement with an "openlink-dir" statement
with the path to the openlink drivers, libs, and SDK.  The compile
works fine and does not produce any errors.

The problem is that whenever I hit a test page that just does an
"odbc_connect", I get an empty document and this in the apache

[Mon Feb  7 15:05:20 2000] [notice] Apache/1.3.9 (Unix) PHP/3.0.14 configured -- resuming normal operations
/usr/libexec/ld-elf.so.1: /usr/local/openlink/lib/oplodbc.so.1.0: Undefined symbol "pthread_mutex_lock"          

If I give an incorrect uname or password in my odbc_connect call, I get
an error displayed by the odbc driver telling me so, only when it actually
tries to connect to the remote end does it give the above error...

Now I have other things running on this box (FreeBSD 3.4 Release) that use
pthreads (ie: mysql) and have calls to "pthread_mutex_lock", so what's

Any FreeBSD folks want to take a stab at this?  I'm concurrently working
with OLink support on this, but they seem a bit baffled...




1. Apache-DSO, PHP, Openlink, won't work

I try to connect from a linux Red Hat 6.2 as a Client to a Windows NT
4.0 Server Access DB, but somehow it doesn't do as it should.

Openlink: in /local/openlink
$ sh install.sh
$ . openlink.sh

Apache: in /local/apache_1.3.12
$./configure --prefix=/www --enable-shared=max
$make install

PHP: in /local/php-3.0.16
$./configure --prefix=/local --with-apxs=/www/bin/apxs
-with-openlink=/local/openlink --enable-track-vars
$ make
$ make install
When I try to start Apache, it says that "httpd started", without error.
But it didn't.
"ps ax" doesn't show any httpd process. I can't find any error messages
in the logs/error_log.

I think this is an PHP-Openlink Problem, because when I do the
Comment these lines in httpd.conf:
  #LoadModule php3_module        libexec/libphp3.so
  #AddModule  mod_hp3.c
$ ./apachectl start
Uncomment these lines
 LoadModule php3_module        libexec/libphp3.so
 AddModule  mod_hp3.c
$ ./apachectl restart  <--- a stop-start won't do
Apache is running.

I don't think this behavior is "normal". Apache DSO and PHP without
Openlink (no ODBC at all) is no problem.

Does anybody know what's wrong with that? Can I "trust" this Server,
when I use my strange method to run it?

2. censorship by Richard E. Depew

3. Apache 1.3.17 wont start (with PHP 404sp1, Openlink 4)

4. Finger gives only *some* users online

5. ODBC OpenLink

6. ATI 8500 Radeon All-in -Wonder?

7. mod_php3 and openlink ODBC

8. compose key

9. mod_php3 & OpenLink ODBC


11. Apache w/ PHP and SSL: w/ PHP OK - w/out PHP NOK

12. Apache Rewrite domain.com->index.php domain.org->index2.php

13. Solaris - PHP- Apache- Oracle : Problem getting PHP installed