Hello,
On 08/12/08 10:30, mahesh.peddi@info-spectrum.com wrote:
Hi Daniel,
Thanks for your prompt reply.The output of "show createtable 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@gmail.com To: mahesh.peddi@info-spectrum.com Cc: users@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@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
-- Daniel-Constantin Mierla http://www.asipto.com