You are here

[Solved] SQLite Database Browser update to 3.5.1 fails via platform update

7 posts / 0 new
Last post
Bruce Huber
Offline
Last seen: 4 years 7 months ago
Joined: 2013-01-21 20:29
[Solved] SQLite Database Browser update to 3.5.1 fails via platform update

====================================================
SOLVED: Mar. 25, 2015
See my "XP's Internet Explorer - no access to github as of Jan 5, 2015" message later in the thread below (Mar. 23).
====================================================
An FYI for the update of:
DB Browser for SQLite 3.5.1 Portable (formerly SQLite Database Browser)
::
Running PA Platform 12.0.5 on WinXP-64.
Normal PA application update process would find that SQLite Database Browser had an update available - but the download failed each time over four days.
The PA update error box gave a message that "there might be a proxy server issue or server access error".
I do not run a proxy server - and all other app updates downloaded and installed successfully during this time.
::
RESOLUTION: Finally went to PA website and downloaded the app's PAF.exe file manually and installed it via the PA GUI.
::
I don't know if the problem was an incorrect download link in the automated PA app update process ... but the link on the PA website appeared to be the same.

Wm ...
Offline
Last seen: 7 years 11 months ago
Joined: 2010-07-17 12:37
IIRC it is to do with PA

IIRC it is to do with PA using Win tools for the d/l. When you d/l yourself it is using your browsers mechanism. If you have your system nice and tight then it won't always work depending on where the file to be d/l'd is hosted

Wm

Bruce Huber
Offline
Last seen: 4 years 7 months ago
Joined: 2013-01-21 20:29
(Multiple redirects affect PA app updater?)

Thanks Wm! So it is probably related to the fact that there are multiple redirects.

PA app updater and website are both redirecting the download to github. I see in the web browser download dialog that the download has been redirected from github to:
"https://s3.amazonaws.com"

Based on your info, I would assume that PA's app update process cannot handle that second redirect.

John T. Haller
John T. Haller's picture
Online
Last seen: 35 min 40 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
Updater Works Fine

The updater works just fine as long as Windows' networking components are properly configured. I just installed the current release of SQLite Database Browser via the platform on my Windows 8.1 box without any issue.

Windows' built-in networking components are used by any apps that instantiate them as well as Internet Explorer. You can ensure they are working properly by attempting to download in IE. If IE fails, it's usually because of an improper proxy configuration (one is defined in Internet Options when it should not be or isn't defined when it should be) or some of the components are damaged (often by a utility "disabling" or "uninstalling" IE, which should never be done).

Sometimes, the impossible can become possible, if you're awesome!

Wm ...
Offline
Last seen: 7 years 11 months ago
Joined: 2010-07-17 12:37
Yes but not quite, if your

Yes but not quite, if your WinExplorer &c settings are tied down tight (I'm on WinXP so mine are very tight to avoid bad-stuff) then the redirection doesn't work at an OS and friends level. So PA's update asks for the redirect to follow and the native Win tools being used say, "no, I'm not allowed to do that".

Someone else will explain it better if I've got it very wrong

Wm

John T. Haller
John T. Haller's picture
Online
Last seen: 35 min 40 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
Incorrect Settings

If some variation of "tight" settings disables redirects, you've basically broken the ability for the internet components to work properly. So, my original point stands. Your internet components must be properly configured and working. If redirects are disabled, your internet components are configured incorrectly and most things that utilize them will fail. Every single app downloaded by the updater/app store involves at least one redirect.

Sometimes, the impossible can become possible, if you're awesome!

Bruce Huber
Offline
Last seen: 4 years 7 months ago
Joined: 2013-01-21 20:29
XP's Internet Explorer - no access to github as of Jan 5, 2015

--------------------------------------------------
John, thanks for the details on PA updates utilizing the same mechanisms as Internet Explorer. Tried the download straight from IE and that failed also on my XP system.

Which sent me on a google search - and I found this ...
=============================
Improving GitHub's SSL setup
https://github.com/blog/1937-improving-github-s-ssl-setup
::
December 23, 2014
by dbussink
::
To keep GitHub as secure as possible for every user, we will remove RC4 support in our SSL configuration on github.com and in the GitHub API on January 5th 2015.
RC4 has a number of cryptographic weaknesses that may be exploited, impacting the security of your data. More details about these vulnerabilities are listed in the current IETF draft.
If you are using Internet Explorer on Windows XP, you will no longer be able to access github.com once this change takes place. Windows XP only supports outdated SSL ciphers, is no longer supported by Microsoft, and contains a known critical security problem in its SSL implementation.
We strongly recommend that Windows XP users upgrade to a newer version of Windows. If this is not possible, you will need to use Chrome or Firefox to access GitHub on Windows XP. The git client available at git-scm.com still works on Windows XP.
=============================

So on my XP system, I will just have to manually download any PA updates that come from github.

Thanks!

Log in or register to post comments