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.rar is 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.rar is 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."