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

[Sergio Gutierrez]

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.4opensips_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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090306/7489c8a9/attachment-0001.htm