Hello,
On 14.10.24 17:55, marek via sr-users wrote:
hi,
i'm trying setup kamailio for simple CDR logging
versions - kamailio 5.7, rocky 9.4
i have configured and populate sqlite with "kamdbctl create"
kamailio.cfg
#CDR
loadmodule "db_sqlite.so"
loadmodule "acc.so"
modparam("acc", "cdr_enable", 1)
modparam("acc", "db_flag", 1)
modparam("acc", "db_missed_flag", 2)
modparam("acc", "db_url",
"sqlite:///var/log/kamailio-cdr.sqlite")
modparam("acc", "time_mode", 3)
but i have this error
ERROR: db_sqlite [dbase.c:232]: db_sqlite_submit_query(): failed to
prepare statement: table acc has no column named time_attr
any ideas where can i find acc schema update for time_attr column?
bash# grep -Rni time_attr /usr/share/kamailio/db_sqlite/ shows nothing
you have to add the column, depending on mode it has to be a different
type for it, see:
-
https://www.kamailio.org/docs/modules/stable/modules/acc.html#acc.p.time_at…
Cheers,
Daniel
--
Daniel-Constantin Mierla (@
asipto.com)
twitter.com/miconda --
linkedin.com/in/miconda
Kamailio Consultancy, Training and Development Services --
asipto.com