[bug]: socket DB connections do not work

[miken32]

FreePBX Version

FreePBX 17

Issue Description

Just noticed I had 8 GB of error logs from UCP. You're passing invalid options to nodeMaria.createConnection() for socket-based connections. unixSocket is not valid. The correct option is socketPath. Check /var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/config/connection-options.js for details.

Operating Environment

UCP 17.0.4.30

Relevant log output

2026-02-25 18:34 -05:00: SqlError: (conn:-1, no: 1130, SQLState: HY000) Host '::1' is not allowed to connect to this MariaDB server
2026-02-25 18:34 -05:00:     at module.exports.createError (/var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/misc/errors.js:66:10)
2026-02-25 18:34 -05:00:     at PacketNodeEncoded.readError (/var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/io/packet.js:588:19)
2026-02-25 18:34 -05:00:     at Handshake.parseHandshakeInit (/var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/cmd/handshake/auth/handshake.js:35:30)
2026-02-25 18:34 -05:00:     at Authentication.onPacketReceive (/var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/cmd/handshake/authentication.js:42:17)
2026-02-25 18:34 -05:00:     at PacketInputStream.receivePacketBasic (/var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/io/packet-input-stream.js:85:9)
2026-02-25 18:34 -05:00:     at PacketInputStream.onData (/var/www/html/admin/modules/ucp/node/node_modules/mariadb/lib/io/packet-input-stream.js:135:20)
2026-02-25 18:34 -05:00:     at Socket.emit (node:events:517:28)
2026-02-25 18:34 -05:00:     at addChunk (node:internal/streams/readable:368:12)
2026-02-25 18:34 -05:00:     at readableAddChunk (node:internal/streams/readable:341:9)
2026-02-25 18:34 -05:00:     at Readable.push (node:internal/streams/readable:278:10) {
2026-02-25 18:34 -05:00:   sqlMessage: "Host '::1' is not allowed to connect to this MariaDB server",
2026-02-25 18:34 -05:00:   sql: null,
2026-02-25 18:34 -05:00:   fatal: true,
2026-02-25 18:34 -05:00:   errno: 1130,
2026-02-25 18:34 -05:00:   sqlState: 'HY000',
2026-02-25 18:34 -05:00:   code: 'ER_HOST_NOT_PRIVILEGED'
2026-02-25 18:34 -05:00: }
2026-02-25 18:34 -05:00: There was an error with MySQL Connection

[miken32]

Looks like commit 2da2005 just copied and pasted options, despite changing from one library to another.