If I install MariaDB on Debian11 from https://dlm.mariadb.com/repo/mariadb-server/... and do a 'SELECT UUID();' then I always get '-040300000000' as the fifth number and not the mac address of the machine. Example with command line 'mysql':
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 30
|
Server version: 10.5.17-MariaDB-1:10.5.17+maria~deb11 mariadb.org binary distribution
|
......
|
MariaDB [(none)]> select UUID();
|
+--------------------------------------+
|
| UUID() |
|
+--------------------------------------+
|
| 3a688c85-239a-11ed-9a5d-040300000000 |
|
+--------------------------------------+
|
1 row in set (0,000 sec)
|
The same happens with MariaDB 10.6 and also on a different machine.
Kernel is: 5.10.0-17-amd64 #1 SMP Debian 5.10.136-1 (2022-08-13) x86_64 GNU/Linux
If I install the package that comes with Debian11 on the same machine everything is fine:
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 30
|
Server version: 10.5.15-MariaDB-0+deb11u1 Debian 11
|
.....
|
MariaDB [(none)]> select UUID();
|
+--------------------------------------+
|
| UUID() |
|
+--------------------------------------+
|
| e58b1ad1-239a-11ed-b1cd-a249edae51a0 |
|
+--------------------------------------+
|
1 row in set (0.000 sec)
|
If I use
./mariadb_repo_setup --mariadb-server-version="mariadb-10.6.8"
|
to set up the mariadb repository, the version before this commit get's installed and it works also:
Your MariaDB connection id is 31
|
Server version: 10.6.8-MariaDB-1:10.6.8+maria~bullseye mariadb.org binary distribution
|
.......
|
MariaDB [(none)]> select UUID();
|
+--------------------------------------+
|
| UUID() |
|
+--------------------------------------+
|
| cc7e9d64-2873-11ed-8542-a249edae51a0 |
|
+--------------------------------------+
|
1 row in set (0.000 sec)
|
Can this be related to this change?
After porting https://github.com/tridge/junkcode/blob/c271acabd1b1ae24cff1624d5d7bb9bbb9d5c1b9/aix_getmac.c#L10 it failed with a errno 22.
So reverted to using the ioctl SIOCGIFHWADDR.