app_realtime is something seperate used in your dial plan. Look at app_realtime.c for examples.
Matthew ----- Original Message ----- From: "harry gaillac" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Wednesday, October 13, 2004 9:43 AM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database > ok i agree you but what's app_realtime how does it > work? > > harry > > --- Matthew Boehm <[EMAIL PROTECTED]> a �crit : > > No you don't. > > > > You had it right in that last email. 1 db server, > > multiple * boxes. Make 1 > > sip table on the db server for each location. Then > > on each seperate * box, > > run the perl script to generate a new sip for that * > > box. Pretty simple. > > > > Matthew > > > > ----- Original Message ----- > > From: "harry gaillac" <[EMAIL PROTECTED]> > > To: "Asterisk Users Mailing List - Non-Commercial > > Discussion" > > <[EMAIL PROTECTED]> > > Sent: Wednesday, October 13, 2004 5:00 AM > > Subject: Re: [Asterisk-Users] SIP peers in MySQL > > Database > > > > > > > Ok in order to add a conf file in sip.conf we need > > to > > > load app_realtime > > > harry > > > > > > --- Brian Wilkins <[EMAIL PROTECTED]> a �crit : > > > > I believe retrieving in real-time is being > > worked on > > > > and should be done soon. > > > > Developers are almost finished working on > > RealTime. > > > > > > > > include => sip_additional.conf in [general] > > > > > > > > > > > > On Tuesday 12 October 2004 05:26 pm, harry > > gaillac > > > > wrote: > > > > > hello Matthew, > > > > > > > > > > I was wrong -:) but retrieving all sip info > > from > > > > > database would be better than running a perl > > > > script on > > > > > every Asterisk box in order to rebuild a > > > > > sip_additionnal.conf.(??) > > > > > > > > > > so I have to create the table run the perl > > script > > > > in > > > > > order to create or overwrite a > > > > sip-additionnal.conf > > > > > but I don't understand "Go into sip.conf and > > add a > > > > > #include line for this new file." > > > > > > > > > > You mean i have to add > > > > > include /etc/asterisk/sip-additionnal.conf in > > > > sip.conf > > > > > > > > > > [general] > > > > > context=default > > > > > ;recordhistory=yes > > > > > ... > > > > > include /etc/asterisk/sip-additionnal.conf > > > > > > > > > > How do you update many pbx ? crontab ? > > > > > > > > > > Best regards > > > > > Harry > > > > > > > > > > NB: everybody should be able to find a full > > > > > documentation about Asterisk features not in > > > > mailing > > > > > list. > > > > > I look at voip-info. > > > > > > > > > > --- Matthew Boehm <[EMAIL PROTECTED]> a > > �crit : > > > > > > Yes you are wrong. You seem to be combining > > two > > > > > > different methods of getting > > > > > > SIP info out of a database. Pick 1. I use > > the > > > > perl > > > > > > script right now so here > > > > > > is how to do that: > > > > > > > > > > > > In order to use the perl script which can > > > > support > > > > > > 'ALL' sip abilities, use > > > > > > this table: > > > > > > > > > > > > CREATE TABLE sip_perl ( > > > > > > 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) > > > > > > ); > > > > > > > > > > > > Then, insert a new row for each sip > > parameter > > > > > > keeping the 'id' the same for > > > > > > each phone: > > > > > > > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'account', '3038', 0); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'callerid', '"Cytel" <2814494000>', 1); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'nat', 'yes', 0); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'context', 'cytel-internal', 0); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'type', 'friend', 0); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'mailbox', '[EMAIL PROTECTED]', 0); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'secret', '3038joshdana', 0); > > > > > > INSERT INTO `sip_perl` (`id`, `keyword`, > > `DATA`, > > > > > > `flags`) VALUES (3038, > > > > > > 'host', 'dynamic', 0); > > > > > > > > > > > > Edit the perl script to match. Then run the > > perl > > > > > > script. It should > > > > > > create/overwrite whatever file you set in it > > and > > > > > > produce a new .conf > > > > > > > > > > > > Go into sip.conf and add a #include line for > > > > this > > > > > > new file. > > > > > > > > > > > > Matthew > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "harry gaillac" > > <[EMAIL PROTECTED]> > > > > > > To: "Asterisk Users Mailing List - > > > > Non-Commercial > > > > > > Discussion" > > > > > > <[EMAIL PROTECTED]> > > > > > > Sent: Monday, October 11, 2004 6:42 PM > > > > > > Subject: Re: [Asterisk-Users] SIP peers in > > MySQL > > > > > > Database > > > > > > > > > > > > > I read the perl script. > > > > > > > here is 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 > > '', > > > > > > > `port` int(6) NOT NULL default '0', > > > > > > > `regseconds` int(11) NOT NULL default > > '0', > > > > > > > PRIMARY KEY (`name`) > > > > > > > ) TYPE=MyISAM; > > > > > > > > > > > > > > I would like asterisk retrieve all > > sipfriends > > > > > > > variables > > > > > > > from database. > > > > > > > > > > > > > > I wish to add other variables for each sip > > > > clients > > > > > > > like qualify, nat, ... in sipfriends table > > but > > > > sip > > > > > > > code channel don't seem to be able to > > support > > > > > > > > > > > > others > > > > > > > > > > > > > variables. > > > > > > > may be i'm wrong ? > > > === message truncated === > > > > > > > Vous manquez d'espace pour stocker vos mails ? > Yahoo! Mail vous offre GRATUITEMENT 100 Mo ! > Cr�ez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/ > > Le nouveau Yahoo! Messenger est arriv� ! D�couvrez toutes les nouveaut�s pour dialoguer instantan�ment avec vos amis. A t�l�charger gratuitement sur http://fr.messenger.yahoo.com > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
