{"id":451,"date":"2016-09-16T14:41:35","date_gmt":"2016-09-16T14:41:35","guid":{"rendered":"http:\/\/myprojects.advchaweb.com\/?p=451"},"modified":"2017-02-14T05:15:29","modified_gmt":"2017-02-14T05:15:29","slug":"install-mapserver-on-ubuntu-14-04","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2016\/09\/16\/install-mapserver-on-ubuntu-14-04\/","title":{"rendered":"Install MapServer On Ubuntu 14.04"},"content":{"rendered":"

Prerequisite: Ubuntu 14.04, Apache Webserver 2.4 and php 5.6<\/p>\n

Install PostgreSQL. Read How To Install and Use PostgreSQL on Ubuntu 14.04<\/a>:<\/p>\n

    \n
  1. Update system\n
    sudo apt-get update<\/pre>\n<\/li>\n
  2. Install Postgres package and a “contrib” package that adds some additional utilities and functionality\n
    sudo apt-get install postgresql postgresql-contrib<\/pre>\n<\/li>\n
  3. PostgreSQL Roles and Databases
    \ncreated a user account called ‘postgres’<\/p>\n
    teddy@teddy-K43SJ:~$ sudo -i -u postgres<\/pre>\n
    get a Postgres prompt immediately by typing<\/p>\n
    postgres@teddy-K43SJ:~$ psql\r\npsql (9.3.14)\r\nType \"help\" for help.\r\n\r\npostgres=# \\q<\/pre>\n
    Type ‘\\q’ to quit! I can see my postgresql version is 9.3.14. Watch the above carefully! MY USER ALSO BE CHANGED FROM<\/span> ‘teddy@teddy-K43SJ’ to ‘postgres@teddy-K43SJ’! To quit completely, type ‘exit’<\/p>\n
    postgres@teddy-K43SJ:~$ exit\r\nlogout\r\nteddy@teddy-K43SJ:~$<\/pre>\n
    HERE WE DON’T THE PASSWORD FOR ‘postgres’ ROLE, SO ALTER IT (Read ‘How connect Postgres to localhost server using pgAdmin on Ubuntu?<\/a>‘)<\/p>\n
    teddy@teddy-K43SJ:~$ sudo -u postgres psql postgres\r\npsql (9.3.14)\r\nType \"help\" for help.\r\n\r\npostgres=# alter user postgres with password 'postgres';\r\nALTER ROLE\r\npostgres=# \\q<\/pre>\n
    SO (without quote) user = ‘postgres’ and password = ‘postgres’<\/p>\n
    Install pgadmin 3<\/p>\n
    teddy@teddy-K43SJ:~$ sudo apt-get install pgadmin3<\/pre>\n
    To open it, you can type : pgadmin3 or (better) go to Applications-> Programming->pgAdmin III<\/p>\n
    Create local connection with pgadmin:
    \n1. Click ‘Add a connection to a server’ or File->Add Server. Then fill it    \"psql-new-server\"<\/a>Click ‘OK’ and if everything right, here is the result\"psql-localhost\"<\/a>Create a new database. Select ‘Databases’->right click and click ‘New Database…’-> On ‘Name’ fill (for example) ‘testdb’\"psql-new-db\"<\/a>Then OK. There would be a ‘red cross’ on the database name. It’s fine. Just click it. Here is the structure\"psql-structure-db\"<\/a>Create a new table. We can do it from the structure above: Select ‘Tables’ -> right click and click ‘New Table…’ OR (better) from SQL Query\"psql-create-table\"<\/a>Here is the result of the new tabel ‘playground’ (DONT FORGET TO REFRESH FIRST)\"psql-table-playground\"<\/a>For more command and samples, read How To Install and Use PostgreSQL on Ubuntu 14.04<\/a> or watch this video