Asterisk MySQL RealTime: Invalid database

Asterisk Asterisk Support
1

I have a problem, i’m a newbie with Asterisk and trying to get i working with mysql

Apr 27 10:38:14] WARNING[2665]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: asterisk (check res_mysql.conf)

i know this i probably just some stupid error

/etc/asterisk/res_mysql.conf

[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = asterisk
dbpass = SomeSecertPw
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

/etc/asterisk/extensions.conf

[incoming] switch => Realtime/@extensions

/etc/asterisk/extconfig.conf

[settings] sipusers => mysql,asterisk,sip sippeers => mysql,asterisk,sip extensions => mysql,asterisk,extensions voicemail => mysql,asterisk,voicemessages queues => mysql,asterisk,queues queue_members => mysql,asterisk,queue_members

i followed this guide: hostseries.com/asterisk-realtime … ion-guide/

2

i installed and compiled from source:

asterisk-1.6.2.6
asterisk-addons-1.6.2.1

3

my problem was in my extconfig.conf, here is how it looks like now, and this works :smile:

[settings]
sipusers => mysql,general,sip_buddies
sippeers => mysql,general,sip_buddies
extensions => mysql,general,extensions
voicemail => mysql,general,voicemessages
queues => mysql,general,queues
queue_members => mysql,general,queue_members