[asterisk-users] CDR_TDS driver disappears - "does not provide a license key" on reload attempt

[Mitch Sharp]

You should be able to handle that with CDR via ODBC and use Microsoft's
recently released ODBC drivers. The should bypass all this FreeTDS stuff
and just use straight ODBC.

On Fri, Nov 10, 2017 at 7:55 AM, J Montoya <asterisk_list at earthshod.co.uk>
wrote:

> On Friday 10 Nov 2017, Stefan Viljoen wrote:
> > Hi All
> >
> > I have an Asterisk 1.8.32.3 instance that will at random intervals stop
> > logging CDR data to MSSQL via FreeTDS.
> >
> > On investigation I'll find that the FreeTDS module has been unloaded
> > somehow. It is not listed in cdr show status or show module like.
> >
> > Trying
> > module load cdr_tds
> > results in
> > module cdr_tds does not provide a license key
> > and the module is not loaded.
> > .....  stuff deleted  .....
> > I have this on multiple sites very far apart, different hardware,
> asterisk
> > instances compiled at widely varying times.
> >
> > Anybody encountered this before?
>
> The solution is to avoid proprietary software!
>
> Asterisk's CDRs simply do not need any of the special proprietary crack
> that
> comes with MSSQL or Oracle.  MariaDB or SQLite is perfectly adequate for
> its
> needs  (hell, a flat text file will do the job).
>
> If you *really* need your CDRs in an MSSQL database, you could use MariaDB
> as
> an intermediate layer with binary logging enabled; and then use a few
> lines of
> Perl or Python to translate the binlog from MariaDB's SQL dialect to
> Microsoft's.
>
>
> --
> JM or AJS
>
> Note:  Originating address only accepts e-mail from list!  If replying off-
> list, change address to asterisk1list at earthshod dot co dot uk .
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at: https://community.asterisk.
> org/
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20171110/ed355e9d/attachment.html>