RE: accessing MySQL via Perl

2005-03-26 Thread Gerald Preston
--- WGO Sent: Thursday, March 10, 2005 11:27 AM To: Gerald Preston; Randy Kobes Cc: activeperl@listserv.ActiveState.com Subject: RE: accessing MySQL via Perl [EMAIL PROTECTED] wrote: > David, > > I am trying to open the down loaded DBI.tar.gz file that is saved as > DBI.tar.tar. When I

Re: accessing MySQL via Perl

2005-03-14 Thread Howard Vihon
I had the same problem and am using DBI and DBD modules from ActiveState with MySQL 4.1. You are not going to like this workaround, but I hope it works for you also. I found that I was able to remove my name and password, and the connection would then work. My MySQL Server IS protected with a

RE: accessing MySQL via Perl

2005-03-10 Thread Wagner, David --- Senior Programmer Analyst --- WGO
[EMAIL PROTECTED] wrote: > David, > > I am trying to open the down loaded DBI.tar.gz file that is saved as > DBI.tar.tar. When I try to unzip the file I get "Error reading > header after processing 0 entries". Do you have a good copy or know > where I can download one. > > Thanks, > > Jerry

RE: accessing MySQL via Perl

2005-03-04 Thread Randy Kobes
On Fri, 4 Mar 2005, Gerald Preston wrote: > Randy, > > How do I install this with ppm? I see no ppd file. > > Jerry You should just be able to to, at a DOS prompt, C:\> ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd for ActivePerl 8xx, or C:\> ppm install http://theoryx5.uwinnip

RE: accessing MySQL via Perl

2005-03-04 Thread Gerald Preston
Randy, How do I install this with ppm? I see no ppd file. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Randy Kobes Sent: Friday, March 04, 2005 9:07 AM To: Gerald Preston Cc: activeperl@listserv.ActiveState.com Subject: Re: accessing MySQL via

RE: accessing MySQL via Perl

2005-03-04 Thread Wagner, David --- Senior Programmer Analyst --- WGO
y > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Wagner, David --- Senior Programmer Analyst --- WGO > Sent: Friday, March 04, 2005 11:01 AM > To: Randy Kobes; Gerald Preston > Cc: activeperl@listserv.ActiveState.com >

Re: accessing MySQL via Perl

2005-03-04 Thread Jeff Griffiths
Wagner, David --- Senior Programmer Analyst --- WGO wrote: ... I get "DBI connect<'club','gjwpp88',..> failed; Client does not support authentication protocol requested by server" Any ideas? This probably means that the DBD-mysql package you have wasn't compiled against mysql-4.1. We have such a p

RE: accessing MySQL via Perl

2005-03-04 Thread Gerald Preston
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wagner, David --- Senior Programmer Analyst --- WGO Sent: Friday, March 04, 2005 11:01 AM To: Randy Kobes; Gerald Preston Cc: activeperl@listserv.ActiveState.com Subject: RE: accessing MySQL via Perl [EMAIL PROTECTED] wrote: > On Fri, 4 Mar

RE: accessing MySQL via Perl

2005-03-04 Thread Wagner, David --- Senior Programmer Analyst --- WGO
[EMAIL PROTECTED] wrote: > On Fri, 4 Mar 2005, Gerald Preston wrote: > >> I am using Perl -v 5.8 and MySQL 4.1.10, just installed today. >> >> I am inserting some data with r following code: [ ... ] >> I get "DBI connect<'club','gjwpp88',..> failed; Client does not >> support authentication proto

Re: accessing MySQL via Perl

2005-03-04 Thread Randy Kobes
On Fri, 4 Mar 2005, Gerald Preston wrote: > I am using Perl -v 5.8 and MySQL 4.1.10, just installed today. > > I am inserting some data with r following code: [ ... ] > I get "DBI connect<'club','gjwpp88',..> failed; Client does not support > authentication protocol requested by server" > > Any id

RE: accessing MySQL via Perl

2005-03-04 Thread Chad I. Uretsky
Title: Message Perhaps instead of:   my $dbh=DBI->connect( 'dbi:mysql:club', 'gjwpp88', 'x' ) or die "\n$DBI::errstr\n";     you could try:   $dbh = DBI->connect ("DBI:mysql:host=localhost;database=club","gjwpp88","x") or die "\n$DBI::errstr\n";     You might even try:  

RE: accessing MySQL via Perl

2005-03-04 Thread Darren Barnes
WHERE    u.param4 = p.param5   For this query you can leave it out.   Darren   From: Gerald Preston [mailto:[EMAIL PROTECTED] Sent: 04 March 2005 09:33 To: 'Darren Barnes'; 'Mulley, Nikhil'; activeperl@listserv.ActiveState.com Subject: RE: accessing MySQL

RE: accessing MySQL via Perl

2005-03-04 Thread Gerald Preston
bject: RE: accessing MySQL via Perl   It states in the documentation to use DBD-mysql 2.9004 but I still had the same problem even upgrading. I believe it’s not handling the new 41-bit length passwords.   To get round it you can either start the database with old_passwords (--old_passwords) e

RE: accessing MySQL via Perl

2005-03-04 Thread Darren Barnes
It states in the documentation to use DBD-mysql 2.9004 but I still had the same problem even upgrading. I believe it’s not handling the new 41-bit length passwords.   To get round it you can either start the database with old_passwords (--old_passwords) enabled, then add the users but y

RE: accessing MySQL via Perl

2005-03-04 Thread Gerald Preston
DBI 1.46  and MySQL 4.1.10   Jerry   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mulley, Nikhil Sent: Friday, March 04, 2005 1:51 AM To: Gerald Preston; activeperl@listserv.ActiveState.com Subject: RE: accessing MySQL via Perl   What is the version of

RE: accessing MySQL via Perl

2005-03-03 Thread Mulley, Nikhil
What is the version of MySQL server you are using and the DBI version ? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Gerald PrestonSent: Friday, March 04, 2005 1:03 PMTo: activeperl@listserv.ActiveState.comSubject: accessing MySQL via