# Admin controller problem

**URL:** <https://www.ruby-forum.com/t/admin-controller-problem/67814>\
**Category:** Rails\
**Created:** [September 6, 2006, 11:53pm UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814 "2006-09-06T23:53:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![darthclark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/dbc845/32.png) [@darthclark](https://www.ruby-forum.com/u/darthclark)\
**Post date:** [September 6, 2006, 11:53pm UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814/1 "2006-09-06T23:53:13Z")

</div>

I am reading the agile web development with rails book, and starting to  
create the depot. I am getting the below error after setting up the  
“ruby script/generate scaffold Product Admin” does anyone know what the  
problem is?

NameError in AdminController#index

uninitialized constant Mysql

RAILS\_ROOT: ./script/…/config/…/  
Application Trace | Framework Trace | Full Trace

/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active\_support/dependencies.rb:123:in  
`const_missing' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:133:in`const\_missing’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:34:in  
`mysql_connection' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in`connection\_without\_query\_cache=’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/query\_cache.rb:54:in  
`connection=' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in`retrieve\_connection’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:696:in`columns’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:216:in  
`column_for' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/calculations.rb:138:in`calculate’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:66:in  
`count' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/pagination.rb:172:in`count\_collection\_for\_pagination’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/pagination.rb:196:in  
`paginator_and_collection_for' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/pagination.rb:129:in`paginate’  
#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:13:in `list' #{RAILS_ROOT}/app/controllers/admin_controller.rb:8:in`index’

/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active\_support/dependencies.rb:123:in  
`const_missing' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:133:in`const\_missing’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:34:in  
`mysql_connection' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in`connection\_without\_query\_cache=’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/query\_cache.rb:54:in  
`connection=' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in`retrieve\_connection’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:696:in`columns’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:216:in  
`column_for' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/calculations.rb:138:in`calculate’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:66:in  
`count' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/pagination.rb:172:in`count\_collection\_for\_pagination’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/pagination.rb:196:in  
`paginator_and_collection_for' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/pagination.rb:129:in`paginate’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/base.rb:941:in  
`perform_action_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:368:in`perform\_action\_without\_benchmark’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/benchmarking.rb:69:in  
`perform_action_without_rescue' /usr/local/lib/ruby/1.8/benchmark.rb:293:in`measure’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/benchmarking.rb:69:in  
`perform_action_without_rescue' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/rescue.rb:82:in`perform\_action’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/base.rb:408:in  
`process_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:377:in`process\_without\_session\_management\_support’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/session\_management.rb:117:in  
`process' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in`dispatch’  
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick\_server.rb:115:in  
`handle_dispatch' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:81:in`service’  
/usr/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/local/lib/ruby/1.8/webrick/httpserver.rb:65:in`run’  
/usr/local/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/local/lib/ruby/1.8/webrick/server.rb:162:in`start\_thread’  
/usr/local/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:92:in`start’  
/usr/local/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:82:in`start’  
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick\_server.rb:67:in  
`dispatch’  
script/server:51

/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active\_support/dependencies.rb:123:in  
`const_missing' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:133:in`const\_missing’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:34:in  
`mysql_connection' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in`connection\_without\_query\_cache=’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/query\_cache.rb:54:in  
`connection=' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in`retrieve\_connection’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:78:in  
`connection' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:696:in`columns’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:216:in  
`column_for' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/calculations.rb:138:in`calculate’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:66:in  
`count' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/pagination.rb:172:in`count\_collection\_for\_pagination’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/pagination.rb:196:in  
`paginator_and_collection_for' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/pagination.rb:129:in`paginate’  
#{RAILS\_ROOT}/app/controllers/admin\_controller.rb:13:in `list' #{RAILS_ROOT}/app/controllers/admin_controller.rb:8:in`index’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/base.rb:941:in  
`perform_action_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:368:in`perform\_action\_without\_benchmark’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/benchmarking.rb:69:in  
`perform_action_without_rescue' /usr/local/lib/ruby/1.8/benchmark.rb:293:in`measure’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/benchmarking.rb:69:in  
`perform_action_without_rescue' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/rescue.rb:82:in`perform\_action’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/base.rb:408:in  
`process_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:377:in`process\_without\_session\_management\_support’  
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/session\_management.rb:117:in  
`process' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in`dispatch’  
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick\_server.rb:115:in  
`handle_dispatch' /usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick_server.rb:81:in`service’  
/usr/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/local/lib/ruby/1.8/webrick/httpserver.rb:65:in`run’  
/usr/local/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/local/lib/ruby/1.8/webrick/server.rb:162:in`start\_thread’  
/usr/local/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:92:in`start’  
/usr/local/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:82:in`start’  
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/webrick\_server.rb:67:in  
`dispatch’  
script/server:51

This error occured while loading the following files:  
active\_record/mysql.rb

Request

Parameters: None

Show session dump

* * *

flash: !map:ActionController::Flash::FlashHash {}

Response  
Headers: {“cookie”=\>[], “Cache-Control”=\>“no-cache”}

---

<div class="post-metadata">

**Author:** ![darthclark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/dbc845/32.png) [@darthclark](https://www.ruby-forum.com/u/darthclark)\
**Post date:** [September 7, 2006, 11:26am UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814/2 "2006-09-07T11:26:21Z")

</div>

> NameError in AdminController#index
> 
> uninitialized constant Mysql

Just one idea:

how does your database.yml looks like?

Beate

---

<div class="post-metadata">

**Author:** ![darthclark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/dbc845/32.png) [@darthclark](https://www.ruby-forum.com/u/darthclark)\
**Post date:** [September 7, 2006, 3:57pm UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814/3 "2006-09-07T15:57:01Z")

</div>

looks like this

development:  
adapter: mysql  
database: depot\_development  
username: myuser  
password: luke458  
host: localhost

through putty, it says like root@localhost cannot be connected “no  
password”  
my username is not even root.

---

<div class="post-metadata">

**Author:** ![darthclark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/dbc845/32.png) [@darthclark](https://www.ruby-forum.com/u/darthclark)\
**Post date:** [September 7, 2006, 4:45pm UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814/4 "2006-09-07T16:45:16Z")

</div>

that did not work, is there some line i need to run in rubygems?

---

<div class="post-metadata">

**Author:** ![darthclark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/dbc845/32.png) [@darthclark](https://www.ruby-forum.com/u/darthclark)\
**Post date:** [September 7, 2006, 5:59pm UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814/5 "2006-09-07T17:59:26Z")

</div>

I will give someone free hosting for three months, if someone will log  
into my server and fix this problem. I really need this fixed today. If  
you are willing please send an email to removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![darthclark](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/dbc845/32.png) [@darthclark](https://www.ruby-forum.com/u/darthclark)\
**Post date:** [September 7, 2006, 4:21pm UTC](https://www.ruby-forum.com/t/admin-controller-problem/67814/6 "2006-09-07T16:21:12Z")

</div>

On 07/09/06, darthclark [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> looks like this
> 
> development:  
> adapter: mysql  
> database: depot\_development  
> username: myuser  
> password: luke458  
> host: localhost

two spaces at the beginning of the lines under ‘development’, not one.

–  
Rasputin :: Jack of All Trades - Master of Nuns  
[http://number9.hellooperator.net/](http://number9.hellooperator.net/)