Not able to get it working on Azure

[Sudeep Dsouza]

Hi,

I used to use Cleardb to host the mysql database but as it is shutting down
I moved the database to Azure. But when i try to connect it to the Azure
Mysql database i am getting an error.
1. Does Phpgedview work on Mysql version 8.0 which is what is available on
Azure
2. Is there any other database provider that I can use to host this if
Azure does not work.

Thanks in advance.

Regards,
Sudeep
Personal blog - http://www.sudeep.me

[Gerry Kroll]

Firstly, which version of PhpGedView are you using?

You should be using the latest-and-greatest version that you can download as an SVN snapshot.

What error messages are you getting? Saying, "It doesn't work" is not very helpful.

[Sudeep Dsouza]

@canajun2eh I am using PhpGedView 4.3.0 svn.

Given below are the error messages i get when i connect to the database.

ERROR 2: PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
0 Error occurred on in function __construct
1 called from line 115 of file class_pgv_db.php in function createInstance
2 called from line 183 of file install.php

Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers

[Gerry Kroll]

You say you're using PhpGedView version 4.3.0 "svn". Are you sure about that? You're supposed to use version 4.3.1 "SVN". I assume the ".0" is just a typo.

Your database is not configured correctly on the server.

PhpGedView uses UTF-8 character encoding exclusively. The server's database configuration must be set to support utf8mb3_unicode_ci collation .

Since your database configuration in PhpGedView (near the bottom of the screen shot you supplied) specifies that the database should not be used to provide UTF-8 collation, your server's database configuration must be set to support latin1_swedish_ci collation in addition to the utf8mb3_unicode_ci collation mentioned above.

The database support of various collations is done outside PhpGedView. PhpGedView has no control over how the database is set up on the server.