res_config stores an entire *.conf file into a table. This is known as 'static' under the new RealTime method. The load_realtime and update_realtime methods will select info from a table where each column is a possible field in the conf file. For example, if a section of your sip.conf file looked like this:
[bob] hostname=dynamic nat=yes type=user Then your associated sip table would have at least the following columns: (I say at least because my sip table has over 30 columns, 1 for each possible sip configuration) name hostname nat type Look at docs/README.extconfig for more examples. If you REALLY want to start messing with it now, the only 'official' driver for RealTime is for ODBC. The only 'known' MySQL RealTime driver was written by myself over the weekend. Find it here: http://bugs.digium.com/bug_view_page.php?bug_id=0002613 I say 'known' because nobody else has claimed responsibility for writing/creating one for MySQL. Hopefully, I am now that person. =) If you use it, please pass on any bugs, and/or successes to me off list. Thanks, Matthew ----- Original Message ----- From: "Michael Baird" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Monday, October 11, 2004 3:54 PM Subject: Re: [Asterisk-Users] SIP peers in MySQL Database > Matthew, will the new method for dynamic storage of sip peers be based > on res_config? Or will it be some new method, is there anything I can > look at to start researching it yet? > > Regards > Michael Baird > > > 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-user > > _______________________________________________ > 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
