Page 1 of 1

Windows7 Servoy+Sybase install Security issues

PostPosted: Sat May 22, 2010 11:50 am
by 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

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Mon May 24, 2010 10:55 am
by 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

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Mon May 24, 2010 1:39 pm
by Jan Aleman
We have hundreds of Windows 7 users. I personally use it too without problems. Is your only problem with Sybase SQL Anywhere?

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Mon May 24, 2010 2:06 pm
by 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

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Thu May 27, 2010 11:41 am
by 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 ?

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Thu May 27, 2010 12:16 pm
by 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

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Thu May 27, 2010 1:10 pm
by 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?

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Thu May 27, 2010 1:31 pm
by 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

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Thu May 27, 2010 1:58 pm
by 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?

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Thu May 27, 2010 2:50 pm
by 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

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Mon May 31, 2010 5:22 pm
by Tokajac

Re: Windows7 Servoy+Sybase install Security issues

PostPosted: Fri Jun 04, 2010 6:51 pm
by 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