While Updating into 5.x of MySQL Database privilages are changes,

I tried it with a "virgin" installation of openser. so i used the mysql script to create a completely new DB for openser.

Before Compliing the OpenSER , Check lib files Mysql client for openSER/

Problem in MySQL updatation not , in OpenSER,

With out properly libraries file are installed , then pnly the Mysql.so file will install the Properly.

if there are problems with the libraries, you can see messages like "cant find mysqllib.so.14" when you start openser.i changed the Makefile of the mysql modul to point directly to the ne mysql libs. so the libraries should be ok.

On 3/27/07, Martin Klisch martin@campus-merseburg.de wrote:

...

...

Hello,

after upgrading our MySQL 4.0.x to 5 and compiling the openser(1.1.1)-mysql modul with the new mysql libraries i always get

this

...

error: [ID 272136 local1.error] table_version(): Invalid type (2) or nul (0) version columns for subscriber

The tableversion is the right one and i can access the openser tables

with

...

the openser-user via regular mysql console client.

now i tried it with mysql 4.1 - it's the same problem.

anyone has an idea, what the problem could be?

I've tested some more situations:

openser 1.1.1, mysql.so, mysql-client 4.0.27 does work with mysql 4.0.x server openser 1.1.1, mysql.so, mysql-client 4.0.27 does work with mysql 4.1 + 5.x server after setting old-passwordstyle for the db user openser 1.1.1, mysql.so, mysql-client 4.1 does not work with mysql 4.0.x, 4.1, 5.x openser 1.1.1, mysql.so, mysql-client 5.x does not work with mysql 4.0.x, 4.1, 5.x

so it only works with the mysql 4.0 libraries. anyone had similar problems?

btw, platform is solaris 10 on sparc64

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users

-- Thanks and Regards Ravi Prakash Sunkara ravi.sunkara@hyperion-tech.com M:+91 9985077535 www.hyperion-tech.com Client and Parent company :- www.august-networks.com