Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11699

[Draft] unix_socket authentication does not work on some machines

    XMLWordPrintable

Details

    Description

      Can't make unix_socket work on my machine, something must be missing.

      MariaDB [test]> select @@version;
      +----------------------+
      | @@version            |
      +----------------------+
      | 5.5.54-MariaDB-debug |
      +----------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> install soname 'auth_socket';
      Query OK, 0 rows affected (0.05 sec)
       
      MariaDB [test]> create user elenst identified via 'unix_socket';
      Query OK, 0 rows affected (0.00 sec)
      

      MariaDB [test]> select @@socket;
      +-----------------------------------+
      | @@socket                          |
      +-----------------------------------+
      | /data/bld/5.5/data/tmp/mysql.sock |
      +-----------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> exit
      Bye
      elenst@jessie:/data/bld/5.5$ whoami
      elenst
      elenst@jessie:/data/bld/5.5$ bin/mysql --socket=/data/bld/5.5/data/tmp/mysql.sock -uelenst
      ERROR 1698 (28000): Access denied for user 'elenst'@'localhost'
      

      The socket itself is okay:

      elenst@jessie:/data/bld/5.5$ bin/mysql --socket=/data/bld/5.5/data/tmp/mysql.sock -uroot -p
      Enter password: 
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 7
      Server version: 5.5.54-MariaDB-debug Source distribution
       
      Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> 
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.