Information for Users
Information for Installers
- Server Installation
Project Documentation
For a local oracle-xe installation the following values of driver and dbProperties should be good except for the user and password values:
driver=oracle.jdbc.pool.OracleDataSourceNote the "'" which is needed because the url contains colons which also separate individual properties.
For MySQL:
driver=com.mysql.jdbc.jdbc2.optional.MysqlDataSourceConnect to the https://<your host name>:8181/TopCATAdmin (or https://<your host name>:8181/<your topcatAdminUrlRoot> ). You will be prompted for a username and password.
Go to https://<[your host name]>:8181/TOPCATWeb.jsp (or https://<your host name>:8181/<your topcatUrlRoot>/TOPCATWeb.jsp) and try logging in to one of the configured ICATs if you have a login on one of them.
In case of problems look at the log files: server.log, topcat.log and topcat_admin.log all of which can both be found in the logs directory below your domain.
The following changes have been made to the schema in topcat 1.12.0:
To upgrade an existing database from topcat 1.11.0 to 1.12.0, run the following sql queries for your particular database:
Oracle:
ALTER TABLE TOPCAT_ICAT_SERVER ADD (ALLOW_UPLOAD NUMBER(1), ALLOW_CREATE_DATASET NUMBER(1));
ALTER TABLE TOPCAT_USER_DOWNLOAD ADD MESSAGE VARCHAR2(255);
MySql:
ALTER TABLE TOPCAT_ICAT_SERVER ADD (ALLOW_UPLOAD TINYINT(1), ALLOW_CREATE_DATASET TINYINT(1));
ALTER TABLE TOPCAT_USER_DOWNLOAD ADD MESSAGE VARCHAR(255);
Derby:
ALTER TABLE TOPCAT_ICAT_SERVER ADD (ALLOW_UPLOAD SMALLINT, ALLOW_CREATE_DATASET SMALLINT);
ALTER TABLE TOPCAT_USER_DOWNLOAD ADD MESSAGE VARCHAR(255);
The following are two examples of Apache 2.4 reverse proxy settings for topcat and topcatadmin. One for when topcat and topcatadmin is deployed using the default path and the other when a custom path is used
Using default install paths:
topcatUrlRoot=
topcatAdminUrlRoot=
ProxyPreserveHost on
SSLProxyEngine on
SSLProxyCheckPeerCN off
SSLProxyCheckPeerName off
SSLProxyCACertificateFile
conf/ssl.crt/topcat.crt
ProxyPass /topcat/ https://localhost:8181/
ProxyPassReverse /topcat/ https://localhost:8181/
ProxyPassReverseCookiePath / /topcat
ProxyPass /topcatadmin/ https://localhost:8181/TopCATAdmin/
ProxyPassReverse /topcatadmin/
https://localhost:8181/TopCATAdmin/
<Location /topcat/>
RequestHeader edit X-GWT-Module-Base ^(.*)/topcat/(.*)$ $1/$2
</Location>
<Location /topcatadmin/>
RequestHeader edit X-GWT-Module-Base ^(.*)/topcatadmin/(.*)$ $1/TopCATAdmin/$2
</Location>
<Proxy *>
Allow from All
Require all granted
</Proxy>
Using custom install paths:
topcatUrlRoot=/<your topcat path>
topcatAdminUrlRoot=/<your topcatadmin path>
ProxyPreserveHost On
SSLProxyEngine on
SSLProxyCheckPeerCN off
SSLProxyCheckPeerName off
SSLProxyCACertificateFile
conf/ssl.crt/topcat.crt
ProxyPass /topcat/ https://localhost:8181/<your topcat path>/
ProxyPassReverse /topcat/
https://localhost:8181/<your topcat path>/
ProxyPassReverseCookiePath /<your topcat path> /topcat
ProxyPass
/topcatadmin/ https://localhost:8181/<your topcatadmin path>/
ProxyPassReverse /topcatadmin/
https://localhost:8181/<your topcatadmin path>/
<Location /topcat/>
RequestHeader edit X-GWT-Module-Base
^(.*)/topcat/(.*)$ $1/<your topcat path>/$2
</Location>
<Location /topcatadmin/>
RequestHeader edit
X-GWT-Module-Base ^(.*)/topcatadmin/(.*)$ $1/<your topcatadmin path>/$2
</Location>
<Proxy *>
Allow from All
Require all granted
</Proxy>
Upload functionality in topcat requires the latest IDS 1.1.0 .
File upload is achieved via a cross-domain mechanism where files are uploaded directly to your configured IDS from the browser. In order for this to work, your IDS must have a CA certificate. If you are using a self-signed certificate on a test IDS installation, you must add the IDS certificate to your browser's trusted store for upload to work properly. If you do not add the certificate to your browser's trusted store, you will get a never ending upload progress bar because topcat cannot retrieve the server response from the IDS.
The upload functionality can be enabled/disabled in topcatadmin.