Hi Robert. Please update again from branch (stable version)
Regards. Sergio. On Fri, Mar 6, 2009 at 2:46 AM, Robert Borz <[email protected]> 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: [email protected] [mailto:[email protected]] > Sent: Thursday, March 05, 2009 8:52 PM > To: [email protected] > 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 <[email protected]> wrote: > Hi Bogdan, > > I filed a anonymous bug report on the new tracker. > > > Regards, > Robert. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Thursday, March 05, 2009 6:36 PM > To: [email protected] > Cc: [email protected] > 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:[email protected]] > > Sent: Thursday, March 05, 2009 6:12 PM > > To: '[email protected]' > > 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 > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > -- > Sergio Gutiérrez > > -- Sergio Gutiérrez
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
