I've tried various permutations on compiling and installing Campcaster, and I'm stumped, and I could use some help.

This question isn't about compiling it - I actually managed to get it to compile cleanly, satisfying a ton of missing library dependencies, learning about PKG_CONFIG_PATH, why it's important to NOT set your --prefix flag to /usr to override the default of /usr/local, that sort of thing.

The thing just won't connect to the database, no matter what. Note here that it's trying to connect to 'campcaster' with a user of 'campcaster' in spite of the command line options I've supplied.

But even when I throw in the towel and use the default database name and default user name, with a password of 'campcaster' I get the same 'can't connect' results.

I think it's telling that psql won't even connect, and fails authentication the same way. So this is telling me that I've got postres misconfigured in some way that I can't determine. When I switched the local login line in pg_hba.conf from
'local all all ident sameuser'
to
'local all all md5'

I was able to log into psql, no problem. However, I can't get Campcaster to do this, there's apparently no config setting that controls this.


What should I be looking at? Has anybody else had this problem? Assume a virgin install of 'postgresql'.

Could this have something to do with TCP/IP sockets?

I notice also that Campcaster has added the following to my pg_hba.conf file:

# The following line was inserted by the campcaster-station package installer
# the original pg_hba.conf file is saved under pg_hba.conf.before-campcaster
host all all 127.0.0.1 255.255.255.255 password
#host all all 127.0.0.1 255.255.255.255 ident sameuser





Here's the results of my attempt to run the postInstallStation script:
==========================
[root@footage campcaster-1.4.0]# bin/postInstallStation.sh --directory=/usr/local --database=myradio --dbpassword=mypassword --dbuser=myradio --www-root=/srv/www --postgresql-dir /var/lib/pgsql/data --postgresql-init-script=/etc/rc.d/init.d/postgresql
Making post-install steps for Campcaster Station.

Using the following installation parameters:

installation directory: /usr/local
database server: localhost
database: myradio
database user: myradio
database user password: mypassword
apache daemon group: apache
apache document root: /srv/www
postgresql data directory: /var/lib/pgsql/data
postgresql init script: /etc/rc.d/init.d/postgresql

Checking for required tools...
Executable sed found...
Executable psql found...
Executable php found...
Executable odbcinst found...
Modifying postgresql access permissions...
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
Creating database for Campcaster scheduler.

Using the following parameters:

database server: localhost
database: myradio
database user: myradio
database user password: mypassword

Checking for required tools...
Executable su found...
Executable psql found...
Creating database and database user...
ERROR: role "myradio" already exists
ERROR: database "myradio" already exists
Done.
Creating ODBC data source for Campcaster scheduler.

Using the following installation parameters:

database server: localhost
database: myradio

Checking for required tools...
Executable sed found...
Executable grep found...
Executable odbcinst found...
Removing old ODBC PostgreSQL driver...
PostgreSQL_Campcaster has been deleted (if it existed at all) because its usage count became zero
Registering ODBC PostgreSQL driver...
odbcinst: Driver installed. Usage count increased to 1.
Target directory is /etc
Registering Campcaster ODBC data source...
Done.
Setting up directory permissions...
Configuring apache ...
/etc/apache/conf.d N
/etc/apache2/conf.d N
/etc/apache2/conf/modules.d N
/etc/httpd/conf.d Y
done
Restarting apache...
apache N
apache2 N
httpd Y
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
done
Creating symlinks...
Initializing database...
*************************
* StorageServer Install *
*************************
DB Error: connect failed
[nativecode=Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "campcaster"] ** pgsql(pgsql)://campcaster:PASSWORD@localhost/Campcaster
Database connection problem.
Check if database 'Campcaster' exists with corresponding permissions.
[root@footage campcaster-1.4.0]#