similar to: asterisk query mysql problem or bug?

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

Hi Guys, We have just set up Asterisk (CVS Head) for a realtime enviorment using MySQL & Asterisk Addons. I have populated the "sip_buddies" table with the same information that is came from our sip.conf, however registration seems to fail for the softphone we have set up. Does anyone have any idea as to what I should be looking for here? I'm not getting any error messages

Hi I am trying to make asterisk load config from database, so far I get the sip, extension working, but voicemail seems still looking for config file, not from the database. the extconfig.conf looks like ... sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies extensions => mysql,asterisk,extensions_table voicemail => mysql,asterisk,voicemail_users .. the

Hi all, I have the Asterisk set up and 2 softphone (Xlite) set up on two other PC. With the following configuration, I can use one softphone (2000) to call the other one (2001) and/or the voicemail at 2999. Here is my problem: 1. When I dial 9+nxxx-xxxx with one of the softphone to the PSTN via X100P card, I got busy tone. (i.e. I want to use the phone line which is connected to the

I'm going to be testing the new realtime stuff further in the next few days, and just wanted some clarification on a couple of things before I start on it. I believe I can store any config file in a external config such as mgcp.conf for example, by adding it to extconfig.conf with the below syntax. mgcp.conf => mysql,asterisk,mgcpchans Doing this will require a reload of asterisk to read

Hi, Having some issues here with getting asterisk realtime for the dialplan (extensions.conf) setup: mysql> desc extensions_table; +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | MUL | NULL |

Greetings, I'm having some trouble with the realtime engines. When asterisk loads, everything looks fine, there don't seem to be any problems via notices or anything. Furthermore, cdr_odbc is working, and actively logging my failed call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config:

Hi all, I'm using asterisk in real time mode...All extensions are defined in table sip_buddies...Everything looks fine and asterisk is reading extensions info from the sip_buddies table...The problem occurs as soon as any information on an extension is changed from sip_buddies table...Which mean, if I change the secret field in sip_buddies table then i should reload asterisk to read again the

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

Hi all, Any one tried installing Asterisk on Linksys WRT54G? We have but facing problems with SIP to SIP calls. The phones ring and calls are established but we cannot hear any voice at all. I tried allow=all in the general section but did not work. So I forced ulaw. Can any one please check it out and let me know what is wrong? Here are the conf files: Asterisk Version: Asterisk

hello i am trying to use res_odbc for sipuser. my connection is working. i have checked using isql. even cdr_odbc is working but i hav problem in res_odbc. i have created user in sip_buddies table but asterisk is no getting user from this sip_buddies table. /etc/asterisk/extconfig.conf [settings] sipusers=>odbc,asterisk,sip_buddies sippeers=>odbc,asterisk,sip_buddies

Hi, I configured asterisk on redhat linux 9 box. I installed two different ip softphones (SJPHONE and X-PRO) and got them registered with asterisk. The call from one phone to another does get routed via asterisk, but there is one problem coming up. As soon as call is accepted by the end user , it is automatically disconnected with the error "cannot align media streams". If I enable SIP

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to

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 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, Realtime SIP and Extensions are working fine but facing some problems with Voicemail. Added an entry to extconfig.conf voicemail => mysql,asterisk,voicemail_users Created the corresponding table and an entry for mailbox 201. This is also reflected in the CLI as shown below. CLI> realtime load voicemail mailbox 201 Column Name Column Value

maybe a dumb question but what do we have here??? sip-friends.sql # # Table structure for table `sipfriends` # CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `username` varchar(40) default '', `ipaddr` varchar(20) NOT NULL default '',

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:

My database machine is broken and I have to use another one. I made somewhere mistake(s) and get now in the debug file: [Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query: SELECT * FROM sip_buddies WHERE name = '886' [Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query Failed because: Can't find file: './astconf/sip_buddies.frm' (errno: 13) [Feb 24 09:05:25]

Hi All: I'd like to use Realtime Static in terms of the performance concern about dynamic realtime. Assume that I create a table: as following: CREATE TABLE `extensions_table` ( `id` int(11) NOT NULL auto_increment, `context` varchar(20) NOT NULL default '', `exten` varchar(20) NOT NULL default '', `priority` tinyint(4) NOT NULL default '0', `app` varchar(20)