Can’t Connect to External Databases

While the feature previous worked, I’ve been unable to get it to connect to external databases since a plugin update earlier this year.

Would love to get this things working properly, otherwise I’ll probably have to find another logging solution that’s a little less user friendly, but actually works.

Apache’s error logs shows this information:

The error seems to differ depending on the PHP version:

Then with php 8:

2022/04/20 04:17:16 [error] 121525#121525: *368238 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "aws_cloudwatch" in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php on line 951PHP message: PHP Fatal error: Uncaught TypeError: array_merge(): Argument #2 must be of type array, null given in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php:951
Stack trace:
#0 /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php(951): array_merge(Array, NULL)
#1 /www/example_679/public/wp-includes/class-wp-hook.php(307): WSAL_Ext_Connections->test_connection('')
#2 /www/example_679/public/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#3 /www/example_679/public/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#4 /www/example_679/public/wp-admin/admin-ajax.php(187): do_action('wp_ajax_wsal_co...')
#5 {main}
thrown in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php on line 951" while reading response header from upstream, client: 68.189.168.44, server: www.example.com, request: "POST /wp-admin/admin-ajax.php?_fs_blog_admin=true HTTP/1.1", upstream: "fastcgi://unix:/var/run/php8.0-fpm-example.sock:", host: "www.example.com:17994", referrer: "https://www.example.com/wp-admin/admin.php?page=wsal-ext-settings&tab=connections"

With php7.4:
2022/04/20 03:58:04 [error] 270#270: *365920 FastCGI sent in stderr: "PHP message: PHP Warning: array_merge(): Expected parameter 2 to be an array, null given in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php on line 951" while reading response header from upstream, client: 68.189.168.44, server: www.example.com, request: "POST /wp-admin/admin-ajax.php?_fs_blog_admin=true HTTP/1.1", upstream: "fastcgi://unix:/var/run/php7.4-fpm-example.sock:", host: "www.example.com:17994", referrer: "https://www.example.com/wp-admin/admin.php?page=wsal-ext-settings&tab=connections"

And this error when selecting just log files and not even trying to use an external database:
previously:

2022/04/20 04:20:24 [error] 121525#121525: *368552 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined array key "aws_cloudwatch" in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php on line 951PHP message: PHP Fatal error: Uncaught TypeError: array_merge(): Argument #2 must be of type array, null given in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php:951
Stack trace:
#0 /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php(951): array_merge(Array, NULL)
#1 /www/example_679/public/wp-includes/class-wp-hook.php(307): WSAL_Ext_Connections->test_connection('')
#2 /www/example_679/public/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#3 /www/example_679/public/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#4 /www/example_679/public/wp-admin/admin-ajax.php(187): do_action('wp_ajax_wsal_co...')
#5 {main}
thrown in /www/example_679/public/wp-content/plugins/wp-security-audit-log-premium/extensions/external-db/classes/Connections.php on line 951" while reading response header from upstream, client: 68.189.168.44, server: www.example.com,, request: "POST /wp-admin/admin-ajax.php?_fs_blog_admin=true HTTP/1.1", upstream: "fastcgi://unix:/var/run/php8.0-fpm-example.sock:", host: "www.example.com:17994", referrer: "https://www.example.com/wp-admin/admin.php?page=wsal-ext-settings&tab=connections"

• This topic was modified 2 years, 8 months ago by supaiku.