DBI script works on command line but not in browser


Syntactic Confectionery Delight
	PerlMonks

DBI script works on command line but not in browser

by Anonymous Monk

on Jun 06, 2000 at 02:27 UTC ( #16511=perlquestion: print w/ replies, xml )

Need Help??

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

My DBI script works correctly when run by a web server, but I get syntax errors when running it from the command line (Perl 5 and FreeBSD server). Here's the code:

use DBI;
($db) = DBI->connect('DBI:mysql:DatabaseName, $dbusername);
[download]

Here are the corresponding errors:

syntax error in file MyScript.cgi at line 66, next 2 tokens "use DBI" 
syntax error in file MyScript.cgi at line 82, next 2 tokens "->" 
[download]

What's the problem?

Comment on DBI script works on command line but not in browser Select or Download Code
Re: script using DBI won't run from command line but runs great thru browser. why? by btrott (Parson) on Jun 06, 2000 at 03:02 UTC
Sounds like you're running it w/ perl4 under the command line. How are you executing the file? Where's your perl? Do you have 2 versions installed?	[reply]
Re: script using DBI won't run from command line but runs great thru browser. why? by IndyZ (Friar) on Jun 06, 2000 at 05:22 UTC
If I follow btrott correctly, you probanly have perl installed in two places, like perl4 in /bin/perl, and perl5 in /usr/bin/perl. try typing "whereis perl" and see where the binaries are. =Brian	[reply]
Re: DBI script works on command line but not in browser by Zombie codehopper (Initiate) on Mar 07, 2003 at 18:10 UTC
use DBI; my $dbh = DBI->connect("DBI:mysql:databasename:server", "user","password") or die "Couldn't connect to database";	[reply]

Back to Seekers of Perl Wisdom

Node Status^?

node history
Node Type: perlquestion [id://16511]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others musing on the Monastery: (15)

As of 2013-05-23 17:55 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

The best material for plates (tableware) is:

Results (487 votes), past polls