<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><blockquote>
I had to re-read your logs a bit. In brief: I made the mistake of<br>
reading the moodle-instupg.log bottom-up, and thought the install had<br>
become corrupted. But re-visiting it, I realise that the error that is<br>
key here is the failure to connect to the Postgres server.<br><br>
psql: could not connect to server: No such file or directory<br>
Is the server running locally and accepting<br>
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?<br><br>
So we need to make sure that the pgsql-xs service is running, and that<br>
it accepts connections from Moodle (that is, from apache).<br><br>
Some commands to try (and the correct output in my test XS)<br><br>
# check that the postgresql service is *not* set to run as it will<br>
conflict w pgsql-xs<br>
$ chkconfig --list postgresql<br>
postgresql 0:off 1:off 2:off 3:off 4:off 5:off 6:off<br></blockquote></blockquote><div>Verified <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<blockquote><br>
# should say that the server is running<br>
$ service pgsql-xs status<br></blockquote></blockquote><div>Verified: postmaster (pid 2904 2903 2902 2901 2899 2804) is running...<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<blockquote><br>
# should give you a list of databases - see how moodle-xs is owned by apache<br>
$ su postgres -c '/usr/bin/psql -l '<br>
List of databases<br>
Name | Owner | Encoding<br>
------------+----------+-----------<br>
moodle-xs | apache | UTF8<br>
postgres | postgres | SQL_ASCII<br>
template0 | postgres | SQL_ASCII<br>
template1 | postgres | SQL_ASCII<br></blockquote></blockquote><div>Verified: just these (4 rows) <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<blockquote><br>
# check that you can connect as the apache user and list existing tables<br>
$sudo -u apache psql moodle-xs -c '\d'<br>
List of relations<br>
Schema | Name | Type | Owner<br>
--------+-----------------------------------------+----------+--------<br>
public | adodb_logsql | table | apache<br>
public | adodb_logsql_id_seq | sequence | apache<br>
public | mdl_assignment | table | apache<br>
public | mdl_assignment_id_seq | sequence | apache<br>
public | mdl_assignment_submissions | table | apache<br>
public | mdl_assignment_submissions_id_seq | sequence | apache<br>
public | mdl_backup_config | table | apache<br>
...<br></blockquote></blockquote><div>Verified: It continues for 406 rows <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><blockquote>
</blockquote>
<br>
<br>
Can you try these commands? I think we're pretty close to resolving the problem.<br>
<div><div></div><div class="h5"><br>
<br></div></div></blockquote><div>Given that I'm getting all the same outputs you have included in your email, do you think that my hunch from last night (below) might be correct? If so, where do I go next?<br><br><span dir="ltr" id=":178">I'll try your suggestions
then. One thing worth noting though, those early failures are probably
from before you sent me the idea to make sure that psgsql was running.
Remember the back and forth we had where I ended up running the
command to start it on boot and rebooted? My guess is that the early
failures are from before I did that</span>. so what you saw at the bottom of the file may be the actual breakage as you originally expected <br><br>(not simply a conflict with postgresql, which doesn't seem to be occurring given that my output from your suggestions above matches your samples.)<br>
<br>'Morning!<br>-Dan<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div class="h5">
<br>
<br>
m<br>
--<br>
<a href="mailto:martin.langhoff@gmail.com">martin.langhoff@gmail.com</a><br>
<a href="mailto:martin@laptop.org">martin@laptop.org</a> -- School Server Architect<br>
- ask interesting questions<br>
- don't get distracted with shiny stuff - working code first<br>
- <a href="http://wiki.laptop.org/go/User:Martinlanghoff" target="_blank">http://wiki.laptop.org/go/User:Martinlanghoff</a><br>
</div></div></blockquote></div><br>