Sunday, December 30, 2007

ERROR on WEBSITE Application does not get called

Dec 30 - 08:26 GMT
Customer

Hi we have nothing changed but now getting an error message. could you please check, what is causing this problem now? It was already setup for working, Database seems to be OK.

t3log.info start in folder /redmine

THanks

---------------------------------------------
Problem URL:
http://t3log.info/
---------------------------------------------

Dec 30 - 09:34 GMT
Support - Shelly

Hello Andreas,

Please check whether the dispatch.fcgi or dispatch.cgi
has correct path to ruby.

The correct path is /usr/bin/ruby

And ensure the permissions are set to 755.

Let us know with the updates.

Thank you :)
Kind regards,
Shelly, Servage - Support
Servage Hosting

Dec 30 - 09:55 GMT
Customer

That's the case Shelly!

dispatch.fcgi looks like this

usr/bin/ruby

#
# You may specify the path to the FastCGI crash log (a log of unhandled
# exceptions which forced the FastCGI instance to exit, great for debugging) ...

the same in dispatch.cgi
------------------------------

Permissions are 755

log and tmp folder are set to webserver recursive
------------------------------

Dec 30 - 09:56 GMT
Customer

You can check the folder /1_redmine in our installation - This contains the complete redmine installation and gets calles thry http://www.t3log.info

Dec 30 - 10:28 GMT
Customer

Hi is still somebody there to assist?

I guess it is a .htaccess error. I copied it from your faq but something seems not working as the error message is coming from the .htaccess file

Dec 30 - 10:33 GMT
Customer

Here this is the error I am getting now:

dispatch.fcgi: line 1: usr/bin/ruby: No such file or directory dispatch.fcgi: line 14: RailsFCGIHandler.process!: command not found dispatch.fcgi: line 17: RailsFCGIHandler.process!: command not found dispatch.fcgi: line 20: RailsFCGIHandler.process!: command not found dispatch.fcgi: line 22: syntax error near unexpected token `(' dispatch.fcgi: line 22: `require File.dirname(__FILE__) + "/../config/environment"'


As you can see the path to your ruby isn't OK. So where do you have your ruby installed

Dec 30 - 10:39 GMT
Support - Shelly

Hello Andreas,

The path will be:#!/usr/bin/ruby
and not /usr/bin/ruby.

Please check at your end and update us.

Thank you :)
Kind regards,
Shelly, Servage - Support
Servage Hosting

Dec 30 - 10:47 GMT
Customer

Hi

now I receive still the syntax error

dispatch.fcgi: line 22: syntax error near unexpected token `(' dispatch.fcgi: line 22: `require File.dirname(__FILE__) + "/../config/environment"'

How should this look like?
--------------------------------- dispatch.fcgi
#!/usr/bin/ruby

#
# You may specify the path to the FastCGI crash log (a log of unhandled
# exceptions which forced the FastCGI instance to exit, great for debugging)
# and the number of requests to process before running garbage collection.
#
# By default, the FastCGI crash log is RAILS_ROOT/log/fastcgi.crash.log
# and the GC period is nil (turned off). A reasonable number of requests
# could range from 10-100 depending on the memory footprint of your app.
#
# Example:
# # Default log path, normal GC behavior.
#RailsFCGIHandler.process!
#
# # Default log path, 50 requests between GC.
#RailsFCGIHandler.process! nil, 50
#
# # Custom log path, normal GC behavior.
#RailsFCGIHandler.process! '/var/log/redmine_fcgi_crash.log'
#
require File.dirname(__FILE__) + "/../config/environment"
require 'fcgi_handler'

RailsFCGIHandler.process!
---------------------------

I can't find any differences here. So what is wrong?

Dec 30 - 10:50 GMT
Customer

If I enable the error logs then even they don't get called

dispatch.fcgi: line 14: RailsFCGIHandler.process!: command not found
dispatch.fcgi: line 17: RailsFCGIHandler.process!: command not found
dispatch.fcgi: line 20: RailsFCGIHandler.process!: command not found
dispatch.fcgi: line 22: syntax error near unexpected token `(' dispatch.fcgi: line 22: `require File.dirname(__FILE__) + "/../config/environment"'

---------------------------------------------

Can it be that the user permissions aren't enough to run ruby applications? So the folders or files won't get found?
Dec 30 - 11:23 GMT
Customer
Hi
I got further and now I gut a whole bunch of stuff.

-------------------------------------------
The dispatch.fcgi looks like this now:
-------------------------------------------
#!/usr/bin/ruby

#
# You may specify the path to the FastCGI crash log (a log of unhandled
# exceptions which forced the FastCGI instance to exit, great for debugging)
# and the number of requests to process before running garbage collection.
#
# By default, the FastCGI crash log is RAILS_ROOT/log/fastcgi.crash.log
# and the GC period is nil (turned off). A reasonable number of requests
# could range from 10-100 depending on the memory footprint of your app.
#
# Example:
# # Default log path, normal GC behavior.
RailsFCGIHandler.process!
#
# # Default log path, 50 requests between GC.
RailsFCGIHandler.process! nil, 50
#
# # Custom log path, normal GC behavior.
RailsFCGIHandler.process! '/var/log/redmine_fcgi_crash.log'
#
require File.dirname(__FILE__) + "/../config/environment"
require 'fcgi_handler'

RailsFCGIHandler.process!
---------------------------------------
=======================================

The Error message I am receiving now when I call http://t3log.info is:
---------------------------------------
Errno::ENOENT in WelcomeController#index

No such file or directory - /tmp/mysql.sock

RAILS_ROOT: /home81c/sub004/sc44977-AQJR/1_redmine/public/../config/..
Application Trace | Framework Trace | Full Trace

/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:107:in `initialize'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:107:in `real_connect'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:389:in `connect'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:152:in `initialize'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in `mysql_connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `connection_without_query_cache='
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in `connection='
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/base.rb:763:in `columns'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:257:in `column_for'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:116:in `calculate'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:66:in `maximum'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/app/models/setting.rb:102:in `check_cache'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/app/controllers/application.rb:31:in `user_setup'

/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:107:in `initialize'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:107:in `real_connect'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:389:in `connect'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:152:in `initialize'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in `mysql_connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `connection_without_query_cache='
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in `connection='
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/base.rb:763:in `columns'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:257:in `column_for'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:116:in `calculate'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:66:in `maximum'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:469:in `call'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:442:in `run'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:714:in `run_before_filters'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:694:in `call_filters'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:688:in `perform_action_without_benchmark'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in `perform_action'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:435:in `process_without_filters'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:684:in `process_without_session_management_support'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in `process'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:334:in `process'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/dispatcher.rb:41:in `dispatch'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:168:in `process_request'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:143:in `process_each_request!'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:109:in `with_signal_handler'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:142:in `process_each_request!'
/usr/lib/site_ruby/1.8/fcgi.rb:600:in `each_cgi'
/usr/lib/site_ruby/1.8/fcgi.rb:117:in `session'
/usr/lib/site_ruby/1.8/fcgi.rb:104:in `each_request'
/usr/lib/site_ruby/1.8/fcgi.rb:36:in `each'
/usr/lib/site_ruby/1.8/fcgi.rb:597:in `each_cgi'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:141:in `process_each_request!'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:55:in `process!'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:25:in `process!'
/home81c/sub004/sc44977-AQJR/1_redmine/public/dispatch.fcgi:25

