[OpenSIPS-Users] Bug in uri_db module, OpenSIPS v1.4.4

[Robert Borz]

Hi Sergio,

I fetched opensips_1_4 from 1.4 branch from svn and now it does as expected. Great work! Thank you. :-)


Regards,
Robert

________________________________________
From: saguti at gmail.com [mailto:saguti at gmail.com] 
Sent: Friday, March 06, 2009 4:13 PM
To: robert.borz at web.de
Cc: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] Bug in uri_db module, OpenSIPS v1.4.4


Hi Robert.

Please update again from branch (stable version)

Regards.

Sergio.
On Fri, Mar 6, 2009 at 2:46 AM, Robert Borz <robert.borz at web.de> wrote:
Hi Sergio,

I just checked out the current svn version. But the problem still exists. Here's my module configuration:

loadmodule "uri_db.so"
modparam("uri_db", "db_url", "postgres://opensips:********@*********/opensips_1_4")
modparam("uri_db", "use_uri_table", 1)
modparam("uri_db", "use_domain", 0)

And here's the output generated with debug 5:

DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 9 chars, out: 9 chars
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 10 chars, out: 10 chars
DBG:db_postgres:db_postgres_val2str: PQescapeStringConn: in: 12 chars, out: 12 chars
DBG:db_postgres:db_postgres_submit_query: 0x74c578 PQsendQuery(select username from subscriber where username='sip/10000' AND domain='**********' AND uri_user='************')
DBG:core:db_new_result: allocate 48 bytes for result set at 0x74da00
DBG:db_postgres:db_postgres_store_result: 0x74c578 PQresultStatus(PGRES_FATAL_ERROR) PQgetResult(0x84ba20)
ERROR:db_postgres:db_postgres_store_result: 0x74c578 - invalid query, execution aborted
ERROR:db_postgres:db_postgres_store_result: 0x74c578: PGRES_FATAL_ERROR
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
DBG:core:db_free_columns: freeing 0 columns
DBG:core:db_free_rows: freeing 0 rows
DBG:core:db_free_result: freeing result set at 0x74da00
DBG:db_postgres:free_query: PQclear(0x84ba20) result set
ERROR:core:db_do_query: error while storing result
ERROR:uri_db:check_username: Error while querying database


Regards,
Robert.


________________________________________
From: saguti at gmail.com [mailto:saguti at gmail.com]
Sent: Thursday, March 05, 2009 8:52 PM
To: robert.borz at web.de
Subject: Re: [OpenSIPS-Users] Bug in uri_db module, OpenSIPS v1.4.4

Hello Robert.

Please, update  from SVN and try again.

You can download stable version by using:
svn co https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.4 opensips_1_4

Please confirm us whether it works, to proceed to close your bug report.

Thanks for reporting.

Best regards.

Sergio.


On Thu, Mar 5, 2009 at 12:49 PM, Robert Borz <robert.borz at web.de> wrote:
Hi Bogdan,

I filed a anonymous bug report on the new tracker.


Regards,
Robert.

-----Original Message-----
From: bogdan at voice-system.ro [mailto:bogdan at voice-system.ro]
Sent: Thursday, March 05, 2009 6:36 PM
To: robert.borz at web.de
Cc: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] Bug in uri_db module, OpenSIPS v1.4.4

Hi Robert,

Looks like a bug to me - could you please upload a new bug report on the
tracker about this problem?

Thanks and regards,
Bogdan

Robert Borz wrote:
> Allright, just my mistake? Just trying to convert my current OpenSER configuration.
>
> Adding the additional parameter
>       modparam("uri_db", "db_table", "uri")
> fixed this issue.
>
>
> Sorry...
>
>
> Robert.
>
> -----Original Message-----
> From: Robert Borz [mailto:robert.borz at web.de]
> Sent: Thursday, March 05, 2009 6:12 PM
> To: 'users at lists.opensips.org'
> Subject: Bug in uri_db module, OpenSIPS v1.4.4
>
> I just tried using the uri_db module together with db_postgres module:
>
> loadmodule "uri_db.so"
> modparam("uri_db", "use_uri_table", 1)
>
> Does not use the "uri" table and tries looking up the user still in the subscriber table.
>
> Relevant output with debug level 5:
> DBG:db_postgres:db_postgres_submit_query: 0x74c8e8 PQsendQuery(select username from subscriber where username='*********' AND domain='*******.de' AND uri_user='************')
>
> 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...
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>



_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



--
Sergio Gutiérrez



-- 
Sergio Gutiérrez