Re: [SR-Users] module postgres SER

2011-02-09 Thread Daniel-Constantin Mierla

Hello,

On 2/9/11 2:19 PM, Bruno Bresciani wrote:

Hi,

I've seen the problem in a postgres module (SER-0.8.1.4), if the 
connection fails and module tries to reparse url it fails as 
CON_SQLURL(_h) is corrupted by the function aug_free() after some 
reconnect attempts . When the postgres database back to work, some 
modules doesn't get reconnect because the db_url is corrupted. Why 
this is happening? There are some solution for this problem?
ser 0.8.1.4 is s old and I cannot fully remember, but I think 
postgres module had no reconnect functionality at all by that time.


However, version 3.1.x of SER (as well as Kamailio flavour) has db 
reconnect functionality for postgres. You can try it and report if 
something is not working, it will be fixed in 3.x, but I think nobody is 
still developing on 0.8.x to backport anything there.


Cheers,
Daniel

--
Daniel-Constantin Mierla
http://www.asipto.com


___
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


Re: [SR-Users] module postgres SER

2011-02-09 Thread Daniel-Constantin Mierla
please keep the mailing list cc-ed, sending private messages is not in 
the spirit of public mailing lists. Others may want to follow up the 
discussion now or later.


Thanks,
Daniel

On 2/9/11 5:01 PM, Bruno Bresciani wrote:

Daniel,

thanks for your reply, really ser-0.8.1.4 is too old but i need to 
solve this problem on that version. My great doubt is Why the aug_free 
function corrupt the url of database after some attemps to reconnect. 
Well, I'll try to understand this question...


Best Regards


2011/2/9 Daniel-Constantin Mierla mico...@gmail.com 
mailto:mico...@gmail.com


Hello,


On 2/9/11 2:19 PM, Bruno Bresciani wrote:

Hi,

I've seen the problem in a postgres module (SER-0.8.1.4), if
the connection fails and module tries to reparse url it fails
as CON_SQLURL(_h) is corrupted by the function aug_free()
after some reconnect attempts . When the postgres database
back to work, some modules doesn't get reconnect because the
db_url is corrupted. Why this is happening? There are some
solution for this problem?

ser 0.8.1.4 is s old and I cannot fully remember, but I think
postgres module had no reconnect functionality at all by that time.

However, version 3.1.x of SER (as well as Kamailio flavour) has db
reconnect functionality for postgres. You can try it and report if
something is not working, it will be fixed in 3.x, but I think
nobody is still developing on 0.8.x to backport anything there.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla

http://www.asipto.com




--
Daniel-Constantin Mierla
http://www.asipto.com

___
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