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