{"id":2481,"date":"2012-07-24T00:23:09","date_gmt":"2012-07-24T00:23:09","guid":{"rendered":"http:\/\/craftydba.com\/?p=2481"},"modified":"2013-01-29T16:26:09","modified_gmt":"2013-01-29T16:26:09","slug":"configuring-a-ftp-server","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=2481","title":{"rendered":"Virtual Box &#8211; FTP Server Settings"},"content":{"rendered":"<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/virtual_box_icon.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/virtual_box_icon.jpg\" alt=\"\" title=\"virtual_box_icon\" width=\"128\" height=\"128\" class=\"alignleft size-full wp-image-4258\" \/><\/a><br \/>\nI am continuing work on <span style=\"color: #FF0000;\">PROJECT ALPHA<\/span> which is chartered to create a test environment for a <a href=\"http:\/\/www.perl.org\/\">PERL<\/a> based Etract Translate and Load (<a href=\"http:\/\/en.wikipedia.org\/wiki\/Extract,_transform,_load\">ETL<\/a>) solution.  <\/p>\n<p>If you have correctly followed the previous <a href=\"https:\/\/www.virtualbox.org\/\">Oracle Virtual Box<\/a> articles, a working guest image of <a href=\"http:\/\/en.wikipedia.org\/wiki\/Windows_Server_2008\">Windows 2008 Server<\/a> now exists with the <a href=\"http:\/\/en.wikipedia.org\/wiki\/IIS_7\">IIS 7.0<\/a> Web server role installed.  <\/p>\n<p>Today, we are going to concentrate on configuring the FTP server.  A local windows user account will have a home directory containing the test data file for the Perl program.<\/p>\n<p>The series of screen shots below will walk you through configuring the FTP Server installed on the guest image.<\/p>\n<p>Step 1 &#8211; IIS 7.0 Manager does not manager FTP settings.  Version 7.5 fixes this issue. <\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-0.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-0-1024x316.jpg\" alt=\"\" title=\"vb-new-ftp-0\" width=\"665\" height=\"205\" class=\"aligncenter size-large wp-image-2489\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-0-1024x316.jpg 1024w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-0-300x92.jpg 300w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-0.jpg 1070w\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" \/><\/a><\/p>\n<p>Step 2 &#8211; Create new FTP Site using IIS 6.0 Manager.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-1.jpg\" alt=\"\" title=\"vb-new-ftp-1\" width=\"660\" height=\"637\" class=\"aligncenter size-full wp-image-2490\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-1.jpg 660w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-1-300x289.jpg 300w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p>Step 3 &#8211; Choose FTP Site name.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-2.jpg\" alt=\"\" title=\"vb-new-ftp-2\" width=\"481\" height=\"374\" class=\"aligncenter size-full wp-image-2491\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-2.jpg 481w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-2-300x233.jpg 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/><\/a><\/p>\n<p>Step 4 &#8211; Select the IP address and port.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-3.jpg\" alt=\"\" title=\"vb-new-ftp-3\" width=\"488\" height=\"377\" class=\"aligncenter size-full wp-image-2492\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-3.jpg 488w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-3-300x231.jpg 300w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/a><\/p>\n<p>Step 5 &#8211; Use Isolate Users security.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-4.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-4.jpg\" alt=\"\" title=\"vb-new-ftp-4\" width=\"483\" height=\"372\" class=\"aligncenter size-full wp-image-2493\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-4.jpg 483w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-4-300x231.jpg 300w\" sizes=\"auto, (max-width: 483px) 100vw, 483px\" \/><\/a><\/p>\n<p>Step 6 &#8211; Select the default home directory.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-5.jpg\" alt=\"\" title=\"vb-new-ftp-5\" width=\"482\" height=\"376\" class=\"aligncenter size-full wp-image-2494\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-5.jpg 482w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-5-300x234.jpg 300w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/><\/a><\/p>\n<p>Step 7 &#8211; Allow users read\/write access.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-6.jpg\" alt=\"\" title=\"vb-new-ftp-6\" width=\"484\" height=\"374\" class=\"aligncenter size-full wp-image-2495\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-6.jpg 484w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-6-300x231.jpg 300w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/><\/a><\/p>\n<p>Step 8 &#8211; Set 10 user connections under site properties.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-7.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-7.jpg\" alt=\"\" title=\"vb-new-ftp-7\" width=\"464\" height=\"435\" class=\"aligncenter size-full wp-image-2496\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-7.jpg 464w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-7-300x281.jpg 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p>Step 9 &#8211; Uncheck anonymous connections under site properties.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-8.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-8.jpg\" alt=\"\" title=\"vb-new-ftp-8\" width=\"464\" height=\"436\" class=\"aligncenter size-full wp-image-2497\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-8.jpg 464w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-8-300x281.jpg 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p>Step 10 &#8211; Set welcome banner message under site properties.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-9.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-9.jpg\" alt=\"\" title=\"vb-new-ftp-9\" width=\"463\" height=\"440\" class=\"aligncenter size-full wp-image-2498\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-9.jpg 463w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-9-300x285.jpg 300w\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" \/><\/a><\/p>\n<p>Step 11 &#8211; Double check home directory settings.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-10.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-10.jpg\" alt=\"\" title=\"vb-new-ftp-10\" width=\"462\" height=\"438\" class=\"aligncenter size-full wp-image-2499\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-10.jpg 462w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-10-300x284.jpg 300w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>Step 12 &#8211; Create a local windows test account.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-11.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-11.jpg\" alt=\"\" title=\"vb-new-ftp-11\" width=\"391\" height=\"522\" class=\"aligncenter size-full wp-image-2500\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-11.jpg 391w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-11-224x300.jpg 224w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><\/a><\/p>\n<p>Step 13 &#8211; Create user directory with readme.txt test file.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-12.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-12.jpg\" alt=\"\" title=\"vb-new-ftp-12\" width=\"667\" height=\"520\" class=\"aligncenter size-full wp-image-2501\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-12.jpg 667w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-12-300x233.jpg 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p>Step 14 &#8211; Use windows FTP utility to perform test download.<\/p>\n<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-13.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-13.jpg\" alt=\"\" title=\"vb-new-ftp-13\" width=\"669\" height=\"408\" class=\"aligncenter size-full wp-image-2502\" srcset=\"https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-13.jpg 669w, https:\/\/craftydba.com\/wp-content\/uploads\/2012\/07\/vb-new-ftp-13-300x182.jpg 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p>In short, the FTP Server that comes with Windows Server 2008 is not as mature as the 7.5 release.  The default user directory is always located under the [Home Directory] \\ [Local User Directory] \\ [User Account Directory].  Since there is no active directory domain for our test server, only anonymous or local user isolation are available as security choices.  The later choice is more secure.<\/p>\n<p>Regardless of all these limitations, we now have a working <a href=\"http:\/\/en.wikipedia.org\/wiki\/Ftp_server\">FTP<\/a> server.  Next time, we are going to start creating routines for our PERL based ETL solution.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am continuing work on PROJECT ALPHA which is chartered to create a test environment for a PERL based Etract Translate and Load (ETL) solution. If you have correctly followed the previous Oracle Virtual Box articles, a working guest image of Windows 2008 Server now exists with the IIS 7.0 Web server role installed. Today, we are going to concentrate on configuring the FTP server. A local windows user account will have a home directory containing the test data file for the Perl program. The series of screen shots below&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[502,494,505,15,443,490,493,504,503],"class_list":["post-2481","post","type-post","status-publish","format-standard","hentry","category-other","tag-etl-project","tag-ftp-server","tag-iis-7-0","tag-john-f-miner-iii","tag-perl-script-2","tag-project-alpha","tag-virtual-box","tag-web-server","tag-windows-2008-server"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/2481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2481"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/2481\/revisions"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}