← 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

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
   For recet Workbench, in the connections dialog, on the Advanced tab,
   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.


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