Thread: Database home page will not load whilst ZoneAlarm Pro is running


Permlink Replies: 16 - Pages: 2 [ 1 2 | Next ] - Last Post: Feb 13, 2007 1:00 AM Last Post By: Naglaa
cygnusx1

Posts: 5
Registered: 11/21/05
Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 22, 2005 12:41 PM
Click to report abuse...   Click to reply to this thread Reply
Hi,

I'm runnning win XP sp2 on a dell latitude d800 with zonealarm pro 6.0.667.000

I had a couple of glitches during install similar to those reported in other threads, but everything installed ok in the end and could connect via sqlplus, db instance verified as up and running.

Clicking on "Go to database start page" from the start menu, brought up logon page and if incorrect details entered it gives error message (as it should), but if you enter correct credentials it just comes back to logon page.

Turning off ZA Pro and repeating process, I can logon OK and get to home page. As far as I can see, I've allowed all oracle XE related services and apps access to trusted and internet zones.

Any ideas? I don't want to leave firewall disabled, and turning it on/off to use XE is impractical too.
Dietmar Aust

Posts: 1,745
Registered: 04/30/00
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 24, 2005 12:22 AM   in response to: cygnusx1 in response to: cygnusx1
Click to report abuse...   Click to reply to this thread Reply
Hi,

I haven't used zonealarm but I think it blocks the cookies. I have read on the internet that you can individually control the cookies with zone alarm pro.

Can you allow the cookies to your XE site and try again?

~Dietmar.
pviellieux

Posts: 4
Registered: 01/16/01
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 24, 2005 4:58 PM   in response to: Dietmar Aust in response to: Dietmar Aust
Click to report abuse...   Click to reply to this thread Reply
I have the same problem - keeps going to the login prompt if ZonaAlarm is running, works fine if I shut it down. I enabled cookies for the local site (127.0.0.1) but that didn't make a difference.

Paul
pviellieux

Posts: 4
Registered: 01/16/01
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 24, 2005 6:10 PM   in response to: cygnusx1 in response to: cygnusx1
Click to report abuse...   Click to reply to this thread Reply
BTW - The same thing happens after you create the sample application and run it - you keep getting bounced to the login if ZA is running, it works fine if you shut ZA down...
Dietmar Aust

Posts: 1,745
Registered: 04/30/00
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 25, 2005 1:21 AM   in response to: pviellieux in response to: pviellieux
Click to report abuse...   Click to reply to this thread Reply
Hi,

I have done some research and found a working solution (for me).

I have downloaded the latest version 6.1.737.000 (english version).

First I installed just the basic (free) version of ZoneAlarm, no problems there. XE worked just fine.

Then I upgraded to ZoneAlarm Pro and immediately I had the problems as described above.

The problem is definitely due to blocked cookies from localhost.
There are numerous posts on their support forum regarding this issue:
http://forum.zonelabs.org/zonelabs/search?q=cookie+localhost

It seems to be a bug in ZoneAlarm Pro. It identifies the cookies as 3rd party cookies and therefore blocks them. Adding 127.0.0.1, localhost or the local ip address to the site list (privacy tab) won't work either.

The only way I got this working was to set the following configuration options:
Privacy > Cookie Control => OFF
Privacy > Ad Blocking => OFF

Does this workaround work for you as well?

~Dietmar.
mtownsen

Posts: 785
Registered: 01/10/01
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 25, 2005 10:14 AM   in response to: Dietmar Aust in response to: Dietmar Aust
Click to report abuse...   Click to reply to this thread Reply
Great work Dietmar - thanks
cygnusx1

Posts: 5
Registered: 11/21/05
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 25, 2005 2:24 PM   in response to: Dietmar Aust in response to: Dietmar Aust
Click to report abuse...   Click to reply to this thread Reply
Dietmar - vielen danke!

That sorted it out.
Dietmar Aust

Posts: 1,745
Registered: 04/30/00
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 25, 2005 3:00 PM   in response to: cygnusx1 in response to: cygnusx1
Click to report abuse...   Click to reply to this thread Reply
Always glad to help :).

Enjoy the ride with XE! When it was first announced I could hardly sleep for a few days, I was totally excited.

~Dietmar.
pviellieux

Posts: 4
Registered: 01/16/01
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 25, 2005 3:34 PM   in response to: Dietmar Aust in response to: Dietmar Aust
Click to report abuse...   Click to reply to this thread Reply
Dietmar,

I am also running ZA 6.1.737 - while your solution does work, I don't se it as being any more viable or convenient than just shutting down ZA while I log onto XE. From the threads you pointed out, I think we all need to complain loudly to ZoneLabs to get them to fix this.
mtownsen

Posts: 785
Registered: 01/10/01
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 25, 2005 4:32 PM   in response to: pviellieux in response to: pviellieux
Click to report abuse...   Click to reply to this thread Reply
Maybe a better workaround may be to just use the real hostname or IP address in the URL. You could also edit the URL the icons are using to use the same value. Let me know if this works
Dietmar Aust

Posts: 1,745
Registered: 04/30/00
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 26, 2005 1:10 AM   in response to: mtownsen in response to: mtownsen
Click to report abuse...   Click to reply to this thread Reply
ZoneAlarm Workaround II

Mark, your suggestion worked out!

I changed the privacy settings back to Cookie Control: HIGH and Ad Blocking: HIGH.

Then I restarted the browser and accessed XE via
http://192.168.0.5:8080/htmldb  or
http://daust2.opal-consulting.de:8080/htmldb

Both worked (local ip address and fully qualified name)!

Only http://127.0.0.1 and http://localhost have problems.

Suprisingly, when I used 192.168.0.5 this ip address would get automatically added by ZoneAlarm to the list of exceptions for the cookie control (Privacy > Tab Site List).

Now we all should be happy camper once again :).

~Dietmar.

P.S.: But I am still suprised that ZoneLabs hasn't fixed the problem since it seems to be known for a year by now and many many people have problems with this (Zope, PHP, ...)
pviellieux

Posts: 4
Registered: 01/16/01
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 27, 2005 8:56 PM   in response to: Dietmar Aust in response to: Dietmar Aust
Click to report abuse...   Click to reply to this thread Reply
You're right, this does work a lot better - THANKS!

I have a similar problem with my Cisco VPN client - hangs on login. I have to stop ZA to login, then I can restart ZA. Has anyone come across a fix for this?
Dietmar Aust

Posts: 1,745
Registered: 04/30/00
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Nov 27, 2005 10:40 PM   in response to: pviellieux in response to: pviellieux
Click to report abuse...   Click to reply to this thread Reply
user470952

Posts: 1
Registered: 12/03/05
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Dec 3, 2005 12:37 PM   in response to: cygnusx1 in response to: cygnusx1
Click to report abuse...   Click to reply to this thread Reply
Thanks, that really worked.
Dietmar Aust

Posts: 1,745
Registered: 04/30/00
Re: Database home page will not load whilst ZoneAlarm Pro is running
Posted: Feb 11, 2006 2:52 PM   in response to: Dietmar Aust in response to: Dietmar Aust
Click to report abuse...   Click to reply to this thread Reply
In the current beta 3 there is a check whether cookies are enabled or not.
If they are not enabled, an error message is displayed.

This is good!!!

I haven't checked with ZoneAlarm pro yet but the problem should still persist since the default URL is http://127.0.0.1:8080/ which is (unfortunately) not recognized by ZoneAlarm to be the local machine.

At least this gives us a hint as to what we have to look for (i.e. cookies).

Using the url with the local hostname or the ip address directly should work as described earlier.

~Dietmar.
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums