> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Federico Sevilla III > Sent: Tuesday, October 01, 2002 7:24 PM > To: [EMAIL PROTECTED] > Subject: Re: [plug] Postfix Inquiry > > > I doubt it'll be a pleasant task for you to develop this > system using the Korn Shell. I don't think you have to get > into a power struggle with your administrators, anyway. > You can work around (and with) the current systems.
I'll check this out in our meeting. > Why don't you install Python, Perl, or some other friendlier > scripting language on a GNU/Linux box, which will act as your > glue between the Oracle database server and the Exchange > email server, doing the grunt work of creating customized > email messages using a template and perhaps handling and > rerouting email that gets sent to your central [EMAIL PROTECTED] > mailbox? I have an idea that the scripts will reside in the same machine where our CBR Oracle database is located. This is most probably what will happen: - We'll just use Korn Shell to make scripts - Create a new table that contains info for notification that includes the e-mail addresses - Create a generic text file that contains the form/template for the e-mail message - The scripts will get the info from the table and append the data gathered from that table to the form/template (text file) - Make a cron for every 5 minutes to check if there are new payments and send a notification e-mail message to the taxpayer - We'll just use the "mail" command to send the e-mail message. But my problem is, is it possible to use "$ cat form | mail [EMAIL PROTECTED]" but the SMTP is located from the different site? Let's say that the scripts, form and the database is located at 192.168.0.1 (Quezon City) and our SMTP (Postfix) is located at 192.168.0.2 (Makati City). How can I do it? BTW, I think we're using Postfix as our MTA already. Thanks. --- MARVIN T. PASCUAL E-Mail: [EMAIL PROTECTED] Tel. #: (+63-2) 925-2053/981-7068 Mobile #: (+62-919) 314-1254 Linux User No. 247147
BEGIN:VCARD VERSION:2.1 N:Pascual;Marvin T. FN:Marvin T. Pascual ORG:Bureau of Internal Revenue;Information Systems Development Service TITLE:Information Systems Analyst 1 TEL;WORK;VOICE:9252052 TEL;WORK;VOICE:9817022 TEL;HOME;VOICE:9293952 TEL;PREF:9252052 ADR;WORK:;Systems Maintenance and Support Division;#14 Makadios Street, Sikatuna Village;Quezon City;;1101;Philippines LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Systems Maintenance and Support Division=0D=0A#14 Makadios Street, Sikatuna = Village=0D=0AQuezon City 1101=0D=0APhilippines EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20020423T181951Z END:VCARD
