issues compiling the DBD::mysql

am 19.08.2003 00:25:30 von Jeff.Hodge

------_=_NextPart_001_01C365D7.A21B7BB0
Content-Type: text/plain;
charset="iso-8859-1"

I'm having issues compiling the DBD::mysql.

Box - mysql 4.0.14/perl 5.8.0/modperl1.28/apache1.38/DBI 1.37

At first installing via cpan or source would bomb during perl makefile
without finding the mysql_config script. I installed mysql 4.0.14 via
rpm....mysql_config script didn't install; although it is working properly.
So then I downloaded and untare mysql-standard-4.0.14-pc-linux-i686 and
found the missing script in
.../mysql-standard-4.0.14-pc-linux-i686/bin/mysql_config.

After copying the script into my /usr/bin/ I find the make file gets
created, but the make is bombing out with the following:

Using DBI 1.37 installed in
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto
Writing Makefile for DBD::mysql
lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # make
cc -c
-I/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
-I -DPERL_Y2KW-DPERL_POLLUTE_MALLOC
-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOU-D_FILE_OFFSET_BITS=64 -O3
-DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic
usr/local/lib/perl5/5.8.0/i686-linux/CORE" dbdimp.c
In file included from dbdimp.c:29:
dbdimp.h:31: mysql.h: No such file or directory
dbdimp.h:32: errmsg.h: No such file or directory
make: *** [dbdimp.o] Error 1
lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # perl
Makefile.PL --cflags -I /bin/ -L /usr/lib/
I will use the following settings for compiling and
testing:

cflags (Users choice) = -I
libs (Users choice) = /usr/lib/
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL
--help' and
'perldoc INSTALL'.

Unrecognized argument in LIBS ignored: '/usr/lib/'
Using DBI 1.37 installed in
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto
Writing Makefile for DBD::mysql
lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # make
cc -c
-I/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
-I -DPERL_Y2KW-DPERL_POLLUTE_MALLOC
-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOU-D_FILE_OFFSET_BITS=64 -O3
-DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic
usr/local/lib/perl5/5.8.0/i686-linux/CORE" dbdimp.c
In file included from dbdimp.c:29:
dbdimp.h:31: mysql.h: No such file or directory
dbdimp.h:32: errmsg.h: No such file or directory
make: *** [dbdimp.o] Error 1

Does anybody have any suggestions?

I'm also thinking of compileing the source from
mysql-standard-4.0.14-pc-linux-i686 and try to re-build mysql first.
Although mysql is running, so this might be the wrong thing to do

thanks,

JH

------_=_NextPart_001_01C365D7.A21B7BB0--

Re: issues compiling the DBD::mysql

am 19.08.2003 01:11:53 von Leif W

Oops, meant to send to the list.

----- Original Message -----
From: "Leif W"
To: "Hodge, Jeff F (ECIII)"
Sent: Monday, August 18, 2003 6:58 PM
Subject: Re: issues compiling the DBD::mysql

> Hi,
>
> Try this instead:
>
> 1) 'cd' to one level up from mysql-standard-4.0.14-pc-linux-i686 (assuming
> /usr/local, but change as appropriate here and below):
>
> cd /usr/local/
>
> 2) make a symlink from your mysql directory to something short and simple
> like mysql:
>
> ln -s mysql-standard-4.0.14-pc-linux-i686 mysql
>
> 3) Put the mysql_config back into mysql-standard-4.0.14-pc-linux-i686/bin
>
> mv -iv /usr/bin/mysql_config /usr/local/mysql/bin
>
> 4) Add /usr/local/mysql/bin to your current PATH environment variable:
>
> PATH=$PATH:/usr/local/mysql/bin
>
> 5) You should add this directory to your ~/.profile, ~/.login, or
whichever
> startup script your shell uses so it's in the PATH nextime you login, and
> probably wouldn't hurt to add it to the system-wide /etc/profile or
> equivalent. Example of what the line looks like (in a BASH-style shell
> syntax:
>
>
>
PATH="/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/u sr/bin:/usr/loca
> l/mysql/bin"
>
> 6) Verify that mysql is installed correctly, that it runs, that you can
> login via the command line client, 'mysql'.
>
> 7) Try making the DBD::mysql module again.
>
>
> Leif
>
> ----- Original Message -----
> From: "Hodge, Jeff F (ECIII)"
> To:
> Sent: Monday, August 18, 2003 6:25 PM
> Subject: issues compiling the DBD::mysql
>
>
> > I'm having issues compiling the DBD::mysql.
> >
> > Box - mysql 4.0.14/perl 5.8.0/modperl1.28/apache1.38/DBI 1.37
> >
> > At first installing via cpan or source would bomb during perl makefile
> > without finding the mysql_config script. I installed mysql 4.0.14 via
> > rpm....mysql_config script didn't install; although it is working
> properly.
> > So then I downloaded and untare mysql-standard-4.0.14-pc-linux-i686 and
> > found the missing script in
> > ../mysql-standard-4.0.14-pc-linux-i686/bin/mysql_config.
> >
> > After copying the script into my /usr/bin/ I find the make file gets
> > created, but the make is bombing out with the following:
> >
> > Using DBI 1.37 installed in
> > /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto
> > Writing Makefile for DBD::mysql
> > lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # make
> > cc -c
> > -I/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
> > -I -DPERL_Y2KW-DPERL_POLLUTE_MALLOC
> > -fno-strict-aliasing -I/usr/local/include
> > -D_LARGEFILE_SOU-D_FILE_OFFSET_BITS=64 -O3
> > -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic
> > usr/local/lib/perl5/5.8.0/i686-linux/CORE" dbdimp.c
> > In file included from dbdimp.c:29:
> > dbdimp.h:31: mysql.h: No such file or directory
> > dbdimp.h:32: errmsg.h: No such file or directory
> > make: *** [dbdimp.o] Error 1
> > lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # perl
> > Makefile.PL --cflags -I /bin/ -L /usr/lib/
> > I will use the following settings for compiling and
> > testing:
> >
> > cflags (Users choice) = -I
> > libs (Users choice) = /usr/lib/
> > nocatchstderr (default ) = 0
> > nofoundrows (default ) = 0
> > ssl (guessed ) = 0
> > testdb (default ) = test
> > testhost (default ) =
> > testpassword (default ) =
> > testuser (default ) =
> >
> > To change these settings, see 'perl Makefile.PL
> > --help' and
> > 'perldoc INSTALL'.
> >
> > Unrecognized argument in LIBS ignored: '/usr/lib/'
> > Using DBI 1.37 installed in
> > /usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto
> > Writing Makefile for DBD::mysql
> > lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # make
> > cc -c
> > -I/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
> > -I -DPERL_Y2KW-DPERL_POLLUTE_MALLOC
> > -fno-strict-aliasing -I/usr/local/include
> > -D_LARGEFILE_SOU-D_FILE_OFFSET_BITS=64 -O3
> > -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic
> > usr/local/lib/perl5/5.8.0/i686-linux/CORE" dbdimp.c
> > In file included from dbdimp.c:29:
> > dbdimp.h:31: mysql.h: No such file or directory
> > dbdimp.h:32: errmsg.h: No such file or directory
> > make: *** [dbdimp.o] Error 1
> >
> >
> > Does anybody have any suggestions?
> >
> > I'm also thinking of compileing the source from
> > mysql-standard-4.0.14-pc-linux-i686 and try to re-build mysql first.
> > Although mysql is running, so this might be the wrong thing to do
> >
> > thanks,
> >
> > JH
> >
>

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: issues compiling the DBD::mysql

am 19.08.2003 01:11:53 von Leif W