How to setup Asterisk 1.6.2 on CentOS 5.4

The link below will be very helpful.
Setup Asterisk on CentOS
- Rosh (May 7, 2010)


Install and Set up Postgresql DB in Ubuntu 9.04

Open a terminal window, and type the following command to install it:

rosh@rosh-desktop:~$ sudo apt-get install postgresql

Make a dicrectory to keep db sources (You don't have to have same path and directory name as I have):

rosh@rosh-desktop:~$ mkdir /usr/local/pgsql/data

Change the owner of directory:

rosh@rosh-desktop:~$ chown postgres /usr/local/pgsql/data

Also, you can change both the owner and the group information of 'data' directory if you want or need:

rosh@rosh-desktop:~$ chown postgres:postgres /usr/local/pgsql/data

Switch user to postgres:

rosh@rosh-desktop:~$ su - postgres

Initialize the DB server:

postgres@rosh-desktop:~$ /usr/lib/postgresql/8.3/bin/initdb -D /usr/local/pgsql/data

Create new DB (You can pick any db name instead of using 'db'):

postgres@rosh-desktop:~$ /usr/lib/postgresql/8.3/bin/createdb db

Create new user (You can pick any user name instead of using 'user'):

postgres@rosh-desktop:~$ createuser -U postgres -d -P user

Exit from the DB and run it::

postgres@rosh-desktop:~$ exit
rosh@rosh-desktop:~$psql -s db

Done!

Here is the options I used above,

psql

-s(--single-step): Run in single-step mode. That means the user is prompted before each command is sent to the server, with the option to cancel execution as well. Use this to debug scripts.

createuser

-d(--createdb): The new user will be allowed to create databases.
-P(--pwprompt): If given, createuser will issue a prompt for the password of the new user. This is not necessary if you do not plan on using password authentication.
-U(--username): User name to connect as (not the user name to create).

- Rosh (February 04, 2010) - Source from Jongchun Park


Syntax Highlighting File for UltraEdit

If you installed the UltraEdit, and its 'Syntax Highlighting' is not set, the link below will be very helpful.
Adding a Wordfile
- Rosh (September 1, 2009)


Java Problem in Eclipse - "Scanner cannot be resolved to a type"

If you have an error message above while running Java program, you might have a lower version of JRE than Java6, and so you need to correct it.
Follow the processes to solve it. Done!

- Rosh (March 27, 2009)


Install Apache Sever on Ubuntu

Open a terminal window, and type the following command:

rosh@rosh-desktop:~$ sudo apt-get install apache2

If you are running PHP you will also need to install the php and php module for apache:

rosh@rosh-desktop:~$ sudo apt-get install libapache2-mod-php5

rosh@rosh-desktop:~$ sudo apt-get install php5

Then, restart the service.

rosh@rosh-desktop:~$ sudo /etc/init.d/apache2 restart

Done!
Now your web files will be found in /var/www/.

- Rosh (March 06, 2009)


Install MySQL-SERVER on Ubuntu

Open a terminal window, and type the following command:

rosh@rosh-desktop:~$ sudo apt-get install mysql-server

If you are running PHP you will also need to install the php module for mysql:

rosh@rosh-desktop:~$ sudo apt-get install php5-mysql

Done!

- Rosh (March 04, 2009)