[asterisk-users] Asterisk Realtime

[Mike Hammett]

[root at Aiur asterisk]# cat res_mysql.conf
;
; Sample configuration for res_config_mysql.c
;
; The value of dbhost may be either a hostname or an IP address.
; If dbhost is commented out or the string "localhost", a connection
; to the local host is assumed and dbsock is used instead of TCP/IP
; to connect to the server.
;
[general]
;dbhost = 127.0.0.1
dbname = asterisk
dbuser = asterisk
dbpass = yourpassword
;dbport = 3306
dbsock =  /var/lib/mysql/mysql.sock

[root at Aiur asterisk]# cat extconfig.conf
;
; Static and realtime external configuration
; engine configuration
;
; Please read doc/extconfig.txt for basic table
; formatting information.
;
[settings]
;
; Static configuration files:
;
; file.conf => driver,database[,table]
;
; maps a particular configuration file to the given
; database driver, database and table (or uses the
; name of the file as the table if not specified)
;
;uncomment to load queues.conf via the odbc engine.
;
;queues.conf => odbc,asterisk,ast_config
;
; The following files CANNOT be loaded from Realtime storage:
;       asterisk.conf
;       extconfig.conf (this file)
;       logger.conf
;
; Additionally, the following files cannot be loaded from
; Realtime storage unless the storage driver is loaded
; early using 'preload' statements in modules.conf:
;       manager.conf
;       cdr.conf
;       rtp.conf
;
;
; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
;example => odbc,asterisk,alttable
;example2 => ldap,"dc=oxymium,dc=net",example2
;
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
;sippeers => odbc,asterisk
;voicemail => odbc,asterisk
;extensions => odbc,asterisk
;queues => odbc,asterisk
;queue_members => odbc,asterisk

sippeers => mysql,asterisk,sip_peers
sipusers => mysql,asterisk,sip_users
iaxpeers => mysql,asterisk,iax_peers
iaxusers => mysql,asterisk,iax_users
queues => mysql,asterisk,queue_table
queue_members => mysql,asterisk,queue_member_table
voicemail => mysql,asterisk