[Katello] Remote Database

Hi,

Ideally I would like the option to configure Katello with a remote
database. This is supported in Foreman, but from what I can see candlepin
installation scripts are hard coded to assume a local db. Is there any
technical reason for this? I would have assumed it's just a JDBC connection
and is agnostic about the location?

Thanks,

Alan

The install scripts don't do a great job of managing. I've actually had to
break candlepin upgrades for it to work on my end. There is a bug
report/enhancement request for this. I'll see if I can dig up the link.

Ultimately, you can point the candlepin.conf to an external server, but you
will have issues during upgrades.

··· On Mar 28, 2017 14:13, wrote:

Hi,

Ideally I would like the option to configure Katello with a remote
database. This is supported in Foreman, but from what I can see candlepin
installation scripts are hard coded to assume a local db. Is there any
technical reason for this? I would have assumed it’s just a JDBC connection
and is agnostic about the location?

Thanks,

Alan


You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

Hi

I just report our experience :slight_smile: if anyone has better experience I'm
interested to hear it.

We tried to move all DB outside of Foreman using Postgres clusters but we
had a really hard time special if used with Katello.

We didn't try to export the database witch might bring to better results
instead we kind of initialized again but this process lost from time to
time the creation of the keys and other stuff creating very weird issue
not very easy to troubleshot.

The main reason we didn't proceed further was that every update could break
it overwriting the manual configuration of the exteral dbs.

··· On Tuesday, March 28, 2017 at 8:13:20 PM UTC+2, apgrif...@gmail.com wrote: > > Hi, > > Ideally I would like the option to configure Katello with a remote > database. This is supported in Foreman, but from what I can see candlepin > installation scripts are hard coded to assume a local db. Is there any > technical reason for this? I would have assumed it's just a JDBC connection > and is agnostic about the location? > > Thanks, > > Alan >

How did you set it up initially? Let foreman-installer create a local DB
then transfer it to a remote host and update candlepin.conf ?

··· On 28 March 2017 at 19:55, Neil Hanlon wrote:

The install scripts don’t do a great job of managing. I’ve actually had to
break candlepin upgrades for it to work on my end. There is a bug
report/enhancement request for this. I’ll see if I can dig up the link.

Ultimately, you can point the candlepin.conf to an external server, but
you will have issues during upgrades.

On Mar 28, 2017 14:13, apgriffiths79@gmail.com wrote:

Hi,

Ideally I would like the option to configure Katello with a remote
database. This is supported in Foreman, but from what I can see candlepin
installation scripts are hard coded to assume a local db. Is there any
technical reason for this? I would have assumed it’s just a JDBC connection
and is agnostic about the location?

Thanks,

Alan


You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “Foreman users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/foreman-users/Krz_wMppo1g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

Hey,
you can have a look at the current work to externalize services within a katello install. Free free to work & test with us :slight_smile: Some of the puppet modules already support it, you can try to use them directly. https://github.com/Katello/puppet-candlepin/pull/62 for example is for external db with candlepin. https://github.com/Katello/puppet-katello/pull/171 is a work in progress PR for the katello module. Any input is appreciated and testing is always welcome. Currently I doubt all changes will be ready for katello 3.4 – more like 3.5 or later.

Greetings
Klaas Demter

ATIX - The Linux & Open Source Company
www.atix.de

----- Ursprüngliche Mail -----

··· Von: "marco giovannini" An: "Foreman users" Gesendet: Donnerstag, 30. März 2017 11:35:49 Betreff: [foreman-users] Re: [Katello] Remote Database

Hi

I just report our experience :slight_smile: if anyone has better experience I’m
interested to hear it.

We tried to move all DB outside of Foreman using Postgres clusters but we
had a really hard time special if used with Katello.

We didn’t try to export the database witch might bring to better results
instead we kind of initialized again but this process lost from time to
time the creation of the keys and other stuff creating very weird issue
not very easy to troubleshot.

The main reason we didn’t proceed further was that every update could break
it overwriting the manual configuration of the exteral dbs.

On Tuesday, March 28, 2017 at 8:13:20 PM UTC+2, apgrif...@gmail.com wrote:

Hi,

Ideally I would like the option to configure Katello with a remote
database. This is supported in Foreman, but from what I can see candlepin
installation scripts are hard coded to assume a local db. Is there any
technical reason for this? I would have assumed it’s just a JDBC connection
and is agnostic about the location?

Thanks,

Alan


You received this message because you are subscribed to the Google Groups “Foreman users” group.
To unsubscribe from this group and stop receiving emails from it, send an email to foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

Hi Alan,

Can you help with steps to use external db instance.

Thanks

··· On Tuesday, 28 March 2017 21:19:41 UTC+1, Alan Griffiths wrote: > > How did you set it up initially? Let foreman-installer create a local DB > then transfer it to a remote host and update candlepin.conf ? > > On 28 March 2017 at 19:55, Neil Hanlon <nha...@kayak.com > > wrote: > >> The install scripts don't do a great job of managing. I've actually had >> to break candlepin upgrades for it to work on my end. There is a bug >> report/enhancement request for this. I'll see if I can dig up the link. >> >> Ultimately, you can point the candlepin.conf to an external server, but >> you will have issues during upgrades. >> >> On Mar 28, 2017 14:13, <apgrif...@gmail.com > wrote: >> >>> Hi, >>> >>> Ideally I would like the option to configure Katello with a remote >>> database. This is supported in Foreman, but from what I can see candlepin >>> installation scripts are hard coded to assume a local db. Is there any >>> technical reason for this? I would have assumed it's just a JDBC connection >>> and is agnostic about the location? >>> >>> Thanks, >>> >>> Alan >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Foreman users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to foreman-user...@googlegroups.com . >>> To post to this group, send email to forema...@googlegroups.com >>> . >>> Visit this group at https://groups.google.com/group/foreman-users. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Foreman users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/foreman-users/Krz_wMppo1g/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> foreman-user...@googlegroups.com . >> To post to this group, send email to forema...@googlegroups.com >> . >> Visit this group at https://groups.google.com/group/foreman-users. >> For more options, visit https://groups.google.com/d/optout. >> > >

