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@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