[Server-devel] Attempting to re-install jabber component of XS without re-installing the entire server

[Daniel Bennett]

Also,

Given that the error log mentioned "version mangling" I have been trying to
re-install/update moodle and I've run into the following peculiarity (or it
seems peculiar to me anyway).

rpm -q moodle-xs:
moodle-xs-1.9.5.xs1.1.gc292d55-1.xs9.noarch

rpm -U moodle-xs:
error: open of moodle-xs failed: no such file or directory

Is that normal?

On Fri, Sep 18, 2009 at 9:20 AM, Daniel Bennett <dantana at gmail.com> wrote:

>
>> I had to re-read your logs a bit. In brief: I made the mistake of
>> reading the moodle-instupg.log bottom-up, and thought the install had
>> become corrupted. But re-visiting it, I realise that the error that is
>> key here is the failure to connect to the Postgres server.
>>
>>   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"?
>>
>> So we need to make sure that the pgsql-xs service is running, and that
>> it accepts connections from Moodle (that is, from apache).
>>
>> Some commands to try (and the correct output in my test XS)
>>
>>    # check that the postgresql service is *not* set to run as it will
>> conflict w pgsql-xs
>>    $ chkconfig --list postgresql
>>    postgresql      0:off   1:off   2:off   3:off   4:off   5:off   6:off
>>
>> Verified
>
>>
>>    # should say that the server is running
>>    $ service pgsql-xs status
>>
>> Verified:  postmaster (pid 2904 2903 2902 2901 2899 2804) is running...
>
>>
>>    # should give you a list of databases - see how moodle-xs is owned by
>> apache
>>    $  su postgres -c '/usr/bin/psql -l '
>>         List of databases
>>    Name    |  Owner   | Encoding
>> ------------+----------+-----------
>>  moodle-xs  | apache   | UTF8
>>  postgres   | postgres | SQL_ASCII
>>  template0  | postgres | SQL_ASCII
>>  template1  | postgres | SQL_ASCII
>>
>> Verified: just these (4 rows)
>
>>
>>    # check that you can connect as the apache user and list existing
>> tables
>>    $sudo -u apache psql moodle-xs -c '\d'
>>                              List of relations
>>  Schema |                  Name                   |   Type   | Owner
>> --------+-----------------------------------------+----------+--------
>>  public | adodb_logsql                            | table    | apache
>>  public | adodb_logsql_id_seq                     | sequence | apache
>>  public | mdl_assignment                          | table    | apache
>>  public | mdl_assignment_id_seq                   | sequence | apache
>>  public | mdl_assignment_submissions              | table    | apache
>>  public | mdl_assignment_submissions_id_seq       | sequence | apache
>>  public | mdl_backup_config                       | table    | apache
>> ...
>>
>> Verified: It continues for 406 rows
>
>>
>>
>> Can you try these commands? I think we're pretty close to resolving the
>> problem.
>>
>>
>> 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?
>
> 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.  so what you saw at the bottom
> of the file may be the actual breakage as you originally expected
>
> (not simply a conflict with postgresql, which doesn't seem to be occurring
> given that my output from your suggestions above matches your samples.)
>
> 'Morning!
> -Dan
>
>>
>>
>> m
>> --
>>  martin.langhoff at gmail.com
>>  martin at laptop.org -- School Server Architect
>>  - ask interesting questions
>>  - don't get distracted with shiny stuff  - working code first
>>  - http://wiki.laptop.org/go/User:Martinlanghoff
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.laptop.org/pipermail/server-devel/attachments/20090918/d6da472a/attachment-0001.htm