Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: DBD::MySQL

Posted on 2010-11-15 19:01:53 by 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

Report this message

#2: Re: DBD::MySQL

Posted on 2010-11-16 11:33:47 by 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

Report this message

#3: Re: DBD::MySQL

Posted on 2010-11-16 11:41:20 by 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]

=2E..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--

Report this message

#4: Re: DBD::MySQL

Posted on 2010-11-16 11:45:51 by 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--

Report this message