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
