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

[Daniel-Constantin Mierla]

Hello,

On 08/12/08 10:30, mahesh.peddi at info-spectrum.com wrote:
> Hi Daniel,
>
>                Thanks for your prompt reply.The output of "show create 
> table version" is as follows
>
> +---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ 
>
> | Table   | Create Table |
> +---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ 
>
> | version | CREATE TABLE `version` (
>  `table_name` varchar(32) NOT NULL,
>  `table_version` int(10) unsigned NOT NULL default '0'
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
> +---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+ 
>
> 1 row in set (0.03 sec)
>
> Kindly guide me on this.
the table structure is ok. Could you make sure the mysql module is 
compiled again if you updated libraries or so. I was pointed that there 
was a change in naming the INT type in mysql libraries -- maybe others 
on the list can jump quicker here with a yes or no.

Cheers,
Daniel

>
> Thank you,
>
>
> Regards,
> Mahesh Peddi
> Infospectrum India Pvt. Ltd.
> Cell:  +91 9765775176
> IP-Phone Ext. - 764
>
> ----- Original Message ----- From: "Daniel-Constantin Mierla" 
> <miconda at gmail.com>
> To: <mahesh.peddi at info-spectrum.com>
> Cc: <users at lists.kamailio.org>
> Sent: Monday, August 11, 2008 9:41 PM
> Subject: Re: [Kamailio-Users] ERROR:presence:mod_init: 1Wrong version 
> v-1 for table <presentity>, need v2
>
>
>> 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
>>
>>
>

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