[Users] openser admin question..

[nick]

peter.3.edwards at bt.com wrote:
>> Is an error like this normal when doing the db install?
>>
>> ERROR 1064 (42000): You have an error in your SQL syntax; check the 
>> manual that corresponds to your MySQL server version for the right 
>> syntax to use near 'VIEW usr_preferences_view AS SELECT id, username, 
>> domain, attribute, type AS att' at line 1
> 
> Hi, Nick.
> 
> Not that it helps you much - but, no, I don't think that's normal - I
> didn't get this when installing on MySQL 5.0.24 (latest stable version),
> compiled from source.  You might get compatibility issues if your
> version of MySQL is out of date ... what are you running?

mysql-4.1.20-1

There's no 5 built for centos yet, but this should be fairly up to date...
> 
> I'm sure Mike Williams will be along to help you debug it ...

The program works.. but I'm not sure what that error might cause in way 
of bugs, or whatever.
> 
>> By the way, while ruby on rails might be a great development 
>> platform, 
>> it's a right pain in the behind to install.
> 
> Completely agree - especially when you're in a network which requires
> the use of a proxy to reach the web ...
> 
> Bleugh.
> 
> Still, once it's up and running it should be easy to maintain, or so I'm
> led to believe!
> 
I had no end of problems installing mysql-ruby in the end, I ended up 
running the extern.rb with some command line options --with-mysql-config 
   and that got the makefile built.

BTW, what version of mysql-ruby should I be running, I'm using 2.5.1 at 
the moment, 2.6 and 2.7 were also available


> Peter.
>