[SR-Users] syncing db_text acc table

Tue Dec 13 20:40:49 CET 2011

Hello,

db_text keeps data in memory, the main reason being updates of the 
records, which will be hard to sync to disk in a text file every time, 
considering multi-process architecture of kamailio.

Perhaps you should look at db_flatstore for a need of storing acc record 
to text files. Other alternative of not using a sql server, is db_sqlite.

Cheers,
Daniel

On 12/13/11 6:56 PM, Pedro Antonio Vico Solano wrote:
> Hello Carsten, How are you?
>
> I've tried to disable caching (modparam("db_text", "db_mode", 1) but 
> it remains the same. I've read the module README file and it seems 
> that it is not implemented:
>
> /[..] NOTE: even when is in non-caching mode, the module does not 
> write back to hard drive after changes. In this mode, the module 
> checks if the corresponding file on disk has changed, and reloads it. 
> The write on disk happens at openser shut down. [..]/
>
> Do you know any alternative?
>
> BR,
> Pedro
>
>
>
> De: Carsten Bock <carsten at ng-voice.com>
> Para: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - 
> Users        Mailing List" <sr-users at lists.sip-router.org>
> Fecha: 13/12/2011 18:08
> Asunto: Re: [SR-Users] syncing db_text acc table
> Enviado por: sr-users-bounces at lists.sip-router.org
> ------------------------------------------------------------------------
>
>
>
> Hi Pedro,
>
> You need to disable the caching mode in db_text, see here:
> http://kamailio.org/docs/modules/devel/modules_k/db_text.html#id2530805
>
> Kind regards from Hamburg,
> Carsten
>
> 2011/12/13 Pedro Antonio Vico Solano <pvsolano at amper.es>:
> > Hello,
> >
> > I'm using Kamailio 3.1.5 with db_text module. I'm trying to save 
> accounting
> > information on the acc file. Everything seems to work fine but 
> accounting
> > records are only written on the file when Kamailio program shutdowns.
> >
> > usrloc tables have a configuration parameter for persistent storage mode
> > (modparam("usrloc", "db_mode", 1))
> >
> > How can I get the same  behaviour on acc table?
> >
> > Thanks.
> > 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 <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/
>
> _______________________________________________
> 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
>
>
> 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

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20111213/137f09b5/attachment.htm>