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

[Arnaud Pignard]

look at unixODBC or iodbc for more information

Also the reason (i guess) why they move to ODBC is that's ODBC have many 
connector to most SQL database.

At 15:26 11/10/2004, you wrote:
>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
>_______________________________________________
>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