[Rails] Re: Re: SSL problems with RoR, MySQL and Apace

Ruby on Rails Wednesday, February 2, 2011

Hassan Schroeder wrote in post #979000:
> On Tue, Feb 1, 2011 at 2:42 PM, Anthony M. <lists@ruby-forum.com> wrote:
>
>> Apache does serve up the correct page, however when using 443 it doesn't
>> connect to the db but when using port 80 it works fine.
>
> That makes pretty much zero sense :-)
>
> Can we see all of the log entries (httpd access/error, Passenger, Rails)
> for one of the SSL-based access attempts? And possibly the same for
> a non-SSL access that works?
>
> --
> Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
> twitter: @hassan

Port: 80

I changed the port in the VHost to 80 and commented out the SSL stuff
and restarted apache.

Apache Error Log -
[Wed Feb 02 10:48:32 2011] [notice] caught SIGTERM, shutting down
[Wed Feb 02 10:48:34 2011] [notice] Apache/2.2.11 (Ubuntu)
mod_ssl/2.2.11 OpenSSL/0.9.8g Phusion_Passenger/3.0.2 configured --
resuming normal operations

Apache Access Log -
10.10.20.108 - - [02/Feb/2011:10:56:45 -0500] "GET / HTTP/1.1" 200 1711
"-" "Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101
Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:45 -0500] "GET /AC_OETags.js
HTTP/1.1" 304 - "http://testabl.cyncsoftware.com/" "Mozilla/5.0 (Windows
NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:47 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 311 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:47 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 311 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:47 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 619 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:47 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 4977 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:52 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 311 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:52 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 528 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:53 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 311 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:53 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 3202 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:53 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 4977 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:53 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 4360 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:10:56:54 -0500] "POST /rubyamf/gateway
HTTP/1.1" 200 4360 "http://testabl.cyncsoftware.com/sikkim.swf"
"Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"

Rails Log -

Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:34) [POST]
Sending data
Completed in 4ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.com/rubyamf/gateway]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:34) [POST]
Sending data
Completed in 5ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.com/rubyamf/gateway]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:34) [POST]


Processing LovsController#amf_multi_lov (for 10.10.20.108 at 2011-02-02
11:00:34) [POST]
Parameters: {0=>{"user_locale"=>{"is_model"=>false,
"name"=>"userLocaleLov", "model"=>"user", "method"=>"lov_locale",
"query_keys"=>[]}, "user_skin"=>{"is_model"=>false,
"name"=>"userSkinLov", "model"=>"user", "method"=>"lov_skin",
"query_keys"=>[]}}, "user_locale"=>{"is_model"=>false,
"name"=>"userLocaleLov", "model"=>"user", "method"=>"lov_locale",
"query_keys"=>[]}, "user_skin"=>{"is_model"=>false,
"name"=>"userSkinLov", "model"=>"user", "method"=>"lov_skin",
"query_keys"=>[]}}
Completed in 7ms (DB: 0) | 200
[http://testabl.cyncsoftware.comlovs/amf_multi_lov]
Sending data
Completed in 20ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.comlovs/amf_multi_lov]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:34) [POST]


Processing MenuModulesController#amftree (for 10.10.20.108 at 2011-02-02
11:00:34) [POST]
Parameters: {0=>{"id"=>-1}, "id"=>-1}
Completed in 150ms (DB: 1) | 200
[http://testabl.cyncsoftware.commenu_modules/amftree]
Sending data
Completed in 220ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.commenu_modules/amftree]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]
Sending data
Completed in 5ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.com/rubyamf/gateway]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]


Processing SessionsController#amfcreate (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]
Parameters: {0=>{"lock_version"=>0, "id"=>0, "login"=>"system",
"password"=>"SYSTEM123"}, "lock_version"=>0, "id"=>0, "login"=>"system",
"password"=>"SYSTEM123"}
Completed in 6ms (DB: 0) | 200
[http://testabl.cyncsoftware.comsessions/amfcreate]
Sending data
Completed in 16ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.comsessions/amfcreate]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]
Sending data
Completed in 5ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.com/rubyamf/gateway]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]


Processing LovsController#amf_multi_lov (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]
Parameters: {0=>{"manager_lov"=>{"is_model"=>true,
"name"=>"manager_lov", "model"=>"manager", "query_keys"=>[]},
"client_val"=>{"is_model"=>false, "model"=>"client", "method"=>"val",
"query_keys"=>[]}}, "manager_lov"=>{"is_model"=>true,
"name"=>"manager_lov", "model"=>"manager", "query_keys"=>[]},
"client_val"=>{"is_model"=>false, "model"=>"client", "method"=>"val",
"query_keys"=>[]}}
Completed in 13ms (DB: 0) | 200
[http://testabl.cyncsoftware.comlovs/amf_multi_lov]
Sending data
Completed in 41ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.comlovs/amf_multi_lov]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]


Processing MenuModulesController#amftree (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]
Parameters: {0=>{"id"=>-1}, "id"=>-1}
Completed in 40ms (DB: 5) | 200
[http://testabl.cyncsoftware.commenu_modules/amftree]
Sending data
Completed in 110ms (View: 1, DB: 0) | 200 OK
[http://testabl.cyncsoftware.commenu_modules/amftree]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]


Processing ClientsController#index (for 10.10.20.108 at 2011-02-02
11:00:41) [POST]
Parameters: {0=>nil}
Completed in 40ms (DB: 4) | 200
[http://testabl.cyncsoftware.comclients/index]
Sending data
Completed in 483ms (View: 0, DB: 45) | 200 OK
[http://testabl.cyncsoftware.comclients/index]


Processing RubyamfController#gateway (for 10.10.20.108 at 2011-02-02
11:00:42) [POST]


Processing ClientsController#index (for 10.10.20.108 at 2011-02-02
11:00:42) [POST]
Parameters: {0=>nil}
Completed in 10ms (DB: 1) | 200
[http://testabl.cyncsoftware.comclients/index]
Sending data
Completed in 268ms (View: 0, DB: 15) | 200 OK
[http://testabl.cyncsoftware.comclients/index]

##Now switching the port to 443 in the VHost and uncommenting out the
SSL info. I cleared out the logs before doing this so all the
information in the logs is after the port was changed.


Apache Error Log -

[Wed Feb 02 11:04:36 2011] [notice] caught SIGTERM, shutting down
[Wed Feb 02 11:04:41 2011] [notice] Apache/2.2.11 (Ubuntu)
mod_ssl/2.2.11 OpenSSL/0.9.8g Phusion_Passenger/3.0.2 configured --
resuming normal operations
[Wed Feb 02 11:06:02 2011] [error] [client 10.10.20.108] File does not
exist: /htdocs
[Wed Feb 02 11:06:02 2011] [error] [client 10.10.20.108] File does not
exist: /htdocs


Apache Access Log -

10.10.20.108 - - [02/Feb/2011:11:05:50 -0500] "GET / HTTP/1.1" 200 1711
"-" "Mozilla/5.0 (Windows NT 5.1; rv:2.0b8) Gecko/20100101
Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:11:05:50 -0500] "GET /AC_OETags.js
HTTP/1.1" 200 8349 "https://testabl.cyncsoftware.com/" "Mozilla/5.0
(Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:11:05:50 -0500] "GET /favicon.ico
HTTP/1.1" 200 1150 "-" "Mozilla/5.0 (Windows NT 5.1; rv:2.0b8)
Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:11:05:50 -0500] "GET /sikkim.swf HTTP/1.1"
200 2330779 "https://testabl.cyncsoftware.com/" "Mozilla/5.0 (Windows NT
5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:11:06:01 -0500] "GET /images/cync_logo.png
HTTP/1.1" 200 11606 "-" "Mozilla/5.0 (Windows NT 5.1; rv:2.0b8)
Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:11:06:01 -0500] "GET
/en_US_BaseResourceModule.swf HTTP/1.1" 200 42535 "-" "Mozilla/5.0
(Windows NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"
10.10.20.108 - - [02/Feb/2011:11:06:01 -0500] "GET
/skins/sundae/sundaec.swf HTTP/1.1" 200 94745 "-" "Mozilla/5.0 (Windows
NT 5.1; rv:2.0b8) Gecko/20100101 Firefox/4.0b8"

Rails Log -

It seems as if nothing is being logged to the Rails log during these
errors. I cleared out the App/log/production.log (rake log:clear)
before switching the port to 443 in VHost are when I access the site it
doesn't log anything to the production.log.


Thanks for the continued help.

--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Posted by Ruby on Rails at 8:20 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)