<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">And solved<div class=""><br class=""></div><div class="">It’s more of a documentation issue.</div><div class=""><br class=""></div><div class="">The default encryption is now SHA512 - which with MD5 and the {SSHA512} on the front needs 101 bytes</div><div class="">for the password in the db</div><div class=""><br class=""></div><div class="">I have only seen references to varchar(40) for the password - I had it set to 100 (doh!)</div><div class=""><br class=""></div><div class="">On the plus side I have it working with Informix - I will do a separate note about the hoops you have to jump through for that.</div><div class=""><br class=""></div><div class="">Sorry for the noise</div><div class=""><br class=""></div><div class="">Regards</div><div class=""><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">--<br class="">Clive Eisen<br class="">GPG: 3818B5F1<br class=""><br class=""><br class=""><br class=""><br class=""><br class=""></div>

</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On 23 Nov 2017, at 12:51, Clive Eisen <<a href="mailto:clive@hildebrand.co.uk" class="">clive@hildebrand.co.uk</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=us-ascii" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Good call chaps <div class=""><br class=""></div><div class="">I have tracked it down to</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Trying CRYPTED validate with {SSHA512}+pCMXZt0RWx/lE/ggcoOJWEUheG9yKiHKLzOUqb1/GJQjyXMgeO3yy1Z4b6meNyavTqAxDJpsS3HuPcTpVeDofi6ilo, secret at /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Dancer2/Plugin/Auth/Extensible/Role/Provider.pm line 85.</span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">+pCMXZt0RWx/lE/ggcoOJWEUheG9yKiHKLzOUqb1/GJQjyXMgeO3yy1Z4b6meNyavTqAxDJpsS3HuPcTpVeDofi6ilo</span>= </div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><br class=""></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class="">eq</div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> +pCMXZt0RWx/lE/ggcoOJWEUheG9yKiHKLzOUqb1/GJQjyXMgeO3yy1Z4b6meNyavTqAxDJpsS3HuPcTpVeDofi6ilo </span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">at /root/perl5/perlbrew/perls/perl-5.24.1/lib/site_perl/5.24.1/Crypt/SaltedHash.pm line 308.</span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">So the original in DB password is padded %4 with = (as it should be) </span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">and the freshly encyrpted one is not</span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class=""></span></div><div style="margin: 0px; line-height: normal; background-color: rgb(255, 255, 255);" class="">I will try and figure out why</div><div style="margin: 0px; font-size: 10px; line-height: normal; font-family: Monaco; background-color: rgb(255, 255, 255);" class=""><br class=""></div><div class="">
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">--<br class="">Clive Eisen<br class="">GPG: 3818B5F1<br class=""><br class=""><br class=""><br class=""><br class=""><br class=""></div>

</div>
<br class=""><div class=""><blockquote type="cite" class=""><div class="">On 23 Nov 2017, at 11:41, Nathan Bailey <<a href="mailto:web@polynate.net" class="">web@polynate.net</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">And in support of Andy's comments below - I put a debug warn statement at the start of each sub in Extensible.pm and Database.pm to work out where things weren't working.<div class="">Also turn up your logging to get the 'debug' level reports from DPAE into your logs.<br class=""><div class="gmail_extra"><br class=""><div class="gmail_quote">On 23 November 2017 at 22:10, Andrew Beverley <span dir="ltr" class=""><<a href="mailto:andy@andybev.com" target="_blank" class="">andy@andybev.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On Thu, 23 Nov 2017 10:28:31 +0000 Clive Eisen wrote:<br class="">
> However the login is failing and I am just returned to the login screen<br class="">
> with the banner set to LOGIN FAILED<br class="">
><br class="">
> There is no indication WHAT is failing - can anyone suggest either what<br class="">
> is wrong or where I can add debug - I have tried with and without roles.<br class="">
<br class="">
</span>I would start by hacking some debug statements directly into the<br class="">
authenticate_user() subroutine in Provider/Database.pm<br class="">
<br class="">
That function should be called by DPAE, so you can check firstly that<br class="">
it's actually being called, and secondly if/what/why it's returning a<br class="">
failure (assuming it is).<br class="">
<br class="">
Andy<br class="">
______________________________<wbr class="">_________________<br class="">
dancer-users mailing list<br class="">
<a href="mailto:dancer-users@dancer.pm" class="">dancer-users@dancer.pm</a><br class="">
<a href="http://lists.preshweb.co.uk/mailman/listinfo/dancer-users" rel="noreferrer" target="_blank" class="">http://lists.preshweb.co.uk/<wbr class="">mailman/listinfo/dancer-users</a><br class="">
</blockquote></div><br class=""></div></div></div>
_______________________________________________<br class="">dancer-users mailing list<br class=""><a href="mailto:dancer-users@dancer.pm" class="">dancer-users@dancer.pm</a><br class=""><a href="http://lists.preshweb.co.uk/mailman/listinfo/dancer-users" class="">http://lists.preshweb.co.uk/mailman/listinfo/dancer-users</a><br class=""></div></blockquote></div><br class=""></div></div>_______________________________________________<br class="">dancer-users mailing list<br class=""><a href="mailto:dancer-users@dancer.pm" class="">dancer-users@dancer.pm</a><br class="">http://lists.preshweb.co.uk/mailman/listinfo/dancer-users<br class=""></div></blockquote></div><br class=""></div></body></html>