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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Mike Williams > Sent: Monday, August 07, 2006 1:19 PM > To: [email protected] > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Mike Williams > > Sent: Friday, August 04, 2006 10:38 AM > > To: [email protected] > > Cc: [email protected] > > 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 > > [email protected] > > 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 > [email protected] > http://openser.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
