[SR-Users] Siremis: changes to Kamailio DB

[Daniel-Constantin Mierla]

Hello,

On 5/30/11 8:53 PM, Peter Dunkley wrote:
> Hello,
>
> I believe that the Kamailio database changes are:
> - Additional fields in the acc table
> - A new statistics table (for holding things like shared memory usage) -
> usually updated by a timer event in kamailio.cfg
> - A new cdrs table
> - A stored procedure to populate the cdrs table by processing the acc
> table - the stored procedure is usually run from a cron job.
>
> I seem to recall that there are some .sql files in the Siremis source for
> these changes.
right, here it is:
http://siremis.git.sourceforge.net/git/gitweb.cgi?p=siremis/siremis;a=blob_plain;f=siremis/modules/ser/mod.install.siremis.sql;hb=HEAD

Cheers,
Daniel

>
> Regards,
>
> Peter
>
>> Hi!
>>
>> I just read the Siremis installation howto. One of the task of the
>> installer is: "Update SIP Database - this updates the structure of
>> Kamailio database for accounting and charts modules"
>>
>> I wonder what siremis exactly does to the DB. Is greped over the siremis
>> source file but couldn't find the changes. Are they somewhere
>> documented? (e.g. .sql file with the statemens).
>>
>> Anyway, I wonder changes are needed at all. IMO, if possible, the
>> Kamailio DB should not be changed by an external too - otherwise this
>> may cause problems with updates to the Kamailio DB structure.
>>
>> Thanks
>> Klaus
>>
>> _______________________________________________
>> 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
>>
>

-- 
Daniel-Constantin Mierla
http://www.asipto.com