theforeman / puppetdb_foreman

PuppetDB proxy in Foreman
http://theforeman.org
GNU General Public License v3.0
32 stars 23 forks source link

rubygem-puppetdb_foreman.noarch breaks foreman-rake #82

Open realvinx opened 1 year ago

realvinx commented 1 year ago

I got the following: Foreman 3.6.1 running on AlmaLinux 8.7 (CentOS 8 variant) installed puppetdb via packages:

# rpm -qa | grep puppetdb
puppetdb-7.13.0-1.el8.noarch
puppetdb-termini-7.13.0-1.el8.noarch

puppet agent works with puppetdb.

But after installing the puppetdb-plugin for foreman with "dnf install rubygem-puppetdb_foreman.noarch", the forman-installer fails, especially foreman-rake:

2023-04-20 13:26:10 [ERROR ] [configure] '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
2023-04-20 13:26:10 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from 'notrun' to ['0'] failed: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
2023-04-20 13:26:15 [NOTICE] [configure] 1000 configuration steps out of 1244 steps complete.
2023-04-20 13:26:17 [NOTICE] [configure] System configuration has finished.

  There were errors detected during install.
  Please address the errors and re-run the installer to ensure the system is properly configured.
  Failing to do so is likely to result in broken functionality.

  The full log is at /var/log/foreman-installer/foreman.log

foreman.log:

