He'll be starting Monday, let see what happens
ALL: sqlite3 /var/log/asterisk/master.db "select * from cdr"
DATE: sqlite3 /var/log/asterisk/master.db "select * from cdr where calldate >= '2016-05-22'"
NPA: sqlite3 /var/log/asterisk/master.db "SELECT * from cdr WHERE clid LIKE '%<843%'"
DEST: sqlite3 /var/log/asterisk/master.db "SELECT * from cdr WHERE dstchannel LIKE '%411%'"
FLDS: sqlite3 /var/log/asterisk/master.db "PRAGMA table_info(cdr)"
How do I get this update?
If you want to use an existing Incredible PBX XiVO server, do the following:OK, it says "Incredible PBX is already installed."
what next
cd /etc/asterisk
mv cdr_sqlite3_custom.conf cdr_sqlite3_custom.old.conf
echo "[master]" > cdr_sqlite3_custom.conf
echo "table = cdr" >> cdr_sqlite3_custom.conf
echo "columns => calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, accountcode, uniqueid, userfield, did, recordingfile, cnum, cnam, outbound_cnum, outbound_cnam, dst_cnam" >> cdr_sqlite3_custom.conf
echo "values => '\${CDR(start)}','\${CDR(clid)}','\${CDR(src)}','\${CDR(dst)}','\${CDR(dcontext)}','\${CDR(channel)}', '\${CDR(dstchannel)}','\${CDR(lastapp)}','\${CDR(lastdata)}','\${CDR(duration)}', '\${CDR(billsec)}','\${CDR(disposition)}','\${CDR(amaflags)}', '\${CDR(accountcode)}','\${CDR(uniqueid)}','\${CDR(userfield)}','\${CDR(did)}','\${CDR(recordingfile)}','\${CDR(cnum)}','\${CDR(cnam)}','\${CDR(outbound_cnum)}','\${CDR(outbound_cnam)}','\${CDR(dst_cnam)}'" >> cdr_sqlite3_custom.conf
chown asterisk:www-data cdr_sqlite3_custom.conf
chmod 660 cdr_sqlite3_custom.conf
mv /var/log/asterisk/master.db /var/log/asterisk/master.old.db
touch /var/log/asterisk/master.db
chown asterisk:asterisk /var/log/asterisk/master.db
chmod 640 /var/log/asterisk/master.db
/etc/init.d/asterisk restart
Ward, if someone download/install from http://nerdvittles.com/?p=18734 instructions NOW, will the above change be included?
Link up your team and customers Phone System Live Chat Video Conferencing
Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.
Check your inbox!
We’ve sent you an email. Click on the button in the email body to verify your email address – (if you can not find it, check your spam folder).
Upon verification you will be directed to the 3CX setup wizard.