[Spacewalk-devel] Postgres dev environment
Hi all Just setting this up ATM. When I run 'spacewalk-setup --disconnected' I got heaps of errors in /var/log/rhn/populate_db.log, reportedly from /etc/sysconfig/rhn/postgres/main.sql. To get spacewalk-setup to complete, I made the following changes: --- 902 CREATE TABLE rhnConfigInfo 903 ( 904 --id NUMBER NOT NULL 905 id NUMERIC NOT NULL 906 CONSTRAINT rhn_confinfo_id_pk PRIMARY KEY, 907 -- USING INDEX TABLESPACE [[2m_tbs]], 908 --username VARCHAR2(32) NULL, 909 --groupnameVARCHAR2(32) NULL, 910 username VARCHAR(32) NOT NULL, 911 groupnameVARCHAR(32) NOT NULL, 912 --filemode NUMBER NULL, 913 filemode NUMERIC NOT NULL, 914 --symlink_target_filename_id NUMBER 915 symlink_target_filename_id NUMERIC 916 CONSTRAINT rhn_confinfo_symlink_fk 917 REFERENCES rhnConfigFileName (id), 918 created DATE 919 -- DEFAULT (sysdate) NOT NULL, 920 DEFAULT (current_timestamp) NOT NULL, 921 modified DATE 922 -- DEFAULT (sysdate) NOT NULL, 923 DEFAULT (current_timestamp) NOT NULL, 924 --selinux_ctx VARCHAR2(64) 925 selinux_ctx VARCHAR(64) 926 ) 927 -- ENABLE ROW MOVEMENT 928 ; 929 930 CREATE UNIQUE INDEX rhn_confinfo_ugf_uq 931 ON rhnConfigInfo (username, groupname, filemode, selinux_ctx, symlink_target_filename_id) 932 --TABLESPACE [[4m_tbs]]; 933 ; 934 935 CREATE SEQUENCE rhn_confinfo_id_seq; --- Could someone comment on the correctness of these? Thanks CC -- RHCE#805007969328369 ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
Re: [Spacewalk-devel] Postgres dev environment
On Tue, Aug 03, 2010 at 07:55:05PM +0800, Colin Coe wrote: Hi all Just setting this up ATM. When I run 'spacewalk-setup --disconnected' I got heaps of errors in /var/log/rhn/populate_db.log, reportedly from /etc/sysconfig/rhn/postgres/main.sql. To get spacewalk-setup to complete, I made the following changes: --- 902 CREATE TABLE rhnConfigInfo 903 ( 904 --id NUMBER NOT NULL 905 id NUMERIC NOT NULL 906 CONSTRAINT rhn_confinfo_id_pk PRIMARY KEY, 907 -- USING INDEX TABLESPACE [[2m_tbs]], 908 --username VARCHAR2(32) NULL, 909 --groupnameVARCHAR2(32) NULL, 910 username VARCHAR(32) NOT NULL, 911 groupnameVARCHAR(32) NOT NULL, 912 --filemode NUMBER NULL, 913 filemode NUMERIC NOT NULL, 914 --symlink_target_filename_id NUMBER 915 symlink_target_filename_id NUMERIC 916 CONSTRAINT rhn_confinfo_symlink_fk 917 REFERENCES rhnConfigFileName (id), 918 created DATE 919 -- DEFAULT (sysdate) NOT NULL, 920 DEFAULT (current_timestamp) NOT NULL, 921 modified DATE 922 -- DEFAULT (sysdate) NOT NULL, 923 DEFAULT (current_timestamp) NOT NULL, 924 --selinux_ctx VARCHAR2(64) 925 selinux_ctx VARCHAR(64) 926 ) 927 -- ENABLE ROW MOVEMENT 928 ; 929 930 CREATE UNIQUE INDEX rhn_confinfo_ugf_uq 931 ON rhnConfigInfo (username, groupname, filemode, selinux_ctx, symlink_target_filename_id) 932 --TABLESPACE [[4m_tbs]]; 933 ; 934 935 CREATE SEQUENCE rhn_confinfo_id_seq; --- Could someone comment on the correctness of these? The problem is caused by the NULL clauses that chameleon does not understand and thus the source file is just copied over. Can you please try the rpm from https://koji.spacewalkproject.org/koji/taskinfo?taskID=43419 and confirm that it fixes the issue for you? -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
Re: [Spacewalk-devel] Postgres dev environment
On Tue, Aug 03, 2010 at 09:19:53PM +0800, Colin Coe wrote: I've gone back to RHEL as I kept having problems under Fedora (the simple-core and friends) so I downloaded the src.rpm and rebuild against RHEL5. It built cleanly and I've upgraded the RPM. Looks like it worked OK as it came back OK and the services all started. Fine. I've pushed the change, tagged and scheduled spacewalk-schema-1.1.26-1 build. Thanks, -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel