[Users] OpenSER Administrator Release

Louis Alexander louis.alexander at logicacmg.com
Mon Aug 7 19:02:30 CEST 2006


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 at openser.org [mailto:users-bounces at openser.org] On Behalf
Of Mike Williams
Sent: Friday, August 04, 2006 10:38 AM
To: users at openser.org
Cc: devel at 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 at 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.




More information about the Users mailing list