wordpress postgres database connection issue

2
votes

I'm trying to use the pg4wp postgresql plugin for wordpress. I provide the host, user(with super user role) and password correctly. But I still get the following error.

Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'wordpressuser'@'localhost' (using password: YES) in /var/www/html/main-landing/blog/wp-content/pg4wp/core.php(32) : eval()'d code on line 1386

Warning: error_log(/var/www/html/main-landing/blog//wp-content/pg4wp/logs/pg4wp_unmodified.log): failed to open stream: No such file or directory in /var/www/html/main-landing/blog/wp-content/pg4wp/driver_pgsql.php on line 482

Notice: Trying to get property of non-object in /var/www/html/main-landing/blog/wp-content/pg4wp/driver_pgsql.php on line 274

Notice: Trying to get property of non-object in /var/www/html/main-landing/blog/wp-content/pg4wp/driver_pgsql.php on line 288

Warning: error_log(/var/www/html/main-landing/blog//wp-content/pg4wp/logs/pg4wp_unmodified.log): failed to open stream: No such file or directory in /var/www/html/main-landing/blog/wp-content/pg4wp/driver_pgsql.php on line 482

Warning: pg_query(): Query failed: ERROR: missing FROM-clause entry for table "session" LINE 1: SELECT @@SESSION.sql_mode ^ in /var/www/html/main-landing/blog/wp-content/pg4wp/driver_pgsql.php on line 136

My pg_log throws the following error:

ERROR: relation "wp_options" does not exist at character 26 STATEMENT: SELECT option_value FROM wp_options WHERE option_name = 'siteurl' LIMIT 1

Can't figure this out

1
phpwordpresspostgresql
It looks like something (a plugin, maybe) is sending MySQL-specific statements. SELECT @@SESSION.sql_mode doesn't make sense in PostgreSQL, it's a MySQL extension. – Craig Ringer

1 Answers

0
votes

Put bluntly, don't even try to not use MySQL with WordPress. This plugin is merely one of many that have tried to make WP play well with Postgres. They all failed owing to lack of maintenance and plugin compatibility.

As you may have noted on the plugin's page, this one is no exception: it hasn't been updated for months in spite of how WP's core has evolved in recent versions, and it mentions the usual caveats with respect to plugins.