Skip site navigation (1) Skip section navigation (2)

Re: PGACCESS Error Relative Path @ export table

From: "John L(dot) Turner" <jlt(at)wvinter(dot)net>
To: Brett Schwarz <brett_schwarz(at)yahoo(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: PGACCESS Error Relative Path @ export table
Date: 2002-07-31 14:45:05
Message-ID: 200207311445.05814.jlt@wvinter.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
Brett Schwarz, wanted me to know...
> On Wed, 2002-07-31 at 05:55, John L. Turner wrote:
> > Andreas Kretzer, wanted me to know...
> >
> > > On 30.07.2002 at 17:45 John L. Turner wrote:
> > > >Hi:
> > > >
> > > >Newbe trying to learn pgaccess' import / export of tables
> > > >
> > > >ERROR
> > > >"Relative Path not allowed for servers side copy command"
> > > >
> > > >Version downloaded today (Tuesday 30 July 02) was 0.98.8
> > > >( even though the/pgaccess/lib/mainlib.tcl says 0.98.7 )
> > > >
> > > >I opened a test database, created with the command
> > > >psql mytestdb <  /pgaccess/demo/formdemo.sql
> > > >
> > > >Open Data base with no local host given,
> > > >AND with my local host IP #
> > > >
> > > >I did start postmaster with -i
> > > >
> > > >Then From Main pgaccess Menu: Database | Export Table
> > > >Tried to export the table phonebook, received above ERROR
> > > >
> > > >I entered the path /home/jlt/phonebook.txt
> > > >ERROR received.
> > >
> > > Are you sure that the error was the same? It might have been
> > > 'access denied'. Try /tmp/phonebook.txt
> > >
> > > >Also tested ~/phonebook.txt
> > > >Also tested 192.168.110.42:~/phonebook.txt
> > >
> > > Hmm... It should have been possible (except it is explicitly
> > > catched by pgaccess. But of course the home directory
> > > would have been that of the postgres backend processes'
> > > user.
> > >
> > > Hope this helps
> > > Andreas
> >
> > _________________
> > Seem to have found the answer ( at least ONE answer that worked)
> >
> > Turns out that the only directory that I have permission to write to is:
> > /var/lib/pgsql/
> >
> > I started the postmaster -1  as user  postgres
> >
> > SO that leads to the bottom line Question:
> > How does a user in postgresql obtain permissions to other directories ?
>
> This is at the OS level. Pgaccess is really only accessing the file via
> the filesystem of the OS that you are running. You need to make sure
> that the user you start PGAccess with has permissions for those
> files/directories. For example, on Unix machines, you would use chmod.
> If you are on a machine that is maintained by someone else, then you
> would need to ask that person to set the permissions correctly for you.
>

1) My system is Linux SuSE 8.0 release with
 	postgresql-7.2-70
 	pgaccess 0.98.8

2) The database I opened, was created by user postgres as follows:
 >psql mytestdb < /usr/share/doc/packages/postgresql-tk/formdemo.sql
   exited from psql .

3) I started pgaccess as user jlt ( normal user me ). @  /home/jlt
   Within pgaccess, USERS tab, I added jlt (me) as a user. 

4) Tested import and exporting of a table:
     Can not get permission to read or write to anything
     other than directory:     /var/lib/pgsql
     Was able to import and export files from that one directory.

Is it a security issue that prevents me as a normal user from
accessing those other directories, if so, why do I have permission
to /var/lib/pgsql to copy the file to another directory ( I assume 
a fat32 mount could allow me to steal that data, because 
once there, anyone could read/write to it...
Seems like a tangle web has been woven ;-)

> > Thanks to anyone for a kick in pants to find the answer.
> >
> > P.S. Why didn't the original message just say permissions not set for X
> > user ?
>
> I just sent a patch in, so that it gives a decent error message. Not
> sure if it will get applied or not...
>

Would like to see a simular corrected message when trying to Create a NEW
database with pgaccess:

"Tcl error executing pg_exec create database mytestdb

is not a valid postgresq connection"

That type of message is not too helpful to newbies like me.

Best regards for quick replies!
John Turner

In response to

Responses

pgsql-interfaces by date

Next:From: John L. TurnerDate: 2002-07-31 17:27:37
Subject: Re: PGACCESS Error Relative Path @ export table
Previous:From: Brett SchwarzDate: 2002-07-31 13:32:08
Subject: Re: PGACCESS Error Relative Path @ export table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group