Problem with DBI-1.45

Hi, I have just installed DBI-1.45 but when I run a
Perl
program to connect to MySQL I've got this errror

install_driver(mysql) failed: Can't locate
DBD/mysql.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully
installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge.
at mysql.pl line 2

Seeing the above error, I think I miss DBD so I also
downloaded DBD. But when I try to do perl Makefile.PL
I've got this error

Can't exec "mysql_config": No such file or directory
at Makefile.PL line 174.
readline() on closed filehandle PIPE at Makefile.PL
line 176.
Can't exec "mysql_config": No such file or directory
at Makefile.PL line 174.
readline() on closed filehandle PIPE at Makefile.PL
line 176.
Can't exec "mysql_config": No such file or directory
at Makefile.PL line 174.
readline() on closed filehandle PIPE at Makefile.PL
line 176.
Can't exec "mysql_config": No such file or directory
at Makefile.PL line 174.
readline() on closed filehandle PIPE at Makefile.PL
line 176.
Can't exec "mysql_config": No such file or directory
at Makefile.PL line 174.
readline() on closed filehandle PIPE at Makefile.PL
line 176.
Failed to determine directory of mysql.h. Use

perl Makefile.PL --cflags=-I

Re: Problem with DBI-1.45

Minh,

according to this group, you need to install the complete MySQL server on
that machine that you are installing DBI-1.45. It makes no sense to me,
since the MySQL server is a complete different server, so I don't see why I
need to install MySQL on a machine that all it's going to do is run some
perl script to manage the MySQL server.

So, I guess you need to install MySQL server.

I am still compiling it on my server, so, I'll let you know in a day or two.
:-)

I hope that helps.

josé


----- Original Message -----
From: "Minh Nguyen"
To:
Sent: Sunday, November 14, 2004 8:15 PM
Subject: Problem with DBI-1.45


>
> Hi, I have just installed DBI-1.45 but when I run a
> Perl
> program to connect to MySQL I've got this errror
>
> install_driver(mysql) failed: Can't locate
> DBD/mysql.pm in @INC (@INC contains:
> /usr/lib/perl5/5.8.3/i586-linux-thread-multi
> /usr/lib/perl5/5.8.3
> /usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.3
> /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.3
> /usr/lib/perl5/vendor_perl .) at (eval 1) line 3.
> Perhaps the DBD::mysql perl module hasn't been fully
> installed,
> or perhaps the capitalisation of 'mysql' isn't right.
> Available drivers: DBM, ExampleP, File, Proxy, Sponge.
> at mysql.pl line 2
>
> Seeing the above error, I think I miss DBD so I also
> downloaded DBD. But when I try to do perl Makefile.PL
> I've got this error
>
> Can't exec "mysql_config": No such file or directory
> at Makefile.PL line 174.
> readline() on closed filehandle PIPE at Makefile.PL
> line 176.
> Can't exec "mysql_config": No such file or directory
> at Makefile.PL line 174.
> readline() on closed filehandle PIPE at Makefile.PL
> line 176.
> Can't exec "mysql_config": No such file or directory
> at Makefile.PL line 174.
> readline() on closed filehandle PIPE at Makefile.PL
> line 176.
> Can't exec "mysql_config": No such file or directory
> at Makefile.PL line 174.
> readline() on closed filehandle PIPE at Makefile.PL
> line 176.
> Can't exec "mysql_config": No such file or directory
> at Makefile.PL line 174.
> readline() on closed filehandle PIPE at Makefile.PL
> line 176.
> Failed to determine directory of mysql.h. Use
>
> perl Makefile.PL --cflags=-I

Re: Problem with DBI-1.45

>according to this group, you need to install the complete MySQL server
on=20
>that machine that you are installing DBI-1.45. It makes no sense to
me,=20
>since the MySQL server is a complete different server, so I don't see
why I=20
>need to install MySQL on a machine that all it's going to do is run
some=20
>perl script to manage the MySQL server.

Yes, this solved mysteries for me, too. I really needed only the
mysql/lib and mysql/include files, but I had to have the latest versions
installed to get a good installation of the DBI/DBD.
--
Glenn Fleishman
seattle, washington
work and home: glennf.com
wireless data news: wifinetnews.com

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

Re: Problem with DBI-1.45

I have already installed MySQL server and client 4.1.
I can run the command line fine. However, one thing
I don't understand is that I can not find the
directory
/usr/local/mysql, which should exist right?

Minh

