Forum: Ruby on Rails RoR Not Selecting Database

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
289399fbee544494fa22c697194139fa?d=identicon&s=25 Matthew Hinton (mhinton)
on 2005-11-23 15:19
I am trying to setup RoR and I appear to have everything setup
correctly but I am getting a db error.  I am on Mac OS X and I am using
MySQL 5 for my database.  I setup my database.yml and my model and
controller.  I can put an index method in my controller and display
some text.  When I replace my index method with


model :recipe
scaffold :recipe


I get an ActiveRecord::InvalidStatement error.  No database selected
when rails trys to run the "SELECT COUNT(*) FROM recipes" query.


In my MySQL query log I can see the "SELECT COUNT(*) FROM recipes"
query so connecting to the database is no problem.  It seems like rails
isn't issuing a "use recipes" statement before issuing the query.  I
spent an entire day trying to get everything setup correctly over the
weekend and I am stumped as to how to fix this.


Any help would be greatly appreciated thanks.
Ef4d1b20eba4b45b4a477c33bae1d156?d=identicon&s=25 ksibilev (Guest)
on 2005-11-25 05:00
(Received via mailing list)
It must be your mysql extension. Make sure that you have native mysql
extension installed.

http://raa.ruby-lang.org/project/mysql-ruby/

Kent.
289399fbee544494fa22c697194139fa?d=identicon&s=25 Matthew Hinton (mhinton)
on 2005-11-26 21:00
ksibilev wrote:
> It must be your mysql extension. Make sure that you have native mysql
> extension installed.
>
> http://raa.ruby-lang.org/project/mysql-ruby/
>
> Kent.

I issued the following command and got the following output and I still
have the same problem.

Matt@Bender:~$ sudo gem install mysql -- --with-mysql-config
Password:
Attempting local installation of 'mysql'
Local gem file not found: mysql*.gem
Attempting remote installation of 'mysql'
Updating Gem source index for: http://gems.rubyforge.org
Building native extensions.  This could take a while...
In file included from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:74:3: error: #error ---->>
ruby requires sizeof(void*) == sizeof(long) to be compiled. <<----
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:670:21: error: missing.h: No
such file or directory
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:671:20: error: intern.h: No
such file or directory
In file included from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:682: error: parse error
before 'rb_nativethread_t'
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:682: warning: data definition
has no type or storage class
mysql.c:6:21: error: version.h: No such file or directory
make: *** [mysql.o] Error 1
In file included from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:74:3: error: #error ---->>
ruby requires sizeof(void*) == sizeof(long) to be compiled. <<----
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:670:21: error: missing.h: No
such file or directory
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:671:20: error: intern.h: No
such file or directory
In file included from mysql.c:5:
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:682: error: parse error
before 'rb_nativethread_t'
/usr/lib/ruby/1.8/powerpc-darwin8.0/ruby.h:682: warning: data definition
has no type or storage class
mysql.c:6:21: error: version.h: No such file or directory
make: *** [mysql.o] Error 1
ruby extconf.rb install mysql -- --with-mysql-config
checking for mysql_ssl_set()... yes
checking for mysql.h... yes
creating Makefile

make
gcc -fno-common  -arch ppc -g -Os -pipe -fno-common  -arch ppc -pipe
-pipe -fno-common  -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0
-I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_SSL_SET
-DHAVE_MYSQL_H  -I/usr/local/mysql/include -Os -arch ppc -fno-common -c
mysql.c

make install
gcc -fno-common  -arch ppc -g -Os -pipe -fno-common  -arch ppc -pipe
-pipe -fno-common  -I. -I/usr/lib/ruby/1.8/powerpc-darwin8.0
-I/usr/lib/ruby/1.8/powerpc-darwin8.0 -I. -DHAVE_MYSQL_SSL_SET
-DHAVE_MYSQL_H  -I/usr/local/mysql/include -Os -arch ppc -fno-common -c
mysql.c
Successfully installed mysql-2.7
This topic is locked and can not be replied to.