[SR-Users] sqlite -> usrloc tables deleted after 1 minute

[Carsten Bock]

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 at 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 at 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 at 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!