In installing via source code postgreSQL credentials are missing, and you can't login application as jasperadmin user.
Date: Wed, 23 Feb 2011 10:24:14 -0800
From: Alex Matzinger <firstname.lastname@example.org>
To: Jason Helfman <email@example.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
Inserting into JIUser needed the externallyDefined, and enabled attribute's
values changed from '0', and '1' to 'false' and 'true'
INSERT INTO JIUser
Inserting into JIResourceFolder need to have the update_date attribute added to
the insert statement with a default value of 'NOW()'.
INSERT INTO JIResourceFolder
(1,0,'/',false,'/','root','Root of the folder hierarchy',NULL,NOW(),NOW());
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!