Accuraty

I was able to get around this same problem by increasing the speed of the INSERTs in to ip2nation, there are 65,000+ inserts and many hosts do not have MySQL setup for performance and/or have the timeout on the PHP execution process short enough that only 10,000 or so records get inserted/committed before timing out.

So, use phpMyAdmin, Adminer, or MySQL WorkBench, find the SQL scripts and run them by hand. For the ip2nation one, you need to add some SQL to turn off checks, commits… this dramatically increases the speed of the query.

The first 3 lines and last 3 lines are what you are adding, you are wrapping all the INSERTs in commands to turn off unnecessary features that are slowing things down.

SET autocommit=0;
SET unique_checks=0;
SET foreign_key_checks=0;

INSERT INTO ip2nation (ip, country) VALUES(3332724736, 'pm');
INSERT INTO ip2nation (ip, country) VALUES(3332726783, 'ca');
... 60,000+ similar lines ...
INSERT INTO ip2nation (ip, country) VALUES(1314357247, 'uk');

SET foreign_key_checks=1;
SET unique_checks=1;
COMMIT;

If you want to read up on the commands/settings, go here
https://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-bulk-data-loading.html

• This reply was modified 6 years, 5 months ago by Accuraty.

We got it working very well using NinjaForms + the Salesforce add-on module instead of Brilliant.
https://ninjaforms.com/docs/salesforce-crm/

I am truly surprised that “Refresh active page” means what I described above. But yes, you are right, it does work as expected and needed, thank you.

Please – maybe – consider changing the wording so it is more obvious what “Refresh active page” does or at least add some on-page help, tooltips, or easy to find in-context docs that would better explain what that feature is doing and what the expected or possible results are. Thanks again – Jeremy

• This reply was modified 7 years, 3 months ago by Accuraty.

I am so sorry, after 2+ hours logged work, the client deleted the module instead of testing it like I had requested. I have no idea and no conclusion to this. I appreciate your help!

On the server I am able to browser to https://wordpress.backup-technology.com/ without any browser warnings about the cert.

I downloaded the PEM and added the setting/path/file to php.ini. IIS7 displays it, so it looks like everything should be working. I will have the client test it. Thanks!

The server is Windows Server 2008 R2. All Windows Updates including optional and are in place rebooted, etc. “Give me updates for Microsoft products and check for new…” is also checked. There are no hidden updates. I have also read this and verify that The Update Root Certificates feature is on.
https://technet.microsoft.com/en-us/library/cc771121(WS.10).aspx

Any additional advice on how I can pinpoint the cert on my server that is not getting updated?

I have a WordPress site where this is happening, but we are hosted on Windows/IIS7/etc. Can I get an overview of the issue and how it is being fixed in a way that I can apply the logic to my hosting environment? Are we simply saying that the plugin developer is using a self-signed cert and I need to get my server’s cert store to consider their stuff valid?