Hi Naidu,<br><br>If you've compiled openser from source, then u'll find a script called mysqldb.sh inside the scripts directory of the source distribution. Just cd to the directory containing the script. And then execute it as
<br><br># ./mysqldb.sh create<br><br>That should be it, it will ask you if u want to create the presence related tables.<br>Thanks<br>kumar<br><br><div><span class="gmail_quote">On 6/20/07, <b class="gmail_sendername"><a href="mailto:akkala.naidu@aricent.com">
akkala.naidu@aricent.com</a></b> <<a href="mailto:akkala.naidu@aricent.com">akkala.naidu@aricent.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Hi Kumar,<br>
<br>
Even myself trying to use openser as 'presence server'.<br>
I did all the changes to openser.cfg to add presence module to openser. <br>
i have downloaded and installed mysql binary " mysql-5.0.41-linux-i686-glibc23.tar.gz " from net.<br>
now my question is: How to create PRESENCE tables from mysql ? <br>
when i type 'use openser' command from mysql> i got below error :<br>
<br>
mysql> use openser<br>
ERROR 1049 (42000): Unknown database 'openser'<br>
<br>
<br>
Pls let me know how to create tables and how to start mysql client an server to make it work as presence server.<br>
<br><div>Thanks in advance,<br>
Naidu<br><div><br></div><font color="#990099">-----<a href="mailto:users-bounces@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">users-bounces@openser.org</a> wrote: -----<br><br></font>
<blockquote style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">To: <a href="mailto:users@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
users@openser.org</a><br>From: KUMAR <<a href="mailto:kumar.kisalaya@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kumar.kisalaya@gmail.com</a>><br>Sent by: <a href="mailto:users-bounces@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
users-bounces@openser.org</a><br>Date: 06/20/2007 12:44PM<br>Subject: [Users] presence<br><br><font face="monospace" size="3"><br><br>ScanMail detected the email
with attachment openser.cfg20070620094425.rar is not allowed to
circulate. The attachment Quarantineed<br>ScanMail detected the
email with attachment openser_dump20070620125611.rar is not allowed to
circulate. The attachment Quarantineed<br><br>Hi all,<br>I am using openser-1.2.1+RTPProxy. I am using XLite as UA. I want to<br>be able to store the buddy list of the users at the server. For this,<br>I am using the presence module. But I cannot get it working. I have
<br>created the presence related tables in mysql. And those tables do show<br>some information in them. I have attached my openser.cfg and the<br>message dump from wireshark. The messages have been captured at the UA<br>end.
<br>I also get the following message at the server.<br><br>PRESENCE: handle_subscribe:Missing or unsupported event header field value<br> 2(12452) PRESENCE:handle_subscribe: ERROR occured<br> 2(12452) WARNING: script writer didn't release transaction
<br><br>Am I missing something basic here?<br>Please reply.<br>Thank you<br>Kumar<br></font><font face="monospace" size="3"><br><br>ScanMail
detected the email with attachment openser.cfg20070620094425.rar is not
allowed to circulate. The attachment Quarantineed<br>ScanMail
detected the email with attachment openser_dump20070620125611.rar is
not allowed to circulate. The attachment Quarantineed<br><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@openser.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
Users@openser.org</a><br><a href="http://openser.org/cgi-bin/mailman/listinfo/users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://openser.org/cgi-bin/mailman/listinfo/users</a><br></font></blockquote>
<br></div></div><br>*****Aricent-Private *****=
<table><tbody><tr><td bgcolor="#ffffff"><font color="#000000"></font><pre><font color="#000000">"DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of <br>the individual to whom it is addressed. It may contain privileged or confidential information and should not be
<br>circulated or used for any purpose other than for what it is intended. If you have received this message in error, <br>please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly
<br>prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for <br>loss or damage arising from the use of the information transmitted by this email including damage from virus."
<br></font></pre></td></tr></tbody></table>
</blockquote></div><br>