[pure-ftpd] Mysql

vinyl · 2005-10-13 07:33:46

I used pure-ftpd before, but this time it makes me crazy.

I have set up Pure-ftpd, when I start it WITHOUT the line:

MySQLConfigFile /etc/pureftpd-mysql.conf

It works, it starts up and runs.

But when I comment out the line above, it fails to start.. I cant really seem to figure what it could be...

The contents of the pureftp-mysql.conf is this:

#MYSQLServer localhost
#MYSQLPort 3306
MYSQLSocket /tmp/mysql.sock
MYSQLUser user
MYSQLPassword pass
MYSQLDatabase pureftpd
MYSQLCrypt cleartext
MYSQLGetPW SELECT Password FROM users WHERE User="L"
MYSQLGetDir SELECT Dir FROM users WHERE User="L"
MYSQLDefaultUID 1000
MYSQLDefaultGID 1000

(obviously I filled in the user+pass)

My database looks like this:

CREATE TABLE `users` (
`User` varchar(16) collate latin1_general_ci NOT NULL default '',
`Password` varchar(64) collate latin1_general_ci NOT NULL default '',
`Uid` int(11) NOT NULL default '-1',
`Gid` int(11) NOT NULL default '-1',
`Dir` varchar(128) collate latin1_general_ci NOT NULL default '',
PRIMARY KEY (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

Anyone that has some ideas, could it be a firewall issue (wich is NOT on my linux box) or is this really something going wrong in a config file?

vinyl · 2005-10-13 10:03:32

Ok, I managed to get the error message:

421 Unknown authentication method: mysql:/etc/pmysql.conf
[1] 4158
[1] Exit 252 /usr/sbin/pure-ftpd -l mysql:/etc/pmysql.conf

Is the package capable of using mysql for authentication or is there a package made by someone that is capable of using mysql?

Deciare · 2005-10-14 00:05:39

It looks as though pure-ftpd is looking for /etc/pmysql.conf instead of /etc/pureftpd-mysql.conf for some reason. Maybe try renaming your config file to /etc/pmysql.conf and changing the MySQLConfigFile line to match?

Arch Linux

#1 2005-10-13 07:33:46

[pure-ftpd] Mysql

#2 2005-10-13 10:03:32

Re: [pure-ftpd] Mysql

#3 2005-10-14 00:05:39

Re: [pure-ftpd] Mysql

Board footer