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

Mariadb cluster does not ship pam authentication module

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 5.5.33a
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      After installing mariadb-galera-server I do not appear to have the pam auth plugin.

      Here are the only authentication plugins available:

      mysql_native_password ACTIVE AUTHENTICATION NULL GPL
      mysql_old_password ACTIVE AUTHENTICATION NULL GPL

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            serg Sergei Golubchik added a comment -

            how did you install mariadb-galera-server? Did you use apt-get?

            Show
            serg Sergei Golubchik added a comment - how did you install mariadb-galera-server? Did you use apt-get?
            Hide
            mchugh19 Christian McHugh added a comment -

            Yep!

            1. dpkg -l |grep maria
              ii libmariadbclient18 5.5.34+maria-1~wheezy MariaDB database client library
              ii libmysqlclient18 5.5.34+maria-1~wheezy Virtual package to satisfy external depends
              ii mariadb-client-5.5 5.5.34+maria-1~wheezy MariaDB database client binaries
              ii mariadb-client-core-5.5 5.5.34+maria-1~wheezy MariaDB database core client binaries
              ii mariadb-common 5.5.34+maria-1~wheezy MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
              ii mariadb-galera-server 5.5.33a+maria-1~wheezy MariaDB database server with Galera cluster
              ii mariadb-galera-server-5.5 5.5.33a+maria-1~wheezy MariaDB database server with Galera cluster binaries
              ii mysql-common 5.5.34+maria-1~wheezy MariaDB database common files (e.g. /etc/mysql/my.cnf)
            1. cat /etc/apt/sources.list.d/mariadb.list
              deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main
            Show
            mchugh19 Christian McHugh added a comment - Yep! dpkg -l |grep maria ii libmariadbclient18 5.5.34+maria-1~wheezy MariaDB database client library ii libmysqlclient18 5.5.34+maria-1~wheezy Virtual package to satisfy external depends ii mariadb-client-5.5 5.5.34+maria-1~wheezy MariaDB database client binaries ii mariadb-client-core-5.5 5.5.34+maria-1~wheezy MariaDB database core client binaries ii mariadb-common 5.5.34+maria-1~wheezy MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) ii mariadb-galera-server 5.5.33a+maria-1~wheezy MariaDB database server with Galera cluster ii mariadb-galera-server-5.5 5.5.33a+maria-1~wheezy MariaDB database server with Galera cluster binaries ii mysql-common 5.5.34+maria-1~wheezy MariaDB database common files (e.g. /etc/mysql/my.cnf) cat /etc/apt/sources.list.d/mariadb.list deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/debian wheezy main
            Hide
            elenst Elena Stepanova added a comment -

            The module is shipped, but as the most of plugins it is a separate library. To enable it, run INSTALL SONAME 'auth_pam'.

            If it does not work, please comment to re-open the bug and provide information about your OS/architecture.

            Show
            elenst Elena Stepanova added a comment - The module is shipped, but as the most of plugins it is a separate library. To enable it, run INSTALL SONAME 'auth_pam' . If it does not work, please comment to re-open the bug and provide information about your OS/architecture.
            Hide
            mchugh19 Christian McHugh added a comment -

            Oh man! You are right. Install soname loaded it right up.

            I don't see in the documentation a way to specify these commands in my.cnf. Is that possible? It looks like --plugin-load auth_pam, could be passed to the mysqld process at startup, but on debian these options are not user editable without modifying, and thus customizing, the init script script.

            Show
            mchugh19 Christian McHugh added a comment - Oh man! You are right. Install soname loaded it right up. I don't see in the documentation a way to specify these commands in my.cnf. Is that possible? It looks like --plugin-load auth_pam, could be passed to the mysqld process at startup, but on debian these options are not user editable without modifying, and thus customizing, the init script script.
            Hide
            elenst Elena Stepanova added a comment -

            If you ran INSTALL SONAME, you don't need to re-load the plugin on each server startup, it will stay there until you unload it (or until the library is removed from the file system).
            Otherwise, yes, plugin-load (or plugin-load-add) is the solution, you should add it to my.cnf
            plugin-load=auth_pam

            Show
            elenst Elena Stepanova added a comment - If you ran INSTALL SONAME , you don't need to re-load the plugin on each server startup, it will stay there until you unload it (or until the library is removed from the file system). Otherwise, yes, plugin-load (or plugin-load-add) is the solution, you should add it to my.cnf plugin-load=auth_pam

              People

              • Assignee:
                Unassigned
                Reporter:
                mchugh19 Christian McHugh
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: