RE: [cobalt-users] Perl DBI/DBD

[BSmith@xxxxxxxxxxx]

-----Original Message-----
From: Troy Arnold
Subject: [cobalt-users] Perl DBI/DBD


Hi all. I have a client who needs the Perl DBI/DBD's installed. Located
install information, tars from MySQL and attempted to install but received
some errors when setting up the makefile. My questions are as follows...

1) Is the Perl DBI/DBD already installed on a RAQ4? I have the most recent
MySQL, PHP and Chilisoft apps installed and updated.
2) Should I be using the DBI from the mysql.org site or the one available on
CPAN?
3) Anyone install this on a RAQ (I am sure someone has), and if so can you
provide a short walkthrough of any changes you had to make to get the
install to run properly? I have followed the instructions in the readmes
but...?

Didn't have a lot of time this morning to outline this but figured I would
put the word out before I got too deep into researching the problem further.
It was a late night! Thanks in advance.

Best regards,
Troy Arnold
websetters, inc.

_____________________________________


Troy,

If you are just looking to use mySQL under Perl, it is included.  I have
used it
on a few of my applications, and have NOT had any issues.

I know the RaQ 550 does NOT come with the DBI for mySQl, but it is really
easy
to install.

You can use this to validate the mySQL DBI is installed:

use DBI();
my $dbh = DBI->connect("DBI:mysql:database=dbname;host=localhost",
"username", "password", {'RaiseError' => 1});\
$dbh->disconnect();

Do not create a database or anything, and you will get this error

DBI->connect(database=dbname;host=localhost) failed: Access denied for user:
'username@localhost' (Using password: YES) at try.pl line 2

Which just shows you that Perl knows how to talk to mySQL.

Have fun & Happy programming.

Brian