<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.2.2">
</HEAD>
<BODY LINK="#0000ff">
Hi Laurent,<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
Have you got desc of mysql table, please ?<BR>
</BLOCKQUOTE>
<BR>
Ok, for this, look at the following file inside ticket_init to get a description<BR>
for each attribute:<BR>
<BR>
<A HREF="https://dolphin.aspl.es/svn/publico/valvula/plugins/mod-ticket/mod-ticket.c">https://dolphin.aspl.es/svn/publico/valvula/plugins/mod-ticket/mod-ticket.c</A><BR>
<BR>
Best Regards,<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<B>De :</B> Francis Brosnan Blázquez [mailto:francis@aspl.es] <BR>
<B>Envoyé :</B> lundi 23 février 2015 15:22<BR>
<B>À :</B> Laurent RAYSSIGUIER<BR>
<B>Cc :</B> valvula@lists.aspl.es<BR>
<B>Objet :</B> Re: [Valvula] MOD-TICKET -- some notes about configuring it<BR>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
El lun, 23-02-2015 a las 14:49 +0100, Laurent RAYSSIGUIER escribió: <BR>
<BR>
Hello,<BR>
<BR>
<BR>
Hi Laurent,<BR>
<BR>
<BR>
<BR>
<BR>
I’m a brand new valvula user.<BR>
<BR>
<BR>
<BR>
I’m interessed by mod_tucket module that I found here : <A HREF="http://www.aspl.es/valvula/html/valvulad_mod_ticket.html">http://www.aspl.es/valvula/html/valvulad_mod_ticket.html</A><BR>
<BR>
<BR>
Ok,<BR>
<BR>
<BR>
<BR>
<BR>
I’ve installed valvula, and I think it works J<BR>
<BR>
<BR>
<BR>
root@smtpmailing1:~# valvulad-mgr.py -o<BR>
<BR>
Module: mod-ticket<BR>
<BR>
root@smtpmailing1:~# valvulad-mgr.py -l<BR>
<BR>
Listen: 127.0.0.1:3579<BR>
<BR>
Mod: mod-ticket<BR>
<BR>
<BR>
<BR>
I have added valvula to postfix with this command line :<BR>
<BR>
valvulad-mgr.py -c smtpd_data_restrictions 3579 first<BR>
<BR>
<BR>
<BR>
I’ve restarted postfix ….. and now ??<BR>
<BR>
<BR>
Ok,<BR>
<BR>
<BR>
<BR>
<BR>
How can I tell parameters to valvula ?<BR>
<BR>
I can’t find doc about it.<BR>
<BR>
<BR>
Uhmn..I'll update documentation to fix this. For now, use the following notes:<BR>
<BR>
1) First, you'll have to create the set of plans to apply to your sending users. For that,<BR>
connect to the valvula database and insert them like:<BR>
<BR>
mysql> INSERT INTO ticket_plan (name, description, total_limit, day_limit, month_limit) VALUES ('You plan name', 'description', 100000, 3000, 10000)<BR>
<BR>
2) Now, with that plan created, create a rule that binds this plan to a sending sasl user<BR>
like this:<BR>
<BR>
mysql> INSERT INTO domain_ticket (sasl_user, valid_until, ticket_plan_id) VALUES (<A HREF="mailto:'test@limited.com">'test@limited.com</A>', -1, plan_id)<BR>
<BR>
...where plan_id is the id inside ticket_plan table and -1 is that you are making this rule to have no limit in<BR>
time, allowing the user to consume without time ilmit. Otherwise, place there an unix stamp epoch indicating when<BR>
that user should be blocked even through there's still quota available.<BR>
<BR>
...and that's all. <BR>
<BR>
You don't have to restart valvula after including modifications or updates into the MySQL database. Valvula<BR>
will notice that this is available on the next incoming request to be checked.<BR>
<BR>
<BR>
<BR>
<BR>
Have you a web site explaining parametrers or database structure for this module ?<BR>
<BR>
<BR>
Not for now. I'll update the module with these notes. <BR>
<BR>
Best Regards,<BR>
<BR>
<BR>
<BR>
<BR>
Thanks.<BR>
<BR>
<BR>
<BR>
Best regards<BR>
<BR>
Laurent<BR>
<BR>
<BR>
<BR>
<BLOCKQUOTE>
<PRE>
_______________________________________________
Valvula mailing list
<A HREF="mailto:Valvula@lists.aspl.es">Valvula@lists.aspl.es</A>
<A HREF="http://lists.aspl.es/cgi-bin/mailman/listinfo/valvula">http://lists.aspl.es/cgi-bin/mailman/listinfo/valvula</A>
</PRE>
</BLOCKQUOTE>
<BR>
<BR>
<BR>
<BR>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>