[Mapbender-dev] install script handling

[Christoph Baudson]

Thomas Baschetti schrieb:
> Hi,
>
>
> Christoph Baudson schrieb:
>>
>> I'm still somehow puzzled what would be the standard way to install 
>> Mapbender:
>> (1) which user shall run the installer?
>> (2) which db user shall be used?
>>
>> Here are my thoughts, please help me get on track
>> (1) the user should be allowed to grant write permissions to the web 
>> user, so the script must be run as a superuser
> not nice, i don't like this. I try NOT to start any script as a 
> superuser unless it is really, really, really necessary.
>> (2) the success of the database access depends upon the settings in 
>> pg_hba.conf (in PostgreSQL). I assume the default is "ident", which 
>> leads me to the assumption, that there must be a corresponding db 
>> user to the os user. I always create a superuser named after my os 
>> user, so I don't have a problem. But if I want to use the db user 
>> "postgres", this won't work. When does PostgreSQL ask for a password? 
>> And if so, does it require the password for every single SQL file?
> First to say, "ident" is not default on windows (who uses windows, 
> anyway...)
> If using password-authentification (md5), psql will ask whenever it 
> connects to the database. So yes, for every single SQL-file (+1 extra 
> for createdb)
> You can prevent this by
> - setting an environment var "pgpassword" which is considered a 
> security risk,
> - using a file ~/.pgpass which consists of connect-strings:
>   host:port:database:username:password

You put a lot of thought into it, thanks. Will have to try it myself.

>
>>
>> The installer should be foolproof and self-explanatory. Please help.
>>
> and have a gui.
> I think installation should be like:
> - download mapbender
> - unzip it in your webdirectory
> - go to http://server/mapbenderpath
> - fill in some questions (database, server, ...)
> - magic happens
> - mapbender is up and running
>
> The actual install-scripts are only a temporary solution, imho.

Yes, you're right.

>
> Other projects get this done (mediawiki, drupal...), i think we can 
> get this done, too.
>
> Other opinions?
>
> Ciao
> Thomas
>


-- 
********************************************
INTERGEO 2009
22.-24. September 2009 in Karlsruhe
Halle 1, Stand 1.417
www.intergeo.de
******************************************** 

_______________________________________

W h e r e G r o u p GmbH & Co. KG

Siemensstraße 8
53121 Bonn
Germany

Christoph Baudson
Anwendungsentwickler

Fon: +49 (0)228 / 90 90 38 - 15
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________

Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Olaf Knopp, Peter Stamm
_______________________________________