DBD::MySQL

DBD::MySQL

am 15.11.2010 19:01:53 von Andy

I have installed DBD:MySQL 4.0.18 on Perl 5.10, Mac OS X 10.6.

Any ideas about what I might have done wrong? About what I need to do to
fix it?
The following test script produces the errors shown below:
#!/usr/bin/perl -w
use strict;
use warnings;

use DBI;
use DBD::MySQL;

my $GCdbSchemaName = "gfrm";
my $GCdbUn = "gfrm";
my $GCdbPw = "gfrm";

my $dbHandle = DBI->connect("DBI:mysql:database=$GCdbSchemaName", $GCdbUn,
$GCdbPw);
exit;

Errors:
====
Thomas:gfrm gnicastro$ perl -w testDBIandDBD.pl
Subroutine driver redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 21.
Subroutine CLONE redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 38.
Subroutine _OdbcParse redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 42.
Subroutine _OdbcParseHost redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 77.
Subroutine AUTOLOAD redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 84.
Subroutine connect redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 103.
Subroutine data_sources redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 151.
Subroutine admin redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 169.
Subroutine prepare redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 217.
Subroutine db2ANSI redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 231.
Subroutine ANSI2db redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 237.
Subroutine admin redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 243.
Subroutine _SelectDB redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 252.
Subroutine table_info redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 256.
Subroutine _ListTables redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 386.
Subroutine column_info redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 395.
Subroutine primary_key_info redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 586.
Subroutine foreign_key_info redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 633.
Subroutine _version redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 714.
Subroutine get_info redefined at
/Library/Perl/5.10.0/darwin-thread-multi-2level/DBD/mysql.pm line 727.
Thomas:gfrm gnicastro$
======

Thanks for your help,
Andynic





--
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: DBD::MySQL

am 16.11.2010 11:33:47 von Dave Howorth

Andy wrote:
> I have installed DBD:MySQL 4.0.18 on Perl 5.10, Mac OS X 10.6.
>
> Any ideas about what I might have done wrong? About what I need to do to
> fix it?
> The following test script produces the errors shown below:
> #!/usr/bin/perl -w
> use strict;
> use warnings;
>
> use DBI;
> use DBD::MySQL;
>
> my $GCdbSchemaName = "gfrm";
> my $GCdbUn = "gfrm";
> my $GCdbPw = "gfrm";
>
> my $dbHandle = DBI->connect("DBI:mysql:database=$GCdbSchemaName", $GCdbUn,
> $GCdbPw);
> exit;

Well on my machine that code says "Can't locate DBD/MySQL.pm". It says
that because the module is actually called DBD::mysql.

So I doubt you have shown us the actual code you ran. Or do you have
some other module?

And you don't need to use DBD::mysql because DBI will do that.

Cheers, Dave

PS You don't need -w on the shebang line and on the command line and use
warnings as well! perl will get the hint with just one of them :)

--
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: DBD::MySQL

am 16.11.2010 11:41:20 von Peter Pentchev

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

On Tue, Nov 16, 2010 at 10:33:47AM +0000, Dave Howorth wrote:
> Andy wrote:
> > I have installed DBD:MySQL 4.0.18 on Perl 5.10, Mac OS X 10.6.
> >=20
> > Any ideas about what I might have done wrong? About what I need to do to
> > fix it?
> > The following test script produces the errors shown below:
> > #!/usr/bin/perl -w
> > use strict;
> > use warnings;
> >=20
> > use DBI;
> > use DBD::MySQL;
> >=20
> > my $GCdbSchemaName =3D "gfrm";
> > my $GCdbUn =3D "gfrm";
> > my $GCdbPw =3D "gfrm";
> >=20
> > my $dbHandle =3D DBI->connect("DBI:mysql:database=3D$GCdbSchemaName", $=
GCdbUn,
> > $GCdbPw);
> > exit;
>=20
> Well on my machine that code says "Can't locate DBD/MySQL.pm". It says
> that because the module is actually called DBD::mysql.
[snip]

..unless he's using it on a case-insensitive filesystem.

G'luck,
Peter

--=20
Peter Pentchev roam@space.bg roam@ringlet.net 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 every third, but it still comprehensible.

