Cdr_sqlite3

Home » Asterisk Users » Cdr_sqlite3
Asterisk Users 5 Comments

Hello,

I am using cdr_sqlite3_custom and the file is automatically saved as:

/var/log/asterisk/master.db

how can I change the location ?

If this is not possible to change in the config file, where in the source code would I change that?

I am using asterisk 16.

thanks,

5 thoughts on - Cdr_sqlite3

  • T24gU2F0LCBNYXIgNCwgMjAyMyBhdCAxOjI5IFBNLCBGb3VyaHVuZHJlZCBUaGVjYXQgPDQwMHRo ZWNhdEBnbXguY2g+IHdyb3RlOgoKPiAvdmFyL2xvZy9hc3Rlcmlzay9tYXN0ZXIuZGIKPgo+IGhv dyBjYW4gSSBjaGFuZ2UgdGhlIGxvY2F0aW9uID8KPgo+IElmIHRoaXMgaXMgbm90IHBvc3NpYmxl IHRvIGNoYW5nZSBpbiB0aGUgY29uZmlnIGZpbGUsIHdoZXJlIGluIHRoZQo+IHNvdXJjZSBjb2Rl IHdvdWxkIEkgY2hhbmdlIHRoYXQ/CgpjZHIvY2RyX3NxbGl0ZTNfY3VzdG9tLmMgbGluZSAzMTEK
    CktpbmQgcmVnYXJkcywKU2Vhbg=

  • > >
    > cdr/cdr_sqlite3_custom.c line 311

    Hello,

    I asked here recently how to change the location where
    “cdr_sqlite3_custom” stores the sqlite database. The default is location is “astlogdir”.

    I need to change this location without affecting the rest of the asterisk logs.

    Sean Bright suggested to patch cdr/cdr_sqlite3_custom.c

    But I cannot hard-code the path either.

    How could I create new custom configuration variable, perhaps
    “cdrlogdir”, that I could then assign in asterisk.conf ?

    Can this be done easily by patching few lines somewhere?

    thanks,

  • Something like the following:

    https://gist.github.com/seanbright/f8331df57aacdd06b6d391dfec2f59c6

    This adds a new ‘filename’ option that you would provide in
    /etc/asterisk/cdr_sqlite3_custom.conf like:

    [master]
    ; A non-absolute path will be relative to Asterisk’s log
    ; directory filename = testing.db

    Or:

    [master]
    filename = /full/path/to/testing.db

    This patch does not support module reload, so once the filename is set you would have to unload and load the module or restart Asterisk if you wanted to change the path to the database file.

    To apply:

    $ cd /path/to/source/code/of/asterisk
    $ curl https://gist.githubusercontent.com/seanbright/f8331df57aacdd06b6d391dfec2f59c6/raw/693f7027440b07d1122283d4d750051f8acbbe94/gistfile0.txt | patch -p1
    $ make && sudo make install

    Kind regards, Sean