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

[harry gaillac]

Hi all,

Just two questions:

Why asterisk use ODBC(Microsoft?) to connect to SQL
database?

Anybody could answer to my first question ?

Harry

 --- Roy Sigurd Karlsbakk <roy at karlsbakk.net> a écrit
: 
> 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
> 
=== 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