headers
msmonroe | 6 Nov 2002 02:01

make test fails on my solaris box

Hello,

I am having all sorts of trouble installing the MySQL DBD on my Sun Solaris machine. When I run 'make test',
after what appears to be a successful 'perl Makefile.PL' and 'make' I get back a the following error message;

...
Failed 17/18 test scripts, 5.56% okay. 724/727 subtests failed, 0.41% okay.
make: *** [test_dynamic] Error 2

I have tried building MySQL and Perl from source, as well as using pre-built binaries. In attempting to
build MySQL, Perl and the MySQL DBD, I have used several version of GCC including 2.95.3, 3.0.1, 3.1 and
3.2. In addition, I have attempted to install the following versions of the MySQL DBD;
Msql-Mysql-modules-1.2216, Msql-Mysql-modules-1.2219 and most recently DBD-mysql-2.1020. I get
the same error no matter what I do.

While I am new to the MySQL community I have been a UNIX sys-admin for many years. My environment is as follows:

Solaris 7 - all patches are up to date. (I have attempted to install the MySQL DBD running both the 32 and 64 bit
versions of the kernel)
MySQL version 3.23.45
ncurses 5.2
libgcc 3.1
zlib 1.1.4
Perl 5.8.0
GCC 3.1
DBD-mysql-2.1020
GNU versions of make and tar
Solaris versions of ar, ld etc...

Following are the responses I get back from running 'perl Makefile.PL', 'make' and 'make test':
(Continue reading)

Permalink | Reply | 0 comments |
headers
msmonroe | 8 Nov 2002 00:55

'make test' fails on solaris - more info

Here is an update on my problems getting a successful response with 'make test' on my Solaris box. My
environment is now:

Solaris 7 (64-bit Kernel)
MySQL 3.23.53 (yes it is installed correctly and up and running)
Perl 5.8.0 (I believe that DBI 1.30 comes with this version)

MySQL and Perl were built with GCC 3.2 (with libgcc 3.2 and GNU make, etc...)
 - yes, I have zlib installed (version 1.1.4)
 - yes, I used the GNU version of tar and not the Solaris version
 - yes, I used the Solaris /usr/ccs/bin utils and not GNU's bin utils

I am trying to install the DBD-mysql-2.1020 module. The machine I am building it on does not have access to
the Internet, so I'm not able to use CPAN to install it. I'm attempting to build it manually. Both perl and
mysql built, and are currently running without any glitches or errors. I just don't understand why the
'make test' fails so absolutely. Is there a known problem with Solaris and the DBD-mysql-2.1020 module?
Is there a problem with the Makefile.PL or with the libraries inside the DBD module? Or is the problem with
version 5.8.0 of Perl? Or better yet, some combination?

I've tried these various Makefile.PL options:

perl Makefile.PL --libs='-L/usr/local/lib -R/usr/local/lib -L/usr/local/mysql/lib/mysql
-lmysqlclient -lz -lcrypt -lgen -lsocket -lnsl -lm'

perl Makefile.PL --libs='-L/usr/local/lib -R/usr/local/lib
/usr/local/mysql/lib/mysql/libmysqlclient.a -lz -lcrypt -lgen -lsocket -lnsl -lm'

as well as many other derivations.

I am fresh out of ideas on what to try next. To pre-answer common response question:
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jochen Wiedmann | 8 Nov 2002 09:03
Picon

Re: 'make test' fails on solaris - more info

Zitiere msmonroe <msmonroe <at> stravin.com>:

> DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open

- Does this file exist on your local machine?
- If so: Is it a soft link? Pointing to what? Does the referenced
  file really exist? (Try "wc /usr/somwhere/libmysqlclient.so.10")
- Is it possible to create a soft link to /usr/lib or something
  similar? Perhaps just for the sake of testing?

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1966 <at> 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 <at> lists.mysql.com instead.
Permalink | Reply | 0 comments |
headers
Matthew Monroe | 9 Nov 2002 07:37

Re: 'make test' fails on solaris - more info

