--0-2000556517-1116258334=:60881
Content-Type: text/plain; charset=us-ascii

Hi,

I am trying to setup proftpd on linux with
mysql authentication. But not working,
here is the lines that I tried to put in my
proftpd.conf file:

SQLAuthenticate on
#the authenticate type is database
SQLAuthTypes PlainText Backend
#the URL, username, password for connecting to mysql
SQLConnectInfo dbname@192.168.0.6:3306 root password1
#might need default gid
SQLDefaultGID 50
#SQLDefaultHomedir
SQLDefaultUID 50
#SQLGroupInfo
#SQLGroupWhereClause
#SQLHomedirOnDemand
#SQLLog
#SQLLogFile
#SQLMinID
#SQLMinUserGID
#SQLMinUserUID
SQLUserInfo ftp_user username password uid gid ftpdir homedir


#############endofconf###################

I have a table inside mysql database with the following structure:

mysql> desc ftp_user;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(20) | YES | | NULL | |
| password | varchar(20) | YES | | NULL | |
| uid | int(11) | YES | | NULL | |
| gid | int(11) | YES | | NULL | |
| ftpdir | varchar(50) | YES | | NULL | |
| homedir | varchar(50) | YES | | NULL | |
+----------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)


I will appreciate if any help.

fg
p.s. If I remove all the lines start with SQL in my conf file,
the ftp server running fine. any idea?


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--0-2000556517-1116258334=:60881
Content-Type: text/html; charset=us-ascii

Hi,

 

I am trying to setup proftpd on linux with

mysql authentication. But not working,

here is the lines that I tried to put in my

proftpd.conf file:

 

SQLAuthenticate on
#the authenticate type is database
SQLAuthTypes PlainText Backend
#the URL, username, password for connecting to mysql
SQLConnectInfo dbname@192.168.0.6:3306 root password1
#might need default gid
SQLDefaultGID 50
#SQLDefaultHomedir
SQLDefaultUID 50
#SQLGroupInfo
#SQLGroupWhereClause
#SQLHomedirOnDemand
#SQLLog
#SQLLogFile
#SQLMinID
#SQLMinUserGID
#SQLMinUserUID

SQLUserInfo ftp_user username password uid gid ftpdir homedir

 

#############endofconf###################

 

I have a table inside mysql database with the following structure:

 

mysql> desc ftp_user;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(20) | YES  |     | NULL    |       |
| password | varchar(20) | YES  |     | NULL    |       |
| uid      | int(11)     | YES  |     | NULL    |       |
| gid      | int(11)     | YES  |     | NULL    |       |
| ftpdir   | varchar(50) | YES  |     | NULL   
|       |
| homedir  | varchar(50) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

 

I will appreciate if any help.

 

fg

p.s. If I remove all the lines start with SQL in my conf file,

the ftp server running fine. any idea?

 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--0-2000556517-1116258334=:60881--


-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
_______________________________________________
ProFTPD Users List
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html