search for: retrieve_sip_conf_from_mysql

...asterisk/etc/asterisk/res_odbc.conf [mysql] dsn => sipfriends username => root password => pre-connect => yes it is not sql-password set. i have only access to this machine. asterisk can't authenficate users from the database. chois2: i copy from asterisk-sources: contrib/scripts/retrieve_sip_conf_from_mysql.pl in my /usr/asterisk/etc/asterisk directory. i create a mysql database: mysqladmin create sip i pasted the table: CREATE TABLE sip ( id INT(11) DEFAULT -1 NOT NULL, keyword VARCHAR(20) NOT NULL, data VARCHAR(50) NOT NULL, flags INT(1) DEFAULT 0 NOT NULL, PRIMARY KEY (id,keyword)...

...up the db schema? and have you entered any sip data into the db? Sean -----Original Message----- From: Chandra [mailto:chandra@digital.com.np] Sent: Tue 1/6/2004 10:57 PM To: asterisk-users@lists.digium.com Cc: Subject: [Asterisk-Users] no results. i have been working with the retrieve_sip_conf_from_mysql.pl file and i have set everything as required. but when i run this script i am continuously getting the "no results" in my screen and the file written by this script has only first result although i have many in my database. this is the part of this script. my @resSet = @{$r...

Hello all! I am trying to load sip.conf from mysql database. I have followed the instructions at <http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers>. Seems that the authentication (user & psw) works fine but I would like to get more information from mysql and I don't know how to retrieve it. Could anybody help me? Any idea about how to do it? Regards, Victor.

...sted as belonging to individual peers. if i set dtmfmode, or qualify, or any of the others listed as individual variables, in [general] will the autocreatepeer use them? I suppose i could write a script to automatically generate peers for asterisk from SER's DB, (along the lines of the current retrieve_sip_conf_from_mysql.pl but having duplicate SIP client entries seems kind of inelegant. any help is appreciated, thanks- yair -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ .

...sted as belonging to individual peers. if i set dtmfmode, or qualify, or any of the others listed as individual variables, in [general] will the autocreatepeer use them? I suppose i could write a script to automatically generate peers for asterisk from SER's DB, (along the lines of the current retrieve_sip_conf_from_mysql.pl) but having duplicate SIP client entries seems kind of inelegant. And, of course, if i'm missing something basic conceptually, i'd be grateful if someone could point that out to me as well. any help is appreciated, thanks- yair

I am wondering what is the best way to send the smallest files with the vm to emai l integration? I am not sure what order the three lines of the format command take, so I have just tried trial and error swapping. I think when set to "gsm" I get the smallest sizes. I can get my Windows Media player to play at least part of the file (get missing codec message from Realplayer), but get a