reset password

Set Up Ubuntu Server 10.04

.bashrc

umask 077
alias dir="ls -lX"

SSH Public Key Authentication

Copy over the public key, then

> mkdir .ssh
> cat key.pub >> .ssh/authorized_keys

Packages

> dpkg -l
> sudo apt-get remove cups
> sudo apt-get remove openjdk*
> sudo apt-get install nmap
> sudo apt-get autoremove

Java

Edit /etc/apt/sources.list and uncomment the following two lines:

deb http://archive.canonical.com/ubuntu lucid partner
deb-src http://archive.canonical.com/ubuntu lucid partner

Then

> sudo apt-get update
> sudo apt-get install sun-java6-jdk

Tomcat

> sudo apt-get install tomcat6

Once installed, Tomcat will be running at port 8080. The webapp directory is at /var/lib/tomcat6/webapps/ and the configuration files are under /etc/tomcat6/.

Then install MySQL JDBC driver:

> sudo apt-get install mysql-java

The JAR file will be under /usr/share/java with many other JAR files.

MySQL and phpMyAdmin

If MySQL is not installed already:

> sudo apt-get install mysql-server

To change the root password:

> sudo dpkg-reconfigure mysql-server-5.1

Log into MySQL and create an account and a database for the user:

> mysql -u root -p
mysql> create database cysun;
mysql> grant all privileges on cysun.* to 'cysun'@'%' identified by 'abcd' with grant option;
mysql> flush privileges;
mysql> quit

Note that the GRANT statement will automatically create the user account if it does not exist.

Now install phpMyAdmin:

> sudo apt-get install phpmyadmin

During configuration you'll need to provide the root password of MySQL. After phpMyAdmin is installed, it can be accessed at http://host/phpmyadmin/ .

PostgreSQL

If PostgreSQL is not installed already:

> sudo apt-get install postgresql

Log into PostgreSQL and create an account and a database for the user:

> sudo -u postgres psql template1
psql> create user cysun with createdb password 'abcd';
psql> create database cysun with owner=cysun;
psql> \q

Leave out the createdb option in the CREATE USER statement if you do not want to grant the user the privilege to create databases.

This page has been viewed 33209 times.