Na vytvorenie vlastného FTP servera je vytvorených mnoho ftp serverov, my sa pozrieme na najpoužívanejší – proFTPD. Znova bude tento návod písaný pre distribúciu Debian.
V návode si ukážeme ako prepojiť proFTPD s MySQL.
1, Inštalácia
apt-get install proftpd proftpd-mysql
2, Tabuľka proFTPD v MySQL
CREATE TABLE IF NOT EXISTS `ftpgroup` (
`groupname` varchar(16) NOT NULL default '',
`gid` smallint(6) NOT NULL default '5500',
`members` varchar(16) NOT NULL default '',
KEY `groupname` (`groupname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ProFTP group table';
INSERT INTO `ftpgroup` (`groupname`, `gid`, `members`) VALUES
('ftpgroup', 5500, 'ftpuser'),
('ftpgroup', 5500, 'ftpguest');
CREATE TABLE IF NOT EXISTS `ftpuser` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` varchar(32) NOT NULL default '',
`passwd` varchar(32) NOT NULL default '',
`uid` smallint(6) NOT NULL default '5500',
`gid` smallint(6) NOT NULL default '5500',
`homedir` varchar(255) NOT NULL default '',
`shell` varchar(16) NOT NULL default '/sbin/nologin',
`count` int(11) NOT NULL default '0',
`accessed` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`webminuid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ProFTP user table' AUTO_INCREMENT=101 ;
INSERT INTO `ftpuser` (`userid`, `passwd`, `uid`, `gid`, `homedir`, `shell`) VALUES
('username', 'password', 5500, 5500, '/dir/', '/sbin/nologin');
3, Spojenie proFTPD s MySQL
# Password type
SQLAuthTypes Plaintext
# Authentication type
SQLAuthenticate users
# Use only SQL when authenticating, and not the system's /etc/passwd
# If the user's information is not in SQL, they're not a user to use
# this server.
AuthOrder mod_sql.c
# DB connect info. Format: database_name@server_address database_username database_password
SQLConnectInfo database@localhost username password
# Default UID/GID. Change to suit needs.
SQLDefaultUID 5500
SQLDefaultGID 5500
# Mininum UID/GID. Change to suit needs.
SQLMinUserUID 33
SQLMinUserGID 33
# Database query. Format: ** defined below **
SQLUserInfo ftpuser userid passwd uid gid homedir shell
5, Dôležitá konfigurácia
UseIPv6 off
DefaultRoot ~
I truly appreciate this article. Great….
I think this is a real great article post.Really looking forward to read more. Awesome….
Recommeneded website…
below you’ll find the link to some sites that we think you should visit…
Check this out…
Here are some of the sites we recommend for our visitors…
iPhone 5…
[...]here are some links to sites that we link to because we think they are worth visiting[...]…
[...]the time to read or visit the content or sites we have linked to below the[...]……
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
Great Clips Coupons…
[...]following are a few hyper-links to websites online which I link to for the fact we feel they are worthwhile browsing[...]…
Read More…
[...]…Great Post…[...]…
Recommeneded websites…
Here you’ll find some sites that we think you’ll appreciate, just click the links over…
Great Clips Coupons…
[...]following are a handful of urls to internet websites which I link to as we feel they will be seriously worth visiting[...]…
News info…
I was reading the news and I saw this really interesting topic…
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Links…
[...]Sites of interest we have a link to[...]……
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Great Clips Coupons…
[...]here are a few url links to internet websites which I connect to seeing that we feel they’re worthwhile browsing[...]…
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Great Clips Coupons…
[...]below are a couple of web page links to web sites which we link to as we think they really are definitely worth browsing[...]…
Related……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out…
Here are some of the sites we recommend for our visitors…
Not a chance……
[...] Now any time a man or woman looks at the latest fashion assertion, it is normally measurement zero [...]…
[...]The information mentioned in the article are some of the best available [...]……
[...]below you’ll find the link to some sites that we think you should visit[...]……
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
Check this out……
[...] ordinarily posts some very interesting stuff such as this. If you’re not used to this page [...]…
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
Awesome website…
[...]the time to read or visit the content or sites we have linked to below the[...]……
közösségi portálok…
[...]while the sites we link to below are completely unrelated to ours, we think they are worth a read, so have a look[...]…
Superb website…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
Links…
[...]Sites of interest we have a link to[...]……
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
Hello!…
An interesting discussion is worth comment. I think that you should write more on this topic, it might not be a taboo subject but generally people are not enough to speak on such topics. To the next. Cheers…
Thank you…
I was very pleased to find this web-site.I wanted to thanks for your time for this wonderful read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you blog post….
Thank you…
I was very pleased to find this web-site.I wanted to thanks for your time for this wonderful read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you blog post….
hello…
you have a great blog here! would you like to make some invite posts on my blog?…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Websites you should visit…
[...]below you’ll find the link to some sites that we think you should visit[...]……
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
Read More…
[...]…Great Post…[...]…
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
aba…
ugg herren classic short schokoladencentimetres of surface area of the garment and the down to keep kids body warm and comfortable…
Great blog…
The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you coul…
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Superb website…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……