[Spacewalk-list] Error initializing Spacewalk: Could not populate database.

[Wojtak, Greg]

I think you need postgresql 8.4.

yum install postgresql84

should do the trick.

You might want to remove postgresql first though.

On 2011-01-28 10:50 AM, "Fabio Venturi" <dalamenona at gmail.com> wrote:

>Hello to anyone,
>I'm trying to setup Spacewalk on a virtual machine with CentOS release
>5.5 (Final) with PostgeSQL backend,
>the following packages are installed on the system:
>
>spacewalk-repo-1.2-0.el5
>spacewalk-backend-libs-1.2.75-1.el5
>spacewalk-branding-1.2.2-1.el5
>spacewalk-html-1.2.31-1.el5
>spacewalk-setup-jabberd-1.3.1-1.el5
>spacewalk-backend-xml-export-libs-1.2.75-1.el5
>spacewalk-backend-config-files-tool-1.2.75-1.el5
>spacewalk-backend-package-push-server-1.2.75-1.el5
>spacewalk-base-minimal-1.2.31-1.el5
>spacewalk-grail-1.2.31-1.el5
>spacewalk-setup-1.2.16-1.el5
>spacewalk-schema-1.2.69-1.el5
>spacewalk-java-lib-1.2.115-1.el5
>spacewalk-certs-tools-1.2.2-1.el5
>spacewalk-backend-1.2.75-1.el5
>spacewalk-backend-sql-1.2.75-1.el5
>spacewalk-backend-config-files-common-1.2.75-1.el5
>spacewalk-backend-xmlrpc-1.2.75-1.el5
>spacewalk-backend-iss-export-1.2.75-1.el5
>spacewalk-backend-config-files-1.2.75-1.el5
>spacewalk-backend-iss-1.2.75-1.el5
>spacewalk-doc-indexes-1.1.1-1.el5
>spacewalk-pxt-1.2.31-1.el5
>spacewalk-admin-1.2.7-1.el5
>spacewalk-backend-tools-1.2.75-1.el5
>spacewalk-monitoring-1.2.1-1.el5
>spacewalk-sniglets-1.2.31-1.el5
>spacewalk-selinux-1.2.5-1.el5
>spacewalk-java-1.2.115-1.el5
>spacewalk-taskomatic-1.2.115-1.el5
>spacewalk-common-1.2.3-1.el5
>spacewalk-client-repo-1.2-0.el5
>spacewalk-java-config-1.2.115-1.el5
>spacewalk-config-1.2.7-1.el5
>spacewalk-backend-server-1.2.75-1.el5
>spacewalk-backend-app-1.2.75-1.el5
>spacewalk-backend-applet-1.2.75-1.el5
>spacewalk-backend-xp-1.2.75-1.el5
>spacewalk-slf4j-1.6.1-1.el5
>spacewalk-base-1.2.31-1.el5
>spacewalk-monitoring-selinux-1.2.3-1.el5
>spacewalk-search-1.2.4-1.el5
>
>and
>spacewalk-java-postgresql-1.2.115-1.el5
>spacewalk-postgresql-1.2.3-1.el5
>spacewalk-backend-sql-postgresql-1.2.75-1.el5
>postgresql-libs-8.1.22-1.el5_5.1
>postgresql-8.1.22-1.el5_5.1
>postgresql-server-8.1.22-1.el5_5.1
>postgresql-pl-8.1.22-1.el5_5.1
>postgresql-jdbc-8.1.407-1jpp.4
>
>PostgreSQL is up and running with database/role working correctly,
>when running the command spacewalk-setup the output is:
>
>[root at spacewalk.net1.lan ~]# spacewalk-setup --disconnected
>** Database: Setting up database connection for PostgreSQL backend.
>Hostname (leave empty for local)?
>Database? spacewalk
>Username? spacewalk
>Password?
>** Database: Populating database.
>*** Progress: ##
>Could not populate database.
>
>
>
>And in the last line of the log file there is the following error:
>
>[...]
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>"rhn_urlps_recid_pk" for table "rhn_url_probe_step"
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>"valid_countries_pk" for table "valid_countries"
>NOTICE:  CREATE TABLE / UNIQUE will create implicit index
>"valid_countries_tl_unq" for table "valid_countries_tl"
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>"web_cust_not_id_pk" for table "web_customer_notification"
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>"wup_text_pk" for table "web_user_prefix"
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>"wust_type_pk" for table "web_user_site_type"
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>"wusi_id_pk" for table "web_user_site_info"
>ERROR:  syntax error at or near "DEFAULT" at character 91
>
>
>I've tried to search this error, but with no luck,
>is this a known problem?
>Thank you in advance for any hint,
>Yours sincerely,
>
>-
>Fabio Venturi
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list