[Serusers] does_uri_exist does not find user in subscriber db?

[Francisco Cuellar]

Hello,
Is there something I am missing? Do I somehow have the wrong version of URI
module? please help!
Francisco

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
Behalf Of Francisco Cuellar
Sent: Thursday, July 15, 2004 2:09 AM
To: Jan Janak; cisco at ifreedomcom.com
Cc: serusers at lists.iptel.org
Subject: RE: [Serusers] does_uri_exist does not find user in subscriber db?


Hello Jan,
and thanks for the quick reply, I tried what you suggested and here is what
I got

Jul 15 00:43:36 sip ser: ser shutdown succeeded
Jul 15 00:43:37 sip ser: set_mod_param_regex: parameter <use_domain> not
found in module <uri>
Jul 15 00:43:37 sip ser: parse error (101,32-33): Can't set module parameter
Jul 15 00:43:37 sip ser: ERROR: bad config file (1 errors)
Jul 15 00:43:37 sip ser: ser startup failed

any ideas? I don't see use_domain in uri README

Francisco

-----Original Message-----
From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
Behalf Of Jan Janak
Sent: Wednesday, July 14, 2004 11:53 PM
To: cisco at ifreedomcom.com
Cc: serusers at lists.iptel.org
Subject: Re: [Serusers] does_uri_exist does not find user in subscriber db?


My quick guess is that the domain part of the Request-URI does not match
the domain in subscriber table. Try to set the following:

modparam("uri", "use_domain", 0)

that would disable domain matching, or compare the domain part of the
Request-URI of the SIP message to the domain in subscriber table to see if
they are the same.

  Jan.

On 14-07 16:46, Francisco Cuellar wrote:
> Hello all,
>
> I've been having trouble with does_uri_exist function in uri module..for
> some reason it does not see the username in the subscriber table..
> am running ser-0.8.12 stable,
> checks.c file where function does_uri_exist resides in uri directory of
Ser
> source is $Id: checks.c,v 1.10 2003/04/28 22:08:03 janakj Exp $
>
> here are the options I'm loading for uri module
>
> modparam("uri", "db_url", "mysql://seruser:serpasswd@localhost/ser")
> modparam("uri", "subscriber_table", "subscriber")
> modparam("uri", "uri_table", "uri")
> modparam("uri", "uri_user_column", "username")
> modparam("uri", "uri_domain_column", "domain")
> modparam("uri", "uri_uriuser_column", "uri_user")
> modparam("uri", "subscriber_user_column", "username")
> modparam("uri", "subscriber_domain_column", "domain")
>
> this is the part on ser.cfg where I am trying to apply does_uri_exist
>
>   if (!lookup("location")) {
>                 log(1, "LOG:USRLOC request not found\n");
>                 if (does_uri_exist()) {
>                         log(1, "LOG:URI Exists\n");
>                         if (is_user_in("Request-URI", "voicemail")) {
>                                 rewritehostport("192.168.10.10:5090");
>                                 log(1, "LOG:USRLOC request not found,VM
> set,relay to VM\n");
>                                 if (!t_relay()) {
>                                         sl_reply_error();
>                                         break;
>                                 };
>                         break;
>                         };
>                 };
>         };
>
> I know that the username is in the subscriber table username 4500
>
> when I check the mysql db I get
> mysql> select * from subscriber where username=4500;
>
> | phplib_id                        | username | domain              |
> password |
>  first_name | last_name | phone | email_address            |
> datetime_created
>  | datetime_modified   | confirmation | flag | sendnotification | greeting
|
> ha1
>                               | ha1b                             | perms |
> allow
> _find | timezone |
> ------+----------+
> | c493919a77f0c3e2671dce9048a78cce | 4500     | sip.mydomain.com| 4500
|
>             |           |       | 4500 at sip.mydomain.com| 2004-06-25
00:32:27
>  | 0000-00-00 00:00:00 |              | o    |                  |
|
> c49
> 3919a77f0c3e2671dce9048a78cce | 643bfb0b11229b401fc32c4af1b538d4 | NULL  |
0
>       | NULL     |
>
+----------------------------------+----------+---------------------+-------
> ---+
>
> but while running debug during a call to 4500 which is not in location db
> but is in subscriber table i get
>
>  0(20262) lookup(): '4500' Not found in usrloc
>  0(20262) LOG:USRLOC request not found
>  0(20262) does_uri_exit(): User in request uri does not exist
>  0(20262) LOG: Called not in location DB/n 0(20262) parse_headers:
> flags=16384
>
> Is there something missing in my script that is needed by does_uri_exist?
>
> I really appreciate any help pointing me in the right direction
>
> Thanks
> Francisco

> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers