Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><a href="http://en.wikipedia.org/wiki/File_Transfer_Protocol#Protocol_overview" rel="nofollow">FTP Active Mode</a> by definition requires the server to initiate its outgoing connections from port <code>L-1</code>. Does your firewall allow outgoing connections from port <code>3520</code> as well?</p> <p>From the <a href="http://www.ietf.org/rfc/rfc959.txt" rel="nofollow">FTP RFC</a>:</p> <blockquote> <p>3.2. ESTABLISHING DATA CONNECTIONS</p> <pre><code> The mechanics of transferring data consists of setting up the data connection to the appropriate ports and choosing the parameters for transfer. Both the user and the server-DTPs have a default data port. The user-process default data port is the same as the control connection port (i.e., U). The server-process default data port is the port adjacent to the control connection port (i.e., L-1). </code></pre> <p>...</p> <p>3.3. DATA CONNECTION MANAGEMENT</p> <pre><code> Default Data Connection Ports: All FTP implementations must support use of the default data connection ports, and only the User-PI may initiate the use of non-default ports. Negotiating Non-Default Data Ports: The User-PI may specify a non-default user side data port with the PORT command. The User-PI may request the server side to identify a non-default server side data port with the PASV command. Since a connection is defined by the pair of addresses, either of these actions is enough to get a different data connection, still it is permitted to do both commands to use new ports on both ends of the data connection. </code></pre> </blockquote> <p>You might wish to take the opportunity to change your users to <a href="http://en.wikipedia.org/wiki/SSH_file_transfer_protocol" rel="nofollow">SFTP</a>, a much nicer protocol.</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to change ProFTPd port without using "passive mode"
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USsarnold
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. CO3520? No, the firewall is for "inbound" connections only, not "outgoing". I never had it enabled on port 20 either, but it works just find with only port 21 enabled. I just tried to enable it on 3520 too, just in case, but it's still not working.
      singulars
      1. PO
      1. UStechexpert
    2. COOk, I think I figured this out after reading this page: [link](http://slacksite.com/other/ftp.html). It appears that most FTP connections are indeed "passive" and the problem with "active" connections comes from the use of firewalls of the client since FTP server is initiating an outgoing "data" connection to the client on some **random** port. In passive mode the client initiates both "command" and "data" connections to the server and hence the firewall isn't a problem, but you should specify which "passive" ports to use on the server. I enabled 3520 and 3521 PassivePorts and it's now working
      singulars
      1. PO
      1. UStechexpert
    3. CO@techexpert, excellent :) I suggest moving your comment to an answer, so you can accept it, and hopefully it'll be that much more visible to others in the future. Thanks for the report. :)
      singulars
      1. PO
      1. USsarnold
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload