[Bug]: db:convert-type does not support mysql passwordless unix socket auth #31998
Closed
5 of 8 tasks
Assignees
Labels
Comments
urandom2
added
0. Needs triage
This comment has been minimized.
This comment has been minimized.
|
Hi, I have the same problem with version 25.0.2:
Does this help? |
|
After thinking about this, it sounds like a feature request to me since unix sockets seem to not be supported by the db:convert-type command. |
joshtrichards
added a commit
to joshtrichards/nc-server
that referenced
this issue
Jul 8, 2023
Fixes nextcloud#31998 Adds support to `occ db:convert-type` to support UNIX socket connections via MySQL/MariaDB. Uses same `dbhost` / `hostname` parameter parsing logic (adapted) as used elsewhere (at least the relevant parts) for consistency. Signed-off-by: Josh Richards <[email protected]>
4 tasks
AndyScherzinger
pushed a commit
to joshtrichards/nc-server
that referenced
this issue
Feb 27, 2024
Fixes nextcloud#31998 Adds support to `occ db:convert-type` to support UNIX socket connections via MySQL/MariaDB. Uses same `dbhost` / `hostname` parameter parsing logic (adapted) as used elsewhere (at least the relevant parts) for consistency. Signed-off-by: Josh Richards <[email protected]>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Bug description
I am able to configure nextcloud to mariadb via unix socket without a password, nextcloud/docker#1284, however when I use
db:convert-type, I get a 'Connection refused` error.Steps to reproduce
occ db:convert-type --all-apps --clear-schema mysql nextcloud localhost:/run/mysqld/mysqld.sock nextcloudExpected behavior
it would work
Installation method
Other
Operating system
Other
PHP engine version
PHP 8.1
Web server
Nginx
Database engine version
PostgreSQL
Is this bug present after an update or on a fresh install?
Updated from a minor version (ex. 22.2.3 to 22.2.4)
Are you using the Nextcloud Server Encryption module?
Encryption is Disabled
What user-backends are you using?
Configuration report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "nextcloud.example.com" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "23.0.3.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "", "dbuser": "***REMOVED SENSITIVE VALUE***", "installed": true, "theme": "", "maintenance": false, "apps_paths": [ { "path": "\/usr\/share\/webapps\/nextcloud\/apps", "url": "\/apps", "writable": true } ], "appstore.experimental.enabled": true, "loglevel": 0, "trashbin_retention_obligation": "auto", "htaccess.RewriteBase": "\/", "mail_smtpmode": "smtp", "overwrite.cli.url": "https:\/\/nextcloud.example.com", "memcache.local": "\\OC\\Memcache\\APCu", "filelocking.enabled": true, "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0 }, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "app_install_overwrite": [ "calendar", "keeweb", "impersonate", "groupfolders", "files_accesscontrol", "tasks", "twofactor_nextcloud_notification", "unsplash", "contacts" ], "mysql.utf8mb4": true, "mail_sendmailmode": "smtp", "mail_smtpauthtype": "PLAIN", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "default_phone_region": "US" } }List of activated Apps
Nextcloud Signing status
Nextcloud Logs
Additional info
The text was updated successfully, but these errors were encountered: