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

[mahesh.peddi at info-spectrum.com]

Hi All,

I am working on Openser 1.3.2 version with no_tls support.
When i include
"modparam("presence", 
"db_url","mysql://openser:openserrw@localhost/openser")"

for the presence and run openserctl moni i am getting the error as

ERROR: Error opening OpenSER's FIFO /tmp/openser_fifo
ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name", 
"/tmp/openser_fifo")' in your config
ERROR: and also have loaded the mi_fifo module.

And the errors in /var/log/messages

Aug 10 09:37:41 rhel4 openser[5530]: ERROR:core:table_version: invalid type 
(2) or nul (0) version columns for presentity
Aug 10 09:37:41 rhel4 openser[5530]: ERROR:presence:mod_init: 1Wrong version 
v-1 for table <presentity>, need v2
Aug 10 09:37:41 rhel4 openser[5530]: ERROR:core:init_mod: failed to 
initialize module presence
Aug 10 09:37:41 rhel4 openser[5530]: ERROR:core:main: error while 
initializing modules
Aug 10 09:37:41 rhel4 openser[5530]: NOTICE:presence:destroy: destroy module 
...
Aug 10 10:01:01 rhel4 crond(pam_unix)[5552]: session opened for user root by 
(uid=0)
Aug 10 10:01:01 rhel4 crond(pam_unix)[5552]: session closed for user root

And when i check in the data base its showing the version as

mysql> select * from version where table_name="presentity" ;
+------------+---------------+
| table_name | table_version |
+------------+---------------+
| presentity |             2 |
+------------+---------------+
1 row in set (0.00 sec)

Please help me how to resolve this.
And as mention in the forums i modify the res.c as below shows even i am 
facing the same error.


 --------------------------------------------------------------------------------Index: modules/mysql/res.c===================================================================--- modules/mysql/res.c (revision 4448)+++ modules/mysql/res.c (working copy)@@ -103,7 +103,10 @@  break;  default:- RES_TYPES(_r)[i] = DB_STRING;+ LM_WARN("unhandled data type column (%.*s) type id (%d), "+ "use DB_STRING as default\n", RES_NAMES(_r)[col]->len,+ RES_NAMES(_r)[col]->s, fields[col].type);+ RES_TYPES(_r)[col] = DB_STRING;  break;  }  }--------------------------------------------------------------------------------I am enclosing my "openser.cfg" and "openserctlrc"Regards,Mahesh PeddiInfospectrum India Pvt. Ltd.Cell:  +91 9765775176IP-Phone Ext. - 764
-------------- next part --------------
A non-text attachment was scrubbed...
Name: openser.cfg.rar
Type: application/octet-stream
Size: 5942 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080811/e99b9e4f/attachment.obj>