Asterisk Realtime Configuration

Asterisk Asterisk Support
1

Hello everybody!
Please help me to configure step by step Asterisk Realtime Configuration with MySQL, I read a tutorial with PostgreSQL on this url: asteriskguru.com/tutorials/r … pgsql.html
But I can not do it with MySQL.
Thank y very much!

2

maybe this will help

voip-info.org/wiki-Asterisk+RealTime

3

thank rusty, but I find it is difficult to follow that wiki, anyone knows the url similar to asteriskguru.com/tutorials/r … pgsql.html ? I really need it!

4

I have read the related articles on voip-info.org/wiki-Asterisk+RealTime, but when testing, there are some problem that I can not solve now, such as: (on Asterisk log):
(my computer: 203.119.9.14, asterisk: 203.119.9.15)

Mar 28 03:48:14 WARNING[2439]: config.c:920 find_engine: Realtime mapping for ‘sippeers’ found to engine ‘mysql’, but the engine is not available
Mar 28 03:48:14 NOTICE[2439]: chan_sip.c:10851 handle_request_register: Registration from ‘Vidu sip:quang@203.119.9.15’ failed for ‘203.119.9.14’ - Username/auth name mismatch
Mar 28 03:49:14 WARNING[2439]: config.c:920 find_engine: Realtime mapping for ‘sippeers’ found to engine ‘mysql’, but the engine is not available
Mar 28 03:49:14 NOTICE[2439]: chan_sip.c:10851 handle_request_register: Registration from ‘Vidu sip:quang@203.119.9.15’ failed for ‘203.119.9.14’ - Username/auth name mismatch

Please help me to correct this!

5

I have exactly the same probleme and i don’t know how to resolve it.
I tryed all combination of display name/username/auth name on XLite but nothing to do, always the same error.

But i’m sure that the retrieve_sip_conf_from_mysql.pl doesn’t do its job correctly because it’s suppose to write in sip_additionnal.conf the info from the database but this file is empty…
I’ll search again and if i find something, i’ll tell you.

Please help US ^^

6

hi,

you doesn’t have installed asterisk-addons with mysql support.

Sylvain

7

I had a same problema, but with postgres. I don’t know how, but I got it. Try type ‘odbc show’ in CLI. It’ll show you the connection between asterisk and your odbc driver, in your case, mysql. I wish luck to you.

8

It’s seems like You fill the table with wrong info.
The column “name” in the SIP/IAX users table is rigth column for storing the registration username.