Re: Re: Using php as a backend bridge between smtp and mysql

I got the sendmail part to work, but how do you process a pipe? I just need the variable name of yyy in "echo yyy | proc-mail.php" On 3/4/02 5:05 PM, "David Robley" <robleyd@paradise.net.nz> wrote: > In article <B8A82373.533D%ken@tossell.net>, ken@tossell.net says... >> Hi, >> I need to have php called from sendmail. I have set up an address to be >> aliased to "|/usr/local/bin/proc-mail" but I get an error saying "service >> unavailable". All permissions correct. See php code below. This is just a >> test mechanism, right now, to send the email to a mysql database for a >> free-webmail system. >> >> #!/usr/local/bin/php -q >> <?php >> $db_name = "mail"; >> $table_name = "Messages"; >> $connection = >> @mysql_pconnect("mysql.tossell.net","mail","fhsdbfhksdbfhjsd") >> or die("Couldn't connect."); >> $db = @mysql_select_db($db_name, $connection) or die("Couldn't select >> database."); >> $sql = "insert into $table_name (rcpt, send, subject) VALUES >> ('ken','ken@tossell.net','SUP?')"; >> mysql_select_db( $db_name, $connection ); >> mysql_query($sql); >> ?> >> >> Thanks. > > Presumably that script is /usr/local/bin/proc-mail and that is the > complete script? If so, given that it takes no 'external' information, > what happens when you try and run it from the shell? Is it executable by > the appropriate level of user?