[Pkg-roundcube-maintainers] Roundcube mysql access change recommendation

[kurt at va1der.ca]

Hello,

I have noticed that the installer for roundcube by in Debian by default 
(for mysql/mariadb connections) sets up the database to use the php 
"mysql" driver.  It points it to a mysql instance on localhost at port 
3306.  I would  like to note that officially, the php mysql extension is 
no longer recommended for use, and hasn't been for some time.  This 
should be updated to "mysqli".

Also, since there is no real method in Debian to even point roundcube at 
a remote database at install time, perhaps you might consider to change 
the installer to use Unix sockets for talking to the database.  There is 
not even a clear way for the end user to edit the generated 
/etc/roundcube/debian-db.php to let it use sockets, though it is 
possible by clearing the port and setting the host to 
"unix(/var/run/mysqld/mysqld.sock)".  It is however unintuitive.  And 
since every mariadb install by default listens on a unix socket, it 
would be a performance improvement to switch the default behaviour.

Best regards,

       Kurt Fitzner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-roundcube-maintainers/attachments/20240807/eeafb414/attachment.htm>