[Asterisk-Users] Keeping users, extensions, voicemail and so on in DB

[Damon Estep]

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 at lists.digium.com [mailto:asterisk-users-
> bounces at 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 at lists.digium.com
> [mailto:asterisk-users-bounces at 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 at lists.digium.com
[mailto:asterisk-users-
> > bounces at 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 at lists.digium.com
> > [mailto:asterisk-users-bounces at 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 at 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 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
> > >
> >
> >
> > --
> > Best Regards
> > Shamsul Arefin
> > Saktek Technologies
> > _______________________________________________
> > 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
> _______________________________________________
> 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