Currently, the program is utilizing MSSQL only. This allows for PHP or ASP to be hosted on a separate IIS box and access the data from the MSSQL box, all separate from the IMail server. I assume you could run all 3 on the same box, or (in the future dump the data to a access file). Currently there is a .sql script that creates the user/password, database, tables, and columns. Then you just let the program run every night at 12:01am to update the database from the previous day's logs. You can also manually run the program with the --file option to specify a specific log to analyze, but with no options, it just analyzes the file(month)(today's date - 1 day).log When the access becomes available, the access file will have the tables and columns already setup. (NOT YET)
Duane ----- Original Message ----- From: "Jay Calvert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 24, 2003 6:27 PM Subject: Re: [Declude.JunkMail] new declude log analyzer (BETA) > Shouldn't work with Access if the datasource isn't hard coded? > Like are you creating the database and tables if they don't exist? > > Or does it rely on a database already created? > > > > > > ----- Original Message ----- > From: "Duane Cox" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 24, 2003 4:23 PM > Subject: Re: [Declude.JunkMail] new declude log analyzer (BETA) > > > > Great, I will get you a copy sometime next week, and look forward to your > > feedback. > > I assume you are setup with MSSQL 7 or 2000 and IIS 5. > > > > Duane > > > > > > ----- Original Message ----- > > From: "Jay Calvert" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, January 24, 2003 6:21 PM > > Subject: Re: [Declude.JunkMail] new declude log analyzer (BETA) > > > > > > > I would be interested. > > > > > > > > > ----- Original Message ----- > > > From: "Duane Cox" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Cc: <[EMAIL PROTECTED]> > > > Sent: Friday, January 24, 2003 3:32 PM > > > Subject: [Declude.JunkMail] new declude log analyzer (BETA) > > > > > > > > > > I have been working on (in my spare time) a declude (eventually imail > > log > > > > files too) analyzer that will parse the declude virus and junkmail log > > > files > > > > (we don't have hijack ... sorry). Yeah, not another one! Seems as if > > > > everybody has one these days. > > > > Well I took it to another level. The program parses out the log > files, > > > > updates that information to a mssql database (access in the future), > > then > > > > there is a web site that will draw all these numbers out in pie > charts. > > > > > > > > I would include a few pictures with this email, but am not sure if > that > > is > > > > allowed. But if you are interested in trying out this program or > > looking > > > at > > > > screen shots, just email me at [EMAIL PROTECTED] > > > > > > > > So far, the program works as follows. Parses log file for declude > virus > > > > ONLY, need more work for junkmail. Updates MSSQL database ONLY, need > to > > > add > > > > access. I am currently working on the web side of it, not sure to use > > PHP > > > > or ASP yet. Probably PHP. > > > > > > > > Interesting? > > > > > > > > Duane Cox > > > > [EMAIL PROTECTED] > > > > > > > > > > > > --- > > > > [This E-mail was scanned for viruses by Declude Virus > > > (http://www.declude.com)] > > > > > > > > --- > > > > This E-mail came from the Declude.JunkMail mailing list. To > > > > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > > > > type "unsubscribe Declude.JunkMail". The archives can be found > > > > at http://www.mail-archive.com. > > > > --- > > > > [This eMail Has Been Scanned For Viruses By Your eMail Server] > > > > > > > > > > > > > > --- > > > [This eMail Has Been Scanned For Viruses By Your eMail Server] > > > > > > --- > > > [This E-mail was scanned for viruses by Declude Virus > > (http://www.declude.com)] > > > > > > --- > > > This E-mail came from the Declude.JunkMail mailing list. To > > > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > > > type "unsubscribe Declude.JunkMail". The archives can be found > > > at http://www.mail-archive.com. > > > > > > > --- > > [This E-mail was scanned for viruses by Declude Virus > (http://www.declude.com)] > > > > --- > > This E-mail came from the Declude.JunkMail mailing list. To > > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > > type "unsubscribe Declude.JunkMail". The archives can be found > > at http://www.mail-archive.com. > > --- > > [This eMail Has Been Scanned For Viruses By Your eMail Server] > > > > > > --- > [This eMail Has Been Scanned For Viruses By Your eMail Server] > > --- > [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] > > --- > This E-mail came from the Declude.JunkMail mailing list. To > unsubscribe, just send an E-mail to [EMAIL PROTECTED], and > type "unsubscribe Declude.JunkMail". The archives can be found > at http://www.mail-archive.com. > --- [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] --- This E-mail came from the Declude.JunkMail mailing list. To unsubscribe, just send an E-mail to [EMAIL PROTECTED], and type "unsubscribe Declude.JunkMail". The archives can be found at http://www.mail-archive.com.
