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

TJ Saunders <[email protected]>
Newsgroups gmane.network.proftpd.user
Message-ID <1483634843.1739575.838400425.7B79BB1F@webmail.messagingengine.com>
> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.