> How do you update many pbx ? crontab ? How often are you needing to update them? Hourly? Daily? I only have 1 * box so I currently use the perl script method on our prod server. I'm using the RealTime on our dev server.
RealTime will deffinatly be easier once it has become stablized. You will be able to have multiple Sip tables in 1 database server that can handle multiple * machines. Be patient.. -Matthew > > 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 ? > > > > > > best regards > > > harry > > > > > > --- Matthew Boehm <[EMAIL PROTECTED]> a écrit : > > > > It is possible to use 1 database for many > > asterisk > > > > boxes. You can do this > > > > with the retreive script I mentioned. By adding > > > > another column to the > > > > database to indicate which * server that phone > > > > belongs to, you can easialy > > > > change the script on a per machine basis. > > > > > > > > Matthew > > > > > > > > ----- Original Message ----- > > > > From: "harry gaillac" <[EMAIL PROTECTED]> > > > > To: "Asterisk Users Mailing List - > > Non-Commercial > > > > Discussion" > > > > <[EMAIL PROTECTED]> > > > > Sent: Monday, October 11, 2004 12:00 PM > > > > Subject: Re: [Asterisk-Users] SIP peers in MySQL > > > > Database > > > > > > > > > > > > > I agree you users from asterisk list don't > > have to > > > > > give me "FREE SUPPORT" the day after I posted > > a > > > > > question . > > > > > > > > > > I was thinking many users are used to register > > sip > > > > > clients in sql database not one sip.conf per > > > > Asterisk > > > > > pbx box . > > > > > > > > > > harry > > > > > > > > > > > > > > > --- Matthew Boehm <[EMAIL PROTECTED]> a > > écrit : > > > > > > You have obviously never posted to any kind > > of > > > > > > mailing list before. > > > > > > Sometimes you may have to wait a few days > > for > > > > > > someone to answer you. > > > > > > Sometimes people just don't know. Griping to > > the > > > > > > owners of the list about > > > > > > the people who take time out of their day to > > > > give > > > > > > you FREE support isn't > > > > > > going to make things better nor will it make > > you > > > > > > popular nor will you get a > > > > > > faster response (if any). > > > > > > > > > > > > As long as the database can be accessed by > > the > > > > > > asterisk server, then you can > > > > > > store sip info into that database. You > > should > > > > not > > > > > > need to use autocreate. If > > > > > > you don't need immediate, uptodate, realtime > > sip > > > > > > configuration, look in > > > > > > <ASTERISK SOURCE ROOT>/contrib/scripts/ for > > > > > > something called > > > > > > retreive_sip_from_mysql.pl or something > > like > > > > that. > > > > > > That is what I use. > > > > > > > > > > > > Or you can be patient and the new RealTime > > > > method > > > > > > should be in stable form > > > > > > in a week or two. > > > > > > > > > > > > Matthew > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "harry gaillac" > > <[EMAIL PROTECTED]> > > > > > > To: <[EMAIL PROTECTED]> > > > > > > Cc: <[EMAIL PROTECTED]> > > > > > > Sent: Monday, October 11, 2004 10:01 AM > > > > > > Subject: [Asterisk-Users] SIP peers in MySQL > > > > > > Database > > > > > > > > > > > > > > > > > > > hello, > > > > > > > > > > > > > > I wrote to [EMAIL PROTECTED] > > in > > > > > > order to > > > > > > > someone help me without reply ????? > > > > > > > > > > > > > > May be you could help me > > > > > > > > > > > > > > Here is my problem.Two smalls offices with > > sip > > > > > > clients > > > > > > > > > > > > > > + Asterisk, one offices with Asterisk and > > > > mysql > > > === 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
