|
osdir.com mailing list archive F.A.Q. -since 2001! |
|
|
|
Subject: Re: mailwatch + postgreSQL - msg#00061List: mail.virus.mailscanner.mailwatch.general
by Date: Prev Next Date Index by Thread: Prev Next Thread Index
Dhawal Doshy wrote:
> Maicon Triches wrote: > >> hi; >> >> i use postfix+postgresql and i like put mailwatch in postgresql... >> mailwatch have support a postgresql ? >> >> tanks; >> >> Maik >> > > There are people using postgresql with mailwatch, but none of the > implementations are well documented (afaik). > > MailWatch 2.x, when released will support postgres as the preferred > database.. but no timelines yet exist for the release. > > - dhawal > I have released my modifications to get MailWatch to work with PostgreSQL. I have gone through and tuned all of the queries to make sure they use indexes, either as a normal user, or as an admin. With one week providing over 1 million rows, speed is a major concern us and several queries required tuning. Note, we only use the reporting/quarantine side of MailWatch, and other parts might be broken still. Also, our MailScanner boxes write out to local SQLite dbs that is dumped to PG every 5 minutes, so the Perl has not been changed to use PostgreSQL, but that really is the easy part. This prevents the loss of any data due to the DB server being down. I can't remember if that was going to be in 2.0, but it is a really nice feature. You can the modified code base at: http://www2.edutech.nodak.edu/mw/mailwatch-edt.tar.gz It should provide a base for your modifications to begin. I also have support for LDAP and kerberos logins, if that is useful at all. Hope it helps, Richard ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
Thread at a glance:
Previous Message by Date:White/Black Lists defaultHey guys, I am confused about what exactly default means when you see it in the To field of the lists page. I know that it shows up when you create a list with no recipient specified, but it doesn't seem to work as a wildcard. Today one of my clients called me into his office and asked me about the white list function. He is using a new mailing service and it is being detected as spam. He first added a white list entry for just himself using the remote server's ip address in the from field and his full email address in the to fields. This worked fine, but he needed to be able to email all the staff from this service as well. I had him recreate the rule and leave the to fields blank. He sent a test to himself and a few other staff members and they were all blocked. Am I missing something here? I read the FAQ and looked through all the documentation I could find and had no luck locating any information. Any help or suggestions would be appreciated. Thanks, Cameron ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 Next Message by Date:report filter problemsI am trying to add a filter to the reports page. Basically I want the filter to show only todays messages. Any clue as how to filter by date? ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 Previous Message by Thread:Re: mailwatch + postgreSQLScott Silva wrote: >> MailWatch 2.x, when released will support postgres as the preferred >> database.. but no timelines yet exist for the release. > Will there be a migration path for the mysql data? > I don't really want to lose any archived data. > Steve has stated in the past that although postgres will be preferred, MySQL will still be supported although some of the new features may not be supported. I *think* that this was before the support of triggers and stored procs were introduced and I'm guessing that the loss of functionality will be small if any. matt ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 Next Message by Thread:White/Black Lists defaultHey guys, I am confused about what exactly default means when you see it in the To field of the lists page. I know that it shows up when you create a list with no recipient specified, but it doesn't seem to work as a wildcard. Today one of my clients called me into his office and asked me about the white list function. He is using a new mailing service and it is being detected as spam. He first added a white list entry for just himself using the remote server's ip address in the from field and his full email address in the to fields. This worked fine, but he needed to be able to email all the staff from this service as well. I had him recreate the rule and leave the to fields blank. He sent a test to himself and a few other staff members and they were all blocked. Am I missing something here? I read the FAQ and looked through all the documentation I could find and had no luck locating any information. Any help or suggestions would be appreciated. Thanks, Cameron ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
blog comments powered by Disqus
|
|