Greets Folks,
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
###### SCRIPT 1 ######
#! /usr/bin/perl -w
# intro4.pl - generate a Web page using the CGI.pm object-based interface
use strict;
use CGI;
my $cgi = new CGI;
print $cgi->header (),
$cgi->start_html ("My Page Title"),
$cgi->p ("My page body"),
$cgi->end_html ();
exit (0);
###### SCRIPT 2 ######
#! /usr/bin/perl -w
# intro6.pl - connect to MySQL, retrieve data, write plain text output
use strict;
use DBI;
use CGI qw(:standard);
my ($dbh, $sth, $count);
$dbh = DBI->connect ("DBI:mysql:host=localhost;database=*******",
"******", "*******", {PrintError => 0, RaiseError => 1});
$sth = $dbh->prepare ("SELECT name, wins, losses FROM teams");
$sth->execute ();
$count = 0;
while (my @val = $sth->fetchrow_array ())
{
print p (sprintf ("name = %s, wins = %d, losses = %d\n",
$val[0], $val[1], $val[2]));
++$count;
}
print "$count rows total\n";
$sth->finish ();
$dbh->disconnect ();
exit (0);
I have double checked everything. CGI.pm works withother scripts. Thwe
server I know for a fact has MySQL on it, DBI and DBD::mysql. the fiedls
have been uploaded in ASCII format, and I've CHMOD-ed them to 755.
I can't tell what else could be wrong. The only thing I can think of might
be the login command. I had to block out the real user names and passwords
and stuff with asterisks here, but the username and password I use are for
the DBA, an I am assuming that that user has read/write permissions. The
only other thing I can think of might be that the line
DBI:mysql:host=localhost might be different on the actual system than in the
book. Do any of these things sound possible? If so, how can I correct them
or get the right info?
Thanks,
Will
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
