Amahi Forums

My squeezcenter has stopped working and I am getting a ruby on rails error when I attempt to access the HDA dashboard (via http://hda or via ip address), full error message details at end of this post. I have tried the suggested "rake db:migrate" but get the following error;

# rake db:migrate
rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2376:in `raw_load_rakefile'
(See full trace by running task with --trace)

I tried restarting squeezecenter and get the following;

# /etc/init.d/squeezeboxserver restart
Stopping Squeezebox Server: [ OK ]
Starting Squeezebox Server: Use of uninitialized value in subroutine entry at /usr/share/squeezeboxserver/CPAN/YAML/Syck.pm line 75.
[10-05-15 16:06:15.1106] main::init (320) Starting Squeezebox Server (v7.4.1, r28947, Tue Oct 20 07:59:38 PDT 2009) perl 5.010000
100515 16:06:15 [Warning] Can't create test file /var/lib/mysql/hda.lower-test
100515 16:06:15 [Warning] Can't create test file /var/lib/mysql/hda.lower-test
100515 16:06:15 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100515 16:06:15 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100515 16:06:15 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
[ OK ]

I've tried "mysql_upgrade" and get the following;

# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed

All packages are up to date and I've tried a reboot. All other HDA apps are working fine. Any ideas anyone?

Start of dasborad error message ::--

* Phusion Passenger

Ruby on Rails application could not be started
There appears to be a database problem.

*
Your config/database.yml may not be written correctly. Please check it and fix any errors.
*
Your database schema may be out of date or nonexistant. Please run rake db:migrate to ensure that the database schema is up-to-date.
*
The database server may not be running. Please check whether it's running, and start it if it isn't.

Error message:
Mysql::Error: Got error 28 from storage engine: SHOW FIELDS FROM `settings` (ActiveRecord::StatementInvalid)
Exception class:
ActiveRecord::StatementInvalid
Application root:
/var/hda/platform/html
Backtrace:
# File Line Location
0 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract_adapter.rb 219 in `log'
1 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 319 in `execute'
2 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 465 in `columns'
3 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1271 in `columns'
4 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1284 in `column_names'
5 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1297 in `column_methods_hash'
6 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all_attributes_exists?'
7 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `all?'
8 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `each'
9 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all?'
10 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all_attributes_exists?'
11 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1842 in `method_missing'
12 /var/hda/platform/html/app/models/setting.rb 23 in `get'
13 /var/hda/platform/html/lib/router-driver.rb 31
14 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
15 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
16 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 158 in `require'
17 /var/hda/platform/html/app/models/firewall.rb 17
18 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
19 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
20 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 158 in `require'
21 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 265 in `require_or_load'
22 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 224 in `depend_on'
23 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 136 in `require_dependency'
24 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 414 in `load_application_classes'
25 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 413 in `each'
26 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 413 in `load_application_classes'
27 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 411 in `each'
28 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 411 in `load_application_classes'
29 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 197 in `process'
30 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 113 in `send'
31 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 113 in `run'
32 /var/hda/platform/html/config/environment.rb 9
33 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
34 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
35 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 303 in `preload_application'
36 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 252 in `initialize_server'
37 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/utils.rb 255 in `report_app_init_status'
38 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 237 in `initialize_server'
39 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 194 in `start_synchronously'
40 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 163 in `start'
41 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 213 in `start'
42 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 262 in `spawn_rails_application'
43 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server_collection.rb 126 in `lookup_or_add'
44 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 256 in `spawn_rails_application'
45 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server_collection.rb 80 in `synchronize'
46 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server_collection.rb 79 in `synchronize'
47 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 255 in `spawn_rails_application'
48 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 154 in `spawn_application'
49 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 287 in `handle_spawn_application'
50 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 352 in `__send__'
51 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 352 in `main_loop'
52 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 196 in `start_synchronously'
53 /usr/lib/phusion_passenger/passenger-spawn-server 61

Powered by Phusion Passenger, mod_rails / mod_rack for Apache.

I did a forcece-reload of Squeezecenter and that fixed that but it also seems to have fixed the dashboard problem. How bizarre.

Jim!

last night I did a yum update.

Today I noticed that online bookmarks asked for a login, but I could not login.
b4rt reported a database error
and later http://hda gave the ruby error mentioned in the previous message.

On the fedora machine I got a message box about the server not being able to "replace the lock because the process was in use by usr/lib/puthon /something/yum update"

The text between "" is what I approximately remember since I did not write down the error message.

Fortunately, everything is working again after a reboot.

I think there is some sort of bug, how can I help solve this?

Well, this has nothing to do with Squeezecenter (to the best of my knowledge) but I'm getting roughly the same database error. I was about 1/3 of the way through dumping 16,000 files equaling 73gb to my spiffy new HDA when I got a "disk full" message. Shocked, I quickly switched over to my Amahi control panel only to see this:

There appears to be a database problem.
Your config/database.yml may not be written correctly. Please check it and fix any errors.
Your database schema may be out of date or nonexistant. Please run rake db:migrate to ensure that the database schema is up-to-date.
The database server may not be running. Please check whether it's running, and start it if it isn't.
Error message:
Mysql::Error: Got error 28 from storage engine: SHOW FIELDS FROM `settings` (ActiveRecord::StatementInvalid)
Exception class:
ActiveRecord::StatementInvalid
Application root:
/var/hda/platform/html
Backtrace:
# File Line Location
0 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract_adapter.rb 219 in `log'
1 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 319 in `execute'
2 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 465 in `columns'
3 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1271 in `columns'
4 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1284 in `column_names'
5 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1297 in `column_methods_hash'
6 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all_attributes_exists?'
7 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `all?'
8 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `each'
9 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all?'
10 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all_attributes_exists?'
11 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1842 in `method_missing'
12 /var/hda/platform/html/app/models/setting.rb 23 in `get'
13 /var/hda/platform/html/lib/router-driver.rb 31
14 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
15 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
16 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 158 in `require'
17 /var/hda/platform/html/app/models/firewall.rb 17
18 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
19 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
20 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 158 in `require'
21 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 265 in `require_or_load'
22 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 224 in `depend_on'
23 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 136 in `require_dependency'
24 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 414 in `load_application_classes'
25 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 413 in `each'
26 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 413 in `load_application_classes'
27 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 411 in `each'
28 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 411 in `load_application_classes'
29 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 197 in `process'
30 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 113 in `send'
31 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 113 in `run'
32 /var/hda/platform/html/config/environment.rb 9
33 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
34 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
35 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 303 in `preload_application'
36 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 252 in `initialize_server'
37 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/utils.rb 255 in `report_app_init_status'
38 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 237 in `initialize_server'
39 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 194 in `start_synchronously'
40 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 163 in `start'
41 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/railz/application_spawner.rb 213 in `start'
42 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 262 in `spawn_rails_application'
43 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server_collection.rb 126 in `lookup_or_add'
44 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 256 in `spawn_rails_application'
45 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server_collection.rb 80 in `synchronize'
46 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server_collection.rb 79 in `synchronize'
47 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 255 in `spawn_rails_application'
48 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 154 in `spawn_application'
49 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/spawn_manager.rb 287 in `handle_spawn_application'
50 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 352 in `__send__'
51 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 352 in `main_loop'
52 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.11/lib/phusion_passenger/abstract_server.rb 196 in `start_synchronously'
53 /usr/lib/phusion_passenger/passenger-spawn-server 61

I logged into the Amahi server and was told that disk space was low. The system proceeded to run a disk analyses and came up with this: http://i.imgur.com/Oqkur.png. I tried the control panel again and was able to see my shares and storage. They looked like this: http://i.imgur.com/goyKO.png. Should be plenty of room, no? Was it just too many files for the database to handle? Is my database filling up the little 38gb drive that I'm running the OS off of? Any thoughts to suggestions? I'm going to try the standard PCTA (power cycle - try again) but any advice would be welcome. This problem happened after I'd spent the last few days transfering about 200 gb of data btw.

been there. log in as root and run:
df
have a look at the use % there to make sure / has plenty of room.

Thanks for the reply lou1z. Seems like the Amahi forums tend to have a lot of questions and few answers. I actually just did a reboot and the problem vanished. Now if I could only figure out why my ping in online games goes up to 996 when I have Amahi run the dhcp services on my network.... However, as network storage, available to every machine on my network, Amahi is working great.