[Perfparse-devel-int] Re: perfparse for Solaris compile errors

[Ben C. <bcl...@pe...>]

Comment about MySQL 4.1.x

Not tested, but I have no reason to believe PP will not work on this 
version.  There are no compatibility issues with the code we run.

However upgrading from 4.0.x and older, to 4.1.x is another questions. 
If you want to do this, you will have to dump all your data, upgrade 
MySQL, then reimport your data.

If you dump, please remember to add to the top of the dump script:

SET FOREIGN_KEY_CHECKS = 0;

And at the bottom:

SET FOREIGN_KEY_CHECKS = 1;

I hope this is of use to somebody.

Ben


Yves wrote:
>>Yves,
>>
>>Thank you very much for your quick response. This is the last gcc
>>command:
> 
> 
> Good, this is what I needed, not more, not less :)
> 
> 
>>gcc -shared -Wl,-h -Wl,libpp_storage_mysql.so.0 -o
>>.libs/libpp_storage_mysql.so.0.0.0
>>.libs/libpp_storage_mysql_la-storage_mysql.o
>>.libs/libpp_storage_mysql_la-libstorage.o -z allextract
>>/usr/local/mysql/lib/mysql/libmysqlclient.a -z defaultextract
>>-R/export/home/miedervd/perfparse-0.105.6/libpp_mysql/.libs
>>-R/usr/local/nagios/lib -R/usr/lib -R/usr/openwin/lib -R/usr/local/lib
>>-R/usr/local/BerkeleyDB.4.2/lib -R/usr/local/ssl/lib -L/usr/lib
>>-L/usr/openwin/lib -L/usr/local/lib -L/usr/local/BerkeleyDB.4.2/lib
>>-L/usr/local/ssl/lib -L/usr/local/mysql/lib/mysql -lposix4 -lcrypt -lgen
>>-L/export/home/miedervd/perfparse-0.105.6/libpp_mysql
>>/export/home/miedervd/perfparse-0.105.6/libpp_mysql/.libs/libpp_mysql.so
>>-ldl -lnsl -lm -lsocket -lc
>>Text relocation remains                         referenced
>>    against symbol                  offset      in file
>><unknown>                           0x5d0
>>/usr/local/mysql/lib/mysql/libmysqlclient.a(libmysql.o)
>><unknown>                           0x5d4
>>/usr/local/mysql/lib/mysql/libmysqlclient.a(libmysql.o)
>><unknown>                           0x5d8
>>/usr/local/mysql/lib/mysql/libmysqlclient.a(libmysql.o)
>><unknown>                           0x5dc
>>/usr/local/mysql/lib/mysql/libmysqlclient.a(libmysql.o)
>><unknown>                           0x5e0
>>/usr/local/mysql/lib/mysql/libmysqlclient.a(libmysql.o)
>>
>>
>><unknown> lines are a lot of them and the libmysqlclient.a(libmysql.o)
>>line is after the 0x5d* ...
>>Sounds like there are some problems with the mysql libs, but I can't
>>find out how to resolve it. I hope you can give me some help or know a
>>way out of this.
> 
> 
> You are right, the issue is with mysql libs. I know only 2 ways to solve your problem :
> 1/ complain about mysql libs where you got them, and convince them that the problem is
> not with perfparse but with mysql (you are not the only one who reports that problem).
> Help them to find the bug if you can. I presume that it's only a missing package on your
> environment, but I have no idea what it can be. And their package is bugged probably
> because it's missing a dependancy on the missing package.
> 
> 2/ do it yourself (faster that you think, easier than complaining...)
> - download mysql-4.0 (btw, we are not sure that perfparse works on 4.1 : ask Ben about
> that); mkdir -p /opt/mysql/mysql-4.0.22; ./configure --prefix=/opt/mysql/mysql-4.0.22;
> make; make install
> - Then in perfparse : ./configure [your options here]
> --with-mysql_config_dir=/opt/mysql/mysql-4.0.22/bin
> Don't forget to update $LD_LIBRARY_PATH with /opt/mysql/mysql-4.0.22/lib
> 
> 
> 
> 
>>By the way, creating packages for Solaris is very simple. Just follow
>>the instructions in the link below.
>>
>>http://www.eek.org/docs/spdoc.html
> 
> 
> With not a lot of time, and because I'm using my own mysql server (not from sunfreeware
> packages), I cannot do it. And if I were using sunfreeware packages, I would probably
> have the same problems as you, as others.
> btw, the others who have thoses problems installed from the sources and never complained
> again :)
> 
> Yves
>