[SR-Users] cleanup database

[Sebastian Grosse]

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 at lists.sip-router.org 
		http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 
		
		




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130827/90bc1298/attachment.html>