[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cgi-list
Subject:    Re: [CGI] Why won't this word when called from the ALIASES file?
From:       "Mike Carpenter" <mikec () internet-software ! com>
Date:       1998-11-23 4:07:20
[Download RAW message or body]

Msql bases authentication on login username.  If you run this from aliases
you really haven't set the user yet.  Try it from a user's .forward file and
I'll bet you get past this.


Later...
Mike
-----Original Message-----
From: Jann Linder <jann@jann.com>
To: cgi-list@jann.com <cgi-list@jann.com>
Cc: CGI-L@vm.ege.edu.tr <CGI-L@vm.ege.edu.tr>
Date: Sunday, November 22, 1998 7:52 PM
Subject: [CGI] Why won't this word when called from the ALIASES file?


>I am working on a msql table which "answers" email and connects to a msql
database.
>
>it works when piping entries to it from the command line but, when called
from the /etc/aliases
>file, i get this error:
>
>The original message was received at Sun, 22 Nov 1998 15:56:34 -0800 (PST)
>from mg131-004.ricochet.net [204.179.131.4]
>
>   ----- The following addresses had permanent fatal errors -----
>"| /calendarplus/htdocs/contest/contestentry.pl"
>    (expanded from: <upgradecontest@jann.com>)
>
>   ----- Transcript of session follows -----
>searching for '981122220814997000018'
>Can't Connect: Can't find your username. Who are you? at
>/calendarplus/htdocs/contest/contestentry.pl line 116, <> chunk 79.
>554 "| /calendarplus/htdocs/contest/contestentry.pl" ... unknown mailer
error 255
>
>
>
>here is my subroutine:
>
>I have also tried to put in the username of my account and password in
place of the two undef's
>
>sub approve_seq {
>
> my ($row) = @_;
> my $dbh = DBI->connect('support',undef,undef,'mSQL') or die "Can't
Connect: $DBI::errstr";
>
> $sth = $dbh ->prepare(<<END);
>update contest set entered = 1 where _rowid = $row
>END
> if (!$sth->execute) {
>  die "ERROR:" .$sth->errstr."\n";
>  }
>  $sth->finish;
>  $dbh->disconnect;
>
> }
>
>Jann Linder
>Web Developer
>Perl Programmer
>
>Personal Site: http://www.jann.com/
>CalendarPlus Site: http://www.calendarplus.com/
>-----------------------------------------------------------------
>To unsubscribe, send mail to "majordomo@jann.com" with "unsubscribe
cgi-list"
>in the body.
>
>The CGI Tips & Tricks website (and archive of the list) is located
>at http://www.jann.com/Perl/
>
>cgi-list is hosted by Summit Communication Design
(http://www.summitdesign.net).
>
>Summit Communication Design is a full-service web hosting firm
>providing web design, cgi programming and inter/intra-net support.
>-----------------------------------------------------------------

-----------------------------------------------------------------
To unsubscribe, send mail to "majordomo@jann.com" with "unsubscribe cgi-list"
in the body.

The CGI Tips & Tricks website (and archive of the list) is located
at http://www.jann.com/Perl/

cgi-list is hosted by Summit Communication Design (http://www.summitdesign.net).

Summit Communication Design is a full-service web hosting firm
providing web design, cgi programming and inter/intra-net support.
-----------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]