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

[John K. <kl...@gm...>]

Hi Dave,

Are you referring to the files in var/sqlrelay/tmp/ipc?  I actually
manually chmod'd those to 666, and still have the issue.

Or, are you saying that the permissions *at the time of creation* are
the issue (such that chmod'ing after the fact has no real effect)?

I'll give your code change a try, regardless.

Thanks,
JK

On Feb 5, 2008 5:32 PM, David Muse <dav...@fi...> wrote:
> 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
>
> -------------------------------------------------------------------------
> 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
>