<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.6000.16788" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>I've created an user in another opensips
server and confirmed that user in the table of subscriber of
opensips database. How can I let OpenXCAP to visit the mysql of OpenSIPS
?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>The following is part of my OpenXCAP config.ini
:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>-------------------------------------------------------------------------</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>[Server]</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>address = 0.0.0.0<BR>port = 80</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>root = <A
href="http://xcap.mylab.net/xcap-root">http://xcap.mylab.net/xcap-root</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>backend = OpenSER<BR></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>[Database]</SPAN></FONT></DIV>
<DIV><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>authentication_db_uri =
mysql://root:openxcap@localhost/openxcap</SPAN></FONT></DIV>
<DIV><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>storage_db_uri =
mysql://root:openxcap@localhost/openxcap</SPAN></FONT></DIV>
<DIV><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009>subscriber_table = subscriber<BR>xcap_table =
xcap</SPAN></FONT></DIV>
<DIV><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009></SPAN></FONT><FONT face="Arial Narrow"
color=#0000ff><SPAN class=362540713-07012009><BR>[OpenSER]</SPAN></FONT><FONT
face="Arial Narrow" color=#0000ff><SPAN class=362540713-07012009><BR>xmlrpc_url
= <A
href="http://osips.mylab.net:8080">http://osips.mylab.net:8080</A></SPAN></FONT><FONT
face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009></DIV></SPAN></FONT>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009><SPAN
class=362540713-07012009>-------------------------------------------------------------------------</SPAN></DIV></SPAN></FONT>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=362540713-07012009></SPAN></FONT> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Adrian Georgescu
[mailto:ag@ag-projects.com] <BR><B>Sent:</B> 2009年1月7日 15:49<BR><B>To:</B>
Jun.Wen<BR><B>Cc:</B> users@lists.opensips.org<BR><B>Subject:</B> Re:
[OpenSIPS-Users] OpenXCAP Put 401 Unauthorized<BR></FONT><BR></DIV>
<DIV></DIV>The database is commonly shared between the two servers. So you can
create an user with opensipsctl command on the sip machine as long as OpenXCAP
is using the same database as OpenSIPS.
<DIV> </DIV>
<DIV>Adrian</DIV>
<DIV><BR>
<DIV>
<DIV>On Jan 7, 2009, at 8:29 AM, Jun.Wen wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=798262807-07012009><FONT
face="Arial Narrow" color=#0000ff>I did not install opensips with openxcap in
same server, is it a must or not ?</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Adrian Georgescu [<A
href="mailto:ag@ag-projects.com">mailto:ag@ag-projects.com</A>]
<BR><B>Sent:</B> 2009年1月7日 14:49<BR><B>To:</B> Jun.Wen<BR><B>Cc:</B> <A
href="mailto:users@lists.opensips.org">users@lists.opensips.org</A><BR><B>Subject:</B>
Re: [OpenSIPS-Users] OpenXCAP Put 401 Unauthorized<BR></FONT><BR></DIV>
<DIV></DIV>Did you try opensipsctl command?
<DIV>
<DIV>
<DIV><BR></DIV>
<DIV>Adrian</DIV>
<DIV><BR>
<DIV>
<DIV>On Jan 7, 2009, at 5:33 AM, Jun.Wen wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff>Adrian,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff>I guess my problem is I did
not successfully created users in xcap server by the scripts of "python
add-openxcap-user.py". Inside the table of <FONT color=#000000><FONT
color=#0000ff>subscriber</FONT> </FONT><FONT color=#0000ff>of mysql, there
is no any user record existed.</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff>Any tips to create user inside xcap server
?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff>Regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876582804-07012009><FONT
face="Arial Narrow" color=#0000ff>Jun</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Adrian Georgescu [<A
href="mailto:ag@ag-projects.com">mailto:ag@ag-projects.com</A>]
<BR><B>Sent:</B> 2009年1月3日 1:08<BR><B>To:</B> Jun.Wen<BR><B>Cc:</B> <A
href="mailto:users@lists.opensips.org">users@lists.opensips.org</A><BR><B>Subject:</B>
Re: [OpenSIPS-Users] OpenXCAP Put 401 Unauthorized<BR></FONT><BR></DIV>
<DIV></DIV>I do not find in your logs what is wrong with your setup, it
could be either the client or the server configuration.
<DIV><BR></DIV>
<DIV>Can you try your XCAP client using a SIP account from <A
href="http://sip2sip.info">http://sip2sip.info</A> see if that works?</DIV>
<DIV><BR></DIV>
<DIV>Regards,</DIV>
<DIV>Adrian</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>
<DIV>
<DIV>
<DIV>On Jan 2, 2009, at 2:39 PM, Jun.Wen wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=884063713-02012009><FONT
face="Arial Narrow" color=#0000ff>It looks like this -</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=884063713-02012009><FONT
face="Arial Narrow" color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=884063713-02012009><FONT
face="Arial Narrow"
color=#0000ff>-------------------------------------------------------------------------</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=884063713-02012009><FONT
face="Arial Narrow" color=#0000ff>xcap:~/.sipclient# cat config.ini <BR>#
rename this file to 'config.ini' and copy it in ~/.sipclient/
directory</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV dir=ltr align=left><SPAN class=884063713-02012009><FONT
face="Arial Narrow" color=#0000ff># this will be the default account used
by xcapclient<BR>[Account]<BR>sip_address = <A
href="mailto:alice@192.168.10.10">alice@192.168.10.10</A><BR>password =
123<BR>xcap_root = <A
href="http://192.168.10.10/xcap-root">http://192.168.10.10/xcap-root</A></FONT></SPAN></DIV>
<DIV> </DIV>
<DIV dir=ltr align=left><SPAN class=884063713-02012009><FONT
face="Arial Narrow" color=#0000ff># this will be used when -a bob
command-line switch is provided<BR>[Account_bob]<BR>sip_address = <A
href="mailto:bob@192.168.10.10">bob@192.168.10.10</A><BR>password =
123<BR>xcap_root = <A
href="http://192.168.10.10/xcap-root">http://192.168.10.10/xcap-root</A></FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Adrian Georgescu [<A
href="mailto:ag@ag-projects.com">mailto:ag@ag-projects.com</A>]
<BR><B>Sent:</B> 2009年1月2日 21:35<BR><B>To:</B> Jun.Wen<BR><B>Subject:</B>
Re: [OpenSIPS-Users] OpenXCAP Put 401 Unauthorized<BR></FONT><BR></DIV>
<DIV></DIV>What is the content of your xcapclient configuration file
.sipclient/config.ini ?
<DIV><BR></DIV>
<DIV>Adrian</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>
<DIV>On Jan 2, 2009, at 9:33 AM, Jun.Wen wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>Hi, All, Happy new year to all the team
here.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>Please help me to figure out what is going
wrong with my openxcap. Thanks in advance.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>I've built up openxcap in debian according to
the installation guide and the it works as followings info from
error.log.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>-------------------------------------------------------------------------------------------------------------------------------</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>2009-01-02 02:56:26-0500 [-] Starting OpenXCAP
1.0.6<BR>2009-01-02 02:56:37-0500 [-] Supported Root URIs: <A
href="http://192.168.10.10/xcap-root">http://192.168.10.10/xcap-root</A><BR>2009-01-02
02:56:39-0500 [-] Certificate file 'tls/server.crt' could not be loaded:
File 'tls/server.crt' does not exist<BR>2009-01-02 02:56:39-0500 [-]
Private key file 'tls/server.key' could not be loaded: File
'tls/server.key' does not exist<BR>2009-01-02 02:56:39-0500 [-] Trusted
peers: 192.168.10.0/24, 127.0.0.1<BR>2009-01-02 02:56:39-0500 [-]
xcap.server.HTTPFactory starting on 80</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>--------------------------------------------------------------------------------------------------------------------------------</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>The openxcap server is configured to domain
192.168.10.10 ( local server static IP address ). I also created a
test account <A
href="mailto:alice@192.168.10.10">alice@192.168.10.10</A> with pwd 123
by python add-openxcap-user.py in scripts. While when I tried
the python-xcapclient to put a document to the openxcap server, I always
encountered "401 Unauthorized" for following details
-</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>-----------------------------------------------------------------------------------------------------------------------------------</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009>xcap:/opt/python-xcaplib/examples# xcapclient
-i pres-rules.xml put<BR>put <A
href="http://192.168.10.10/xcap-root/pres-rules/users/sip:alice@192.168.10.10/index">http://192.168.10.10/xcap-root/pres-rules/users/sip:alice@192.168.10.10/index</A><BR>401
Unauthorized<BR>content-type: text/html<BR>content-length:
141<BR><html><head><title>Unauthorized</title></head><body><h1>Unauthorized</h1><p>You
are not authorized to access this
resource.</p></body></html></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009>-----------------------------------------------------------------------------------------------------------------------------------</SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009>Please refer
the the access.log and it seems something related my domain
settings.</SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009>-----------------------------------------------------------------------------------------------------------------------------------</SPAN></SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009>2009-01-01 08:41:08-0500 [-] 192.168.10.10 'PUT
/xcap-root/pres-rules/users/<A
href="sip:alice@192.168.10.10/index">sip:alice@192.168.10.10/index</A>
HTTP/1.1' 401 0 141 'python-xcaplib/1.0.8'
-<BR> REQUEST
headers:<BR>
Accept-Encoding:
identity<BR>
User-Agent:
python-xcaplib/1.0.8<BR>
Host:
192.168.10.10<BR>
Content-Type:
application/x-www-form-urlencoded<BR>
Authorization: Basic
YWxpY2U6MTIz<BR> RESPONSE
headers:<BR>
Date: Thu, 01 Jan 2009 13:41:08
GMT<BR>
Content-Type:
text/html<BR>
WWW-Authenticate: basic
realm="192.168.10.10"<BR>
Server: OpenXCAP/1.0.6</SPAN></SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009>-----------------------------------------------------------------------------------------------------------------------------------</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009>Regards</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN class=805071608-02012009><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009>Jun</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009><SPAN
class=805071608-02012009></SPAN></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face="Arial Narrow" color=#0000ff><SPAN
class=805071608-02012009></SPAN></FONT> </DIV></DIV>_______________________________________________<BR>Users
mailing list<BR><A
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</A><BR><A
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</A><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>