similar to: Asterisk Database Configuration

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`

Hello, Asterisk Real time database worked on astersik 1.6.2.0 but now i am working on Asterisk to latest version which is 1.6.2.2 ,there is a a warning [Feb 24 16:26:14] WARNING[4053]: config.c:2025 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available [Feb 24 16:26:14] NOTICE[4053]: chan_sip.c:21500 handle_request_register:

Hello I am new in Asterisk Java, i am working on Asterisk 1.6.2.0 , i started the first example Hello AGI in this tutorial http://asterisk-java.org/development/tutorial.html I put the jar file and the proparty file in folder i wrote in extensions.conf this exten => 1300,1,AGI(agi:// 192.168.50.127/hello.agi,${EXTEN},${UNIQUEID},${CALLERID(name)}) I started AGI server ,then when i call

Hello, I am new in Asterisk Community, i am working on Asterisk 1.6, i need to know how can i monitor the extension status? when i wrote sip show peers on asterisk Extension Domain port Status 111/111 (Unspecified) D 0 Unmonitored 1300/1300 192.168.50.111 D 5060 Unmonitored 222/222

Hi there asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs; here some info: *CLI> realtime load sipfriends name 104 Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104' Jan 13 11:52:21 DEBUG[8928]:

I am currently in the process of testing out realtime support for sip.conf. I have followed all of the directions that are listed in the Wiki, but for some reason this does not work. When utilizing a flat file, I am able to register endpoints without any problems, and calls can proceed. One interesting side effect that I have noticed is that when I am using realtime for sip, I am unable to see

Hello all, I recently noticed the realTime effort and must say it is a nice idea! I would appreciate any help to get it running .. I downloaded the code & patches and succefully patched my asterisk (CVS-HEAD-11/29/04-12). - created a DB called asterisk, and a table sip using the schema supplied at http://bugs.digium.com/bug_view_page.php?bug_id=0002613. - entered an entry: insert into

Greetings, Is there a way to tie a specific sip username to a IP address when authenticating against mysql sipfriends table? (USE_MYSQL_FRIENDS=1 USE_SIP_MYSQL_FRIENDS=1 in channels/Makefile) The reason is that I'm using Wellgate FXSes that have second/third/fourth FXS ports bugged when I use a password, but work ok when there is no password. Linking the username to a specific ip could

Is it possible to load phone registration information stored in sipfriends MySQL DB, so that Asterisk "thinks" those phones are already registered? This would be very usefull for a redundant server... Regards, Ricardo Carvalho. -------------- next part -------------- An HTML attachment was scrubbed... URL:

I am using mysql sipfriends and can't seem to get the MWI to work. From what I've read it seems this is not supported with that dynamic system, and probably never will be. I was thinking of just setting a cron job or something to check every minute for voicemail and set our sip NOTIFY messages as needed. Also, the PAP2-NA has the ability to reboot via a sip notify and I would like to be

Hi, I have some mySQL-sipfriends and connectivity to PSTN. When a call from PSTN comes, it shows a callerid, and that callerid is displayed at the called sip phone. When the call comes from another sip user (defined as mySQL-sipfriend), no callerid is displayed at the called sip phone. I turned on sip debug and discovered, that in the last case in the SIP-header to the called phone: From:

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, i'm a bit puzzled because i do not get include and hint to work with the new realtime enginge (cvs-head from 2004-12-09). other things (sipfriends and "normal" extensions) work perfect with the realtime engine. the entries in the static extensions.conf file i used before where: exten => 183,hint,SIP/snom220 exten => 183,1,Macro(stdexten,443,SIP/snom220,183) exten =>

Hello I am trying to attach a database to asterisk , can anyone help me? in extconfig.conf sipusers => mysql,general,sip in res_mysql.conf [general] dbhost = 192.168.50.125 dbname = asterisk dbuser = root dbpass = ahmed dbport = 3306 dbsock = /tmp/mysql.sock i created a table in MySql CREATE TABLE `sip` ( `name` varchar(40) NOT NULL default '',`username` varchar(40) default

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.

Hey All, We are looking to expand our usage of Asterisk and I am trying to make as much of the configuration dynamic as I possibly can. The only part that I'm having problems with is sip.conf. I can get asterisk to register each extension with our local SER SIP proxy dynamically by using the "sipfriends" table in the database, but I'm having trouble with the message waiting

I'm authenticating against sipfriends in MySQL, and have just noticed that none of the below commands return any output: sip show users sip show inuse sip show active sip show subscriptions Is this a bug or something wrong on my side? I'm using the stable 1.0 cvs Vahan

Hello *'s, i am using Realtime Sip drivers but its not working here is my configs: extconfig.conf [settings] ; Realtime configuration engine ; ; maps a particular family of realtime ; configuration to a given database driver, ; database and table (or uses the name of ; the family if the table is not specified ; sipfriends => mysql,asterisk,sip_friends res_mysql.conf [general] dbhost =

Having problems getting realtime working, I'm trying to use odbc for all of this. I've got Fedora 3 and have been fighting with odbc for a day now. I think I got it working correctly, however I can't seem to get the realtime portion working. In asterisk 'odbc show' shows it connected, I see it on my (odbc) mysql server connected and all, it connects and just idles. So, without

Hi all, Is there a way to keep track in Asterisk of which phones are online in realtime using some MySQL DB table for exemple, much like "sip show peers" does in the CLI? Regards, Ricardo.