[MacPorts] #72323: mariadb-10.6-server fails to run after migrate due to missing dependency on lzo2

[MacPorts]

#72323: mariadb-10.6-server fails to run after migrate due to missing dependency on
lzo2
----------------------+--------------------
 Reporter:  jasimon9  |      Owner:  (none)
     Type:  defect    |     Status:  new
 Priority:  Normal    |  Milestone:
Component:  ports     |    Version:
 Keywords:            |       Port:
----------------------+--------------------
 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).

-- 
Ticket URL: <https://trac.macports.org/ticket/72323>
MacPorts <https://www.macports.org/>
Ports system for macOS