PHP Language - php compile with pgsql and mysql problem

Author

php compile with pgsql and mysql problem

avidfan

2006-12-02, 3:57 am

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

Ric

2006-12-02, 3:57 am

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
>
>
>

avidfan

2006-12-03, 4:01 am

On Sat, 02 Dec 2006 10:17:43 +0100, Ric <antispam@randometry.com>
wrote:
[color=darkred]
>avidfan schrieb:
>
>
>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
>

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

Sponsored Links