Re: [Users] OpenSER Administrator Release - sr-users

7 Aug 2006

Hmm,

Did you run 'gem install mysql'? According to some websites, this is needed. 
Also, what OS and version of MySQL are you running?

Mike

On Monday 07 August 2006 02:03, Louis Alexander wrote:
...
  Unfortunately (fortunately?) I've allowed that
user under the machines
 domain name, 127.0.0.1, and localhost.  Yet the issue still persists.  Ill
 keep trying to figure it out.

 Thanks

 Louis

 -----Original Message-----
 From: users-bounces(a)openser.org [mailto:users-bounces@openser.org] On
 Behalf Of Mike Williams
 Sent: Monday, August 07, 2006 1:19 PM
 To: users(a)openser.org
 Subject: Re: [Users] OpenSER Administrator Release

 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:i
n `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:i
n `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.

 _______________________________________________
 Users mailing list
 Users(a)openser.org
 http://openser.org/cgi-bin/mailman/listinfo/users 