[Maps-l] running tools on cassini / db / old-name

[Kate]

On Thu, Aug 13, 2009 at 8:15 PM, Aude<aude.wiki at gmail.com> wrote:
> On 8/13/09, Tim Alder <tim.alder at s2002.tu-chemnitz.de> wrote:
>> Hello,
>> the outdating is not so the problem for me because I only want to make
>> my first steps in postgres on this way (I hope I find time).
>> For regular updating we should wait for our db-server.
>>
>> But it would be nice if you can tell me how you contact the database, in
>> which language your scripts are and where they are.
>> So why doesn't http://cassini.toolserver.org/~kolossos/osm work (PHP) if
>> it's fine on http://toolserver.org/~kolossos/osm ?
>>
>> Greetings Kolossos
>>
>
> I had time available today to look at how postgres is setup and found
> that further configuration work is needed, including for how user
> authentication is handled.  This means that whatever way Peter is
> using will change.
>
> We should set things so they work similar to how the toolserver
> handles MySQL authentication with .my.cnf files.  The equivalent for
> postgres are .pgpass files that reside in the user home directories.
>
> Also, not everyone has an account yet.  If granted the right
> privileges (don't need root access), then I can work on this in the
> next few days.
>
> -Aude
>

I have been discussing how to handle authentication on IRC.  Instead
of password authentication, we may use the ident authentication
option.  This means that no password is needed, with postgresql
instead trusting the authentication (ssh/key) that got you logged into
cassini.  This should work if users will access the database only
locally, and we don't need to enable TCP/IP connections.

As for why http://cassini.toolserver.org/~kolossos/osm isn't working,
apache UserDir is set to have osm_public_html as the root web
directory.  You can create a symlink from your kolossos/public_html
directory to the kolossos/osm_public_html directory.

I did that and now my beautiful :) home page works:

http://cassini.toolserver.org/~aude

-Aude

>>
>>
>> _______________________________________________
>> Maps-l mailing list
>> Maps-l at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/maps-l
>>
>
> _______________________________________________
> Maps-l mailing list
> Maps-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/maps-l
>