30 May
2011
30 May
'11
8:27 p.m.
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
30 May
30 May
8:53 p.m.
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.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Peter Dunkley
Technical Director
Crocodile RCS Ltd
10:40 p.m.
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_…
Cheers,
Daniel
Regards,
Peter
--
Daniel-Constantin Mierla
http://www.asipto.com
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
31 May
31 May
8:15 p.m.
Daniel-Constantin Mierla wrote:
Hello,
On 5/30/11 8:53 PM, Peter Dunkley wrote:
Thanks. I was looking for "ALTER TABLE" thus I didn't found it.
regards
Klaus
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_…
4951
days inactive
4952
days old
3 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Klaus Darilion -
Peter Dunkley