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(a)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