Re: [PHP-DB] MySQLnd support for ed25519
Hi Ruprecht, yes, if a provider not changed the default authentication (mysql_nativ_password) there is nothing customers have to do, because the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based). Mysql changed this starting from version 8, were the default authentication now is the plugin caching_sha2_password. Mariadb not changed the default, but recommends to use a safer authentication method like the ed25519-plugin. I would like to use it, but then i have the problem that PHP (the Mysql nativ driver) cames with an error like "The server requested authentication method unknown to the client". So i would be glad if this authentication method would be implemented. Regards, Dimi
RE: [PHP-DB] MySQLnd support for ed25519
Mysql 8 is already the stable version and has been for a while. I for development use it on windows and its v8 -Original Message- From: Ruprecht Helms Sent: 08 September 2021 16:02 To: php-db@lists.php.net Subject: Re: [PHP-DB] MySQLnd support for ed25519 Hi Dimi, I think mysql 8 is the new version of mysql. I don't know if there a exists a stable release or only a beta. My thoughts are that the last php-version maybe can handle the mentioned authentication method or you have to try to compile the handling for the mysql-plugin in the php-mysqldriver. Maybe the question about enhancing the php is relation on the Linuxdistribution. Here I mean an additional rpm if you use Redhat, Fedora, Centos, Suse... or .deb if you use Debian, Ubuntu or such of these. To mix a tarball with one of these packages I think it is to difficult in this case. Regards, Ruprecht Am 08.09.21 um 15:20 schrieb dimi_php: > Hi Ruprecht, > > yes, if a provider not changed the default authentication > (mysql_nativ_password) there is nothing customers have to do, because > the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based). > Mysql changed this starting from version 8, were the default authentication > now is the plugin caching_sha2_password. > Mariadb not changed the default, but recommends to use a safer authentication > method like the ed25519-plugin. > > I would like to use it, but then i have the problem that PHP (the > Mysql nativ driver) cames with an error like "The server requested > authentication method unknown to the client". > > So i would be glad if this authentication method would be implemented. > > Regards, > Dimi -- PHP Database Mailing List (https://link.edgepilot.com/s/bc6bf762/v5jGKG7Xd0e-fT3zNkB0xg?u=http://www.php.net/) To unsubscribe, visit: https://link.edgepilot.com/s/cb035ec6/Rl3bBHstt0_Aj5u5ZnK0vg?u=http://www.php.net/unsub.php
Re: [PHP-DB] MySQLnd support for ed25519
Hi Dimi, I think mysql 8 is the new version of mysql. I don't know if there a exists a stable release or only a beta. My thoughts are that the last php-version maybe can handle the mentioned authentication method or you have to try to compile the handling for the mysql-plugin in the php-mysqldriver. Maybe the question about enhancing the php is relation on the Linuxdistribution. Here I mean an additional rpm if you use Redhat, Fedora, Centos, Suse... or .deb if you use Debian, Ubuntu or such of these. To mix a tarball with one of these packages I think it is to difficult in this case. Regards, Ruprecht Am 08.09.21 um 15:20 schrieb dimi_php: Hi Ruprecht, yes, if a provider not changed the default authentication (mysql_nativ_password) there is nothing customers have to do, because the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based). Mysql changed this starting from version 8, were the default authentication now is the plugin caching_sha2_password. Mariadb not changed the default, but recommends to use a safer authentication method like the ed25519-plugin. I would like to use it, but then i have the problem that PHP (the Mysql nativ driver) cames with an error like "The server requested authentication method unknown to the client". So i would be glad if this authentication method would be implemented. Regards, Dimi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQLnd support for ed25519
Hi Dimi, hi everyone, I don't know about this algorithm. On one running server and on my local linuxbox there is Mysql running. On another server the provider changed from mysql to mariadb. As reason for the change from mysql 5.7 to mariadb 10.5 the provider only told his customers that mariadb is an enlargement of the database and based on mysql. Nothing told about better security or any more, only that the provider looked forward without problems in the changingprocess. Regards, Ruprecht Am 07.09.21 um 17:04 schrieb dimi_php: Hi everyone, i just wanted to ask if the authentication with ed25519 algorithm with the MySQLnd is maybe possible in the future? I use mariadb which currently not support either the sha256_password or the caching_sha2_password, therefore i have to use the standard mysql_native_password authentication, although i actually want to use the ed25519 authentication-plugin in mariadb. Best regards, Dimi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
