[OpenSER-Users] ERROR:presence:mod_init: Wrong version v-1 for table <presentity>, need v2

[Bogdan-Andrei Iancu]

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: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
>
>
>