What tables to create for using SQL capability of MailScanner conf.

[Tomáš Kurinec]

Thank you for suggestion Steve, but what I'm exactly trying to do is a
web interface for customers in company where i work. In the interface
the users should be able to write their own rules for their domains
(accounts) using some combo boxes and text boxes and so on...

So I thought it would be much easier to tell MailScanner to use the
rulesets defined in the database. Of course, this database would be
the same as for the web interface and mailscanner. The other solution
for this would be to create separate database for the web interface
and from this database the rulesets would be parsed to create rulesets
files for mailscanner, but I probably do not need to explain which
solution is much better, safer, effective...

Do you think there is any better solution for my assignement?

Tom

Dňa 5. apríla 2012 17:06, Steve Campbell <campbell at cnpapers.com> napísal/a:
>
>
> On 4/5/2012 10:25 AM, Alex Broens wrote:
>>
>>
>>
>> Is everybody listening to the same airwave?
>>
>> MailScanner's SQL stuff has zero to do with Mailwatch's SQL schema.
>>
>> Seems to me Tom is referring to MailScanner's schema.
>>
>> or am I still listening AM radio ?
>>
>> Alex
>>
>>
> I believe you're on FM and correct. I suppose MailWatch's database could be
> used for such a thing as required by the OP, but what he's asking for is a
> separate database that's referenced in the config file under the SQL
> section. The fields are described slightly in the config file's comments,
> but I could not find any creation information on this database anywhere.
> Maybe someone could point us all to the link of the manual that describes
> this?
>
> Now, for Tom:
>
> I for one have never used this database, but I do use MailWatch and it's
> database. I was under the impression that this database was a lot like MCP
> in it's utilization. In other words, not very many people used it even
> though it is described in the config file.
>
> My suggestion to the OP is to skip the database setup unless there is a real
> need to use it. I've been able to use MS for many years without the database
> and have opted instead for the text files of rules for both MS and SA. These
> are much easier to manage in the long run and use very little overhead that
> a database would require.
>
> Good luck,
>
> steve
>
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!