On Friday, 20 February 2026 at 00:22:15 UTC, realhet wrote:
On Thursday, 19 February 2026 at 23:32:05 UTC, apz28 wrote:
On Thursday, 19 February 2026 at 22:54:42 UTC, realhet wrote:
Hi,
You can try my packages - if bug found, please create one
Look unittest in module pham.db.db_mydatabase for
DbIntegratedSecurityConnection.srp256
https://github.com/apz28/dlang/tree/main/source/pham/db
https://code.dlang.org/packages/pham_library
Thanks!
pham.db.db_myexception.MyException@c:\d\libs\pham\db\db_myprotocol.d(912):
Unsupported authenticated type: mysql_native_password
Now it turned out, that my older MySql version which works with
mysql-d/mysql-native is too old for your library.
I've made a user with sha authentication, but the default on
this MySql version is still `mysql_native_password`, so the
pham.db library gives up.
Now I will stick to MySql5.7, I'm happy that it finally works.
And later if I have to work with a bigger server, I will have
some ideas.
Thank you All!
It is a lack of clarification, it supports 4 types
mysql_native_password, SCRAM-SHA-1, caching_sha2_password &
authentication_windows_client
You need to set
connection.connectionStringBuilder.integratedSecurity =
DbIntegratedSecurityConnection.legacy; // To a one that required
by database server
DbIntegratedSecurityConnection.legacy = mysql_native_password
DbIntegratedSecurityConnection.srp1 = SCRAM-SHA-1
DbIntegratedSecurityConnection.srp256 = caching_sha2_password
DbIntegratedSecurityConnection.sspi =
authentication_windows_client
