Mike Williams wrote:

Nick,

The web interface depends on MySQL 5 for views. Unfortunately, I had to do this in order to not break compatibility with openserctl. Anyway, it should only break the user prefences section.

Yeah, I noticed the user prefs don't work.

Ok, I needs mysql 5..

When I install it, I just need to run the script again, right?

off to search for the rpms :)

Sorry that Rails is such a pain, it's even worse if your system doesn't have ruby installed by default.

I was able to get ruby and gems and rails installed without too many problems, but mysql was a huge pain. Not the first time I've had to battle to get things working though :)

Let me know if you have any more questions.

Mike Williams

On Thursday 31 August 2006 06:46, nick 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

By the way, while ruby on rails might be a great development platform, it's a right pain in the behind to install.

---

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

---

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

nick wrote:

OK, I spoke too soon.

I upgraded to mysql5, fixed the problems it created, reinstalled rails and installed the latest version of mysql-ruby.

I started up weBRICK and gave a go to connecting to it..

Now I have nice big script that says :

Application error (Rails)

I had a look at the log directory, but it doesn't tell me anything interesting..

Any ideas???

---

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

Here's what gets stamped in the log/development.log

no such file to load -- ../config/../config/routes.rb^M /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:140:in `load'^M /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:140:in `load'^M /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/routing.rb:608:in `reload'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:67:in `prepare_application'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:37:in `dispatch'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:115:in `handle_dispatch'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:81:in `service'^M /usr/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'^M /usr/local/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'^M /usr/local/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'^M /usr/local/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'^M /usr/local/lib/ruby/1.8/webrick/server.rb:95:in `start'^M /usr/local/lib/ruby/1.8/webrick/server.rb:92:in `start'^M /usr/local/lib/ruby/1.8/webrick/server.rb:23:in `start'^M /usr/local/lib/ruby/1.8/webrick/server.rb:82:in `start'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:67:in `dispatch'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/servers/webrick.rb:59^M /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'^M /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require'^M /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/server.rb:30^M /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'^M /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require'^M ./server:3