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

[Francisco Cuellar]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20040714/705e81cc/attachment.htm>