>
> Minh,
>
> according to this group, you need to install the
> complete MySQL server on
> that machine that you are installing DBI-1.45. It
> makes no sense to me,
> since the MySQL server is a complete different
> server, so I don't see why I
> need to install MySQL on a machine that all it's
> going to do is run some
> perl script to manage the MySQL server.
>
> So, I guess you need to install MySQL server.
>
> I am still compiling it on my server, so, I'll let
> you know in a day or two.
> :-)
>
> I hope that helps.
>
> josé
>
>
> ----- Original Message -----
> From: "Minh Nguyen"
> To:
> Sent: Sunday, November 14, 2004 8:15 PM
> Subject: Problem with DBI-1.45
>
>
> >
> > Hi, I have just installed DBI-1.45 but when I run
> a
> > Perl
> > program to connect to MySQL I've got this errror
> >
> > install_driver(mysql) failed: Can't locate
> > DBD/mysql.pm in @INC (@INC contains:
> > /usr/lib/perl5/5.8.3/i586-linux-thread-multi
> > /usr/lib/perl5/5.8.3
> >
>
/usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
> > /usr/lib/perl5/site_perl/5.8.3
> > /usr/lib/perl5/site_perl
> >
>
/usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
> > /usr/lib/perl5/vendor_perl/5.8.3
> > /usr/lib/perl5/vendor_perl .) at (eval 1) line 3.
> > Perhaps the DBD::mysql perl module hasn't been
> fully
> > installed,
> > or perhaps the capitalisation of 'mysql' isn't
> right.
> > Available drivers: DBM, ExampleP, File, Proxy,
> Sponge.
> > at mysql.pl line 2
> >
> > Seeing the above error, I think I miss DBD so I
> also
> > downloaded DBD. But when I try to do perl
> Makefile.PL
> > I've got this error
> >
> > Can't exec "mysql_config": No such file or
> directory
> > at Makefile.PL line 174.
> > readline() on closed filehandle PIPE at
> Makefile.PL
> > line 176.
> > Can't exec "mysql_config": No such file or
> directory
> > at Makefile.PL line 174.
> > readline() on closed filehandle PIPE at
> Makefile.PL
> > line 176.
> > Can't exec "mysql_config": No such file or
> directory
> > at Makefile.PL line 174.
> > readline() on closed filehandle PIPE at
> Makefile.PL
> > line 176.
> > Can't exec "mysql_config": No such file or
> directory
> > at Makefile.PL line 174.
> > readline() on closed filehandle PIPE at
> Makefile.PL
> > line 176.
> > Can't exec "mysql_config": No such file or
> directory
> > at Makefile.PL line 174.
> > readline() on closed filehandle PIPE at
> Makefile.PL
> > line 176.
> > Failed to determine directory of mysql.h. Use
> >
> > perl Makefile.PL --cflags=-I

Re: Problem with DBI-1.45

>I have already installed MySQL server and client 4.1.
>I can run the command line fine. However, one thing=20
>I don't understand is that I can not find the
>directory
>/usr/local/mysql, which should exist right?

You've got to copy or make symbolic links.

mv mysql-distribution-name /usr/local/
cd /usr/local
ln -s mysql-distribution-name mysql
cd /usr/lib
ln -s /usr/local/mysql/lib mysql
[if you get an error, "mv mysql mysql_lib_old"]
cd /usr/include
ln -s /usr/local/mysql/include mysql
[if you get an error, "mv mysql mysql_include_old"]
--
Glenn Fleishman
seattle, washington
work and home: glennf.com
wireless data news: wifinetnews.com

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

Re: Problem with DBI-1.45

Glenn,

> Yes, this solved mysteries for me, too. I really needed only the
> mysql/lib and mysql/include files, but I had to have the latest versions
> installed to get a good installation of the DBI/DBD.

this is the reason why it makes no sense to me. Here is the size of the
libraries,

-rw------- 1 jicman mailguest 1685 Nov 10 23:59 libmysql.imp
-rw------- 1 jicman mailguest 1993078 Nov 10 23:59 libmysqlclient.a
-rw------- 1 jicman mailguest 1899136 Nov 10 23:59 libmysqlclient_r.a
-rw------- 1 jicman mailguest 12319666 Nov 10 23:59 libmysqld.a
-rw------- 1 jicman mailguest 1260254 Nov 10 23:59 libmystrings.a
-rw------- 1 jicman mailguest 766332 Nov 10 23:59 libmysys.a

and here is the include files,

-rw------- 1 jicman mailguest 27526 Nov 10 23:58 mysql.h
-rw------- 1 jicman mailguest 15042 Nov 10 23:58 mysql_com.h
-rw------- 1 jicman mailguest 1241 Nov 10 23:58 mysql_embed.h
-rw------- 1 jicman mailguest 1559 Nov 10 23:58 mysql_time.h
-rw------- 1 jicman mailguest 800 Nov 10 23:58 mysql_version.h
-rw------- 1 jicman mailguest 11315 Nov 10 23:58 mysqld_error.h


There should be a simple mysqllib tar file that will allow a --prefix option
on the configure shell script to install the files using the prefix that the
user wants to use.

This is why one should not need to install the full DB server or even client
just to get these files.

Just a thought, of course. :-)
I don't know how big the mysql libraries and include files are, but I don't
think it should be more than database


--
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: Problem with DBI-1.45

--a8Wt8u1KmwUX3Y2C
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, Nov 14, 2004 at 08:23:29PM -0500, jose isaias cabrera wrote:
>=20
> Minh,
>=20
> according to this group, you need to install the complete MySQL server on=
=20
> that machine that you are installing DBI-1.45. It makes no sense to me,=
=20
> since the MySQL server is a complete different server, so I don't see why=
I=20
> need to install MySQL on a machine that all it's going to do is run some=
=20
> perl script to manage the MySQL server.

Errr... oops. Guess this was partly my fault.

You do not really need to install the full-blown MySQL server, sorry :(
All you need is the client libraries - download the full MySQL source
(it is a single source tarball for everything), then ./configure it with
your favorite values for --prefix and specify --without-server, too :)
This will only build the client libraries.

Once again, sorry for omitting this kinda important detail :(

G'luck,
Peter

--=20
Peter Pentchev roam@ringlet.net roam@cnsys.bg roam@FreeBSD.org
PGP key: http://people.FreeBSD.org/~roam/roam.key.asc
Key fingerprint FDBA FD79 C26F 3C51 C95E DF9E ED18 B68D 1619 4553
This sentence is false.

--a8Wt8u1KmwUX3Y2C
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (FreeBSD)

iD8DBQFBmGal7Ri2jRYZRVMRAo0rAJ4uE7uXsyILsdlaaFT1Eo+11HrfHACg tu6U
0iEeydyR3HA/EXZ7cOwc8Cc=
=qy1G
-----END PGP SIGNATURE-----

--a8Wt8u1KmwUX3Y2C--

Re: Problem with DBI-1.45

--v9Ux+11Zm5mwPlX6
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, Nov 14, 2004 at 05:40:38PM -0800, Glenn Fleishman wrote:
> >I have already installed MySQL server and client 4.1.
> >I can run the command line fine. However, one thing=20
> >I don't understand is that I can not find the
> >directory
> >/usr/local/mysql, which should exist right?

Actually, no - it depends on the installation type. If you installed
the MySQL server and client from the packages supplied at the mysql.com
website, then most probably those directories should exist. If,
however, your MySQL server and client installation came from your OS's
vendor packages - e.g. RPM's found on RedHat install CD's, Debian .deb
files, FreeBSD ports/packages or something - then the installation
directory may not necessarily be /usr/local/mysql. You might have to
look for a mysql_config script - check if there is a
/usr/bin/mysql_config, /usr/local/bin/mysql_config, or just do a
"whereis mysql_config" or, if that fails, "locate mysql_config". It
will tell you best where to find your MySQL installation :)

By the way, the key to the errors you are getting in the DBD::mysql
installation is mostly that - the DBD::mysql Makefile.PL cannot find the
mysql_config script, which is supposed to tell it where to find the
header files and the library. If you can find mysql_config on your
system, then the best way to build DBD::mysql would be to add to your
PATH variable the directory where mysql_config lives, so Makefile.PL can
find it. If you are using a Bourne-like shell (sh, ksh, bash, zsh,
..), and if, say, you find mysql_config in /usr/mysql/bin/mysql_config,
then do the following:

PATH=3D"/usr/mysql/bin:$PATH"
export PATH

For csh-like shells, that would be:

set path =3D ( /usr/mysql/bin $path )

After that, re-running 'perl Makefile.PL' for DBD::mysql should work
just fine.

> You've got to copy or make symbolic links.
>=20
> mv mysql-distribution-name /usr/local/
[snip other commands]

Of course, that's assuming that 'mysql-distribution-name' refers to an
official distribution obtained from the mysql.com download sites :)

G'luck,
Peter

--=20
Peter Pentchev roam@ringlet.net roam@cnsys.bg roam@FreeBSD.org
PGP key: http://people.FreeBSD.org/~roam/roam.key.asc
Key fingerprint FDBA FD79 C26F 3C51 C95E DF9E ED18 B68D 1619 4553
The rest of this sentence is written in Thailand, on

