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

[Roy Sigurd Karlsbakk]

res_config_odbc and ast_data is the "new way"
the old way is still in 1.0.1 and CVS -r v1-0
ast_data is available at
http://svn.asteriskdocs.org/res_data/

roy

On Oct 11, 2004, at 14:47, harry gaillac wrote:

> Sorry
> I have not look at CVS but I would like somebody help
> me too about my problem.
>
> help please
>
>
>  --- Roy Sigurd Karlsbakk <roy at karlsbakk.net> a écrit
> :
>> it's in there in -r v1-0, but replaced by "some
>> realtime stuff" in
>> development CVS
>> I haven't found out more about that, though..
>>
>> On Oct 11, 2004, at 13:36, Tomica Crnek wrote:
>>
>>>
>>>> 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 at lists.digium.com
>>>> [mailto:asterisk-users-bounces at 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 at 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 at 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 at lists.digium.com
>>>>>>
>> [mailto:asterisk-users-bounces at lists.digium.com]
>>>>> On Behalf Of
>>>>>> harry gaillac
>>>>>> Sent: Monday, October 11, 2004 11:45 AM
>>>>>> To: Glynn Condez
>>>>>> Cc: asterisk-users at 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 at 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 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
> === message truncated ===
>
>
> 	
>
> 	
> 		
> 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
>