The problem is, that with a trigger for a table I can't delete rows from the same table:
ERROR 1442: Can’t update table ‘sip_capture′ in stored function/trigger because it is already used by statement which invoked this

Am 27.08.13 17:42, schrieb Alex Balashov:

Well, you could use a trigger/stored procedure to do that inside the database, as opposed to externally...

On 08/27/2013 11:41 AM, Sebastian Grosse wrote:

Hallo All,
I use the module sipcapture and this will fill a MySQL-database. Is
there a better / an other way to cleanup the database frequently as to
create an own cronjob?
I want to set a maximum interval of time or table-rows, because I don't
want my database to grow eternal.

Any idea how to configure kamailio, sipcapture or an other module or
other ideas?

Sebastian G.

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users