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

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.

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