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:
Test | Production | Comment | |
---|---|---|---|
Name | DaCHS-test | DaCHS | As you want |
Host | 127.0.0.1:<port_number> | <<my_server>>.<<my_domain>> | |
TCP port | 5433 | ||
Service | leave empty | ||
Base maintenance | postgres | ||
Use name | gavoadmin | ||
password | ******* | Get it with the command above | |
save password | yes | As you want |
Usage
Now you should be able to see your database:
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:
- tab
All VO
(main page); - eventually, fill filter fields as your needs (not required);
- then click on
Submit
; - click on your service on the list.
Second scenario: your service is not published to a registry (but online):
- tab
Custom ressource
; - fill the
URL
field: for instance,http://cdpp-epntap.irap.omp.eu/__system__/tap/run/tap
; - fill the
schema
field: for instance,transplanet
; - eventually, fill some other filter fields (not required);
- click on your service on the list.
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.