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-PRESENTI…
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