I''m having problems using Sqlite (2.8.15) with Rails running under Cygwin. The problem is that even after building sqlite under Cygwin, it does not seem to be able to open a database if given a Unix-style pathname. Using a Windows-style pathname works fine. However, if I put the full Windows-style pathname into the ''database.yml'' configuration file, Rails seems to want to replace this with the Unix-style pathname. Line 56 of sqlite_adapter.rb (in ActiveRecord-1.9.1) seems to be the culprit, as this calls File.expand_path to get a filename relative to the RAILS_ROOT directory. Does anyone know of a way to get around this problem (aside from commenting out line 56 of sqlite_adapter.rb)? Thanks, Brett
Brett Norris wrote:> I''m having problems using Sqlite (2.8.15) with Rails running under > Cygwin.The answer is: don''t use Rails (or Ruby for that matter) under Cygwin - many people have been there and got burned. Use the One Click Installer and (if you need to host things on Windows), a native Windows build of Apache (trhgere are a couple of one-click Apache installers, too). -- Best regards, Alexey Verkhovsky Ruby Forum: ruby-forum.org (moderator) RForum: rforum.andreas-s.net (co-author) Instiki: instiki.org (maintainer)
On Saturday, April 2, 2005, 1:01:31 PM, Alexey wrote:> Brett Norris wrote:>> I''m having problems using Sqlite (2.8.15) with Rails running under >> Cygwin.> The answer is: don''t use Rails (or Ruby for that matter) under Cygwin - > many people have been there and got burned. > Use the One Click Installer and (if you need to host things on Windows), > a native Windows build of Apache (trhgere are a couple of one-click > Apache installers, too).I like using Ruby under Cygwin, but use the native Windows installer for Rails work becaues I can''t make the Cygwin Ruby talk to MySQL for some reason. For dead-easy Apache + MySQL + phpMyAdmin on Windows, google "xampp". Gavin
Gavin Sinclair wrote:>I like using Ruby under Cygwin >I like it to. But I have /c/ruby/bin in my Cygwin PATH for that :) Reasons: 1. It works. 2. Why have two separate Ruby installations? 3. One Click Installer Ruby is notably faster. -- Best regards, Alexey Verkhovsky Ruby Forum: ruby-forum.org (moderator) RForum: rforum.andreas-s.net (co-author) Instiki: instiki.org (maintainer)
Brett Norris wrote:>>I''m having problems using Sqlite (2.8.15) with Rails running under Cygwin.Alexey Verkhovsky wrote:>The answer is: don''t use Rails (or Ruby for that matter) under Cygwin - >many people have been there and got burned.Thanks for the advice. I''m not sure I agree with it though. I''ve been using Ruby under Cygwin for a couple of years now and have not been burned so far. Apart from this Sqlite problem (which is really an sqlite issue, rather than a rails issue), I''ve not run into any problems with Rails under Cygwin so far. Surely if there are issues running Ruby or Rails under Cygwin, we (the Ruby community) should be looking at finding the root cause and fixing it rather than just ignoring the problem by not using it in that environment. Best regards, Brett