/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:107:in `initialize'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/vendor/mysql.rb:107:in `real_connect'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:389:in `connect'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:152:in `initialize'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:82:in `mysql_connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:262:in `connection_without_query_cache='
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/query_cache.rb:54:in `connection='
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:230:in `retrieve_connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/base.rb:763:in `columns'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:257:in `column_for'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:116:in `calculate'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/activerecord/lib/active_record/calculations.rb:66:in `maximum'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/app/models/setting.rb:102:in `check_cache'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/app/controllers/application.rb:31:in `user_setup'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:469:in `call'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:442:in `run'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:714:in `run_before_filters'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:694:in `call_filters'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:688:in `perform_action_without_benchmark'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in `perform_action_without_rescue'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in `perform_action'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:435:in `process_without_filters'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/filters.rb:684:in `process_without_session_management_support'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in `process'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/actionpack/lib/action_controller/base.rb:334:in `process'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/dispatcher.rb:41:in `dispatch'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:168:in `process_request'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:143:in `process_each_request!'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:109:in `with_signal_handler'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:142:in `process_each_request!'
/usr/lib/site_ruby/1.8/fcgi.rb:600:in `each_cgi'
/usr/lib/site_ruby/1.8/fcgi.rb:117:in `session'
/usr/lib/site_ruby/1.8/fcgi.rb:104:in `each_request'
/usr/lib/site_ruby/1.8/fcgi.rb:36:in `each'
/usr/lib/site_ruby/1.8/fcgi.rb:597:in `each_cgi'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:141:in `process_each_request!'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:55:in `process!'
/mounted-storage/home81c/sub004/sc44977-AQJR/1_redmine/vendor/rails/railties/lib/fcgi_handler.rb:25:in `process!'
/home81c/sub004/sc44977-AQJR/1_redmine/public/dispatch.fcgi:25

Request

Parameters: None

Show session dump

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


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

As you can see here it can't find a file called:
No such file or directory - /tmp/mysql.sock
--------------------------------------

Where is it and how can I solve this problem.

Thanks
Andi


Dec 30 - 11:40 GMT
Customer

WHERE IS mysql.sock or mysqld.sock
Your db is much to old:
warning: locate: warning: database /var/lib/slocate/slocate.db' is more than 8 days old warning: Please make sure the daily cron job is enabled in /etc/updatedb.conf

Dec 30 - 11:50 GMT
Customer

The rails path seems to be found:
RAILS_ROOT: /home81c/sub004/sc44977-AQJR/1_redmine/public/../config/..
----------------
The ruby Path differs from what you told us:
/usr/lib/site_ruby/1.8/fcgi.rb:600:in `each_cgi'
and
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'

the dispatcher is here:
/home81c/sub004/sc44977-AQJR/1_redmine/public/dispatch.fcgi:25

But I can't find this mysql.sock or mysqld.sock


I followed this post here:

这样的错误,其实是由于MySQL没有安装在默认的地址下的原因,解决办法是如果您有安装phpmyadmin的话,登录进去,选择系统变量会看到一项

QUOTE:

socket /var/run/mysqld/mysqld.sock

这样的字眼,后面的就是socket的地址,把database.yml里加上一行:

Sorry if you can't understand in short it says: (free translation)
update database.yml to reflect your system’s configuration. So your entry will be:

socket: /path/to/mysql.sock

---------------------------

So I really need to know where on your system do you hide mysql.sock or mysqld.sock WHERE!

I asked this already days ago if you checked. Or haven't you got this file at all on your servers?

Dec 30 - 11:59 GMT
Customer

Oh I am sorry you are not running utf8 in your support section. switch to chinese and you can read the post.

You also should check your Templates and CSS as now I can't even see anymore the submit (UPDATE) bottom. It is somewhere to the right in nowhere ;-)

Dec 30 - 12:13 GMT
Customer

You can read the last comment here: Sory that your site isn't displaying those characters so ttaht you might understand what I m talking about. So please check here:
http://apapococ.blogspot.com/2007/12/error-on-website-application-does-not.html

Dec 30 - 12:27 GMT
Customer

ruby: No such file or directory -- script/server (LoadError)

RUBY IS NOT FOUND - PLEASE CHECK

The paths you have given to me don't seem to be OK!

Dec 30 - 12:33 GMT
Customer

HI SERVAGE WHERE IS YOUR SUPPORT???

Dec 30 - 22:36 GMT
Josh

Hello Andreas,

Thank you for your reply. I can see that we have already replied to another ticket regarding the same issue. Kind do not open further tickets regarding the same issue. This may delay the responding time on the other open ticket.

You are more than welcome to update the open ticket if you have any additional comments or updates. Thank you for your understanding.


Kind regards,
Josh, Support
Servage Hosting

Dec 31 - 01:35 GMT
Customer

Hi JOSH

This is a different issue and you better read it twice. The one issue is about SERVAGE HOSTING SUPPORT (and Steffan your boss already replied!!!) and has nothing to do with the very specific case of REDMINE - The second Post.

It proofs again that SERVAGE HOSTING 24/7 SUPPORT has no clue and no qualification at all and are only good in copy and pasting prepared answers. Read more about SERVAGE HOSTING in our Blog.
http://apapococ.blogspot.com/

Dec 31 - 05:08 GMT
Customer

There is no Answer coming so we need to close this for the moment as we have HUGE Problems and can only post 2 Error Tickets, even we are running much more sites!

No comments: