keeps / dbptk-desktop Goto Github PK

https://stackoverflow.com/a/19734810/10386423

If not installed notify the user it is a requirement

Steps to recreate the process:

1. Start DBPTK Desktop and stop its execution by closing down the application
2. Start another DBPTK Desktop
3. Go to the console and type:

$ ps aux | grep dbvtk
mguimar+ 22149 30.6  2.6 4606884 425732 ?      Sl   16:17   0:41 /tmp/.mount_dbptk-UFQRi0/resources/app.asar.unpacked/resources/jre/linux/x64/bin/java -jar -Dserver.port=0 -Dfile.encoding=UTF-8 -Dserver.port.file=/tmp/tmp-22066BzaxoMg3gZRW -Xmx147895296 -Denv=desktop -Djava.io.tmpdir=/tmp resources/war/dbvtk.war
mguimar+ 22277 30.8  2.4 4606884 391144 ?      Sl   16:17   0:38 /tmp/.mount_dbptk-AS4GXK/resources/app.asar.unpacked/resources/jre/linux/x64/bin/java -jar -Dserver.port=0 -Dfile.encoding=UTF-8 -Dserver.port.file=/tmp/tmp-22190bxJ8aqR6VkVV -Xmx147895296 -Denv=desktop -Djava.io.tmpdir=/tmp resources/war/dbvtk.war

Options:

• Enable only one instance of DBPTK Desktop
• When closing the DBPTK Desktop ensure that the process terminates before starting another one

Steps to recreate:

• install DBPTK Desktop via snap store (linux)
• Open the application
• Go to help > reports

This should open a folder with all the reports and it does nothing, fails internally

https://adoptopenjdk.net/releases.html

Needs to run via .execFile() due to ASAR. electron/electron#9459

Seems like quite a lot of databases have arrays in it. It is interesting that dbptk developer created siard but problem occurred when I tried to browse or validate this siard with dbptk Desktop.
com.databasepreservation.common.exceptions.ViewerException: Arrays are not yet supported.

Query:
... AND (c.relkind = ANY (ARRAY['r'::"char", 'v'::"char", 'm'::"char", 'f'::"char", 'p'::"char"])) AND...

