# Error during running demo.rb file of Service Merchant

**URL:** <https://www.ruby-forum.com/t/error-during-running-demo-rb-file-of-service-merchant/170338>\
**Category:** Rails\
**Created:** [June 16, 2009, 10:31am UTC](https://www.ruby-forum.com/t/error-during-running-demo-rb-file-of-service-merchant/170338 "2009-06-16T10:31:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikas](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/ac91a4/32.png) [@vikas](https://www.ruby-forum.com/u/vikas)\
**Post date:** [June 16, 2009, 10:31am UTC](https://www.ruby-forum.com/t/error-during-running-demo-rb-file-of-service-merchant/170338/1 "2009-06-16T10:31:04Z")

</div>

Hello all,

I’m trying to use service merchant plugin in my application.

i installed plugin in vendor/plugins dir.

I am using mysql database. so i changed database configuration in two  
files of service\_merchant

1)“vendor\plugins\service\_merchant\tracker\test\connection.rb” and  
“vendor\plugins\service\_merchant\subscription\_management\test” as  
following

require ‘rubygems’  
gem ‘activerecord’  
require ‘activerecord’  
#gem ‘sqlite3-ruby’

ActiveRecord::Base.establish\_connection(  
:adapter =\> “mysql”,  
:database =\> “sarasave\_service\_marchant”,  
:username =\> “root”,  
:password =\> “myroot”,  
:host =\> “localhost”  
)

now i created database successfully. using

rake service\_merchant:create\_all\_tables

but when i run “demo.rb” file then i got following error of  
ConnectionNotEstablished -----

F:\sarasaves\_service\_merchant\sarasaves\vendor\plugins\service\_merchant\>ruby  
dem  
o.rb --trace  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record/connection\_a  
dapters/abstract/connection\_pool.rb:326:in `retrieve_connection': ActiveRecord:: ConnectionNotEstablished (ActiveRecord::ConnectionNotEstablished) from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record /connection_adapters/abstract/connection_specification.rb:123:in`retrieve\_conne  
ction’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record  
/connection\_adapters/abstract/connection\_specification.rb:115:in  
`connection' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record /base.rb:1276:in`columns’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record  
/base.rb:3008:in `attributes_from_column_definition_without_lock' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record /locking/optimistic.rb:66:in`attributes\_from\_column\_definition’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active\_record  
/base.rb:2435:in `initialize' from ./subscription_management/lib/subscription_management.rb:82:in`new  
’  
from  
./subscription\_management/lib/subscription\_management.rb:82:in `sub  
scribe’  
from demo.rb:55

* * *

I tried subscription = Subscription.new in my application console then  
it runs

F:\sarasaves\_service\_merchant\sarasaves\>ruby script/console  
Loading development environment (Rails 2.3.2)

> > subscription = Subscription.new  
> > =\> #\<Subscription id: nil, account\_id: nil, tariff\_plan\_id: nil,  
> > taxes\_id: nil,  
> > quantity: nil, currency: nil, net\_amount: nil, taxes\_amount: nil,  
> > periodicity: n  
> > il, starts\_on: nil, ends\_on: nil, status: nil, created\_at: nil,  
> > updated\_at: nil,  
> > deleted\_at: nil\>

I don’t understand what’s the problem to run demo.rb?

please tell me what went wrong, if any one used service merchant  
plugin.

---

<div class="post-metadata">

**Author:** ![vikas](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/ac91a4/32.png) [@vikas](https://www.ruby-forum.com/u/vikas)\
**Post date:** [June 16, 2009, 5:47pm UTC](https://www.ruby-forum.com/t/error-during-running-demo-rb-file-of-service-merchant/170338/2 "2009-06-16T17:47:07Z")

</div>

Looks like you configure connection in the wrong place. When  
installed as plugin, service\_merchant uses connection defined in  
`config/database.yml` file of your Rails app.

What you have changed is a special connection that’s only used in  
service\_merchant internal unit tests.

On 16 июн, 12:31, Vikas G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)