Hi Pedro,

did you check your expires date in your preloaded data? Kamailio will

delete it, if expires is in the past....

This is most likely your problem.

So long,

Carsten

2012/4/18 Pedro Antonio Vico Solano <pvsolano@amper.es>:

> Hello,

>

> I'm having a strange behaviour with sqlite and usrloc tables (location,

> aliases). I've created the database with kamdbctl and preloaded many
tables

> with my own data.

>

> After starting kamailio 3.2.2 (with sqlite engine) location and aliases

> tables get empty after 1 minute. It does not happen with other tables
(e.g.

> dialplan & subscriber).

>

> ul.dump command also shows empty tables.

>

> Some configuration:

>

> # -- usrloc params --

> # use sqlite database for persistent storage, write-thru

> modparam("usrloc", "db_mode", 1)

> modparam("usrloc|dialplan", "db_url", "sqlite:////etc/kamailio/db.sqlite")

>

> [Attached SQLite schema.]

>

> Can anyone help me? Thanks in advance.

> BR,

> Pedro

>

>

> ADVERTENCIA

>

> Este mensaje y/o sus anexos, pueden contener información personal
y

> confidencial cuyo uso, reproducción o distribución no autorizados
están

> legalmente prohibidos. Por lo tanto, si Vd. no fuera su destinatario
y,

> erróneamente, lo hubiera recibido, le rogamos que informe al remitente
y lo

> borre de inmediato.

>

> En cumplimiento de la Ley Orgánica 15/1999, de Protección de Datos
de

> Carácter Personal le informamos de que su dirección de correo electrónico,

> así como sus datos personales y de empresa pasarán a formar parte
de nuestro

> fichero de Gestión, y serán tratados con la única finalidad de mantenimiento

> de la relación adquirida con usted. Los datos personales que existen
en

> nuestro poder están protegidos por nuestra Política de Seguridad,
y no serán

> compartidos con ninguna otra empresa. Usted puede ejercitar los derechos
de

> acceso, rectificación, cancelación y oposición dirigiéndose por escrito
a la

> dirección arriba indicada.

>

> This e-mail and its attachments may include confidential personal

> information which may be protected by any legal rules and cannot be
used,

> copied, distributed or disclosed to any person without authorisation.
If you

> are not the intended recipient and have received this e-mail by mistake,

> please advise the sender and erase it.

>

> In compliance with the Spanish Organic Act 15/1999 on Personal Data

> Protection, we hereby inform you that your email address, as well
as your

> personal and business information, will be included in our Management
files

> and used solely for purposes corresponding to our commercial relationship.

> All personal data in our possession is protected by our Data Safety
Policy

> and thus shall not be released to any other third party whatsoever.
You may

> exercise your right to access, rectify, cancel and contest by writing
to the

> address provided above.

> _______________________________________________

> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
list

> sr-users@lists.sip-router.org

> 
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

>

-- 

Carsten Bock

CEO (Geschäftsführer)

ng-voice GmbH

Schomburgstr. 80

D-22767 Hamburg / Germany

http://www.ng-voice.com

mailto:carsten@ng-voice.com

Mobile +49 179 2021244

Office +49 40 34927219

Fax +49 40 34927220

Sitz der Gesellschaft: Hamburg

Registergericht: Amtsgericht Hamburg, HRB 120189

Geschäftsführer: Carsten Bock

Ust-ID: DE279344284

Hier finden Sie unsere handelsrechtlichen Pflichtangaben:

http://www.ng-voice.com/imprint/

-- 

Meet ng-voice at LinuxTag 2012 in Berlin - May 23rd - 26th, 2012. Save
the 

date!

_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users@lists.sip-router.org

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users