[Proftpd-user] help on setup proftpd with mysql on redhat linux

--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
[url]http://mail.yahoo.com[/url]
--0-2000556517-1116258334=:60881
Content-Type: text/html; charset=us-ascii

<DIV>Hi,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I am trying to setup proftpd on linux with</DIV>
<DIV>mysql authentication. But not working,</DIV>
<DIV>here is the lines that I tried to put in my</DIV>
<DIV>proftpd.conf file:</DIV>
<DIV>&nbsp;</DIV>
<DIV>SQLAuthenticate on<BR>#the authenticate type is database <BR>SQLAuthTypes PlainText Backend<BR>#the URL, username, password for connecting to mysql<BR>SQLConnectInfo dbname<A href="mailto:dbname@192.168.0.6:3306">@192.168.0.6:3306</A> root password1<BR>#might need default gid<BR>SQLDefaultGID 50<BR>#SQLDefaultHomedir<BR>SQLDefaultUID 50<BR>#SQLGroupInfo<BR>#SQLGroupWhereClause<BR>#SQLHomedirOnDemand<BR>#SQLLog<BR>#SQLLogFile<BR>#SQLMinID<BR>#SQLMinUserGID<BR>#SQLMinUserUID </DIV>
<DIV>SQLUserInfo ftp_user username password uid gid ftpdir homedir<BR></DIV>
<DIV>&nbsp;</DIV>
<DIV>#############endofconf###################</DIV>
<DIV>&nbsp;</DIV>
<DIV>I have a table inside mysql database with the following structure:</DIV>
<DIV>&nbsp;</DIV>
<DIV>mysql&gt; desc ftp_user;<BR>+----------+-------------+------+-----+---------+-------+<BR>| Field&nbsp;&nbsp;&nbsp; | Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Null | Key | Default | Extra |<BR>+----------+-------------+------+-----+---------+-------+<BR>| username | varchar(20) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| password | varchar(20) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| uid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(11)&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| gid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(11)&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| ftpdir&nbsp;&nbsp; | varchar(50) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>| homedir&nbsp; | varchar(50) | YES&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<BR>+----------+-------------+------+-----+---------+-------+<BR>6 rows in set (0.00 sec)<BR></DIV>
<DIV>&nbsp;</DIV>
<DIV>I will appreciate if any help.</DIV>
<DIV>&nbsp;</DIV>
<DIV>fg</DIV>
<DIV>p.s. If I remove all the lines start with SQL in my conf file,</DIV>
<DIV>the ftp server running fine. any idea?</DIV>
<DIV>&nbsp;</DIV><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam? Yahoo! Mail has the best spam protection around <br>[url]http://mail.yahoo.com[/url]
--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!
[url]http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click[/url]
_______________________________________________
ProFTPD Users List <proftpd-users@proftpd.org>
Unsubscribe problems?
[url]http://www.proftpd.org/list-unsub.html[/url]