Studio 6.10.2 always generates update scripts to drop PASSWORD_ENCRYPTION from SEC_USER

Hi,

after switching back to 6.10.2, I have a big issue when I try to start my solution from inside studio 6.10.2:

I get a message that the database needs to be updates and when I go to the db manager, I find 2 update scripts:
1st to rename PASSWORD_ENCRYPTION and
2nd to dorp the renamed column.

And these are the facts:

  • The database does not have such a column
  • When I create it, then the changes are applied, but the next time, I get the same message and another set of update scripts was created.

I tried:

  • I dropped the database
  • removed the init and update folders from db directory
  • created the database from scratch.
    => A new database was created (without PASSWORD_ENCRYPTION column) and when I try to start it from inside Studio 6, it tells me, that the database must be upgraded…

So what did I mess up on my system regarding Studio 7 so that the new PASSWORD_ENCRYPTION column is now seen be Studio 6?

After moving back from Studio 7 to 6 on my linux system, I did the following steps:
a) removed the sources completly and got it from source control (with no Studio 7 ever doing any commits!)
b) removed the url for new CUBA IntelliJ
c) removed ~/.IntelliJIdea2018.3 folder to get rid of new CUBA plugin.
d) Installed old CUBA plugin to get the “IDE” feature available from inside Studio 6
e) dropped mysql database and created it with my own set of create scripts (based on a dump of a Studio 6 created database with additional data that is filled in for tests,)

When I ignore the Studio 6 message when starting tomcat, then tomcat starts without any complaints. But of course: I would like to get rid of this message.

Would be great if I could get assistance on this issue.

With kind regards,

Konrad

1 Like

Yes, I see this when I switch between version 6 and 7. I usually end up recreating the database. No idea what causes it though.

Hi Ray,

so for you creating the database again helped? So you just did a “Run” -> “Create database” in Studio 6?

This didn’t help for me. But it must be a studio item, because when starting tomcat, it does not complain about the database.

And I even tried to let him recreate all scripts. So I removed all contents of modules/core/db/ so Studio generated all files again together with dropping / recreating an empty mysql database where Studio could create everything from scratch.

Because I think it must be the studio, I tried to remove all settings (~/.haulmont) and let him recreate the whole configuration which didn’t change anything.

Maybe something was broken when I had Studio 6 and IntelliJ with the new CUBA plugin up and running? But I didn’t open the solution with IntelliJ if I remember correctly (but it was up and running and Studio 6 also talks to the Plugin …).

With kind regard,

Konrad

Yes, I ran it from the gradle script, though that shouldn’t make a difference. It looks as though there was a system change to create these fields but going between version 6 and 7 takes the update out of sync. I would have reported it, but I haven’t been able to get a consistent bead on why it’s happening, so I thought it was something I did. However, since you’re seeing it too …

Has anyone else seen this?

Could someone from Cuba weigh in and explain why this field gets added/removed?