Stefan Viljoen
2017-Nov-10 10:44 UTC
[asterisk-users] CDR_TDS driver disappears - "does not provide a license key" on reload attempt
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. The only way to get things working again is to kill Asterisk, and do a make install again. On restart, FreeTDS is back. Just replacing cdr_tds.so from a backup fails, Asterisk still won't load it. You have to replace the asterisk binary -and- the cdr_tds.so file - their sizes change as well, and a sha256sum when FreeTDS "does not provide a license key" varies for both the main asterisk binary and the cdr_tds.so module. I have this on multiple sites very far apart, different hardware, asterisk instances compiled at widely varying times. Anybody encountered this before? Thanks,
J Montoya
2017-Nov-10 13:55 UTC
[asterisk-users] CDR_TDS driver disappears - "does not provide a license key" on reload attempt
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 .
Mitch Sharp
2017-Nov-10 17:01 UTC
[asterisk-users] CDR_TDS driver disappears - "does not provide a license key" on reload attempt
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>