I did something like this: -

  1. Install katello as normal, utilising local DB
  2. Export foreman and candlepin DBs using pgdump tools
  3. Import DBs into remote DB server (ensure pg_hba.conf is has appropriate
    entries)
  4. Change DB connection strings in the following locations
    /etc/foreman/database.yml and /etc/candlepin/candlepin.conf
  5. Restart Katello

As others have noted, this will break the upgrade process - so precede with
caution

··· On 10 May 2017 at 14:42, GKASERA wrote:

Hi Alan,

Can you help with steps to use external db instance.

Thanks

On Tuesday, 28 March 2017 21:19:41 UTC+1, Alan Griffiths wrote:

How did you set it up initially? Let foreman-installer create a local DB
then transfer it to a remote host and update candlepin.conf ?

On 28 March 2017 at 19:55, Neil Hanlon nha...@kayak.com wrote:

The install scripts don’t do a great job of managing. I’ve actually had
to break candlepin upgrades for it to work on my end. There is a bug
report/enhancement request for this. I’ll see if I can dig up the link.

Ultimately, you can point the candlepin.conf to an external server, but
you will have issues during upgrades.

On Mar 28, 2017 14:13, apgrif...@gmail.com wrote:

Hi,

Ideally I would like the option to configure Katello with a remote
database. This is supported in Foreman, but from what I can see candlepin
installation scripts are hard coded to assume a local db. Is there any
technical reason for this? I would have assumed it’s just a JDBC connection
and is agnostic about the location?

Thanks,

Alan


You received this message because you are subscribed to the Google
Groups “Foreman users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to foreman-user...@googlegroups.com.
To post to this group, send email to forema...@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “Foreman users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/foreman-users/Krz_wMppo1g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
foreman-user...@googlegroups.com.
To post to this group, send email to forema...@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “Foreman users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/foreman-users/Krz_wMppo1g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
foreman-users+unsubscribe@googlegroups.com.
To post to this group, send email to foreman-users@googlegroups.com.
Visit this group at https://groups.google.com/group/foreman-users.
For more options, visit https://groups.google.com/d/optout.

Hi Alan,

I am new to postgresql so can you please provide details on setting of
pg_hba.conf.

I am trying to use RDS as external db, I am have exported db and get the
connection working however getting error while creating new repositories
thereafter.

Appreciate all help.

Thanks

··· On Thursday, 11 May 2017 14:23:16 UTC+1, Alan Griffiths wrote: > > I did something like this: - > > 1. Install katello as normal, utilising local DB > 2. Export foreman and candlepin DBs using pgdump tools > 3. Import DBs into remote DB server (ensure pg_hba.conf is has appropriate > entries) > 4. Change DB connection strings in the following locations > /etc/foreman/database.yml and /etc/candlepin/candlepin.conf > 5. Restart Katello > > As others have noted, this will break the upgrade process - so precede > with caution > > On 10 May 2017 at 14:42, GKASERA <gka...@gmail.com > wrote: > >> Hi Alan, >> >> Can you help with steps to use external db instance. >> >> Thanks >> >> On Tuesday, 28 March 2017 21:19:41 UTC+1, Alan Griffiths wrote: >>> >>> How did you set it up initially? Let foreman-installer create a local DB >>> then transfer it to a remote host and update candlepin.conf ? >>> >>> On 28 March 2017 at 19:55, Neil Hanlon wrote: >>> >>>> The install scripts don't do a great job of managing. I've actually had >>>> to break candlepin upgrades for it to work on my end. There is a bug >>>> report/enhancement request for this. I'll see if I can dig up the link. >>>> >>>> Ultimately, you can point the candlepin.conf to an external server, but >>>> you will have issues during upgrades. >>>> >>>> On Mar 28, 2017 14:13, wrote: >>>> >>>>> Hi, >>>>> >>>>> Ideally I would like the option to configure Katello with a remote >>>>> database. This is supported in Foreman, but from what I can see candlepin >>>>> installation scripts are hard coded to assume a local db. Is there any >>>>> technical reason for this? I would have assumed it's just a JDBC connection >>>>> and is agnostic about the location? >>>>> >>>>> Thanks, >>>>> >>>>> Alan >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Foreman users" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to foreman-user...@googlegroups.com. >>>>> To post to this group, send email to forema...@googlegroups.com. >>>>> Visit this group at https://groups.google.com/group/foreman-users. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "Foreman users" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/foreman-users/Krz_wMppo1g/unsubscribe >>>> . >>>> To unsubscribe from this group and all its topics, send an email to >>>> foreman-user...@googlegroups.com. >>>> To post to this group, send email to forema...@googlegroups.com. >>>> Visit this group at https://groups.google.com/group/foreman-users. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Foreman users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/foreman-users/Krz_wMppo1g/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> foreman-user...@googlegroups.com . >> To post to this group, send email to forema...@googlegroups.com >> . >> Visit this group at https://groups.google.com/group/foreman-users. >> For more options, visit https://groups.google.com/d/optout. >> > >