solution protection

Anyway to remove the solution protection in Servoy?
(without the password)

It’s asking for a password,
(when I export the solution)
but I’m 100% sure I never set one!

Alex

Mac OSX 10.4
Servoy 3.1.7

I did recently
rename
the solution.
Would that cause a problem?

Hi Alex,

Renaming a solution will not add a password to a solution.
Do you use any protected modules in that solution?

Might be protected modules, I’ll check it out.
Are modules the same as plug-ins?
I have some of those.

I did load a backup from before the name change,
and the password protection is not set.

Or maybe the backup restore in MySQL
removes the password?

This bug reproduces sometimes. The easiest way to reproduce it is to create a new solution and save it without creating any form. Next time you try to open the solution you’re requested a password, even though no password has ever set.

Thanks, I’m sure renaming the solution caused the problem.

otaku.com:
Might be protected modules, I’ll check it out.
Are modules the same as plug-ins?
I have some of those.

Modules are solutions that are loaded into other solutions. You can see that in the Solution Settings dialog (see menu bar) of the main solution.

otaku.com:
I did load a backup from before the name change,
and the password protection is not set.

Or maybe the backup restore in MySQL
removes the password?

A restore won’t remove any passwords. The only way to remove a password that you have lost is to send the solution to Servoy.
Anyway, you have your solution open again.

If you have time though could you try to reproduce the problem by renaming it again? (keep your MySQL backup handy ;) )

I’ll try to recreate the problem.

In 3.1.7
and
3.5.2

Can’t re-produce the problem.

I export the release from the backup
and import as a
Clean Import

All okay.
Then rename the release.
All okay.
No password is set.

Oh, man - unfortunately I haven’t backed up my last round of work and can’t just re-import. My situation happened like this:

  1. Local version of developer (3.5.2) crashed while connected to remote data and repository DBs.
  2. Suddenly the solution I was working on fine before now requests a password to open the editor or export.

So I’ve got to actually send my solution to Servoy for them to un-protect it? But how do I do that if I need the password to even export the solution to be sent?

Can you send the repository database to them?

Sure - who do I send it to?

And any idea how this happened in the first place? We have had some strange bugs using a local Developer instance with connections to remote data and repository DBs, but thought it was a bad internet connection on the server. So now we’ve got a new server with a good connection - but I’m worried this solution protection bug might still be related to crashes during remote development like this.

(Btw, I’m the same post person as before - forum made me re-register after changing email address…)

Have you done something/anything with the database directly?

I personally have not heard about such an event…

I’ve dumped the DB to move it between servers, and I like to look at my MySQL client during development - but I haven’t touched any records (I know Servoy doesn’t like that.)

This is my first time using a high-level tool like Servoy for DB application development. Although I recognize and appreciate the ‘rapid’ aspect, I can’t imagine a situation using PHP, for example, where my work would be completely halted and I had to send a DB dump to someone so they could pick out a password based on patterns only they know about.

Yes, I have a backup, but it’s 10 work-hours old.

I’ve dumped the DB to move it between servers, and I like to look at my MySQL client during development - but I haven’t touched any records (I know Servoy doesn’t like that.)

Could have caused it :?:

Really I can not imagine this happening just like that. At lease I have never heard of it…

Is there any documentation on how the repository works? For example, I found the following data in the ‘servoy_root_elements’ table, and would like to know how it works: (7779,‘070e3a39-8465-44ad-92a0-965a77b9c2c5’,‘FRAH_GP’,43,2,2,1,140). Maybe one of those numbers has to do with solution protection? I know editing the repository is not recommended - but I have no choice at this point - I can’t edit my solution.

No, there is no documentation.

Not only is editing not recommended it is likely that it leads to nothing.

But again, why don’t you send the db to Servoy? They should be able to help you…

I did send my DB to Servoy. So I have to sit and twiddle my thumbs while I wait for their reply. I guess that’s what you get for using closed-source development tools.

So I have to sit and twiddle my thumbs while I wait for their reply. I guess that's what you get for using closed-source development tools.
```Wow, that is sooo scinical.

BTW, not to start a discussion about open/closed source, but I have found myself in a couple of open source environments NEVER getting an answer to ANY more advanced question/issue raised.
Servoy DOES reply and there is at least somebody you can turn to and ask for priority.