Google seems to suggest that it might be a permissions problem: remember that
to MySQL, localhost and 127.0.0.1 are different. You may want to look at this
link:
Mike,
I'm having trouble logging into the OpenSER Administrator. I get
the following error in my browser:
Got any tips?
ActiveRecord::StatementInvalid in LoginController#login
Mysql::Error: Lost connection to MySQL server during query: SELECT * FROM
users WHERE (login = 'openser' AND password =
'0dd62bae0b6b4d8e0388c620134decb8405b6976') LIMIT 1
RAILS_ROOT: script/../config/..
Application Trace | Framework Trace | Full Trace
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/abstract_adapter.rb:120:in `log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:184:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:336:in `select'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:175:in `select_all'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:390:in `find_by_sql'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:924:in `find_every'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:918:in `find_initial'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:380:in `find'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/dep
r ecated_finders.rb:22:in `find_first'
#{RAILS_ROOT}/app/models/user.rb:7:in `authenticate'
app/controllers/login_controller.rb:11:in `login'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/abstract_adapter.rb:120:in `log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:184:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:336:in `select'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:175:in `select_all'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:390:in `find_by_sql'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:924:in `find_every'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:918:in `find_initial'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:380:in `find'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/dep
r ecated_finders.rb:22:in `find_first'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
a se.rb:910:in `perform_action_without_filters'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/f
i lters.rb:368:in `perform_action_without_benchmark'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
e nchmarking.rb:69:in `perform_action_without_rescue'
/usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
e nchmarking.rb:69:in `perform_action_without_rescue'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/r
e scue.rb:82:in `perform_action'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
a se.rb:381:in `process_without_filters'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/f
i lters.rb:377:in `process_without_session_management_support'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/s
e ssion_management.rb:117:in `process'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/dispatcher.rb:38:in
`dispatch'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:115:in
`handle_dispatch'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:81:in
`service'
/usr/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/local/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/local/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/local/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/local/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/local/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/local/lib/ruby/1.8/webrick/server.rb:23:in `start'
/usr/local/lib/ruby/1.8/webrick/server.rb:82:in `start'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:67:in
`dispatch'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/servers/webrick.
r b:59
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/de
p endencies.rb:147:in `require'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/server.rb:30
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/de
p endencies.rb:147:in `require'
script/server:3
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/abstract_adapter.rb:120:in `log'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:184:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:336:in `select'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/con
n ection_adapters/mysql_adapter.rb:175:in `select_all'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:390:in `find_by_sql'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:924:in `find_every'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:918:in `find_initial'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/bas
e .rb:380:in `find'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/dep
r ecated_finders.rb:22:in `find_first'
#{RAILS_ROOT}/app/models/user.rb:7:in `authenticate'
app/controllers/login_controller.rb:11:in `login'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
a se.rb:910:in `perform_action_without_filters'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/f
i lters.rb:368:in `perform_action_without_benchmark'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
e nchmarking.rb:69:in `perform_action_without_rescue'
/usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
e nchmarking.rb:69:in `perform_action_without_rescue'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/r
e scue.rb:82:in `perform_action'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/b
a se.rb:381:in `process_without_filters'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/f
i lters.rb:377:in `process_without_session_management_support'
/usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/s
e ssion_management.rb:117:in `process'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/dispatcher.rb:38:in
`dispatch'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:115:in
`handle_dispatch'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:81:in
`service'
/usr/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/local/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/local/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/local/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/local/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/local/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/local/lib/ruby/1.8/webrick/server.rb:23:in `start'
/usr/local/lib/ruby/1.8/webrick/server.rb:82:in `start'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:67:in
`dispatch'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/servers/webrick.
r b:59
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/de
p endencies.rb:147:in `require'
/usr/local/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/server.rb:30
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require'
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/de
p endencies.rb:147:in `require'
script/server:3
Request
Parameters: {"user_login"=>"openser",
"user_password"=>"openserrw",
"login"=>"Login \302\273"}
Show session dump
---
return-to: /login
flash: !map:ActionController::Flash::FlashHash {}
Response
Headers: {"cookie"=>[], "Cache-Control"=>"no-cache"}
-----Original Message-----
From: users-bounces(a)openser.org [mailto:users-bounces@openser.org] On
Behalf Of Mike Williams
Sent: Friday, August 04, 2006 10:38 AM
To: users(a)openser.org
Cc: devel(a)openser.org
Subject: [Users] OpenSER Administrator Release
All,
I've just finished my first release of OpenSER Administrator, a web
interface
for managing OpenSER. It's GPL'd and written in Ruby on Ralis, and can be
downloaded from
openseradmin.sourceforge.net
Please let me know what you think, and let me know of any features you
want,
bugs you find, etc.
Thanks,
Mike Williams
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an
intended recipient then please promptly delete this e-mail and any
attachment and all copies and inform the sender. Thank you.