Project

General

Profile

Actions

Bug #10709

open

Issue with Hostgroups and Salt

Added by Dean Wilson almost 9 years ago. Updated almost 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

Hi,

When trying to edit host groups with the Salt plugin installed, I get this error. Screenshot attached.
Version is 1.8.1 running on RHEL 6.4.
We do have Puppet 3.7.x opensource running through foreman as well.

I've had no luck finding a solution, so hopefully someone can help me, as it would be really nice to have our saltstack managed from here.

Plugin installation text:
Resolving Dependencies
--> Running transaction check
---> Package ruby193-rubygem-foreman_salt-doc.noarch 0:2.1.0-1.el6 will be installed
--> Processing Dependency: ruby193-rubygem-foreman_salt = 2.1.0-1.el6 for package: ruby193-rubygem-foreman_salt-doc-2.1.0-1.el6.noarch
--> Running transaction check
---> Package ruby193-rubygem-foreman_salt.noarch 0:2.1.0-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================================================================================
Package Arch Version Repository Size =================================================================================================================================================================================================
Installing:
ruby193-rubygem-foreman_salt-doc noarch 2.1.0-1.el6 foreman-plugins 4.0 k
Installing for dependencies:
ruby193-rubygem-foreman_salt noarch 2.1.0-1.el6 foreman-plugins 201 k

Transaction Summary =================================================================================================================================================================================================
Install 2 Package(s)

Total download size: 205 k
Installed size: 2.5 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): ruby193-rubygem-foreman_salt-2.1.0-1.el6.noarch.rpm | 201 kB 00:00
(2/2): ruby193-rubygem-foreman_salt-doc-2.1.0-1.el6.noarch.rpm | 4.0 kB 00:00
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 97 kB/s | 205 kB 00:02
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : ruby193-rubygem-foreman_salt-2.1.0-1.el6.noarch 1/2
Installing : ruby193-rubygem-foreman_salt-doc-2.1.0-1.el6.noarch 2/2
Verifying : ruby193-rubygem-foreman_salt-doc-2.1.0-1.el6.noarch 1/2
Verifying : ruby193-rubygem-foreman_salt-2.1.0-1.el6.noarch 2/2

Installed:
ruby193-rubygem-foreman_salt-doc.noarch 0:2.1.0-1.el6

Dependency Installed:
ruby193-rubygem-foreman_salt.noarch 0:2.1.0-1.el6

Complete!

Thanks,


Files

salthostgroups.png View salthostgroups.png 8.67 KB Dean Wilson, 06/05/2015 12:57 AM
Untitled picture.png View Untitled picture.png 25.4 KB Dean Wilson, 06/09/2015 06:18 PM
dbtables.txt dbtables.txt 14.1 KB Dean Wilson, 07/05/2015 10:53 PM
Actions #1

Updated by Dominic Cleal almost 9 years ago

  • Project changed from Foreman to Salt
  • Category deleted (Plugin integration)

"PGError: ERROR: relation "hostgroup_salt_modules" does not exist".

Could you try running "foreman-rake db:migrate" please?

Actions #2

Updated by Dean Wilson almost 9 years ago

I tried running that, and I also did it as part of the upgrade I went through to upgrade to 1.8.1

Do you have any other suggestions?
Do you think this is a problem with the DB or something else?

Cheers,

Dean

Actions #3

Updated by Dean Wilson almost 9 years ago

Further to my last note, I did try that and still get the same issue.

Actions #4

Updated by Dean Wilson almost 9 years ago

Here is the full trace attached.

[[]]

Actions #5

Updated by Dominic Cleal almost 9 years ago

Was there any output from the command? Please provide any, and also the output from "foreman-rake db:migrate:status".

Also assuming you're using PostgreSQL, try "sudo -u foreman psql" and then "\d" to print a list of tables - include that output too.

It does appear to be a problem with the DB, seems like it hasn't run post-upgrade tasks.

Actions #6

Updated by Dean Wilson almost 9 years ago

There was no output from the status command.
Yes using Postgres sql.

Attached is the list of tables from \d.

Actions

Also available in: Atom PDF