Project

General

Profile

Actions

Defect #17598

open

Wiki page for installation instructions is incomplete

Added by Michel Behr over 9 years ago. Updated over 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Documentation
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

Please correct me if I'm wrong, but AFAIU, what we see here:
http://www.redmine.org/projects/redmine/wiki/redmineinstall#PostgreSQL

Is this:
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;

When in fact it should THIS:
su postgres
psql
postgres=# CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD '<password>' NOINHERIT VALID UNTIL 'infinity';
postgres=# CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine TEMPLATE template0;
postgres=# \q
exit

The same applies to MySQL, we should present more complete instructions - shouldn't we...? (I don't have write access to the wiki, that's why I didn't do it on my own).

Actions #1

Updated by Michel Behr over 9 years ago

Please correct me if I'm wrong, but AFAIU, what we see here:
http://www.redmine.org/projects/redmine/wiki/redmineinstall#PostgreSQL

Is this:
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;

When in fact it should be THIS:
su postgres
psql
postgres=# CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD '<password>' NOINHERIT VALID UNTIL 'infinity';
postgres=# CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine TEMPLATE template0;
postgres=# \q
exit

The same applies to MySQL, we should present more complete instructions - shouldn't we...? (I don't have write access to the wiki, that's why I didn't do it on my own).

Actions #2

Updated by Jan Niggemann (redmine.org team member) over 9 years ago

Personally, I don't see the big difference here. Basic knowledge of how to use your system is required anyway, so the wiki might IMHO as well stay as it is, but that's just my 2ct.

Actions #3

Updated by Michel Behr over 9 years ago

Yes, I don't have that basic knowledge... :-) and I understand that at one time one needs to stop explaining and assume SOME basic understanding as a premise - with that in mind my suggestion would be just a link to "psql basics", something like:
http://blog.sensible.io/2013/08/19/postgresql-basics-by-example.html

But yeah, now that I'm having to learn about databases, postgresql, etc, it seems pretty basic really and "standard" before anyone can deal with redmine.

Actions #4

Updated by Toshi MARUYAMA over 9 years ago

  • Category changed from Wiki to Documentation
Actions

Also available in: Atom PDF