MikoPBX
Модули
Перевод этой страницы:
MikoPBX
Модули
mkdir -p /usr/src/miko-mysql-to-sqlite; cd /usr/src/miko-mysql-to-sqlite
curl 'https://gist.githubusercontent.com/esperlu/943776/raw/be469f0a0ab8962350f3c5ebe8459218b915f817/mysql2sqlite.sh' -o 'mysql2sqlite.sh'
./mysql2sqlite.sh -ufreepbxuser -p123 asteriskcdrdb PT1C_cdr | grep -v 'CREATE INDEX' | sqlite3 ./master.db
mkdir -p /storage/usbdisk1/mikopbx/freepbx-dmp; cd /storage/usbdisk1/mikopbx/freepbx-dmp;
sqlite3 master.db 'SELECT strftime("%Y/%m/%d/", calldate) || recordingfile FROM PT1C_cdr WHERE recordingfile<>"" AND calldate > "2020-02-07"' > file-for-download.txt
curl 'http://files.miko.ru/s/zYyMAyhpqtLZ7Qf/download' -o ./download-and-convert.sh sh ./download-and-convert.sh file-for-download.txt 10.70.10.6:443
cp /storage/usbdisk1/mikopbx/astlogs/asterisk/cdr.db /storage/usbdisk1/mikopbx/astlogs/asterisk/cdr.db.dmp
cp /storage/usbdisk1/mikopbx/astlogs/asterisk/cdr.db ./cdr.db
sqlite3 << EOF ATTACH DATABASE 'cdr.db' as 'new'; ATTACH DATABASE 'master.db' as 'old'; delete from new.cdr_general; INSERT INTO new.cdr_general ( src_num, dst_num, src_chan, dst_chan, start, answer, endtime, duration, billsec, disposition, UNIQUEID, did, linkedid, recordingfile ) SELECT src, dst, channel, dstchannel, calldate, answer, "end", duration, billsec, disposition, linkedid || id, did, linkedid, "/storage/usbdisk1/mikopbx/voicemailarchive/monitor/" || strftime("%Y/%m/%d/", calldate) || recordingfile || ".mp3" FROM old.PT1C_cdr; DETACH DATABASE 'new'; DETACH DATABASE 'old'; .exit EOF
sqlite3 ./cdr.db 'UPDATE cdr_general SET recordingfile="" where recordingfile LIKE "%/.mp3"'
sqlite3 ./cdr.db 'UPDATE cdr_general SET recordingfile="" where start<"2020-02-07"'
cp ./cdr.db /storage/usbdisk1/mikopbx/astlogs/asterisk/cdr.db