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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] wrote: ----- To: [email protected] From: KUMAR <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 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 [email protected] 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."
_______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
