SourceForge has been redesigned. Learn more.
Close

#1032 Update Check Fails - Access is Denied for release.xml

3.3.0
open
5
2015-11-05
2012-06-25
AnySupport
No

I'm using 3.3.0 on Windows 7 (x64). Every time I open the program, I get a popup that updates are available, but then when I ask it to download them, it'll fail. When I use the Update Manager the Check option fails. I've not changed any of these settings since installing the software.
I apologize if this is something specific to me and not a bug, but I don't know what's wrong here.
Thank you!

Update Manager Settings:
Host: sourceforge.net Port: 80 Path: projects/squirrel-sql/files/updates Channel: STABLE
URL: http://sourceforge.net:80/projects/squirrel-sql/files/updates/stable/release.xml
TEST CONNECTION ERROR: Unable to download release.xml from the specified location
Stack Trace:
java.io.IOException: Access is denied
at java.io.WinNTFileSystem.createFileExclusively(Native Method)
at java.io.File.createNewFile(Unknown Source)
at net.sourceforge.squirrel_sql.fw.util.FileWrapperImpl.createNewFile(FileWrapperImpl.java:351)
at net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.copyBytesToFile(IOUtilitiesImpl.java:194)
at net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:338)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:875)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1055)
at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:204)
at net.sourceforge.squirrel_sql.client.preferences.UpdatePreferencesPanel$TestConnectionButtonListener.actionPerformed(UpdatePreferencesPanel.java:655)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Discussion

  • Rob Manning

    Rob Manning - 2012-06-25

    The problem is that the location under which you installed SQuirreL does not permit your user account to write files to. This location is where SQuirreL expects to download updates to and to modify the file "release.xml" which describes the release that is currently installed. You may need to grant write access to whevever SQuirreL was installed. Alternatively, you could attempt to launch SQuirreL as a privileged user to allow the update process to succeed.

    Rob

     
  • Rob Manning

    Rob Manning - 2012-06-25

    Alternatively, you might consider installing to a "non-standard" location (for example, c:\squirrel-sql\) so that Windows doesn't require authentication each time you intend to update SQuirreL. Sorry if this breaks some sort of perceived security benefit provided by Windows. If there is a better way that other open-source Java apps use to integrate with Windows Vista/7/8, please mention the app by name so we could look at it.

    Rob

     
  • AnySupport

    AnySupport - 2012-06-26

    Ah, very strange as I thought I already had administration rights to these folders so I thought the access was for the remote folder. I gave myself full rights to the full SQuirrel install folder and that seems to have worked just fine. Thank you for the quick help!

     
  • Rob Manning

    Rob Manning - 2012-06-27

    Really no trouble at all. Truly sorry that the Windows experience is hampered by our collective lack of knowledge about installing and maintaining Java apps on recent Windows releases. As I said before : any insight that can be provided regarding the "proper" way for Java apps to integrate with Windows security would be greatly appreciated. In any case glad to hear you were able to work around the problem.

    Rob

     
  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    Anonymous

    Anonymous - 2012-09-13

    Yes, it was such a pain to install on Window 7-64 into "C:\Program Files (x86)\squirrel-sql-3.4.0" using an 'as admin' command prompt. Windows install should work more smoothly. Users are not all JAVA developers. I should have know the pain would not end there. Forcing the directory to 'all' for 'users' as admin fixed the error.

    However, the dialog box message was junk. A file write open access problem should not be 'connection failed' on the dialog box. Not all users are JAVA developers.

     
    Last edit: Anonymous 2017-05-22
  • Saugata Guha

    Saugata Guha - 2015-10-15

    I have similar issue, but it happens earlier, when it is trying to get the release.xml file, from the URL.
    The exception is as follows.
    My installation is Squirrel version 3.5.0 on Linux, CentOS release 6.4 (Final)
    This happens when I do "Test Connection", and when the Error dialog pops up, I copied the stack trace.
    When I try to put the URL in the web browser, it takes me to the following page.
    https://sourceforge.net/projects/squirrel-sql/files/
    and in firefox it puts up a red dialog on the side, saying it did not find the URL.
    Looks like the release.xml URL changed.

    java.io.FileNotFoundException: Failed to download file from url (http://sourceforge.net/projects/squirrel-sql/files/updates/stable/release.xml): HTTP Response Code=404
    at net.sourceforge.squirrel_sql.fw.util.IOUtilitiesImpl.downloadHttpFile(IOUtilitiesImpl.java:327)
    at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadHttpUpdateFile(UpdateUtilImpl.java:875)
    at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentReleaseHttp(UpdateUtilImpl.java:1055)
    at net.sourceforge.squirrel_sql.client.update.UpdateUtilImpl.downloadCurrentRelease(UpdateUtilImpl.java:204)
    at net.sourceforge.squirrel_sql.client.preferences.UpdatePreferencesPanel$TestConnectionButtonListener.actionPerformed(UpdatePreferencesPanel.java:666)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    at java.awt.Component.processMouseEvent(Component.java:6505)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
    at java.awt.Component.processEvent(Component.java:6270)
    at java.awt.Container.processEvent(Container.java:2229)
    at java.awt.Component.dispatchEventImpl(Component.java:4861)
    at java.awt.Container.dispatchEventImpl(Container.java:2287)
    at java.awt.Component.dispatchEvent(Component.java:4687)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
    at java.awt.Container.dispatchEventImpl(Container.java:2273)
    at java.awt.Window.dispatchEventImpl(Window.java:2719)
    at java.awt.Component.dispatchEvent(Component.java:4687)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
    at java.awt.EventQueue.access$200(EventQueue.java:103)
    at java.awt.EventQueue$3.run(EventQueue.java:694)
    at java.awt.EventQueue$3.run(EventQueue.java:692)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
    at java.awt.EventQueue$4.run(EventQueue.java:708)
    at java.awt.EventQueue$4.run(EventQueue.java:706)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
    at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

     
  • Hans-Georg Michna

    Exact same server error 404 here, but it is already three weeks later. Perhaps we should file a new defect.

     
    Last edit: Hans-Georg Michna 2015-11-05

Log in to post a comment.