ftp/pure-ftpd mysql auth from jail not working?

[Marko Cupać]

Hi,

I have working pure-ftpd server on vmware-based 9.3-RELEASE-p33. It
authenticates virtual users from mysql server over tcp, and chroots them
to their directories.

I'd like to move pure-ftpd to jail-based 10.2-RELEASE-p10. I copied
pure-ftpd.conf and pureftpd-mysql.conf to new server, but I get:

331 User someuser OK. Password required
Password:
530 Login authentication failed
Login failed.

pure-ftpd.conf:
ChrootEveryone              yes
BrokenClientsCompatibility  no
MaxClientsNumber            50
Daemonize                   yes
MaxClientsPerIP             32
VerboseLog                  no
DisplayDotFiles             no
AnonymousOnly               no
NoAnonymous                 yes
SyslogFacility              ftp
DontResolve                 yes
MaxIdleTime                 15
MySQLConfigFile             /usr/local/etc/pureftpd-mysql.conf
LimitRecursion              10000 8
MaxLoad                     4
PassivePortRange            30000 31000
Umask                       133:022
MinUID                      2001
AllowUserFXP                no
ProhibitDotFilesWrite       yes
ProhibitDotFilesRead        yes
AltLog                      stats:/var/log/pureftpd.log
NoChmod                     yes
CreateHomeDir               yes
MaxDiskUsage                99
CustomerProof               yes
IPV4Only                    yes
Bind                        IP.ADD.RE.SS,21

pureftpd-mysql.conf:
MYSQLServer		mysql.example.org
MYSQLPort       	3306
MYSQLUser       	user
MYSQLPassword   	pass
MYSQLDatabase   	pureftpd
MYSQLCrypt      	any
MYSQLGetPW      	SELECT Password FROM users WHERE User='\L'
MYSQLGetUID     	SELECT Uid FROM users WHERE User='\L'
MYSQLGetGID     	SELECT Gid FROM users WHERE User='\L'
MYSQLGetDir     	SELECT Dir FROM users WHERE User='\L'
MySQLGetBandwidthUL     SELECT ulBwidth FROM users WHERE User='\L'
MySQLGetBandwidthDL     SELECT dlBwidth FROM users WHERE User='\L'
MySQLGetQTASZ           SELECT sizeQuota FROM users WHERE User='\L'
MySQLGetQTAFS		SELECT fileQuota FROM users WHERE User='\L'

Any idea why the same configuration does not work in jail-based host?
-- 
Before enlightenment - chop wood, draw water.
After  enlightenment - chop wood, draw water.

Marko Cupać
https://www.mimar.rs/