# grep ERROR /var/log/foreman-installer/foreman.log
2023-04-20 13:25:44 [NOTICE] [root] Use -l to set the terminal output log level to ERROR, WARN, NOTICE, INFO, or DEBUG. See --full-help for definitions.
2023-04-20 13:25:52 [DEBUG ] [configure] -D DEFAULT_ERRORLOG="logs/error_log"
2023-04-20 13:26:10 [INFO  ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: PG::UndefinedColumn: ERROR:  column settings.category does not exist
2023-04-20 13:26:10 [INFO  ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column settings.category does not exist
2023-04-20 13:26:10 [INFO  ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: PG::UndefinedColumn: ERROR:  column settings.category does not exist
2023-04-20 13:26:10 [ERROR ] [configure] '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
2023-04-20 13:26:10 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from 'notrun' to ['0'] failed: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]

foreman-rake db:migrate:status shows:

# foreman-rake db:migrate:status

database: foreman

 Status   Migration ID    Migration Name
--------------------------------------------------
   up     20090714132448  Create hosts
   up     20090714132449  Add audits table
   up     20090715143858  Create architectures
   up     20090717025820  Create media
   up     20090718060746  Create domains
   up     20090718064254  Create subnets
   up     20090720134126  Create operatingsystems
   up     20090722140138  Create models
   up     20090722141107  Create environmentsforeman puppet
   up     20090729132209  Create reports
   up     20090730152224  Create ptables
   up     20090802062223  Create puppetclassesforeman puppet
   up     20090804130144  Create parameters
   up     20090820130541  Create auth sources
   up     20090905150131  Create hostgroups
   up     20090905150132  Create hostgroups puppetclassesforeman puppet
   up     20090905155444  Add type to parameter
   up     20090907045751  Add domain to parameter
   up     20090916053824  Change host build default to false
   up     20090920043521  Add index to host
   up     20090920064156  Add index to parameters
   up     20090920065522  Add index to reports
   up     20091012135004  Create users
   up     20091016031017  Create sessions
   up     20091022054108  Add status to report
   up     20091219132338  Create lookup keys
   up     20091219132839  Create lookup values
   up     20100310080727  Add family to os
   up     20100414125652  Add releasename to os
   up     20100416124600  Create usergroups
   up     20100419151910  Add owner to hosts
   up     20100523141204  Create media operatingsystems and migrate data
   up     20100525094200  Simplify parameters
   up     20100601221000  Update os minor
   up     20100616114400  Change family in os
   up     20100625155400  Create notices
   up     20100628123400  Add internal auth
   up     20100629093200  Create roles
   up     20100701081235  Add user domains and hostgroups
   up     20100822072954  Create user facts
   up     20100823181036  Add enabled to hosts
   up     20100914092104  Add my booleans to user
   up     20101018120548  Create messages
   up     20101018120603  Create sources
   up     20101018120621  Create logs
   up     20101019122857  Add metrics to report
   up     20101019183859  Convert reports
   up     20101103150254  Add owned filter to user
   up     20101118130026  Correct media
   up     20101121080425  Create config templates
   up     20101121135521  Create template combinations
   up     20101121140000  Add environment to template combinationsforeman puppet
   up     20101122132041  Create operatingsystems config templates
   up     20101123152150  Create template kinds
   up     20101123153303  Create os default templates
   up     20101130093613  Add sub systems to subnet
   up     20101130100315  Create proxies
   up     20101202104444  Add proxy to domain
   up     20110117162722  Add host group defaults
   up     20110213104226  Create proxy features
   up     20110216101848  Change puppetmaster column
   up     20110301154453  Add managed to hosts
   up     20110327123639  Add priority to parameter
   up     20110404150043  Add media path to medium
   up     20110407091150  Add image to host
   up     20110412103238  Remove unused fields from puppet classesforeman puppet
   up     20110417102947  Add table bookmarks
   up     20110616080444  Add look up key id to puppet class
   up     20110617190131  Add sparc info to model
   up     20110619130336  Add ancestry to hostgroup
   up     20110628115422  Create settings
   up     20110712070522  Create host classforeman puppet
   up     20110801090318  Add vm defaults to hostgroup
   up     20110803114134  Add subnet and domain to host groups
   up     20111124095053  Rename changes to audited changes
   up     20111124095054  Add remote address to audits
   up     20111124095055  Rename parent to association
   up     20111205231500  Add gateway and dns to subnets
   up     20120102071633  Add from and to ranges to subnets
   up     20120110113051  Create subnet domain
   up     20120122131037  Create compute resources
   up     20120126113850  Add uuid and compute id to host
   up     20120311081257  Create nics
   up     20120313081913  Add puppet master proxy to host and host group
   up     20120502105518  Update report field to large int
   up     20120506143325  Create images
   up     20120509131302  Add cert name to host
   up     20120510113417  Create key pairs
   up     20120521142924  Add dns id to subnet
   up     20120523065531  Add image id to host
   up     20120529113900  Add user compute resources
   up     20120529115814  Add compute resources boolean to user
   up     20120607074318  Convert params to text
   up     20120612070100  Change bookmark column to text
   up     20120613082125  Rename association to associated
   up     20120621135042  Create taxonomies
   up     20120624081510  Add auditable name and associated name to audit
   up     20120624093958  Add os family to media
   up     20120624094034  Add os family to ptable
   up     20120705130038  Add attributes to compute resources
   up     20120824142048  Add some indexesforeman puppet
   up     20120905095532  Create environment classesforeman puppet
   up     20120905131841  Add lookup keys override and required
   up     20120916080843  Add lookup values count to lookup keys
   up     20120921000313  Add iam role to images
   up     20120921105349  Create tokens
   up     20121003172526  Add taxonomy ids to hosts
   up     20121011115320  Change domain character count
   up     20121015113502  Update media path limit
   up     20121018152459  Create hostgroup classesforeman puppet
   up     20121101141448  Add locations organizations
   up     20121118120028  Migrate hypervisors to compute resources
   up     20121118125341  Create taxable taxonomies
   up     20121119102104  Add my taxonomy to user
   up     20121210214810  Add subscribe to all hostgroups to users
   up     20121218084123  Change smart variable length
   up     20130109155024  Add ignore types to taxonomy
   up     20130121130826  Add digest to messages
   up     20130211160200  Add sti to hosts
   up     20130228145456  Add digest to sources
   up     20130409081924  Add label to host group
   up     20130417110127  Add sti to settings
   up     20130419145808  Add id to user hostgroup
   up     20130430150500  Add locale to users
   up     20130520161514  Add unique constraint to fact name
   up     20130523131455  Add unique constraints to fact values
   up     20130530061844  Change column lengths
   up     20130804131949  Add public to key pairs
   up     20130813105054  Change compute resource password to text
   up     20130814132531  Add ldap filter to auth sources
   up     20130908170524  Add keys
   up     20130924145800  Remove unused role fields
   up     20131014133347  Add compose flag and short name to fact name
   up     20131017142515  Allow null values on fact value
   up     20131021125612  Add type to fact name
   up     20131021152315  Change name index on fact name
   up     20131107094849  Add ancestry to fact names
   up     20131114084718  Extend user role
   up     20131114094841  Create cached user roles
   up     20131122170726  Create cached usergroup members
   up     20131125230654  Create realms
   up     20131128150357  Add admin flag to usergroup
   up     20131202120621  Create permissions
   up     20131202131847  Create filters
   up     20131202144415  Create filterings
   up     20131204174455  Add description to operatingsystem
   up     20131212125626  Add ldap avatar support
   up     20131223120945  Add userdata flag to images
   up     20131224153518  Create compute profiles
   up     20131224153743  Create compute attributes
   up     20131224154836  Add compute profile to hostgroup
   up     20140110164135  Add foreign keys to filters and filterings
   up     20140115130443  Add password to images
   up     20140123185537  Add default organization id to users
   up     20140123194519  Add default location id to users
   up     20140128123153  Add ancestry to taxonomies
   up     20140219183342  Change label to title
   up     20140219183345  Add taxonomy searches to filter
   up     20140304184854  Add provision method to hosts
   up     20140314004243  Add counter caches
   up     20140318221513  Change host managed default to false
   up     20140320000449  Add server type to auth source
   up     20140320004050  Add groups base to auth source
   up     20140325093623  Add lowerlogin to users
   up     20140407161817  Create config groupsforeman puppet
   up     20140407162007  Create config group classesforeman puppet
   up     20140407162059  Create host config groupsforeman puppet
   up     20140409031625  Create external usergroups
   up     20140410134234  Remove subscribe to all hostgroups from users
   up     20140415052549  Cleanup users properties
   up     20140415053029  Remove user join tables
   up     20140522122215  Add hidden value to parameter
   up     20140630114339  Add boot mode to subnet
   up     20140705173549  Add locked and default and vendor to config template
   up     20140707113214  Remove architecture default
   up     20140710132249  Extract nic attributes
   up     20140711142510  Add attributes to nic base
   up     20140716102950  Add managed to nics
   up     20140716140436  Change auditable name column to text
   up     20140725101621  Add primary interface to hosts
   up     20140728190218  Add ip suggestion to subnets
   up     20140805114754  Add unique index to parameter
   up     20140826104209  Add merge overrides and avoid duplicates to lookup key
   up     20140901115249  Add request uuid to audits
   up     20140902102858  Convert ipam to string
   up     20140908192300  Change nil admin users to false
   up     20140910111148  Add bond attributes to nic base
   up     20140910153654  Move host nics to interfaces
   up     20140912113254  Add password hash to operatingsystem
   up     20140912114124  Add grub password to hosts
   up     20140912145052  Add grub password to hostgroup
   up     20140915141937  Add should use puppet default to lookup value and key
   up     20140928131124  Add title to os
   up     20140928140206  Create widgets
   up     20140929073150  Create mail notifications
   up     20140929073343  Create user mail notifications
   up     20140930201523  Add mail enabled to user
   up     20141014131912  Add subscription type to mail notifications
   up     20141023114229  Add timezone to user
   up     20141112165600  Add type to parameter index
   up     20141116131324  Add mail query to user mail notification
   up     20141117093914  Add queryable to mail notification
   up     20141120140051  Remove audit user fk
   up     20141124055509  Rename smart proxy auth related settings
   up     20141217101211  Add compute attributes to nics
   up     20141225073211  Add description to taxonomies
   up     20150127085513  Set ptable layout to text
   up     20150212161904  Move description fields to text
   up     20150225131946  Change default subnet boot mode
   up     20150428070436  Add index to logs source
   up     20150428110835  Change os default password hash
   up     20150514072626  Add type to config template
   up     20150514114044  Migrate ptables to templates
   up     20150514121649  Add usergroup sync to auth sources
   up     20150521121315  Rename config template to provisioning template
   up     20150525081931  Remove duplicate tokens
   up     20150602153751  Change usergroup name to be required
   up     20150605073820  Fix template snippet flag
   up     20150606065713  Add sti to lookup keys
   up     20150612135546  Create host status
   up     20150616080015  Create core template input
   up     20150618093433  Remove unused fields from hosts
   up     20150622090115  Change reported at
   up     20150705131449  Add type to reports
   up     20150708070742  Add full name to setting
   up     20150713143226  Add unique to operatingsystems title
   up     20150714132601  Remove is param
   up     20150811170401  Add merge default to lookup key
   up     20150819105725  Add lookup value match to host and hostgroup
   up     20150827152730  Add options to core template input
   up     20150917155300  Update host status status field int
   up     20151009084350  Drop ptables
   up     20151019174035  Rename domain host count
   up     20151025120534  Add hidden value to lookup key
   up     20151104100257  Add hosts count to hostgroup
   up     20151109152507  Add host status host id index
   up     20151210143537  Add type to mail notification
   up     20160127134031  Add advanced to core template input
   up     20160201131211  Add expired logs to smart proxy
   up     20160203110216  Add default value for bookmark public field
   up     20160215143900  Add subnet domain relation constraints
   up     20160308102459  Remove permissions from roles
   up     20160315161936  Add encrypted to settings
   up     20160414063050  Add sti to subnets
   up     20160415134454  Add ipv6 to hosts
   up     20160415135858  Add ipv6 subnet
   up     20160527093031  Limit os description
   up     20160609092110  Remove nil from merge override
   up     20160616074718  Remove host counter cache
   up     20160715131352  Set role builtin default
   up     20160717125402  Unify permissions
   up     20160719081324  Change templates type default
   up     20160725142557  Add pxe loader to host
   up     20160726085358  Rename lookup value use puppet default
   up     20160727084256  Add description to user
   up     20160727142242  Add pxe loader to hostgroup
   up     20160728095626  Add description to role
   up     20160818091420  Add override flag to filter
   up     20160831121418  Rename lookup key use puppet default
   up     20160927071039  Create notification blueprints
   up     20160927071147  Create notifications
   up     20160927073233  Create notification recipients
   up     20161205142618  Delete orphaned smart class parametersforeman puppet
   up     20161227082709  Change architecture name limit
   up     20161227082721  Change usergroup name limit
   up     20170109115157  Fix lookup key auditable typeforeman puppet
   up     20170110113824  Change id value range
   up     20170118142654  Add auto increment to bigint ids
   up     20170118154134  Add type index to reports
   up     20170127094357  Add caching enabled to compute resource
   up     20170201135815  Add domain to compute resources
   up     20170209084517  Add actions to notification blueprint
   up     20170213154641  Add index reports on host id type
   up     20170214132230  Create ssh keys
   up     20170221100747  Add origin to roles
   up     20170226193446  Move subject to notifications
   up     20170228134258  Add clone info to role
   up     20170301155205  Remove widget hide
   up     20170306100129  Add message to notification
   up     20170315154334  Add report time type host index
   up     20170316142703  Add missing indexes to notification
   up     20170319131341  Add ancestry name index on fact name
   up     20170404134531  Add description to subnets
   up     20170424131346  Add description to hostgroup
   up     20170604082313  Add compute resource to hostgroup
   up     20170606115344  Change lookup key path to text
   up     20170608130132  Add use netgroups to ldap auth source
   up     20170610132326  Create personal access tokens
   up     20170622011347  Add http proxies
  down    20170717140010  Migrate puppetdb api version setting
   up     20170815130257  Add index to ssh keys
   up     20170911133318  Drop default type in templates
   up     20171016202300  Increase fact value size
   up     20171109095957  Add key type to parameters
   up     20171119094913  Add mtu to subnet
   up     20171126131104  Remove duplicate taxable taxonomies
   up     20171213161035  Add indexes on images
   up     20171225122601  Add version to auditable index
   up     20171231134017  Change vlan to int
   up     20180102082705  Add taxonomy index to hosts
   up     20180111130853  Add config reports origin
   up     20180123140634  Remove limit ldap filter
   up     20180129143410  Create jwt secrets
   up     20180208053256  Create table preferences
   up     20180216094550  Add template to subnets
   up     20180305111232  Add build errors to hosts
   up     20180312080251  Change digests limit
   up     20180424080702  Change subnet vlanid size
   up     20180613100703  Add type to token
   up     20180702102759  Remove params value limit
   up     20180705191153  Add upgrade task
   up     20180705230311  Smart proxy capabilities
   up     20180713154128  Add index on role names
   up     20180715202514  Optimize indices
   up     20180806151925  Add subnet name unique constraint
   up     20180816110716  Add httpboot do subnet
   up     20180816134832  Cast lookup key valuesforeman puppet
   up     20180820072858  Add help text to template kinds
   up     20180831115634  Add uniqueness to puppetclass nameforeman puppet
   up     20180904142922  Add nic delay to subnet
  down    20181001113836  Remove puppetdb dashboard address settingpuppetdb foreman
   up     20181023112532  Add environment puppetclass idforeman puppet
   up     20181101101145  Add index to lookup values
   up     20181224174419  Add index to environment class by lookup key and puppetclassforeman puppet
   up     20190116120705  Remove timestamps from logs
   up     20190121084601  Change compute resource password length
   up     20190225115728  Create stored values
   up     20190226182746  Create registration facets
   up     20190228160047  Add value type and resource type to template input
   up     20190510082811  Add taxonomy id taxable type indices to taxable taxonomies
   up     20190604081000  Change root pass in host
   up     20190627083110  Change token value type
   up     20190630034751  Create host facets reported data facets
   up     20190705060630  Add searchable value to parameters
   up     20190821135704  Feature unique name
   up     20190829102315  Http proxy unique name
   up     20190918170516  Add default to template inputs
   up     20190919155550  Add description to templates
   up     20191001120743  Add fields to reported data facet
   up     20191017151119  Add external ipam id to subnets
   up     20191028082812  Remove limit from root pass
   up     20200107181613  Add foreman internal table
   up     20200127103144  Ssh keys fingerprints sha1
   up     20200129123555  Add disabled to users
   up     20200205105956  Drop parameterized classes setting
   up     20200217110708  Alter session sequence to cycle
   up     20200311131527  Drop smart variable permissions
   up     20200311134414  Change match to text in lookupvalue
   up     20200318135632  Rename report templates
   up     20200324210540  Rename default variable lookup path
   up     20200326164755  Change oidc audience setting type
   up     20200402190048  Add hidden value to template input
   up     20200406113832  Drop variable lookup key
   up     20200427151946  Drop rackspace cr
   up     20200513092446  Change config chart class
   up     20200521082853  Rename cent os7 install media
   up     20200525073201  Drop puppet class id from look up key
   up     20200602155700  Drop puppet run
   up     20200615071719  Add bmc to subnet
   up     20200616134403  Remove setting enable orchestration
   up     20200625081552  Add unique index to lookup value
   up     20200709160133  Set empty filter taxonomy search nil
   up     20200720123005  Migrate puppet core typesforeman puppet
   up     20200722171017  Create host puppet facetforeman puppet
   up     20200803113531  Create hostgroup puppet facetforeman puppet
   up     20200803113803  Migrate environment to puppet facetforeman puppet
   up     20200803113903  Migrate host type in host config groupsforeman puppet
   up     20200825121733  Drop compare content host template
   up     20200908120905  Rebuild taxonomy search
   up     20200911083030  Use hash index for reports
   up     20200918223816  Update login delegation description
   up     20200921135723  Create host facets infrastructure facets
   up     20201030102020  Enlarge report status
   up     20201125113903  Migrate puppetclasses to facetsforeman puppet
   up     20201224095619  Remove ovirt use api from attr
   up     20210114143800  Nilify empty proxy credentials
   up     20210115124508  Template kind registration
   up     20210317090500  Add disks total to host facets
   up     20210317170111  Remove the remote add setting
   up     20210401124332  Drop db pending migration setting
   up     20210407104300  Downcase mac addresses
   up     20210502113529  Drop view bookmarks permission
   up     20210525144427  Enforce unique templates
   up     20210609093404  Drop override taxonomies from filter
   up     20210610131920  Restrict sendmail location
   up     20210901081438  Drop view tasks permission
   up     20210915132645  General setting to dsl
   up     20210924103241  Remove katello id from environmentsforeman puppet
   up     20210929132645  Core setting to dsl
   up     20211111115000  Drop fix db cache setting
   up     20211111125003  Drop puppetclasses direct referencesforeman puppet
   up     20211112130803  Cleanup environment from core tablesforeman puppet
   up     20220111110149  Drop require ssl smart proxies setting
   up     20220124174632  Drop setting fields
   up     20220201205305  Migrate host class permissionforeman puppet
   up     20220204155632  Rename job report template
   up     20220208134539  Rename cent os stream os
   up     20220208135305  Migrate environment ignore typeforeman puppet
   up     20220421204325  Drop environment from host and hgforeman puppet
   up     20220515130414  Drop unnecessary timestamps
   up     20220628083024  Change default value for mail enabled to user
   up     20220630104300  Fix facet audits
   up     20220809191656  Add ssl ca to http proxy
   up     20220907145552  Clean trends and foreman docker data
   up     20221010174230  Add kernel version to host facets
   up     20221017161042  Remove host power status from settings
   up     20221025151600  Add creator id to hosts
  down    20221026123754  Fix puppetdb settings category to dsl
   up     20221102134032  Add bios to host facets
   up     20221126232030  Remove category from settings

When I restart foreman (systemctl restart foreman) the WebUI is broken and shows the following error:

 Service unavailable ERF64-6496 [Foreman::MaintenanceException]: There are migrations pending in the system.

When I uninstall rubygem-puppetdb_foreman.noarch with "dnf remove rubygem-puppetdb_foreman.noarch" und rerun foreman-installer it works again.

Any hints or ideas what's going wrong here ?

realvinx commented 1 year ago

here's the version of rubygem-puppetdb_foreman that I used: rubygem-puppetdb_foreman-6.0.1-1.fm3_5.el8.noarch