<br>Hi Robert.<br><br>Please update again from branch (stable version)<br><br>Regards.<br><br>Sergio.<br><br><div class="gmail_quote">On Fri, Mar 6, 2009 at 2:46 AM, Robert Borz <span dir="ltr"><<a href="mailto:robert.borz@web.de">robert.borz@web.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Sergio,<br>
<br>
I just checked out the current svn version. But the problem still exists. Here's my module configuration:<br>
<br>
loadmodule "uri_db.so"<br>
modparam("uri_db", "db_url", "postgres://opensips:********@*********/opensips_1_4")<br>
<div class="im">modparam("uri_db", "use_uri_table", 1)<br>
</div>modparam("uri_db", "use_domain", 0)<br>
<br>
And here's the output generated with debug 5:<br>
<br>
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 9 chars, out: 9 chars<br>
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 10 chars, out: 10 chars<br>
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 12 chars, out: 12 chars<br>
DBG:db_postgres:db_postgres_submit_query: 0x74c578 PQsendQuery(select username from subscriber where username='sip/10000' AND domain='**********' AND uri_user='************')<br>
DBG:core:db_new_result: allocate 48 bytes for result set at 0x74da00<br>
DBG:db_postgres:db_postgres_store_result: 0x74c578 PQresultStatus(PGRES_FATAL_ERROR) PQgetResult(0x84ba20)<br>
ERROR:db_postgres:db_postgres_store_result: 0x74c578 - invalid query, execution aborted<br>
ERROR:db_postgres:db_postgres_store_result: 0x74c578: PGRES_FATAL_ERROR<br>
ERROR:db_postgres:db_postgres_store_result: 0x74c578: ERROR: column "uri_user" does not exist#012LINE 1: ... username='*********' AND domain='**********' AND uri_user='...#012 ^#012<br>
DBG:core:db_free_columns: freeing 0 columns<br>
DBG:core:db_free_rows: freeing 0 rows<br>
DBG:core:db_free_result: freeing result set at 0x74da00<br>
DBG:db_postgres:free_query: PQclear(0x84ba20) result set<br>
ERROR:core:db_do_query: error while storing result<br>
ERROR:uri_db:check_username: Error while querying database<br>
<br>
<br>
Regards,<br>
Robert.<br>
<br>
<br>
________________________________________<br>
From: <a href="mailto:saguti@gmail.com">saguti@gmail.com</a> [mailto:<a href="mailto:saguti@gmail.com">saguti@gmail.com</a>]<br>
Sent: Thursday, March 05, 2009 8:52 PM<br>
<div class="im">To: <a href="mailto:robert.borz@web.de">robert.borz@web.de</a><br>
</div><div><div></div><div class="h5">Subject: Re: [OpenSIPS-Users] Bug in uri_db module, OpenSIPS v1.4.4<br>
<br>
Hello Robert.<br>
<br>
Please, update from SVN and try again.<br>
<br>
You can download stable version by using:<br>
svn co <a href="https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.4" target="_blank">https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.4</a> opensips_1_4<br>
<br>
Please confirm us whether it works, to proceed to close your bug report.<br>
<br>
Thanks for reporting.<br>
<br>
Best regards.<br>
<br>
Sergio.<br>
<br>
<br>
On Thu, Mar 5, 2009 at 12:49 PM, Robert Borz <<a href="mailto:robert.borz@web.de">robert.borz@web.de</a>> wrote:<br>
Hi Bogdan,<br>
<br>
I filed a anonymous bug report on the new tracker.<br>
<br>
<br>
Regards,<br>
Robert.<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a> [mailto:<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>]<br>
Sent: Thursday, March 05, 2009 6:36 PM<br>
To: <a href="mailto:robert.borz@web.de">robert.borz@web.de</a><br>
Cc: <a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Subject: Re: [OpenSIPS-Users] Bug in uri_db module, OpenSIPS v1.4.4<br>
<br>
Hi Robert,<br>
<br>
Looks like a bug to me - could you please upload a new bug report on the<br>
tracker about this problem?<br>
<br>
Thanks and regards,<br>
Bogdan<br>
<br>
Robert Borz wrote:<br>
> Allright, just my mistake? Just trying to convert my current OpenSER configuration.<br>
><br>
> Adding the additional parameter<br>
> modparam("uri_db", "db_table", "uri")<br>
> fixed this issue.<br>
><br>
><br>
> Sorry...<br>
><br>
><br>
> Robert.<br>
><br>
> -----Original Message-----<br>
> From: Robert Borz [mailto:<a href="mailto:robert.borz@web.de">robert.borz@web.de</a>]<br>
> Sent: Thursday, March 05, 2009 6:12 PM<br>
> To: '<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>'<br>
> Subject: Bug in uri_db module, OpenSIPS v1.4.4<br>
><br>
> I just tried using the uri_db module together with db_postgres module:<br>
><br>
> loadmodule "uri_db.so"<br>
> modparam("uri_db", "use_uri_table", 1)<br>
><br>
> Does not use the "uri" table and tries looking up the user still in the subscriber table.<br>
><br>
> Relevant output with debug level 5:<br>
> DBG:db_postgres:db_postgres_submit_query: 0x74c8e8 PQsendQuery(select username from subscriber where username='*********' AND domain='*******.de' AND uri_user='************')<br>
><br>
> The docs say, that use_uri_table has to be set to another value than 0, which means true. Seems not to work right now...<br>
><br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
><br>
<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
<br>
--<br>
Sergio Gutiérrez<br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Sergio Gutiérrez<br>