similar to: What is sip-friends.sql??????

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,

Hi all, From the web, I can find a table scheme of sipusers for ARA using. However, I can't find any meaning of each field, especially for the field regserver which is new in the table. Can any tell me more detail about the usage of each field? CREATE TABLE `sip_buddies` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `host` varchar(31) NOT NULL

Hi all! So far I've always used plaintext passwords for SIP, but now I've decided to use MD5 encryption. For each client I edited its section as follows, then: auth=md5 md5secret=hashed_passwd ;secret=plaintext_passwd where hashed_passwd is the output of echo -n "user:realm:plaintext_passwd" | md5sum When the first SIP clients registers with Asterisk after a "sip

Hello I need to add sip extensions from my UI so without going through sip.conf so i created table CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `username` varchar(40) default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `ipaddr` varchar(20) NOT NULL default '', `port`

hi, i.m. newbie in asterisk. asterisk 1.0.3 is my current version. i like to store usernames and passwords in a sql database. i like to log failed authentification-passwords, to create a blacklist for securityreasons. i thingk a sql-database is a good way to log these actions. i don.t find debugging-options to output invalid login-passwords. Ok, i have made the following: debian is my OS.

Hello I need to add sip extensions from my UI so without going through sip.conf so i created table CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `username` varchar(40) default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `ipaddr` varchar(20) NOT NULL default '', `port`

ok so my table looks like this... REATE TABLE `sip` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `accountcode` varchar(20) default NULL, `amaflags` varchar(7) default NULL, `callgroup` varchar(10) default NULL, `callerid` varchar(80) default NULL, `canreinvite` char(3) default 'yes', `context` varchar(80) default NULL, `defaultip`

It seems that when setting qualify = 200 or qualify = yes in the 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

can anybody identify why the CLI is issuing a failure message while debug shows everything is fine???? this makes no sense to me. also, why is the username being updated? this has got to be wrong from CLI -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 -- SIP Seeding '52221' at 52221@192.168.70.26:5060 for 3600 Dec 24 12:16:35 NOTICE[15776]:

Hello there, I have configured my asterisk to run on Mysql backend. But the Asterisk was unable to pick the peer details from the database. This is how I configured the Asterisk to run with mysql on the backend. Edit /usr/src/asterisk/channels/Makefile, change it to enable the MYSQL_FRIENDS USE_MYSQL_FRIENDS=1 USE_SIP_MYSQL_FRIENDS=1 cd /usr/src/asterisk make

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': ==

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

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',

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

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:

Has anybody seen this behaviour? sip conf is stored in mysql database in 2 tables ast_config for static (general) key/values sip_buddies for sip extension detail. database on the same machine as asterisk Grandstream phones (I happen to have 2) register with asterisk via sip with accounts and passwords successfully for a variable period of time. Then after a while, i get errors which appear to

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

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! | | | |

does anybody know what these log messages mean? what ever it is, asterisk needed a restart to become active again. (server was not rebooted and remained live to ssh and other network functions.) no outgoing calls can be made. The system was just sitting idle over night and trying to make a call about mid morning failed. == Parsing '/etc/asterisk/asterisk.conf': Found == Parsing

Hello, Right now there is not a table build script at: http://www.voip-info.org/wiki-Asterisk+RealTime+IAX Therefore I have taken the SIP build script and added a few fields that I use from my iax.conf (could be more out there, please see the complete build script below): `dbsecret` varchar(100) default '', `notransfer` varchar(100) default '', `inkeys` varchar(100)