Job for mariadb.service failed because the control process exited with error code.

[tsull360]

Hello,
Working with the script on Debian 12, getting the subject error. Didn't see any history on this, thought I would raise it as an issue.

[itiligent]

Hi and thanks for the feedback... Yes, it seems Debian 12 breaks a bunch of things.. :(

I ran up a vanilla Debian 12 and it seems theres a few new and screwy things that might have changed around various OS behvaviour, db defaults, root permissions, unix socket access and such ... but Im not fully sure of the exact cause as yet. I can replicate a range of errors around database creation where db root access is needed (parts that have worked perfectly for years) and there is an earlier mysql timezone fix that now breaks mariadb cold.

As I'm a but time limited it would seem prundent to hold back from and wait for the dust to settle with such a new OS version and to absorb a bit more backgounf info on whats changed. Best to stay closer to Bullseye / 11 variants for the time being.

I'll leave this open with intent to take a closer look when I can find time... or if some other kind soul wants to help and submit PR that would be awesome!

[tsull360]

Thank you for the feedback! As you are time constrained, I'm knowledge constrained :) but will tinker to see if I can learn anything.

[itiligent]

Tim,

An update:

Just now I was able to massage the code through in smaller chunks and I could successfully create the guacamole database. This might be a Maria bug coz no other versions have had any issue with this exact script syntax in years, unless I’m missing something really dumb...

To reproduce the error, run these commands in a script running as sudo :
SQLCODE=blah blah sql setup commands… echo ${SQLCODE} | mysql -u root -D mysql -h ${MYSQL_HOST} -P ${MYSQL_PORT}

will return ERROR 1698 (28000): Access denied for user 'root'@'localhost'

The error is a bit misleading because if I omit the port number in the script commands, auth works fine and the SQL code runs perfectly :

echo ${SQLCODE} | mysql -u root -D mysql -h ${MYSQL_HOST}

Weird

[itiligent]

closed this, replaced with a more specific issue #10