Amahi Forums

Posted: **Wed Feb 17, 2010 2:45 pm**

I have made every single security and software update yesterday and although It worked for one night (even after reboot) it doesnt appear to work anymore (services seems to be accessible still... i,e I can still access shares and Internet still work.

The Million dollars questions... How do I fix this?:

here is the error:

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:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (Mysql::Error)
Exception class:
Mysql::Error
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/mysql_adapter.rb 585 in `real_connect'
1 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 585 in `connect'
2 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 199 in `initialize'
3 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 71 in `new'
4 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/mysql_adapter.rb 71 in `mysql_connection'
5 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 223 in `send'
6 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 223 in `new_connection'
7 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 245 in `checkout_new_connection'
8 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 188 in `checkout'
9 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 184 in `loop'
10 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 184 in `checkout'
11 /usr/lib/ruby/1.8/monitor.rb 242 in `synchronize'
12 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 183 in `checkout'
13 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 98 in `connection'
14 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb 326 in `retrieve_connection'
15 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb 123 in `retrieve_connection'
16 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb 115 in `connection'
17 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1271 in `columns'
18 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1284 in `column_names'
19 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1297 in `column_methods_hash'
20 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all_attributes_exists?'
21 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `all?'
22 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `each'
23 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all?'
24 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1986 in `all_attributes_exists?'
25 /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/base.rb 1842 in `method_missing'
26 /var/hda/platform/html/app/models/setting.rb 23 in `get'
27 /var/hda/platform/html/lib/router-driver.rb 31
28 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
29 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
30 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 158 in `require'
31 /var/hda/platform/html/app/models/firewall.rb 17
32 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
33 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
34 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 158 in `require'
35 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 265 in `require_or_load'
36 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 224 in `depend_on'
37 /usr/lib/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb 136 in `require_dependency'
38 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 414 in `load_application_classes'
39 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 413 in `each'
40 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 413 in `load_application_classes'
41 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 411 in `each'
42 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 411 in `load_application_classes'
43 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 197 in `process'
44 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 113 in `send'
45 /usr/lib/ruby/gems/1.8/gems/rails-2.3.4/lib/initializer.rb 113 in `run'
46 /var/hda/platform/html/config/environment.rb 9
47 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `gem_original_require'
48 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb 31 in `require'
49 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/railz/application_spawner.rb 303 in `preload_application'
50 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/railz/application_spawner.rb 252 in `initialize_server'
51 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/utils.rb 254 in `report_app_init_status'
52 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/railz/application_spawner.rb 237 in `initialize_server'
53 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server.rb 194 in `start_synchronously'
54 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server.rb 163 in `start'
55 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/railz/application_spawner.rb 213 in `start'
56 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/spawn_manager.rb 262 in `spawn_rails_application'
57 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server_collection.rb 126 in `lookup_or_add'
58 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/spawn_manager.rb 256 in `spawn_rails_application'
59 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server_collection.rb 80 in `synchronize'
60 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server_collection.rb 79 in `synchronize'
61 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/spawn_manager.rb 255 in `spawn_rails_application'
62 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/spawn_manager.rb 154 in `spawn_application'
63 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/spawn_manager.rb 287 in `handle_spawn_application'
64 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server.rb 352 in `__send__'
65 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server.rb 352 in `main_loop'
66 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/lib/phusion_passenger/abstract_server.rb 196 in `start_synchronously'
67 /usr/lib/ruby/gems/1.8/gems/passenger-2.2.5/bin/passenger-spawn-server 61
68 /usr/lib/phusion_passenger/passenger-spawn-server 19 in `load'
69 /usr/lib/phusion_passenger/passenger-spawn-server 19

Posted: **Wed Feb 17, 2010 2:48 pm**

what happens when you do this (as root)?

Code: Select all

service mysqld restart

Posted: **Wed Feb 17, 2010 3:01 pm**

[username@homepcserver ~]$ su -
Password:
[root@homepcserver ~]# service mysqld restart
Stopping MySQL: [FAILED]

[root@homepcserver ~]#

(will be testing as advised, will post results shortly)
ps guax | grep mysql
service mysqld status

Posted: **Wed Feb 17, 2010 3:09 pm**

to ps guax | grep mysql:

[root@homepcserver ~]# ps guax | grep mysql
root 1436 0.0 0.0 107688 788 ? S 14:42 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 2125 0.0 1.9 367364 19660 ? Sl 14:59 0:02 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 31397 0.1 0.1 107940 1572 ? S 17:05 0:00 /bin/bash /etc/init.d/mysqld start
root 31426 0.0 0.1 107684 1388 ? S 17:05 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 31515 0.0 1.5 192400 16004 ? Sl 17:05 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 32129 0.0 0.1 107812 1560 ? S 17:07 0:00 /bin/bash /etc/init.d/mysqld start
root 32158 0.5 0.1 107684 1392 ? S 17:07 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 32247 3.0 1.5 192400 16008 ? Sl 17:07 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 32266 0.0 0.0 102736 788 pts/0 S+ 17:07 0:00 grep mysql
You have mail in /var/spool/mail/root

to

service mysqld status
[root@homepcserver ~]# service mysqld status
mysqld (pid 32247 32129 2125) is running...

(testing, will post results

killall mysqld_safe
service mysqld stop
killall mysqld_safe
ps guax | grep mysql | fpaste

Posted: **Wed Feb 17, 2010 3:15 pm**

i think there ought to be only one PID.

something is hosed with your mysql server.

try killing it, or restarting the machine.

Posted: **Thu Feb 18, 2010 6:49 pm**

any update cpg?

Posted: **Wed Feb 24, 2010 10:23 am**

anyone else? can someone help in fixing this?

Posted: **Fri Mar 12, 2010 4:29 am**

I got the same problem.

Restart mysqld failed.

from /var/hda/platform/html/log/production.log

Code: Select all

Processing SetupController#index (for 192.168.168.104 at 2010-03-12 18:25:11) [GET]
  Parameters: {"sub"=>"settings", "action"=>"index", "controller"=>"setup", "tab"=>"setting"}
Rendering template within layouts/amahi
Rendering setup/index
Completed in 357ms (View: 103, DB: 82) | 200 OK [http://hda/setup?sub=settings&tab=setting]


Processing SetupController#index (for 127.0.0.1 at 2010-03-12 18:53:49) [GET]
  Parameters: {"rest"=>["scrape"], "info_hash"=>"+舓\204?\006d\256\267萤\273\220WD觴H", "action"=>"index", "controller"=>"setup"}
Redirected to http://tk2.greedland.net/user_sessions/new
Filter chain halted as [:admin_required] rendered_or_redirected.
Completed in 16ms (DB: 2) | 302 Found [http://tk2.greedland.net/scrape?info_hash=%2B%C5%03k%84%CF4%06d%AE%B7%D3%A9%BB%90WD%D3xH]


Processing UserSessionsController#new (for 127.0.0.1 at 2010-03-12 18:53:49) [GET]
  Parameters: {"action"=>"new", "controller"=>"user_sessions"}
Rendering template within layouts/login
Rendering user_sessions/new
Completed in 42ms (View: 31, DB: 1) | 200 OK [http://tk2.greedland.net/user_sessions/new]


Processing SetupController#index (for 127.0.0.1 at 2010-03-12 19:06:25) [GET]
  Parameters: {"left"=>"5546392246", "rest"=>["announce"], "info_hash"=>"+舓\204?\006d\256\267萤\273\220WD觴H", "peer_id"=>"-TR1910-19irx5bt1jj8", "action"=>"index", "uploaded"=>"0", "numwant"=>"200", "event"=>"started", "port"=>"51413", "controller"=>"setup", "downloaded"=>"0", "compact"=>"1", "key"=>"gln86l42", "supportcrypto"=>"1"}
Redirected to http://tk2.greedland.net/user_sessions/new
Filter chain halted as [:admin_required] rendered_or_redirected.
Completed in 32ms (DB: 3) | 302 Found [http://tk2.greedland.net/announce?info_hash=%2B%C5%03k%84%CF4%06d%AE%B7%D3%A9%BB%90WD%D3xH&peer_id=-TR1910-19irx5bt1jj8&port=51413&uploaded=0&downloaded=0&left=5546392246&numwant=200&key=gln86l42&compact=1&supportcrypto=1&event=started]


Processing UserSessionsController#new (for 127.0.0.1 at 2010-03-12 19:06:25) [GET]
  Parameters: {"action"=>"new", "controller"=>"user_sessions"}
Rendering template within layouts/login
Rendering user_sessions/new
Completed in 90ms (View: 78, DB: 1) | 200 OK [http://tk2.greedland.net/user_sessions/new]


Processing SetupController#index (for 127.0.0.1 at 2010-03-12 19:16:25) [GET]
  Parameters: {"left"=>"5546326710", "rest"=>["announce"], "info_hash"=>"+舓\204?\006d\256\267萤\273\220WD觴H", "peer_id"=>"-TR1910-19irx5bt1jj8", "action"=>"index", "uploaded"=>"101550", "numwant"=>"200", "port"=>"51413", "controller"=>"setup", "downloaded"=>"0", "compact"=>"1", "key"=>"gln86l42", "supportcrypto"=>"1"}

ActiveRecord::StatementInvalid (Mysql::Error: Got error 28 from storage engine: SHOW FIELDS FROM `aliases`):
  app/controllers/application_controller.rb:131:in `all?'
  app/controllers/application_controller.rb:42:in `check_for_amahi_app'
  passenger (2.2.5) lib/phusion_passenger/rack/request_handler.rb:95:in `process_request'
  passenger (2.2.5) lib/phusion_passenger/abstract_request_handler.rb:207:in `main_loop'
  passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:378:in `start_request_handler'
  passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:336:in `handle_spawn_application'
  passenger (2.2.5) lib/phusion_passenger/utils.rb:183:in `safe_fork'
  passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:334:in `handle_spawn_application'
  passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `__send__'
  passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:352:in `main_loop'
  passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
  passenger (2.2.5) lib/phusion_passenger/abstract_server.rb:163:in `start'
  passenger (2.2.5) lib/phusion_passenger/railz/application_spawner.rb:213:in[root@server log]#

Looks like it's something to do with transmission cause tk2.greedland.net is a tracker server.
Why the login screen path is pointing to http://tk2.greedland.net/user_sessions/new ?

Posted: **Thu Mar 25, 2010 3:14 pm**

I have the same error

New to Amahi, been running it for 1 week, installed a few apps, openvnc, transmission and icalendar, then installed all security updates 538 in total, just rebooted tonight and internet is working, shares are working, but no interface when accessing //hda (not even from the server itself)

Happy to test anything for the techy guys here, this just made me realise how out of my depth I am, but I really want to keep Amahi.

Thanks in advance for any guidance.
Chris

Amahi Forums

Errors when accessing http://hda

Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda

Re: Errors when accessing http://hda