> Zitiere msmonroe <msmonroe <at> stravin.com>:
> 
> > DBD::mysql: ld.so.1: /usr/bin/perl: fatal: libmysqlclient.so.10: open
> 
> - Does this file exist on your local machine?
> - If so: Is it a soft link? Pointing to what? Does the referenced
>   file really exist? (Try "wc /usr/somwhere/libmysqlclient.so.10")
> - Is it possible to create a soft link to /usr/lib or something
>   similar? Perhaps just for the sake of testing?

Success!!

Yes, libmysqlclient.so.10 is in /usr/local/mysql/lib/mysql and is a soft
link to another file 'libmysqlclient.10.0.0' in the same directory.

I created another soft link in /usr/lib of libmysqlclient.so.10 to
/usr/local/mysql/lib/mysql/libmysqlclient.10.0.0. When I tried 'make
test' after this change, it worked!

I guess, even though the directory '/usr/local/mysql/lib/mysql' exists
in the output of the mysql_config --libs command, that doesn't ensure
that the linker can find those libraries.

Thanks Jochen, much appreciated.

Matthew Monroe
msmonroe <at> stravin.com

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
(Continue reading)

Permalink | Reply | 0 comments |
headers
Jens Harms | 11 Nov 2002 14:22
Picon

local module path (PREFIX) not used in tests

Hi,
i want to install dbd-mysql-2.1020 on unix, but i'm not root.

i tried this:
perl Makefile.PL PREFIX=$HOME/src/perl/modules
make
make test

the output:

t/insertid..........Can't locate DBI.pm in  <at> INC ( <at> INC contains: blib/arch
blib/lib /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005 . /usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.00503
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd
/usr/local/lib/perl5/site_perl/5.005 . /usr/libdata/perl/5.00503/mach
/usr/libdata/perl/5.00503) at t/insertid.t line 4.
BEGIN failed--compilation aborted at t/insertid.t line 4.
dubious

i think Makefile.PL should prepend the following code to any test program:

unshift(  <at> INC, $PREFIX );
( eg. unshift( <at> INC, "/home/jojo/localperlmodules" )

Jens Harms ( jens.harms <at> informatik.uni-oldenburg.de )

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
(Continue reading)

Permalink | Reply | 2 comments |
headers
Niño Fision | 11 Nov 2002 15:13
Picon

Re: local module path (PREFIX) not used in tests

"make test" is complaining about another module, named "DBI". You have to 
install this module before any DBD::*.
In fact, you have to use this module (which uses DBD::mysql) in your programs.

PREFIX problems would apeard when you will try to install it.

Niño Fision

El Lun 11 Nov 2002 10:22, Jens Harms escribió:
> Hi,
> i want to install dbd-mysql-2.1020 on unix, but i'm not root.
>
> i tried this:
> perl Makefile.PL PREFIX=$HOME/src/perl/modules
> make
> make test
>
> the output:
>
> t/insertid..........Can't locate DBI.pm in  <at> INC ( <at> INC contains: blib/arch
> blib/lib /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> /usr/local/lib/perl5/site_perl/5.005 . /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503
> /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> /usr/local/lib/perl5/site_perl/5.005 . /usr/libdata/perl/5.00503/mach
> /usr/libdata/perl/5.00503) at t/insertid.t line 4.
> BEGIN failed--compilation aborted at t/insertid.t line 4.
> dubious
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Jens Harms | 11 Nov 2002 15:49
Picon

Re: local module path (PREFIX) not used in tests

thank you. another problem apears if i try to install:

the makefile from DBD-mysql does not make use of PREFIX.

..perl Makefile.PL PREFIX=$HOME/local
..make install
..mkdir /usr/local/lib/perl5: Permission denied at
../usr/libdata/perl/5.00503/ExtUtils/Install.pm line 58

SOLUTION: installing DBD-mysql and DBI on UNIX without root permissons:
http://faqomatic.sourceforge.net/fom-serve/cache/437.html

Summary:
1. download DBD, DBI modules
2. untar, ungzip
3. HOME=your local home directory    <-- normaly already defined)
   mkdir $HOME/local
   mkdir $HOME/lib
   mkdir $HOME/bin
   export PERL5LIB=$HOME/lib/perl5:$HOME/lib/perl5/site_perl
   ( perl5lib is used to find perl modules, 'export' is known by bash )
