Admin panel always jumps back to installation screen

Razuna v2 Legacy Self-Hosted
1

Hi there,

I installed Razuna 1.8 sucessfully with MySQL DB on my host.
I can add users, tenants etc.

After a while, the admin page shows me the installation screen instead of the login screen. Just to mention that the tenants are still working well - just the administration panel is “gone” or lets say replaced by the installation screen.

When “reinstalling”, the database (incl. tenants) got wiped. I can access the admin page then, but all data is lost then. Afterwards, lets say 15 minutes, the installation screen appears again.

Is there something I have to change to make the install screen not appear again?

2

Something must be wrong with your setup. Please make sure that the hostname
of your machine doesn’t change and also that the permissions to the
/razuna/db folder are correct.

3

Could you please outline what this “jump back” triggered?
And what IS the “correct” permission to razuna/db folder? =)

edit:
Actual permission are chown = root (because we want to run razuna later on port 80) and permissions are chmod 777.

/opt/razuna/tomcat/webapps/razuna/db =>

-rwxrwxrwx 1 root root 5296128 Feb 10 17:56 razuna_default.h2.db
-rw-r–r-- 1 root root 152 Feb 10 17:56 razuna_default.lock.db
-rwxrwxrwx 1 root root 409600 Feb 9 15:21 razuna_default.mv.db
-rwxrwxrwx 1 root root 680 Feb 9 15:00 razuna_default.trace.db

Is that correct?

4

As outlined in my previous answer, make sure your hostname doesn’t change.
We have seen that when the hostname changes the db cannot be read. I don’t
know your system so I can’t tell you your permissions. You are the admin
you need to know what you do :slight_smile:

5

Well, the hostname didn’t change. And the raz1 db is working well, just the install page instead of admin login pops up.
Any other suggestions regarding that issue?

Could you point me to file where the “decision” is made if the login or the install screen will be shown? Would be very helpful! I try to debug it then for myself!

6

The information is kept in the H2 database called razuna_default in the
table razuna_settings. Somehow the column “Firsttime” was reset to true. It
should be “false”. You can get tools to inspect the H2 database at
h2database.com

1 Like
7

Did you manage to resolve the issue? I had a similar problem. After a few minutes of working in Razuna, the admin interface would revert to the setup wizard (which I think is what you’re seeing). Stopping and restarting Tomcat would fix it temporarily. With Nitai’s help I was able to resolve the problem by upgrading the H2 driver to version 1.4.191. Razuna has been running for several days now without a recurrence.

Razuna 1.8 self-hosted
Tomcat 8.0.3
Java JDK 1.8.0.72
MySQL 5.6.29
Firefox 44.0.2
MacPro 2 x 2.4 GHz Intel Xeon
32 GB RAM
OS X 10.9.5

8

Hi,

no, I have still the same problem as you describes.
Please explain how to update the H2 drivers!

9

Thank you for the comment. In order to apply the new driver:

  1. Download the driver from http://www.h2database.com/h2-2016-01-21.zip
  2. Stop Tomcat.
  3. Copy the h2-xxx.jar file from the download to /razuna/WEB-INF/lib folder
    (remove the other h2-xxx.jar file!)
  4. Start Tomcat

We will release an updated Razuna 1.8.1 version containing this fix soon,
too.

10

Thank you so much for sharing this! I spent a week tweaking the mysql settings and even trying updated mysql drivers trying to figure this issue out. My issue was when I was doing batch uploads through the API with a custom java application I wrote, but it appears to have been the same problem. It never dawned on me that the H2 driver could have been a problem for a mysql setup! This seems to have fixed it and it is now running quite smoothly!