Hello all, I''m a Ruby noobie, so please bear with me. I''ve recently switched to Ubuntu and have installed ruby using the package manager. I then installed gem, and used it to install rails and its dependencies. I ran the rails command to create a website. I used the generator to create a migration task and tried to run it with the following command. rake migrate --trace This produced the following trace: (in /home/wgant/user/ruby/HoshinWeb) ** Invoke migrate (first_time) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! Mysql::Error: Lost connection to MySQL server during query: SELECT version FROM schema_info /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:185:in `execute'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:337:in `select'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:180:in `select_one'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:306:in `current_version'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:323:in `current_version'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:387:in `irrelevant_migration?'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:329:in `migrate'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:327:in `migrate'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:294:in `up'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/activerecord/lib/active_record/migration.rb:285:in `migrate'' /home/wgant/user/ruby/HoshinWeb/config/../vendor/rails/railties/lib/tasks/databases.rake:4 /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `execute'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:387:in `execute'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:357:in `invoke'' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in `invoke'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:364:in `invoke_prerequisites''/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:999:in `each'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:363:in `invoke_prerequisites''/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:356:in `invoke'' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:350:in `invoke'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake.rb:1906:in `run'' /usr/lib/ruby/gems/1.8/gems/rake-0.7.1/bin/rake:7 /usr/bin/rake:18 I''ve set up my database correctly in the database.yml file using the same username and database name I use to connect with MySQL Administrator. The database is currently empty (no schema table or anything). Is this the problem or am I missing something else? Thanks, Will --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Will Gant wrote:> rake aborted! > Mysql::Error: Lost connection to MySQL server during query: SELECTDid you configure a database server in config/database.yml? Eric --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Yes. I have the following listed in my config file development: adapter: mysql database: MyWeb_dev username: root password: password host: localhost Any thoughts? This is the same info I use to connect to the database currently. Eric Anderson <eric-ANzg6odk14w@public.gmane.org> wrote: Will Gant wrote:> rake aborted! > Mysql::Error: Lost connection to MySQL server during query: SELECTDid you configure a database server in config/database.yml? Eric (What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Is there something special I need to do to the database to get it ready for migrations? I noticed that it is using a table to store the schema version. Such a table does not exist in my database. Will Gant <williamwgant-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: Yes. I have the following listed in my config file development: adapter: mysql database: MyWeb_dev username: root password: password host: localhost Any thoughts? This is the same info I use to connect to the database currently. Eric Anderson <eric-ANzg6odk14w@public.gmane.org> wrote: Will Gant wrote:> rake aborted! > Mysql::Error: Lost connection to MySQL server during query: SELECTDid you configure a database server in config/database.yml? Eric --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. --------------------------------- Get your email and more, right on the new Yahoo.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 -~----------~----~----~----~------~----~------~--~---
It will create it with the first migration. can you connect from command line? Craig On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote:> Is there something special I need to do to the database to get it > ready for migrations? I noticed that it is using a table to store the > schema version. Such a table does not exist in my database. > > Will Gant <williamwgant-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > Yes. I have the following listed in my config file > > development: > adapter: mysql > database: MyWeb_dev > username: root > password: password > host: localhost > > Any thoughts? This is the same info I use to connect to the > database currently. > > Eric Anderson <eric-ANzg6odk14w@public.gmane.org> wrote: > > Will Gant wrote: > > rake aborted! > > Mysql::Error: Lost connection to MySQL server during > query: SELECT > > Did you configure a database server in > config/database.yml? > > Eric > > > > ______________________________________________________ > All-new Yahoo! Mail - Fire up a more powerful email > and get things done faster. > > ______________________________________________________ > Get your email and more, right on the MailScanner has > detected a possible fraud attempt from > "us.rd.yahoo.com" claiming to benew Yahoo.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 -~----------~----~----~----~------~----~------~--~---
Yep. I can connect that way. However, now when I try to run rake migrate I get the following message No such file or directory - /tmp/mysql.sock This leads me to believe that something is configured incorrectly. Any thoughts? Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: It will create it with the first migration. can you connect from command line? Craig On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote:> Is there something special I need to do to the database to get it > ready for migrations? I noticed that it is using a table to store the > schema version. Such a table does not exist in my database. > > Will Gant wrote: > Yes. I have the following listed in my config file > > development: > adapter: mysql > database: MyWeb_dev > username: root > password: password > host: localhost > > Any thoughts? This is the same info I use to connect to the > database currently. > > Eric Anderson wrote: > > Will Gant wrote: > > rake aborted! > > Mysql::Error: Lost connection to MySQL server during > query: SELECT > > Did you configure a database server in > config/database.yml? > > Eric > > > > ______________________________________________________ > All-new Yahoo! Mail - Fire up a more powerful email > and get things done faster. > > ______________________________________________________ > Get your email and more, right on the MailScanner has > detected a possible fraud attempt from > "us.rd.yahoo.com" claiming to benew Yahoo.com > >(What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian --------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Does /tmp/mysqlsock exist? Are you on Macintosh? Linux? Windows? where is my.cnf? When you connect from command line, do you specify a port # ? i.e. 3306 On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote:> Yep. I can connect that way. However, now when I try to run > rake migrate > I get the following message > No such file or directory - /tmp/mysql.sock > > This leads me to believe that something is configured incorrectly. Any > thoughts? > > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > It will create it with the first migration. > > can you connect from command line? > > Craig > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > Is there something special I need to do to the database to > get it > > ready for migrations? I noticed that it is using a table to > store the > > schema version. Such a table does not exist in my database. > > > > Will Gant wrote: > > Yes. I have the following listed in my config file > > > > development: > > adapter: mysql > > database: MyWeb_dev > > username: root > > password: password > > host: localhost > > > > Any thoughts? This is the same info I use to connect to the > > database currently. > > > > Eric Anderson wrote: > > > > Will Gant wrote: > > > rake aborted! > > > Mysql::Error: Lost connection to MySQL server during > > query: SELECT > > > > Did you configure a database server in > > config/database.yml? > >--~--~---------~--~----~------------~-------~--~----~ 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''m on Ubuntu Linux and the file does not exist. I don''t specify a port or anything when I connect on the command line. Do you think I should re-install MySQL to see if that helps? Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: Does /tmp/mysqlsock exist? Are you on Macintosh? Linux? Windows? where is my.cnf? When you connect from command line, do you specify a port # ? i.e. 3306 On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote:> Yep. I can connect that way. However, now when I try to run > rake migrate > I get the following message > No such file or directory - /tmp/mysql.sock > > This leads me to believe that something is configured incorrectly. Any > thoughts? > > > Craig White wrote: > > It will create it with the first migration. > > can you connect from command line? > > Craig > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > Is there something special I need to do to the database to > get it > > ready for migrations? I noticed that it is using a table to > store the > > schema version. Such a table does not exist in my database. > > > > Will Gant wrote: > > Yes. I have the following listed in my config file > > > > development: > > adapter: mysql > > database: MyWeb_dev > > username: root > > password: password > > host: localhost > > > > Any thoughts? This is the same info I use to connect to the > > database currently. > > > > Eric Anderson wrote: > > > > Will Gant wrote: > > > rake aborted! > > > Mysql::Error: Lost connection to MySQL server during > > query: SELECT > > > > Did you configure a database server in > > config/database.yml? > >(What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian --------------------------------- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
The socket file being used when I connect via SQL Admin is /var/run/mysqld/mysqld.sock Is there a config file somewhere for ruby where this information could be stored incorrectly? Will Gant <williamwgant-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: I''m on Ubuntu Linux and the file does not exist. I don''t specify a port or anything when I connect on the command line. Do you think I should re-install MySQL to see if that helps? Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: Does /tmp/mysqlsock exist? Are you on Macintosh? Linux? Windows? where is my.cnf? When you connect from command line, do you specify a port # ? i.e. 3306 On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote:> Yep. I can connect that way. However, now when I try to run > rake migrate > I get the following message > No such file or directory - /tmp/mysql.sock > > This leads me to believe that something is configured incorrectly. Any > thoughts? > > > Craig White wrote: > > It will create it with the first migration. > > can you connect from command line? > > Craig > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > Is there something special I need to do to the database to > get it > > ready for migrations? I noticed that it is using a table to > store the > > schema version. Such a table does not exist in my database. > > > > Will Gant wrote: > > Yes. I have the following listed in my config file > > > > development: > > adapter: mysql > > database: MyWeb_dev > > username: root > > password: password > > host: localhost > > > > Any thoughts? This is the same info I use to connect to the > > database currently. > > > > Eric Anderson wrote: > > > > Will Gant wrote: > > > rake aborted! > > > Mysql::Error: Lost connection to MySQL server during > > query: SELECT > > > > Did you configure a database server in > > config/database.yml? > >--------------------------------- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. --------------------------------- Do you Yahoo!? Get on board. You''re invited to try the new Yahoo! Mail. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Include that in your database.yml file... socket: /var/run/mysqld/mysqld.sock Craig On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote:> The socket file being used when I connect via SQL Admin is > /var/run/mysqld/mysqld.sock > > Is there a config file somewhere for ruby where this information could > be stored incorrectly? > > Will Gant <williamwgant-/E1597aS9LQAvxtiuMwx3w@public.gmane.org> wrote: > I''m on Ubuntu Linux and the file does not exist. I don''t > specify a port or anything when I connect on the command line. > Do you think I should re-install MySQL to see if that helps? > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > Does /tmp/mysqlsock exist? Are you on Macintosh? > Linux? Windows? > > where is my.cnf? > > When you connect from command line, do you specify a > port # ? i.e. 3306 > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > Yep. I can connect that way. However, now when I try > to run > > rake migrate > > I get the following message > > No such file or directory - /tmp/mysql.sock > > > > This leads me to believe that something is > configured incorrectly. Any > > thoughts? > > > > > > Craig White wrote: > > > > It will create it with the first migration. > > > > can you connect from command line? > > > > Craig > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > Is there something special I need to do to the > database to > > get it > > > ready for migrations? I noticed that it is using a > table to > > store the > > > schema version. Such a table does not exist in my > database. > > > > > > Will Gant wrote: > > > Yes. I have the following listed in my config file > > > > > > development: > > > adapter: mysql > > > database: MyWeb_dev > > > username: root > > > password: password > > > host: localhost > > > > > > Any thoughts? This is the same info I use to > connect to the > > > database currently. > > > > > > Eric Anderson wrote: > > > > > > Will Gant wrote: > > > > rake aborted! > > > > Mysql::Error: Lost connection to MySQL server > during > > > query: SELECT > > > > > > Did you configure a database server in > > > config/database.yml? > > > > > > > > ______________________________________________________ > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > the US (and 30+ countries) for 2¢/min or less. > > ______________________________________________________ > Do you Yahoo!? > Get on board. You''re invited to try the new Yahoo! > Mail. > >--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Close.... Now it''s giving me the following error again: rake aborted! Mysql::Error: Lost connection to MySQL server during query: SELECT version FROM schema_info Will Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: Include that in your database.yml file... socket: /var/run/mysqld/mysqld.sock Craig On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote:> The socket file being used when I connect via SQL Admin is > /var/run/mysqld/mysqld.sock > > Is there a config file somewhere for ruby where this information could > be stored incorrectly? > > Will Gant wrote: > I''m on Ubuntu Linux and the file does not exist. I don''t > specify a port or anything when I connect on the command line. > Do you think I should re-install MySQL to see if that helps? > > Craig White wrote: > > Does /tmp/mysqlsock exist? Are you on Macintosh? > Linux? Windows? > > where is my.cnf? > > When you connect from command line, do you specify a > port # ? i.e. 3306 > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > Yep. I can connect that way. However, now when I try > to run > > rake migrate > > I get the following message > > No such file or directory - /tmp/mysql.sock > > > > This leads me to believe that something is > configured incorrectly. Any > > thoughts? > > > > > > Craig White wrote: > > > > It will create it with the first migration. > > > > can you connect from command line? > > > > Craig > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > Is there something special I need to do to the > database to > > get it > > > ready for migrations? I noticed that it is using a > table to > > store the > > > schema version. Such a table does not exist in my > database. > > > > > > Will Gant wrote: > > > Yes. I have the following listed in my config file > > > > > > development: > > > adapter: mysql > > > database: MyWeb_dev > > > username: root > > > password: password > > > host: localhost > > > > > > Any thoughts? This is the same info I use to > connect to the > > > database currently. > > > > > > Eric Anderson wrote: > > > > > > Will Gant wrote: > > > > rake aborted! > > > > Mysql::Error: Lost connection to MySQL server > during > > > query: SELECT > > > > > > Did you configure a database server in > > > config/database.yml? > > > > > > > > ______________________________________________________ > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > the US (and 30+ countries) for 2¢/min or less. > > ______________________________________________________ > Do you Yahoo!? > Get on board. You''re invited to try the new Yahoo! > Mail. > >--------------------------------- Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Could the new problem be related to this? http://dev.rubyonrails.org/ticket/4749 Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: Include that in your database.yml file... socket: /var/run/mysqld/mysqld.sock Craig On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote:> The socket file being used when I connect via SQL Admin is > /var/run/mysqld/mysqld.sock > > Is there a config file somewhere for ruby where this information could > be stored incorrectly? > > Will Gant wrote: > I''m on Ubuntu Linux and the file does not exist. I don''t > specify a port or anything when I connect on the command line. > Do you think I should re-install MySQL to see if that helps? > > Craig White wrote: > > Does /tmp/mysqlsock exist? Are you on Macintosh? > Linux? Windows? > > where is my.cnf? > > When you connect from command line, do you specify a > port # ? i.e. 3306 > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > Yep. I can connect that way. However, now when I try > to run > > rake migrate > > I get the following message > > No such file or directory - /tmp/mysql.sock > > > > This leads me to believe that something is > configured incorrectly. Any > > thoughts? > > > > > > Craig White wrote: > > > > It will create it with the first migration. > > > > can you connect from command line? > > > > Craig > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > Is there something special I need to do to the > database to > > get it > > > ready for migrations? I noticed that it is using a > table to > > store the > > > schema version. Such a table does not exist in my > database. > > > > > > Will Gant wrote: > > > Yes. I have the following listed in my config file > > > > > > development: > > > adapter: mysql > > > database: MyWeb_dev > > > username: root > > > password: password > > > host: localhost > > > > > > Any thoughts? This is the same info I use to > connect to the > > > database currently. > > > > > > Eric Anderson wrote: > > > > > > Will Gant wrote: > > > > rake aborted! > > > > Mysql::Error: Lost connection to MySQL server > during > > > query: SELECT > > > > > > Did you configure a database server in > > > config/database.yml? > > > > > > > > ______________________________________________________ > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > the US (and 30+ countries) for 2¢/min or less. > > ______________________________________________________ > Do you Yahoo!? > Get on board. You''re invited to try the new Yahoo! > Mail. > >(What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Why - are you editing environment.rb? Craig On Sat, 2006-09-09 at 19:16 -0700, Will Gant wrote:> Could the new problem be related to this? > > http://dev.rubyonrails.org/ticket/4749 > > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > Include that in your database.yml file... > > socket: /var/run/mysqld/mysqld.sock > > Craig > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > The socket file being used when I connect via SQL Admin is > > /var/run/mysqld/mysqld.sock > > > > Is there a config file somewhere for ruby where this > information could > > be stored incorrectly? > > > > Will Gant wrote: > > I''m on Ubuntu Linux and the file does not exist. I don''t > > specify a port or anything when I connect on the command > line. > > Do you think I should re-install MySQL to see if that helps? > > > > Craig White wrote: > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > Linux? Windows? > > > > where is my.cnf? > > > > When you connect from command line, do you specify a > > port # ? i.e. 3306 > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > Yep. I can connect that way. However, now when I try > > to run > > > rake migrate > > > I get the following message > > > No such file or directory - /tmp/mysql.sock > > > > > > This leads me to believe that something is > > configured incorrectly. Any > > > thoughts? > > > > > > > > > Craig White wrote: > > > > > > It will create it with the first migration. > > > > > > can you connect from command line? > > > > > > Craig > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > Is there something special I need to do to the > > database to > > > get it > > > > ready for migrations? I noticed that it is using a > > table to > > > store the > > > > schema version. Such a table does not exist in my > > database. > > > > > > > > Will Gant wrote: > > > > Yes. I have the following listed in my config file > > > > > > > > development: > > > > adapter: mysql > > > > database: MyWeb_dev > > > > username: root > > > > password: password > > > > host: localhost > > > > > > > > Any thoughts? This is the same info I use to > > connect to the > > > > database currently. > > > > > > > > Eric Anderson wrote: > > > > > > > > Will Gant wrote: > > > > > rake aborted! > > > > > Mysql::Error: Lost connection to MySQL server > > during > > > > query: SELECT > > > > > > > > Did you configure a database server in > > > > config/database.yml? > > > > > > > > > > > > > > ______________________________________________________ > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > the US (and 30+ countries) for 2¢/min or less. > > > > ______________________________________________________ > > Do you Yahoo!? > > Get on board. You''re invited to try the new Yahoo! > > Mail. > > > > > > > ______________________________________________________________ > All-new Yahoo! Mail - Fire up a more powerful email and get > things done faster. > >--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
did you ''gem install mysql'' ? (as root or via sudo?) Craig On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote:> Close.... > Now it''s giving me the following error again: > > rake aborted! > Mysql::Error: Lost connection to MySQL server during query: SELECT > version FROM schema_info > > Will > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > Include that in your database.yml file... > > socket: /var/run/mysqld/mysqld.sock > > Craig > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > The socket file being used when I connect via SQL Admin is > > /var/run/mysqld/mysqld.sock > > > > Is there a config file somewhere for ruby where this > information could > > be stored incorrectly? > > > > Will Gant wrote: > > I''m on Ubuntu Linux and the file does not exist. I don''t > > specify a port or anything when I connect on the command > line. > > Do you think I should re-install MySQL to see if that helps? > > > > Craig White wrote: > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > Linux? Windows? > > > > where is my.cnf? > > > > When you connect from command line, do you specify a > > port # ? i.e. 3306 > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > Yep. I can connect that way. However, now when I try > > to run > > > rake migrate > > > I get the following message > > > No such file or directory - /tmp/mysql.sock > > > > > > This leads me to believe that something is > > configured incorrectly. Any > > > thoughts? > > > > > > > > > Craig White wrote: > > > > > > It will create it with the first migration. > > > > > > can you connect from command line? > > > > > > Craig > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > Is there something special I need to do to the > > database to > > > get it > > > > ready for migrations? I noticed that it is using a > > table to > > > store the > > > > schema version. Such a table does not exist in my > > database. > > > > > > > > Will Gant wrote: > > > > Yes. I have the following listed in my config file > > > > > > > > development: > > > > adapter: mysql > > > > database: MyWeb_dev > > > > username: root > > > > password: password > > > > host: localhost > > > > > > > > Any thoughts? This is the same info I use to > > connect to the > > > > database currently. > > > > > > > > Eric Anderson wrote: > > > > > > > > Will Gant wrote: > > > > > rake aborted! > > > > > Mysql::Error: Lost connection to MySQL server > > during > > > > query: SELECT > > > > > > > > Did you configure a database server in > > > > config/database.yml? > > > > > > > > > > > > > > ______________________________________________________ > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > the US (and 30+ countries) for 2¢/min or less. > > > > ______________________________________________________ > > Do you Yahoo!? > > Get on board. You''re invited to try the new Yahoo! > > Mail. > > > > > > > ______________________________________________________________ > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail. > >--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
Apparently I overlooked that one. It''s giving me the following options. Which do I take? 1. mysql 2.7.1 (mswin32) 2. mysql 2.7 (ruby) 3. mysql 2.6 (ruby) 4. mysql 2.5.1 (ruby) 5. Cancel installation I would think #2, but I wanted to check before I did anything. I''m running MySQL 5.0. Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: did you ''gem install mysql'' ? (as root or via sudo?) Craig On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote:> Close.... > Now it''s giving me the following error again: > > rake aborted! > Mysql::Error: Lost connection to MySQL server during query: SELECT > version FROM schema_info > > Will > > Craig White wrote: > > Include that in your database.yml file... > > socket: /var/run/mysqld/mysqld.sock > > Craig > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > The socket file being used when I connect via SQL Admin is > > /var/run/mysqld/mysqld.sock > > > > Is there a config file somewhere for ruby where this > information could > > be stored incorrectly? > > > > Will Gant wrote: > > I''m on Ubuntu Linux and the file does not exist. I don''t > > specify a port or anything when I connect on the command > line. > > Do you think I should re-install MySQL to see if that helps? > > > > Craig White wrote: > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > Linux? Windows? > > > > where is my.cnf? > > > > When you connect from command line, do you specify a > > port # ? i.e. 3306 > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > Yep. I can connect that way. However, now when I try > > to run > > > rake migrate > > > I get the following message > > > No such file or directory - /tmp/mysql.sock > > > > > > This leads me to believe that something is > > configured incorrectly. Any > > > thoughts? > > > > > > > > > Craig White wrote: > > > > > > It will create it with the first migration. > > > > > > can you connect from command line? > > > > > > Craig > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > Is there something special I need to do to the > > database to > > > get it > > > > ready for migrations? I noticed that it is using a > > table to > > > store the > > > > schema version. Such a table does not exist in my > > database. > > > > > > > > Will Gant wrote: > > > > Yes. I have the following listed in my config file > > > > > > > > development: > > > > adapter: mysql > > > > database: MyWeb_dev > > > > username: root > > > > password: password > > > > host: localhost > > > > > > > > Any thoughts? This is the same info I use to > > connect to the > > > > database currently. > > > > > > > > Eric Anderson wrote: > > > > > > > > Will Gant wrote: > > > > > rake aborted! > > > > > Mysql::Error: Lost connection to MySQL server > > during > > > > query: SELECT > > > > > > > > Did you configure a database server in > > > > config/database.yml? > > > > > > > > > > > > > > ______________________________________________________ > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > the US (and 30+ countries) for 2¢/min or less. > > > > ______________________________________________________ > > Do you Yahoo!? > > Get on board. You''re invited to try the new Yahoo! > > Mail. > > > > > > > ______________________________________________________________ > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail. > >--------------------------------- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
2 sounds like the winner Craig On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote:> Apparently I overlooked that one. It''s giving me the following > options. Which do I take? > > 1. mysql 2.7.1 (mswin32) > 2. mysql 2.7 (ruby) > 3. mysql 2.6 (ruby) > 4. mysql 2.5.1 (ruby) > 5. Cancel installation > > > I would think #2, but I wanted to check before I did anything. I''m > running MySQL 5.0. > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > did you ''gem install mysql'' ? (as root or via sudo?) > > Craig > > On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote: > > Close.... > > Now it''s giving me the following error again: > > > > rake aborted! > > Mysql::Error: Lost connection to MySQL server during query: > SELECT > > version FROM schema_info > > > > Will > > > > Craig White wrote: > > > > Include that in your database.yml file... > > > > socket: /var/run/mysqld/mysqld.sock > > > > Craig > > > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > > The socket file being used when I connect via SQL Admin is > > > /var/run/mysqld/mysqld.sock > > > > > > Is there a config file somewhere for ruby where this > > information could > > > be stored incorrectly? > > > > > > Will Gant wrote: > > > I''m on Ubuntu Linux and the file does not exist. I don''t > > > specify a port or anything when I connect on the command > > line. > > > Do you think I should re-install MySQL to see if that > helps? > > > > > > Craig White wrote: > > > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > > Linux? Windows? > > > > > > where is my.cnf? > > > > > > When you connect from command line, do you specify a > > > port # ? i.e. 3306 > > > > > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > > Yep. I can connect that way. However, now when I try > > > to run > > > > rake migrate > > > > I get the following message > > > > No such file or directory - /tmp/mysql.sock > > > > > > > > This leads me to believe that something is > > > configured incorrectly. Any > > > > thoughts? > > > > > > > > > > > > Craig White wrote: > > > > > > > > It will create it with the first migration. > > > > > > > > can you connect from command line? > > > > > > > > Craig > > > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > > Is there something special I need to do to the > > > database to > > > > get it > > > > > ready for migrations? I noticed that it is using a > > > table to > > > > store the > > > > > schema version. Such a table does not exist in my > > > database. > > > > > > > > > > Will Gant wrote: > > > > > Yes. I have the following listed in my config file > > > > > > > > > > development: > > > > > adapter: mysql > > > > > database: MyWeb_dev > > > > > username: root > > > > > password: password > > > > > host: localhost > > > > > > > > > > Any thoughts? This is the same info I use to > > > connect to the > > > > > database currently. > > > > > > > > > > Eric Anderson wrote: > > > > > > > > > > Will Gant wrote: > > > > > > rake aborted! > > > > > > Mysql::Error: Lost connection to MySQL server > > > during > > > > > query: SELECT > > > > > > > > > > Did you configure a database server in > > > > > config/database.yml? > > > > > > > > > > > > > > > > > > > > ______________________________________________________ > > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > > the US (and 30+ countries) for 2¢/min or less. > > > > > > ______________________________________________________ > > > Do you Yahoo!? > > > Get on board. You''re invited to try the new Yahoo! > > > Mail. > > > > > > > > > > > > > ______________________________________________________________ > > Do you Yahoo!? > > Everyone is raving about the all-new Yahoo! Mail. > > > > > > > ______________________________________________________________ > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. > Great rates starting at 1¢/min. > >--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
I tried this:
sudo gem install mysql --include-dependencies
and got the following:
Building native extensions. This could take a while...
extconf.rb:1:in `require'': no such file to load -- mkmf (LoadError)
from extconf.rb:1
ERROR: While executing gem ... (RuntimeError)
ERROR: Failed to build gem native extension.
Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for
inspection.
Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
------
The file in question is empty.
Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote:
2 sounds like the winner
Craig
On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote:> Apparently I overlooked that one. It''s giving me the following
> options. Which do I take?
>
> 1. mysql 2.7.1 (mswin32)
> 2. mysql 2.7 (ruby)
> 3. mysql 2.6 (ruby)
> 4. mysql 2.5.1 (ruby)
> 5. Cancel installation
>
>
> I would think #2, but I wanted to check before I did anything. I''m
> running MySQL 5.0.
>
> Craig White wrote:
>
> did you ''gem install mysql'' ? (as root or via
sudo?)
>
> Craig
>
> On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote:
> > Close....
> > Now it''s giving me the following error again:
> >
> > rake aborted!
> > Mysql::Error: Lost connection to MySQL server during query:
> SELECT
> > version FROM schema_info
> >
> > Will
> >
> > Craig White wrote:
> >
> > Include that in your database.yml file...
> >
> > socket: /var/run/mysqld/mysqld.sock
> >
> > Craig
> >
> > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote:
> > > The socket file being used when I connect via SQL Admin
is
> > > /var/run/mysqld/mysqld.sock
> > >
> > > Is there a config file somewhere for ruby where this
> > information could
> > > be stored incorrectly?
> > >
> > > Will Gant wrote:
> > > I''m on Ubuntu Linux and the file does not exist.
I don''t
> > > specify a port or anything when I connect on the command
> > line.
> > > Do you think I should re-install MySQL to see if that
> helps?
> > >
> > > Craig White wrote:
> > >
> > > Does /tmp/mysqlsock exist? Are you on Macintosh?
> > > Linux? Windows?
> > >
> > > where is my.cnf?
> > >
> > > When you connect from command line, do you specify a
> > > port # ? i.e. 3306
> > >
> > >
> > >
> > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote:
> > > > Yep. I can connect that way. However, now when I try
> > > to run
> > > > rake migrate
> > > > I get the following message
> > > > No such file or directory - /tmp/mysql.sock
> > > >
> > > > This leads me to believe that something is
> > > configured incorrectly. Any
> > > > thoughts?
> > > >
> > > >
> > > > Craig White wrote:
> > > >
> > > > It will create it with the first migration.
> > > >
> > > > can you connect from command line?
> > > >
> > > > Craig
> > > >
> > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote:
> > > > > Is there something special I need to do to the
> > > database to
> > > > get it
> > > > > ready for migrations? I noticed that it is
using a
> > > table to
> > > > store the
> > > > > schema version. Such a table does not exist in
my
> > > database.
> > > > >
> > > > > Will Gant wrote:
> > > > > Yes. I have the following listed in my config
file
> > > > >
> > > > > development:
> > > > > adapter: mysql
> > > > > database: MyWeb_dev
> > > > > username: root
> > > > > password: password
> > > > > host: localhost
> > > > >
> > > > > Any thoughts? This is the same info I use to
> > > connect to the
> > > > > database currently.
> > > > >
> > > > > Eric Anderson wrote:
> > > > >
> > > > > Will Gant wrote:
> > > > > > rake aborted!
> > > > > > Mysql::Error: Lost connection to MySQL
server
> > > during
> > > > > query: SELECT
> > > > >
> > > > > Did you configure a database server in
> > > > > config/database.yml?
> > > > >
> > >
> > >
> > >
> > >
> > > ______________________________________________________
> > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to
> > > the US (and 30+ countries) for 2¢/min or less.
> > >
> > > ______________________________________________________
> > > Do you Yahoo!?
> > > Get on board. You''re invited to try the new
Yahoo!
> > > Mail.
> > > >
> >
> >
> >
> >
> ______________________________________________________________
> > Do you Yahoo!?
> > Everyone is raving about the all-new Yahoo! Mail.
> > >
>
>
>
> ______________________________________________________________
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.
> Great rates starting at 1¢/min.
> >
(What is best in life?) To crush your enemies, see them driven before you, and
to hear the lamentations of the women. - Conan the Barbarian
---------------------------------
Stay in the know. Pulse on the new Yahoo.com. Check it out.
--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---
On Fedora Core I''ve never had any luck using gem to install the Ruby MySql plugin. But it always works when I use yum (Fedora package manger). I suggest you track down the Ruby MySql package for your system and install it that way. Aaron On Sep 9, 2006, at 9:15 PM, Will Gant wrote:> I tried this: > sudo gem install mysql --include-dependencies > > and got the following: > > Building native extensions. This could take a while... > extconf.rb:1:in `require'': no such file to load -- mkmf (LoadError) > from extconf.rb:1 > > ERROR: While executing gem ... (RuntimeError) > ERROR: Failed to build gem native extension. > Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/ > mysql-2.7 for inspection. > > > Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out > ------ > > The file in question is empty. > > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > > 2 sounds like the winner > > Craig > > On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote: > > Apparently I overlooked that one. It''s giving me the following > > options. Which do I take? > > > > 1. mysql 2.7.1 (mswin32) > > 2. mysql 2.7 (ruby) > > 3. mysql 2.6 (ruby) > > 4. mysql 2.5.1 (ruby) > > 5. Cancel installation > > > > > > I would think #2, but I wanted to check before I did anything. I''m > > running MySQL 5.0. > > > > Craig White wrote: > > > > did you ''gem install mysql'' ? (as root or via sudo?) > > > > Craig > > > > On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote: > > > Close.... > > > Now it''s giving me the following error again: > > > > > > rake aborted! > > > Mysql::Error: Lost connection to MySQL server during query: > > SELECT > > > version FROM schema_info > > > > > > Will > > > > > > Craig White wrote: > > > > > > Include that in your database.yml file... > > > > > > socket: /var/run/mysqld/mysqld.sock > > > > > > Craig > > > > > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > > > The socket file being used when I connect via SQL Admin is > > > > /var/run/mysqld/mysqld.sock > > > > > > > > Is there a config file somewhere for ruby where this > > > information could > > > > be stored incorrectly? > > > > > > > > Will Gant wrote: > > > > I''m on Ubuntu Linux and the file does not exist. I don''t > > > > specify a port or anything when I connect on the command > > > line. > > > > Do you think I should re-install MySQL to see if that > > helps? > > > > > > > > Craig White wrote: > > > > > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > > > Linux? Windows? > > > > > > > > where is my.cnf? > > > > > > > > When you connect from command line, do you specify a > > > > port # ? i.e. 3306 > > > > > > > > > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > > > Yep. I can connect that way. However, now when I try > > > > to run > > > > > rake migrate > > > > > I get the following message > > > > > No such file or directory - /tmp/mysql.sock > > > > > > > > > > This leads me to believe that something is > > > > configured incorrectly. Any > > > > > thoughts? > > > > > > > > > > > > > > > Craig White wrote: > > > > > > > > > > It will create it with the first migration. > > > > > > > > > > can you connect from command line? > > > > > > > > > > Craig > > > > > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > > > Is there something special I need to do to the > > > > database to > > > > > get it > > > > > > ready for migrations? I noticed that it is using a > > > > table to > > > > > store the > > > > > > schema version. Such a table does not exist in my > > > > database. > > > > > > > > > > > > Will Gant wrote: > > > > > > Yes. I have the following listed in my config file > > > > > > > > > > > > development: > > > > > > adapter: mysql > > > > > > database: MyWeb_dev > > > > > > username: root > > > > > > password: password > > > > > > host: localhost > > > > > > > > > > > > Any thoughts? This is the same info I use to > > > > connect to the > > > > > > database currently. > > > > > > > > > > > > Eric Anderson wrote: > > > > > > > > > > > > Will Gant wrote: > > > > > > > rake aborted! > > > > > > > Mysql::Error: Lost connection to MySQL server > > > > during > > > > > > query: SELECT > > > > > > > > > > > > Did you configure a database server in > > > > > > config/database.yml? > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________ > > > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > > > the US (and 30+ countries) for 2¢/min or less. > > > > > > > > ______________________________________________________ > > > > Do you Yahoo!? > > > > Get on board. You''re invited to try the new Yahoo! > > > > Mail. > > > > > > > > > > > > > > > > > > > ______________________________________________________________ > > > Do you Yahoo!? > > > Everyone is raving about the all-new Yahoo! Mail. > > > > > > > > > > > > ______________________________________________________________ > > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. > > Great rates starting at 1¢/min. > > > > > > Stay in the know. Pulse on the new Yahoo.com. Check it out. > >--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
That fixed it. What a day!
Thanks to everyone for helping and putting up with me. I appreciate it.
Aaron Baldwin <baldwina-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: On
Fedora Core I''ve never had any luck using gem to install the Ruby MySql
plugin. But it always works when I use yum (Fedora package manger). I suggest
you track down the Ruby MySql package for your system and install it that way.
Aaron
On Sep 9, 2006, at 9:15 PM, Will Gant wrote:
I tried this:
sudo gem install mysql --include-dependencies
and got the following:
Building native extensions. This could take a while...
extconf.rb:1:in `require'': no such file to load -- mkmf (LoadError)
from extconf.rb:1
ERROR: While executing gem ... (RuntimeError)
ERROR: Failed to build gem native extension.
Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for
inspection.
Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out
------
The file in question is empty.
Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote:
2 sounds like the winner
Craig
On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote:> Apparently I overlooked that one. It''s giving me the following
> options. Which do I take?
>
> 1. mysql 2.7.1 (mswin32)
> 2. mysql 2.7 (ruby)
> 3. mysql 2.6 (ruby)
> 4. mysql 2.5.1 (ruby)
> 5. Cancel installation
>
>
> I would think #2, but I wanted to check before I did anything. I''m
> running MySQL 5.0.
>
> Craig White wrote:
>
> did you ''gem install mysql'' ? (as root or via
sudo?)
>
> Craig
>
> On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote:
> > Close....
> > Now it''s giving me the following error again:
> >
> > rake aborted!
> > Mysql::Error: Lost connection to MySQL server during query:
> SELECT
> > version FROM schema_info
> >
> > Will
> >
> > Craig White wrote:
> >
> > Include that in your database.yml file...
> >
> > socket: /var/run/mysqld/mysqld.sock
> >
> > Craig
> >
> > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote:
> > > The socket file being used when I connect via SQL Admin
is
> > > /var/run/mysqld/mysqld.sock
> > >
> > > Is there a config file somewhere for ruby where this
> > information could
> > > be stored incorrectly?
> > >
> > > Will Gant wrote:
> > > I''m on Ubuntu Linux and the file does not exist.
I don''t
> > > specify a port or anything when I connect on the command
> > line.
> > > Do you think I should re-install MySQL to see if that
> helps?
> > >
> > > Craig White wrote:
> > >
> > > Does /tmp/mysqlsock exist? Are you on Macintosh?
> > > Linux? Windows?
> > >
> > > where is my.cnf?
> > >
> > > When you connect from command line, do you specify a
> > > port # ? i.e. 3306
> > >
> > >
> > >
> > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote:
> > > > Yep. I can connect that way. However, now when I try
> > > to run
> > > > rake migrate
> > > > I get the following message
> > > > No such file or directory - /tmp/mysql.sock
> > > >
> > > > This leads me to believe that something is
> > > configured incorrectly. Any
> > > > thoughts?
> > > >
> > > >
> > > > Craig White wrote:
> > > >
> > > > It will create it with the first migration.
> > > >
> > > > can you connect from command line?
> > > >
> > > > Craig
> > > >
> > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote:
> > > > > Is there something special I need to do to the
> > > database to
> > > > get it
> > > > > ready for migrations? I noticed that it is
using a
> > > table to
> > > > store the
> > > > > schema version. Such a table does not exist in
my
> > > database.
> > > > >
> > > > > Will Gant wrote:
> > > > > Yes. I have the following listed in my config
file
> > > > >
> > > > > development:
> > > > > adapter: mysql
> > > > > database: MyWeb_dev
> > > > > username: root
> > > > > password: password
> > > > > host: localhost
> > > > >
> > > > > Any thoughts? This is the same info I use to
> > > connect to the
> > > > > database currently.
> > > > >
> > > > > Eric Anderson wrote:
> > > > >
> > > > > Will Gant wrote:
> > > > > > rake aborted!
> > > > > > Mysql::Error: Lost connection to MySQL
server
> > > during
> > > > > query: SELECT
> > > > >
> > > > > Did you configure a database server in
> > > > > config/database.yml?
> > > > >
> > >
> > >
> > >
> > >
> > > ______________________________________________________
> > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to
> > > the US (and 30+ countries) for 2¢/min or less.
> > >
> > > ______________________________________________________
> > > Do you Yahoo!?
> > > Get on board. You''re invited to try the new
Yahoo!
> > > Mail.
> > > >
> >
> >
> >
> >
> ______________________________________________________________
> > Do you Yahoo!?
> > Everyone is raving about the all-new Yahoo! Mail.
> > >
>
>
>
> ______________________________________________________________
> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.
> Great rates starting at 1¢/min.
> >
---------------------------------
Stay in the know. Pulse on the new Yahoo.com. Check it out.
(What is best in life?) To crush your enemies, see them driven before you, and
to hear the lamentations of the women. - Conan the Barbarian
---------------------------------
Stay in the know. Pulse on the new Yahoo.com. Check it out.
--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---
erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2006-Sep-26 22:21 UTC
Re: Can''t migrate schema -FIXED
Hi, I also have the same problem as you. Do you mind telling me how you fix it? I tried the gem install mysql but it doesn''t work. Thanks, Erwin Will Gant wrote:> That fixed it. What a day! > > Thanks to everyone for helping and putting up with me. I appreciate it. > > Aaron Baldwin <baldwina-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: On Fedora Core I''ve never had any luck using gem to install the Ruby MySql plugin. But it always works when I use yum (Fedora package manger). I suggest you track down the Ruby MySql package for your system and install it that way. > > > Aaron > > On Sep 9, 2006, at 9:15 PM, Will Gant wrote: > > I tried this: > sudo gem install mysql --include-dependencies > > and got the following: > > Building native extensions. This could take a while... > extconf.rb:1:in `require'': no such file to load -- mkmf (LoadError) > from extconf.rb:1 > > ERROR: While executing gem ... (RuntimeError) > ERROR: Failed to build gem native extension. > Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection. > > > Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out > ------ > > The file in question is empty. > > > Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: > 2 sounds like the winner > > Craig > > On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote: > > Apparently I overlooked that one. It''s giving me the following > > options. Which do I take? > > > > 1. mysql 2.7.1 (mswin32) > > 2. mysql 2.7 (ruby) > > 3. mysql 2.6 (ruby) > > 4. mysql 2.5.1 (ruby) > > 5. Cancel installation > > > > > > I would think #2, but I wanted to check before I did anything. I''m > > running MySQL 5.0. > > > > Craig White wrote: > > > > did you ''gem install mysql'' ? (as root or via sudo?) > > > > Craig > > > > On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote: > > > Close.... > > > Now it''s giving me the following error again: > > > > > > rake aborted! > > > Mysql::Error: Lost connection to MySQL server during query: > > SELECT > > > version FROM schema_info > > > > > > Will > > > > > > Craig White wrote: > > > > > > Include that in your database.yml file... > > > > > > socket: /var/run/mysqld/mysqld.sock > > > > > > Craig > > > > > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > > > The socket file being used when I connect via SQL Admin is > > > > /var/run/mysqld/mysqld.sock > > > > > > > > Is there a config file somewhere for ruby where this > > > information could > > > > be stored incorrectly? > > > > > > > > Will Gant wrote: > > > > I''m on Ubuntu Linux and the file does not exist. I don''t > > > > specify a port or anything when I connect on the command > > > line. > > > > Do you think I should re-install MySQL to see if that > > helps? > > > > > > > > Craig White wrote: > > > > > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > > > Linux? Windows? > > > > > > > > where is my.cnf? > > > > > > > > When you connect from command line, do you specify a > > > > port # ? i.e. 3306 > > > > > > > > > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > > > Yep. I can connect that way. However, now when I try > > > > to run > > > > > rake migrate > > > > > I get the following message > > > > > No such file or directory - /tmp/mysql.sock > > > > > > > > > > This leads me to believe that something is > > > > configured incorrectly. Any > > > > > thoughts? > > > > > > > > > > > > > > > Craig White wrote: > > > > > > > > > > It will create it with the first migration. > > > > > > > > > > can you connect from command line? > > > > > > > > > > Craig > > > > > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > > > Is there something special I need to do to the > > > > database to > > > > > get it > > > > > > ready for migrations? I noticed that it is using a > > > > table to > > > > > store the > > > > > > schema version. Such a table does not exist in my > > > > database. > > > > > > > > > > > > Will Gant wrote: > > > > > > Yes. I have the following listed in my config file > > > > > > > > > > > > development: > > > > > > adapter: mysql > > > > > > database: MyWeb_dev > > > > > > username: root > > > > > > password: password > > > > > > host: localhost > > > > > > > > > > > > Any thoughts? This is the same info I use to > > > > connect to the > > > > > > database currently. > > > > > > > > > > > > Eric Anderson wrote: > > > > > > > > > > > > Will Gant wrote: > > > > > > > rake aborted! > > > > > > > Mysql::Error: Lost connection to MySQL server > > > > during > > > > > > query: SELECT > > > > > > > > > > > > Did you configure a database server in > > > > > > config/database.yml? > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________ > > > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > > > the US (and 30+ countries) for 2¢/min or less. > > > > > > > > ______________________________________________________ > > > > Do you Yahoo!? > > > > Get on board. You''re invited to try the new Yahoo! > > > > Mail. > > > > > > > > > > > > > > > > > > > ______________________________________________________________ > > > Do you Yahoo!? > > > Everyone is raving about the all-new Yahoo! Mail. > > > > > > > > > > > > ______________________________________________________________ > > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. > > Great rates starting at 1¢/min. > > > > > > > --------------------------------- > Stay in the know. Pulse on the new Yahoo.com. Check it out. > > > > > > > (What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian > > --------------------------------- > Stay in the know. Pulse on the new Yahoo.com. Check it out. > --0-1776466192-1157861201=:16373 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: quoted-printable > X-Google-AttachSize: 8993 > > That fixed it. What a day!<br><br>Thanks to everyone for helping and putting up with me. I appreciate it.<br><br><b><i>Aaron Baldwin <baldwina@gmail.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <div>On Fedora Core I''ve never had any luck using gem to install the Ruby MySql plugin. But it always works when I use yum (Fedora package manger). I suggest you track down the Ruby MySql package for your system and install it that way.</div><div><br class="khtml-block-placeholder"></div><div>Aaron</div><br><div><div>On Sep 9, 2006, at 9:15 PM, Will Gant wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">I tried this:<br>sudo gem install mysql --include-dependencies<br><br> and got the following:<br><br>Building native extensions. This could take a while...<br>extconf.rb:1:in `require'': no such file to load -- mkmf > (LoadError)<br> from extconf.rb:1<br><br>ERROR: While executing gem ... (RuntimeError)<br> ERROR: Failed to build gem native extension.<br>Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection.<br><br><br>Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out<br>------<br><br>The file in question is empty.<br><br><br><b><i>Craig White <<a href="mailto:craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org">craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org</a>></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <br>2 sounds like the winner<br><br>Craig<br><br>On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote:<br>> Apparently I overlooked that one. It''s giving me the following<br>> options. Which do I take?<br>> <br>> 1. mysql 2.7.1 (mswin32)<br>> 2. mysql 2.7 (ruby)<br>> 3. mysql 2.6 (ruby)<br>> 4. mysql 2.5.1 > (ruby)<br>> 5. Cancel installation<br>> <br>> <br>> I would think #2, but I wanted to check before I did anything. I''m<br>> running MySQL 5.0.<br>> <br>> Craig White wrote:<br>> <br>> did you ''gem install mysql'' ? (as root or via sudo?)<br>> <br>> Craig<br>> <br>> On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote:<br>> > Close....<br>> > Now it''s giving me the following error again:<br>> > <br>> > rake aborted!<br>> > Mysql::Error: Lost connection to MySQL server during query:<br>> SELECT<br>> > version FROM schema_info<br>> > <br>> > Will<br>> > <br>> > Craig White wrote:<br>> > <br>> > Include that in your database.yml file...<br>> > <br>> > socket: > /var/run/mysqld/mysqld.sock<br>> > <br>> > Craig <br>> > <br>> > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote:<br>> > > The socket file being used when I connect via SQL Admin is<br>> > > /var/run/mysqld/mysqld.sock<br>> > > <br>> > > Is there a config file somewhere for ruby where this<br>> > information could<br>> > > be stored incorrectly?<br>> > > <br>> > > Will Gant wrote:<br>> > > I''m on Ubuntu Linux and the file does not exist. I don''t<br>> > > specify a port or anything when I connect on the command<br>> > line.<br>> > > Do you think I should re-install MySQL to see if that<br>> helps?<br>> > > <br>> > > Craig White wrote:<br>> > > <br>> > > > Does /tmp/mysqlsock exist? Are you on Macintosh?<br>> > > Linux? Windows?<br>> > > <br>> > > where is my.cnf?<br>> > > <br>> > > When you connect from command line, do you specify a<br>> > > port # ? i.e. 3306<br>> > > <br>> > > <br>> > > <br>> > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote:<br>> > > > Yep. I can connect that way. However, now when I try<br>> > > to run<br>> > > > rake migrate<br>> > > > I get the following message<br>> > > > No such file or directory - /tmp/mysql.sock<br>> > > > <br>> > > > This leads me to believe that something is<br>> > > configured incorrectly. Any<br>> > > > thoughts?<br>> > > > > <br>> > > > <br>> > > > Craig White wrote:<br>> > > > <br>> > > > It will create it with the first migration.<br>> > > > <br>> > > > can you connect from command line?<br>> > > > <br>> > > > Craig<br>> > > > <br>> > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote:<br>> > > > > Is there something special I need to do to the<br>> > > database to<br>> > > > get it<br>> > > > > ready for migrations? I noticed that it is using a<br>> > > table to<br>> > > > store the<br>> > > > > schema version. Such a table does not exist in my<br>> > > database.<br>> > > > > <br>> > > > > > Will Gant wrote:<br>> > > > > Yes. I have the following listed in my config file<br>> > > > > <br>> > > > > development:<br>> > > > > adapter: mysql<br>> > > > > database: MyWeb_dev<br>> > > > > username: root<br>> > > > > password: password<br>> > > > > host: localhost<br>> > > > > <br>> > > > > Any thoughts? This is the same info I use to<br>> > > connect to the<br>> > > > > database currently.<br>> > > > > <br>> > > > > Eric Anderson wrote:<br>> > > > > <br>> > > > > Will Gant wrote:<br>> > > > > > rake aborted!<br>> > > > > > Mysql::Error: > Lost connection to MySQL server<br>> > > during<br>> > > > > query: SELECT <br>> > > > > <br>> > > > > Did you configure a database server in<br>> > > > > config/database.yml?<br>> > > > > <br>> > > <br>> > > <br>> > > <br>> > > <br>> > > ______________________________________________________<br>> > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to<br>> > > the US (and 30+ countries) for 2¢/min or less.<br>> > > <br>> > > ______________________________________________________<br>> > > Do you Yahoo!?<br>> > > Get on board. You''re invited to try the new Yahoo!<br>> > > Mail.<br>> > > > <br>> > <br>> > > <br>> > <br>> ><br>> ______________________________________________________________<br>> > Do you Yahoo!?<br>> > Everyone is raving about the all-new Yahoo! Mail.<br>> > > <br>> <br>> <br>> <br>> ______________________________________________________________<br>> Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.<br>> Great rates starting at 1¢/min.<br>> > <br><br><br> <hr size="1">Stay in the know. Pulse on the new Yahoo.com. <a href="http://us.rd.yahoo.com/evt=42974/*http://www.yahoo.com/preview"> Check it out.</a> <br> <br> <hr size=1>Stay in the know. Pulse on the new Yahoo.com. <a href="http://us.rd.yahoo.com/evt=42974/*http://www.yahoo.com/preview"> Check it out.</a> > > --0-1776466192-1157861201=:16373----~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
I didn''t use gem to install the extension. Rather, I used the Synaptic Package Manager. Will "erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org" <erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: Hi, I also have the same problem as you. Do you mind telling me how you fix it? I tried the gem install mysql but it doesn''t work. Thanks, Erwin Will Gant wrote:> That fixed it. What a day! > > Thanks to everyone for helping and putting up with me. I appreciate it. > > Aaron Baldwin wrote: On Fedora Core I''ve never had any luck using gem to install the Ruby MySql plugin. But it always works when I use yum (Fedora package manger). I suggest you track down the Ruby MySql package for your system and install it that way. > > > Aaron > > On Sep 9, 2006, at 9:15 PM, Will Gant wrote: > > I tried this: > sudo gem install mysql --include-dependencies > > and got the following: > > Building native extensions. This could take a while... > extconf.rb:1:in `require'': no such file to load -- mkmf (LoadError) > from extconf.rb:1 > > ERROR: While executing gem ... (RuntimeError) > ERROR: Failed to build gem native extension. > Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection. > > > Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out > ------ > > The file in question is empty. > > > Craig White wrote: > 2 sounds like the winner > > Craig > > On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote: > > Apparently I overlooked that one. It''s giving me the following > > options. Which do I take? > > > > 1. mysql 2.7.1 (mswin32) > > 2. mysql 2.7 (ruby) > > 3. mysql 2.6 (ruby) > > 4. mysql 2.5.1 (ruby) > > 5. Cancel installation > > > > > > I would think #2, but I wanted to check before I did anything. I''m > > running MySQL 5.0. > > > > Craig White wrote: > > > > did you ''gem install mysql'' ? (as root or via sudo?) > > > > Craig > > > > On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote: > > > Close.... > > > Now it''s giving me the following error again: > > > > > > rake aborted! > > > Mysql::Error: Lost connection to MySQL server during query: > > SELECT > > > version FROM schema_info > > > > > > Will > > > > > > Craig White wrote: > > > > > > Include that in your database.yml file... > > > > > > socket: /var/run/mysqld/mysqld.sock > > > > > > Craig > > > > > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > > > The socket file being used when I connect via SQL Admin is > > > > /var/run/mysqld/mysqld.sock > > > > > > > > Is there a config file somewhere for ruby where this > > > information could > > > > be stored incorrectly? > > > > > > > > Will Gant wrote: > > > > I''m on Ubuntu Linux and the file does not exist. I don''t > > > > specify a port or anything when I connect on the command > > > line. > > > > Do you think I should re-install MySQL to see if that > > helps? > > > > > > > > Craig White wrote: > > > > > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > > > Linux? Windows? > > > > > > > > where is my.cnf? > > > > > > > > When you connect from command line, do you specify a > > > > port # ? i.e. 3306 > > > > > > > > > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > > > Yep. I can connect that way. However, now when I try > > > > to run > > > > > rake migrate > > > > > I get the following message > > > > > No such file or directory - /tmp/mysql.sock > > > > > > > > > > This leads me to believe that something is > > > > configured incorrectly. Any > > > > > thoughts? > > > > > > > > > > > > > > > Craig White wrote: > > > > > > > > > > It will create it with the first migration. > > > > > > > > > > can you connect from command line? > > > > > > > > > > Craig > > > > > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > > > Is there something special I need to do to the > > > > database to > > > > > get it > > > > > > ready for migrations? I noticed that it is using a > > > > table to > > > > > store the > > > > > > schema version. Such a table does not exist in my > > > > database. > > > > > > > > > > > > Will Gant wrote: > > > > > > Yes. I have the following listed in my config file > > > > > > > > > > > > development: > > > > > > adapter: mysql > > > > > > database: MyWeb_dev > > > > > > username: root > > > > > > password: password > > > > > > host: localhost > > > > > > > > > > > > Any thoughts? This is the same info I use to > > > > connect to the > > > > > > database currently. > > > > > > > > > > > > Eric Anderson wrote: > > > > > > > > > > > > Will Gant wrote: > > > > > > > rake aborted! > > > > > > > Mysql::Error: Lost connection to MySQL server > > > > during > > > > > > query: SELECT > > > > > > > > > > > > Did you configure a database server in > > > > > > config/database.yml? > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________ > > > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > > > the US (and 30+ countries) for 2¢/min or less. > > > > > > > > ______________________________________________________ > > > > Do you Yahoo!? > > > > Get on board. You''re invited to try the new Yahoo! > > > > Mail. > > > > > > > > > > > > > > > > > > > ______________________________________________________________ > > > Do you Yahoo!? > > > Everyone is raving about the all-new Yahoo! Mail. > > > > > > > > > > > > ______________________________________________________________ > > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. > > Great rates starting at 1¢/min. > > > > > > > --------------------------------- > Stay in the know. Pulse on the new Yahoo.com. Check it out. > > > > > > > (What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian > > --------------------------------- > Stay in the know. Pulse on the new Yahoo.com. Check it out. > --0-1776466192-1157861201=:16373 > Content-Type: text/html; charset=iso-8859-1 > Content-Transfer-Encoding: quoted-printable > X-Google-AttachSize: 8993 > > That fixed it. What a day!Thanks to everyone for helping and putting up with me. I appreciate it. Aaron Baldwin <baldwina-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: On Fedora Core I''ve never had any luck using gem to install the Ruby MySql plugin. But it always works when I use yum (Fedora package manger). I suggest you track down the Ruby MySql package for your system and install it that way. Aaron On Sep 9, 2006, at 9:15 PM, Will Gant wrote: I tried this: sudo gem install mysql --include-dependencies and got the following: Building native extensions. This could take a while... extconf.rb:1:in `require'': no such file to load -- mkmf> (LoadError)from extconf.rb:1 ERROR: While executing gem ... (RuntimeError) ERROR: Failed to build gem native extension. Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/mysql-2.7 for inspection. Results logged to /usr/lib/ruby/gems/1.8/gems/mysql-2.7/gem_make.out ------ The file in question is empty. Craig White <craigwhite-BQ75lA0ptkhBDgjK7y7TUQ@public.gmane.org> wrote: 2 sounds like the winner Craig On Sat, 2006-09-09 at 19:48 -0700, Will Gant wrote:> Apparently I overlooked that one. It''s giving me the following > options. Which do I take? > > 1. mysql 2.7.1 (mswin32) > 2. mysql 2.7 (ruby) > 3. mysql 2.6 (ruby) > 4. mysql 2.5.1 > (ruby) > 5. Cancel installation > > > I would think #2, but I wanted to check before I did anything. I''m > running MySQL 5.0. > > Craig White wrote: > > did you ''gem install mysql'' ? (as root or via sudo?) > > Craig > > On Sat, 2006-09-09 at 19:13 -0700, Will Gant wrote: > > Close.... > > Now it''s giving me the following error again: > > > > rake aborted! > > Mysql::Error: Lost connection to MySQL server during query: > SELECT > > version FROM schema_info > > > > Will > > > > Craig White wrote: > > > > Include that in your database.yml file... > > > > socket: > /var/run/mysqld/mysqld.sock > > > > Craig > > > > On Sat, 2006-09-09 at 17:26 -0700, Will Gant wrote: > > > The socket file being used when I connect via SQL Admin is > > > /var/run/mysqld/mysqld.sock > > > > > > Is there a config file somewhere for ruby where this > > information could > > > be stored incorrectly? > > > > > > Will Gant wrote: > > > I''m on Ubuntu Linux and the file does not exist. I don''t > > > specify a port or anything when I connect on the command > > line. > > > Do you think I should re-install MySQL to see if that > helps? > > > > > > Craig White wrote: > > > > > > > Does /tmp/mysqlsock exist? Are you on Macintosh? > > > Linux? Windows? > > > > > > where is my.cnf? > > > > > > When you connect from command line, do you specify a > > > port # ? i.e. 3306 > > > > > > > > > > > > On Sat, 2006-09-09 at 15:28 -0700, Will Gant wrote: > > > > Yep. I can connect that way. However, now when I try > > > to run > > > > rake migrate > > > > I get the following message > > > > No such file or directory - /tmp/mysql.sock > > > > > > > > This leads me to believe that something is > > > configured incorrectly. Any > > > > thoughts? > > > > > > > > > > > > > Craig White wrote: > > > > > > > > It will create it with the first migration. > > > > > > > > can you connect from command line? > > > > > > > > Craig > > > > > > > > On Sat, 2006-09-09 at 14:15 -0700, Will Gant wrote: > > > > > Is there something special I need to do to the > > > database to > > > > get it > > > > > ready for migrations? I noticed that it is using a > > > table to > > > > store the > > > > > schema version. Such a table does not exist in my > > > database. > > > > > > > > > > > Will Gant wrote: > > > > > Yes. I have the following listed in my config file > > > > > > > > > > development: > > > > > adapter: mysql > > > > > database: MyWeb_dev > > > > > username: root > > > > > password: password > > > > > host: localhost > > > > > > > > > > Any thoughts? This is the same info I use to > > > connect to the > > > > > database currently. > > > > > > > > > > Eric Anderson wrote: > > > > > > > > > > Will Gant wrote: > > > > > > rake aborted! > > > > > > Mysql::Error: > Lost connection to MySQL server > > > during > > > > > query: SELECT > > > > > > > > > > Did you configure a database server in > > > > > config/database.yml? > > > > > > > > > > > > > > > > > > > > ______________________________________________________ > > > Yahoo! Messenger with Voice. Make PC-to-Phone Calls to > > > the US (and 30+ countries) for 2¢/min or less. > > > > > > ______________________________________________________ > > > Do you Yahoo!? > > > Get on board. You''re invited to try the new Yahoo! > > > Mail. > > > > > > > > > > > > > > ______________________________________________________________ > > Do you Yahoo!? > > Everyone is raving about the all-new Yahoo! Mail. > > > > > > > ______________________________________________________________ > Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. > Great rates starting at 1¢/min. > >--------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out. --------------------------------- Stay in the know. Pulse on the new Yahoo.com. Check it out.> > --0-1776466192-1157861201=:16373----------------------------------- Sneak preview the all-new Yahoo.com. It''s not radically different. Just radically better. --~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk -~----------~----~----~----~------~----~------~--~---
erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2006-Sep-26 22:30 UTC
Re: Can''t migrate schema -FIXED
Hi, I should''ve tried harder before posting a question. Fixed it with "sudo apt-get install libmysql-ruby". Thanks, Erwin --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
No problem man. Just out of curiousity, what distro are you using? "erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org" <erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: Hi, I should''ve tried harder before posting a question. Fixed it with "sudo apt-get install libmysql-ruby". Thanks, Erwin (What is best in life?) To crush your enemies, see them driven before you, and to hear the lamentations of the women. - Conan the Barbarian --------------------------------- Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
erwin.gosal-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2006-Sep-29 16:25 UTC
Re: Can''t migrate schema -FIXED
ubuntu dapper drake --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---