4. CREATE FILE $HOME/perl-local
---- FILE: ~/perl-local -------------------------
PREFIX=$HOME/local \
INSTALLPRIVLIB=$HOME/local/lib/perl5 \
INSTALLSCRIPT=$HOME/local/bin \
INSTALLSITELIB=$HOME/local/lib/perl5/site_perl \
INSTALLBIN=$HOME/local/bin \
INSTALLMAN1DIR=$HOME/local/lib/perl5/man \
INSTALLMAN3DIR=$HOME/local/lib/perl5/man/man3
(Continue reading)

Permalink | Reply | 0 comments |
headers
Ken | 25 Nov 2002 17:21

SSL, mysql 4, windows, perl

Hi:

Newbie to the lists - searched the archives but didn't find many 
answers....  I apologize if this has been asked and answered already - if 
so, please point me to the article.

I'm trying to determine if it is possible to run mysql 4.x (or 3.x) on a 
windows 2000 machine and have a perl script running across the Internet 
also on a windows 2000 machine that communicates with the server using 
ssl/ssh.  I've got connectivity working using the perl modules, but can't 
figure out how to encrypt the data as it travels over the internet.

Is there a guide that someone could point me to?  Any advice would be 
greatly appreciated!

Thanks
Ken

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1974 <at> 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 <at> lists.mysql.com instead.
Permalink | Reply | 2 comments |
headers
Ken | 25 Nov 2002 17:32

Re: SSL, mysql 4, windows, perl

Got the (seemingly obvious and simple!!) answer from Andreas.
Great job guys!

At 11:25 AM 11/25/2002, Andreas Gietl wrote:
>On Monday 25 November 2002 17:21, Ken wrote:
>
>in mysql-4.X and newer DBD-version you can use
>
>  $dsn = "DBI:mysql:<dbname>:<host>:<port>;mysql_compression=1;mysql_ssl=1";
>  $dbh = DBI->connect($dsn, $user, $password);
>
>do create a connection ssl-encrypted.
>
> > Hi:
> >
> > Newbie to the lists - searched the archives but didn't find many
> > answers....  I apologize if this has been asked and answered already - if
> > so, please point me to the article.
> >
> > I'm trying to determine if it is possible to run mysql 4.x (or 3.x) on a
> > windows 2000 machine and have a perl script running across the Internet
> > also on a windows 2000 machine that communicates with the server using
> > ssl/ssh.  I've got connectivity working using the perl modules, but can't
> > figure out how to encrypt the data as it travels over the internet.
> >
> > Is there a guide that someone could point me to?  Any advice would be
> > greatly appreciated!
> >
> > Thanks
> > Ken
(Continue reading)

Permalink | Reply | 0 comments |
headers
Zheng Qian | 29 Nov 2002 01:34
Picon

some error

 I could not installed the DBD-mysql On redhat 8.0
It display

[root <at> localhost bugzilla-2.17.1]# perl -MCPAN -e 'install "DBD::mysql"'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Wed, 27 Nov 2002 21:53:28 GMT
Running install for module DBD::mysql
Running make for J/JW/JWIED/DBD-mysql-2.1020.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for 
/root/.cpan/sources/authors/id/J/JW/JWIED/DBD-mysql-2.1020.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-2.1020/
DBD-mysql-2.1020/t/
DBD-mysql-2.1020/t/mysql2.t
DBD-mysql-2.1020/t/akmisc.t
DBD-mysql-2.1020/t/60leaks.t
DBD-mysql-2.1020/t/10dsnlist.t
DBD-mysql-2.1020/t/ak-dbd.t
DBD-mysql-2.1020/t/50chopblanks.t
DBD-mysql-2.1020/t/mysql.t
DBD-mysql-2.1020/t/lib.pl
DBD-mysql-2.1020/t/40blobs.t
DBD-mysql-2.1020/t/40nulls.t
DBD-mysql-2.1020/t/insertid.t
DBD-mysql-2.1020/t/40listfields.t
DBD-mysql-2.1020/t/40bindparam.t
DBD-mysql-2.1020/t/mysql.dbtest
DBD-mysql-2.1020/t/dbdadmin.t
(Continue reading)

Permalink | Reply | 0 comments |

Gmane