Thread: How to access service using LAN
Dear Friends,
I have a crucial problem, I try to develop an
application using Python and PostgreSQL. I try to make
a GUI using Python and i've planned to SELECT, INSERT
and UPDATE the data on the database server. For
justifications :
PC1<----------------------------> PC2
192.168.0.3/24 192.168.0.2/24
Mandrake Linux 8.2 Mandrake Linux 8.2
PostgreSQL 7.2 server Python 2.2 + GUI
Python 2.2
database: mindik attribute :
table: name, id name, id
But my problem was the Python interpreter still can't
access table in the PC1. I've open the default port:
5432 on Postgresql.conf in /var/lib/pgsql/data
I try to set up the pg_hba.conf:
localhost mindik 192.168.0.3 trust
I try the interpreter in PC1:
>>>import pg
>>>select=database_query("SELECT name FROM mindik
WHERE id=(13920)")
The message from the Python interpreter :
There is an error setting on the file pg_hba.conf.
Is there anyone who can help my problems, please ?
Thank's for those who able to help me.
Best regards,
Santoso
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
santoso berkah <im_id@yahoo.com> writes:
> The message from the Python interpreter :
> There is an error setting on the file pg_hba.conf.
[blink] I'm pretty certain there is no Postgres-related code that would
produce an error message spelled just that way. Could we see the exact
error message, not a translation, please? Also it would be useful for
you to look into the postmaster's stderr log to see what is reported
there.
regards, tom lane
santoso berkah <im_id@yahoo.com> writes:
> I try to set up the pg_hba.conf:
> localhost mindik 192.168.0.3 trust
BTW, this is certainly wrong... PG 7.2 supports these two syntaxes:
# Unix sockets:
local all trust
# TCP sockets:
host all 127.0.0.1 255.255.255.255 trust
You might perhaps also want
host all 192.168.0.3 255.255.255.255 trust
or
host all 192.168.0.0 255.255.255.0 trust
depending on your local network setup.
regards, tom lane
Hello Tom,
I try to follow your instruction to set up the
pg_hba.conf and it was worked. Thanks for your help.
And i have some trouble :
When i try to connect the Python file and PostgreSQL
service (under postgres user), it was works, but when
i try the GUI application using Tkinter, there was an
error messages:
bash-2.05$ python InputBiodataAdministrasiwithDB.py
Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified
Traceback (most recent call last):
File "InputBiodataAdministrasiwithDB.py", line 24, in
?
root = Tk()
File "/usr/lib/python2.2/lib-tk/Tkinter.py", line
1487, in __init__
Tclerror: couldn't connect to display ":0"
Can you tell me how to fix the problem:
1. To make the user postgres have the authority for
acessing xserver (Xwindow).
2. To make the other user such as John to have an
access as same as the user postgres.
Thank you very much for your help.
Best Regards,
Santoso
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> santoso berkah <im_id@yahoo.com> writes:
> > I try to set up the pg_hba.conf:
>
> > localhost mindik 192.168.0.3 trust
>
> BTW, this is certainly wrong... PG 7.2 supports
> these two syntaxes:
>
> # Unix sockets:
> local all
> trust
> # TCP sockets:
> host all 127.0.0.1 255.255.255.255
> trust
>
> You might perhaps also want
> host all 192.168.0.3 255.255.255.255
> trust
> or
> host all 192.168.0.0 255.255.255.0
> trust
> depending on your local network setup.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
Hello Friends,
I try to follow your instruction to set up the
pg_hba.conf and it was worked. Thanks for your help.
And i have some trouble :
When i try to connect the Python file and PostgreSQL
service (under postgres user), it was works, but
when
i try the GUI application using Tkinter, there was
an
error messages:
bash-2.05$ python InputBiodataAdministrasiwithDB.py
Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified
Traceback (most recent call last):
File "InputBiodataAdministrasiwithDB.py", line 24,
in
?
root = Tk()
File "/usr/lib/python2.2/lib-tk/Tkinter.py", line
1487, in __init__
Tclerror: couldn't connect to display ":0"
Can you tell me how to fix the problem:
1. To make the user postgres have the authority for
acessing xserver (Xwindow).> 2. To make the other
user such as John to have an
access as same as the user postgres.
Thank you very much for your help.
Best Regards,
Santoso
> --- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > santoso berkah <im_id@yahoo.com> writes:
> > > I try to set up the pg_hba.conf:
> >
> > > localhost mindik 192.168.0.3 trust
> >
> > BTW, this is certainly wrong... PG 7.2 supports
> > these two syntaxes:
> >
> > # Unix sockets:
> > local all
>
> > trust
> > # TCP sockets:
> > host all 127.0.0.1
> 255.255.255.255
> > trust
> >
> > You might perhaps also want
> > host all 192.168.0.3
> 255.255.255.255
> > trust
> > or
> > host all 192.168.0.0 255.255.255.0
>
> > trust
> > depending on your local network setup.
> >
> > regards, tom lane
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo@postgresql.org so that your
> message can get through to the mailing list
cleanly
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com