similar to: The 'sipfriends' table is obsolete - ????

Hi, I have a problem with IAX accounts... I set up a few months ago an Asterisk server, with mysql support to load iax accounts. Settings seems fine because apparently the system works as expected. Yesterday I tried to add another iax account in the iax.conf directly. And I have a problem with this new account (named 444). I can authenticate from 444 to the server, and I can receive calls from

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

Starting with Asterisk 1.2 I have always used realtime static to load my extensions.conf into Asterisk. It worked perfectly up to version 1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I can see that the extensions.conf file is mapped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': ==

Hello I was wandering If I let 2 asterisk boxes (let's name them ast01 and ast02) connect to one SQL realtime iaxfriends/sipfriends database What happens if I register my client to ast01, The ast01 box will update the client's record in the iaxfriends database (ipaddr/port/regseconds) Let's say there is an incoming call then for this client but this call arrives on ast02 (the box

Hi all, I try to make a call from my Openser(SIP Proxy) to the asterisk in different machine. I use my asterisk as a trunking gateway. I can make a call from my openser to some trunking gateway such as my cisco 5300 or welltech 5250. In the same method, I try to make a call to asterisk ( sip listen on udp 5060 ) I use ngrep on my asterisk machine and list as below. But I can't find any sip

Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

Hi actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. I read on the wiki: =================================================== Database Config put the following in res_mysql.conf [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = myuser dbpass = mypass dbport = 3306 Values in sip.conf or iax.conf like in older versions of * are no longer used. Database Table Lets

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL:

All, I get this whenever trying to dial to a peer when the peer registered to another server. I'm basically trying to use realtime to check for the peer and dial it. Mar 24 09:16:47 VERBOSE[4527]: -- Executing Dial("SIP/brak-f69f", "IAX2/brak-test/107") in new stack Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_users WHERE name =

Hi folks, I'm really confused, so please help me, or at least give me some pointers to clarify this issue. Can I mix "Static" and "Real" realtime? Is there a way to easily switch from one to another, say, for sip.conf? Which are the major benefits of "Real" realtime? Please help me! Thanks in advance, -- Andrea Spadaccini Multimedia Technologies Institute

So this is what i've done so far... my extconfig.conf looks like this [settings] ;example => odbc,asterisk,alttable ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk sipusers => mysql,voip,sip sippeers => mysql,voip,sip voicemail => mysql,voip,voicemail extensions => mysql,voip,extensions -------------------- and my extensions.conf has the following lines in it.

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

I think I have 4 options. 1, Modify chan_sip.c to update a new field in sipusers realtime table with the status of the sip peer/user. Then use agi to dial sip calls. Check the status field if OK then dial the fullcontact from the sip table. If not goto voicemail or where ever else I want the call to go.. The UA would only register to one server, so only one server *should* be writing to the

Hi when i use MeetMe, i have this errors: app_meetme.c: Unable to open pseudo device Where is the problems ? i have too warning and error into my logs: [Nov 1 07:26:17] WARNING[18544] res_musiconhold.c: Unable to open pseudo channel for timing... Sound may be choppy. [Nov 1 07:26:17] WARNING[18544] config.c: Realtime mapping for 'iaxpeers' found to engine 'mysql', but

Hi all I have asked this question before but have not got any helping input. I'm really new to this and need some explanation about ASTCC. So here is the question again. In the ASTCC web admin there are Trunks, Routes, IAXFriends, SIPFriends, Brands, Cards. As I understand Brands is not used, Cards just makes the cards. Routed in the dialplan and pricelist, Trunks is for ASTCC to

Hi all, Trying to do what should be a basic info retrieval from my asterisk network -- get the list of IAXPeers and break down by IP, name, and Status etc. Asterisk 1.0 Manager unfortunately. Using PHP. Easy to get the response -- but parsing it is impossible! That table format throws me for a loop ... Any idea of an easy way to seperate out the columns of that horrid 'table' reponse

Hi all, A week or so down the list, i read that not many people were using realtime on an Asterisk18, so i had this afternoon a go at it... [sorry for the inconveneant line-wraps] First i did: mysql> create database asterisk; mysql> grant all on asterisk.* to 'voipadmin'@'localhost' identified by next i used the info from the wiki: CREATE TABLE `sip_devices` ( `id`

Hi, I've just done up a quick proggy to show me the status of my IAX peers from my windows box. It plugs into the simple manager proxy. You can see more information (including a screenshot) at: http://www.sineapps.com/news.php?rssid=384 You can download it directly from: http://www.sineapps.com/down/IAXPeers.zip Could you please have a look and let me know your thoughts. -- Cheers,

Is there any reason why IAXPeers output is different from SIPPeers output? The response has no Eventlist: start Ej. Response: Success Eventlist: start Message: Peer status list will follow Event: PeerEntry Channeltype: SIP ObjectName: 1001 ChanObjectType: peer IPaddress: 192.168.175.1 IPport: 63772 Dynamic: yes Natsupport: no VideoSupport: no TextSupport: no ACL: no Status: