Quote:
Originally Posted by Uzzi
Hi,I've configured pure-ftpd table-mysql to use pureftpd db and ftpd table.
Ehis is log:
Code:
Wrong SQL parameters : [SELECT Password FROM users WHERE User='xyx']
Why use FROM users above FROM ftpd?
Code:
/etc/pure-ftpd/db/mysql.conf:
MYSQLGetPW SELECT Password FROM ftpd WHERE User="L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "R")
Thank you Debian 11
|
You don't show us the relevant parts of your pure-ftpd configuration, so it's hard to know. Which tutorial did you follow on setting this up?
https://tecadmin.net/setup-pure-ftpd...centos-redhat/
While that tutorial is for RHEL/CentOS, the steps are valid (aside from those for installation using YUM, which you've ostensibly already performed). It looks as if you've not completed configuration of things.
As an aside, I'd strongly recommend *NEVER* using FTP...SFTP and SCP can perform essentially the same functions, but are much more secure.