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

[Noble Antony T]

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

-- 
Thanks & Regards,
Noble Antony Thattil.



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

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080704/655001a6/attachment.htm>