Asterisk realtime

kapo · **Joined:** Wed Aug 26, 2009 12:28 pm **Posts:** 5

Please how can I set up Asterisk realtime with A2billing? I have correctly compiled asterisk+asterisk addons, configure extconfig.conf and so via http://www.voip-info.org/wiki/view/Aste ... alTime+Sip . But when I create customer in A2B nothing happens. Asterisk doesn`t notice it. In agi configuration "realtime" is set to "yes". I checked wiki, but only one page refers to my problem : http://www.asterisk2billing.org/cgi-bin ... tSIPFriend

Quote:

With A2Billing in Realtime mode, there is no requirement to reload asterisk when a new friend is added or removed.

Thats great! But information value is zero. Please help.

Thanks

jroper · **Joined:** Fri Jun 23, 2006 3:56 pm **Posts:** 4065

Hi

extconfig should have these lines:-

Code:

; include a2billing realtime
sipusers => mysql,a2billing14,cc_sip_buddies
sippeers => mysql,a2billing14,cc_sip_buddies
iaxusers => mysql,a2billing14,cc_iax_buddies
iaxpeers => mysql,a2billing14,cc_iax_buddies

and res_mysql.conf should look something like this.

Code:

[general]
dbhost = 127.0.0.1
dbname = a2billing14
dbuser = username
dbpass = useerpassword
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

And that should be enough to get it going.

Joe

kapo · **Joined:** Wed Aug 26, 2009 12:28 pm **Posts:** 5

Thank you! Thats information I need

kapo · **Joined:** Wed Aug 26, 2009 12:28 pm **Posts:** 5

So another problem appears.

After start asterisk I can see in the log these lines:

[Aug 28 18:24:19] WARNING[32028] res_config_mysql.c: Table cc_sip_buddies requires a column 'defaultuser' of size '10', but no such column exists.
[Aug 28 18:24:19] WARNING[32028] res_config_mysql.c: Table cc_sip_buddies requires a column 'useragent' of size '20', but no such column exists.

Some solution?

Thanks

kapo · **Joined:** Wed Aug 26, 2009 12:28 pm **Posts:** 5

Anybody who`s using A2billing 1.4.1 with asterisk realtime? Please help :-)

dhuang · **Joined:** Fri Apr 06, 2007 2:35 pm **Posts:** 6

look into chan_sip.c, it should tell you about the size of the filed
eg. char useragent[256] , "defaultuser", RQ_CHAR, 10

Then just create those filed in your cc_sip_buddies.

mtaisigue · **Joined:** Thu May 15, 2008 2:02 am **Posts:** 115

Hello can any body help me out with realtime please
I just have the config as jroper said and
iam getting this message

[Dec 22 18:21:12] WARNING[11675]: pbx_config.c:1551 pbx_load_config: ==!!== Unknown directive: sipusers at line 234 -- IGNORING!!!
[Dec 22 18:21:12] WARNING[11675]: pbx_config.c:1551 pbx_load_config: ==!!== Unknown directive: sippeers at line 235 -- IGNORING!!!

and this one

[Dec 22 18:21:12] ERROR[11675]: res_config_mysql.c:880 mysql_reconnect: MySQL RealTime: Ping failed (2006). Trying an explicit reconnect.
[Dec 22 18:21:12] ERROR[11675]: res_config_mysql.c:880 mysql_reconnect: MySQL RealTime: Ping failed (2006). Trying an explicit reconnect.

I did this
> realtime mysql status
Connected to asterisk@localhost, port 3306 with username root for 10 minutes.

Thank you
Best

mtaisigue · **Joined:** Thu May 15, 2008 2:02 am **Posts:** 115

thank you guys

never mind

i solved it

provided by Star2Billing S.L.

Asterisk realtime

Who is online