*** /home/muraviov/git/postgresql/contrib/sepgsql/expected/label.out 2014-05-12 20:52:35.116035803 +0400 --- /home/muraviov/git/postgresql/contrib/sepgsql/results/label.out 2014-05-14 08:06:35.991033891 +0400 *************** *** 193,203 **** (1 row) SELECT sepgsql_setcon(NULL); -- failed to reset ! ERROR: SELinux: security policy violation SELECT sepgsql_getcon(); sepgsql_getcon -------------------------------------------------- ! unconfined_u:unconfined_r:unconfined_t:s0:c0.c15 (1 row) BEGIN; --- 193,207 ---- (1 row) SELECT sepgsql_setcon(NULL); -- failed to reset ! sepgsql_setcon ! ---------------- ! t ! (1 row) ! SELECT sepgsql_getcon(); sepgsql_getcon -------------------------------------------------- ! unconfined_u:unconfined_r:unconfined_t:s0:c0.c25 (1 row) BEGIN; *************** *** 270,276 **** SELECT sepgsql_getcon(); -- should be 's0:c0.c15' sepgsql_getcon -------------------------------------------------- ! unconfined_u:unconfined_r:unconfined_t:s0:c0.c15 (1 row) BEGIN; --- 274,280 ---- SELECT sepgsql_getcon(); -- should be 's0:c0.c15' sepgsql_getcon -------------------------------------------------- ! unconfined_u:unconfined_r:unconfined_t:s0:c0.c25 (1 row) BEGIN; *************** *** 350,370 **** (1 row) SELECT f5('unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c31'); -- Failed ! ERROR: SELinux: security policy violation ! CONTEXT: SQL function "f5" statement 1 SELECT sepgsql_getcon(); ! sepgsql_getcon ! ----------------------------------------------------------- ! unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c7 (1 row) SELECT f5(NULL); -- Failed ! ERROR: SELinux: security policy violation ! CONTEXT: SQL function "f5" statement 1 SELECT sepgsql_getcon(); ! sepgsql_getcon ! ----------------------------------------------------------- ! unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c7 (1 row) BEGIN; --- 354,380 ---- (1 row) SELECT f5('unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c31'); -- Failed ! f5 ! ---- ! t ! (1 row) ! SELECT sepgsql_getcon(); ! sepgsql_getcon ! ------------------------------------------------------------ ! unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c31 (1 row) SELECT f5(NULL); -- Failed ! f5 ! ---- ! t ! (1 row) ! SELECT sepgsql_getcon(); ! sepgsql_getcon ! ------------------------------------------------------------ ! unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c15 (1 row) BEGIN; *************** *** 382,390 **** ABORT; SELECT sepgsql_getcon(); ! sepgsql_getcon ! ----------------------------------------------------------- ! unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c7 (1 row) -- --- 392,400 ---- ABORT; SELECT sepgsql_getcon(); ! sepgsql_getcon ! ------------------------------------------------------------ ! unconfined_u:unconfined_r:sepgsql_regtest_user_t:s0:c0.c15 (1 row) -- ====================================================================== *** /home/muraviov/git/postgresql/contrib/sepgsql/expected/ddl.out 2014-05-12 20:52:35.116035803 +0400 --- /home/muraviov/git/postgresql/contrib/sepgsql/results/ddl.out 2014-05-14 08:06:42.859801632 +0400 *************** *** 46,56 **** LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=system_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="pg_catalog" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" - LINE 1: CREATE TABLE regtest_table (x serial primary key, y text); - ^ - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" LOG: SELinux: allowed { add_name } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" LOG: SELinux: allowed { setattr } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_table name="regtest_schema.regtest_table" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" --- 46,51 ---- *************** *** 156,166 **** LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="regtest_schema.regtest_table_4.y" LOG: SELinux: allowed { create } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="regtest_schema.regtest_table_4.z" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" - LINE 1: CREATE TABLE regtest_table_4 (x int primary key, y int, z in... - ^ - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" LOG: SELinux: allowed { add_name } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema" LOG: SELinux: allowed { setattr } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_table name="regtest_schema.regtest_table_4" CREATE INDEX regtest_index_tbl4_y ON regtest_table_4(y); --- 151,156 ---- ====================================================================== *** /home/muraviov/git/postgresql/contrib/sepgsql/expected/alter.out 2014-05-12 20:52:35.115035838 +0400 --- /home/muraviov/git/postgresql/contrib/sepgsql/results/alter.out 2014-05-14 08:06:46.991661904 +0400 *************** *** 143,155 **** LOG: SELinux: allowed { setattr } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="regtest_schema_2.regtest_table.b" LOG: SELinux: allowed { setattr } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="regtest_schema.regtest_table_2.b" ALTER TABLE regtest_table ADD CONSTRAINT test_fk FOREIGN KEY (a) REFERENCES regtest_table_3(x); -- not supported - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema_2" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=system_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="pg_catalog" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema_2" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=system_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="pg_catalog" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema_2" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=system_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="pg_catalog" - LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="regtest_schema_2" LOG: SELinux: allowed { search } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=system_u:object_r:sepgsql_schema_t:s0 tclass=db_schema name="pg_catalog" LOG: SELinux: allowed { select } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_table name="regtest_schema_2.regtest_table" LOG: SELinux: allowed { select } scontext=unconfined_u:unconfined_r:unconfined_t:s0 tcontext=unconfined_u:object_r:sepgsql_table_t:s0 tclass=db_column name="table regtest_table column a" --- 143,151 ---- ======================================================================