Hi Andrea, You are using an openser version that requires a version 2 of the presentity table. And you installed the table corresponding to version 1. Try to use the openserdbctl script to create the correct table.
Regards, Bogdan Andrea Polidoro wrote: > 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-PRESENTITY > > 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:[EMAIL PROTECTED]/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 > > > _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
