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/conn ection_adapters/abstract_adapter.rb:120:in `log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:184:in `execute' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:336:in `select' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:175:in `select_all' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:390:in `find_by_sql' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:924:in `find_every' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:918:in `find_initial' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:380:in `find' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/depr 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/conn ection_adapters/abstract_adapter.rb:120:in `log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:184:in `execute' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:336:in `select' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:175:in `select_all' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:390:in `find_by_sql' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:924:in `find_every' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:918:in `find_initial' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:380:in `find' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/depr ecated_finders.rb:22:in `find_first' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/ba se.rb:910:in `perform_action_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/fi lters.rb:368:in `perform_action_without_benchmark' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/be 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/be nchmarking.rb:69:in `perform_action_without_rescue' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/re scue.rb:82:in `perform_action' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/ba se.rb:381:in `process_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/fi lters.rb:377:in `process_without_session_management_support' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/se 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/dep 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/dep endencies.rb:147:in `require' script/server:3
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/abstract_adapter.rb:120:in `log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:184:in `execute' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:336:in `select' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/conn ection_adapters/mysql_adapter.rb:175:in `select_all' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:390:in `find_by_sql' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:924:in `find_every' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:918:in `find_initial' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base .rb:380:in `find' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/depr 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/ba se.rb:910:in `perform_action_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/fi lters.rb:368:in `perform_action_without_benchmark' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/be 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/be nchmarking.rb:69:in `perform_action_without_rescue' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/re scue.rb:82:in `perform_action' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/ba se.rb:381:in `process_without_filters' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/fi lters.rb:377:in `process_without_session_management_support' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/se 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/dep 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/dep 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@openser.org [mailto:users-bounces@openser.org] On Behalf Of Mike Williams Sent: Friday, August 04, 2006 10:38 AM To: users@openser.org Cc: devel@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@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.