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

[Volodymyr Kostyrko]

Marko Cupać wrote:

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.



Any idea why the same configuration does not work in jail-based host?


I can only guess wide: there's no connection to database. Whether you 
missed the difference between 'localhost' and '127.0.0.1' or the jail 
misses network connection to the server. Try connecting to the mysql 
database directly with a commandline client.


--
Sphinx of black quartz judge my vow.

___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"

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
MaxClientsNumber50
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  1 8
MaxLoad 4
PassivePortRange3 31000
Umask   133:022
MinUID  2001
AllowUserFXPno
ProhibitDotFilesWrite   yes
ProhibitDotFilesReadyes
AltLog  stats:/var/log/pureftpd.log
NoChmod yes
CreateHomeDir   yes
MaxDiskUsage99
CustomerProof   yes
IPV4Onlyyes
BindIP.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/
___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"