Re: [Proftpd-user] Login error with SqlAuthType=Backend with MySQL5.7+

Tj,

I've read your posts, This may be related, i configured it with this from git head:

sh configure --sysconfdir=/etc --enable-devel=stacktrace --with-modules=mod_sql:mod_sql_mysql:mod_quotatab:mod_quotatab_sql:mod_wrap2:mod_wrap2_sql:mod_tls:mod_ifsession --disable-auth-file --enable-nls --with-includes=/usr/include/mysql --enable-scoreboard-updates

I tries without 
--with-includes=/usr/include/mysql

To make it auto-guess it, and some thing, I only have one libmysqlclient-dev installed, and it's the mysql5.7 one.

Any idea?


> -----Original Message-----
> From: TJ Saunders [mailto:[email protected]]
> Sent: quinta-feira, 5 de Janeiro de 2017 16:47
> To: Jose Almeirim; [email protected]
> Subject: Re: [Proftpd-user] Login error with SqlAuthType=Backend with
> MySQL5.7+
> 
> 
> > With MySQL 5.7+ I cannot auth users with backend authtype, I get an:
> >
> >
> > 2017-01-04 22:08:23,041 mod_sql/4.3[5973]: checking password using
> > SQLAuthType 'Backend'
> > 2017-01-04 22:08:23,041 mod_sql/4.3[5973]: entering     mysql
> > cmd_checkauth
> > 2017-01-04 22:08:23,048 mod_sql/4.3[5973]: password mismatch
> > 2017-01-04 22:08:23,048 mod_sql/4.3[5973]: exiting      mysql
> > cmd_checkauth
> > 2017-01-04 22:08:23,048 mod_sql/4.3[5973]: 'Backend' SQLAuthType
> handler
> > reports failure
> 
> Did you build proftpd from source, or are you using a package?  There
> are similar reports in the online forums:
> 
>   https://forums.proftpd.org/smf/index.php/topic,12043.0.html
> 
> However, as yet I've not been able to reproduce the issue, and thus
> cannot tell if it is a packaging issue, a build issue, or a migration
> of
> old pre-MySQL 5.7+ tables+data to a MySQL 5.7+ world...
> 
> TJ


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html