thr3ads.net - asterisk users - [Asterisk-Users] SIP peers in MySQL Database [Oct 2004]

If this information is useful, please help other people find it:
Share via:

harry gaillac

2004-Oct-10 06:19 UTC

[Asterisk-Users] SIP peers in MySQL Database

hello,

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   
           ------------   ------------------      +
                    |                      SIP peers
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

harry gaillac

2004-Oct-11 02:44 UTC

head link

[Asterisk-Users] Re: SIP peers in MySQL Database

Hi,

Look at:
http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers
http://www.voip-info.org/wiki-Asterisk+configuration+from+database

Is it working well? I don't know because of i'm
waiting  a reply in order to use sql database for all
sip clients from small offices asterisk box with nat
context.


May I use autocreatepeer in all asterisk sip.conf file
with nat=yes in general option ???

[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
  
           ------------   ------------------      +
                    |                      SIP peers
in
                    |                    mysql
database 
-----------   ------------------
|Asterisk |-- |nat/firewall box |
-----------   ------------------

Harry

 --- Glynn Condez <glynn@itextron.com> a ?crit : > Hi Harry,
> 
> how did you make sip peers on mysql database? is it
> working well? where can
> I find a documentation so I could migrate my
> Asterisk sip config to use
> Mysql also.
> 
> Regards
> 
>  

	

	
		
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

Tomica Crnek

2004-Oct-11 03:10 UTC

head link

[Asterisk-Users] Re: SIP peers in MySQL Database

It says "To enable this, you need to edit the Makefile in the channels
directory of your source tree and enable MYSQL_FRIENDS.", but there is no 
MYSQL_FRIENDS in channels/Makefile any more.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com 
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of 
> harry gaillac
> Sent: Monday, October 11, 2004 11:45 AM
> To: Glynn Condez
> Cc: asterisk-users@lists.digium.com
> Subject: [Asterisk-Users] Re: SIP peers in MySQL Database
> 
> Hi,
> 
> Look at:
> http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers
> http://www.voip-info.org/wiki-Asterisk+configuration+from+database
> 
> Is it working well? I don't know because of i'm waiting  a 
> reply in order to use sql database for all sip clients from 
> small offices asterisk box with nat context.
> 
> 
> May I use autocreatepeer in all asterisk sip.conf file with 
> nat=yes in general option ???
> 
> [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
>   
>            ------------   ------------------      +
>                     |                      SIP peers
> in
>                     |                    mysql
> database 
> -----------   ------------------
> |Asterisk |-- |nat/firewall box |
> -----------   ------------------
> 
> Harry
> 
>  --- Glynn Condez <glynn@itextron.com> a ?crit : 
> > Hi Harry,
> > 
> > how did you make sip peers on mysql database? is it working well? 
> > where can I find a documentation so I could migrate my Asterisk sip 
> > config to use Mysql also.
> > 
> > Regards
> > 
> >  
> 
> 
> 	
> 
> 	
> 		
> 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@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
>

Tomica Crnek

2004-Oct-11 04:36 UTC

head link

[Asterisk-Users] Re: SIP peers in MySQL Database

>From few days ago there is no USE_MYSQL_FRIENDS in channels/Makefile. That
is why I am asking this.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com 
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of 
> harry gaillac
> Sent: Monday, October 11, 2004 12:19 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: RE: [Asterisk-Users] Re: SIP peers in MySQL Database
> 
> look at ../channels/Makefile
> 
> try USE_MYSQL_FRIENDS=1
> 
> Harry
> ----------------------------------------------------
> #
> # Asterisk -- A telephony toolkit for Linux.
> #
> # Makefile for Channel backends (dynamically loaded) # # 
> Copyright (C) 1999, Mark Spencer # # Mark Spencer 
> <markster@linux-support.net> # # Edited By Belgarath <> Aug 
> 28 2004 # Added bare bones ultrasparc-linux support.
> #
> # This program is free software, distributed under the terms 
> of # the GNU General Public License #
> 
> OSARCH=$(shell uname -s)
> PROC=$(shell uname -m)
> 
> USE_MYSQL_FRIENDS=0
> USE_SIP_MYSQL_FRIENDS=0
> ----------------------------------------------------
> 
> 
>  --- Tomica Crnek <Tomica.Crnek@span.hr> a ?crit : 
> > 
> > It says "To enable this, you need to edit the Makefile in 
> the channels 
> > directory of your source tree and enable MYSQL_FRIENDS.", 
> but there is 
> > no MYSQL_FRIENDS in channels/Makefile any more.
> > 
> > > -----Original Message-----
> > > From: asterisk-users-bounces@lists.digium.com
> > > [mailto:asterisk-users-bounces@lists.digium.com]
> > On Behalf Of
> > > harry gaillac
> > > Sent: Monday, October 11, 2004 11:45 AM
> > > To: Glynn Condez
> > > Cc: asterisk-users@lists.digium.com
> > > Subject: [Asterisk-Users] Re: SIP peers in MySQL
> > Database
> > > 
> > > Hi,
> > > 
> > > Look at:
> > >
> >
> http://www.voip-info.org/wiki-Asterisk+sip+mysql+peers
> > >
> >
> http://www.voip-info.org/wiki-Asterisk+configuration+from+database
> > > 
> > > Is it working well? I don't know because of i'm
> > waiting  a
> > > reply in order to use sql database for all sip
> > clients from
> > > small offices asterisk box with nat context.
> > > 
> > > 
> > > May I use autocreatepeer in all asterisk sip.conf
> > file with
> > > nat=yes in general option ???
> > > 
> > > [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
> > >   
> > >            ------------   ------------------     
> > +
> > >                     |                      SIP
> > peers
> > > in
> > >                     |                    mysql
> > > database 
> > > -----------   ------------------
> > > |Asterisk |-- |nat/firewall box |
> > > -----------   ------------------
> > > 
> > > Harry
> > > 
> > >  --- Glynn Condez <glynn@itextron.com> a ?crit : 
> > > > Hi Harry,
> > > > 
> > > > how did you make sip peers on mysql database? is
> > it working well? 
> > > > where can I find a documentation so I could
> > migrate my Asterisk sip
> > > > config to use Mysql also.
> > > > 
> > > > Regards
> > > > 
> > > >  
> > > 
> > > 
> > > 	
> > > 
> > > 	
> > > 		
> > > 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@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@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@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
>

Andreas Sikkema

2004-Oct-11 06:58 UTC

head link

[Asterisk-Users] Re: SIP peers in MySQL Database

asterisk-users-bounces@lists.digium.com wrote:
> 	But In my tests you would never see this unless you're doing 10k
> selects and 5k inserts and that's on a 1ghz box.
Per seconds? Per day?

-- 
Andreas Sikkema                Rits tele.com
Scheepmakersstraat 11      3011 VH Rotterdam
t: +31 (0)10 2245544    f: +31 (0)10 2245540

harry gaillac

2004-Oct-11 08:01 UTC

head link

[Asterisk-Users] SIP peers in MySQL Database

hello,

I wrote to asterisk-users@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

Linus Surguy

2004-Oct-11 11:16 UTC

head link

[Asterisk-Users] Database of world area codes

Also, try www.wtng.info

Linus

harry gaillac

2004-Oct-13 08:28 UTC

head link

[Asterisk-Users] SIP peers in MySQL Database

ok but if i add or remove variables from database.
Does the perl script overwrite the conf file ?
for example i remove a phone so i run the perl script
on pbx in order to update config file.Is it a problem
for real time calls ?

harry


 --- Brian West <brian@bkw.org> a ?crit : > > > include => sip_additional.conf in [general]
> 
> Ok Just for the sake of some poor soul 4 months from
> now that keeps trying
> to do an include and reads this info thinking its
> correct.
> 
> The proper way is:
> 
> #include somefile.conf
> 
> Or
> 
> #include /full/path/to/a/file.conf
> 
> No => and you MUST have a # in front.
> 
> bkw
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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 - Oct 2004 - SIP peers in MySQL Database

[Asterisk-Users] SIP peers in MySQL Database

[Asterisk-Users] Re: SIP peers in MySQL Database

[Asterisk-Users] Re: SIP peers in MySQL Database

[Asterisk-Users] Re: SIP peers in MySQL Database

[Asterisk-Users] Re: SIP peers in MySQL Database

[Asterisk-Users] SIP peers in MySQL Database

[Asterisk-Users] Database of world area codes

[Asterisk-Users] SIP peers in MySQL Database