https://wiki.isikhnas.com/index.php?action=history&feed=atom&title=Database_server_setup 2026-09-09T22:56:24Z Revision history for this page on the wiki MediaWiki 1.31.16 https://wiki.isikhnas.com/index.php?title=Database_server_setup&diff=821&oldid=prev 2014-02-25T03:27:38Z

<p>Created page with &quot;== Server hardware setup == This is based on the use of an EeePC netbook with no CD. It should be connected to the internet via an ethernet cable (wireless can be set up but i...&quot;</p> <p><b>Halaman baru</b></p><div>== Server hardware setup ==<br /> This is based on the use of an EeePC netbook with no CD. It should be connected to the internet via an ethernet cable (wireless can be set up but it is too much bother and not practical for a server). <br /> <br /> == Install the operating system ==<br /> # Download Ubuntu 12.04 Server edition iso<br /> # Download unetbootin for use on a windows machine<br /> # Create a boot USB stick with the Ubuntu image<br /> # Set the netbook's Bios to boot from the USB stick<br /> # Boot and install<br /> <br /> == Software configuration ==<br /> # Install OpenSSH so you can configure it via SSH over the network<br /> <br /> # sudo apt-get install openssh-server<br /> <br /> If you are connected to the LAN, you should now be able to continue configuration from a second machine over SSH. To check the IP address on the netbook<br /> <br /> # ifconfig<br /> <br /> Then on your main machine, use PuTTY to access the netbook at the specified address.<br /> <br /> # Install Postgresql 9.1<br /> It should be 9.2 but it is not easily available in apt, and postgis isn't available. To avoid compiling, we'll stick with 9.1<br /> <br /> # sudo apt-get install postgresql<br /> # sudo apt-get install postgis<br /> <br /> Continue configuration of SMS tools as indicated in SMS server setup guide.<br /> <br /> == Configure and restore the database ==<br /> <br /> === Download the database from the AWS server ===<br /> # change to the postgres user<br /> <br /> # sudo su postgres<br /> <br /> # export the entire database cluster<br /> <br /> # pg_dumpall &gt; /tmp/db_all_20130407.sql<br /> <br /> # compress it<br /> <br /> # gzip /tmp/db_all_20130407.sql<br /> <br /> # Use your local SFTP client to download the export file.<br /> # Uncompress it<br /> <br /> # gunzip db_all_20130407.sql.gz<br /> <br /> === Set up the local database and install the backup file ===<br /> <br /> # sudo su postgres<br /> # psql postgres &lt; db_all_20130407.sql<br /> # exit<br /> <br /> === Set up database access ===<br /> Edit pg_hba.conf<br /> <br /> # sudo nano /etc/postgresql/9.1/main/pg_hba.conf<br /> <br /> Add these lines<br /> <br /> host all angus 192.168.0.0/16 md5<br /> local isikhnas smsd peer<br /> <br /> Edit postgresql.conf<br /> <br /> # sudo nano /etc/postgresql/9.1/main/postgresql.conf<br /> <br /> Change the line to <br /> <br /> Listen = '*'<br /> <br /> Reload the configuration<br /> <br /> # sudo service postgresql restart</div>

Catriona