Jump to content
TNG Community

SSL and importing Gedcom


KathieR

Recommended Posts

I recently added SSL to my Wordpress site.  

I have TNG running under the site.  I used the Kloosterman method for TNG integration.

Everything is working except the import.  When I try to import a gedcom file it just hangs, so I know that I need to change something, but I don't know what.

Any help would be appreciated.

Kathie

Link to comment
Share on other sites

In the admin section....

Setup —> General —> Site design and Definition

...have you changed your URL to start with https and not http ?

Not sure if that will fix it but it’s an easy first check.

Phil

Link to comment
Share on other sites

Are you importing from your desktop or straight from the gedcom folder?

The former has never worked for me - probably due to file size. Try using an ftp like Filezilla to upload your gedcom into the gedcom folder, and then import it by choosing it from the list.

Link to comment
Share on other sites

My experience is the same as fluffy82.  Always using FTP to upload the gedcom to the host gedcom folder, then pulling the file from there for the import.  I do it that way for local and remote host, ..has never failed.  Then SSL is taken out of picture.

Link to comment
Share on other sites

Since TNG can extract the .ged file from a .zip file, you can also zip your .ged file before FTPing to your host.  Might not make that much of a difference if you have the bandwidth but a 10MB ged file compresses to 2MB and therefore uploads quicker if you do not have the bandwidth.  Mine is currently 1/4th of what I had 6 years ago in Texas

Link to comment
Share on other sites

Sigh,

Thanks guys, but I have tried both uploading from the desktop and transferring it using FTP first.  Both get the same result - spinning wheel and it doesn't get past the first step.  So it must be something in the first piece of the puzzle.

BTW, I upload updates monthly, sometimes weekly, so I know everything was working fine on 24 Nov, before SSL installation, but not working now, after SSL installation. 

Is it maybe something I need to do in one of my wordpress files or settings?

Kathie

Edited by KathieR
Link to comment
Share on other sites

Another thing you can try: importing a gedcom always takes quite a long time, especially if it adds people to an existing (large) database. What I have been doing recently, is to empty the "people" and "children" tables in the database through phpMyAdmin before every import. This has reduced the import time from very long - sometimes freezing - to only between 60 and 90 seconds.

Link to comment
Share on other sites

3 hours ago, KathieR said:

BTW, I upload updates monthly, sometimes weekly, so I know everything was working fine on 24 Nov, before SSL installation, but not working now, after SSL installation

Kathie,

Is it possible your version of PHP changed within the last month?  or the PHP handler?  I know that during TNG 13 beta testing, I discovered that if I enabled PHP 7.4 using the FPM with OPcache that the import no longer showed any progress bar and just dumped the completed progress bar to the screen when it was done.  Changing it to use the old style counts would not help either since none of the Import Secondary process display progress counts.

On my hosting service I can select the PHP Handler, so if I change the PHP Handler to use the CGI handler then I can see the progress.  I am not Unix system expert since my expertise was the IBM z/OS operating system before I retired 16 years ago.

 

Link to comment
Share on other sites

Fluffy82,

Tried that.  It didn't import.  But it did restore from backup.  So that's probably tells me something.

Ken:

Yes, my version of PHP did change to 7.4.

From your post, I thought - great, I am just being impatient.  So I left it for 10 minutes.  That did not help, unfortunately, still no joy.

My hosting service does not allow me to change the PHP handler.

Kathe

Link to comment
Share on other sites

Robin Richmond

How big is your database (# of people)? How big is your Gedcom file?

Is the import giving your an error?  Have you tried the "Old Import" option?  It might have the same output caching problem, but it produces so much output that I would expect it to fill the buffers and display at least some of the progress report.

Does it add any content to the database?

 

Link to comment
Share on other sites

Robin Richmond
5 hours ago, fluffy82 said:

What I have been doing recently, is to empty the "people" and "children" tables in the database through phpMyAdmin before every import. This has reduced the import time from very long - sometimes freezing - to only between 60 and 90 seconds.

That's great, but ... (With me, there's always a "but", isn't there?) ... it's also curious, because, when you launch a full tree Gedcom Import, the Gedcom Import starts by clearing the tree's people, children, families, events, citations, sources, and repositories (that may be it). It shouldn't take TNG much more time to do that than phpMyAdmin takes, but, hey, if it helps, that's great.  I just wish that I understood why.

- Robin

 

Link to comment
Share on other sites

Robin,

I have 8,974 people in my online tree and 8,972 in my gedcom.  I cleared the tree, checked that there were no people, attempted the upload using the "old import".  After 10 minutes, I killed it and checked the tree - zero people.  So I restored from backup. 

So, it is not importing any content, and it is not giving me any errors.

Kathie

Link to comment
Share on other sites

Kathie,

Please check with your hosting service if they are using FPM with OPcache as the PHP handler.  If they are ask them if there is a way to revert back to using CGI as the handler

Link to comment
Share on other sites

Ken,

They are using the Litespeed web server with lsphp.  They did tell me how to turn off OPcashe on the PHP handler and I did that. 

It did not, however, make any difference to the import, unfortunately.

Kathie

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...