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

[Daniel-Constantin Mierla]

Hello,

please post the output of:

show create table version

in the mysql client. The errors shows some issue with the column type.

Cheers,
Daniel

On 08/11/08 17:12, mahesh.peddi at info-spectrum.com wrote:
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>   

-- 
Daniel-Constantin Mierla
http://www.asipto.com