[#5101] - postgreSQL credentials missing in source code

Category:
Bug report
Priority:
Low
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

In installing via source code postgreSQL credentials are missing, and you can't login application as jasperadmin user.

AttachmentSize
Binary Data js400-patches.tar.gz1.61 KB
jgh's picture
jgh
435
Joined: Aug 27 2010 - 4:24pm
Last seen: 7 years 7 months ago

2 Comments:

#1

Date: Wed, 23 Feb 2011 10:24:14 -0800
From: Alex Matzinger <amatzinger@experts-exchange.com>
To: Jason Helfman <jhelfman@e-e.com>
Subject: Diff in credentials file

[-- Autoview using w3m -I 'ISO-8859-1' -T text/html -dump --]
For ALL insert statements the ` marks surounding table names and attributes
needed to be removed.

This statement needed to have the tenantAlias attribute added, as there is a
not null requirement. The default was set to ' '.

INSERT INTO JITenant (id, tenantId, parentId, tenantName, tenantDesc,
tenantNote, tenantUri, tenantFolderUri, tenantAlias)
VALUES (1,'organizations',NULL,'root','organizations',' ','/','/',' ');

Inserting into JIRole needs to be done one insert at a time, and all
externallyDefined attributes changed from '0' to 'false'.

INSERT INTO JIRole (rolename, tenantId,externallyDefined) VALUES
('ROLE_USER',1,false);

Inserting into JIUser needed the externallyDefined, and enabled attribute's
values changed from '0', and '1' to 'false' and 'true'

INSERT INTO JIUser
(username,tenantId,fullname,emailAddress,password,externallyDefined,enabled)
VALUES
('jasperadmin',1,'Jasper
Administrator',NULL,'349AFAADD5C5A2BD477309618DCD58B9',false,true);

Inserting into JIResourceFolder need to have the update_date attribute added to
the insert statement with a default value of 'NOW()'.

INSERT INTO JIResourceFolder
(id,version,uri,hidden,name,label,description,parent_folder,creation_date,update_date)
VALUES
(1,0,'/',false,'/','root','Root of the folder hierarchy',NULL,NOW(),NOW());

- Alex

#2

I've confirmed that the sql credentials are suitable for both 8.4 and 9.x, and there is no need for different sql for 9.x. A colleague of mine, Phil, noted that the sql for 9.x in this ticket is just a shortcut that is new in 9.x, but said the sql in the 8.4 file would work just fine with 9.x. Thanks!

Feedback