Hi, I''m new user to ruby on rails. I followed one tutorial but it is giving error while database connectivity. The error is: No connection could be made because the target machine actively refused it. - connect(2) my database.yml file is as follows. I''m trying to access MySql remotely. development: adapter: mysql database: cookbook username: poonam password:poonam host: web test: adapter: mysql database: cookbook username: poonam password:poonam host: web production: adapter: mysql database: cookbook username: poonam password: poonam host:web -- 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 -~----------~----~----~----~------~----~------~--~---
have you set your hosts file? I''m asking this because you need a name resolution for you host, since you''re using host: web. Instead you can try using host: ip. On 8/28/06, poonam <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > > > Hi, > > I''m new user to ruby on rails. I followed one tutorial but it is giving > error while database connectivity. The error is: > > No connection could be made because the target machine actively refused > it. - connect(2) > > > my database.yml file is as follows. I''m trying to access MySql remotely. > > development: > adapter: mysql > database: cookbook > username: poonam > password:poonamhost: web <---- HERE test:> adapter: mysql > database: cookbook > username: poonam > password:poonam > host: web <---- HERE > > production: > adapter: mysql > database: cookbook > username: poonam > password: poonamhost:web <---- HERE> > -- > Posted via http://www.ruby-forum.com/. > > > >-- WINDOWS: "Where do you want to go today?" LINUX: "Where do you want to go tomorrow?" BSD: "Are you guys coming or what?" --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
> --I done like u said. But no luck. The error is same. -- 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 -~----------~----~----~----~------~----~------~--~---
Strange... What OS are you running? On 8/28/06, poonam <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > > > -- > I done like u said. But no luck. The error is same. > > -- > 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 -~----------~----~----~----~------~----~------~--~---
Filipe Rocha wrote:> Strange... > What OS are you running?Windows server 2003 -- 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 -~----------~----~----~----~------~----~------~--~---
Maybe the firewall is blocking connections to database system (which one?) . maybe you missspelled your IP on database.yml. Did you install the ruby connector to the database? These are all the things I can remember. I would approach it by: 1. confirm that the database is running 2. confirm that the firewall is not blocking connections 3. double check the database IP @ database.yml . 4. check if I had the database connector if not install it from the gems. 5. try again This would be my umble approach. :) -- WINDOWS: "Where do you want to go today?" LINUX: "Where do you want to go tomorrow?" BSD: "Are you guys coming or what?" --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Filipe Rocha wrote:> Maybe the firewall is blocking connections to database system (which > one?) . maybe you missspelled your IP on database.yml. Did you install > the ruby connector to the database? > These are all the things I can remember. > I would approach it by: > 1. confirm that the database is running > 2. confirm that the firewall is not blocking connections > 3. double check the database IP @ database.yml . > 4. check if I had the database connector if not install it from the > gems. >From where I get that database connector? -- 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 -~----------~----~----~----~------~----~------~--~---
poonam wrote:> Filipe Rocha wrote: >> Maybe the firewall is blocking connections to database system (which >> one?) . maybe you missspelled your IP on database.yml. Did you install >> the ruby connector to the database? >> These are all the things I can remember. >> I would approach it by: >> 1. confirm that the database is running >> 2. confirm that the firewall is not blocking connections >> 3. double check the database IP @ database.yml . >> 4. check if I had the database connector if not install it from the >> gems.> From where I get that database connector?I''m using MySql database. -- 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 -~----------~----~----~----~------~----~------~--~---
Hi, you need a accurate Ip or hostname. what is "host: web" ??? poonam schrieb:> > Hi, > > I''m new user to ruby on rails. I followed one tutorial but it is giving > error while database connectivity. The error is: > > No connection could be made because the target machine actively refused > it. - connect(2) > > > my database.yml file is as follows. I''m trying to access MySql remotely. > > development: > adapter: mysql > database: cookbook > username: poonam > password:poonam > host: web > > test: > adapter: mysql > database: cookbook > username: poonam > password:poonam > host: web > > production: > adapter: mysql > database: cookbook > username: poonam > password: poonam > host:web > >--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
poonam wrote:> poonam wrote: > >> Filipe Rocha wrote: >> >>> Maybe the firewall is blocking connections to database system (which >>> one?) . maybe you missspelled your IP on database.yml. Did you install >>> the ruby connector to the database? >>> These are all the things I can remember. >>> I would approach it by: >>> 1. confirm that the database is running >>> 2. confirm that the firewall is not blocking connections >>> 3. double check the database IP @ database.yml . >>> 4. check if I had the database connector if not install it from the >>> gems. >>> > > >> From where I get that database connector? >> > I''m using MySql database. > >If you''re just starting out with Rails and you''re on Windows, consider using InstantRails (just google it) to help you get started! Cheers Mohit. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Alexander Klaiber wrote:> Hi, > > you need a accurate Ip or hostname. > > what is "host: web" ???"host:web" here web is hostname. -- 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 -~----------~----~----~----~------~----~------~--~---
Mohit Sindhwani wrote:> poonam wrote: >>>> 2. confirm that the firewall is not blocking connections >> > If you''re just starting out with Rails and you''re on Windows, consider > using InstantRails (just google it) to help you get started! > Cheers > Mohit.I tried the InstantRails now it is giving error: #28000Access denied for user ''poonam''@''DEV-116'' (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 -~----------~----~----~----~------~----~------~--~---
On 8/29/06, poonam <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Mohit Sindhwani wrote: > > poonam wrote: > >>>> 2. confirm that the firewall is not blocking connections > >> > > If you''re just starting out with Rails and you''re on Windows, consider > > using InstantRails (just google it) to help you get started! > > Cheers > > Mohit. > > I tried the InstantRails now it is giving error: > > #28000Access denied for user ''poonam''@''DEV-116'' (using password: NO)try username: root password:> > -- > Posted via http://www.ruby-forum.com/. > > > >-- WINDOWS: "Where do you want to go today?" LINUX: "Where do you want to go tomorrow?" BSD: "Are you guys coming or what?" --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
poonam wrote:> Mohit Sindhwani wrote: >> poonam wrote: >>>>> 2. confirm that the firewall is not blocking connections >>> >> If you''re just starting out with Rails and you''re on Windows, consider >> using InstantRails (just google it) to help you get started! >> Cheers >> Mohit.yes.......that InstantRails is working....... Thanks. poonam -- 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 -~----------~----~----~----~------~----~------~--~---