[OpenSIPS-Users] Core Dump with db_http and avp_db_query

[Andrei Dragus]

Hi,

1. Do you have a server that is prepared to respond to queries via HTTP ?
2. The avpops module uses raw queries. The db_http module has raw
queries turned off by default. You should set the following parameter if
you know your server supports raw queries:

modparam("db_http", "cap_raw_quey", 1)

Andrei



Brad Bendy wrote:
> Hi List,
>
> I wanted to test some things using the db_http driver and using 
> avp_db_query to perform db queries. This happens on 1.6.1 and 1.6.2 
> both no-tls on 32bit BSD.
>
> When we load db_http and assign the db_url for avpops to it we get a 
> core dump on startup, ive tried this:
>
> modparam("avpops","db_url","http://user:pass@localhost/db_http")
> modparam("avpops","db_url","http://user:pass@localhost")
>
> If we change the db_url to say mysql we have no issues and all works well.
>
> Backtrace shows:
>
>
> #0  0x00000000 in ?? ()
> #1  0x285b8070 in db_query_avp (url=0x81bf244, msg=0xbfbfe84c, 
> query=0x8221768 "SELECT foo FROM bar WHERE foo = bar", dest=0x8229b8c) 
> at avpops_db.c:417
> #2  0x285bacb6 in ops_dbquery_avps (msg=0xbfbfe84c, query=0x8229b40, 
> url=0x81bf244, dest=0x8229b8c) at avpops_impl.c:755
> #3  0x285b2f81 in w_dbquery_avps (msg=0xbfbfe84c, query=0x8229b40 
> "�%\034\b#", dest=0x8229b8c "\004", url=0x0) at avpops.c:1130
> #4  0x08053f56 in do_action (a=0x81c2760, msg=0xbfbfe84c) at action.c:967
> #5  0x08052920 in run_action_list (a=0x81c2760, msg=0xbfbfe84c) at 
> action.c:139
> #6  0x08057485 in run_top_route (a=0x81c2760, msg=0xbfbfe84c) at 
> action.c:119
> #7  0x080a31e2 in run_startup_route () at route.c:1867
> #8  0x0806f7c2 in main (argc=3, argv=0xbfbfec5c) at main.c:811
>
>
> I have also moved it out of the startup_route into a route block and 
> the switch then crashes as soon as a call is sent to that particular 
> route block.
>
>
> Am I just trying to use db_http wrong and my configuration is not correct?
>
> Thanks for any help
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   

-- 
Andrei Dragus
www.voice-system.ro