Windows7 Servoy+Sybase install Security issues

[Tokajac]

Hello,

I've tried to install Servoy 5.1.3. including Sybase on Windows7:
After the wizard, i run developer/servoy.exe;
The Windows7 firewall asked me whether i allow access to the public network, i clicked Allow Access.
Servoy freezes than with progress bar on ~33%
I tried to install it in:
c:\Servoy, c:\Program Files\Servoy, c:\Users\MyUsername\Documents\Servoy, e:\Projects\Servoy

This is related to Win7 security, i suppose. How to setup OS for comfortable usage of Servoy with Sybase? Like it runs fine when i uncheck Database on installation wizard, because not all projects require Sybase.

Regards

[Tokajac]

Hello,

Does this mean that Servoy+Sybase can't be used on Win7 yet? Does anybody have experience with Win7+Servoy?
Do i have to reinstall back to WinXP then...?

Regards

[Jan Aleman]

We have hundreds of Windows 7 users. I personally use it too without problems. Is your only problem with Sybase SQL Anywhere?

[Tokajac]

Thank you for the reply!

Yes, only with Sybase.
I described the procedure above.
Checking the Win7 security settings... If you have any hints, please let me know

Regards

[jcompagner]

i use win7 (64 bit) also just without any problem

But if you disable (comment, place # in front of it, or remove that line) of the nativelauncher starter in the servoy.properties then it works fine?
(nativeStartupLauncher=%%user.dir%%\\sybase_db\\dbspawn.exe|%%user.dir%%\\sybase_db\\dbsrv11.exe|@sybase_db\\sybase.config\#Path\=%%Path%%;sybase_db;sybase_db\\scripts)

Because i think you will get a security dialog anyway because we open up a http port (8080) for the webclient, i think windows will also ask for permissions because of that.

When it hangs is the 8080 port already open? Can you go to http://localhost:8080 ?

[Tokajac]

When i run without changing servoy.properties, i get hanging startup screen (no changes, waited ~20mins) and Unable to connect via browser http://localhost:8080 during that period; in Task Manager servoy.exe takes 0 CPU, dbsrv11.exe takes 91 CPU;
If i End Process dbsrv11.exe at any moment the Servoy starts up regularly but without 'lightening' in the SysTray; able to connect via http://localhost:8080 now.

If in servoy.properties i commented out line

Code: Select all

nativeStartupLauncher=%%user.dir%%\\sybase_db\\dbspawn.exe|%%user.dir%%\\sybase_db\\dbsrv11.exe|@sybase_db\\sybase.config\#Path\=%%Path%%;sybase_db;sybase_db\\scripts


Servoy starts regularly;

Laptop configuration: Dell/Intel Core 2 Duo/4GB RAM/Win7 32bit
Seems that we pointed out that Sybase dbsrv11.exe has trouble to start. Why? How and where to set permissions properly? Only security dialog appeared on initial run when i clicked Allow Access (mentioned above)

Regards

[jcompagner]

so if you just use this command line command in the application_server dir:

sybase_db\dbsrv11.exe @sybase_db\sybase.config

You have the same problem?

Is this a clean sybase install? So no big databases?

[Tokajac]

Yes, seems to be the same problem:
When i run in command line the command that you suggested the 'lightening' appear in the SysTray and in TaskManager the dbsrv11.exe is ~91 CPU again;
After this when i start servoy.exe it hangs again; I commented out nativeStartupLauncher for this scenario;

default databases:
application_server/database/
bug_db.db, example.db, log_data.db, pdf_forms.db, servoy_repository.db, udm.db, user_data.db

All is happening with latest downloaded Servoy install 5.1.3 for Windows

Regards

[jcompagner]

i am out of idea's it really seems to be some sybase issue here.
And it is not that sybase is waiting for something, it is really crunching because the cpu usage is above 90%...

Maybe you could try sybase 10?

[Tokajac]

Thank you for your effort! If you get anything new on your mind maybe, share please

Is there any app on my computer that might interfere dbsrv11.exe? I've installed fresh copy of Win7 not so long ago

Regards

[Tokajac]

How to use EBFs for Servoy 5.1.3's Sybase from
http://downloads.sybase.com
?
Please check posts on:
http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-307&group=sybase.public.sqlanywhere.web

Regards

[Tokajac]

Seems to work now!

Check installation-flow below
1)
Installed Servoy 5.1.3 to
c:\Users\MyUsername\Documents\Servoy\

2)
Installed SQL Anywhere 11.0.1 Developer Edition downloaded from
http://www.sybase.com/detail?id=1016644
to
c:\Program Files\SQL Anywhere 11\
and copied content from c:\Program Files\SQL Anywhere 11\Bin32\
to
c:\Users\MyUsername\Documents\Servoy\application_server\sybase_db\
with Overwrite existing files


Regards