sr-users

sr-users@lists.kamailio.org

5 participants
37457 discussions

[Users] The lcr module has incorrect syntax for the current mysql release
by Brandon Price 07 Aug '06

07 Aug '06

Of coarse I found this out after upgrading my test box from mysql 5.0.19 to 5.0.22. The lcr module runs the following query... SELECT gw.ip_addr, gw.port, gw.uri_scheme, gw.transport, gw.strip, gw.prefix FROM gw, lcr WHERE ''<sip:12345678910@eastern.mynoc.net>'' LIKE lcr.from_uri AND '15184782222' LIKE CONCAT(lcr.prefix, '%') AND lcr.grp_id = gw.grp_id ORDER BY CHAR_LENGTH(lcr.prefix), lcr.priority DESC, RAND() which returns ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':12345678910@eastern.mynoc.net>'' LIKE lcr.from_uri AND '15184782222' LIKE CONCA' at line 1 the correct query would be ... SELECT gw.ip_addr, gw.port, gw.uri_scheme, gw.transport, gw.strip, gw.prefix FROM gw, lcr WHERE '<sip:12345678910@eastern.mynoc.net>' LIKE lcr.from_uri AND '15184782222' LIKE CONCAT(lcr.prefix, '%') AND lcr.grp_id = gw.grp_id ORDER BY CHAR_LENGTH(lcr.prefix), lcr.priority DESC, RAND(); Notice that I removed the double single quotes around <sip: 12345678910(a)eastern.mynoc.net> which is the from uri. This appears to be broken in current cvs as well.

3 6

Re: [Serusers] Cisco like translation rules in SER.
by Jiri Kuthan 07 Aug '06

07 Aug '06

There is a buch of commands you can use for uri maniputlation: strip, prefix, subst_uri. -jiri At 15:52 25/07/2006, Robert Zorop wrote: >Hi guys. > I'd like to hear about different methods of implementing cisco like transtation rules in SER. I was thinking about AVPs, but still couldn't find the ight way. > Is someone is doing it inside or outside ser, please shed a light on this!. What i need is to stip some numbers, and then add some other (variables) before proxying the calls. > > >Thanks in advance. > >_______________________________________________ >Serusers mailing list >Serusers(a)lists.iptel.org >http://lists.iptel.org/mailman/listinfo/serusers -- Jiri Kuthan http://iptel.org/~jiri/

3 4

Re: [Users] OpenSER Administrator Release
by Mike Williams 07 Aug '06

07 Aug '06

It's done on SVN. Thanks for the tip. Let me know what you think of the release. Mike On Monday 07 August 2006 02:53, Louis Alexander wrote: > Gem install mysql worked great! > > You might want to add this to your INSTALL document as it is not in there. > 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 2:40 PM > To: users(a)openser.org > Subject: Re: [Users] OpenSER Administrator Release > > 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 > > _______________________________________________ > Users mailing list > Users(a)openser.org > http://openser.org/cgi-bin/mailman/listinfo/users

1 0

Re: [Users] OpenSER Administrator Release
by Mike Williams 07 Aug '06

07 Aug '06

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

1 0

[Users] Confused on routing...
by Marvin Ottley 07 Aug '06

07 Aug '06

Hello all, I'm trying to implement routing in general and I'm also trying to use the lcr module. I'm a little confused as to where in the picture does xml fit in. While reading through documentation I came across the acronym RPID which seems to be an implementation of routing information in an xml document, that's passed to lcr module as a parameter. What are the mechanics behind this? Thanks in advance for your help, Marvin

2 1

[Users] OpenSER Administrator Release
by Mike Williams 07 Aug '06

07 Aug '06

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

2 2

[Serusers] SER + Asterisk PSTN calls don't hung up
by Ricardo Carvalho 07 Aug '06

07 Aug '06

Hi, I'm deploying a SER + Asterisk architecture, where SER is used to manage acc, users database and sip routing, and Asterisk is used for voicemail and PSTN gateway. The system is already able to make and receive calls from the PSTN, although, only after the call has been established it can be hung up with success; when it is still ringing, if any side hungs up the call, it still keeps ringing on the other side. Observing with Ethereal, we concluded that in this erroneous cases, the CANCEL SIP request isn't transmitted from the SER to Asterisk (if cancelled from the VoIP side) being transmitted a "404 User Not Found" message from SER to Sip Phone. If hung from the PSTN side, the sip phone keeps calling after that, and ends calling by time-out being observed a "486 Busy Here" status message from Asterisk to SER and then from SER to sip phone. Any help, please? Regards, Ricardo.

1 1

Re: [Serusers] mysql change tcp port
by Andrey Kouprianov 07 Aug '06

07 Aug '06

Wow! Thanx!!! On 8/7/06, sip <sip(a)arcdiv.com> wrote: > Usually, that's done in the /etc/my.cnf file. Is it not working there? > > My my.cnf file has a client ([client]) and server ([mysqld]) section. > > My server section (the non-commented part) looks like: > > [mysqld] > port = 3306 > socket = /var/lib/mysql/mysql.sock > > The client section looks the same (since I like the defaults to work the same > when connecting via the command-line client): > > [client] > [mysqld] > port = 3306 > socket = /var/lib/mysql/mysql.sock > > > There were a few packages I had that didn't come with an /etc/my.cnf file but > still read from one if it was there. > > N. > > On Mon, 7 Aug 2006 19:47:54 +0700, Andrey Kouprianov wrote > > Hi, > > > > I know it's the wrong list and I dont even expect anyone to answer. > > Anyway... Does anyone know how to specify different listening TCP > > port and socket name when installing mysql server from FreeBSD ports? > > > > Andrey. > > _______________________________________________ > > Serusers mailing list > > Serusers(a)lists.iptel.org > > http://lists.iptel.org/mailman/listinfo/serusers > >

1 0

[Serusers] mysql change tcp port
by Andrey Kouprianov 07 Aug '06

07 Aug '06

Hi, I know it's the wrong list and I dont even expect anyone to answer. Anyway... Does anyone know how to specify different listening TCP port and socket name when installing mysql server from FreeBSD ports? Andrey.

1 0

[Users] routes configurations
by Lens Oreste 07 Aug '06

07 Aug '06

Hi all I am new to openser and would like to configure my routes. I would like to have some samples. Please point me on the right direction. Regards Lens Oreste

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users