You are not logged in.

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

vinyl
Member
Registered: 2004-07-06
Posts: 33

[pure-ftpd] Mysql

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?

Offline

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

vinyl
Member
Registered: 2004-07-06
Posts: 33

Re: [pure-ftpd] Mysql

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?

Offline

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

Deciare
Member
From: UTC -5:00
Registered: 2005-05-05
Posts: 78

Re: [pure-ftpd] Mysql

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?

Offline

Board footer

Powered by FluxBB