[Bug]: db:convert-type does not support mysql passwordless unix socket auth

⚠️ This issue respects the following points: ⚠️

This is a bug, not a question or a configuration/webserver/proxy issue.
This issue is not already reported on Github (I've searched it).
Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
I agree to follow Nextcloud's Code of Conduct.

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

have a nextcloud install
occ db:convert-type --all-apps --clear-schema mysql nextcloud localhost:/run/mysqld/mysqld.sock nextcloud

Expected 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?

Default user-backend (database)
LDAP/ Active Directory
SSO - SAML
Other

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

Enabled:
  - accessibility: 1.9.0
  - activity: 2.15.0
  - admin_audit: 1.13.0
  - calendar: 3.0.6
  - cloud_federation_api: 1.6.0
  - cms_pico: 1.0.18
  - comments: 1.13.0
  - contacts: 4.1.0
  - contactsinteraction: 1.4.0
  - dashboard: 7.3.0
  - dav: 1.21.0
  - federatedfilesharing: 1.13.0
  - files: 1.18.0
  - files_markdown: 2.3.5
  - files_pdfviewer: 2.4.0
  - files_rightclick: 1.2.0
  - files_sharing: 1.15.0
  - files_trashbin: 1.13.0
  - files_versions: 1.16.0
  - firstrunwizard: 2.12.0
  - impersonate: 1.10.0
  - logreader: 2.8.0
  - lookup_server_connector: 1.11.0
  - nextcloud_announcements: 1.12.0
  - notifications: 2.11.1
  - oauth2: 1.11.0
  - password_policy: 1.13.0
  - photos: 1.5.0
  - privacy: 1.7.0
  - provisioning_api: 1.13.0
  - recommendations: 1.2.0
  - serverinfo: 1.13.0
  - settings: 1.5.0
  - sharebymail: 1.13.0
  - survey_client: 1.11.0
  - systemtags: 1.13.0
  - tasks: 0.14.4
  - text: 3.4.1
  - theming: 1.14.0
  - twofactor_backupcodes: 1.12.0
  - twofactor_nextcloud_notification: 3.3.1
  - twofactor_totp: 6.2.0
  - twofactor_u2f: 6.3.0
  - unsplash: 1.2.4
  - updatenotification: 1.13.0
  - user_status: 1.3.1
  - viewer: 1.7.0
  - weather_status: 1.3.0
  - workflowengine: 2.5.0
Disabled:
  - circles: 22.1.1
  - encryption
  - federation: 1.8.0
  - files_accesscontrol: 1.13.0
  - files_external
  - files_videoplayer: 1.11.0
  - news: 18.0.0
  - phonetrack: 0.7.0
  - support: 1.5.0
  - user_ldap

Nextcloud Signing status

Nextcloud Logs

PHP                 Error: Return type of OCA\LogReader\Log\LogIterator::rewind() should either be compatible with          2022-04-14T06:11:28+00:00  
                              Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily                                  
                              suppress the notice at /usr/share/webapps/nextcloud/apps/logreader/lib/Log/LogIterator.php#69 at                                   
                              lib/private/Log/ErrorHandler.php line 92                                                                                           
                                                                                                                                                                 
                               0. apps/logreader/lib/Log/LogIterator.php line 24                                                                                 
                                  OC\Log\ErrorHandler::onError(                                                                                                  
                                                                                                                                                                 
                                  )                                                                                                                              
                               1. lib/composer/composer/ClassLoader.php line 571                                                                                 
                                  include("\/usr\/share\/webapps\/nextcloud\/apps\/logreader\/lib\/Log\/LogIterator.php")                                        
                               2. lib/composer/composer/ClassLoader.php line 428                                                                                 
                                  Composer\Autoload\includeFile(                                                                                                 
                                                                                                                                                                 
                                  )                                                                                                                              
                               3. .../logreader/lib/Log/LogIteratorFactory.php line 55                                                                           

                                  Composer\Autoload\ClassLoader->loadClass(                                                                                      
                                                                                                                                                                 
                                  )                                                                                                                              
                               4. .../logreader/lib/Command/Tail.php line 65                                                                                     
                                  OCA\LogReader\Log\LogIteratorFactory->getLogIterator(                                                                          
                                                                                                                                                                 
                                  )                                                                                                                              
                               5. 3rdparty/symfony/console/Command/Command.php line 255                                                                          
                                  OCA\LogReader\Command\Tail->execute(                                                                                           
                                                                                                                                                                 
                                  )                                                                                                                              
                               6. core/Command/Base.php line 168                                                                                                 
                                  Symfony\Component\Console\Command\Command->run(                                                                                
                                                                                                                                                                 
                                  )                                                                                                                              
                               7. 3rdparty/symfony/console/Application.php line 1009                                                                             
                                  OC\Core\Command\Base->run(                                                                                                     
                                                                                                                                                                 
                                  )                                                                                                                              
                               8. .../console/Application.php line 273                                                                                           
                                  Symfony\Component\Console\Application->doRunCommand(                                                                           
                                                                                                                                                                 
                                  )                                                                                                                              
                               9. .../symfony/console/Application.php line 149                                                                                   
                                  Symfony\Component\Console\Application->doRun(                                                                                  
                                                                                                                                                                 
                                  )                                                                                                                              
                              10. lib/private/Console/Application.php line 211                                                                                   
                                  Symfony\Component\Console\Application->run(                                                                                    
                                                                                                                                                                 
                                  )                                                                                                                              
                              11. console.php line 99                                                                                                            
                                  OC\Console\Application->run(                                                                                                   
                                                                                                                                                                 
                                  )                                                                                                                              
                              12. occ line 11                                                                                                                    
                                  require_once("\/usr\/share\/webapps\/nextcloud\/console.php")

Additional info

In Connection.php line 87:             
  Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused

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.

(occ db:convert-type) Add support for UNIX sockets

fix(occ): Add support for UNIX sockets to `db:convert-type`

Navigation Menu

Repository navigation

[Bug]: db:convert-type does not support mysql passwordless unix socket auth #31998

⚠️ This issue respects the following points: ⚠️

Bug description

Steps to reproduce

Expected behavior

Installation method

Operating system

PHP engine version

Web server

Database engine version

Is this bug present after an update or on a fresh install?

Are you using the Nextcloud Server Encryption module?

What user-backends are you using?

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[Bug]: db:convert-type does not support mysql passwordless unix socket auth #31998

Description

⚠️ This issue respects the following points: ⚠️

Bug description

Steps to reproduce

Expected behavior

Installation method

Operating system

PHP engine version

Web server

Database engine version

Is this bug present after an update or on a fresh install?

Are you using the Nextcloud Server Encryption module?

What user-backends are you using?

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

Activity

szaimen commented on Jan 23, 2023

kbaniszack commented on Jan 25, 2023

szaimen commented on Jan 25, 2023

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions