Date: Wed, 19 Jun 2002 21:31:04 -0700 (PDT) From: "Nielsen" <nielsen@memberwebs.com> To: "Joseph Maxwell" <jemaxwell@jaymax.com>, <questions@FreeBSD.ORG> Subject: Re: Problems w/ Semaphore - I'm in 'jail' Message-ID: <20020620043104.9796F37B414@hub.freebsd.org> References: <3D10B0FD.F0B7F4A5@jaymax.com>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format.
------=_NextPart_000_009E_01C217B2.C3AA2340
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Yes this is a common problem with both PostgreSQL and MySQL. In my =
experience you have to turn on the kernel variable (in the host system):
jail.sysvipc_allowed: 1
Note that this is a potential security breach as it allows programs =
operating within a jail to influence or communicate with other programs =
(that use sysvipc) running either in the root system or in another jail. =
Bit of a bummer.
Nate
----- Original Message -----=20
From: Joseph Maxwell=20
To: questions@FreeBSD.ORG=20
Sent: Wednesday, June 19, 2002 10:25
Subject: Problems w/ Semaphore - I'm in 'jail'
Hello,=20
Hope there are users in this group w/ PostgreSQL familiarity and this =
BSD interaction=20
I am setting up postgreSQL and have ran into a problem related to =
either=20
kernel config or operating within 'the jail'.=20
Some interactions w/ the postgresql user groups =3D=3D>=20
Systems: PostgreSQL version 7.2.1, with all default settings on a=20
BSD platform ,4.5-RELEASE FreeBSD.=20
=20
hostname# initdb -D /usr/local/pgsql/data=20
The files belonging to this database system will be owned by user =
"postgres".=20
This user must also own the server process.=20
Fixing permissions on existing directory /usr/local/pgsql/data... =
ok=20
creating directory /usr/local/pgsql/data/base... ok=20
creating directory /usr/local/pgsql/data/global... ok=20
creating directory /usr/local/pgsql/data/pg_xlog... ok=20
creating directory /usr/local/pgsql/data/pg_clog... ok=20
creating template1 database in /usr/local/pgsql/data/base/1...=20
IpcSemaphoreCreate: semget(key=3D1, num=3D17, 03600) failed: =
Function not implemented=20
initdb failed.=20
=20
Any ideas on the semget() function, remembered reading on it =
somewhere before but=20
can't remember where=20
I hope this does not call for a kernel rebuild=20
I did an ipcs -s which =3D=3D=3D>=20
=20
hostname# ipcs -s=20
Semaphores:=20
T ID KEY MODE OWNER GROUP=20
hostname#=20
=20
Any insight on this type of problem?=20
Response =3D=3D=3D>=20
Hmm, usually this means either the kernel's not configured for SYSV =
ipc=20
or that you're running in a jail and the sysctl to let the jail use=20
sysv ipc is not turned on.=20
=20
Is this a plausible explanation, & if it is that the kernel's not =
configured for SYSV ipc=20
or that I am running in a jail how can the sysctl be turned on to =
allow the jail to use sysv ipc?=20
Thanks=20
I've spoken w/ my ISP, Tech. support personnel not quite familiar w/ =
problem but promised to investigate.=20
Any other experienced opinions welcomed ...=20
--- Joe ---=20
=20
=20
=20
------=_NextPart_000_009E_01C217B2.C3AA2340
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2713.1100" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D"Courier New" color=3D#000000 size=3D2>Yes this is a =
common problem=20
with both PostgreSQL and MySQL. In my experience you have to turn on the =
kernel=20
variable (in the host system):</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 =
size=3D2>jail.sysvipc_allowed:=20
1</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 size=3D2>Note that this =
is a potential=20
security breach as it allows programs operating within a jail to =
influence or=20
communicate with other programs (that use sysvipc) running either in the =
root=20
system or in another jail. Bit of a bummer.</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 =
size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 =
size=3D2>Nate</FONT></DIV>
<DIV><FONT face=3D"Courier New" color=3D#000000 =
size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Djemaxwell@jaymax.com =
href=3D"mailto:jemaxwell@jaymax.com">Joseph=20
Maxwell</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dquestions@FreeBSD.ORG=20
href=3D"mailto:questions@FreeBSD.ORG">questions@FreeBSD.ORG</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, June 19, 2002=20
10:25</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Problems w/ Semaphore =
- I'm in=20
'jail'</DIV>
<DIV><BR></DIV>Hello, <BR>Hope there are users in this group w/ =
PostgreSQL=20
familiarity and this BSD interaction <BR>I am setting up postgreSQL =
and have=20
ran into a problem related to either <BR>kernel config or operating =
within=20
'the jail'.=20
<P>Some interactions w/ the postgresql user groups =3D=3D>=20
<P>Systems: PostgreSQL version 7.2.1, with all default settings =
on a=20
<BR> BSD platform ,4.5-RELEASE FreeBSD. <BR> =20
<BLOCKQUOTE> hostname# initdb -D /usr/local/pgsql/data=20
<BR> The files belonging to this database system will be =
owned=20
by user "postgres". <BR> This user must also own the =
server=20
process.=20
<P> Fixing permissions on existing directory=20
/usr/local/pgsql/data... ok <BR> creating directory=20
/usr/local/pgsql/data/base... ok <BR> creating directory =
/usr/local/pgsql/data/global... ok <BR> creating =
directory=20
/usr/local/pgsql/data/pg_xlog... ok <BR> creating =
directory=20
/usr/local/pgsql/data/pg_clog... ok <BR> creating =
template1=20
database in /usr/local/pgsql/data/base/1... <BR> =20
IpcSemaphoreCreate: semget(key=3D1, num=3D17, 03600) failed: =
Function not=20
implemented=20
<P> initdb failed. =
<BR> </P></BLOCKQUOTE> Any=20
ideas on the semget() function, remembered reading on it somewhere =
before but=20
<BR> can't remember where <BR> I hope this =
does not=20
call for a kernel rebuild <BR> I did an ipcs -s which =
=3D=3D=3D>=20
<BR> =20
<BLOCKQUOTE> hostname# ipcs -s=20
<BR> Semaphores:=20
<BR> T =20
ID =
KEY =20
MODE OWNER =
GROUP=20
<P> hostname#=20
<BR> </P></BLOCKQUOTE> Any insight on this type of =
problem?=20
<P>Response =3D=3D=3D> <BR> <B>Hmm, usually this means either =
the kernel's=20
not configured for SYSV ipc</B> <BR><B> or that you're running =
in a jail=20
and the sysctl to let the jail use</B> <BR><B> sysv ipc is not =
turned=20
on.</B> <BR> =20
<P>Is this a plausible explanation, & if it is that the =
kernel's not=20
configured for SYSV ipc <BR>or that I am running in a jail how can the =
sysctl=20
be turned on to allow the jail to use sysv ipc?=20
<P> Thanks=20
<P>I've spoken w/ my ISP, Tech. support personnel not quite familiar =
w/=20
problem but promised to investigate. <BR>Any other experienced =
opinions=20
welcomed ...=20
<P>--- Joe --- <BR> <BR> =
<BR> =20
</P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_009E_01C217B2.C3AA2340--
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020620043104.9796F37B414>