As I read in some discussions, usage of wpDataTables with PostgreSQL database needs pgsql driver. Some supporters talk about its restarting in case of connectivity problems.
We don't work on weekends so it adds two days to the waiting time.
we appreciate your patience.
Yes, the driver which is required for your remote Database connection needs to be installed and activated on the WordPress hosting server - in order for your WordPress to make the connection with that remote Database.
Also, the DB user which you input, along with all the other connection details, need to be correctly inserted into our "Additional DB connection" interface of the Plugin.
If you insert all the required details for that connection and if that DB user has permission to connect, and the driver is installed on the WP Hosting server - you can test the connection and see if there are any errors.
If there are any errors - this is being returned from your remote PostegreSQL hosting, wpDataTables can only show the error. We don't have any Log which can show you more details what's behind that error.
We realise our Lite Support most probably already advised on the following details, but here are some general points to be aware of, in regards to connecting our Plugin to your remote Database as PostgreSQL .
Generally speaking, when our Users try to connect to PostgreSQL, here are the checks that need to be done :
First, please check if you have the following drivers installed, and activated ( on your WordPress Hosting server).
So, these drivers need to be installed and activated on the server where your WordPress website is hosted.
The remote (in this case Postgre Database) server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHPs logic of connecting to separate connections.
If there are errors your server returns, those are returned by the remote DB server towards your WordPress, and only displayed by wpDataTables.
- there's no additional log within wpDataTables that would distinctively show you what's behind the error.
If your PostgreSQL is installed on Ubuntu 18.04 server, and you’re receiving the following error:
“wpDataTables could not connect to postgresql server. postgresql said: There was a problem with your SQL connection – could not find driver”
You may need to install the PGSQL driver by following these steps:
[sudo] apt-get install php-pgsql
Then uncomment pgsql and pdo-pgsql extentions in php.ini and restart Apache with the following command:
[sudo] /etc/init.d/apache2 restart
Here is some additional advice, in case if you have chosen a different driver from our dropdown in the External DB Connection configuration.
You should only select the driver from the dropdown if the connection doesn't work.
The plugin detects the connection you selected (MSSQL, MySQL, PostgreSQL) and based on that it attempts to connect using the default driver for that type of database.
If that doesn't work automatically, then you need to select a different/ specific driver.
If you have a Linux server, you can take a look at this thread on Stack Overflow.
There are a lot of resources available online for installing the PHP drivers, so the hosting provider should be able to do this without many issues.
I hope that helps as a general guidance/advice, but let us know if you have any additional questions.
Hey!
As I read in some discussions, usage of wpDataTables with PostgreSQL database needs pgsql driver. Some supporters talk about its restarting in case of connectivity problems.
Where this driver should be:
thank you!
Hi Evgeniy ,
Sorry for the waiting time.
We don't work on weekends so it adds two days to the waiting time.
we appreciate your patience.
Yes, the driver which is required for your remote Database connection needs to be installed and activated on the WordPress hosting server - in order for your WordPress to make the connection with that remote Database.
Also, the DB user which you input, along with all the other connection details, need to be correctly inserted into our "Additional DB connection" interface of the Plugin.
If you insert all the required details for that connection and if that DB user has permission to connect, and the driver is installed on the WP Hosting server - you can test the connection and see if there are any errors.
If there are any errors - this is being returned from your remote PostegreSQL hosting, wpDataTables can only show the error. We don't have any Log which can show you more details what's behind that error.
We realise our Lite Support most probably already advised on the following details, but here are some general points to be aware of, in regards to connecting our Plugin to your remote Database as PostgreSQL .
Generally speaking, when our Users try to connect to PostgreSQL, here are the checks that need to be done :
First, please check if you have the following drivers installed, and activated ( on your WordPress Hosting server).
So, these drivers need to be installed and activated on the server where your WordPress website is hosted.
The remote (in this case Postgre Database) server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHPs logic of connecting to separate connections.
If there are errors your server returns, those are returned by the remote DB server towards your WordPress, and only displayed by wpDataTables.
- there's no additional log within wpDataTables that would distinctively show you what's behind the error.
If your PostgreSQL is installed on Ubuntu 18.04 server, and you’re receiving the following error:
“wpDataTables could not connect to postgresql server. postgresql said: There was a problem with your SQL connection – could not find driver”
You may need to install the PGSQL driver by following these steps:
Then uncomment pgsql and pdo-pgsql extentions in php.ini and restart Apache with the following command:
Here is some additional advice, in case if you have chosen a different driver from our dropdown in the External DB Connection configuration.
You should only select the driver from the dropdown if the connection doesn't work.
The plugin detects the connection you selected (MSSQL, MySQL, PostgreSQL) and based on that it attempts to connect using the default driver for that type of database.
If that doesn't work automatically, then you need to select a different/ specific driver.
If you have a Linux server, you can take a look at this thread on Stack Overflow.
There are a lot of resources available online for installing the PHP drivers, so the hosting provider should be able to do this without many issues.
I hope that helps as a general guidance/advice, but let us know if you have any additional questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables