Re: [Sqlrelay-discussion] Couldn't attach to shared memory segment: Permission denied

[David M. <dav...@fi...>]

Hmm, I never ran into the group log-in issue, I'll have to look into
that.  The sqlr-status issue is simpler though.  The shared memory
segment is created with rw----- (600) permissions so that the owner can
read/write it but no one else has any access to it.  I guess it would
make sense to make it at least rw-r---- (640).

A quick fix would be to edit src/listener/sqlrlistener.C and modify the
lines:

if (!idmemory->create(key,sizeof(shmdata),
				permissions::ownerReadWrite())) {

to:

if (!idmemory->create(key,sizeof(shmdata),
			permissions::evalPermString("rw-r----"))) {

Then run make and make install in that directory.

That should take care of it.  I'll put that fix in the next release.

Dave


On Tue, 2008-02-05 at 13:29 -0500, John Klassa wrote:
> Trying to run SQL Relay in an environment where a particular group (in
> the Unix group sense) have the ability to administer and check on SQL
> Relay.  I'm running into a problem, though.
> 
> I've got runasgroup set to the group of interest (call it "xyz"), in
> the config file.  I'm also doing a "newgrp xyz" prior to launching SQL
> Relay...  I discovered that setting "runasgroup" doesn't work unless
> you're logged into that group...
> 
> Anyway, when other folks in the group try to run sqlr-status, they get:
> 
> Couldn't attach to shared memory segment: Permission denied
> 
> I've tried chmoding the directories and files down to var/sqlrelay/tmp
> so that they're group readable and writable.  I even tried world
> readable/writable at one point, just to see.
> 
> What am I missing?
> 
> Thanks,
> JK
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com