[OpenSIPS-Devel] [ opensips-Bugs-2844970 ] is_user_in does not seem to be working in trunk

[SourceForge.net]

Bugs item #2844970, was opened at 2009-08-26 11:45
Message generated for change (Comment added) made by flaviogoncalves
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2844970&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Flavio Goncalves (flaviogoncalves)
Assigned to: Irina-Maria Stanescu (ironmissy)
Summary: is_user_in does not seem to be working in trunk

Initial Comment:
Examples from 1.5 are not running in 1.6 after migration. I can't see any database access in mysql.log when using the function is_user_in("credentials", "local"). I tried db_is_user_in too. 

----------------------------------------------------------------------

>Comment By: Flavio Goncalves (flaviogoncalves)
Date: 2009-08-27 16:05

Message:
Verified Ok. It is working now. 

Thanks, 

----------------------------------------------------------------------

Comment By: Irina-Maria Stanescu (ironmissy)
Date: 2009-08-27 10:06

Message:
Indeed, it was a bug at a fixup function. Please update and try again.

----------------------------------------------------------------------

Comment By: Flavio Goncalves (flaviogoncalves)
Date: 2009-08-26 16:38

Message:
Hi Bogdan, 

Below is the relevant configuration in the file. 

# ----- group parameters ---- #
modparam("group", "use_domain", 1)
modparam("group", "table", "grp")
modparam("group", "db_url",
"mysql://opensips:opensipsrw@localhost/opensips")

 if (db_is_user_in("credentials","local")) {
                        prefix("1305");
                        route(4);
                        exit;
                } else {
                        send_reply("403", "No permission for local
calls");
                        exit;
                };

Yes, seems to be a bug. The strange thing is that I don't see any query to
the database in the mysql.log.

Flavio

----------------------------------------------------------------------

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-08-26 16:11

Message:
I see...I guess you configured the db_url param for the group module ? If
yes and still not working, I'm reassigning the bug to Irina who made the
AAA RADIUS changes.

----------------------------------------------------------------------

Comment By: Flavio Goncalves (flaviogoncalves)
Date: 2009-08-26 14:24

Message:
I'had already tried using db_is_user_in(), but it is not working for me. I
read the documents and migrated the script, but I couldn't spot any error
even with debug=9 and mysql.log. What I've tried:

Recreate the database with the new schema, 
log with debug=9
log with mysql.log
db_is_user_in
is_user_in
multidomain and singledomain


----------------------------------------------------------------------

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-08-26 13:23

Message:
Hi Flavio,

There were some changes due the new AAA API . See:
     http://www.opensips.org/Main/News0038  
     http://www.opensips.org/Main/Ver160#toc16
     http://www.opensips.org/html/docs/modules/devel/group.html

is_user_in() - > db_is_user_in()

Regards,
Bogdan

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2844970&group_id=232389