Installing mysql-server

> apt-get install mysql-server

follow instructions and enter new password for mysql admin.

Install php-myadmin

> apt-get install phpmyadmin

select lighttpd using spacebar then hit enter. when it asks to configure database for phpmyadmin, select yes. it will then ask for your mysql password, and ask you to set phpmyadmin password .

Install ftp server

> apt-get install vsftpd
> nano /etc/vsftpd.conf

[change the following: you have to remove # from the front of the line]

* anonymous_enable=NO
* local_enable=YES
* chroot_local_user=YES

[press crtl-x to exit and save]

> /etc/init.d/vsftpd restart [1][2]

Notes:

  1. [1] just by running vsftpd restart will give you a OOPs 500 error. You need to put “service” before vsftpd
  2. [2] or you can run > service vsftpd restart
  3. seems like vsftpd or other ftp software hooks onto user accounts. so for web servers, each domain should have a ftp account
  4. remember to set chroot
  5. by default openssh should be installed on ubuntu

FTPS for VSFTPD (Very secure ftp daemon)

Note that ftps is different from sftp.

> mkdir /etc/vsftpd
> openssl req -x509 -nodes -days 365 -newkey rsa:1024 -keyout /etc/vsftpd/vsftpd.pem -out /etc/vsftpd/vsftpd.pem
> chmod 600 /etc/vsftpd/vsftpd.pem
> nano /etc/vsftpd.conf

[Add in or make sure the following is uncommented.]

ssl_enable=YES
allow_anon_ssl=NO
force_local_data_ssl=YES
force_local_logins_ssl=YES
require_ssl_reuse=NO
# need require ssl reuse otherwise you get errors when you are editing files using ftps
# error “vsftpd: SSL connection failed session reuse required”
ssl_tlsv1=YES
ssl_sslv2=YES
ssl_sslv3=YES
rsa_cert_file=/etc/vsftpd/vsftpd.pem
listen_port=21
#you can use any port, filezilla defaults to port 21. So does wordpress
pasv_min_port=20000
pasv_max_port=20999
# you will need this pasv, otherwise when you set up firewall, you get ftp connection problems. as a sample use 20000 – 20999

> /etc/init.d/vsftpd restart

now you can ftp into your system using port 990 with ftps

Notes:

  1. Ref: http://ubuntuforums.org/showthread.php?t=518293