[SR-Users] sqlite errors

[nadie]

-----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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)

iQIcBAEBAgAGBQJWLnRoAAoJEG5DH1ilMeee+P8P/A3/YiDqiA2VsZR3GvTtAYgh
5XjGBI9MptT2IuLPe3FMnuOtKPGBkKIlcUpW8EmAvV37wVooHl0ZyF4/Ap+izgMm
G8PeoOhgQ0jaY+j+p/KVK3OpN3uQprH/F+H0o5ljHi2R9oYE/FFVv8/A+mGcAztD
KEmqSq9HNqcCn+4p+qB5yMM+nmi9vCGWFlPiMIInQ7YOIWLCkJJCjkeGgjKgQzJw
tAYRJkoytmpTbUxTw7bwPYniQee7ATfXaMhslLU0bIGIleFjuElcC32NoBs6KZKW
jYAWjMMwuVtyMxjkLq29q46/Me/D7PIbIBuxxoPUho9OKCjEN3ob2K3GRvJf6d5j
p0uNYCNY6nsftdO3UzZE1+xz9NqXvpmO+oOcWw/J9N+5/vMEOorwwvmoD5JX4LSn
7jqXkeGvGoqiwPkquLEYfTWB0hOZJyDRHJWej9WBTPF063seLvaX5OFRXjuvOIHd
D6fmG4vxMTB0VpANxQQuf73HA0hlYZ5WzvjoNT8cc259uWY8OPiuLcIuOfHtBphk
xlttHbTnozCvCJVP4W0OLDZHwPR3AuOdBhtjOM+kIsUwzMVlVA5/Drqai/EDsX4/
tzVPHKNneBU98jPtNTmFQqWnT2sGnZeNYBO/HdcZYNGFsJ993WCQvVAZZ/0OwL+J
hV3EXhaP/KqeZRtHjwFN
=x7Zq
-----END PGP SIGNATURE-----