Yet another MySQL issue on WinXP

Discussion in 'Ruby' started by Perdikis Perdikis, Aug 1, 2009.

  1. I know that my questions will NOT be answered even thogh are pretty
    simple for some guru guys like you..

    I hope is posted in the correct section..


    Like a classic n00b I followed a video tutorial to install ruby, rails,
    gem etc..Is the classic tutorial by Kevin Skoglund..

    He teaches it in his MAC so some things are a bit different there..

    In a step he installs MySQL and somehow he connects it to Ruby!

    I could not even write in CMD mysql -version and get an answer.. Finally
    I did it by reading another topic in the forum..

    But I still get error when I try to browse my project..
    "We're sorry, but something went wrong."
    "We've been notified about this issue and we'll take a look at it
    shortly."

    I attached the development log..

    It says something about sqlite.. Probably it tries to find something
    different than mysql?

    How to I make knows that it needs mysql?


    I am curious if someone can make a noob like me to get this work!

    Good luck!

    Attachments:
    http://www.ruby-forum.com/attachment/3921/log.txt

    --
    Posted via http://www.ruby-forum.com/.
     
    Perdikis Perdikis, Aug 1, 2009
    #1
    1. Advertising

  2. Perdikis Perdikis

    James Coglan Guest

    [Note: parts of this message were removed to make it a legal post.]

    > I attached the development log..
    >
    > It says something about sqlite.. Probably it tries to find something
    > different than mysql?
    >
    > How to I make knows that it needs mysql?




    If you're using mysql, you should have the following in your
    config/database.yml:

    development:
    adapter: mysql
    server: localhost
    user: [your username]
    password: [your password]
    database: [database name]

    Rails uses sqlite3 by default so if you don't have it your app won't start
    properly.

    --
    James Coglan
    http://jcoglan.com
     
    James Coglan, Aug 1, 2009
    #2
    1. Advertising

  3. I just recreate a new my_app project like this..

    rails my_app -d mysql

    So in the database.yml was those..

    # MySQL. Versions 4.1 and 5.0 are recommended.
    #
    # Install the MySQL driver:
    # gem install mysql
    # On Mac OS X:
    # sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql
    # On Mac OS X Leopard:
    # sudo env ARCHFLAGS="-arch i386" gem install mysql --
    --with-mysql-config=/usr/local/mysql/bin/mysql_config
    # This sets the ARCHFLAGS environment variable to your native
    architecture
    # On Windows:
    # gem install mysql
    # Choose the win32 build.
    # Install MySQL and put its /bin directory on your path.
    #
    # And be sure to use new-style password hashing:
    # http://dev.mysql.com/doc/refman/5.0/en/old-client.html
    development:
    adapter: mysql
    encoding: utf8
    reconnect: false
    database: my_app_dev
    pool: 5
    username: root
    password:
    host: localhost

    # Warning: The database defined as "test" will be erased and
    # re-generated from your development database when you run "rake".
    # Do not set this db to the same as development or production.
    test:
    adapter: mysql
    encoding: utf8
    reconnect: false
    database: my_app_test
    pool: 5
    username: root
    password:
    host: localhost

    production:
    adapter: mysql
    encoding: utf8
    reconnect: false
    database: my_app_production
    pool: 5
    username: root
    password:
    host: localhost

    I just set a password and the database I made it "test"..

    I think I am missing something on the comments that says about mysql
    installation on windows..

    "#Install MySQL and put its /bin directory on your path."

    It means to put the "D:\Program Files\MySQL\MySQL Server 5.1\bin" in
    what path?

    THanks!

    PS I attached a new log that may helps!

    Attachments:
    http://www.ruby-forum.com/attachment/3922/log2.txt

    --
    Posted via http://www.ruby-forum.com/.
     
    Perdikis Perdikis, Aug 1, 2009
    #3
  4. Let me notice some things that may are not right..

    THose are my install dirs..

    D:\Ruby
    D:\Gems
    D:\Sites
    D:\Program Files\MySQL



    Thanx!
    --
    Posted via http://www.ruby-forum.com/.
     
    Perdikis Perdikis, Aug 1, 2009
    #4
  5. Perdikis Perdikis

    Luis Lavena Guest

    On Aug 1, 10:16 am, Perdikis Perdikis <> wrote:
    > I know that my questions will NOT be answered even thogh are pretty
    > simple for some guru guys like you..
    >
    > I hope is posted in the correct section..
    >
    > Like a classic n00b I followed a video tutorial to install ruby, rails,
    > gem etc..Is the classic tutorial by Kevin Skoglund..
    >
    > He teaches it in his MAC so some things are a bit different there..
    >
    > In a step he installs MySQL and somehow he connects it to Ruby!
    >
    > I could not even write in CMD mysql -version and get an answer.. Finally
    > I did it by reading another topic in the forum..
    >
    > But I still get error when I try to browse my project..
    > "We're sorry, but something went wrong."
    > "We've been notified about this issue and we'll take a look at it
    > shortly."
    >
    > I attached the development log..
    >
    > It says something about sqlite.. Probably it tries to find something
    > different than mysql?
    >
    > How to I make knows that it needs mysql?
    >
    > I am curious if someone can make a noob like me to get this work!
    >


    Please follow this tutorial:

    http://blog.mmediasys.com/2009/07/06/getting-started-with-rails-and-mysql/

    has been created for people getting started with Ruby and Rails on
    Windows.

    Also, you need to use MySQL 5.0, not 5.1, since the mysql Ruby
    bindings are going to fail, read the post details.

    HTH,
    --
    Luis Lavena
     
    Luis Lavena, Aug 1, 2009
    #5
  6. Perdikis Perdikis, Aug 1, 2009
    #6
  7. Hello again!


    I just wanted to say thank you one more time!

    I followed the link and everything was so clear! I managed to get it
    work!


    Thank you!
    --
    Posted via http://www.ruby-forum.com/.
     
    Mits Beucannon, Aug 1, 2009
    #7
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. volcovcommander

    yet another http 1.1 100 continue issue

    volcovcommander, Oct 31, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    700
    volcovcommander
    Oct 31, 2005
  2. Si
    Replies:
    22
    Views:
    813
    Toby Inkster
    Feb 16, 2005
  3. Berehem
    Replies:
    4
    Views:
    562
    Lawrence Kirby
    Apr 28, 2005
  4. Yet another pointer issue!!

    , Jun 6, 2006, in forum: C Programming
    Replies:
    4
    Views:
    251
    John Bode
    Jun 7, 2006
  5. Manu Sankala

    Yet another rounding issue

    Manu Sankala, Feb 21, 2010, in forum: Ruby
    Replies:
    3
    Views:
    113
    Manu Sankala
    Feb 21, 2010
Loading...

Share This Page