PHP4/mySQL/Apache config problem

[whitie]

Hi guys, I'm relatively new to PHP

I've successfully installed Apache with PHP4 as a module. I'm running Solaris 8 and compiled PHP and Apache from source. Standard PHP code prints fine to the browser but no mySQL functions are recognised :-( eg.

<?
$link = mysql_connect("localhost", "mysql_user", "mysql_password") or die(mysql_error());
?>

Results in:

Fatal error: Call to undefined function: mysql_connect()

I've seen similar postings to this one but no proposed solutions help. PHP was configured as follows:

./configure --prefix=/opt/SWIThttpd \
--with-apxs2=/opt/SWIThttpd/bin/apxs \
--enable-embed=shared
--enable-force-cgi-redirect \
--enable-discard-path --enable-fastcgi \
--with-exec-dir=/opt/SWIThttpd/bin \
--enable-sigchild --enable-magic-quotes \
--with-openssl=/opt/SWITssh
--enable-shared \
--enable-dba --with-flatfile --enable-dbase
--enable-dbx --enable-dio \
--with-gettext --with-iconv --with-java \
--with-mysql=shared,/opt/SWITperl/mysql

mySql is up and running in the directory above. Any changes to the "with-mysql" tag result in the build failing. Any help would be greatly appreciated.

Whitie

[Mordecai]

I searched Google and found a site describing how to install PHP with SFWmysql:
http://www.bolthole.com/solaris/php+solaris.html

Will this help?

[whitie]

Inspired me to check my config.nice file which showed me what config options were and the LDFLAGs that were used. looks like libtool is a joke and is using the libraries in the directory above mySQL. Weird.

Any thoughts fellas?

Whitie

[whitie]

Turns out I was compiling with the wrong libraries after all that. Many thanx for sending that link to me Mordecai I would never have thought of it otherwise.

Whitie.

[Mordecai]

Glad I could help. 🙂