similar to: Presentation + Asterisk Realtime doubts

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

Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any

I've been going in circles for a few weeks now with Realtime SIP. My extconfig.conf has: sipusers => mysql,dbname,ast_sip_users sippeers => mysql,dbname,ast_sip_users When I do a 'sip show peers' I see all my phones. When I do a 'sip show users' I only see a few of them. I can't work out why this is the case. They are also coming up with NAT as

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`

I'm trying to get sipusers working with a realtime odbc database on Asterisk 1.6. We have sippeers working from the database, but need sipusers to be in a separate table for other implementation reasons. sip show user test load returns results from the database. CLI> sip show user test load * Name : test Secret : <Set> MD5Secret : <Not set>

I have followed the instructions on voip-info.org for Realtime SIP peers, but I get this notice : [Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889 handle_request_register: Registration from '<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing

Dear all I'm writing to the list for help as a last resort. I've exhausted all other options, so please forgive me. I've lurked here for years but never actually posted. I'm trying to get Asterisk Realtime SIP configuration working, but it refuses to do so. I have all the necessary configuration in place, Asterisk makes a connection to the database, which can be verified with

hello, I try to query an active directory from asterisk. I do not see how to do it because I just started in asterisk. In extensions.conf switch => Realtime/default at realtime_ext In res_ldap.conf [general] host = ip_active directory protocol = 3 port = 389 dn = ou=voip,dc=test,dc=com pass = administrator_pass_activedirectory user = ou=Users,cn=Administrateur,dc=test,dc=com URL =

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

I have configured my mysql database by following this link http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue The only difference is that I am using ODBC instead of MySQL with Realtime. Within extensions.conf I have the following for my queue exten => 9**2**1611,1,Answer exten => 9**2**1611,2,Queue(irock.com,tT,,,300) exten => *50,1,Answer exten =>

Oh heck. It really looks like realtime has been seriously screwed up. When a call comes in to Asterisk, I can see asterisk executing these queries. SELECT * FROM ast_sip_peers WHERE host = '2XX.YYY.142.205' SELECT * FROM ast_sip_peers WHERE name = '2944093' SELECT * FROM ast_sip_peers WHERE name = '2944093' So, the first thing it does is check and see if there are any

Hi everybody, First of all i am sorry my English :) i want to configure my asterisk server as a sip server that stores sip users in the mysql database connecting directly over odbc driver. My odbc configuration works as below [root at ao042 asterisk]# isql -v asterisk +---------------------------------------+ | Connected! | | | |

Hi, I have installed asterisk-1.4.4 and asterisk-addon-1.4.1. I followed every step to configure RealTime but something is not working properly; the warning that I am geting is: WARNING[32709]: config.c:1229 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for

Just spent hours dicking around with SIP Realtime. Every time a phone came up and sent a registration to Asterisk, Asterisk would simply NOT query the database. I had sipusers in extconfig, but added sippeers as well. NOW I can see Asterisk doing a 'SELECT * FROM sippeers WHERE name = '2944093''. Huh??? Uhm, why? It's not a peer! It's a bloody phone, and in my mind

Hello all, I've been testing a Kamailio Asterisk Realtime integration, and found a strange situation. My problem is that when using the integration, everything seems ok but Asterisk does not see the clients as registered. Kamailio and the clients report registered clients. Also calls fail. In Asterisk cli sip show peers shows nothing but for example realtime load sipusers name 660 shows the

Hello, I noticed that changes to realtime sip peers are not applied until a 'reload'. A 'sip reload' does not make any changes to realtime sip peers. When changing for instance the mailbox-parameter in the realtime sip_buddies table, the change is not applied with a 'sip reload'. For every change there is a complete 'reload' necessary. Why does a 'sip

Hi, I have 2 databases DBNAME1 and DBNAME2. In each database I have a table called sipusers (so DBNAME1.sipusers and DBNAME2.sipusers). Can I use both sipusers tables in Asterisk RealTime? Something like this: /etc/asterisk/extconfig.conf: [settings] sipusers => odbc,DBNAME1,sipusers sippeers => odbc,DBNAME1,sipusers sipusers => odbc,DBNAME2,sipusers sippeers =>

Hello list, scrambling different pieces of info together I've come with the following : I want to have my "register =>" statements in a MySQL-database, so I've made the following table. table ast_config : id 1 cat_metric 0 var_metric 0 commented 0 filename sip.conf category general var_name register var_val username:password at sip.provider.net In ext_config

Hello there I'd like to use sip users and peers realtime. I think I done all I need to get asterisk works fine in realtime: res_odbc.conf configuration. extconfig.conf sippeers => odbc,asterisk,sipclient sipusers => odbc,asterisk,sipclient sip.conf [general] rtcachefriends=yes The sipclient table as suggest in this article: SIP Realtime, MySQL table structure (

Thanks John, You are my savior. This is such a great relief. Apparently realtime will not use either '127.0.0.1' or 'localhost' to connect to the database. I had to use the actual IP address attached to the NIC before it worked. My OS is Debian just a note and Asterisk HEAD from August 20, 2005 Details below for those who might be swimming in the same pool with me.