Hi,
I have compiled the Openser with RLS module in my desktop, and it seems installation went fine...
But when I try to start the openser, I am getting the following error..... * Jul 3 10:11:49 [10721] ERROR:core:table_version: invalid type (2) or nul (0) version columns for xcap Jul 3 10:11:49 [10721] DBG:core:db_free_rows: freeing 1 rows Jul 3 10:11:49 [10721] DBG:core:db_free_rows: row[0]=0x815d530 Jul 3 10:11:49 [10721] DBG:core:db_free_rows: 0x815d530=pkg_free() RES_ROWS Jul 3 10:11:49 [10721] ERROR:presence_xml:mod_init: Wrong version v-1 for table <xcap>, need v3 Jul 3 10:11:49 [10721] ERROR:core:init_mod: failed to initialize module presence_xml Jul 3 10:11:49 [10721] ERROR:core:main: error while initializing modules Jul 3 10:11:49 [10721] DBG:rls:destroy: start*
But my MySQL shows, the version of XCAP as
*mysql> select * from version where table_name="xcap" ; +------------+---------------+ | table_name | table_version | +------------+---------------+ | xcap | 3 | +------------+---------------+ 1 row in set (0.00 sec)
mysql> * Though the version information is present for the xcap table, this error is coming.
I have created the database using the following * stinbng46:/home/nthattil/tmp/src_openser_install# /usr/local/sbin/openserdbctl /usr/local/sbin/openserdbctl $Revision: 3540 $
usage: openserdbctl create <db name or db_path, optional> .....(creates a new database) openserdbctl drop <db name or db_path, optional> .......(!entirely deletes tables!) openserdbctl reinit <db name or db_path, optional> .....(!entirely deletes and than re-creates tables!) openserdbctl backup <file> .................................(dumps current database to file) openserdbctl restore <file> ................................(restores tables from a file) openserdbctl copy <new_db> .................................(creates a new db from an existing one) openserdbctl migrate <old_db> <new_db> .....................(migrates DB from 1.2 to 1.3, not implemented yet!) openserdbctl presence ......................................(adds the presence related tables) openserdbctl extra .........................................(adds the extra tables) openserdbctl serweb ........................................(adds the SERWEB specific tables) *
The Version of Openser I used is
*stinbng46:/home/nthattil/tmp/src_openser_install# /usr/local/sbin/openser -V version: openser 1.3.2-notls (i386/linux) flags: STATS: Off, EXTRA_DEBUG, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535 poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. svnrevision: unknown @(#) $Id: main.c 3590 2008-01-28 17:46:56Z bogdan_iancu $ main.c compiled on 03:33:43 Jul 3 2008 with gcc 4.2.3
*I downloaded the entire source-code from the location below * http://www.openser.org/pub/openser/latest/src/openser-1.3.2-notls_src.tar.gz *
I wanted to use the integrated XCAP server, which will use the mysql database for itself, instead of HTTP protocol.
My Configuration file, I am including along with this mail... also the Openser Log file....
*Somebody please help me....... *Please point out, if something I am missing to configure.....
On Friday 04 July 2008, Noble Antony T wrote:
I have compiled the Openser with RLS module in my desktop, and it seems installation went fine...
But when I try to start the openser, I am getting the following error.....
Jul 3 10:11:49 [10721] ERROR:core:table_version: invalid type (2) or nul (0) version columns for xcap Jul 3 10:11:49 [10721] DBG:core:db_free_rows: freeing 1 rows Jul 3 10:11:49 [10721] DBG:core:db_free_rows: row[0]=0x815d530 Jul 3 10:11:49 [10721] DBG:core:db_free_rows: 0x815d530=pkg_free() RES_ROWS Jul 3 10:11:49 [10721] ERROR:presence_xml:mod_init: Wrong version v-1 for table <xcap>, need v3 Jul 3 10:11:49 [10721] ERROR:core:init_mod: failed to initialize module presence_xml Jul 3 10:11:49 [10721] ERROR:core:main: error while initializing modules Jul 3 10:11:49 [10721] DBG:rls:destroy: start*
But my MySQL shows, the version of XCAP as
*mysql> select * from version where table_name="xcap" ; | xcap | 3 |
Though the version information is present for the xcap table, this error is coming.
Hi Noble Antony,
i've tried to reproduce your problem with the 1.3 branch of openser. On my system i don't observe the error you've described. It seems that there happens an error during the version table query (first log statement). Does this happens all the time? Have you tried to install the DB again?
Cheers,
Henning
Hi,
Thanks for your Reply,
I tried at least 3 times deleting & recreating the Database... always I was getting this issue.
What I observed is, the version table Query returns the data-type of the Version as DB_STRING (2), where as, it should have been DB_INT, so the function *table_version() *is returning as -1.
But the value returned by the Query (String value) is correct.. (except that the data-type.)
Database shows the correct type for the column....
mysql> desc version ; +---------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+-------+ | table_name | varchar(32) | NO | | | | | table_version | int(10) unsigned | NO | | 0 | | +---------------+------------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
I locally changed so that it returns the correct value, in INTEGER.
Also this *table_version* function always finds the result as DB_STRING, it is not only for the *xcap* table, but for all the tables...
On Friday 04 July 2008, Noble Antony T wrote:
I tried at least 3 times deleting & recreating the Database... always I was getting this issue.
What I observed is, the version table Query returns the data-type of the Version as DB_STRING (2), where as, it should have been DB_INT, so the function *table_version() *is returning as -1.
But the value returned by the Query (String value) is correct.. (except that the data-type.)
Database shows the correct type for the column....
mysql> desc version ; | table_version | int(10) unsigned | NO | | 0 | |
I locally changed so that it returns the correct value, in INTEGER.
Also this *table_version* function always finds the result as DB_STRING, it is not only for the *xcap* table, but for all the tables...
Hi,
this is indeed strange. Can you give some details about your system? What version of the mysql-client and -server do you use?
Henning
Hi,
yes, as you told, it was very strange for me too... :)
I have changed the code locally, and Openser is running now.......
may this information be helpful for some others...
stinbng46:/home/nthattil/tmp/src_openser_install# sudo aptitude search mysqlclient v liblibmysqlclient15-dev - v libmysqlclient-dev - v libmysqlclient10-dev - iB libmysqlclient12 - mysql database client library v libmysqlclient12-dev - v libmysqlclient14-dev - v libmysqlclient15 - i libmysqlclient15-dev - MySQL database development files iB libmysqlclient15off - MySQL database client library v libmysqlclient6-dev -
stinbng46:/home/nthattil/tmp/src_openser_install# mysql -V mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
stinbng46:/home/nthattil/tmp/src_openser_install# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 127 Server version: 5.0.32-Debian_7etch5-log Debian etch distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit Bye
On Friday 04 July 2008, Noble Antony T wrote:
Hi,
yes, as you told, it was very strange for me too... :) [..]
Hi,
in the 1.4 trunk i changed some obselete datatype defines for mysql, this was not changed in the 1.3 version because of stability reasons. It could be possible that this causes the error you see now. I've attached a small patch, can you perhaps apply this, recompile and see if the error (and this log message) happens again?
(The patch just log a warning if some datatype conversion failed, and the default "STRING" is used.)
Thanks,
Henning
-
Henning Westerholt -
Noble Antony T