[Asterisk-Users] SIP peers in MySQL Database

Wed Oct 13 09:23:50 MST 2004

app_realtime is something seperate used in your dial plan. Look at
app_realtime.c for examples.

Matthew
----- Original Message ----- 
From: "harry gaillac" <gaillacharry at yahoo.fr>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
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 <mboehm at cytelcom.com> 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" <gaillacharry at yahoo.fr>
> > To: "Asterisk Users Mailing List - Non-Commercial
> > Discussion"
> > <asterisk-users at lists.digium.com>
> > 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 <brian at hcc.net> 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 <mboehm at cytelcom.com> 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', '3038 at cytel', 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"
> > <gaillacharry at yahoo.fr>
> > > > > > To: "Asterisk Users Mailing List -
> > > > Non-Commercial
> > > > > > Discussion"
> > > > > > <asterisk-users at lists.digium.com>
> > > > > > 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
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users