Thread: pgaccess

pgaccess

From
paul simdars
Date:
In Xwindow, if I su to root and type pgaccess, the window comes up.
When I su to postgres or my regular user account and type pgaccess I get
error messages, they start like this :
Xlib: connection to ":0.0" refused by server
Xlib: Client is not authorized to connect to server
Application initialization failed: couldn't connect to display ":0"

There is more about error from main.tcl line 5

I'd sure like to use this interface though.
Thanks
Paul



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----


Re: pgaccess

From
Oliver Elphick
Date:
On Wed, 2002-02-20 at 20:50, paul simdars wrote:
> 
> In Xwindow, if I su to root and type pgaccess, the window comes up.
> When I su to postgres or my regular user account and type pgaccess I get
> error messages, they start like this :

This is not a pgaccess error; it is because of the way you are using X
The same would apply if you ran xterm or xeyes.

> Xlib: connection to ":0.0" refused by server
> Xlib: Client is not authorized to connect to server
> Application initialization failed: couldn't connect to display ":0"

This is because the new user which you have become does not have
authority to use your X session.  One way to solve it is to do
export XAUTHORITY=~/.Xauthority

as the user who starts X, which will work if you su to root, but not to
another non-superuser, because that user will not be able to read the
file.

Alternatively do 
xhost +localhost

which should allow any user on localhost to connect to your X session


-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
    "My sheep hear my voice, and I know them, and they      follow me; And I give unto them eternal life; and they
shallnever perish, neither shall any man pluck them      out of my hand."          John 10:27,28 
 



Re: pgaccess

From
"Liam DeMasi"
Date:
"Oliver Elphick" <olly@lfix.co.uk> wrote in message
news:1014331565.3217.938.camel@linda...
> On Wed, 2002-02-20 at 20:50, paul simdars wrote:
> >
> > In Xwindow, if I su to root and type pgaccess, the window comes up.
> > When I su to postgres or my regular user account and type pgaccess I get
> > error messages, they start like this :
>
> This is not a pgaccess error; it is because of the way you are using X
> The same would apply if you ran xterm or xeyes.
>
> > Xlib: connection to ":0.0" refused by server
> > Xlib: Client is not authorized to connect to server
> > Application initialization failed: couldn't connect to display ":0"
>
> This is because the new user which you have become does not have
> authority to use your X session.  One way to solve it is to do
>
>  export XAUTHORITY=~/.Xauthority
>
> as the user who starts X, which will work if you su to root, but not to
> another non-superuser, because that user will not be able to read the
> file.
>
> Alternatively do
>
>  xhost +localhost
>
> which should allow any user on localhost to connect to your X session
>
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>
>      "My sheep hear my voice, and I know them, and they
>       follow me; And I give unto them eternal life; and they
>       shall never perish, neither shall any man pluck them
>       out of my hand."          John 10:27,28
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


I would like to use pgaccess but i didn't include the "--with-tcl" when i
configured my installation.  Is there a way to activate it now?






Re: pgaccess

From
Andreas Kretzer
Date:
Liam DeMasi wrote:

> I would like to use pgaccess but i didn't include the "--with-tcl" when i
> configured my installation.  Is there a way to activate it now?

Yes :-)
Go to your source directory and just remove the file config.cache or simply
do a 'make distclean' (?? not sure: possibly this target is not really available).

After that start over with your "./configure --with-tcl" and install it.

Andreas