When working on writing some directions for someone at work I ran into a PostgreSQL command line query error. I have much more experience using MySQL so my initial Postgres commands always mimic what I would do in MySQL. Anyhow when attempting to run a SELECT statement matching contents of a specific column I received the error below. After a little research I came up with the answer fairly easily but wanted to note here to help others out and serve as a reference point if I forgot the proper PSQL query in the future. Below I describe the query that caused the error, the error returned by Postgres, and the proper query to use when attempting to match a variable in a Postgres SELECT statement.
Read the rest of this entry »

I was tasked with configuring VSFTPD to allow SFTP or FTPES (FTP over explicit TLS/SSL) tonight for a client. The configuration already had regular FTP working which I verified using FileZilla as an FTP client. I was able to login and transfer files in both directions to and from the server. Next I verified that SFTP worked without issue and I was able to also transfer files in both directions using SFTP. For FTPES I had to make some changes and once I did make the changes I was still getting an error when attempting to do a directory listing using FileZilla. Below I describe the initial changes I made to vsftpd.conf, the errors I received attempting to connect with FTPES, and the way I resolved the problem.
Read the rest of this entry »

Use lftp for Linux command line FTP with explicit TLS/SSL. I was still having trouble though with lftp and implicit TLS/SSL. Below is the command to use lftp to connect to an FTP server that requires an explicit TLS/SSL.

Command:
lftp -du user,password ftp.example.com

You should see the below after connecting. Type ls to see if you get a directory listing and everything has worked.
lftp user@ftp.example.com:~> ls

Thats pretty much it. I will post in the future about lftp and implicit TLS/SSL connections.