[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    A solution to solve problem testing msql-mysql-Modules
From:       Enrico Sorcinelli <enrico.sorcinelli () sestante ! net>
Date:       1999-12-12 21:26:56
[Download RAW message or body]

At 12.58 12/12/99 +0100, Jochen Wiedmann wrote:
>Enrico Sorcinelli wrote:
>
> > The README file KNOW-BUGS section is not so clear! Following the
> > instruction, I've searched for libmysqlclient.so, but can't locate it!
> > I think that I don't have to compile MySQL (on my system) in order to work
> > with Perl, because the MySQL binary installation work fine (i.e, with mysql
> > client and with Apache/php scripts).
>
>The reason you don't see a "real solution" is that compiling your own
>MySQL version always immediately solved the problem ... :-)
>
>
>
>--
>Jochen Wiedmann                                         joe@ispsoft.de
>Life has brown and green eyes. :-)                      +49 711 7168586

Dear Jochen,
with some effort I've tryied to follow your 'hard' solution: a MySQL source 
distribution installation.
I will illustrate the complete procedure in order to install MySQL and Perl 
Support on my machine.

My system and software:
Linux Slackware 3.6 with 2.0.36 Kernel (re-builted)
libc 5.4.46 version
GNU gcc 2.8.1
GNU make 3.76.1
LinuxThreads 
0.7.1(ftp://ftp.inria.fr/INRIA/Projects/cristal/Xavier.Leroy/linuxthreads.ta 
r.gz)
MySQL 3.22.27 (source distribution)
DBI 1.13
Data-Dumper 2.101
Data-ShowTable 3.3
MSQL-MyQLS-Modules 1.2209
Perl 5.000_02

1st Step - Compiling and installing LinuxThreads
Because I've libc on my system I must install LinuxThreads libraries.
I've gunzipped and untared the package, then:
a. cd to source directory
b. vi Makefile (to edit Configuration section)
c. make
d. make install

2nd Step - Compiling and installing MySQL server
I've gunzipped and untared the package, then:
a. cd to source directory
b. ./configure --prefix=/usr/local/mysql-3.22.27
c. make
d. make check
e. make install

3rd Step - Compiling and installing Perl
[...]

4th Step - Compiling and installing Perl Support
I've gunzipped, untared and installed the packages:
Data-Dumper 2.101 [...]
DBI 1.13 [...]
Data-ShowTable 3.3 [...]
MSQL-MyQLS-Modules 1.2209

I must recompiled the last package with:

         perl Makefile.PL --static --config
         make
         make test
         make install

because only with:

         perl Makefile.PL

it was same error with MySQL binary distribution (install_driver(mysql) 
failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module 
DBD::mysql: Unable to resolve symbol at 
/usr/local/lib/perl5/5.00502/i586-linux/DynaLoader.pm line 168, etc.)

All tests successful, 1 test skipped (t/60leaks, why?)

At end of this long work I have a question: it's normal to build with 
--static option even if I recompiled all software with same gcc compiler on 
same machine?

I hope that my work will help some people with same problem!

Bye,
         Enrico Sorcinelli




---------------------------------------------------------------------------- 
---------
SESTANTE Media and Network Solutions S.n.c.
via Trave, 26 - 61032 Fano (PU)  Italy
Tel. 0721 865172 - Fax: 0721 803726
Internet: http://www.sestante.net
E-Mail: info@sestante.net
Secure Transaction Server: https://www.sestantenet.com


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread482@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]