QUICKSTART & PASSWORDS
Version - 20160528
Written by Ricardo Pinho
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License
INDEX
Open QGIS sample project to view the included Natural Earth data
Add a new PostGIS layer from GISVM to your QGIS project
Upload a new PostGIS layer to GISVM using QGIS
Upload a new PostGIS layer to GISVM using SHP2PGSQL
Using phpPgAdmin to manage the PostgreSQL server
Using pgAdmin III to manage the PostgreSQL server
Using Webmin to manage the Ubuntu operating system
Use the local site to get more information on using GISVM
REMEMBER, USE GISVM AT YOUR OWN RISK.
Ubuntu 14.04.4 LTS Server 32bit
| |
PostgreSQL 9.5.3
|
LOGIN | PASSWORD | URL | |
Ubuntu shell (&sudo) | gisvm | gisvm | http://gisvm:4200 |
Local site (Apache2) | gisvm | gisvm | |
PostgreSQL (Database: postgis) | postgres | gisvm | |
Webmin | gisvm | gisvm | |
Samba share (/home/gisvm/gisdata) (/samba/gisdata) | (Windows Shortcut) \\gisvm\gisdata |
Three simple steps: Download, unzip and run
GIS Virtual Machine is a complete and independent computer on a file.
It is optimized to use less than 2 GB of space on your disk at start.
You can download and get it in a compacted 7z file that is less than 200 MB.
After download it you must uncompress the 7z file.
You must have a uncompress program installed or install 7z available as free software:
http://www.7-zip.org/download.html
To run it you must have a Virtual Machine Player installed or install a free available:
- Install VirtualBox, available as free software:
https://www.virtualbox.org/wiki/Downloads
- Or install VMware Player, available for free:
https://www.vmware.com/go/downloadplayer
Or just double click the file “gisvm.vmx” found inside the gisvm unpacked folder.
Use the QGIS installed on your computer or on any other computer at your network, to open the included QGIS sample project file: “gisvm qgis example.qgs” found in the qgis subfolder inside the gisvm unpacked folder.
Note: If you don’t have QGIS installed, just download it from the official site and install it, it’s free software: http://www.qgis.org/
When you open the project all the data is store on the gisvm virtual machine, inside the “postgis” database, using several tables from the “ne” schema.
To create a new PostGIS connection on QGIS, simply type: Name = gisvm ; Host = gisvm ; Database = postgis ; Username = postgres ; Password = gisvm
You can also activate: Save Username & Save Password so you don’t have to type in each type you use the connection.
After creating the connection just select it (gisvm) and click on Connect to display all tables (layers) available to add to your project.
Add any layer to your QGIS project, for example, the roads shapefile (ne_10m_roads.zip) from Natural Earth dataset: http://www.naturalearthdata.com/downloads/10m-cultural-vectors/
Use the DB Manager tool, in the Database menu, to import a PostGIS vector layer to GISVM
The ne_10m_roads layer (table) is now available to be used from PostGIS on GISVM, and you can add it to your QGIS project, just like on the previous example:
Add any shapefile layer PostGIS database with the included command line tool: shp2pgsql, for example, the airports shapefile (ne_10m_airports.zip) from Natural Earth dataset: http://www.naturalearthdata.com/downloads/10m-cultural-vectors/
Just download, extract and copy it inside GISVM, into ”gisdata” shared folder: \\gisvm\gisdata
Go into gisvm terminal in Virtualbox or VMware player window and login as gisvm, password = gisvm. You can also use your browser with shellinabox: http://gisvm:4200
After login, change directory to where you saved the shp file (cd gisdata/ne_10_airports)
To upload the shp file into the postgis database, inside the ne schema, to the ne_10m_airtports table, type or copy&paste the following command line:
shp2pgsql -s 4326 -D -I -W "latin1" ne_10m_airports.shp ne.ne_10m_airports | psql -h localhost -d postgis -U postgres
When it asks for the postgres password, type: gisvm
You can then add it to your QGIS project:
GISVM comes installed with two great full feature administration tools that can be used to manage it completely: phpPgAdmin and Webmin
To manage the PostgreSQL running inside the GISVM you can use the included web application phpPgAdmin: http://gisvm/phppgadmin, login with postgres, password = gisvm
After login just navigate through postgis database, ne schema and ne_10m_airports table.
It allows the execution of all kinds of PostgreSQL operations, like browse and edit the data, add a new column or DROP (delete) the table.
If you have installed the pgAdmin III on your computer you can also use it to manage the PostgreSQL server running on GISVM. If you don’t, you can install it for free from:
http://www.postgresql.org/ftp/pgadmin3/release/v1.22.0/
Run pgAdmin and create a new Server Registration with: Name: gisvm , Host: gisvm , Username: postgres , Password: gisvm
Then use that connection to access the PostgreSQL server running in GISVM:
To manage the ubuntu operating system in GISVM just use the included web application Webmin inside your browser: http://gisvm:10000
Login with: gisvm and password: gisvm
After login you can completely manage the GISVM virtual machine, make updates, create new users, restart running services, configure network, server applications like SAMBA:
GISVM comes with a simple internal site with more information and several other links to help you start using it: http://gisvm
THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
THIS INFORMATION IS BEING GIVEN TO YOU GRATUITOUSLY AND THERE IS NO AGREEMENT OR UNDERSTANDING BETWEEN YOU AND THE GISVM PROJET OR ME (RICARDO PINHO) REGARDING YOUR USE OR MODIFICATION OF THIS INFORMATION BEYOND THE CREATIVE COMMONS ATTRIBUTION-SHAREALIKE 3.0 UNPORTED LICENSE (CC BY-SA)
Please visit the GISVM project site regularly
to get updates and help us make it better!
Thank you for using it.
THAT’S IT, HAVE FUN !!!!!!!!!
GISVM 14.04 POSTGIS - QUICKSTART & PASSWORDS by Ricardo Pinho - ricardo.pinho@gisvm.com This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License |