Re: [basyx-dev] Tests of basys.components failed.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]

Re: [basyx-dev] Tests of basys.components failed.

From: <Frank.Schnicke@xxxxxxxxxxxxxxxxxx>
Date: Wed, 15 May 2019 07:01:13 +0000
Accept-language: de-DE, en-US
Delivered-to: basyx-dev@xxxxxxxxxxx
List-archive: <https://www.eclipse.org/mailman/private/basyx-dev>
List-help: <mailto:basyx-dev-request@eclipse.org?subject=help>
List-subscribe: <https://www.eclipse.org/mailman/listinfo/basyx-dev>, <mailto:basyx-dev-request@eclipse.org?subject=subscribe>
List-unsubscribe: <https://www.eclipse.org/mailman/options/basyx-dev>, <mailto:basyx-dev-request@eclipse.org?subject=unsubscribe>
Thread-index: AQHVClULkrFM41LMO02X1oa6gDCLOqZrvADQ
Thread-topic: [basyx-dev] Tests of basys.components failed.

Dear Antony,

you are right, the database is missing. We are currently working on creating the database dynamically within the tests and deleting it afterwards again.

Until this is available, you can use e.g. postgreSQL https://www.postgresql.org/ and the following commands to setup the database.

Create configuration directory:

initdb -D "*PATH*" -U *USER*

default user: postgres

Start database:

pg_ctl -D "*PATH*" start

Connect command line to running instance:

psql - U *USER*

Create and fill database:

CREATE DATABASE "basyx-map";

\c basyx-map

CREATE SCHEMA elements;

CREATE DATABASE "basyx-directory";

\c basyx-directory

CREATE SCHEMA directory;

CREATE TABLE directory.directory ( "ElementRef" varchar(999999), "ElementID" varchar(999999) primary key );

INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-19', '{content.aas1}' );

INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-18', '{content.aas2}' );

INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-17', '{content.aas3}' );

INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-16', '{content.aas4}' );

INSERT INTO directory.directory ( "ElementID", "ElementRef" ) VALUES ( 'urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-15', '{content.aas5}' );

Best regards,

Frank

----------------------------------------------------------------------------------

M.Sc. Frank Schnicke

Department ESW

Fraunhofer IESE

Fraunhofer-Platz 1 | 67663 Kaiserslautern

Phone: +49 631 / 6800-2259 | Fax: +49 631 / 6800-9-2259

www.iese.fraunhofer.de

Mail: frank.schnicke@xxxxxxxxxxxxxxxxxx

Von: basyx-dev-bounces@xxxxxxxxxxx <basyx-dev-bounces@xxxxxxxxxxx> Im Auftrag von antony liu
Gesendet: Dienstag, 14. Mai 2019 15:01
An: basyx-dev <basyx-dev@xxxxxxxxxxx>
Betreff: [basyx-dev] Tests of basys.components failed.

Hi all,

When I try to run test TestDirectorySQLProvider.testCreateDeleteCall() of then basys.components project, I got error. It seems to be missing the database "basyx-directory". Where can I find the database schema?

The error message is:

Started BaSyx HTTP Server!

Deleting:api/v1/registry/urn:de.FHG:es.iese:aas:0.98:5:lab/microscope#A-166

May 14, 2019 8:38:04 PM org.postgresql.core.v3.ConnectionFactoryImpl log

WARNING: SQLException occurred while connecting to localhost:5432

org.postgresql.util.PSQLException: FATAL: database "basyx-directory" does not exist

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)

at org.postgresql.core.v3.QueryExecutorImpl.readStartupMessages(QueryExecutorImpl.java:2566)

at org.postgresql.core.v3.QueryExecutorImpl.<init>(QueryExecutorImpl.java:131)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:210)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)

at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)

at org.postgresql.Driver.makeConnection(Driver.java:452)

at org.postgresql.Driver.connect(Driver.java:254)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at org.eclipse.basyx.components.sqlprovider.driver.SQLDriver.sqlUpdate(SQLDriver.java:122)

at org.eclipse.basyx.components.servlets.SQLDirectoryServlet.doDelete(SQLDirectoryServlet.java:450)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:713)

at org.eclipse.basyx.vab.backend.server.http.BasysHTTPServlet.service(BasysHTTPServlet.java:43)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

May 14, 2019 8:38:04 PM org.postgresql.Driver connect

SEVERE: Connection error: