[Users] OpenSER Administrator Release

Mon Aug 7 19:19:19 CEST 2006

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: http://www.adamsdesk.com/be/?p=177

Mike

On Monday 07 August 2006 01:02, Louis Alexander wrote:
> 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 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.