On Tue, 1 Oct 2002, Marvin Pascual wrote: > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Ian C. > > Sison > > Sent: Tuesday, October 01, 2002 1:46 PM > > To: 'PLUG Newbie' > > Cc: 'PLUG' > > Subject: Re: [ph-linux-newbie] Postfix Inquiry > > > > > > I'm assuming you are using oracle. > > Yes, for all our systems and that includes our Collection and Bank > Reconciliation system which will be the source for the said project. > > > If your dba can create a table in oracle, > > for_notification, which contains: > > > > transaction_id, > > tin, > > email address, > > date payment was received, > > amount received, > > receiving branch, > > status > > > > and for each transaction received, insert a row with > > the columns of the table filled up, it's a simple > > perl script using DBI::Oracle running on a linux box > > that grabs all rows with 'status = 0' (0 = pending, > > 1 = sent), and create a form letter, fill in the > > information from the row, and send it off via > > Mail::Sender. > > This is a good idea! =) So in short, We'll just make a Perl script in our > Red Hat Linux machine that will grab/get the info from the Oracle database. > > My question is, does our Oracle database which uses Solaris on Sparc > Machines need to have Perl installed? If it's yes then we don't have Perl > in all our existing systems.
No need for Perl on the solaris box. You need to have the oracle libraries for linux in order to compile and run DBD::oracle, and have your solaris oracle respond to network client connections from the linux box and that's all there is to it. > > This doesn't even need postfix, > > What do you mean? How can we notify the taxpayers that the BIR was able to > received their tax payments? Meaning... you don't need postfix per se, you can use ANY_MTA(tm), which includes Andre's sendmail, Rick's Exim, and Likot's qmail \8) IF HOWEVER you want to keep the TIN <--> Email address mappings in a separate database (like mysql or pgsql) and you want instant TIN-Emailaddy lookups, then use postfix. It has native mysql/pgsql(via patch) alias maps. > > > although if you want to keep the TIN/EMAIL address > > lookup db in a separate database, you can store it > > on a mysql or pgsql db, and have postfix access it > > directly as an alias map. > > Well, if your first suggestion really favors in our existing system, that > Perl is not necessary to be installed in our Sparc machines which contains > our Oracle database and Solaris, but only in our Red Hat Linux machine, then > we'll go for your first suggestion. The solaris box need not be touched at all save for the extra table in your oracle db, and additional code to post a row into the table when there is a receipt of payment. FEEDBACK: Feedback from those that reply to the autogenerated email should be 'fed back' to the BIR regional offices in a more productive way, not simply forwarding it to an email account per RDO [it will not be read, believe me]. It should be forwarded to a web based trouble ticket system, so that there is a structured way to track problems, and there is always someone tasked to resolve such problems. This prevents miscommunication, and allows the BIR to be pro-active in solving problems. There are a lot of PHP based trouble ticket systems in freshmeat which i am sure can be adapted to suit the BIRs needs. > Thanks Ian. You're the man! =) Most welcome. =8) _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
