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

12 Aug 2008

Hello,

On 08/12/08 10:30, mahesh.peddi(a)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" 
 &lt;miconda(a)gmail.com&gt;
 To: &lt;mahesh.peddi(a)info-spectrum.com&gt;
 Cc: &lt;users(a)lists.kamailio.org&gt;
 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(a)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(a)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

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