Re: mysql connection failing as CGI
- From: Ric <antispam@xxxxxxxxxxxxxx>
- Date: Wed, 22 Nov 2006 11:22:47 +0100
ianatkinsonbsc@xxxxxxxxx schrieb:
Hi,
I have a strange problem and I'm hoping someone can help. I've bought
some new hosting which comes with a MySQL database but I'm struggling
to get it working with any perl scripts; the hosting support are being
no help so I've had to come here, sorry guys!
The problem basically is that when the script is run as a CGI script it
won't connect to the database, however if I run the same script from
the command line (I have SSH access to the server) it runs fine.
Can you check apache log?
tail -f /var/log/http/error_log
you may find the apache log somewhere else depending on your OS.
In addition to that I would use eval to find out what went wrong, see below
The script is as follows (very simple):my $SQL;
--------------------------------------------------
#! /usr/bin/perl
use DBI;
print "Content-type: text/html\n\n";
print "<html><head></head><body>\n\nres:\n\n";
my $dbh;
my $sth;
eval{
$dbh =
DBI->connect("DBI:mysql:dbname:mydbname;host=213.171.218.249;port=3306",
"dbuser","dbpass",
{
RaiseError => 1
}
);
};
$SQL = "SELECT * FROM numbers";
$sth = $dbh->prepare($SQL);
$sth->execute();
if($@){
print $@;
}
while (@row = $sth->fetchrow_array) { print @row; print "\n"; }.
print "</body></html>";
--------------------------------------------------
And if I run it from the command line:
[domain1201232@ssh5 cgi-bin]$ perl numbers.pl
Content-type: text/html
<html><head></head><body>
res:
1
10
15
</body></html>
As you can see it connects to the database and retrieves the 3 ints sat
in there. If I run this from the CGI-bin however the only code output
is:
<html><head></head><body>
res:
i.e. the script falls over when it tries to make the database
connection and goes no further.
The hosting support are saying that I have not formed the connection
string properly, however if that was the case it wouldn't work from the
command line surely? I have also copied the script over to my machine
at home (verbatim and connecting to the same MySQL server) and it runs
fine from there also.
It seems to me like they have a firewalling problem maybe but I don't
have access to the Apache logs so I'm at a loss as to what else I can
try really. I did try the same thing in PHP (just using PHP syntax) and
that works OK, both on the command line and over the web which was
bringing me back round to the idea that it's a Perl problem, but I
really can't see anything wrong with it and if the syntax was wrong
it'd surely crap out on the command line as well!
Any ideas?
Thanks,
Ian.
- Follow-Ups:
- Re: mysql connection failing as CGI
- From: ianatkinsonbsc
- Re: mysql connection failing as CGI
- References:
- mysql connection failing as CGI
- From: ianatkinsonbsc
- mysql connection failing as CGI
- Prev by Date: Re: FAQ 6.19 What good is "\G" in a regular expression?
- Next by Date: Re: How to change Perl's concept of a newline in regexps?
- Previous by thread: Re: mysql connection failing as CGI
- Next by thread: Re: mysql connection failing as CGI
- Index(es):
Relevant Pages
|
|
