[Asterisk-Users] SIP peers in MySQL Database
harry gaillac
gaillacharry at yahoo.fr
Tue Oct 12 10:26:34 MST 2004
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
More information about the asterisk-users
mailing list