I don''t know why but mySQL is not running when InstantRails starts. I cannot seem to figure out how to get it running. It''s there in the mysql directory. I have "C:\InstantRails\mysql\bin;" as the first entry in my PATH variable. Maybe I am trying to start it in the wrong place? Right now I tried running "mysqld" in the C:\InstantRails\mysql\bin and it seems to be hanging... -- 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 -~----------~----~----~----~------~----~------~--~---
I just tried running "mysql" within the bin directory and now I get this... ERROR 1045 (28000): Access denied for user ''ODBC''@''localhost'' (using password: NO) -- 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 -~----------~----~----~----~------~----~------~--~---
Hi Tom, Without a little more info, I''m not sure how to direct you. MySQL should start when you start IR.exe. Plz say more. Best regards, Bill ----- Original Message ----- From: "Tom Dellaringa" <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> Sent: Sunday, December 02, 2007 5:01 PM Subject: [Rails] Re: How do you start mySQL under InstantRails?> > I just tried running "mysql" within the bin directory and now I get > this... > > ERROR 1045 (28000): Access denied for user ''ODBC''@''localhost'' (using > password: NO) > > -- > 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 -~----------~----~----~----~------~----~------~--~---
Bill Walton wrote:> Hi Tom, > > Without a little more info, I''m not sure how to direct you. MySQL should > start when you start IR.exe. Plz say more.Thanks, I''m not sure what else to provide, but what I finally did was this: C:\InstantRails\mysql\bin>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.27-community Then tried to go to my page, and it finally worked. I guess it wanted to know I was the root user? I thought it was supposed to start at startup as you say. -- 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 -~----------~----~----~----~------~----~------~--~---
The command ''mysql'' which you entered is the client, not the server. If you were able to login using ''mysql -u root'' then it means that the server is starting correctly. Only the MySQL server is loaded when InstantRails starts, not the client, as the client is not used by Rails. On Dec 3, 1:19 am, Tom Dellaringa <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Bill Walton wrote: > > Hi Tom, > > > Without a little more info, I''m not sure how to direct you. MySQL should > > start when you start IR.exe. Plz say more. > > Thanks, I''m not sure what else to provide, but what I finally did was > this: > > C:\InstantRails\mysql\bin>mysql -u root > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 to server version: 5.0.27-community > > Then tried to go to my page, and it finally worked. > > I guess it wanted to know I was the root user? I thought it was supposed > to start at startup as you say. > -- > Posted viahttp://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 -~----------~----~----~----~------~----~------~--~---
Gareth Howells wrote:> The command ''mysql'' which you entered is the client, not the server. > If you were able to login using ''mysql -u root'' then it means that the > server is starting correctly. Only the MySQL server is loaded when > InstantRails starts, not the client, as the client is not used by > Rails.Ok, maybe I''m misunderstanding what was happening then. When I first hit my application, it wouldn''t connect. After I logged into mysql - it did. Is there something I need to do in the application itself to ensure that connection is made? -- 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 -~----------~----~----~----~------~----~------~--~---
Yes, before running a Rails program you should login to MySQL as the user who ''owns'' the database for that program, and then enter the command ''USE databasename;'' where databasename is the name of the database for the program. ----- Gareth Howells Grey College JCR IT Officer and Technical Services Manager University of Durham 07862725134 ----- Original Message ----- From: "Tom Dellaringa" <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> To: <rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> Sent: Monday, December 03, 2007 1:43 AM Subject: [Rails] Re: How do you start mySQL under InstantRails?> > Gareth Howells wrote: >> The command ''mysql'' which you entered is the client, not the server. >> If you were able to login using ''mysql -u root'' then it means that the >> server is starting correctly. Only the MySQL server is loaded when >> InstantRails starts, not the client, as the client is not used by >> Rails. > > Ok, maybe I''m misunderstanding what was happening then. When I first hit > my application, it wouldn''t connect. After I logged into mysql - it > did. Is there something I need to do in the application itself to ensure > that connection is made? > -- > 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 Mon, 03 Dec 2007 02:43:03 +0100, Tom Dellaringa wrote:> Ok, maybe I''m misunderstanding what was happening then. When I first hit > my application, it wouldn''t connect.There was nothing to connect to. The mysql server was down, it''s like trying to load a page in firefox when the server on the other end is down: error 404. Once the mysql server was up and running then rails can connect to it :) -Thufir --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
I''m still slightly confused on this.. how do I start mySQL then when I first load up IR? I tried to begin a new project today, and when I tried to create the db I got the connection error. IR said mySQL was running. I used the IR console to restart mysql - which then send it was "pending" not running. I also tried doing ''mysqld'' in the mysql directory. Shortly after that I was able to create the db and log into it, so I''m not sure what actually got it going. The mysqld command never seemed to execute in the command window... I finally closed it (it seemed hung up). Sorry for this total newb questions, what seems like it should be obvious to me just isn''t... -- 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 -~----------~----~----~----~------~----~------~--~---
Tom Dellaringa wrote:> I''m still slightly confused on this.. how do I start mySQL then when Ion instant rails.... it installs in a directory, alone, not like another windows istallers. it makes an instant rails folder. there is an Instantrails.exe file in the instantrails folder. Double click on instantrails.exe (make a link to it). that will load apache and mysql. then, you should have a little red ''I'' in the bottom right of the screen. it flashs some yellow when running. right click on that I, and select RAILS APPLICATIONS > MANAGE RAILS APPLICATIONS. the rails app should be there. check it, and start mongrel. leave the terminal running, just minimize it. there you go... mysql, apache, and mongrel. there are more options... ;) -- 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 -~----------~----~----~----~------~----~------~--~---
gemblon (t.b.) wrote:> Tom Dellaringa wrote: >> I''m still slightly confused on this.. how do I start mySQL then when I > > > on instant rails.... it installs in a directory, alone, not like another > windows > istallers. it makes an instant rails folder. there is an > Instantrails.exe file in the instantrails folder. Double click on > instantrails.exe (make a link to it). that will load apache and mysql. > then, you should have a little red ''I'' in the bottom right of the > screen. it flashs some yellow when running. >This much I was okay with...> right click on that I, and select RAILS APPLICATIONS > MANAGE RAILS > APPLICATIONS. > the rails app should be there. check it, and start mongrel. leave the > terminal running, just minimize it. > > there you go... mysql, apache, and mongrel. there are more options... > ;)What does starting the mongrel server have to do with getting mysql to run? -- 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 Tue, 18 Dec 2007 16:49:08 +0100, Tom Dellaringa wrote:> I''m still slightly confused on this.. how do I start mySQL then when I > first load up IR?There''s a MySQL group for a better explanation, but... Think of of a web server, be it mongrel, webrick or apache. That web server must be started, yes? Similarly, there''s a mySQL server which must be started. If mongrel/webrick isn''t running, then going to localhost:3000 will give "page cannot be displayed", right? You''re getting the same thing, but from the MySQL server. I forget, are you using Linux or Windows? In GNOME for Linux, I can navigate to System > Administration > Services then enter my root password and turn on the mysql "service". Alternately, from the command line: arrakis ~ # arrakis ~ # /etc/init.d/mysql stop * Stopping mysql ... * Stopping mysqld (0) [ ok ] arrakis ~ # arrakis ~ # /etc/init.d/mysql start * Starting mysql ... * Starting mysql (/etc/mysql/ my.cnf) [ ok ] arrakis ~ # arrakis ~ # /etc/init.d/mysql restart * Stopping mysql ... * Stopping mysqld (0) [ ok ] * Starting mysql ... * Starting mysql (/etc/mysql/ my.cnf) [ ok ] arrakis ~ # -Thufir --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Tom Dellaringa wrote in post #595906:> Bill Walton wrote: >> Hi Tom, >> >> Without a little more info, I''m not sure how to direct you. MySQL should >> start when you start IR.exe. Plz say more. > > Thanks, I''m not sure what else to provide, but what I finally did was > this: > > C:\InstantRails\mysql\bin>mysql -u root > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 to server version: 5.0.27-community > > Then tried to go to my page, and it finally worked. > > I guess it wanted to know I was the root user? I thought it was supposed > to start at startup as you say.Thanks The above method perfectly connects with mysql. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.