Lightroom Wordpress Sync issue?

July 18, 2017 9:10 AM

I am having issues with a Lightroom plug-in that allows direct uploads to a Wordpress blog called WP/LR sync. (https://wordpress.org/plugins/wplr-sync/) I am getting this error when I attempt an upload: “connection to your website works but got an error from WP. Please check your PHP logs on server, your WP/LR logs on your computer and the FAQ. Also make sure the plug in is enabled on WP side.”

The developer is small one man operation and his response to the issue is:

“it seems images up to a certain size will publish, yet I have the “limit file size” set to 2k for all uploads, so I need help in understanding what I can do to get my larger images to publish properly?”

I did this and it worked for a few days, but now it is not publishing again.

I think it is involved with confusion over the upload limits set by WordPress, but I have been through this on other blogs on my grid and the global php.ini files has these limits set

memory_limit = 99M
max_execution_time = 300
upload_max_filesize = 64M
post_max_size = 64M

Which is far more than the size of the files I am trying to upload, and like I mentioned, it worked for a few days?

I looked at the server logs and see nothing that looks remiss, but I am not a DB person, just a guy trying to get his photoblog up. The server logs have this right after I attempt to publish from Lightroom:

64.13.192.113 – – [17/Jul/2017:18:56:43 -0700] “POST /henrycline.com/wp-cron.php?doing_wp_cron=1500343003.0825419425964355468750 HTTP/1.1” 200 20 “http://henrycline.com/wp-cron.php?doing_wp_cron=1500343003.0825419425964355468750” “WordPress/4.8; http://henrycline.com”
192.0.84.33 – – [17/Jul/2017:18:56:42 -0700] “HEAD /henrycline.com/ HTTP/1.1” 200 – “-” “jetmon/1.0 (Jetpack Site Uptime Monitor by WordPress.com)”
64.13.192.113 – – [17/Jul/2017:18:59:25 -0700] “POST /henrycline.com/wp-cron.php?doing_wp_cron=1500343165.2019670009613037109375 HTTP/1.1” 200 20 “http://henrycline.com/wp-cron.php?doing_wp_cron=1500343165.2019670009613037109375” “WordPress/4.8; http://henrycline.com”
164.132.161.25 – – [17/Jul/2017:18:59:24 -0700] “GET /henrycline.com/author/admin/feed/ HTTP/1.1” 200 2679 “-” “Mozilla/5.0 (compatible; AhrefsBot/5.2; +http://ahrefs.com/robot/)”

I have 5 blogs all running on a grid server through Media Temple, they are great, but have no support for plug in issues and such. So there is no recourse there.

I have contacted the plug-in developer again to see if they can be of help, but I also wondered what else can I do to try and trouble shoot this issue myself?

The only other hitch is that I have Sucuri monitor installed on my blgs (after a brute force attack a few years ago) and for some reason when ever I install a plug-in on this particular blog I get a error briefly that reads:

Warning: mysql_real_escape_string(): No such file or directory in infs/c01/h02/mnt/8839/domains/henrycline.comMtml/wp-content/plugins/sucuri-wp-plugin/sucuri_hooks.php on line 244
Warning: mysql_real_escape_string(): A link to the server could not be established in infs/c01/h02/mnt/8839/domains/henrycline.com/html/wp-content/pluginsisucuri-wp-plugin/sucuri_hooks.php on line 244
Warning: Cannot modify header information - headers already sent by (output started at infs/c01/h02/mnt/8839/domains/henrycline.com/html/wp-content/plugins/sucuri-wp-plugin/sucuri_hooks.php:244) in infs/c01/h02/mnt/8839/domains/henrycline.com/html/wp-includes/pluggable.php on line 1210
Warning: Cannot modify header information - headers already sent by (output started at infs/c01/h02/mnt/8839/domains/henrycline.com/html/wp-content/plugins/sucuri-wp-pluginisucuri_hooks.php:244) in infs/c01/h02/mnt/8839/domains/henrycline.com/html/wp-includes/pluggable.php on line 1210

I would greatly appreciate any guidance on how to proceed solving this issue.

Henry

posted by silsurf to Computers & Internet (10 answers total)

Have you tried disabling Jetpack? (not a longtime solution, but a good first step in debugging)

If that doesn't work, slowly continue to disable plugins until the plugin in question behaves.
posted by dreamling at 10:30 AM on July 18, 2017

Can you access the error logs?
posted by czytm at 10:54 AM on July 18, 2017

Response by poster: I can access the error logs. I thought I added any relevant info? This is the last lines of the log just after attempting to publish from Lightroom.

64.13.192.113 – – [17/Jul/2017:18:56:43 -0700] “POST /henrycline.com/wp-cron.php?doing_wp_cron=1500343003.0825419425964355468750 HTTP/1.1” 200 20 “http://henrycline.com/wp-cron.php?doing_wp_cron=1500343003.0825419425964355468750” “WordPress/4.8; http://henrycline.com”
192.0.84.33 – – [17/Jul/2017:18:56:42 -0700] “HEAD /henrycline.com/ HTTP/1.1” 200 – “-” “jetmon/1.0 (Jetpack Site Uptime Monitor by WordPress.com)”
64.13.192.113 – – [17/Jul/2017:18:59:25 -0700] “POST /henrycline.com/wp-cron.php?doing_wp_cron=1500343165.2019670009613037109375 HTTP/1.1” 200 20 “http://henrycline.com/wp-cron.php?doing_wp_cron=1500343165.2019670009613037109375” “WordPress/4.8; http://henrycline.com”
164.132.161.25 – – [17/Jul/2017:18:59:24 -0700] “GET /henrycline.com/author/admin/feed/ HTTP/1.1” 200 2679 “-” “Mozilla/5.0 (compatible; AhrefsBot/5.2; +http://ahrefs.com/robot/)”
posted by silsurf at 10:57 AM on July 18, 2017

You may also find additional info by using the WP command line tool. MT has it enabled on all grid servers.

https://mediatemple.net/community/products/grid/204405704/using-wp-cli

wp doctor check --all will give a look to everything
wp cron event list will tell you when automated processes are running
posted by dreamling at 11:13 AM on July 18, 2017

Sorry, to clarify, those look like access logs to me. My experience is with a separate error log located somewhere like:
/var/log/httpd/
or
/var/log/apache2/

with filenames like error.log or error_log
posted by czytm at 1:31 PM on July 18, 2017

It's possible you don't have error logging enabled, I googled Media Temple error logs:
https://mediatemple.net/community/products/grid/204403804/where-are-the-access_log-and-error_log-files-for-my-server

And make sure you toggle "grid server" if that's what you're using.
posted by czytm at 1:34 PM on July 18, 2017

Response by poster: The error log is almost a full gigabyte, jeez. its one file that has errors for seven sites going back to May 2015. It bit intense.

Here are some errors from the right site, but they dont look any different than the tens of thousands of other errors?

Mon Jul 17 22:29:06 2017] [error] [client 103.240.122.119] ModSecurity: Warning. Match of "rx ^POST$" against "REQUEST_METHOD" required. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "9"] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cokANwBQAACfsPnEAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Warning. Match of "rx ^POST$" against "REQUEST_METHOD" required. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "14"] [hostname "henrycline.com"] [uri "/gs-bin/php-stable/wp-login.php"] [unique_id "WW2cokANwBQAACfsPnEAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Warning. Operator EQ matched 0 at REQUEST_HEADERS. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "10"] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cpEANwBQAACfsPnIAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Access denied with code 401 (phase 2). Operator GT matched 0 at USER:bf_block. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "20"] [id "9999001"] [msg "ip address blocked for 5 minutes, more than 15 login attempts in 3 minutes."] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cpEANwBQAACfsPnIAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Warning. Match of "rx ^POST$" against "REQUEST_METHOD" required. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "9"] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cpEANwBQAACfsPnMAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Access denied with code 401 (phase 2). Operator GT matched 0 at USER:bf_block. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "20"] [id "9999001"] [msg "ip address blocked for 5 minutes, more than 15 login attempts in 3 minutes."] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cpEANwBQAACfsPnMAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Warning. Match of "rx ^POST$" against "REQUEST_METHOD" required. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "14"] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cpEANwBQAACfsPnMAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Warning. Operator EQ matched 0 at REQUEST_HEADERS. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "10"] [hostname "henrycline.com"] [uri "/wp-login.php"] [unique_id "WW2cpEANwBQAACfsPnQAAABJ"]
[Mon Jul 17 22:29:08 2017] [error] [client 103.240.122.119] ModSecurity: Access denied with code 401 (phase 2). Operator GT matched 0 at USER:bf_block. [file "/etc/apache2/mod_security/custom/wpbrute.conf"] [line "20"] [id "9999001"] [msg "ip address blocked for 5 minutes, more than 15 login attempts in 3 minutes."] [hostname "henrycline.com"] [uri "/wp-
posted by silsurf at 4:04 PM on July 18, 2017

Response by poster: I didnt do anything and now it is working again??
posted by silsurf at 5:34 PM on July 18, 2017

Response by poster: except for the last photo, it seems there is something about certain photos that the publishing plugin does not like, I will go back to the developer and see if they can be of any help
posted by silsurf at 5:40 PM on July 18, 2017

If you get in touch with the dev, you'll have to find the relevant errors from the log... you can probably exclude any error/warning from ModSecurity, especially w/ uri /wp-login.php.

I assume they would be PHP errors and lines would start with something like "PHP Fatal Error:" or "PHP Parse error:"
posted by czytm at 6:00 AM on July 19, 2017