Salut,
Incerc sa instalez bbstatus, dar cunostintele mele in ceea ce
priveste postgresql cam lasa de dorit.
Nu reusesc sa-i dau de capat si am nevoie de un sfat. :(
_______________________
[EMAIL PROTECTED] virtuals]# tail -4 /var/www/virtuals/bbstatus/log/error_log
[Fri Jan 09 05:18:13 2004] [error] [client 192.168.0.69] mod_auth_pgsql
database connection error reset failed FATAL: no pg_hba.conf entry for
host "192.168.0.69", user "bbstatus", database "bbstatus", SSL off
_______________________
[EMAIL PROTECTED] virtuals]# cat /var/lib/pgsql/data/pg_hba.conf | grep -v '#'
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host bbstatus bbstatus 192.168.0.69 255.255.255.0 password
______________________
[EMAIL PROTECTED] virtuals]# cat /var/lib/pgsql/data/postgresql.conf | grep -v '#'
tcpip_socket = true
ssl = true
port = 5432
LC_MESSAGES = 'en_US.UTF-8'
LC_MONETARY = 'en_US.UTF-8'
LC_NUMERIC = 'en_US.UTF-8'
LC_TIME = 'en_US.UTF-8'
______________________
bbstatus=# \connect bbstatus
You are now connected to database bbstatus.
bbstatus=#
bbstatus=# select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+----------+-------------+----------+-----------+--------+---
postgres | 1 | t | t | t | |
|
bbstatus | 100 | t | t | t | |
|
(2 rows)
_____________________
Thx! :(
--
\Y__Y
/O--O\
_| |_ Share the road safely!
--
---
Detalii despre listele noastre de mail: http://www.lug.ro/
