Create Realtime Mysql table sql


#1

Hi,
Where can I find the sql files that can create all Asterisk Realtime tables for Mysql? I like to create SIP accounts, Queues, CDR, and VoiceMail in mysql database.

Thanks for help.
Dave


#2

wiki.asterisk.org/wiki/display/ … +structure


#3

The page shows only one table: sipfriends. Is sipfriends for sip accounts? How about Queue, CDR, voice mail, etc.
Thanks for help.
Dave


#4

See the contrib/realtime/mysql directory of the source.

Cheers.


#5

See the contrib/realtime/mysql directory of the source.

Cheers.


#6

Hi javaone9!

CDR - http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql

Also look at the bottom of this page.
http://www.voip-info.org/wiki/view/Asterisk+RealTime

There you have the links you might need!

[quote] Asterisk RealTime Static
Asterisk RealTime Sip
Asterisk RealTime IAX
Asterisk RealTime H323
Asterisk RealTime Voicemail
Asterisk RealTime Queue
Asterisk RealTime Extensions
Asterisk RealTime LDAP
Asterisk RealTime MeetMe
Asterisk RealTime chan_sccp2 - Coming soon
Asterisk configuration from database
Asterisk RealTime PostgreSQL - Working tables for PostgreSQL 8.1
Asterisk RealTime - Ruby on Rails Migrations and Models
The Asterisk Realtime Architecture[/quote]
Virtually yours // Nypon