<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=531253022-14072004>Hello
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=531253022-14072004></SPAN></FONT> </DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2>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..</FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2>am running
ser-0.8.12 stable, </FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2>checks.c file where
function does_uri_exist resides in uri directory of Ser source is
</FONT></SPAN><SPAN class=531253022-14072004><FONT face=Arial size=2>$Id:
checks.c,v 1.10 2003/04/28 22:08:03 janakj Exp $<BR></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2><U><EM>here are the
options I'm loading for uri module</EM></U></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><EM><U><FONT face=Arial
size=2></FONT></U></EM></SPAN> </DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2>modparam("uri",
"db_url", "mysql://seruser:serpasswd@localhost/ser")<BR>modparam("uri",
"subscriber_table", "subscriber")<BR>modparam("uri", "uri_table",
"uri")<BR>modparam("uri", "uri_user_column", "username")<BR>modparam("uri",
"uri_domain_column", "domain")<BR>modparam("uri", "uri_uriuser_column",
"uri_user")<BR>modparam("uri", "subscriber_user_column",
"username")<BR>modparam("uri", "subscriber_domain_column",
"domain")<BR></FONT></SPAN><SPAN class=531253022-14072004><FONT face=Arial
size=2></DIV></FONT></SPAN>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2><EM><U>this is the
part on ser.cfg where I am trying to apply</U>
does_uri_exist</EM></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2> if
(!lookup("location"))
{<BR>
log(1, "LOG:USRLOC request not
found\n");<BR>
if (does_uri_exist())
{<BR>
log(1, "LOG:URI
Exists\n");<BR>
if (is_user_in("Request-URI", "voicemail"))
{<BR>
rewritehostport("192.168.10.10:5090");<BR>
log(1, "LOG:USRLOC request not found,VM set,relay to
VM\n");<BR>
if (!t_relay())
{<BR>
sl_reply_error();<BR>
break;<BR>
};<BR>
break;<BR>
};<BR>
};<BR> };<BR></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2><U><EM>I know that
the username is in the subscriber table</EM></U> <EM>username
4500</EM></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2><EM><U>when I check
the mysql db I get</U></EM></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2><EM><U>mysql>
select * from subscriber where username=4500;</U></EM></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2>|
phplib_id
| username |
domain
| password |<BR> first_name | last_name | phone |
email_address
| datetime_created<BR> | datetime_modified | confirmation |
flag | sendnotification | greeting |
ha1<BR>
|
ha1b
| perms | allow<BR>_find | timezone |<BR>------+----------+<BR>|
c493919a77f0c3e2671dce9048a78cce | 4500 |
sip.mydomain.com| 4500
|<BR>
|
| | <A
href="mailto:4500@sip.mydomain.com">4500@sip.mydomain.com</A>| 2004-06-25
00:32:27<BR> | 0000-00-00 00:00:00
|
| o
|
| |
c49<BR>3919a77f0c3e2671dce9048a78cce | 643bfb0b11229b401fc32c4af1b538d4 |
NULL | 0<BR> | NULL
|<BR>+----------------------------------+----------+---------------------+----------+<BR></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2><U><EM>but while
running debug during a call to 4500 which is not in location db but is
in subscriber table i get</EM></U></FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial size=2> 0(20262)
lookup(): '4500' Not found in usrloc<BR> 0(20262) LOG:USRLOC request not
found<BR> 0(20262) does_uri_exit(): User in request uri does not
exist<BR> 0(20262) LOG: Called not in location DB/n 0(20262) parse_headers:
flags=16384</FONT></SPAN></DIV>
<DIV><SPAN class=531253022-14072004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=531253022-14072004></SPAN><SPAN
class=531253022-14072004>Is there something missing in my script that is needed
by does_uri_exist?</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=531253022-14072004></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=531253022-14072004>I really
appreciate any help pointing me in the right
direction</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=531253022-14072004></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=531253022-14072004>Thanks</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=531253022-14072004>Francisco</DIV></SPAN></FONT></FONT></BODY></HTML>