[Asterisk-Users] SIP peers in MySQL Database

Matthew Boehm mboehm at cytelcom.com
Mon Oct 11 10:23:05 MST 2004


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
> > > database.
> > > I would like to define all sip peers in mysql
> > database
> > > so Asterisk from small office could read sip peers
> > > configuration from database office.
> > >
> > > May I use autocreatepeer in all asterisk sip.conf
> > file
> > > with nat=yes in general option ?
> > >
> > > Regards
> > > Harry
> > >
> > > [general]
> > > dbname= Name of database in your Mysql server
> > > dbhost= Hostname of server
> > > dbuser= Username in MySQL
> > > dbpass= Password for user in MySQL
> > > autocreatepeer=yes
> > > nat=yes
> > > ....
> > > -----------   ------------------
> > > |Asterisk |-- |nat/firewall box |
> > > -----------   ------------------
> > >                     |
> > >                     |
> > >            ------------   ------------------
> > >            | Internet |-- |nat/firewall
> > box|-Asterisk
> > >
> > >            ------------   ------------------ 
> > +
> > >                     |                     SIPpeers
> > in
> > >                     |                   mysql
> > database
> > >
> > > -----------   ------------------
> > > |Asterisk |-- |nat/firewall box |
> > > -----------   ------------------
> > >
> > >
> > >
> > >
> > >
> > >
> > > 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
> >
> > _______________________________________________
> > 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
> >
>
>
>
>
>
>
> 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




More information about the asterisk-users mailing list