[Asterisk-Users] SIP peers in MySQL Database

Brian Wilkins brian at hcc.net
Tue Oct 12 06:49:48 MST 2004 

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 ?
> > >
> > > best regards
> > > harry
> > >
> > >  --- Matthew Boehm <mboehm at cytelcom.com> 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" <gaillacharry at yahoo.fr>
> > > > To: "Asterisk Users Mailing List -
> >
> > Non-Commercial
> >
> > > > Discussion"
> > > > <asterisk-users at lists.digium.com>
> > > > 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 <mboehm at cytelcom.com> 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"
> >
> > <gaillacharry at yahoo.fr>
> >
> > > > > > To: <support at digium.com>
> > > > > > Cc: <asterisk-users at lists.digium.com>
> > > > > > Sent: Monday, October 11, 2004 10:01 AM
> > > > > > Subject: [Asterisk-Users] SIP peers in MySQL
> > > > > > Database
> > > > > >
> > > > > > > hello,
> > > > > > >
> > > > > > > I wrote to asterisk-users at lists.digium.com
> >
> > 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
> 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

-- 
--
Heritage Communications Corporation
  Melbourne, FL     USA     32935
http://www.hcc.net

More information about the asterisk-users mailing list