msql 3.7 in php 5.1 error...

Hi. I am attempting to get msql3 installed with php. Using php version
php5.1-200604070430 and msql-3.7. I am getting the following error on
compile.

/usr/lib/gcc/x86_64-pc-linux-gnu/3.4.6/../../../../x86_64-pc -linux-gnu/bin/ld:
/usr/local/msql3/lib/libmsql.a(libmsql.o): relocation R_X86_64_32
against `a local symbol' can not be used when making a shared object;
recompile with -fPIC
/usr/local/msql3/lib/libmsql.a: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [libphp5.la] Error 1

I'm running 64 bit Gentoo 2.6.13. It states I need to recompile msql
with PIC support? I attempted to do it manually via 'make
EXTRA_CFLAGS=-fPIC' however config started complaining. How do i install
with PIC and is that recomended?

thanks,
anthony

Re: msql 3.7 in php 5.1 error...

anthony wrote:
> Hi. I am attempting to get msql3 installed with php. Using php version
> php5.1-200604070430 and msql-3.7. I am getting the following error on
> compile.
>
> /usr/lib/gcc/x86_64-pc-linux-gnu/3.4.6/../../../../x86_64-pc -linux-gnu/bin/ld:
> /usr/local/msql3/lib/libmsql.a(libmsql.o): relocation R_X86_64_32
> against `a local symbol' can not be used when making a shared object;
> recompile with -fPIC
> /usr/local/msql3/lib/libmsql.a: could not read symbols: Bad value
> collect2: ld returned 1 exit status
> make: *** [libphp5.la] Error 1
>
> I'm running 64 bit Gentoo 2.6.13. It states I need to recompile msql
> with PIC support? I attempted to do it manually via 'make
> EXTRA_CFLAGS=-fPIC' however config started complaining. How do i install
> with PIC and is that recomended?

echo "dev-lang/php msql" >> /etc/portage/package.use
emerge =dev-lang/php-5.1.2


//Aho

Re: msql 3.7 in php 5.1 error...

J.O. Aho wrote:
> echo "dev-lang/php msql" >> /etc/portage/package.use
> emerge =dev-lang/php-5.1.2
>
>
> //Aho

I was actually attempting to keep compiling php by hand. Unless theres a
way I can force it to use a specific cvs vers of php from snaps.php.net
via emerge? If so, then ill just add all my php flags and stuff into
package.use. I have use to compile apache by hand too, but now i just do
php.

-anthony

Re: msql 3.7 in php 5.1 error...

anthony wrote:
> J.O. Aho wrote:
>> echo "dev-lang/php msql" >> /etc/portage/package.use
>> emerge =dev-lang/php-5.1.2

> I was actually attempting to keep compiling php by hand.

As with ALL packages managed distros you will break dependency when you don't
use the package manger to install packages.


> Unless theres a
> way I can force it to use a specific cvs vers of php from snaps.php.net
> via emerge?

You need to build your own ebuilds which you place in the PORTDIR_OVERLAY.
There are two ways to do CVS-ebuilds

1. hardcoded to a version and this is the most common way they are offered

2. dynamical versions, download the source directly from the CVS and compile
those, there are a bunch of those in the portage tree so check cvs-ebuilds for
guidelines.


> If so, then ill just add all my php flags and stuff into
> package.use. I have use to compile apache by hand too, but now i just do
> php.

If you are testing new features in PHP and Apache, I do highly recommend you
do make ebuilds and submit those to the gentoo bugzilla and in that way
contribute to Gentoo and it's users.

http://gentoo-wiki.com/HOWTO_Create_an_Updated_Ebuild
http://www.gentoo.org/proj/en/devrel/handbook/handbook.xml?p art=2&chap=1


//Aho

Re: msql 3.7 in php 5.1 error...

OK. Im gonna go an do it that way. I agree with u that installing things
with out emerge can break stuff... ive seen it happen.

Is there a listing somewhere of what all the +/- variables mean? I have
the list but still trying to find out what the following are in gentoo:

--enable-discard-path = discard-path ?
--with-gettext
--with-mm
--enable-overload
--enable-dba
--enable-gd-native-ttf

--enable-gd-jis-conv = iconv ?
--with-zend-vm=GOTO = vm-goto ?
--with-java = java-external ?
--with-mcrypt = crypt ?

The rest I was able to figure out on my own.
thanks!




J.O. Aho wrote:

> anthony wrote:
>
>> J.O. Aho wrote:
>>
>>> echo "dev-lang/php msql" >> /etc/portage/package.use
>>> emerge =dev-lang/php-5.1.2
>
>
>> I was actually attempting to keep compiling php by hand.
>
>
> As with ALL packages managed distros you will break dependency when you
> don't use the package manger to install packages.
>
>
>> Unless theres a way I can force it to use a specific cvs vers of php
>> from snaps.php.net via emerge?
>
>
> You need to build your own ebuilds which you place in the PORTDIR_OVERLAY.
> There are two ways to do CVS-ebuilds
>
> 1. hardcoded to a version and this is the most common way they are offered
>
> 2. dynamical versions, download the source directly from the CVS and
> compile those, there are a bunch of those in the portage tree so check
> cvs-ebuilds for guidelines.
>
>
>> If so, then ill just add all my php flags and stuff into package.use.
>> I have use to compile apache by hand too, but now i just do php.
>
>
> If you are testing new features in PHP and Apache, I do highly recommend
> you do make ebuilds and submit those to the gentoo bugzilla and in that
> way contribute to Gentoo and it's users.
>
> http://gentoo-wiki.com/HOWTO_Create_an_Updated_Ebuild
> http://www.gentoo.org/proj/en/devrel/handbook/handbook.xml?p art=2&chap=1
>
>
> //Aho

