[OpenSER-Users] Help please: OpenSer as RLS.

Noble Antony T noble.antony at gmail.com
Fri Jul 4 11:57:06 CEST 2008


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...

-- 
Thanks & Regards,
Noble Antony Thattil.

On Fri, Jul 4, 2008 at 2:53 PM, Henning Westerholt <
henning.westerholt at 1und1.de> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.openser.org/pipermail/users/attachments/20080704/fcd73940/attachment.htm 


More information about the Users mailing list