--GvXjxJ+pjyke8COw
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iQIcBAEBCAAGBQJM4l/LAAoJEGUe77AlJ98T/6EQAKl3i164F1k7l8lap9aA 6KVi
m4wd9uZQw9O7gJqeNDNP2SEjU2L7YJs84AwRyJWPMLo+jtVjnzmRRjJCiPtr +L8k
H7fMdfR4TOB+Lx+nDm6P8BxBsiRHmrARFcsviCV9hLY2+uKuogCRJH7e9f/h JiQK
vhBaXXAWlK1NHR//RaSR88aNAhWOPRD+ziIAHHmQb0FKdzuUd+fy+C0AHu4Y uTUL
OyWrOOUjRI/L6I78OHn/oorCzztP5k4wxX5AOPRy5oBX3+0BP6zhJJq5Rvot uTaW
TJS83iLAkBPRbc24ado1bJouEgmty91t+uETlJd6Xq31pVW8kxhiQxim7yzp +H3v
vJLXxT81ft4U/LMgOP42vXDwGRrMWw282pVBjhw59mYRXuiQqLDE9YIdUWoI AmHG
6ftDqrbuCUL5scm3VQ+6XmsOKKmqCL1rhF1vE6b/2xG5Shi92f4WarFqz96j OnRj
zuupvvlQkuH3cZN190V+0RBoqbLB3DoCyglUipyUmeP/pFRdsUqRM7Vv40dc LK8d
Pp/wvKEesnnghzoHQzr6eR/tyaRexxj6+D2WOYXdCNca/V/tLT1XB2rz0R+w hJAx
ywq4lKb7G8scedQGahV0PYTLRrdlu8u3wAdfSfbtlUFQTQ0TcPzAoHGx3FUN vJS/
9SLubGakTd4xHbrx3clo
=GP6x
-----END PGP SIGNATURE-----

--GvXjxJ+pjyke8COw--

Re: DBD::MySQL

am 16.11.2010 11:45:51 von Peter Pentchev

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

On Tue, Nov 16, 2010 at 12:41:20PM +0200, Peter Pentchev wrote:
> On Tue, Nov 16, 2010 at 10:33:47AM +0000, Dave Howorth wrote:
> > Andy wrote:
> > > I have installed DBD:MySQL 4.0.18 on Perl 5.10, Mac OS X 10.6.
> > >=20
> > > Any ideas about what I might have done wrong? About what I need to do=
to
> > > fix it?
> > > The following test script produces the errors shown below:
> > > #!/usr/bin/perl -w
> > > use strict;
> > > use warnings;
> > >=20
> > > use DBI;
> > > use DBD::MySQL;
> > >=20
> > > my $GCdbSchemaName =3D "gfrm";
> > > my $GCdbUn =3D "gfrm";
> > > my $GCdbPw =3D "gfrm";
> > >=20
> > > my $dbHandle =3D DBI->connect("DBI:mysql:database=3D$GCdbSchemaName",=
$GCdbUn,
> > > $GCdbPw);
> > > exit;
> >=20
> > Well on my machine that code says "Can't locate DBD/MySQL.pm". It says
> > that because the module is actually called DBD::mysql.
> [snip]
>=20
> ...unless he's using it on a case-insensitive filesystem.

Okay, that was a bit poorly-phrased :) Even if the original poster is
using the module on a case-insensitive filesystem, it would still be
called "DBD::mysql" and you'd still be right that it's actually called
"DBD::mysql" :) But this would not be a problem.

G'luck,
Peter

--=20
Peter Pentchev roam@space.bg roam@ringlet.net 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
If you think this sentence is confusing, then change one pig.

--8P1HSweYDcXXzwPJ
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iQIcBAEBCAAGBQJM4mDeAAoJEGUe77AlJ98TRXoP/1X+LaOuHX6TogAZkQF3 wA4Z
0nYLOS/1UhC3Wq5IYi8Hjno2j/wY41aZolHQOLiNu1O2/RUOg/Vbr/cjgCUL ue+S
OmLk2Je+1nY2LJ0G0GiFYLdLV8wijGO1s40kyo168ihV0l+xIhPY/T6iiGdC dHve
awaeWMpiqv9wgaYRA4JBh0jYJMMU0KAmOxXrIBT6Equh2LF5yym3b1igXOVl itRa
+nKemsbC7dTbucaHvHcutpHLByzAsH4060BNSUuj7TRYZkbLqcbimEvcWxtw w3Zs
jaNE6/lAFb3YnHm4TA6EKTeAO8wPnRGzdr7mkttzrdAmgG0oLZ88naO/CTKe K+O7
yyiU4X9Xe0lFh+csEdDTD9Zg/HcFjoYsS1qNqMLGQhSyVwcQFNSWrELlQniK arbW
jkxfw5kGrpG9pLpOHtmnyfxOyX15G8s8X62ea/r3d/R27J/Ca1Z2aEIHzgpM pra2
Eu4BJVV3KCaom5kaIGHdu8Xq8iqcDNlIVWB7u8iCULYmPBHfviYJX4oxZNKk RmD3
ll5nCmdXPfLWHLgMjnJk0wFu44LXpRYVel2TMkFDp82lSCD63DtAxoul4KUe 8wJ3
gvT+bAUjcD/U7DO6gLZjQriaZiNTGsoZlrJpVPI0HJIu/f0DLVCrwTF6brRV Oz/q
tc/i0tveXRhzi3gNqoRR
=T8WP
-----END PGP SIGNATURE-----

--8P1HSweYDcXXzwPJ--