Realtime SIP table structure

Asterisk Asterisk SIP
1

Dear all,

i’m using the Realtime and i’m using a table structure (for sip) that i found some years ago.
Is there any official guide about the Realtime?

I would like to have the last available structure of the database in order to can use all the features available (for example in my table there isn’t the field namedpickgroup while in sip.conf it is available).

Thanks and regards,
Davide

2

Asterisk 12 and above use Alembic to manage the database schemas. This means that Alembic can be used to automatically migrate your database between versions[1]. For Asterisk 11 the schemas are in the Asterisk source code in the contrib/realtime directory[2].

[1] https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic
[2] https://github.com/asterisk/asterisk/tree/11/contrib/realtime

3

Thank you very much!

I have checked and in Asterisk 14 there are not the fields namedcallgroup and namedpickupgroup in the Python script that is used to create the database tables.

While in sip.conf i find:

;namedcallgroup=engineering,sales,netgroup,protgroup ; We are in named call groups engineering,sales,netgroup,protgroup
;namedpickupgroup=sales ; We can do call pick-p for named call group sales

This means that the two files can’t be used in Realtime configuration?

Thanks and regards,
Davide

4

The Alembic conversion took the existing schema and put it into Alembic, if those fields were not in it then they did not end up in Alembic for chan_sip. You may be able to add them yourself manually but I’m not sure what that would do to the Alembic upgrade process in the future. It may tolerate it, it may not.

5

Dear Jcolp,

thank you very much for you help, i have one more question: who is the mantainer of Realtime?

It would be nice to have the sql schema updated with all fields (like pjsip) for the sippeers table

Thanks,
Davide

6

There is no dedicated maintainer of realtime. Issues filed[1] for it are handled by anyone. You can file an issue about the missing fields, and we also accept patches adding them. Some information on how to write a migration are on the Alembic documentation site[1].

[1] https://issues.asterisk.org/jira
[2] http://alembic.zzzcomputing.com/en/latest/tutorial.html#create-a-migration-script