thanks for the reply ken
Ken Williams wrote:
> My guess is that it's attempting to connect as the user you've got
> Apache set up to run under.
my guess is that youre right - access denied according to the error_log
but to be honest ive lost track of all the different users on osX
there are normal system-login users like me: username=aju
there are an apache user: username=???
there are an mysql user: username=mysql or undef im not sure
then there is this super user. everytime i install something i end up
needing to be super user so i have a sudo in front of almost any command
how can i see - for instance - the username for the apache server? (ive
look in httpd, it says nobody!)
and what if there are no username for an application like apache or
mysql, i mean if username= super user?
im quite confused
allan juul
> [EMAIL PROTECTED] (allan) wrote:
> >hi
> >
> >i have now finally installed the mysql server and the mysql driver.
> >
> >when i run the script (chmod'ed 777) below in the terminal i get this
> >output (which is correct):
> >
> >Content-Type: text/html
> >
> >one
> >two
> >Found a row: title = xterminator, format = 2lp
> >three
> >
> >
> >
> >however when i run the scirpt from my browser, where i know perl works
> >fine with apache i only get:
> >one
> >
> >
> >so my question is how can i get the same output in the brower?
> >
> >thanks
> >allan
> >
> >
> >
> >
> >______script____________
> >
> >#!/usr/bin/perl -w
> >print "Content-Type: text/html\n\n";
> >use strict;
> >use DBI();
> >print "one\n";
> >my $dbh = DBI->connect("DBI:mysql:database=lps;host=localhost","", "",
> >{'RaiseError' => 1});
> >print "two\n";
> >my $sth = $dbh->prepare("SELECT * FROM longplayers");
> >$sth->execute();
> >while (my $ref = $sth->fetchrow_hashref()) {
> > print "Found a row: title = $ref->{'title'}, format =
> >$ref->{'format'}\n";
> >}
> >$sth->finish();
> >$dbh->disconnect();
> >print "three\n";
> >
>
> ------------------- -------------------
> Ken Williams Last Bastion of Euclidity
> [EMAIL PROTECTED] The Math Forum
