similar to: Database Configration

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

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

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

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

Dear sir, We are using Rethat linnex 9 with which we got samba 2.2.7a. we are able to connect windows 98 and win xp machines, but the problem is we are not able to connect win 3.11 machines is there any add-on package for connecting win 3.11 clients ( windows workgrops ) with regards Jayaram Prasad, Sr.Dy.Systems Engineer. Systems Dept. Hyderabad. jayaram

Hai all, Iam a newbie to Asterisk. I want to configure my Asterisk thru Command Line Interface to connect two internal extensions and two external numbers and calls should occur between any of the two numbers. Can anybody kindly send me the configyration details for extensions.conf anf sip.conf file.. and if anything else needed to serve my purpose. Iam in a great need of this.... A reply word

Hi guys. I installed centos 6.3 os my computer and i installed samba. My purpose, i want to do fileserver. How can i configure /etc/samba/smb.conf file.

I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. You're Invited to Gmail! mahmoud mansy has invited you to open a Gmail account. Gmail is Google's free email service, built on the idea that email can be intuitive, efficient, and fun. Gmail has: *Less spam* Keep unwanted messages out of your inbox with Google's

Hello I change this from chan_sip.conf (see ipsvr): static void realtime_update_peer(const char *peername, struct sockaddr_in *sin, const char *username, const char *fullcontact, int expirey) { char port[10]; char ipaddr[20]; char regseconds[20]; time_t nowtime; -> char ipsvr[20]; time(&nowtime); nowtime += expirey;

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

Hi guys, im using realtime and I want to show registered users or online users on a webpage and offline users. Im taking regseconds field to make this happend If regseconds value is 0 then user appers offline, it regseconds is something else then its online, but sometimes this works and sometimes it does not. Im using the following options rtcachefriends=yes rtnoupdate=yes

Hello, We use Asterisk Realtime for our billing software. 200+ installations of Asterisk with Realtime, but I see this for the first time. Asterisk 1.4.17, Addons 1.4.5, No patches, no NAT - just plain simple installation. With debug I can see: [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27885]:

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

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