<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hello,<div><br></div><div>I filed the crash with source forge, but I don't know if it got submitted or not. I'm facing the following problems with auth_db:</div><div><br></div><div><b>1) The crash:</b> When setting load_credentials with only the column, it causes openSIPS to crash</div><div>modparam("auth_db", "load_credentials", "email_address")</div><div><br></div><div>here is the backtrace:</div><div><br></div><div><div><font class="Apple-style-span" face="Courier">#0 0x00000000004cf85d in tsl (lock=0x0) at evi/../fastlock.h:88</font></div><div><font class="Apple-style-span" face="Courier">#1 get_lock (lock=0x0) at evi/../fastlock.h:178</font></div><div><font class="Apple-style-span" face="Courier">#2 0x00000000004d11fd in lookup_avp_alias_str (name=0x7f46abfc06e8, </font></div><div><font class="Apple-style-span" face="Courier"> avp_name=0x7fff1b26c69c, extra=1) at usr_avp.c:505</font></div><div><font class="Apple-style-span" face="Courier">#3 parse_avp_spec_aux (name=0x7f46abfc06e8, avp_name=0x7fff1b26c69c, extra=1)</font></div><div><font class="Apple-style-span" face="Courier"> at usr_avp.c:566</font></div><div><font class="Apple-style-span" face="Courier">#4 0x00000000004d1403 in get_avp_id (name=0x0) at usr_avp.c:587</font></div><div><font class="Apple-style-span" face="Courier">#5 0x00007f46a7996a4a in parse_aaa_avps () at aaa_avps.h:145</font></div><div><font class="Apple-style-span" face="Courier">#6 mod_init () at authdb_mod.c:209</font></div><div><font class="Apple-style-span" face="Courier">#7 0x000000000049e034 in init_mod (m=0x7f46abfc1b30) at sr_module.c:458</font></div><div><font class="Apple-style-span" face="Courier">#8 0x000000000049dfcc in init_mod (m=0x7f46abfc1c00) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#9 0x000000000049dfcc in init_mod (m=0x7f46abfc1cd0) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#10 0x000000000049dfcc in init_mod (m=0x7f46abfc2078) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#11 0x000000000049dfcc in init_mod (m=0x7f46abfc2148) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#12 0x000000000049dfcc in init_mod (m=0x7f46abfc2218) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#13 0x000000000049dfcc in init_mod (m=0x7f46abfc22e8) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#14 0x000000000049dfcc in init_mod (m=0x7f46abfc23b8) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#15 0x000000000049dfcc in init_mod (m=0x7f46abfc2488) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#16 0x000000000049dfcc in init_mod (m=0x7f46abfc2558) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#17 0x000000000049dfcc in init_mod (m=0x7f46abfc2628) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#18 0x000000000049dfcc in init_mod (m=0x7f46abfc2be0) at sr_module.c:453</font></div><div><font class="Apple-style-span" face="Courier">#19 0x0000000000431c37 in main (argc=<value optimized out>, </font></div><div><font class="Apple-style-span" face="Courier"> argv=<value optimized out>) at main.c:1466</font></div></div><div><br></div><div><b>2) The bug:</b> The named AVPs for load_credentials works just fine with a MySQL backend however, the AVPs for load_credentials are not accessible when using PostgreSQL as a db backend. When using PostgreSQL as backend, I can see in logs that it's querying correctly and I can even see the values from DB but somehow they are not being accessible through the AVP.</div><div><br></div><div>Thank you.</div></body></html>