Hi Naidu,
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
# ./mysqldb.sh create
That should be it, it will ask you if u want to create the presence related tables. Thanks kumar
On 6/20/07, akkala.naidu@aricent.com akkala.naidu@aricent.com wrote:
Hi Kumar,
Even myself trying to use openser as 'presence server'. I did all the changes to openser.cfg to add presence module to openser. i have downloaded and installed mysql binary " mysql-5.0.41-linux-i686-glibc23.tar.gz " from net. now my question is: How to create PRESENCE tables from mysql ? when i type 'use openser' command from mysql> i got below error :
mysql> use openser ERROR 1049 (42000): Unknown database 'openser'
Pls let me know how to create tables and how to start mysql client an server to make it work as presence server.
Thanks in advance, Naidu
-----users-bounces@openser.org wrote: -----
To: users@openser.org From: KUMAR kumar.kisalaya@gmail.com Sent by: users-bounces@openser.org Date: 06/20/2007 12:44PM Subject: [Users] presence
ScanMail detected the email with attachment openser.cfg20070620094425.raris not allowed to circulate. The attachment Quarantineed ScanMail detected the email with attachment openser_dump20070620125611.rar is not allowed to circulate. The attachment Quarantineed
Hi all, I am using openser-1.2.1+RTPProxy. I am using XLite as UA. I want to be able to store the buddy list of the users at the server. For this, I am using the presence module. But I cannot get it working. I have created the presence related tables in mysql. And those tables do show some information in them. I have attached my openser.cfg and the message dump from wireshark. The messages have been captured at the UA end. I also get the following message at the server.
PRESENCE: handle_subscribe:Missing or unsupported event header field value 2(12452) PRESENCE:handle_subscribe: ERROR occured 2(12452) WARNING: script writer didn't release transaction
Am I missing something basic here? Please reply. Thank you Kumar
ScanMail detected the email with attachment openser.cfg20070620094425.raris not allowed to circulate. The attachment Quarantineed ScanMail detected the email with attachment openser_dump20070620125611.rar is not allowed to circulate. The attachment Quarantineed
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
*****Aricent-Private *****=
"DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus."