mariadb-10.6: fails to run due to missing dependency on lzo2

[jasimon9]

With an assist from ChatGPT, I found this in iMac-tmp.log when attempting to start mariadb-10.6-server after a port migrate:

250410 14:52:34 mysqld_safe Starting mariadbd daemon with databases from /opt/local/var/db/mariadb-10.6
dyld[3693]: Library not loaded: /opt/local/lib/liblzo2.2.dylib
  Referenced from: <55E2626A-BC78-303A-A67F-90AD03518BBD> /opt/local/lib/mariadb-10.6/bin/mariadbd
  Reason: tried: '/opt/local/lib/liblzo2.2.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/local/lib/liblzo2.2.dylib' (no such file), '/opt/local/lib/liblzo2.2.dylib' (no such file)
250410 14:52:34 mysqld_safe mysqld from pid file /opt/local/var/db/mariadb-10.6/Mac.lan.pid ended

ChatGPT suggested installing the lzo2 port. After doing that, mariadb-10.6-server ran correctly.

A few contributing factors:

1. During the port migrate, I answered "yes" to all cleanup prompts—this may have removed lzo2.

2. port reclaim might have removed it as well.

3. lzo2 is listed as requested in port echo installed requested, so its removal was unexpected.

Notably, sudo port load mariadb-10.6-server would succeed, but the daemon would silently fail shortly after startup.

It appears the MariaDB server binary links to liblzo2.2.dylib, but no corresponding depends_lib entry exists in the mariadb-10.6 Portfile. Suggest adding port:lzo2 as a dependency for both mariadb-10.6 and mariadb-10.6-server (and perhaps other versions, if affected).

[ryandesign (Ryan Carsten Schmidt)]

The dependency would belong in mariadb-10.6 not mariadb-10.6-server.