Jason, You might try doing a couple of things to reduce some variables. OS X's default Ruby install has some problems with the mySQL connector, and while it can be fixed, it is a little complicated (first you have to patch Ruby, then install some Gems, etc.) so the best thing to do might be to try Locomotive for development. It packages Rails and the lighttpd server and all your gems up in a nice runtime so you don't have to do any configurations, httpd.conf, mod_rewrite stuff, etc.
http://locomotive.sourceforge.net/ Another thing that could be an issue with your database.yml is that your production and test logins are not the same as your development login. while you'd probably know it if you were running in test mode, sometimes it is hard to know if you are in dev or production mode, so it wouldn't hurt to go ahead and set the prodcution db's to the same login in your database.yml -- Chris Anderson http://musicfordozens.com/jchris On 10/27/05, Caleb Phillips <[EMAIL PROTECTED]> wrote: > >>> Rails is not selecting the database before it issues sql commands. > >>> get a "No database selected: ..." error when trying to do anything. > > > http://www.student.cs.uwaterloo.ca/~jouellet/ruby/database.yml > > http://www.student.cs.uwaterloo.ca/~jouellet/ruby/tableDefinitions.sql > > > > i think this is the command i used to create the user 'jay' in mySql > > GRANT ALL PRIVILEGES ON *.* TO 'jay'@'%'; > > Well, all that looks in order, you might try to give the 'jay' user a > password (even a trivial one), and put that in the database.yml. > > If that doesn't work, I'm not sure. Make sure you can do with the > command line mysql client what you are asking Rails to do (i.e. connect > to the database as user jay). > > Good luck. > > -- > Caleb Phillips > IT Specialist > Small White Cube > _______________________________________________ > PDXRuby mailing list > [email protected] > IRC: #pdx.rb on irc.freenode.net > http://lists.pdxruby.org/mailman/listinfo/pdxruby > _______________________________________________ PDXRuby mailing list [email protected] IRC: #pdx.rb on irc.freenode.net http://lists.pdxruby.org/mailman/listinfo/pdxruby
