← Back to team overview

maria-discuss team mailing list archive

Re: Getting PAM auth to work with JDBC

 

I have.  Not much time to reply, but one major thing I had to do form my
notes:

4. modify my.cnf and add line with:  pam_use_cleartext_plugun
   requires restart!!!!
   For Old Workbench to work with this, set the environment variable
   LIB_MYSQL_CLEARTEXT_PLUGIN=1
   For recet Workbench, in the connections dialog, on the Advanced tab,
check
   Enable Cleartext Authentication Plugin

   Problem:  Password is sent uncrypted!!!!

If i remember correclty, nothing needs to happen on JDBC-side to get this
to work.  But, I had the LIB_MYSQL_CLEARTEXT_PLUGIN=1 in the environment.
YMMV.

HTH,
Adam

On Tue, Jul 7, 2015 at 5:44 AM, Troels Arvin <troels@xxxxxxxx> wrote:

> I've got the PAM authentication to work, as long as I use a plain command
> line MariaDB client or HeidiSQL. But I need things to work with JDBC as
> well.
>
> I've found some instructions what seem to indicate that I need to somehow
> make the JDBC connection use SQL and plain-text authentication. But I have
> not been able to find specific instructions on doing that. (The
> instructions, I've seen seem to mainly point to other documents in a
> circular/byzantine way.)
>
> Has someone got the combination of a JDBC client and an PAM-enabled
> MariaDB server to work? If so: Can you shed some light on the steps you
> went through?
>
> Thanks in advance.
>
> --
> Regards,
> Troels Arvin
> http://troels.arvin.dk
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

References