I just started reading the Manning Ruby for Rails guide and have no prior experience with any of this material and I am stuck on initializing an sql database. The book says it needs to be done for the next step in the project, but I have no idea how to initialize the database =/ or how to install it if that is even required. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Which OS are you using, which SQL DataBase are you using and version? On Thu, 2006-12-28 at 02:15 +0100, Alexander York wrote:> I just started reading the Manning Ruby for Rails guide and have no > prior experience with any of this material and I am stuck on > initializing an sql database. The book says it needs to be done for the > next step in the project, but I have no idea how to initialize the > database =/ or how to install it if that is even required. >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
matt wrote:> Which OS are you using, which SQL DataBase are you using and version?Using Gentoo and I don''t think I have mysql installed yet (not really sure where to begin with it in relation to rails) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Well getting MySQL installed is paramount to getting things started. I''m not a Gentoo user, but I use Fedora, so things should be similar enough to get you started. For MySQL Install, I use the yum package manager (yum install mysql*) There are other package managers as well, apt-get, rpm''s, etc, if yum isn''t your thing, let me know what works for you, maybe one of the others on the list can chime in on getting you setup. you can also check to see if it''s installed. $ which mysql or $ yum list mysql* If that returns something like /usr/bin/mysql then you''re in business. You might want to check mysql.com they have a lot of good install information as well. I''ve been thinking about setting up a Gentoo box. It work well for you? Matt On Thu, 2006-12-28 at 02:35 +0100, Alexander York wrote:> matt wrote: > > Which OS are you using, which SQL DataBase are you using and version? > > Using Gentoo and I don''t think I have mysql installed yet (not really > sure where to begin with it in relation to rails) >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
matt wrote:> Well getting MySQL installed is paramount to getting things started. > > I''m not a Gentoo user, but I use Fedora, so things should be similar > enough to get you started. > > For MySQL Install, I use the yum package manager (yum install mysql*) > > There are other package managers as well, apt-get, rpm''s, etc, if yum > isn''t your thing, let me know what works for you, maybe one of the > others on the list can chime in on getting you setup. > > you can also check to see if it''s installed. > > $ which mysql > > or > > $ yum list mysql* > > > If that returns something like /usr/bin/mysql then you''re in business. > > You might want to check mysql.com they have a lot of good install > information as well. > > I''ve been thinking about setting up a Gentoo box. It work well for you? > > MattLove gentoo so far, dont have to deal with a bunch of extra trash that other distros like to pack in with their installers and everything is extremely configurable. Gentoo + Enlightenment DR17 is very nice. Which mysql returned /usr/bin/mysql so i know its installed now, what is next? any configuration needed? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Excellent, with any luck we can get your db set up you will need to make sure that the mysqld is running. On my system, I run /etc/init.d/mysqld start It basically runs through a script that makes a call to /usr/bin/mysql-safe (or something like that) and sets up a mysqld server daemon. After the daemon is up and running, $mysql -uroot This will start your mysql session as root. Might have to use -p and a password, but I believe that mysql defaults to a root user with no password. then you will get a mysql prompt. then create 3 databases. You can choose whatever you want, but by convention, the name of the project followed by _development, _production and _test mysql > create database db_development; mysql > create database db_production; mysql > create database db_test; This will create the 3 databases that the book probably references. ( I haven''t read that one, but the procedure should be the same) then mysql > grant all on db_development.* to ''username''@''localhost'' identified by ''yourpassword''; mysql > grant all on db_test.* to ''username''@''localhost'' identified by ''yourpassword''; you can do the same thing for the production db, but 2 things to mentions. 1) while playing / developing, you may never use the production db. 2) when using the production env, you want to cinch down the permissions, so ''grant all'' wouldn''t be appropriate. While testing/developing, I grant all to my self on production, but never on something that leaves my machine. Also, ''username'' is any name you choose and ''yourpassword'' is any password you choose. All the while this has been as a root mysql user, so exit out of mysql and log back in as such: $ mysql -u username -p enter password: this will ask for your password you just set up. mysql > show databases; should display the 3 new databases we just setup All should be good. OK, I think that covers getting you set up from the command line. I forgot that there are some GUI tools (mysql-admin, and another one..) that makes it easier for some, but I''ve been command-line for so long, that I forget about those things. So let me know if this gets you setup with the DB Matt On Thu, 2006-12-28 at 03:00 +0100, Alexander York wrote:> matt wrote: > > Well getting MySQL installed is paramount to getting things started. > > > > I''m not a Gentoo user, but I use Fedora, so things should be similar > > enough to get you started. > > > > For MySQL Install, I use the yum package manager (yum install mysql*) > > > > There are other package managers as well, apt-get, rpm''s, etc, if yum > > isn''t your thing, let me know what works for you, maybe one of the > > others on the list can chime in on getting you setup. > > > > you can also check to see if it''s installed. > > > > $ which mysql > > > > or > > > > $ yum list mysql* > > > > > > If that returns something like /usr/bin/mysql then you''re in business. > > > > You might want to check mysql.com they have a lot of good install > > information as well. > > > > I''ve been thinking about setting up a Gentoo box. It work well for you? > > > > Matt > > Love gentoo so far, dont have to deal with a bunch of extra trash that > other distros like to pack in with their installers and everything is > extremely configurable. Gentoo + Enlightenment DR17 is very nice. > > Which mysql returned /usr/bin/mysql > > so i know its installed now, what is next? any configuration needed? >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
matt wrote:> > > So let me know if this gets you setup with the DB > > Mattperfect!! i think that is all i need for now, will probably pick this up on thursday! thanks a mill matt and if you have any gentoo questions feel free to ask! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Alexander York wrote:> matt wrote: > >> >> >> So let me know if this gets you setup with the DB >> >> Matt > perfect!! i think that is all i need for now, will probably pick this up > on thursday! thanks a mill matt and if you have any gentoo questions > feel free to ask!When I try to run the server and go to the demo the book provides i get this error Can''t connect to local MySQL server through socket ''/tmp/mysql.sock'' (2) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
in your database.yml file, there is a section for development, test, and production in each section add the following: socket: /var/lib/mysql/mysql.sock That is the path that fedora uses, I suspect that it is the same on Gentoo. There should be a way to find where the socket is located, but I''m at a loss at the moment, so try the above first, and cross your fingers. Matt On Thu, 2006-12-28 at 11:56 +0100, Alexander York wrote:> Alexander York wrote: > > matt wrote: > > > >> > >> > >> So let me know if this gets you setup with the DB > >> > >> Matt > > perfect!! i think that is all i need for now, will probably pick this up > > on thursday! thanks a mill matt and if you have any gentoo questions > > feel free to ask! > > When I try to run the server and go to the demo the book provides i get > this error > > Can''t connect to local MySQL server through socket ''/tmp/mysql.sock'' (2) >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
matt wrote:> in your database.yml file, there is a section for development, test, and > production > > in each section add the following: > > socket: /var/lib/mysql/mysql.sock > > That is the path that fedora uses, I suspect that it is the same on > Gentoo. There should be a way to find where the socket is located, but > I''m at a loss at the moment, so try the above first, and cross your > fingers. > > Mattno luck, even tried ''find''ing the file to no avail -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Not for sure on what to say. Try to restart the mysqld daemon. Also try the mysql forums, they might know more. Google might get you over this hump too, but if I understand MySQL correctly, a mysql.sock file gets created every time the daemon re-starts, so I would try that first. Good luck, you''re almost there. Matt On Fri, 2006-12-29 at 01:33 +0100, Alexander York wrote:> matt wrote: > > in your database.yml file, there is a section for development, test, and > > production > > > > in each section add the following: > > > > socket: /var/lib/mysql/mysql.sock > > > > That is the path that fedora uses, I suspect that it is the same on > > Gentoo. There should be a way to find where the socket is located, but > > I''m at a loss at the moment, so try the above first, and cross your > > fingers. > > > > Matt > > no luck, even tried ''find''ing the file to no avail >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
matt wrote:> Not for sure on what to say. Try to restart the mysqld daemon. Also > try the mysql forums, they might know more. > > Google might get you over this hump too, but if I understand MySQL > correctly, a mysql.sock file gets created every time the daemon > re-starts, so I would try that first. > > Good luck, you''re almost there. > > Mattit seems to be magically working now after i restarted! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 12/28/06, matt <matt-SaPSgiKzPPtdsTMtEp03Dg@public.gmane.org> wrote:> There should be a way to find where the socket is locatedSorry, late to the thread, but -- prompt% mysqld --print-defaults mysqld would have been started with the following arguments: --port=3306 --socket=/tmp/mysql.sock --default-character-set=utf8 --character_set_server=utf8 --datadir=/usr/local/mysql/data ......... FWIW, -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---