There are several ways to test your services hosted on your local DaCHS server. Here is a quick guide for this.

With a web browser

DaCHS provides a web interface to visualize and query your published tap services.

Open http://127.0.0.1 (or http://127.0.0.1:<port_numer> if you don't use the port 80).

Note: Several links may not be updated : refresh with ctr+F5, or even open a private session (Ctrl + Maj + P on Firefox).

You can check service metadata by clicking on the numerous tables link.

Or/and click on the link form-base ADQL (also accessible from the sidebar) and type an SQL query, for instance (replace "transplanet" by your actual service name):

select top 10 * from transplanet.epn_core

With TOPCAT

TOPCAT is an interactive graphical viewer and editor for tabular data and can be used to visualize an query your published services. It is supported on all OS and can be downloaded here.


1/ Click on the Open new table button on the icon menu:


2/ On the new window, click on Query remote databases using sql-like language button on the icon menu:



3/ From the Select service tab, fill the TAP URL field (on the bottom) with http://127.0.0.1/__system__/tap/run/tap (or http://127.0.0.1:<port_number>/__system__/tap/run/tap) and click on Use service button:


4/ Take a look to the DaCHS tables: do you see the <service_name>.epn_core table? Good. Now try to type an ADQL query on the bottom field, for example (again):

select top 10 * from transplanet.epn_core


5/ On the new window, click on the last element of the left panel : you can now visualize the results of your query.


With PGAdmin

Installation

pgAdmin is a postgreSQL client, it aims to provide a graphical interface to view and manage your databases. We will use this tool on section Setting up an EPN-TAP service. If you don't want to install pgAdmin on you computer, you can however use psql commands instead.

First, install pgAdmin on your host machine. If you are on Debian based distribution:


sudo apt-get install pgadmin3


Compiled sources are also available for MacOS and Windows.

You need pgAdmin v. 1.20 or upper in order to deal with postgreSQL 9.4. Once installed, check pgdmin version (Help menu, About).

Configuration

Check for the gavo user password by typing on the DaCHS server:


cat /var/gavo/etc/feed


Now start pgAdmin, then click on Add a connection to a server (power socket icon) and fill the fields as the following:

 TestProductionComment
Name DaCHS-testDaCHS As you want
Host127.0.0.1:<port_number><<my_server>>.<<my_domain>>
TCP port 5433
Service   leave empty
Base maintenancepostgres 
Use namegavoadmin
password******* Get it with the command above
save password  yes As you want

Usage

Now you should be able to see your database:


You can query them by clicking on the "SQL" button on the tool bar.

With the VESPA client

The VESPA client is a web site that allow you to query epn-tap services.

First scenario: your service is published to a registry:

Second scenario: your service is not published to a registry (but online):

Since the VESPA Client is open-source, it is also possible to download it and run a local instance of the client in order to query your local services. You can contact Cyril Chauvin from OBSPM for further information about how to install it.