postgresql

johnh10000 · 08-28-2009, 08:39 PM

Hi I have installed campcaster, and postgresql. It's unlikly I'll be using postgres, for anything else. I would be greatul if one of you could help me resolve the following:

*************************
* StorageServer Install *
*************************
DB Error: connect failed
[nativecode=pg_pconnect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "::1", user "campcaster", database "Campcaster", SSL off] ** pgsql(pgsql)://campcasterASSWORD@localhost/Campcaster
Database connection problem.
Check if database 'Campcaster' exists with corresponding permissions.
dpkg: error processing campcaster-station (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of campcaster-studio:
campcaster-studio depends on campcaster-station (= 1.4.0-3beta3); however:
Package campcaster-station is not configured yet.
dpkg: error processing campcaster-studio (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
campcaster-station
campcaster-studio

j-ray · 08-29-2009, 08:44 AM

would be helpful to know how you installed postgresql. At least there should be the mentioned user registered with the server. Does the database exist? Did you check that?

johnh10000 · 08-29-2009, 09:08 AM

Quote:

Originally Posted by j-ray

would be helpful to know how you installed postgresql. At least there should be the mentioned user registered with the server. Does the database exist? Did you check that?

I am using ubuntu jaunty, so all I did was:

sudo apt-get install -f postgresql postgresql-client postgresql-contrib

johnh10000 · 08-29-2009, 09:10 AM

Quote:

Originally Posted by johnh10000

I am using ubuntu jaunty, so all I did was:

sudo apt-get install -f postgresql postgresql-client postgresql-contrib

Oh and campcast makes a database ok. I think it's the campcast user bit thats wrong.

j-ray · 08-30-2009, 11:35 AM

if that was all you did the postgres server isn't running, is it?
ps -e | grep postgres
should display a list of processes if it is running

if running you maybe have to edit
/etc/postgresql/VERSIONNUMBER/pg_hba.conf

and restart the server...

Good luck

Tinkster · 08-30-2009, 01:23 PM

The entry should look something like:

Code:

host    Campcaster         campcaster         ::1/128               trust(or md5)

trust or md5 depending on whatyour needs are; md5 should
be the better choice (specially since the connection string
mentioned one).

Cheers,
Tink

johnh10000 · 08-30-2009, 01:57 PM

Quote:

Originally Posted by Tinkster

The entry should look something like:

Code:

host    Campcaster         campcaster         ::1/128               trust(or md5)

trust or md5 depending on whatyour needs are; md5 should
be the better choice (specially since the connection string
mentioned one).

Cheers,
Tink

I tried that. But if you look at the attachments, the darn thing changes it back to normal. An won't work. BTW from the command line I can log into it's database.

When it does work, I'd better like the thing.

Tinkster · 08-30-2009, 03:52 PM

What does

Code:

grep -i listen_addresses /path/to/postgresql.conf

say?

Cheers,
Tink