Windows7 Servoy+Sybase install Security issues

Release notes for Servoy betas

Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Sat May 22, 2010 11:50 am

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
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Mon May 24, 2010 10:55 am

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
Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby Jan Aleman » Mon May 24, 2010 1:39 pm

We have hundreds of Windows 7 users. I personally use it too without problems. Is your only problem with Sybase SQL Anywhere?
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Mon May 24, 2010 2:06 pm

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
Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby jcompagner » Thu May 27, 2010 11:41 am

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 ?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8454
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Thu May 27, 2010 12:16 pm

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
Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby jcompagner » Thu May 27, 2010 1:10 pm

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?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8454
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Thu May 27, 2010 1:31 pm

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
Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby jcompagner » Thu May 27, 2010 1:58 pm

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?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8454
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Thu May 27, 2010 2:50 pm

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
Attachments
taskMngr.jpg
taskMngr.jpg (199.12 KiB) Viewed 11712 times
Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Mon May 31, 2010 5:22 pm

Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm

Re: Windows7 Servoy+Sybase install Security issues

Postby Tokajac » Fri Jun 04, 2010 6:51 pm

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
Tokajac
 
Posts: 92
Joined: Sun Jan 03, 2010 10:21 pm


Return to Latest Releases

Who is online

Users browsing this forum: No registered users and 2 guests

cron