--v9Ux+11Zm5mwPlX6
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (FreeBSD)

iD8DBQFBmGu77Ri2jRYZRVMRAv5OAJ4yc6+9hgxS8kiFdFedB20ipn/PxwCg izJz
HsSnnWqh9UYw0Poxgxxz0fY=
=IVlC
-----END PGP SIGNATURE-----

--v9Ux+11Zm5mwPlX6--

Re: Problem with DBI-1.45

> Errr... oops. Guess this was partly my fault.
>
> You do not really need to install the full-blown MySQL server, sorry :(
> All you need is the client libraries - download the full MySQL source
> (it is a single source tarball for everything), then ./configure it with
> your favorite values for --prefix and specify --without-server, too :)
> This will only build the client libraries.
>
> Once again, sorry for omitting this kinda important detail :(

It's ok. :-) I still have about 1/2 day build run. :-) I'd rather try
this new option, since I need the space for other stuff. :-)

thanks again.

josé


--
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: Problem with DBI-1.45

Hi Peter, I've tried all you suggested but still
cannot find where mysql_config is.

I'm using SuSe and it does include mysql. However,
I've reinstalled mysql using the following rpm files
from the official website:

MySQL-client-4.1.7-0.i386.rpm
MySQL-server-4.1.7-0.i386.rpm
MySQL-shared-4.0.22-0.i386.rpm

So how come I still don't have mysql_config?

Minh

--- Peter Pentchev wrote:

> On Sun, Nov 14, 2004 at 05:40:38PM -0800, Glenn
> Fleishman wrote:
> > >I have already installed MySQL server and client
> 4.1.
> > >I can run the command line fine. However, one
> thing
> > >I don't understand is that I can not find the
> > >directory
> > >/usr/local/mysql, which should exist right?
>
> Actually, no - it depends on the installation type.
> If you installed
> the MySQL server and client from the packages
> supplied at the mysql.com
> website, then most probably those directories should
> exist. If,
> however, your MySQL server and client installation
> came from your OS's
> vendor packages - e.g. RPM's found on RedHat install
> CD's, Debian .deb
> files, FreeBSD ports/packages or something - then
> the installation
> directory may not necessarily be /usr/local/mysql.
> You might have to
> look for a mysql_config script - check if there is a
> /usr/bin/mysql_config, /usr/local/bin/mysql_config,
> or just do a
> "whereis mysql_config" or, if that fails, "locate
> mysql_config". It
> will tell you best where to find your MySQL
> installation :)
>
> By the way, the key to the errors you are getting in
> the DBD::mysql
> installation is mostly that - the DBD::mysql
> Makefile.PL cannot find the
> mysql_config script, which is supposed to tell it
> where to find the
> header files and the library. If you can find
> mysql_config on your
> system, then the best way to build DBD::mysql would
> be to add to your
> PATH variable the directory where mysql_config
> lives, so Makefile.PL can
> find it. If you are using a Bourne-like shell (sh,
> ksh, bash, zsh,
> ...), and if, say, you find mysql_config in
> /usr/mysql/bin/mysql_config,
> then do the following:
>
> PATH="/usr/mysql/bin:$PATH"
> export PATH
>
> For csh-like shells, that would be:
>
> set path = ( /usr/mysql/bin $path )
>
> After that, re-running 'perl Makefile.PL' for
> DBD::mysql should work
> just fine.
>
> > You've got to copy or make symbolic links.
> >
> > mv mysql-distribution-name /usr/local/
> [snip other commands]
>
> Of course, that's assuming that
> 'mysql-distribution-name' refers to an
> official distribution obtained from the mysql.com
> download sites :)
>
> G'luck,
> Peter
>
> --
> Peter Pentchev roam@ringlet.net roam@cnsys.bg
> roam@FreeBSD.org
> PGP key:
> http://people.FreeBSD.org/~roam/roam.key.asc
> Key fingerprint FDBA FD79 C26F 3C51 C95E DF9E ED18
> B68D 1619 4553
> The rest of this sentence is written in Thailand, on
>

> ATTACHMENT part 2 application/pgp-signature





__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com



--
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: Problem with DBI-1.45

Minh Nguyen wrote:

> MySQL-client-4.1.7-0.i386.rpm
> MySQL-server-4.1.7-0.i386.rpm
> MySQL-shared-4.0.22-0.i386.rpm

MySQL-devel?

--
http://lilypie.com/baby1/050423/1/5/1/+1

--
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