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

[harry gaillac]

Here is my first question.
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 |
-----------   ------------------

 --- Brian West <brian at bkw.org> a écrit : 
> > Why asterisk use ODBC(Microsoft?) to connect to
> SQL
> > database?
> 
> 1. It's not Microsoft at all.
> 2. It's unixODBC (I don't see Microsoft here at all)
> 3. Wider database support without having to know
> each database type.
> 4. It's not much slower than native DB drivers.
> (15-33% slower)
> 
> 	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.
> 
> > Anybody could answer to my first question ?
> 
> Not really sure what your first question is and I'm
> not gonna dig for it.
> 
> bkw
> 
> _______________________________________________
> 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