18 November 2013, 8:17

I just moved from shared hosting to VPS. Immediately our mahara site went down. I installed the missing extension in apache and got past that error message now I get an issue with the connection. 

The error received was:
postgres7 error: [-1: Database connection failed] in CONNECT(localhost, 'uddingst_mahararoot', '****', uddingst_mahara7)

Now I know that the apache server has to be configured using 

<VirtualHost *:80>
         ServerName example.org
         DocumentRoot /path/to/mahara/htdocs

         ErrorLog /var/log/apache2/mahara.error.log
         CustomLog /var/log/apache2/mahara.access.log combined

         <Directory /home/nigel/mahara/htdocs>
                 AllowOverride All
         </Directory>
    </VirtualHost
but where do I put this code? I am a new at this virtual server bit and well quite frankly lost!

18 November 2013, 11:11

Hi Michael,

The error you posted is a database connection problem, not an Apache (web server) problem. I'd recommend verifying your postgres set up by trying to connect via the command-line psql utility using the same credentials you've set up for Mahara:

psql -d uddingst_mahara7 -h localhost -U uddingst_mahararoot -W

Cheers,

Aaron