Ubuntu server 12.04/ftp
From Attie's Wiki
(Difference between revisions)
(Created page with "Ubuntu Server 12.04 <source lang="bash"> apt-get install pure-ftpd-mysql </source> ==Control The Server== <source lang="bash"> service pure-ftpd-mysql...") |
m (→Configure the Server) |
||
| Line 34: | Line 34: | ||
\`Username\` char(32) NOT NULL, | \`Username\` char(32) NOT NULL, | ||
\`Password\` char(32) NOT NULL, | \`Password\` char(32) NOT NULL, | ||
| − | \` | + | \`Dir\` char(128) NOT NULL, |
| − | \` | + | \`Uid\` char(16) NOT NULL, |
| − | \` | + | \`Git\` char(16) NOT NULL, |
PRIMARY KEY (\`id\`) | PRIMARY KEY (\`id\`) | ||
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; | ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; | ||
EOF | EOF | ||
</source> | </source> | ||
Revision as of 15:00, 7 May 2012
apt-get install pure-ftpd-mysql
Control The Server
service pure-ftpd-mysql restart
Configure the Server
export username=ftpd export password=xxx export database=sys_ftpd sed -ri /etc/pure-ftpd/db/mysql.conf \ -e "s/^(MYSQLUser ).*\$/\1$username/" \ -e "s/^(MYSQLPassword ).*\$/\1$password/" \ -e "s/^(MYSQLDatabase ).*\$/\1$database/" \ -e "s/^(MYSQLCrypt ).*\$/\1md5/" mysql --user=root -p <<EOF CREATE DATABASE $database; CREATE USER '$username'@'localhost' IDENTIFIED BY '$password'; GRANT ALL PRIVILEGES ON $database.* TO '$username'@'localhost' WITH GRANT OPTION; USE $database; CREATE TABLE \`users\` ( \`id\` int(10) unsigned NOT NULL AUTO_INCREMENT, \`Username\` char(32) NOT NULL, \`Password\` char(32) NOT NULL, \`Dir\` char(128) NOT NULL, \`Uid\` char(16) NOT NULL, \`Git\` char(16) NOT NULL, PRIMARY KEY (\`id\`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; EOF
