asterisk users - Jun 2005 - Keeping users, extensions, voicemail and so on in DB

Hello,

I have one question regarding *. Default configuration for asterisk is to
keep configuration(s) in ordinary text based config files. 

My question is simple: is it possible to keep those config info (at least,
to start from - sip.conf, extensions.conf and voicemail.conf) on a database,
which asterisk access via ODBC. If it is possible, I'd appreciate if someone
points me where I can read more about it and shows me some examples. Also
I'd like to know, how asterisk behaves (in terms of stability and
performance) in this environment.


I.N.

Search for "asterisk realtime" at www.voip-info.org

Answer is yes, mysql or odbc.

Requires head, not stable.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Irakli Natsvlishvili
> Sent: Monday, June 13, 2005 11:22 PM
> To: asterisk-users@lists.digium.com
> Subject: [Asterisk-Users] Keeping users, extensions,voicemail and so
on in
> DB
> 
> Hello,
> 
> I have one question regarding *. Default configuration for asterisk is
to
> keep configuration(s) in ordinary text based config files.
> 
> My question is simple: is it possible to keep those config info (at
least,
> to start from - sip.conf, extensions.conf and voicemail.conf) on a
> database,
> which asterisk access via ODBC. If it is possible, I'd appreciate if
> someone
> points me where I can read more about it and shows me some examples.
Also
> I'd like to know, how asterisk behaves (in terms of stability and
> performance) in this environment.
> 
> 
> I.N.
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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

As far as performance, * caches static config, but queries realtime
configs, so scalability must be impacted, but I personally have not
approached the limits of realtime yet.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Irakli Natsvlishvili
> Sent: Monday, June 13, 2005 11:22 PM
> To: asterisk-users@lists.digium.com
> Subject: [Asterisk-Users] Keeping users, extensions,voicemail and so
on in
> DB
> 
> Hello,
> 
> I have one question regarding *. Default configuration for asterisk is
to
> keep configuration(s) in ordinary text based config files.
> 
> My question is simple: is it possible to keep those config info (at
least,
> to start from - sip.conf, extensions.conf and voicemail.conf) on a
> database,
> which asterisk access via ODBC. If it is possible, I'd appreciate if
> someone
> points me where I can read more about it and shows me some examples.
Also
> I'd like to know, how asterisk behaves (in terms of stability and
> performance) in this environment.
> 
> 
> I.N.
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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

Yes it is now possible to store configuration files in database, via
Mysql support or via ODBC. But we have find that Mysql is works much
better.

regards
shams

On 6/14/05, Irakli Natsvlishvili <iraklin@gmail.com>
wrote:
> Hello,
> 
> I have one question regarding *. Default configuration for asterisk is to
> keep configuration(s) in ordinary text based config files.
> 
> My question is simple: is it possible to keep those config info (at least,
> to start from - sip.conf, extensions.conf and voicemail.conf) on a
database,
> which asterisk access via ODBC. If it is possible, I'd appreciate if
someone
> points me where I can read more about it and shows me some examples. Also
> I'd like to know, how asterisk behaves (in terms of stability and
> performance) in this environment.
> 
> 
> I.N.
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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
> 

-- 
Best Regards
Shamsul Arefin
Saktek Technologies

When in realtime mode, does * uses static configs at all? Is it possible to
operate in realtime mode and have static configs (which are build based on
information taken from DB) as fallback solution?


I.N. 
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Damon Estep
Sent: Monday, June 13, 2005 10:29 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and so on
in DB

As far as performance, * caches static config, but queries realtime
configs, so scalability must be impacted, but I personally have not
approached the limits of realtime yet.

Not as fallback, but both can be used together;

You can have some static info in the test files and some in realtime, *
will use the sum of both.

The main benefit to RT is the reduction in the need to "reload"

Read the wiki, these answers and much more are in there.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Irakli Natsvlishvili
> Sent: Monday, June 13, 2005 11:40 PM
> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and
so
> on in DB
> 
> When in realtime mode, does * uses static configs at all? Is it
possible
> to
> operate in realtime mode and have static configs (which are build
based on
> information taken from DB) as fallback solution?
> 
> 
> I.N.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Damon
Estep
> Sent: Monday, June 13, 2005 10:29 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and
so
> on
> in DB
> 
> As far as performance, * caches static config, but queries realtime
> configs, so scalability must be impacted, but I personally have not
> approached the limits of realtime yet.
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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

Forget about MS SQL, odbc drivers that run on linux to talk to MS SQL
stink Odbc in general stinks.

You might be able to get MS SQL DTS (data transformation services) to
link to the mysql database and present the data as it were in your ms
sql database.

There is a pretty good odbc 3.51 mysql driver for windows, as well as a
.net provider. Both at www.mysql.org.

Mysql is free, * will talk to is using the native TDS

You can run the windows version of mysql on a windows box if you wish,
but why? Faster if it is on the same box as asterisk unless * is heavily
loaded.

I tried the * > realtime > odbc > mssql thing, gave up after having
poor
results getting the various ms sql drivers for linux to work right.

our main app uses data in ms sql and mysql and there is a common key in
the data to link accounting data with the * user data for views where
they are both required.

We also use mysql for cdr for billing purposes.

I was much more comfortable with .net ms sql, but the transition and
integration with mysql was easy. Just store the asterisk specific data
in mysql, everthing else in ms sql if you must.






> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Irakli Natsvlishvili
> Sent: Tuesday, June 14, 2005 12:04 AM
> To: 'Shamsul Arefin'; 'Asterisk Users Mailing List -
Non-Commercial
> Discussion'
> Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and
so
> on in DB
> 
> Could you go with some details? What was better performance,
stability?
> All our user info is in MS SQL and we have billing based on it, so it
> won't
> be easy to move to mysql.
> 
> I.N.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Shamsul
> Arefin
> Sent: Monday, June 13, 2005 10:36 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] Keeping users, extensions,voicemail and
so
> on
> in DB
> 
> Yes it is now possible to store configuration files in database, via
> Mysql support or via ODBC. But we have find that Mysql is works much
> better.
> 
> regards
> shams
> 
> On 6/14/05, Irakli Natsvlishvili <iraklin@gmail.com> wrote:
> > Hello,
> >
> > I have one question regarding *. Default configuration for asterisk
is
> to
> > keep configuration(s) in ordinary text based config files.
> >
> > My question is simple: is it possible to keep those config info (at
> least,
> > to start from - sip.conf, extensions.conf and voicemail.conf) on a
> database,
> > which asterisk access via ODBC. If it is possible, I'd appreciate
if
> someone
> > points me where I can read more about it and shows me some examples.
> Also
> > I'd like to know, how asterisk behaves (in terms of stability and
> > performance) in this environment.
> >
> >
> > I.N.
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users@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
> >
> 
> 
> --
> Best Regards
> Shamsul Arefin
> Saktek Technologies
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@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@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

If your app is .net get the .net provider for mysql and give it to your
dba/programmer with the docs, he/she will figure it out. No different
than talking to ms sql with .net except you reference a different data
provider.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Irakli Natsvlishvili
> Sent: Tuesday, June 14, 2005 12:43 AM
> To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
> Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and
so
> on in DB
> 
> Thanks for info . How do you integrate * specific data in mysql with
data
> from MSSQL? App is running on .NET, in this case it will  need to have
> assess to both DBs and update them simultaneously. Sorry, I'm not a DB
> admin.
> 
> 
> I.N.
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Damon
Estep
> Sent: Monday, June 13, 2005 11:21 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail and
so
> on
> in DB
> 
> Forget about MS SQL, odbc drivers that run on linux to talk to MS SQL
> stink Odbc in general stinks.
> 
> You might be able to get MS SQL DTS (data transformation services) to
> link to the mysql database and present the data as it were in your ms
> sql database.
> 
> There is a pretty good odbc 3.51 mysql driver for windows, as well as
a
> .net provider. Both at www.mysql.org.
> 
> Mysql is free, * will talk to is using the native TDS
> 
> You can run the windows version of mysql on a windows box if you wish,
> but why? Faster if it is on the same box as asterisk unless * is
heavily
> loaded.
> 
> I tried the * > realtime > odbc > mssql thing, gave up after
having
poor
> results getting the various ms sql drivers for linux to work right.
> 
> our main app uses data in ms sql and mysql and there is a common key
in
> the data to link accounting data with the * user data for views where
> they are both required.
> 
> We also use mysql for cdr for billing purposes.
> 
> I was much more comfortable with .net ms sql, but the transition and
> integration with mysql was easy. Just store the asterisk specific data
> in mysql, everthing else in ms sql if you must.
> 
> 
> 
> 
> 
> 
> 
> > -----Original Message-----
> > From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-
> > bounces@lists.digium.com] On Behalf Of Irakli Natsvlishvili
> > Sent: Tuesday, June 14, 2005 12:04 AM
> > To: 'Shamsul Arefin'; 'Asterisk Users Mailing List -
Non-Commercial
> > Discussion'
> > Subject: RE: [Asterisk-Users] Keeping users, extensions,voicemail
and
> so
> > on in DB
> >
> > Could you go with some details? What was better performance,
> stability?
> > All our user info is in MS SQL and we have billing based on it, so
it
> > won't
> > be easy to move to mysql.
> >
> > I.N.
> > -----Original Message-----
> > From: asterisk-users-bounces@lists.digium.com
> > [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of
Shamsul
> > Arefin
> > Sent: Monday, June 13, 2005 10:36 PM
> > To: Asterisk Users Mailing List - Non-Commercial Discussion
> > Subject: Re: [Asterisk-Users] Keeping users, extensions,voicemail
and
> so
> > on
> > in DB
> >
> > Yes it is now possible to store configuration files in database, via
> > Mysql support or via ODBC. But we have find that Mysql is works much
> > better.
> >
> > regards
> > shams
> >
> > On 6/14/05, Irakli Natsvlishvili <iraklin@gmail.com> wrote:
> > > Hello,
> > >
> > > I have one question regarding *. Default configuration for
asterisk
> is
> > to
> > > keep configuration(s) in ordinary text based config files.
> > >
> > > My question is simple: is it possible to keep those config info
(at
> > least,
> > > to start from - sip.conf, extensions.conf and voicemail.conf) on
a
> > database,
> > > which asterisk access via ODBC. If it is possible, I'd
appreciate
if
> > someone
> > > points me where I can read more about it and shows me some
examples.
> > Also
> > > I'd like to know, how asterisk behaves (in terms of stability
and
> > > performance) in this environment.
> > >
> > >
> > > I.N.
> > >
> > > _______________________________________________
> > > Asterisk-Users mailing list
> > > Asterisk-Users@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
> > >
> >
> >
> > --
> > Best Regards
> > Shamsul Arefin
> > Saktek Technologies
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users@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@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@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@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