Hello Everyone,
I wanted to let everyone know that I was currently working on a project that deals with Mail Sysloging from the Astaro appliance. I'm currently working on a database schema and php interface that will allow information to be displayed per user / domain. As I get an alpha product going I will post the link and documentation on the install. Currently my goals are to support the following:
Astaro SMTP Syslog:
Env: linux
Linux: Rsyslog
Linux: Mysql Database
Linux: PHP:AUTH[:D]B & Ldap (alpha will only have DB authentication)
Features:
User Login: By Email
Account Level Assign: UID
Categories: Spam, Quarantined, Passed
Search: ADMIN:*, USER: User->Categories
SORT: DESC, Received Date
Message: TRACK BY EXIM ID
Currently I have most of the interface programmed, I'm currently having to go back to the drawing board for the mysql schema though, I currently have 3Million+ rows and the execution time is around 3.30seconds per query. Which I'm not happy with. I hope with in the next 2-3 weeks I should have a semi stable alpha release available for feedback, However at the stage of alpha there is not going to be an install script or automation in order to set it up, but there will be instructions on how to create the tables and which script needs to go into crontab in order to keep the tables updated. I currently haven't seen any program for astaro like the one im creating. If all goes well it shouldn't be hard to enable Syslog Proxy and Security reporting into this. First things first though!
If you would like to help with this project feel free to contact me or if you would like to be notified when an alpha is available please feel free to contact me:
j.loveles [at] gmail.com
Regards -
Redonkuless aka Jonathan Loveless -
This thread was automatically locked due to age.