Basic installation - database configuration

carl.wilson · July 3, 2013, 5:31pm

I'm having problems with the basic installation.

I'm running on CentOS 6u3 x86_64

I've configured a postgresql database

/etc/init.d/postgresql-9.1 initdb

# Start the database
/etc/init.d/postgresql-9.1 start

su - postgres -c $'/usr/bin/psql -c "CREATE USER cmdb WITH PASSWORD \'cmdb\';"'
su - postgres -c $'/usr/bin/psql -c "CREATE DATABASE cmdb WITH OWNER cmdb ENCODING \'UTF8\';"'

and configured postgresql for remote access

Java SDK 1.6u33 is installed and available on the PATH and as JAVA_HOME

I've configured tomcat 7 to use jsvc as user tomcat (it's also running jenkins)

I've added postgresql-9.2-1002.jdbc4.jar to <tomcat>/lib. Already includes tomcat-dbcp.jar

Copied cmdbuild-2.1.3.1.war to <tomcat>/webapps/cmdbuild.jar (owner is tomcat)

Similarly cmdbuild-distribution-shark-overlay-2.1.3.1.zip expanded in <tomcat>/webapps (owner tomcat)

Start tomcat

cmdb screen comes up on browser (Firefox 17)

Check access to database - works as localhost or as machine name (IP address) with user cmdb:cmdb

Choose empty database and go to final screen. Setup admin with username and password

On finish it reports 'Error encountered while loading/saving data'

Error occourred while loading/saving data

Show details

Call: services/json/configure/apply
------------------------------------
Error: org.cmdbuild.exception.ORMException: ORM_GENERIC_ERROR

Choose 'demo' database - same error

Choose 'existing' database. Seems to work, creating database.conf. Then shown set of patches with option to apply. Fails because can't write to database.

So, the basic theme is that the application can't access the database to configure it. What do I need to do to configure the database access?

I've also gone through the 'manual' setup with no more success.

carl.wilson · July 4, 2013, 8:54am

Just to add a bit more info, I eventually installed the demo database manually from demo_schema.sql.

That works, so I guess it's actually a problem with the other code about setting up the database.

tecnoteca · July 4, 2013, 9:00am

Hi,

since the application is working on our systems we need to understand exactly how your server is configured.

Could you please sum up the characteristics of your server?

- operating system version

- java version - it's a system package (installed by rpm/apt) or it's manually installed?

- tomcat version - it's a system package or it's manually installed?

- postgresql version (not psql version!) - it's a system package or it's manually installed?

Moreover, the postgres log could be useful to understand what's going on. Have you trying looking at it?

carl.wilson · July 4, 2013, 10:37am

Previously Tecnoteca wrote:

Hi,

since the application is working on our systems we need to understand exactly how your server is configured.

Could you please sum up the characteristics of your server?

- operating system version

- java version - it's a system package (installed by rpm/apt) or it's manually installed?

- tomcat version - it's a system package or it's manually installed?
- postgresql version (not psql version!) - it's a system package or it's manually installed?

Moreover, the postgres log could be useful to understand what's going on. Have you trying looking at it?

Operating system

: CentOS 6u3 x86_64

Java

- JDK SE Runtime 1.6u33

java version "1.6.0_33"

Java(TM) SE Runtime Environment (build 1.6.0_33-b04)

Java HotSpot(TM) 64-Bit Server VM (build 20.8-b03, mixed mode)

Installed manually from Oracle self-extracting bin - which gives rpms

tomcat

7,0.32 - manual install from tar.gz file with configuration to run war files under jsvc.

rpm -qa|grep -i postgresql

postgresql91-server-9.1.8-2PGDG.rhel6.x86_64

postgresql91-libs-9.1.8-2PGDG.rhel6.x86_64

postgresql91-9.1.8-2PGDG.rhel6.x86_64

Initial setup of postgresql database as described in original question

As noted in further post it works with a manual install of the database from demo_schema.sql. No changes to the database access except as noted in original post. I recreated a virgin database before running the demo_schema manually.

I'll delete the data from the demo setup and work with that, but it would have been useful to be able to use an empty setup. The demo schema appears to work ok so from that I'd take it that the database access is ok. The introductory setup would be better if it worked.

dave.allonby · August 23, 2018, 8:23am

Hi All,

I'm also having difficulties with the database part of a simple installation.

my test machine is a vmware machine with 4gb RAM 2 CPUs and 100GB disk

OS Centos 7.5.1804 (core)

my package list...

Installed Packages

GeoIP.x86_64 1.5.0-11.el7 @anaconda

NetworkManager.x86_64 1:1.10.2-16.el7_5 @updates

NetworkManager-libnm.x86_64 1:1.10.2-16.el7_5 @updates

NetworkManager-team.x86_64 1:1.10.2-16.el7_5 @updates

NetworkManager-tui.x86_64 1:1.10.2-16.el7_5 @updates

NetworkManager-wifi.x86_64 1:1.10.2-16.el7_5 @updates

acl.x86_64 2.2.51-14.el7 @anaconda

aic94xx-firmware.noarch 30-6.el7 @anaconda

alsa-firmware.noarch 1.0.28-2.el7 @anaconda

alsa-lib.i686 1.1.4.1-2.el7 @base

alsa-lib.x86_64 1.1.4.1-2.el7 @anaconda

alsa-tools-firmware.x86_64 1.1.0-1.el7 @anaconda

apache-commons-collections.noarch 3.2.1-22.el7_2 @base

apache-commons-daemon.x86_64 1.0.13-7.el7 @base

apache-commons-dbcp.noarch 1.4-17.el7 @base

apache-commons-logging.noarch 1.1.2-7.el7 @base

apache-commons-pool.noarch 1.6-9.el7 @base

audit.x86_64 2.8.1-3.el7_5.1 @updates

audit-libs.x86_64 2.8.1-3.el7_5.1 @updates

authconfig.x86_64 6.2.8-30.el7 @anaconda

avalon-framework.noarch 4.3-10.el7 @base

avalon-logkit.noarch 2.1-14.el7 @base

basesystem.noarch 10.0-7.el7.centos @anaconda

bash.x86_64 4.2.46-30.el7 @anaconda

bind-libs-lite.x86_64 32:9.9.4-61.el7 @anaconda

bind-license.noarch 32:9.9.4-61.el7 @anaconda

binutils.x86_64 2.27-28.base.el7_5.1 @updates

biosdevname.x86_64 0.7.3-1.el7 @anaconda

btrfs-progs.x86_64 4.9.1-1.el7 @anaconda

bzip2-libs.x86_64 1.0.6-13.el7 @anaconda

ca-certificates.noarch 2018.2.22-70.0.el7_5 @updates

centos-logos.noarch 70.0.6-3.el7.centos @anaconda

centos-release.x86_64 7-5.1804.4.el7.centos @updates

chkconfig.x86_64 1.7.4-1.el7 @anaconda

chrony.x86_64 3.2-2.el7 @anaconda

copy-jdk-configs.noarch 3.3-10.el7_5 @updates

coreutils.x86_64 8.22-21.el7 @anaconda

cpio.x86_64 2.11-27.el7 @anaconda

cracklib.x86_64 2.9.0-11.el7 @anaconda

cracklib-dicts.x86_64 2.9.0-11.el7 @anaconda

cronie.x86_64 1.4.11-19.el7 @anaconda

cronie-anacron.x86_64 1.4.11-19.el7 @anaconda

crontabs.noarch 1.11-6.20121102git.el7 @anaconda

cryptsetup-libs.x86_64 1.7.4-4.el7 @anaconda

curl.x86_64 7.29.0-46.el7 @anaconda

cyrus-sasl-lib.x86_64 2.1.26-23.el7 @anaconda

dbus.x86_64 1:1.10.24-7.el7 @anaconda

dbus-glib.x86_64 0.100-7.el7 @anaconda

dbus-libs.x86_64 1:1.10.24-7.el7 @anaconda

dbus-python.x86_64 1.1.1-9.el7 @anaconda

device-mapper.x86_64 7:1.02.146-4.el7 @anaconda

device-mapper-event.x86_64 7:1.02.146-4.el7 @anaconda

device-mapper-event-libs.x86_64 7:1.02.146-4.el7 @anaconda

device-mapper-libs.x86_64 7:1.02.146-4.el7 @anaconda

device-mapper-persistent-data.x86_64 0.7.3-3.el7 @anaconda

dhclient.x86_64 12:4.2.5-68.el7.centos.1 @updates

dhcp-common.x86_64 12:4.2.5-68.el7.centos.1 @updates

dhcp-libs.x86_64 12:4.2.5-68.el7.centos.1 @updates

diffutils.x86_64 3.3-4.el7 @anaconda

dmidecode.x86_64 1:3.0-5.el7 @anaconda

dracut.x86_64 033-535.el7_5.1 @updates

dracut-config-rescue.x86_64 033-535.el7_5.1 @updates

dracut-network.x86_64 033-535.el7_5.1 @updates

e2fsprogs.x86_64 1.42.9-12.el7_5 @updates

e2fsprogs-libs.x86_64 1.42.9-12.el7_5 @updates

ebtables.x86_64 2.0.10-16.el7 @anaconda

ecj.x86_64 1:4.5.2-3.el7 @base

elfutils-default-yama-scope.noarch 0.170-4.el7 @anaconda

elfutils-libelf.x86_64 0.170-4.el7 @anaconda

elfutils-libs.x86_64 0.170-4.el7 @anaconda

ethtool.x86_64 2:4.8-7.el7 @anaconda

expat.i686 2.1.0-10.el7_3 @base

expat.x86_64 2.1.0-10.el7_3 @anaconda

file.x86_64 5.11-33.el7 @anaconda

file-libs.x86_64 5.11-33.el7 @anaconda

filesystem.x86_64 3.2-25.el7 @anaconda

findutils.x86_64 1:4.5.11-5.el7 @anaconda

fipscheck.x86_64 1.4.1-6.el7 @anaconda

fipscheck-lib.x86_64 1.4.1-6.el7 @anaconda

firewalld.noarch 0.4.4.4-14.el7 @anaconda

firewalld-filesystem.noarch 0.4.4.4-14.el7 @anaconda

fontconfig.i686 2.10.95-11.el7 @base

fontpackages-filesystem.noarch 1.44-8.el7 @base

freetype.i686 2.4.11-15.el7 @base

freetype.x86_64 2.4.11-15.el7 @anaconda

fuse.x86_64 2.9.2-10.el7 @base

fuse-libs.x86_64 2.9.2-10.el7 @base

fxload.x86_64 2002_04_11-16.el7 @anaconda

gawk.x86_64 4.0.2-4.el7_3.1 @anaconda

gdbm.x86_64 1.10-8.el7 @anaconda

geronimo-jms.noarch 1.1.1-19.el7 @base

geronimo-jta.noarch 1.1.1-17.el7 @base

gettext.x86_64 0.19.8.1-2.el7 @anaconda

gettext-libs.x86_64 0.19.8.1-2.el7 @anaconda

giflib.i686 4.1.6-9.el7 @base

glib2.x86_64 2.54.2-2.el7 @anaconda

glibc.i686 2.17-222.el7 @base

glibc.x86_64 2.17-222.el7 @anaconda

glibc-common.x86_64 2.17-222.el7 @anaconda

gmp.x86_64 1:6.0.0-15.el7 @anaconda

gnupg2.x86_64 2.0.22-5.el7_5 @updates

gobject-introspection.x86_64 1.50.0-1.el7 @anaconda

gpgme.x86_64 1.3.2-5.el7 @anaconda

grep.x86_64 2.20-3.el7 @anaconda

groff-base.x86_64 1.22.2-8.el7 @anaconda

grub2.x86_64 1:2.02-0.65.el7.centos.2 @anaconda

grub2-common.noarch 1:2.02-0.65.el7.centos.2 @anaconda

grub2-pc.x86_64 1:2.02-0.65.el7.centos.2 @anaconda

grub2-pc-modules.noarch 1:2.02-0.65.el7.centos.2 @anaconda

grub2-tools.x86_64 1:2.02-0.65.el7.centos.2 @anaconda

grub2-tools-extra.x86_64 1:2.02-0.65.el7.centos.2 @anaconda

grub2-tools-minimal.x86_64 1:2.02-0.65.el7.centos.2 @anaconda

grubby.x86_64 8.28-23.el7 @anaconda

gzip.x86_64 1.5-10.el7 @anaconda

hardlink.x86_64 1:1.0-19.el7 @anaconda

hostname.x86_64 3.13-3.el7 @anaconda

hwdata.x86_64 0.252-8.8.el7 @anaconda

info.x86_64 5.1-5.el7 @anaconda

initscripts.x86_64 9.49.41-1.el7_5.1 @updates

iproute.x86_64 4.11.0-14.el7 @anaconda

iprutils.x86_64 2.4.15.1-1.el7 @anaconda

ipset.x86_64 6.29-1.el7 @anaconda

ipset-libs.x86_64 6.29-1.el7 @anaconda

iptables.x86_64 1.4.21-24.1.el7_5 @updates

iputils.x86_64 20160308-10.el7 @anaconda

irqbalance.x86_64 3:1.0.7-11.el7 @anaconda

ivtv-firmware.noarch 2:20080701-26.el7 @anaconda

iwl100-firmware.noarch 39.31.5.1-62.2.el7_5 @updates

iwl1000-firmware.noarch 1:39.31.5.1-62.2.el7_5 @updates

iwl105-firmware.noarch 18.168.6.1-62.2.el7_5 @updates

iwl135-firmware.noarch 18.168.6.1-62.2.el7_5 @updates

iwl2000-firmware.noarch 18.168.6.1-62.2.el7_5 @updates

iwl2030-firmware.noarch 18.168.6.1-62.2.el7_5 @updates

iwl3160-firmware.noarch 22.0.7.0-62.2.el7_5 @updates

iwl3945-firmware.noarch 15.32.2.9-62.2.el7_5 @updates

iwl4965-firmware.noarch 228.61.2.24-62.2.el7_5 @updates

iwl5000-firmware.noarch 8.83.5.1_1-62.2.el7_5 @updates

iwl5150-firmware.noarch 8.24.2.2-62.2.el7_5 @updates

iwl6000-firmware.noarch 9.221.4.1-62.2.el7_5 @updates

iwl6000g2a-firmware.noarch 17.168.5.3-62.2.el7_5 @updates

iwl6000g2b-firmware.noarch 17.168.5.2-62.2.el7_5 @updates

iwl6050-firmware.noarch 41.28.5.1-62.2.el7_5 @updates

iwl7260-firmware.noarch 22.0.7.0-62.2.el7_5 @updates

iwl7265-firmware.noarch 22.0.7.0-62.2.el7_5 @updates

jakarta-taglibs-standard.noarch 1.1.2-14.el7_1 @base

jansson.x86_64 2.10-1.el7 @anaconda

java-1.8.0-openjdk.i686 1:1.8.0.181-3.b13.el7_5 @updates

java-1.8.0-openjdk-devel.i686 1:1.8.0.181-3.b13.el7_5 @updates

java-1.8.0-openjdk-headless.i686 1:1.8.0.181-3.b13.el7_5 @updates

javamail.noarch 1.4.6-8.el7 @base

javapackages-tools.noarch 3.4.1-11.el7 @base

kbd.x86_64 1.15.5-13.el7 @anaconda

kbd-legacy.noarch 1.15.5-13.el7 @anaconda

kbd-misc.noarch 1.15.5-13.el7 @anaconda

kernel.x86_64 3.10.0-862.el7 @anaconda

kernel.x86_64 3.10.0-862.11.6.el7 @updates

kernel-tools.x86_64 3.10.0-862.11.6.el7 @updates

kernel-tools-libs.x86_64 3.10.0-862.11.6.el7 @updates

kexec-tools.x86_64 2.0.15-13.el7 @anaconda

keyutils-libs.x86_64 1.5.8-3.el7 @anaconda

kmod.x86_64 20-21.el7 @anaconda

kmod-libs.x86_64 20-21.el7 @anaconda

kpartx.x86_64 0.4.9-119.el7_5.1 @updates

krb5-libs.x86_64 1.15.1-19.el7 @updates

less.x86_64 458-9.el7 @anaconda

libICE.i686 1.0.9-9.el7 @base

libSM.i686 1.2.2-2.el7 @base

libX11.i686 1.6.5-1.el7 @base

libX11-common.noarch 1.6.5-1.el7 @base

libXau.i686 1.0.8-2.1.el7 @base

libXcomposite.i686 0.4.4-4.1.el7 @base

libXext.i686 1.3.3-3.el7 @base

libXfont.x86_64 1.5.2-1.el7 @base

libXi.i686 1.7.9-1.el7 @base

libXrender.i686 0.9.10-1.el7 @base

libXtst.i686 1.2.3-1.el7 @base

libacl.x86_64 2.2.51-14.el7 @anaconda

libaio.x86_64 0.3.109-13.el7 @anaconda

libassuan.x86_64 2.1.0-3.el7 @anaconda

libattr.x86_64 2.4.46-13.el7 @anaconda

libblkid.x86_64 2.23.2-52.el7_5.1 @updates

libcap.x86_64 2.22-9.el7 @anaconda

libcap-ng.x86_64 0.7.5-4.el7 @anaconda

libcom_err.x86_64 1.42.9-12.el7_5 @updates

libcroco.x86_64 0.6.11-1.el7 @anaconda

libcurl.x86_64 7.29.0-46.el7 @anaconda

libdaemon.x86_64 0.14-7.el7 @anaconda

libdb.x86_64 5.3.21-24.el7 @anaconda

libdb-utils.x86_64 5.3.21-24.el7 @anaconda

libdnet.x86_64 1.12-13.1.el7 @base

libdrm.x86_64 2.4.83-2.el7 @anaconda

libedit.x86_64 3.0-12.20121213cvs.el7 @anaconda

libestr.x86_64 0.1.9-2.el7 @anaconda

libfastjson.x86_64 0.99.4-2.el7 @anaconda

libffi.x86_64 3.0.13-18.el7 @anaconda

libfontenc.x86_64 1.1.3-3.el7 @base

libgcc.i686 4.8.5-28.el7_5.1 @updates

libgcc.x86_64 4.8.5-28.el7_5.1 @updates

libgcrypt.x86_64 1.5.3-14.el7 @anaconda

libgomp.x86_64 4.8.5-28.el7_5.1 @updates

libgpg-error.x86_64 1.12-3.el7 @anaconda

libicu.x86_64 50.1.2-15.el7 @base

libidn.x86_64 1.28-4.el7 @anaconda

libjpeg-turbo.i686 1.2.90-5.el7 @base

libmnl.x86_64 1.0.3-7.el7 @anaconda

libmount.x86_64 2.23.2-52.el7_5.1 @updates

libmspack.x86_64 0.5-0.5.alpha.el7 @base

libndp.x86_64 1.2-7.el7 @anaconda

libnetfilter_conntrack.x86_64 1.0.6-1.el7_3 @anaconda

libnfnetlink.x86_64 1.0.1-4.el7 @anaconda

libnl3.x86_64 3.2.28-4.el7 @anaconda

libnl3-cli.x86_64 3.2.28-4.el7 @anaconda

libpciaccess.x86_64 0.14-1.el7 @anaconda

libpipeline.x86_64 1.2.3-3.el7 @anaconda

libpng.i686 2:1.5.13-7.el7_2 @base

libpwquality.x86_64 1.2.3-5.el7 @anaconda

libseccomp.x86_64 2.3.1-3.el7 @anaconda

libselinux.x86_64 2.5-12.el7 @anaconda

libselinux-python.x86_64 2.5-12.el7 @anaconda

libselinux-utils.x86_64 2.5-12.el7 @anaconda

libsemanage.x86_64 2.5-11.el7 @anaconda

libsepol.x86_64 2.5-8.1.el7 @anaconda

libss.x86_64 1.42.9-12.el7_5 @updates

libssh2.x86_64 1.4.3-10.el7_2.1 @anaconda

libstdc++.i686 4.8.5-28.el7_5.1 @updates

libstdc++.x86_64 4.8.5-28.el7_5.1 @updates

libsysfs.x86_64 2.1.0-16.el7 @anaconda

libtasn1.x86_64 4.10-1.el7 @anaconda

libteam.x86_64 1.27-4.el7 @anaconda

libtool-ltdl.x86_64 2.4.2-22.el7_3 @base

libunistring.x86_64 0.9.3-9.el7 @anaconda

libuser.x86_64 0.60-9.el7 @anaconda

libutempter.x86_64 1.1.6-4.el7 @anaconda

libuuid.i686 2.23.2-52.el7_5.1 @updates

libuuid.x86_64 2.23.2-52.el7_5.1 @updates

libverto.x86_64 0.2.5-4.el7 @anaconda

libxcb.i686 1.12-1.el7 @base

libxml2.x86_64 2.9.1-6.el7_2.3 @anaconda

libxslt.x86_64 1.1.28-5.el7 @base

linux-firmware.noarch 20180220-62.2.git6d51311.el7_5 @updates

lksctp-tools.i686 1.0.17-2.el7 @base

log4j.noarch 1.2.17-16.el7_4 @base

logrotate.x86_64 3.8.6-15.el7 @anaconda

lsscsi.x86_64 0.27-6.el7 @anaconda

lua.x86_64 5.1.4-15.el7 @anaconda

lvm2.x86_64 7:2.02.177-4.el7 @anaconda

lvm2-libs.x86_64 7:2.02.177-4.el7 @anaconda

lz4.x86_64 1.7.5-2.el7 @anaconda

lzo.x86_64 2.06-8.el7 @anaconda

make.x86_64 1:3.82-23.el7 @anaconda

man-db.x86_64 2.6.3-9.el7 @anaconda

mariadb-libs.x86_64 1:5.5.60-1.el7_5 @updates

microcode_ctl.x86_64 2:2.1-29.10.el7_5 @updates

mozjs17.x86_64 17.0.0-20.el7 @anaconda

nano.x86_64 2.3.1-10.el7 @base

ncurses.x86_64 5.9-14.20130511.el7_4 @anaconda

ncurses-base.noarch 5.9-14.20130511.el7_4 @anaconda

ncurses-libs.i686 5.9-14.20130511.el7_4 @base

ncurses-libs.x86_64 5.9-14.20130511.el7_4 @anaconda

newt.x86_64 0.52.15-4.el7 @anaconda

newt-python.x86_64 0.52.15-4.el7 @anaconda

nspr.i686 4.19.0-1.el7_5 @updates

nspr.x86_64 4.19.0-1.el7_5 @updates

nss.i686 3.36.0-5.el7_5 @updates

nss.x86_64 3.36.0-5.el7_5 @updates

nss-pem.i686 1.0.3-4.el7 @base

nss-pem.x86_64 1.0.3-4.el7 @anaconda

nss-softokn.i686 3.36.0-5.el7_5 @updates

nss-softokn.x86_64 3.36.0-5.el7_5 @updates

nss-softokn-freebl.i686 3.36.0-5.el7_5 @updates

nss-softokn-freebl.x86_64 3.36.0-5.el7_5 @updates

nss-sysinit.x86_64 3.36.0-5.el7_5 @updates

nss-tools.x86_64 3.36.0-5.el7_5 @updates

nss-util.i686 3.36.0-1.el7_5 @updates

nss-util.x86_64 3.36.0-1.el7_5 @updates

numactl-libs.x86_64 2.0.9-7.el7 @anaconda

open-vm-tools.x86_64 10.1.10-3.el7_5.1 @updates

openldap.x86_64 2.4.44-15.el7_5 @updates

openssh.x86_64 7.4p1-16.el7 @anaconda

openssh-clients.x86_64 7.4p1-16.el7 @anaconda

openssh-server.x86_64 7.4p1-16.el7 @anaconda

openssl.x86_64 1:1.0.2k-12.el7 @anaconda

openssl-libs.x86_64 1:1.0.2k-12.el7 @anaconda

os-prober.x86_64 1.58-9.el7 @anaconda

p11-kit.x86_64 0.23.5-3.el7 @anaconda

p11-kit-trust.x86_64 0.23.5-3.el7 @anaconda

pam.x86_64 1.1.8-22.el7 @anaconda

parted.x86_64 3.1-29.el7 @anaconda

passwd.x86_64 0.79-4.el7 @anaconda

pciutils.x86_64 3.5.1-3.el7 @base

pciutils-libs.x86_64 3.5.1-3.el7 @anaconda

pcre.x86_64 8.32-17.el7 @anaconda

pinentry.x86_64 0.8.1-17.el7 @anaconda

pkgconfig.x86_64 1:0.27.1-4.el7 @anaconda

plymouth.x86_64 0.8.9-0.31.20140113.el7.centos @anaconda

plymouth-core-libs.x86_64 0.8.9-0.31.20140113.el7.centos @anaconda

plymouth-scripts.x86_64 0.8.9-0.31.20140113.el7.centos @anaconda

policycoreutils.x86_64 2.5-22.el7 @anaconda

polkit.x86_64 0.112-14.el7 @anaconda

polkit-pkla-compat.x86_64 0.1-4.el7 @anaconda

popt.x86_64 1.13-16.el7 @anaconda

postfix.x86_64 2:2.10.1-6.el7 @anaconda

postgresql.x86_64 9.2.23-3.el7_4 @base

postgresql-contrib.x86_64 9.2.23-3.el7_4 @base

postgresql-libs.x86_64 9.2.23-3.el7_4 @base

postgresql-server.x86_64 9.2.23-3.el7_4 @base

procps-ng.x86_64 3.3.10-17.el7_5.2 @updates

pth.x86_64 2.0.7-23.el7 @anaconda

pygpgme.x86_64 0.3-9.el7 @anaconda

pyliblzma.x86_64 0.5.3-11.el7 @anaconda

python.x86_64 2.7.5-69.el7_5 @updates

python-configobj.noarch 4.7.2-7.el7 @anaconda

python-decorator.noarch 3.4.0-3.el7 @anaconda

python-firewall.noarch 0.4.4.4-14.el7 @anaconda

python-gobject-base.x86_64 3.22.0-1.el7_4.1 @anaconda

python-iniparse.noarch 0.4-9.el7 @anaconda

python-javapackages.noarch 3.4.1-11.el7 @base

python-libs.x86_64 2.7.5-69.el7_5 @updates

python-linux-procfs.noarch 0.4.9-3.el7 @anaconda

python-lxml.x86_64 3.2.1-4.el7 @base

python-perf.x86_64 3.10.0-862.11.6.el7 @updates

python-pycurl.x86_64 7.19.0-19.el7 @anaconda

python-pyudev.noarch 0.15-9.el7 @anaconda

python-schedutils.x86_64 0.4-6.el7 @anaconda

python-slip.noarch 0.4.0-4.el7 @anaconda

python-slip-dbus.noarch 0.4.0-4.el7 @anaconda

python-urlgrabber.noarch 3.10-8.el7 @anaconda

pyxattr.x86_64 0.5.1-5.el7 @anaconda

qrencode-libs.x86_64 3.4.1-3.el7 @anaconda

readline.i686 6.2-10.el7 @base

readline.x86_64 6.2-10.el7 @anaconda

rootfiles.noarch 8.1-11.el7 @anaconda

rpm.x86_64 4.11.3-32.el7 @anaconda

rpm-build-libs.x86_64 4.11.3-32.el7 @anaconda

rpm-libs.x86_64 4.11.3-32.el7 @anaconda

rpm-python.x86_64 4.11.3-32.el7 @anaconda

rsyslog.x86_64 8.24.0-16.el7_5.4 @updates

sed.x86_64 4.2.2-5.el7 @anaconda

selinux-policy.noarch 3.13.1-192.el7_5.6 @updates

selinux-policy-targeted.noarch 3.13.1-192.el7_5.6 @updates

setup.noarch 2.8.71-9.el7 @anaconda

shadow-utils.x86_64 2:4.1.5.1-24.el7 @anaconda

shared-mime-info.x86_64 1.8-4.el7 @anaconda

slang.x86_64 2.2.4-11.el7 @anaconda

snappy.x86_64 1.1.0-3.el7 @anaconda

sqlite.i686 3.7.17-8.el7 @base

sqlite.x86_64 3.7.17-8.el7 @anaconda

stix-fonts.noarch 1.1.0-5.el7 @base

sudo.x86_64 1.8.19p2-14.el7_5 @updates

systemd.x86_64 219-57.el7_5.1 @updates

systemd-libs.x86_64 219-57.el7_5.1 @updates

systemd-sysv.x86_64 219-57.el7_5.1 @updates

sysvinit-tools.x86_64 2.88-14.dsf.el7 @anaconda

tar.x86_64 2:1.26-34.el7 @anaconda

tcp_wrappers-libs.x86_64 7.6-77.el7 @anaconda

teamd.x86_64 1.27-4.el7 @anaconda

tomcat.noarch 7.0.76-6.el7 @base

tomcat-admin-webapps.noarch 7.0.76-6.el7 @base

tomcat-el-2.2-api.noarch 7.0.76-6.el7 @base

tomcat-jsp-2.2-api.noarch 7.0.76-6.el7 @base

tomcat-lib.noarch 7.0.76-6.el7 @base

tomcat-servlet-3.0-api.noarch 7.0.76-6.el7 @base

tomcat-webapps.noarch 7.0.76-6.el7 @base

ttmkfdir.x86_64 3.0.9-42.el7 @base

tuned.noarch 2.9.0-1.el7_5.2 @updates

tzdata.noarch 2018e-3.el7 @updates

tzdata-java.noarch 2018e-3.el7 @updates

ustr.x86_64 1.0.4-16.el7 @anaconda

util-linux.x86_64 2.23.2-52.el7_5.1 @updates

uuid.x86_64 1.6.2-26.el7 @base

vim-minimal.x86_64 2:7.4.160-4.el7 @anaconda

virt-what.x86_64 1.18-4.el7 @anaconda

which.x86_64 2.20-7.el7 @anaconda

wpa_supplicant.x86_64 1:2.6-9.el7 @anaconda

xalan-j2.noarch 2.7.1-23.el7 @base

xerces-j2.noarch 2.11.0-17.el7_0 @base

xfsprogs.x86_64 4.5.0-15.el7 @anaconda

xml-commons-apis.noarch 1.4.01-16.el7 @base

xml-commons-resolver.noarch 1.2-15.el7 @base

xmlsec1.x86_64 1.2.20-7.el7_4 @base

xmlsec1-openssl.x86_64 1.2.20-7.el7_4 @base

xorg-x11-font-utils.x86_64 1:7.5-20.el7 @base

xorg-x11-fonts-Type1.noarch 7.5-9.el7 @base

xz.x86_64 5.2.2-1.el7 @anaconda

xz-libs.x86_64 5.2.2-1.el7 @anaconda

yum.noarch 3.4.3-158.el7.centos @anaconda

yum-metadata-parser.x86_64 1.1.4-10.el7 @anaconda

yum-plugin-fastestmirror.noarch 1.1.31-46.el7_5 @updates

zlib.i686 1.2.7-17.el7 @base

zlib.x86_64 1.2.7-17.el7 @anaconda

Problems

SQL objects not created in db
Errors applying patches

Tests done

Errors found in SQL scripts 'create schema if not exist quartz' Replaced by 'create schema quartz'
Errors with options in demo script
fixed demo script , installed demo db to fresh , changed database.conf but still patches fail to run.

Errors from patches

nested exception is org.postgresql.util.PSQLException: ERROR: relation "Email" already exists
Where: SQL statement "CREATE TABLE "Email"( CONSTRAINT "Email_pkey" PRIMARY KEY ("Id")) INHERITS ("Class")"
PL/pgSQL function cm_create_class(text,oid,text) line 28 at EXECUTE statement
PL/pgSQL function system_class_create(character varying,character varying,boolean,character varying) line 8 at RETURN