Re: msql 3.7 in php 5.1 error...

anthony wrote:
> OK. Im gonna go an do it that way. I agree with u that installing things
> with out emerge can break stuff... ive seen it happen.
>
> Is there a listing somewhere of what all the +/- variables mean? I have
> the list but still trying to find out what the following are in gentoo:
>
> --enable-discard-path = discard-path ?
> --with-gettext
> --with-mm
> --enable-overload
> --enable-dba
> --enable-gd-native-ttf
>
> --enable-gd-jis-conv = iconv ?
> --with-zend-vm=GOTO = vm-goto ?
> --with-java = java-external ?
> --with-mcrypt = crypt ?

euse (app-portage/gentoolkit) can be of help here, it gives you information
about USE flags

[- ] iconv - Enable support for the iconv character set conversion library
[+ D ] crypt - Add support for encryption -- using mcrypt or gpg where applicable
[- ] vm-goto (dev-lang/php): Use the GOTO Zend-VM
[- ] java-external (dev-lang/php): Use the external java extension rather
than the bundled one
(your guesses seems to be correct).


Not all options are available as USE-flags in Gentoo, some you will need to
set in the my_conf varaible, or you can make your own USE-flag, but I think
it's better to hardcode the options, as we never know what will be official
USE flags and we could mess things up in worst case.

I guess you will need enable/disable the following hardcoded, at least I
didn't find a userflag for thise:

--enable-discard-path --with-gettext --with-mm --enable-overload --enable-dba
--enable-gd-native-ttf

Sometimes one an USE can enable more than one option too, seen this in
mozilla/seamonkey ebuilds, this of course makes it a bit more difficult to
track things, but enabling something twice don't hurt and I think when you
have one enable and one disable, the last one issued will take over, so I
think it can be good to see to that your options that isn't USE-flag
controlled are last for the configuration.
By the way, found that there is a pic USE-flag in the
/usr/portage/eclass/php5_1-sapi.eclass (not all are defined in the main ebuild).


//Aho

Re: msql 3.7 in php 5.1 error...

Well... It would seem the ebuild has issues. It may be that it doesnt
like having msql and mysql in the use flags at the same time or
something eles.

checking mSQL version... 1.0
checking for MSSQL support via FreeTDS... no
checking for MySQL support... yes
checking for specified location of the MySQL UNIX socket...
/var/run/mysqld/mysqld.sock
checking for MySQL UNIX socket location... /var/run/mysqld/mysqld.sock
checking for mysql_close in -lmysqlclient... no
checking for mysql_error in -lmysqlclient... no
configure: error: mysql configure failed. Please check config.log for
more information.

!!! ERROR: dev-lang/php-5.1.2 failed.
Call stack:
ebuild.sh, line 1526: Called dyn_compile
ebuild.sh, line 923: Called src_compile
php-5.1.2.ebuild, line 105: Called src_compile_normal
php-5.1.2.ebuild, line 218: Called php5_1-sapi_src_compile
php5_1-sapi.eclass, line 568: Called die

*sigh*.

-anthony

Re: msql 3.7 in php 5.1 error...

anthony wrote:
> Well... It would seem the ebuild has issues. It may be that it doesnt
> like having msql and mysql in the use flags at the same time or
> something eles.

You could try to use mysqli instead, it's the "future" in php.


//Aho

Re: msql 3.7 in php 5.1 error...

So mysqli instead of just mysql ?

J.O. Aho wrote:
> anthony wrote:
>
>> Well... It would seem the ebuild has issues. It may be that it doesnt
>> like having msql and mysql in the use flags at the same time or
>> something eles.
>
>
> You could try to use mysqli instead, it's the "future" in php.
>
>
> //Aho

Re: msql 3.7 in php 5.1 error...

Unfortunatlly the only sollution seems to be to use -msql. php won't
compile with it on gentoo. So I'm still stuck.
-anthony

anthony wrote:

> So mysqli instead of just mysql ?
>
> J.O. Aho wrote:
>
>> anthony wrote:
>>
>>> Well... It would seem the ebuild has issues. It may be that it doesnt
>>> like having msql and mysql in the use flags at the same time or
>>> something eles.
>>
>>
>>
>> You could try to use mysqli instead, it's the "future" in php.
>>
>>
>> //Aho

Re: msql 3.7 in php 5.1 error...

anthony wrote:
> Well... It would seem the ebuild has issues. It may be that it doesnt
> like having msql and mysql in the use flags at the same time or
> something eles.
>
> checking mSQL version... 1.0
> checking for MSSQL support via FreeTDS... no
> checking for MySQL support... yes
> checking for specified location of the MySQL UNIX socket...
> /var/run/mysqld/mysqld.sock
> checking for MySQL UNIX socket location... /var/run/mysqld/mysqld.sock
> checking for mysql_close in -lmysqlclient... no
> checking for mysql_error in -lmysqlclient... no
> configure: error: mysql configure failed. Please check config.log for
> more information.
>
> !!! ERROR: dev-lang/php-5.1.2 failed.
> Call stack:
> ebuild.sh, line 1526: Called dyn_compile
> ebuild.sh, line 923: Called src_compile
> php-5.1.2.ebuild, line 105: Called src_compile_normal
> php-5.1.2.ebuild, line 218: Called php5_1-sapi_src_compile
> php5_1-sapi.eclass, line 568: Called die

Looking at the php5_1-sapi.eclass, shows that the line is
../configure --prefix=${destdir} --sysconfdir=/etc --cache-file=./config.cache
${my_conf} || die "configure failed"

There shouldn't be anything causing the fault in there, except if Gentoo has a
patch that modifies the Makefile, in which case it will become less stable for
configuring some options, here I would suggest you check over the patches used
and remove it from the patch-list and try again.


//Aho