Windows 10: Loading the spark dataframe to table in Azure Database for PostgreSQL - Flexible Server

Hi Team,Issue:Unable to write data into Azure Flexible Postgress SQL server using DatabricksDescription:We need to store the data from dataframe to table in Azure Flexible Postgress SQL server. We can able to establish the connection using hostname, user_name, password JDBC properties, connection is working fineError Occurred: While writing the data into tableorg.postgresql.util.PSQLException: The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supp

:)

 

Always Encrypted now generally available in Azure SQL Database

Source: Always Encrypted now generally available in Azure SQL Database | Blog | Microsoft Azure

 

How to set up signed SSL Root and Leaf certificates on Ubuntu 18.10 Postgresql 11 Database and Windows 10 Power BI plus PostgreSQL?

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses my Windows 10 computer uses with PostgreSQL 11 and Power BI to connect to my PostgreSQL 11 Ubuntu database. However, I got errors in Power BI while I could manually connect via command line.

After troubleshooting with Microsoft Support, I was told:

However, I am confused by the tutorials at

• 32.19. SSL Support and
  
• Connect to PostgreSQL over SSL/TLS on Debian/Ubuntu - gab.lc.
  

I can't tell what steps need to be done on my Ubuntu PC and what steps need to be done on my Windows PC. I don't know if special steps are needed to configure Power BI with the certificates. How do I set up my bidirectional certificates?

Can someone offer a very detailed tutorial, tell me 'how' to read a tutorial, or explain the steps in an answer please?

Edit: The error messages I received were::

and::

and::

 

Feature request: centralized database logging

GPUZ is great as a standalone utility, but it could easily be enhanced to log data to a centralized database as well. Would you please consider adding this feature:

Settings:

• Database logging checkbox; when checked:
  • Database type (maybe just a connection string and an icon link to connectionstrings.com for add'l info)
  • Database location (server, instance name, etc.)
  • Login, typically userid + pswd, but could include checkbox if using a network acct (e.g. ActiveDirectory)
  • Database name (with default of GPUZ)
  • Frequency of data pushes (realtime, 60s, hourly, etc.)

If need be, I could assist with the coding or send you a C# SQL class I often use for utilities of my own, complete with script to create the database and a login. If you're coding in Java, a C# translation isn't difficult, C++ is a bit more involved. My databases are SQL Server; if you prefer mysql, postgresql, etc., your mileage may vary. *Smile