Asterisk 11 Realtime Architecture ARA MySQL table structures

Asterisk Asterisk Support
1

Hi I am using asterisk 11 and I am finding it quite difficult to find all of the correct MySQL table structures for all of the available realtime databases available.

I think in asterisk 11 the following configurations can be placed in MySQL:
sip users
sip peers
cdr
config
acl
voicemail
Queues
meetme
h323

Are there others?

Does anyone have a full list of the databases and the table structures?
this link is good but out of date for asterisk 11
open-voip.org/index.php?titl … me_example
I also tried Asterisk The Definitive Guide, 4th Edition which has some examples but not complete and full of errors

Thanks

2

[delete please my post]

3

The structure are in the contrib directory within the source tarball.

4

Got it thanks. This is very useful.

5

For those that wish to know the following is available in the contrib folder:
iaxfriends.sql
meetme.sql
musiconhold.sqk
queue_log.sql
sippers.sql
voice_date.sql
Voicemail_messages.sql

Looks like we are short the following although some of them are very simple:
extensions
queues
queue_dialplan_parameters
config
acl
voicemail_users

are there others?

6

Take a look here and see if something else help you.

github.com/navaismo/DM-Asterisk … STRUCT.sql