php compile with pgsql and mysql problem

I have compiled php-5.2.0 on solaris 10 06/06, with the following
options:

--with-apxs2=/u01/app/apache/bin/apxs --with-mysql=/u01/app/mysql
--with-zlib-dir=/usr/local --with-pgsql=/u01/app/postgres --with-pear

and the compile seems to go okay, as does the install, but when I try
to start apache, I get this error:

'''
httpd: Syntax error on line 7 of /u01/app/apache/conf/httpd.conf:
Cannot load /u01/app/apache/modules/libphp5.so into server: ld.so.1:
httpd: fatal: relocation error: file
/u01/app/apache/modules/libphp5.so: symbol PQescapeStringConn:
referenced symbol not found
'''

the httpd.conf file is fine:

----------------------------------------------------------------
ServerRoot "/u01/app/apache"

#Listen 12.34.56.78:80
Listen 80

#LoadModule jk_module modules/mod_jk.so
LoadModule php5_module modules/libphp5.so

<IfModule !mpm_netware_module>
User nobody
Group nobody
</IfModule>
...etc...

----------------------------------------------------------------

the module is there in in the 'modules' dir.

I have googled for an hour now and I have seen a few things that
resemble this, but nothing that seems to be helping.

these are the other vitals:

apache 2.2.3 compiled with:

--prefix=/u01/app/apache --disable-ipv6 --enable-so --enable-rewrite
--with-apr=/usr/local/apr --with-apr-util=/usr/local/apr
--enable-proxy

postgresql-8.1.5 compiled with:
--prefix=/u01/app/postgres

mysql-5.0.27 compiled with:
--prefix=/u01/app/mysql --with-mysqld-user=mysql



anyone have any idea where I should be looking? or see any glaring
compile options mistakes?





Thanks for any advice,

avidFan

avidfan schrieb:
> I have compiled php-5.2.0 on solaris 10 06/06, with the following
> options:
>
> --with-apxs2=/u01/app/apache/bin/apxs --with-mysql=/u01/app/mysql
> --with-zlib-dir=/usr/local --with-pgsql=/u01/app/postgres --with-pear
>
> and the compile seems to go okay, as does the install, but when I try
> to start apache, I get this error:
>
> '''
> httpd: Syntax error on line 7 of /u01/app/apache/conf/httpd.conf:
> Cannot load /u01/app/apache/modules/libphp5.so into server: ld.so.1:
> httpd: fatal: relocation error: file
> /u01/app/apache/modules/libphp5.so: symbol PQescapeStringConn:
> referenced symbol not found


I guess your postgres libraries aren't in your system paths.
Did you also compile postgres yourself?
Make sure yur postgres libs are in the correct path, not sure if
solaries also uses ld.so.conf

> '''
>
> the httpd.conf file is fine:
>
> ----------------------------------------------------------------
> ServerRoot "/u01/app/apache"
>
> #Listen 12.34.56.78:80
> Listen 80
>
> #LoadModule jk_module modules/mod_jk.so
> LoadModule php5_module modules/libphp5.so
>
> <IfModule !mpm_netware_module>
> User nobody
> Group nobody
> </IfModule>
> ...etc...
>
> ----------------------------------------------------------------
>
> the module is there in in the 'modules' dir.
>
> I have googled for an hour now and I have seen a few things that
> resemble this, but nothing that seems to be helping.
>
> these are the other vitals:
>
> apache 2.2.3 compiled with:
>
> --prefix=/u01/app/apache --disable-ipv6 --enable-so --enable-rewrite
> --with-apr=/usr/local/apr --with-apr-util=/usr/local/apr
> --enable-proxy
>
> postgresql-8.1.5 compiled with:
> --prefix=/u01/app/postgres
>
> mysql-5.0.27 compiled with:
> --prefix=/u01/app/mysql --with-mysqld-user=mysql
>
>
>
> anyone have any idea where I should be looking? or see any glaring
> compile options mistakes?
>
>
>
>
>
> Thanks for any advice,
>
> avidFan
>
>
>

On Sat, 02 Dec 2006 10:17:43 +0100, Ric <antispam@randometry.com>
wrote:

>avidfan schrieb:
>> I have compiled php-5.2.0 on solaris 10 06/06, with the following
>> options:
>>
>> --with-apxs2=/u01/app/apache/bin/apxs --with-mysql=/u01/app/mysql
>> --with-zlib-dir=/usr/local --with-pgsql=/u01/app/postgres --with-pear
>>
>> and the compile seems to go okay, as does the install, but when I try
>> to start apache, I get this error:
>>
>> '''
>> httpd: Syntax error on line 7 of /u01/app/apache/conf/httpd.conf:
>> Cannot load /u01/app/apache/modules/libphp5.so into server: ld.so.1:
>> httpd: fatal: relocation error: file
>> /u01/app/apache/modules/libphp5.so: symbol PQescapeStringConn:
>> referenced symbol not found
>
>
>I guess your postgres libraries aren't in your system paths.
>Did you also compile postgres yourself?
>Make sure yur postgres libs are in the correct path, not sure if
>solaries also uses ld.so.conf
>
>> '''
>>
>> the httpd.conf file is fine:
>>
>> ----------------------------------------------------------------
>> ServerRoot "/u01/app/apache"
>>
>> #Listen 12.34.56.78:80
>> Listen 80
>>
>> #LoadModule jk_module modules/mod_jk.so
>> LoadModule php5_module modules/libphp5.so
>>
>> <IfModule !mpm_netware_module>
>> User nobody
>> Group nobody
>> </IfModule>
>> ...etc...
>>
>> ----------------------------------------------------------------
>>
>> the module is there in in the 'modules' dir.
>>
>> I have googled for an hour now and I have seen a few things that
>> resemble this, but nothing that seems to be helping.
>>
>> these are the other vitals:
>>
>> apache 2.2.3 compiled with:
>>
>> --prefix=/u01/app/apache --disable-ipv6 --enable-so --enable-rewrite
>> --with-apr=/usr/local/apr --with-apr-util=/usr/local/apr
>> --enable-proxy
>>
>> postgresql-8.1.5 compiled with:
>> --prefix=/u01/app/postgres
>>
>> mysql-5.0.27 compiled with:
>> --prefix=/u01/app/mysql --with-mysqld-user=mysql
>>
>>
>>
>> anyone have any idea where I should be looking? or see any glaring
>> compile options mistakes?
>>
>>
>>
>>
>>
>> Thanks for any advice,
>>
>> avidFan
>>
>>
>>

turns out that I forgot that solaris 10 comes with a version of
postgres and so when I compiled php, the configs were finding
libraries I didn't know about... I removed the postgres version that
comes with solaris 10 and recompiled my version of postgres and then
recompiled php now everything works.

Thanks for the advice.

avidFan