Dear all,
I'm trying to install in a debian sid machine the openser 1.3 in order to use it as presence server. I downloaded the openser and the presence module from the official debian repository. As database I'm using mysql. Unfortunately, when I try to start the openSer I receive this error:
"ERROR:presence:mod_init: Wrong version v-1 for table <presentity>, need v2"
I found the presentity table structure in this link:
http://www.openser.org/docs/db-tables/openser-db-1.3.x.html#GEN-DB-PRESENTIT...
and I compared it with the presentity table in my system (this is the output):
mysql> describe presentity; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(64) | NO | MUL | NULL | | | domain | varchar(64) | NO | | NULL | | | event | varchar(64) | NO | | NULL | | | etag | varchar(64) | NO | | NULL | | | expires | int(11) | NO | | NULL | | | received_time | int(11) | NO | | NULL | | | body | blob | NO | | NULL | | +---------------+------------------+------+-----+---------+----------------+ 8 rows in set (0.03 sec)
How you can see, they seam identical. I searched this error in your mailing list but I didn't find anything. Please, could you help me to understood witch is the error?
the presence parameters in my openser.cfg are: modparam("presence", "db_url", "mysql://openser:openserrw@127.0.0.1/openser") modparam("presence", "presentity_table", "presentity") modparam("presence", "server_address", "sip:192.168.100.22:5060")
Thank you in advance for your help,
Best Regards
Andrea Polidoro