[Users] OpenSER Administrator Release

[Mike Williams]

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 at openser.org [mailto:users-bounces at openser.org] On
> Behalf Of Mike Williams
> Sent: Monday, August 07, 2006 1:19 PM
> To: users at 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 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.
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users