-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hello, sorry for the question. Kamailio 4.3.3, debian Jessie:
Kamailio with sqlite all work correctly
but syslog tells:
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: usrloc [urecord.c:418]: wb_timer(): inserting contact into database failed (aor: 17)
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: db_sqlite [dbase.c:489]: db_sqlite_commit(): sqlite commit failed: attempt to write a readonly database
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: db_sqlite [dbase.c:138]: db_sqlite_cleanup_query(): finalize failed: attempt to write a readonly database
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: usrloc [urecord.c:418]: wb_timer(): inserting contact into database failed (aor: 50)
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: db_sqlite [dbase.c:489]: db_sqlite_commit(): sqlite commit failed: attempt to write a readonly database
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: db_sqlite [dbase.c:138]: db_sqlite_cleanup_query(): finalize failed: attempt to write a readonly database
Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: usrloc [ucontact.c:683]: db_insert_ucontact(): inserting contact in db failed Oct 26 19:36:01 voip /usr/sbin/kamailio[2643]: ERROR: usrloc [urecord.c:418]: wb_timer(): inserting contact into database failed (aor: 59)
kamailio.cfg
#!KAMAILIO #!define WITH_SQLITE #!define WITH_AUTH #!define WITH_USRLOCDB #!define WITH_NAT #!define WITH_TLS
.....
#!ifdef WITH_SQLITE loadmodule "db_sqlite.so" #!endif
......
#!ifdef WITH_SQLITE modparam("auth_db", "db_url", "sqlite:///home/kami/app/kamailio.sqlite") #!define DBURL "sqlite:///home/kami/app/kamailio.sqlite" #!endif
............
# ----- usrloc params ----- /* enable DB persistency for location entries */ #!ifdef WITH_USRLOCDB modparam("usrloc", "db_url", DBURL) modparam("usrloc", "db_mode", 2) modparam("usrloc", "use_domain", MULTIDOMAIN) #!endif
Thanks