Re: [Spacewalk-list] spacewalk-setup --external-postgresql on external RDS instance FAILS

2018-09-26 Thread Robert Paschedag
Am 26. September 2018 03:50:30 MESZ schrieb Jason Hunt :
>When I run spacewalk-setup --external-postgresql I am receiving the
>below
>error and with the details being thin, not sure what the potential
>issue is;
>
># spacewalk-setup --external-postgresql
>* Setting up SELinux..
>** Database: Setting up database connection for PostgreSQL backend.
>Hostname (leave empty for local)? my.remote.database
>Port [5432]?
>Database [spacewalk]?
>Username [myuser]?
>Password [**]?
>** Database: Populating database.
>*** Progress: #
>Could not populate database.
>
>/var/log/rhn/populate_db.log  and rhn_installation.log contain the
>following;
>
># cat populate_db.log
>*psql:/etc/sysconfig/rhn/postgres/deploy.sql:4: ERROR:  extension
>"dblink"
>already exists*

Although this should not bail out (or checked by the script)... What, if you 
comment the line with the activation of dblink and try again?

Robert

>
># cat rhn_installation.log
>Installation log of Spacewalk
>Command: /bin/spacewalk-setup
>Running /usr/sbin/spacewalk-selinux-enable
>Running /usr/sbin/osa-dispatcher-selinux-enable
>
>I can utilize psql to connect and verify database;
>psql -h my.remote.database -U myuser -W -d spacewalk
>
>Password for user satellite_app:
>psql (9.2.24, server 9.6.8)
>WARNING: psql version 9.2, server version 9.6.
> Some psql features might not work.
>SSL connection (cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256)
>Type "help" for help.
>
>spacewalk=> \l
>  List of databases
>   Name|  Owner   | Encoding |   Collate   |Ctype|   Access
>privileges
>spacewalk | master   | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
>
>
>Anyone have any ideas?  Thanks in advance for the help.


-- 
sent from my mobile device

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list


[Spacewalk-list] spacewalk-setup --external-postgresql on external RDS instance FAILS

2018-09-25 Thread Jason Hunt
When I run spacewalk-setup --external-postgresql I am receiving the below
error and with the details being thin, not sure what the potential issue is;

# spacewalk-setup --external-postgresql
* Setting up SELinux..
** Database: Setting up database connection for PostgreSQL backend.
Hostname (leave empty for local)? my.remote.database
Port [5432]?
Database [spacewalk]?
Username [myuser]?
Password [**]?
** Database: Populating database.
*** Progress: #
Could not populate database.

/var/log/rhn/populate_db.log  and rhn_installation.log contain the
following;

# cat populate_db.log
*psql:/etc/sysconfig/rhn/postgres/deploy.sql:4: ERROR:  extension "dblink"
already exists*

# cat rhn_installation.log
Installation log of Spacewalk
Command: /bin/spacewalk-setup
Running /usr/sbin/spacewalk-selinux-enable
Running /usr/sbin/osa-dispatcher-selinux-enable

I can utilize psql to connect and verify database;
psql -h my.remote.database -U myuser -W -d spacewalk

Password for user satellite_app:
psql (9.2.24, server 9.6.8)
WARNING: psql version 9.2, server version 9.6.
 Some psql features might not work.
SSL connection (cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256)
Type "help" for help.

spacewalk=> \l
  List of databases
   Name|  Owner   | Encoding |   Collate   |Ctype|   Access
privileges
spacewalk | master   | UTF8 | en_US.UTF-8 | en_US.UTF-8 |


Anyone have any ideas?  Thanks in advance for the help.
___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list