More or less problem was with migration from mysql to postgresql.
I was following this documentation:
Everything went well until i came to this point:
When the appliance displays the final screen in the console window, open your management browser and log in to the appliance on port 9443 as the vaadmin user.
Here i had some errors/missing icons:
- phpPGAdmin icon is missing in UI
- Filr - Configuration returned error. PostgreSQL problem.
From what i have noticed is that Postgres is trying to use ROOT user which doesn't exist. I had to modify /filrinstall/installer.xml and change username to POSTGRES
<Config id="Installed" type="PostgreSql">
<Resource driverClassName="org.postgresql.Driver" for="icecore" password="SOME_PASSWORD" url="jdbc:postgresql://localhost:5432/filr?charSet=UTF-8" username="postgres"/>
Second problem was that even that authentication was correct in console, i didn't get it to work from filr script so i have changed postgres authentication method from MD5 to Trust.
local all all trust
And the third problem was that database filr was missing. I was first looking if some script includes creation of filr database but i couldn't find it so i have created it on my own.
psql -U postgres -c "create database filr;"
After this upgrade finished.
Upgrade could be restarted through https://FILR_IP:9443/filrconfig
After you get an error you click "Finish" and filr retries upgrade.
After another check i have noticed that if upgrade is succesfull phpPGAdmin icon is there, but connecting to https://FILR_IP:8443/ssf/a/ returns an error so i need to debug more.
HTTP Status 500 – Internal Server Error
Type Exception Report
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Note The full stack trace of the root cause is available in the server logs.
I hope this helps someone.