# cPanel RoR with mySQL database

**URL:** <https://www.ruby-forum.com/t/cpanel-ror-with-mysql-database/151610>\
**Category:** Rails\
**Created:** [October 23, 2008, 1:30pm UTC](https://www.ruby-forum.com/t/cpanel-ror-with-mysql-database/151610 "2008-10-23T13:30:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [October 23, 2008, 1:30pm UTC](https://www.ruby-forum.com/t/cpanel-ror-with-mysql-database/151610/1 "2008-10-23T13:30:58Z")

</div>

Hi,

I have just started using Ruby on Rails with cPanel. I can set up my  
application ok but I am having problems with linking the application  
with a mysql database.

I have run ruby sctipt/generate model and created the table through the  
migration. The table appears in the database correctly.

The original settings were for sqlite3 but I want to use mysql so that  
may be the issue.

I have changed the database.yml file matching with the correct db  
information;  
development:  
adapter: mysql  
database: [hidden]  
username: [hidden]  
password: [hidden]  
host: localhost  
socket: /var/lib/mysql/mysql.sock

I want to access a table from the db.

In the team controller I do this (i have a table called teams);

@team = Team.find(:all)

and in the views do this;

\<% for player in @team %\>  
\<%= player.id %\>  
\<% end %\>

but I get this error;

NoMethodError in Team#index

Showing team/index.html.erb where line #4 raised:

You have a nil object when you didn’t expect it!  
You might have expected an instance of Array.  
The error occurred while evaluating nil.each

Extracted source (around line #4):

1: Team Says Hi  
2:   
  
  
3:  
4: \<% for player in @team %\>  
5: \<%= player.id %\>  
6: \<% end %\>  
7:

hope you can help.

Thanks a lot

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [October 23, 2008, 9:01pm UTC](https://www.ruby-forum.com/t/cpanel-ror-with-mysql-database/151610/2 "2008-10-23T21:01:46Z")

</div>

try executing following

seems like your table is empty

try follwoing  
open command window… goto your project directory… run console…  
./script/console  
they try Team.find(:all) and see if it returns anything… it will tell  
you if there is any data in teams table.

let me know

Ajit

---

<div class="post-metadata">

**Author:** ![rpierry](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e19adc/32.png) [@rpierry](https://www.ruby-forum.com/u/rpierry)\
**Post date:** [October 24, 2008, 1:51am UTC](https://www.ruby-forum.com/t/cpanel-ror-with-mysql-database/151610/3 "2008-10-24T01:51:13Z")

</div>

Hi,

Yep the data is shown which I had entered into the table, through the  
migration.

Hope you can help,

Thanks a lot!