Re: sepgsql installation troubles in Postgresql 9.1 alpha4

Поиск
Список
Период
Сортировка
От Vinicius Abrahao
Тема Re: sepgsql installation troubles in Postgresql 9.1 alpha4
Дата
Msg-id CAM9BftxmhfNz-i3DYim=jjaR-jO71A5C9CfkNURW1AGMm0mSrg@mail.gmail.com
обсуждение исходный текст
Ответ на sepgsql installation troubles in Postgresql 9.1 alpha4  (H S <aras_h1988@yahoo.com>)
Список pgsql-admin
On Mon, Mar 28, 2011 at 7:10 AM, H S <aras_h1988@yahoo.com> wrote:
Dear Sirs,

I have just read your manual about implementing module sepgsql on Postgresql. But I do not have any idea that where and how I sould insert the below commands, that you've mentioned in manual.

>In terminal?
> When I type initdb, normally it requires at least an option to be followed; but here it has been typed "initdb".
> And also about $PGDATA: Should I type my path instead $PGDATA?
> And by the way the for command until end of done. Should I insert/type it in my linux(fedora 14) terminal?

Regards,

Sara

===================================================================================================================================================
(MANUAL) The following instructions that assume your installation is under the /usr/local/pgsql directory. Adjust the paths shown below as appropriate for your installaton.

$ initdb
$ vi $PGDATA/postgresql.conf
$ for DBNAME in template0 template1 postgres; do
  postgres --single -F -O -c exit_on_error=true $DBNAME \
      < /usr/local/pgsql/share/contrib/sepgsql.sql > /dev/null
  done
------------------------------------------
---my commands in terminal:

[postgres@localhost bin]$ for DBNAME in test; do  ./postgres --single -D /usr/local/pgsql/data -F -O -c exit_on_error=true $DBNAME < /usr/local/pgsql/share/
contrib/sepgsql.sql > /dev/null; done
-------------------------------------------
----result:

FATAL:  SELinux: failed to initialize labeling handle: No such file or directory
STATEMENT:  SELECT sepgsql_restorecon(NULL);
-------------------------------------------

*My System has the selinux-policy version is selinux-policy-3.9.7-37.fc14
.
I would like to know whether the versions 3.9.13 in fedora15 and 3.9.7-37 for fedora 14 is equivalent or not.





Dear Sara, dear All,

I am expecting the same problem here...
Digging a little bit more into the code I saw what is the line that is failling, at label.c line 528.

sehnd = selabel_open(SELABEL_CTX_DB, &seopts, 1);

From the block,

if (PG_ARGISNULL(0))
        {
                seopts.type = SELABEL_OPT_UNUSED;
                seopts.value = NULL;
        }
        else
        {
                seopts.type = SELABEL_OPT_PATH;
                seopts.value = TextDatumGetCString(PG_GETARG_DATUM(0));
        }
        sehnd = selabel_open(SELABEL_CTX_DB, &seopts, 1);
        if (!sehnd)
                ereport(ERROR,
                                (errcode(ERRCODE_INTERNAL_ERROR),
                           errmsg("SELinux: failed to initialize labeling handle: %m")));



Do you guys, have success when installing sepgsql? how we can solve this problem?

I am at CentOS 6, with this packages installed:
libselinux-utils-2.0.94-2.el6.x86_64
selinux-policy-targeted-3.7.19-54.el6_0.5.noarch
libselinux-devel-2.0.94-2.el6.x86_64
libselinux-2.0.94-2.el6.x86_64
libselinux-python-2.0.94-2.el6.x86_64
selinux-policy-3.7.19-54.el6_0.5.noarch


Thanks in advance for any help.

Cheers,
Vinícius

--
Vinícius Abrahão Bazana Schmidt
Desenvolvimento
Dextra Sistemas
www.dextra.com.br

В списке pgsql-admin по дате отправления:

Предыдущее
От: Loles
Дата:
Сообщение: pgpool II cancel the current transaction if one node falls
Следующее
От: Daniel Vázquez
Дата:
Сообщение: Unaccent contrib module for PostgreSQL 8