I'm trying to setup a game server control panel (SCInterface) to mess around with on my server. It needs PostgreSQL to run, but the problem is I have zero experience with that. My server is running the latest Ubuntu with Postgresql and dependecies installed. Here's the error I'm getting when I run the install script for the CP (after it auto downloads/extracts the zip):
Afaik, I need to setup a personal key and certificate, which I've done. The problem is that I don't know where to put it for it to be recognized.
Code:
SCManager_latest_Linux32.tar.bz2: OK
MD5 checksum matches, continuing
extracting archive
SCManager/
SCManager/db/
SCManager/db/scm_setup.sh
SCManager/db/Base.sql
SCManager/db/Game_Servers.sql
SCManager/db/LicenseGenerator.sql
SCManager/db/SCM_ServerDB.sql
SCManager/db/SCM_Logs.sql
SCManager/db/setSequences.sql
SCManager/db/table_rules.sql
SCManager/db/Voice_Servers.sql
SCManager/db/Web_Services.sql
SCManager/db/scm_types.so
SCManager/runme.sh
SCManager/SCManager
SCManager/libpqxx-2.4.3.so
SCManager/libpq.so.4
SCManager/libssl.so.0.9.7
SCManager/libcrypto.so.0.9.7
SCManager/libz.so.1
SCManager/libxml2.so.2
Updating the locate database, this might take a while depending on
when you last did this, and the I/O of your system
Installing scm_types.so
System Changes
Database changes
Making sure database server is upThe PostgreSQL server failed to start. Please check the log output:
/usr/lib/postgresql/7.4/bin/postmaster: TCP/IP connections must be enabled for SSL
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Creating the database user
createuser: could not connect to database template1: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Error creating database user. Please look at previous errors.
Error executing the SCM database setup script.
Please look at previous errors
Afaik, I need to setup a personal key and certificate, which I've done. The problem is that I don't know where to put it for it to be recognized.