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
Errors when accessing http://hda
Re: Errors when accessing http://hda
what happens when you do this (as root)?
Code: Select all
service mysqld restart
My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 8GB RAM, 1TBx2+3TBx1
Re: Errors when accessing http://hda
[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
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
Re: Errors when accessing http://hda
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
[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
Last edited by masteraxe on Wed Feb 17, 2010 3:18 pm, edited 2 times in total.
Re: Errors when accessing http://hda
i think there ought to be only one PID.
something is hosed with your mysql server.
try killing it, or restarting the machine.
something is hosed with your mysql server.
try killing it, or restarting the machine.
My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 8GB RAM, 1TBx2+3TBx1
Re: Errors when accessing http://hda
any update cpg?
Re: Errors when accessing http://hda
anyone else? can someone help in fixing this?
Re: Errors when accessing http://hda
I got the same problem.
Restart mysqld failed.
from /var/hda/platform/html/log/production.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 ?
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]#
Why the login screen path is pointing to http://tk2.greedland.net/user_sessions/new ?
Re: Errors when accessing http://hda
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
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
Who is online
Users browsing this forum: No registered users and 19 guests