when the window pops up on your screen
> asking for your username / password. If you cancel it, or enter the
> wrong combination too many times, you get a 401 error.
I get an "Authorization Required
This server could not verify that you are authorized to access the document
requested. Either you supplied the wrong credentials (e.g., bad password),
or your browser doesn't understand how to supply the credentials required."
At present I am thinking that it is the missing .htgroup file and required
line in the .htaccess file that may be the problem. It was good to spell out
the problem with people in the know. I hope the new test users will sort
this out, but in order to do this I have to ask a friend to join as Paypal
will not allow my credit card to send money to myself, I then refund his
money and no cost is incurred. This may take some time as he is at work
----------------------------------------------------------------------------
----
Apache/1.3.27 Server
----- Original Message -----
From: "John Nichel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 1:29 PM
Subject: [wdvltalk] Re: htaccess & mysql
> Okay, these are two different things here. Which one is giving you the
> problem?
>
> The .htaccess validation is when the window pops up on your screen
> asking for your username / password. If you cancel it, or enter the
> wrong combination too many times, you get a 401 error. This has nothing
> to do with your database validation.
>
> cyberkate wrote:
> >>Can you post the relevant bit of code? There are a couple of PERL gurus
on
> >>this list
> >
> >>From .htaccess
> > <snip>
> > AuthName "Foo"
> > AuthType Basic
> > AuthUserFile /myfoopath/.htpasswd
> >
> > require valid-user
> > </snip>
> >
> >>From upload.pl
> > <snip>
> > use vars qw(%FORM $domain $dbuser $dbpass $dbh $imagedir $db);
> > my $rawuser = $cgi->param('user');
> > my $pass = $cgi->param('pass');
> > my $pic = $cgi->param('pic');
> >
> > </snip>
> > <snip>
> > if ($rawuser eq "" || $pass eq "") { error("You didn't enter
> > username/password!"); }
> > </snip>
> > <snip>
> > sub validate {
> >
> > $dbh = DBI->connect("DBI:mysql:$db:$domain",$dbuser,$dbpass) or
> > error("Connect error $DBI::errstr");
> >
> > my $password = crypt($pass, 'az');
> >
> > $SQL = "SELECT user_id FROM Users WHERE username = '$username' AND
password
> > = '$password'";
> > $query = $dbh->prepare($SQL) or error("prepare");
> > $query->execute or error("execute");
> > $id = $query->fetchrow_array();
> > $query->finish;
> >
> > if ($id eq "") { error("Username/Password not found!"); }
> > </snip>
> >
> > There is one thing that might explain it is that I not include the
.htgroup
> > element when these users were registered, however it shouldn't have
stopped
> > mid-session, I think, even with this omission, in fact I don't think
that
> > this element was ever included, but it was working for a long time
before
> > October, but I ca't remember and the backups shed no light as I did not
> > backup this 1 (possibly 2 file ) dir. The .htpasswrd file has the
correct
> > time stamp too.
> > ----- Original Message -----
> > From: "Jon Haworth" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, December 13, 2002 3:49 AM
> > Subject: [wdvltalk] Re: htaccess & mysql
> >
> >
> >
> >>Hi Kate,
> >>
> >>
> >>>The database password reconciles with the .htpassword
> >>>too, so does that eliminate my code too?
> >>
> >>Database password? I thought you were doing .htaccess/.htpasswd
> >>authentication?
> >>
> >>I've probably misunderstood something...
> >>
> >>Are you just storing the passwords in a database for reference, or are
you
> >>authenticating against the database?
> >>
> >>
> >>>The only thing that that coincides with the breakdown
> >>>was the upload.pl, worked last night, fell over today.
> >>
> >>Can you post the relevant bit of code? There are a couple of PERL gurus
on
> >>this list (not me, though)
> >>
> >>It might be helpful if you could post the .htaccess file as well in case
> >>there's a problem there.
> >>
> >>
> >>Cheers
> >>Jon
> >>
> >>____ � The WDVL Discussion List from WDVL.COM � ____
> >>To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
> >> Send Your Posts To: [EMAIL PROTECTED]
> >>To change subscription settings to the wdvltalk digest version:
> >> http://wdvl.internet.com/WDVL/Forum/#sub
> >>
> >>________________ http://www.wdvl.com _______________________
> >>
> >>You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> >>To unsubscribe send a blank email to %%email.unsub%%
> >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.427 / Virus Database: 240 - Release Date: 7/12/02
> >
> >
> > ____ � The WDVL Discussion List from WDVL.COM � ____
> > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
> > Send Your Posts To: [EMAIL PROTECTED]
> > To change subscription settings to the wdvltalk digest version:
> > http://wdvl.internet.com/WDVL/Forum/#sub
> >
> > ________________ http://www.wdvl.com _______________________
> >
> > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> > To unsubscribe send a blank email to %%email.unsub%%
> >
> >
> >
>
>
> --
> By-Tor.com
> It's all about the Rush
> http://www.by-tor.com
>
>
> ____ � The WDVL Discussion List from WDVL.COM � ____
> To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
> Send Your Posts To: [EMAIL PROTECTED]
> To change subscription settings to the wdvltalk digest version:
> http://wdvl.internet.com/WDVL/Forum/#sub
>
> ________________ http://www.wdvl.com _______________________
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to %%email.unsub%%
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/02
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
