I would like to know how i could “migrate” an existing foreman to a Katello server.
I read the docs and know it isn’t supported but still i would like to try to see if it’s possible on my sandbox environment.
I didn’t find so much resources so i don’t know if anyone ever tried. So what could be the best lead so far to begin to dig?
Trying to install katello on top of an existing foreman and debug manually?
Setup a new Katello and export the existing database somehow ?
The easiest way is to simply install a new Katello, import the database and then run foreman-rake db:seed and foreman-rake db:migrate. Make sure that orgs and locations are already enabled in your pure Foreman instance.
But isn’t the foreman database different from Katello database? If i import the foreman existing database into Katello it would overwrite all the Katello specified tables or am i wrong?
Is it a special way of importing?
There is an import/export plugin which creates *.csv files. It seems to run rather without issues even in big environments.
This way you avoid database issues but sometimes you face new required fields or something like that. Depends on the size of your jump from version to version.
So far:
DB method : I got plenty of errors as i would have expected from the dump here is the log if you are curious https://pastebin.com/c4CQLzR4
Nevertheless, if i continue the db:seed detect correctly that the database need some migration and prompt this list https://pastebin.com/6HPAF8cH
But then, the migrate fail because of constraints on existing tables. https://pastebin.com/mZed0BMa
I tried tot drop the database before but with no success since the import_dump task need the ‘foreman’ named database to be existing.
Hammer method : i only manage to export settings from foreman. i’m still trying to get a grasp of how to use the tool to generate a full dump of the database objects.
Can you restore the database on an instance without Katello?
What I did was to use a foreman instance and a katello instance. Both were connected to the same database. First I got the foreman instance running, then I shut down the foreman instance, started the katello one and ran db:migrate and db:seed.
I believe you might have issues because your database is already migrated and you try to restore a dump that does not match your schema. But that’s just a wild guess to be honest.
Little update : I found a way to continue with the database dump solution.
I just drop the foreman database and then recreate it using db:create (it didn’t work before because i didn’t ALTER USER foreman CREATEDB; prior to the db:create command)
The migrate do stuff but stuck once on the 20141209103005 DisownForemanTemplates step wich i debugged using a fix found in an old IRC conversation log (https://botbot.me/freenode/theforeman-dev/2018-06-21/?page=2)
Now i’m stuck in another migration step but i don’t find any ressource on it.
== 20160404132250 RemoveKatelloFromNotificationName: migrating ================
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
Invalid single-table inheritance type: ConfigManagementError is not a subclass of RemoveKatelloFromNotificationName::FakeMailNotification
I bet i need to modifiy some stuff in db/migrate/20160404132250_remove_katello_from_notification_name.rb in order for this step to pass but i’m not fluent enough in ruby to decipher what.
So i’ve found a workaround to make it work more properly just by adding
self.inheritance_column = nil
in the class definition header of
db/migrate/20160404132250_remove_katello_from_notification_name.rb
and
db/migrate/20160426145517_move_host_description_to_host_comment.rb
@devs Is it a clean enough workaround? Or does it break stuff?
The interface is working properly and after copying the encryption key located in /etc/foreman/encryption_key.rb i’m able to connect using LDAP.
I can see my hosts and stuff, but they are all out of sync.
Next step is to correct that.
New trouble : I can now acess to the Content panel, wich is good, so i’m trying to add a new product but when i input a name and label i get this error.
Moreover, when i try to force the foreman-tasks to run i get this : ~]# RAILS_ENV=production runuser -u foreman /opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.2/bin/foreman-tasks run /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in ``require': cannot load such file -- apipie/middleware/checksum_in_headers (LoadError) from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in require’ from /usr/share/foreman/config/application.rb:5:in <top (required)>’ from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in require’ from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in require’ from /opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.13.2/bin/foreman-tasks:5:in ’
