Re: [MySQL] HELP: Can MySQL run external programs... Sendmail for example

[walt]

"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 : [phone]          *
> * G6                      * GSM   : [phone]         *
> * 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-kernel=nea-fast.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Keith,
When you say "Emailing and MD5'ing at the data source.". Are you saying you dont
want to use PHP to insert and email the passwords?

walt