ComposedTypeArray{elementType=Type{description='null', originalTypeName='DOUBLE PRECISION ARRAY', sql99TypeName='DOUBLE PRECISION', sql2008TypeName='DOUBLE PRECISION'}

Uploading to snap store is getting an error stating the token expired.

Provided credentials are no longer valid for the Snap Store.
Recommended resolution: Regenerate them and try again.

Estonian language does not appear in the menu, it must be created manually in the application-menu.js

Current action is not up-to-date and should be replaced by the official action: https://github.com/snapcore/action-build and https://github.com/snapcore/action-publish

Alternatively we can delegate the building action to snapcraft: https://snapcraft.io/docs/creating-snapcraft-yaml

Related to keeps/dbptk-ui#179

Hi
I have a SIARD-file with blobs included (mainly pdf, some docx). When on a document entry, I click on "Download" and get the following error message:

<apiResponseMessage>
    <message>RESTException: Remote exception caused by GenericException: Zip archive entry is missing</message>
    <type>error</type>
</apiResponseMessage>

Can someone give me a clue? Is there something wrong with the file, or might this be an application error?
Thanks

I have centos 7 with gnome and I get error when trying to install the app.

[laurir@hp45 shared]$ ./dbvtk-gui-1.1.0.AppImage
[25103:0807/090454.418821:FATAL:setuid_sandbox_host.cc(157)] The SUID sandbox helper binary was found, but is not configured correctly. Rather than run without sandboxing I'm aborting now. You need to make sure that /tmp/.mount_dbvtk-hs1uoc/chrome-sandbox is owned by root and has mode 4755.
Trace/breakpoint trap (core dumped)
[laurir@hp45 shared]$ ls -l /tmp/.mount_dbvtk-qfbEeb/chrome-sandbox
ls: cannot access /tmp/.mount_dbvtk-qfbEeb/chrome-sandbox: No such file or directory
[laurir@hp45 shared]$

https://www.electron.build/auto-update

Needs #2 as it need to be published

When an update is detected, the system needs to perform a restart, but there is a confirmation button to exit the application, making autoUpdater unable to update the application.

From: keeps/dbptk-ui#270

Description:
sqljdbc_auth is not present in DBPTK desktop java.library.path.

Better error messages needed. Especially regarding MS SQL server certificates which tend to be missing as default.

Browser (Internet explorer, Chrome, Firefox, etc):
DBPTK desktop

Browser version:
2.5.5 (latest)

Steps required to reproduce the bug:

Start app
Select "Use integrated login"
Select "Disable Encryption"

Attach any related screenshots below.

2021-04-15 08:48:28.429 INFO 14868 --- [ main] com.databasepreservation.DBVTK : Started DBVTK in 22.82 seconds (JVM running for 24.226)
2021-04-15 08:51:08.962 WARN 14868 --- [o-auto-1-exec-7] c.m.s.jdbc.internals.AuthenticationJNI : Failed to load the sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path

https://www.electron.build/icons

@jmaferreira can provide the icon images.

Description:
When an alternative DBPTK_HOME directory is specified and used by the environment variable option, then log and report is still locked to the C:\Users<username>.dbvtk\ path.

C:\Users<username>.dbvtk\log
C:\Users<username>.dbvtk\report

Steps required to reproduce the bug:

1. Use DBPTK Desktop v2.5.5 or v2.5.4 (expecting same error on earlier versions too)
2. Set DBVTK_HOME to another drive and folder than the defalt C:...
3. Choose menu: Help > Logs > DBPTK logs
4. Choose menu: Help > Reports

By default java will use 1/4th of the physical memory.
Use 3/4th of the physical memory, use Electron API to get available memory and Java -Xmx flag to increase it.

We are currently using Electron v4.2.5 which contains some vulnerabilities in the dependencies. To fix this is necessary change the version to the latest one, change the deprecated methods and update the integration with the DBPTK-UI

DBPT Desktop v2.5.10

• SIARD extraction from sakila demo database, MySQL: Success
• SIARD validation with [v] Skip additional checks "checked: Success
• Rerun of SIARD validation with [ ] Skip additional checks "unchecked": Failed

DBPTK Developer did skip additional checks, as if it remembers forever the first choice of checking it, and do not consider later run of validation with the option unchecked. I even deleted the validation report and started over, but still with no additional chekcs running.

I have created a SIARD archive from a MS SQL database which contains some arabic text (nvarchar). The text is exported correctly and I can see the arabic characters when I browse the data in the DBPTK GUI. However when I send the archive to a new MS SQL database the columns are created as varchar columns and consequently the arabic characters are not preserved but show as '????'. If I create the table in the database with nvarchar columns before sending the archive the arabic characters are imported correcly.

DBPTK Desktop v2.5.10

• SIARD extraction from testdb03 demo database, MySQL: Success
• EDIT METADATA button, opens the metadata for editing: Success
• Changing Name from "testb03" to "testdb03_test1": Success
• Buttons: CANCEL | SAVE | CLEAR => clicked SAVE: Success
• Dialog "Are you sure you want to update the metadata?" => Clicked "CONFIRM": Success
• Popup dialog: "Metadata was succesfully updated": Success
• Resulting buttons: CANCEL + greyed out SAVE and CLEAR: BUG

I believe the last button stage should display BACK instead of CANCEL.

The popup dialog for "..successfully updated" only shows for a few seconds, and on a large package the metadata update may take a while, hence it should both be written not as a short popup, as well as be changed button text to BACK.

From: keeps/dbptk-ui#184

Using DBPTK Desktop v2.5.9

• SIARD extraction Internal LOBs successful

• SIARD Validation Successful

• SIARD Browsing
  -- Import Succesful
  -- DELETE button within the Browsing fram fails with error:
  Uncaught Exception: (TypeError) : Cannot read property 'c' of null
  -- After this, using DELETE button outside the fram in lower bottom corner is successful
  Now finally the SIARD package is removed from DBPTK Desktop, though still at the file system which is good (did not want or ask it to delete the files themselves, only inside the DBPT Desktop file environment)

2021-08-14 07:25:49.490  INFO 3536 --- [o-auto-1-exec-3] c.d.c.server.controller.SIARDController  : Preparing the SIARD to be browsable (6d2486ea-9914-44d7-b1a7-4261a89469a2)
2021-08-14 07:25:49.490  INFO 3536 --- [o-auto-1-exec-3] c.d.c.server.controller.SIARDController  : starting to convert database C:\uttrekk-dbptk-desktop\version\v2.5.9\t01bclob11rtf_dbptk-desktop-2.5.9_int\t01bclob11rtf_dbptk-desktop-2.5.9_int.siard
2021-08-14 07:25:49.503  INFO 3536 --- [o-auto-1-exec-3] c.d.m.siard.in.input.SIARDImportDefault  : Importing SIARD version 2.1
2021-08-14 07:25:53.874  INFO 3536 --- [o-auto-1-exec-3] c.d.c.s.i.s.collections.RowsCollection   : Creating SOLR collection dbv-database-6d2486ea-9914-44d7-b1a7-4261a89469a2
2021-08-14 07:25:53.875  INFO 3536 --- [o-auto-1-exec-3] c.d.c.s.i.f.EmbeddedSolrClientFactory    : Creating SOLR collection dbv-database-6d2486ea-9914-44d7-b1a7-4261a89469a2
2021-08-14 07:25:54.269  INFO 3536 --- [o-auto-1-exec-3] c.d.c.s.i.f.EmbeddedSolrClientFactory    : SOLR collection dbv-database-6d2486ea-9914-44d7-b1a7-4261a89469a2 is loaded=
2021-08-14 07:25:54.270  INFO 3536 --- [o-auto-1-exec-3] c.d.c.server.index.schema.SchemaBuilder  : Updating dbv-database-6d2486ea-9914-44d7-b1a7-4261a89469a2 collection schema with 3 fields, 2 dynamic fields and 1 copy fields
2021-08-14 07:29:26.792  INFO 3536 --- [o-auto-1-exec-3] c.d.c.server.controller.SIARDController  : Conversion time 3m 37s
2021-08-14 07:29:26.792  INFO 3536 --- [o-auto-1-exec-3] c.d.c.server.controller.SIARDController  : Conversion to SIARD successful, database: 6d2486ea-9914-44d7-b1a7-4261a89469a2
2021-08-14 07:29:27.796 ERROR 3536 --- [o-auto-1-exec-6] c.d.c.client.ClientConfigurationManager  : [0:0:0:0:0:0:0:1] Requiring a shared property while they are not yet loaded
2021-08-14 07:39:34.560 ERROR 3536 --- [o-auto-1-exec-9] Uncaught                                 : [0:0:0:0:0:0:0:1] Uncaught Exception: (TypeError) : Cannot read property 'c' of null

java.lang.Throwable: null
	at Unknown.VG(DataPanel.java:136)
	at Unknown.XG(DataPanel.java:135)
	at Unknown.Ii(Column.java:165)
	at Unknown.F2c(AbstractCellTableBuilder.java:207)
	at Unknown.V3c(DefaultCellTableBuilder.java:130)
	at Unknown.z2c(AbstractCellTableBuilder.java:87)
	at Unknown.GEb(AbstractCellTable.java:2356)
	at Unknown.kFb(AbstractCellTable.java:2158)
	at Unknown.S2c(AbstractHasData.java:273)
	at Unknown.n4c(HasDataPresenter.java:1351)
	at Unknown.F4c(HasDataPresenter.java:984)
	at Unknown.J1b(SchedulerImpl.java:50)
	at Unknown.z1b(SchedulerImpl.java:279)
	at Unknown.n1b(Impl.java:385)
	at Unknown.m1b(Impl.java:376)
	at Unknown.anonymous(Impl.java:78)

https://www.electron.build/multi-platform-build#sample-travisyml-to-build-electron-app-for-macos-linux-and-windows

Also publish to GitHub and bintray
https://www.electron.build/configuration/publish

Related to keeps/dbptk-developer#299

I generated a SIARD archive from a SQL Server database, which I could successfully browse and validate. I exported it to a MySQL-Server. All the tables are generated with all the field, but just a few table are populated with records; others are completely empty. I use version 2.6.1.

Use download-progress event to capture information and feed to the user in a progress bar panel

links: https://www.electron.build/auto-update#event-download-progress

Related to keeps/dbptk-developer#474

• Add -Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBuilderFactoryImpl
• Replace -Djavax.xml.parsers.SAXParserFactory value with org.apache.xerces.jaxp.SAXParserFactoryImpl

Trying to browse a table after import (SIARD 2.1) and validation gives med a JSONException.

[JSONException] Error parsin JSON: SyntaxError: Unexpected token < in JSON at position 0

It is the same for all tables.

Any way to get past this?

I'm getting message - non supported character set (add orai18n.jar in your classpath) BLT8MSWIN1257.

I understand that DBPTK Desktop and Enterprise share the same code for displaying different forms and pages.
Now in Enterprise it is all ok as web browsers have "Back" button.
But in regular DBPTK Desktop if you search and click on different links (moving around according to foreign keys) then you can not go back to previous step. Few releases ago the regular browser shortcut Alt+Left-Arrow worked but at the moment you have to re-start your search process if you need previous results.

I am thinking that separate "Back" button is an idea or at least the "breadcrumb" should be clickable.