Error updating dev site

SteveX
@ultrajam
8 years ago
2,584 posts

I have a site on localhost which I have used for getting updates locally.

I hadn't subscribed to the beta channel so before I started updating to JR6 it was running 5.3.6

Very soon after starting to update the core I got a white page error, with this in the log.

Quote:
[SteveX] Query Error: Data too long for column 'log_text' at row 1

[SteveX] jrCore_load_url: https://www.jamroom.net/networkmarket/browse?type=module&c[] =stable&c[] =imWcTD1VKBWpFXLY&c[] =DXn4xwovnFgxsxov returned code 0 - error #60 (SSL certificate problem: unable to get local issuer certificate)

The system now shows as running 6.0.0, but I can't access the marketplace update page without the error so I can't update the modules and skins.

I have run the integrity check with repair modules checked.

If I visit /marketplace/browse I get a within page error:

Quote: An error was encountered trying to communicate with the Active Marketplace
make sure the Marketplace URL is set correctly in Tools -> Marketplace Systems.

I tried changing to not use ssl, but still the same result.

The rest of the site seems to be working normally as far as I can see.

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
updated by @ultrajam: 03/19/17 02:03:27PM

SteveX
@ultrajam
8 years ago
2,584 posts

Trying another local site, this one not on ssl, I just get the following error:

Quote: Unable to download update from update server (2)

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

@brian
8 years ago
10,148 posts

HI Steve -

Have just updated a site and am seeing no issues. Could there be a network issues between your site and the JR Marketplace?

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

SteveX
@ultrajam
8 years ago
2,584 posts

Hi Brian

It looks that way, I can't update any site locally from either work or home but hosted sites are fine.

I'll look further tomorrow.

Thanks!

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

@brian
8 years ago
10,148 posts

Thanks Steve - let us know.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

SteveX
@ultrajam
8 years ago
2,584 posts

I haven't been able to fix this.

All localhost to jamroom.net communication has stopped working. I don't think it can be a network issue as I have tried from work, from home and through a vpn from both.

I have set up some new local sites (ssl and non-ssl), but they won't communicate either. The sites pass the system check for marketplace, but can't install or update modules.

I'm at a bit of a loss as to what to try next, any ideas would be appreciated.

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

@brian
8 years ago
10,148 posts

Hi Steve - is your dev site on macOS?

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

SteveX
@ultrajam
8 years ago
2,584 posts

It is, but it is within an ampps installation.

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

@brian
8 years ago
10,148 posts

SteveX:
It is, but it is within an ampps installation.

Since Mac OS X El Capitan, they've changed how SSL certificates are accepted/required in the cURL that comes with the OS. JR6 and newer can handle it, but if you are updating a JR5 system you will need to update the jrCore_load_url() function in jrCore/lib/util.php.

Change this:

    if (version_compare(PHP_VERSION, '5.5.0') >= 0) {
        $_opts[CURLOPT_SAFE_UPLOAD] = true;
    }
    // Check for HTTP Basic Authentication
    if (!is_null($username) && !is_null($password)) {
        $_opts[CURLOPT_USERPWD] = $username . ':' . $password;
    }

To this:

    if (!stristr(' ' . PHP_OS, 'darwin')) {
        $_opts[CURLOPT_SSL_VERIFYHOST] = false;
        $_opts[CURLOPT_SSL_VERIFYPEER] = false;
    }
    if (version_compare(PHP_VERSION, '5.5.0') >= 0) {
        $_opts[CURLOPT_SAFE_UPLOAD] = true;
    }
    // Check for HTTP Basic Authentication
    if (!is_null($username) && !is_null($password)) {
        $_opts[CURLOPT_USERPWD] = $username . ':' . $password;
    }

And let me know if that works.

Also - you can try setting the Marketplace URL to NON SSL (if it is set to SSL) in Marketplace -> Tools -> Marketplace Systems.

Let me know if that helps.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

SteveX
@ultrajam
8 years ago
2,584 posts

Thanks Brian, I will try that on the JR5 sites.

But I am getting the same results with freshly installed JR6 sites as well.

On a non-ssl site if I change the marketplace url to http I can communicate wioth the marketplace enough to list modules and up[dates, but if I then try to install or update I get the error at that point. If I use https the site won't list modules or updates at all.

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

@brian
8 years ago
10,148 posts

SteveX:
Thanks Brian, I will try that on the JR5 sites.

But I am getting the same results with freshly installed JR6 sites as well.

On a non-ssl site if I change the marketplace url to http I can communicate wioth the marketplace enough to list modules and up[dates, but if I then try to install or update I get the error at that point. If I use https the site won't list modules or updates at all.

Hmm... that is weird. I would suspect something in the ampps install? Are there any settings you can see that relate to SSL?

I develop on Mac OS and have a ton of local dev sites and am not seeing this issue - however I don't use ampps - I just use the built in Apache and add PHP versions as needed.

I think the reason why you can list the marketplace via NON-SSL is that that works - however, when jamroom.net responds with the URL for you to download the update it, it is going to be an https (SSL) URL since we're running SSL here.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

SteveX
@ultrajam
8 years ago
2,584 posts

Ampps has an ssl checkbox when you create a new local domain. Check the box it will be set up for ssl, don't check it and it won't. But I haven't had any success either way.

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

SteveX
@ultrajam
8 years ago
2,584 posts

I haven't updated ampps since the macOS sierra update. I'll try that at some point soon.

--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)

Error updating dev site

Tags