LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-28-2009, 09:39 PM   #1
johnh10000
Member
 
Registered: Nov 2008
Distribution: Ubuntu Lucid Lynx
Posts: 541

Rep: Reputation: 33
postgresql


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
 
Old 08-29-2009, 09:44 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,550

Rep: Reputation: 137Reputation: 137
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?
 
Old 08-29-2009, 10:08 AM   #3
johnh10000
Member
 
Registered: Nov 2008
Distribution: Ubuntu Lucid Lynx
Posts: 541

Original Poster
Rep: Reputation: 33
Quote:
Originally Posted by j-ray View Post
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
 
Old 08-29-2009, 10:10 AM   #4
johnh10000
Member
 
Registered: Nov 2008
Distribution: Ubuntu Lucid Lynx
Posts: 541

Original Poster
Rep: Reputation: 33
Quote:
Originally Posted by johnh10000 View Post
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.
 
Old 08-30-2009, 12:35 PM   #5
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu, mint, suse
Posts: 1,550

Rep: Reputation: 137Reputation: 137
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
 
Old 08-30-2009, 02:23 PM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
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
 
Old 08-30-2009, 02:57 PM   #7
johnh10000
Member
 
Registered: Nov 2008
Distribution: Ubuntu Lucid Lynx
Posts: 541

Original Poster
Rep: Reputation: 33
Quote:
Originally Posted by Tinkster View Post
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.

Last edited by johnh10000; 10-31-2010 at 06:50 AM.
 
Old 08-30-2009, 04:52 PM   #8
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
What does
Code:
grep -i listen_addresses /path/to/postgresql.conf
say?


Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
PostgreSql sijomon_nd Fedora 1 09-27-2005 10:27 PM
PostgreSQL 7.3.2 redhatrosh Programming 6 06-01-2005 09:15 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 03:50 AM
postgreSQL dsgdevil Linux - Software 3 02-20-2003 11:30 PM
Postgresql Pain in the.......... Linux - General 2 11-09-2001 02:32 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:11 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration