Defect #17598
openWiki page for installation instructions is incomplete
0%
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).
Updated by Michel Behr over 10 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).
Updated by Jan Niggemann (redmine.org team member) over 10 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.
Updated by Michel Behr over 10 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.
Updated by Toshi MARUYAMA over 10 years ago
- Category changed from Wiki to Documentation