Project

General

Profile

Feature #545

Support Oracle SGBD -- Not seen puppet classes list into page ENVIRONMENTS (Oracle DB)

Added by Nikolay Aralovets over 8 years ago. Updated about 3 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

Hello,
I try to see all puppet classes for ENVIRONMENT (http://srv2-itd-sag04.net.billing.ru:3000/environments) page. After click in "http://srv2-itd-sag04.net.billing.ru:3000/puppetclasses?search[environments_id_equals]=10000" link Foreman is returning Internal Error 500. In error_log:
Processing PuppetclassesController#index (for 172.30.64.135 at 2010-12-17 10:40:01) [GET]
Parameters: {"search"=>{"environments_id_equals"=>"10000"}}

ActiveRecord::StatementInvalid (OCIError: ORA-00918: column ambiguously defined: select * from (SELECT "PUPPETCLASSES".* FROM "PUPPETCLASSES" INNER JOIN "ENVIRONMENTS_PUPPETCLASSES" ON "ENVIRONMENTS_PUPPETCLASSES".puppetclass_id = "PUPPETCLASSES".id INNER JOIN "ENVIRONMENTS" ON "ENVIRONMENTS".id = "ENVIRONMENTS_PUPPETCLASSES".environment_id WHERE (environments.id = 10000) ORDER BY name) where rownum <= 20):
/usr/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:948:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.1/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:906:in `select'
app/controllers/puppetclasses_controller.rb:8:in `index'
app/controllers/puppetclasses_controller.rb:5:in `index'
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /var/rails/foreman/public/500.html (500 Internal Server Error)

Working request on PL/SQL looks as:
SELECT * FROM (SELECT "PUPPETCLASSES".* FROM "PUPPET"."PUPPETCLASSES"
INNER JOIN "PUPPET"."ENVIRONMENTS_PUPPETCLASSES" ON "ENVIRONMENTS_PUPPETCLASSES".puppetclass_id = "PUPPETCLASSES".id
INNER JOIN "PUPPET"."ENVIRONMENTS" ON "ENVIRONMENTS".id = "ENVIRONMENTS_PUPPETCLASSES".environment_id
WHERE (environments.id = 10000) ORDER BY environments.name) where rownum <= 20;
Couldn't you editing in used controllers?

History

#1 Updated by Ohad Levy about 8 years ago

  • Status changed from New to Feedback

can you try removed the default_scope value from app/models/environment.rb and see if that errors remains?

#2 Updated by Nikolay Aralovets about 8 years ago

Try...

#3 Updated by Benjamin Papillon almost 7 years ago

  • Tracker changed from Bug to Feature
  • Subject changed from Not seen puppet classes list into page ENVIRONMENTS (Oracle DB) to Support Oracle SGBD -- Not seen puppet classes list into page ENVIRONMENTS (Oracle DB)

I update this ticket as Feature request. Devs are lacking a test environment to validate oracle right now.

#4 Updated by Tomer Brisker about 3 years ago

  • Description updated (diff)
  • Status changed from Feedback to Rejected

Oracle DB is not supported by Foreman as a backend. Please use a supported database such as PostgreSQL or MySQL.

Also available in: Atom PDF