From: Date: September 6 2002 4:13pm
Subject: Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example
List-Archive: http://lists.mysql.com/mysql/118940
Message-Id: <3D78B825.2030202@suppliersystems.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Write it in perl.
Perl has modules for MySQl and Email.


Keith Burke [Experience IT] wrote:

>Greetings,
>
>	I'm new to this list but not to MySQL. I've been using MySQL on
>Linux with PHP for the past year or two. I've always managed to sort out
>any problems by looking at the documentation on the website but my
>current problem has me perplexed.
>
>
>	I need to be able to send Emails to people from MySQL command
>line.
>
>
>	I'm importing a text file of users via a cronjob. MySQL process
>the data and segragates it into different tables. My problem is that I
>want MySQL to Email the plain text passwords to the users before it
>MD5's them. I cannot find any references that MySQL can run external
>programs [sendmail].
>
>Any help or workarounds [no matter how crazy ;-)] would be appriciated,
>although I'd rather not do the Emailing and MD5'ing at the data source.
>
>Oh, if this isn't the correct mailing list to post this, just let me
>know.
>
>
>
>
>
>Regards
>
>**************************************************************
>*       K   e   i   t   h           B   u   r   k   e        *
>**************************************************************
>* Experience IT Ltd       * Phone : +353 1 460 3880          *
>* G6                      * GSM   : +353 86 600 4004         *
>* Riverview Business Park * Email : kburke@stripped     *
>* New Nangor Road         * WWW   : http://www.experience.ie *
>* Dublin 12               ************************************
>* Ireland                 *       R   a   n   g   e   R      *
>**************************************************************
>*           Lieutenant, Your men are already dead            *
>**************************************************************
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread118927@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>