search for: sip_buddie

...2.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing '/etc/asterisk/extconfig.conf': [Feb 22 19:58:23] Found [Feb 22 19:58:23] == Binding voicemail to mysql/AsteriskHosted/voicemail_users [Feb 22 19:58:23] == Binding sipusers to mysql/AsteriskHosted/sip_buddies [Feb 22 19:58:23] == Binding sippeers to mysql/AsteriskHosted/sip_buddies I have the following in extconfig.conf : sipusers => mysql,Asterisk,sip_buddies sippeers => mysql,Asterisk,sip_buddies I have the following in res_mysql.conf : [general] dbhost = 127.0.0.1 dbname = Asterisk dbuse...

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 t...

...ster_verify: Host 127.0.0.1 failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7de2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers => mysql,asterisk,iax_buddies iaxpeers => mysql,asterisk,iax_buddies sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varch...

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 /etc/asterisk/res_odbc.conf [asteirsk] dsn=>asteriskdsn username=>voipbilling password=>voipbilling p...

Hi all I've been doing some testing on realtime using mysql, an have a little question that could not find the answer to or maybe its not posible at this time. Is there a way use "register=>......" on a DB using realtime. For the moment I use it in sip.conf. It will help me a lot if this could be store on a DB somehow. commets or sugestions .... ? thanks Billy

...ly 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 sip_buddies table. ------------------------------------------------------ mysql> update sip_buddies set auth='plaintext'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from sip_buddies; +----------+------+-------------+----------+-----------+-----...

Hello, I'm using Asterisk 1.2 with MySQL support. I use sip_buddies table for SIP clients definition. My problem is that I can not define CLIR. Sip.conf docs says that restrictid = yes hide caller identification. The problem is that definition of sip_buddies field named restrictid is char(1). I tried to set restrictid = y, = 1 - no results. I changed definition...

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 in debug, and just this line from the command li...

Not being an asterisk expert, but having been around the block once or twice when it comes to data and the like, I have made some observations based on the examples given on voip-info.org Sip configs. it appears there is an adjustment to be made in the sip_buddies example table: >>> name Although set to 30 characters, I don't see where it is limited in the text file. In theory, this field could be 250 chars long for those who like to get descriptive in there naming convention. ( I guess this is personal taste). >>> insecure The co...

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 reload' only checks the following files : [Jun 8 17:31:16] == Parsing '/etc/asterisk/sip.conf': [Jun 8 17:31:16] Found [Jun 8 17:3...

...ime+Sip . my res_odbc file as; [root at ao042 asterisk]# cat res_odbc.conf [asterisk] enabled => yes dsn => asterisk username => asterisk password => ******* pre-connect => yes [root at ao042 asterisk]# grep -Ev '^;|^$' extconfig.conf [settings] sipusers => odbc,asterisk,sip_buddies sippeers => odbc,asterisk,sip_buddies and i created the asterisk database with sip_buddies table. Here is my problem: In asterisk console when i run the following command i get the answer, ao042*CLI> realtime load sipusers name 100 Column Name Column Value -...

Hi; I have entries as below in DB, mysql> select * from sip_buddies; +----+------+----------+------------+---------+------------+--------+------- -----+------------+----------+------+ | id | name | context | defaultip | host | mailbox | type | regseconds | ipaddr | username | port | +----+------+----------+------------+---------+------------+--------...

...t '', `username` varchar(40) default '', `ipaddr` varchar(20) NOT NULL default '', `port` int(6) NOT NULL default '0', `regseconds` int(11) NOT NULL default '0', PRIMARY KEY (`name`) ) TYPE=MyISAM; Realtime SIP # # Table structure for table `sip_buddies` # CREATE TABLE `sip_buddies` ( `uniqueid` int(11) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `accountcode` varchar(30) default NULL, `amaflags` char(1) default NULL, `callgroup` varchar(30) default NULL, `callerid` varchar(50) default NULL, `canreinvit...

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] DEBUG[32664]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_buddies WHERE name = '494' [Feb 24 09:05:2...

...eneral] dbhost = 127.0.0.1 dbname = asterisk dbuser = asterisk dbpass = asterisk dbport = 3306 dbsock = /tmp/mysql.sock res_odbc.conf: [mysql] enabled => yes dsn => asterisk username => asterisk password => asterisk pre-connect => yes extconfig.conf: sipusers => mysql,asterisk,sip_buddies sippeers => mysql,asterisk,sip_buddies voicemail => mysql,asterisk,sip_buddies extensions => mysql,asterisk,extensions queues => mysql,asterisk,sip_buddies queue_members => mysql,asterisk,sip_buddies extensions.conf: [office] include => demo ;exten => 333,1, Macro(stdexten,3...

I'm using realtime sip peers and I need to enable a range of IP addresses for a peer. I have: deny = 0.0.0.0/0.0.0.0 permit = xxx.yyy.zzz.0/255.255.255.0 mask = 255.255.255.0 defaultIP = xxx.yyy.zzz.112 host = xxx.yyy.zzz.112 Addresses other than .112 are being denied. Can someone offer assistance? Am I doing something wrong? Bruce

I am using Realtime on Asterisk 11.5 with a SQLite3 backend. While everything seems to be working fine I keep getting this error on my log files: [2014-02-17 19:55:18] WARNING[20569] res_config_sqlite3.c: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = '5060', "regseconds" = '1392692118', "defaultuser" = '2012', "useragent" = 'Aastra 57i/3.2.2.2044', "lastms" = '-1', "fullcontact"...

...#39; at 52221@192.168.70.26:5060 for 3600 -- Saved useragent "Grandstream BT100 1.0.5.20" for peer 52221 -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 from debug /var/log/messages Dec 24 12:16:34 DEBUG[15776]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_buddies WHERE name = '52221' Dec 24 12:16:34 DEBUG[15776]: MySQL RealTime: Everything is fine. Dec 24 12:16:34 VERBOSE[15776]: -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 Dec 24 12:16:35 DEBUG[15776]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_buddies WHERE name...

...he database for a sip friend/peer, RealTime does not update the registration status like it should. I also have several peers which have been offline and Asterisk still reports them as registered, even though the registration seconds are only 200. Asterisk Ver: CVS HEAD 12/1/2004 Layout of sip_buddies: mysql> describe sip_buddies; +----------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------+------+-----+---------+----------------+ | uniqueid | int(11) |...

...=> trunkld [international] include => longdistance include => trunkint [from-pstn] exten => 7157999,1,VoicemailMain() switch => Realtime [residential] include => from-pstn include => international --- And the relevant entries in the DB: mysql> select name, context from sip_buddies; +---------+-------------+ | name | context | +---------+-------------+ | 7157986 | residential | | 7157980 | residential | +---------+-------------+ 2 rows in set (0.01 sec) mysql> select * from extensions; +----+-------------+---------+----------+------------+-------------+ | id | con...