thank you Daniel

for the record for modparam("acc", "time_mode", 3)

ALTER TABLE acc ADD COLUMN time_attr varchar(128);

Marek

Dne 2024-10-14 v 18:04 Daniel-Constantin Mierla napsal(a):

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_att...

Cheers, Daniel