27 Mar
2007
27 Mar
'07
12:41 p.m.
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(a)campus-merseburg.de> wrote:
--
Thanks and Regards
Ravi Prakash Sunkara
ravi.sunkara(a)hyperion-tech.com
M:+91 9985077535
www.hyperion-tech.com
Client and Parent company :- www.august-networks.com
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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users