similar to: Making Asterisk run on Mysql backend

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.

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

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]:

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`

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

I've just compilied th latest CVS of * with USE_MYSQL_FRIENDS enabled ("1"). During startup * tells me that it connects to the db, so this should be fine. Nevertheless I don't see any users from the db when I run "sip show users" or "iax2 show users" although I configured some. It is also not possible to call them. Any hints?

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 I was wandering If I let 2 asterisk boxes (let's name them ast01 and ast02) connect to one SQL realtime iaxfriends/sipfriends database What happens if I register my client to ast01, The ast01 box will update the client's record in the iaxfriends database (ipaddr/port/regseconds) Let's say there is an incoming call then for this client but this call arrives on ast02 (the box

hi, I want to complete asterisk configuration from database(MYSQL),now I come across some doubts: 1. http://voip-info.org/tiki-pagehistory.php?page=Asterisk+configuration+from+database&diff2=3 says that "Dynamic 'friends' (Asterisk v1.0.*) and the number of options supported by this 'MySQL_Friends' system is currently very limited",at the same time I find

Hello Everybody, I was going thru the C code of Asterisk. Does anybody know how does one go about modifying the C code of Asterisk? Please do reply. Regards, Bharat M. Sarvan EZZI BPO Pvt Ltd., PUNE. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello *'s, Hi, I've just tried to enable MYSQL Friends in CVS HEAD. But i cannot find this option.On wiki i found this. To enable this, you need to edit the Makefile in the channels directory of your source tree and enable MYSQL_FRIENDS. This enables database definition of both IAX2 and SIP friends. Make sure you have the MySQL development kit (libraries) installed before

Hi, I had compiled support for MYSQL_FRIENDS and it works for SIP, but when use tiwh IAX2 I have some problem, I can register with a client, but when I try to make a call I got this error: Jul 17 12:52:03 NOTICE[229387]: chan_iax2.c:5183 socket_read: Rejected connect attempt from <IP-ADRRESS> When I google'ed this problem I can see other users also found this error (bug ?) But no-one

hi using sipfriends from mysql from asterisk 1.0 branch, how can I make asterisk show the true channel's current codec with SIP SHOW CHANNELS? This does not seem to work, and bkw_ said sipfriends from mysql didn't have that info at all. For what it may seem, asterisk uses G.726 as told, giving me a -- Format for call is g726 at the start of the call, but in SIP SHOW CHANNELS all these

Hello Everybody, This is Bharat here. I am on the way of learning Asterisks, and I just wished to know how I go about if got to write dailplans for outbound calls and inbound calls. If you could provide me with a simple example, I could get thru. Waiting for your response Regards Bharat M. Sarvan -------------- next part

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

Anyone know the command that tells * to load a sipfriend from the realtime db rather than saying no such host? I've tried various combinations of the rt commands: rtcachefriends=yes; ;rtcache=yes ;rtAutoClear=yes ;rtautoreg=yes ;rtIgnoreRegExpire=yes ;rtupdate=yes rtfromcontact=yes Basically I have a group of 4 * servers all routing calls, but only two are hearing the phones

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

Hello I was just stuck around as to how I configure my Asterisk to access extensions from Mysql. I have made all the necessary changes in the extconfig.conf, the extensions.conf, res_mysql.conf, res_config_odbc.conf,res_odbc.conf as they have mentioned on the site www.voip-info.org <http://www.voip-info.org/> . But still I am getting the error as May 13

11-10-2004 there was a subject: Re: Where did USE_SIP_MYSQL_FRIENDS go?: on asterisk.user list. >All db specific code has been removed from the code in favor of the >currently-in-development "RealTime" method of configuration from >database. >You are most likely not using the 1.0 stable branch. >You need to use the new RealTime configuration method. And currently,

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