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" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Monday, October 11, 2004 10:01 AM > > Subject: [Asterisk-Users] SIP peers in MySQL > > Database > > > > > > > hello, > > > > > > I wrote to [EMAIL PROTECTED] 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 > > > [EMAIL PROTECTED] > > > > > > 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 > > [EMAIL PROTECTED] > > > 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 > [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
