Asterisk Realtime

Asterisk Asterisk Support
1

I’m having trouble setting up asterisk realtime integration with openser. I followed this so far openser.org/dokuwiki/doku.ph … ntegration and have found myself stuck, when i type sip show peers at the asterisk CLI it doesn’t show any peers from the database. on a side note if i have verbose set to ten it shows this

[Nov 1 16:25:09] DEBUG[10182]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine.

every once in a while, but it says everything is fine, any ideas??

also shows this

[Nov 1 16:33:18] DEBUG[10185]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip WHERE name = ‘xxx.xxx.xxx.150’

the ip is the ip of a sip provider i connect to

thanks for your help in advance.

2

Hi
same problem i also faced b4 a week. as per my knowledge reason is your not mentioed coloum"name". name means context like for any type =friend then name is [9204] that extension. so , you sud add this colum & mention the name like [voicepulse] then you name is voicepulse. for that row. or simply mentioed this as u need under colum name-'xxx.xxx.xxx.150.
try this it will help you.

Amit

3

Hi
same problem i also faced b4 a week. as per my knowledge reason is your not mentioed coloum"name". name means context like for any type =friend then name is [9204] that extension. so , you sud add this colum & mention the name like [voicepulse] then you name is voicepulse. for that row. or simply mentioed this as u need under colum name-'xxx.xxx.xxx.150.
try this it will help you.you have to add one more colum = name

Amit

4

I am quite new to MySql, i set up a view using the instructions in the link from my previous post. I do have a name column, and i can see it is populated with the extensions. could the view be causing the problems?