Who Me Too'd this topic

seba4 · ‎2019-04-09

Hi today i was trying to upgrade filr 3.4.3 to 4.x but i had some problems with upgrade.

More or less problem was with migration from mysql to postgresql.

I was following this documentation:
https://www.microfocus.com/documentation/filr/filr-4/filr-inst/t43dt993zq1c.html

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

[PHP]
<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"/>
</Config>
</Database>
[/PHP]

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.

File: /vastorage/postgres/conf/vabase-pg_hba.conf
[PHP]
local all all trust
[/PHP]

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.
[PHP]
psql -U postgres -c "create database filr;"
[/PHP]

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.

ERROR:

[PHP]
HTTP Status 500 – Internal Server Error
Type Exception Report

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

java.lang.NullPointerException
org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge.nextTimestamp(RegionFactoryCacheProviderBridge.java:93)
org.hibernate.impl.SessionFactoryImpl.openSession(SessionFactoryImpl.java:637)
org.hibernate.impl.SessionFactoryImpl.openSession(SessionFactoryImpl.java:646)
org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:321)
org.springframework.orm.hibernate3.SessionFactoryUtils.getSession(SessionFactoryUtils.java:202)
org.kablink.teaming.util.SessionUtil.sessionStartup(SessionUtil.java:63)
org.kablink.teaming.webdav.servlet.filter.HibernateSessionSetupFilter.setupHibernateSession(HibernateSessionSetupFilter.java:92)
org.kablink.teaming.webdav.servlet.filter.HibernateSessionSetupFilter.doFilter(HibernateSessionSetupFilter.java:73)
org.kablink.teaming.webdav.servlet.filter.ResourceDispatchFilter.doFilter(ResourceDispatchFilter.java:210)
Note The full stack trace of the root cause is available in the server logs.
[/PHP]

I hope this helps someone.

Who Me Too'd this topic

Who Me Too'd this topic

Filr 3.4.3 to 4.0 upgrade