Hello Guys,
I have just discovered Ubooquity and I'm loving it so far, but I have noticed that most people are using Ubooquity on their home networks and it's not exposed to the internet. but I only own a VPS and I was wondering if it's safe to run the application on my VPS and have it exposed to the internet

Any suggestions will be much appreciated

Hi all,

I've had a few issues with some folders, that were not imported at first launch. I fixed them, then did another scan, the logs shows "Inserting/updating comic entry in database : bmlablabla"

but they don't show up at all in the library

Comme pour suivre où on es est sur Netflix ou prime ou mycanal ..

Une coche verte = déjà lu (si tout lu: coche aussi sur le dossier conteneur)

une légère ligne blanche au bas du livre à la grandeur proportionnelle du% de lecture

une section "en cours" dans l'accueil a coté de comics raw etc

I decided to convert a bunch of my CBZ from containing JPG files to WEBP files, with the idea that it could save space without sacrificing quality. Doing so really cranked up the memory requirements of Ubooquity. Before using WEBP, I was running Ubooquity with 2gig of memory allocated. I had to turn it up to 3gig to keep from getting out of memory errors in the log.

How did I discover this? Well, after converting a lot of JPGs to WEBPs, I added these new folders to Ubooquity and launched a new scan of my folders. When it was done, I went in to look at the results. I found that many of my comics were showing the "no cover found" default cover that looks like an icon of a book, and that a few comics had a cover that was only a line where the cover image should be - as if the process that created the cover thumbnail just quit after 2 or 3 lines of the original image. The majority of the comic covers were fine though. When I went to read a comic with the built-in Ubooquity reader, if that comic had the default book icon, the first image wouldn't show. I would get a grey almost gradient background. Sometimes it would be bright green - like a green screen used in movie making. But sometimes, if I clicked through the page images, I would eventually get to an image that displayed properly. For each page I would get a spinning hourglass at the top, while Ubooquity decoded the WEBP image. For bad pages, it might spin forever. Other times it would spin a bit and then display the grey gradient or green screen. Some images displayed properly, though. So it was quite confusing. I tried to make sense of which CBZ files worked and which didn't. I tried to make sense of which WEBP files worked and which didn't. I couldn't find any rhyme or reason.

So I thought, well, I bet I know how to fix the cover issue. I'll copy the JPG covers from the original files into the CBZs with WEBP images. Tedious, but it worked. A Ubooquity rescan and things were looking good as far as the appearance of the covers went. But there were still problems once I opened a file in the reader.

So I dug into the Ubooquity logs to see if I could find errors. Sure enough, there were out of memory errors, like these:

20201127 11:20:23 [qtp122114483-765] ERROR com.ubooquity.d.b - Request not handled (should never happen, this is a bug !): /comicreader/335598
20201127 11:20:23 [qtp122114483-765] WARN  org.eclipse.jetty.server.HttpChannel - /comicreader/335598
java.lang.OutOfMemoryError: GC overhead limit exceeded
20201127 11:20:34 [qtp122114483-788] ERROR com.ubooquity.d.b - Request not handled (should never happen, this is a bug !): /comicreader/335598
20201127 11:20:34 [qtp122114483-788] WARN  org.eclipse.jetty.server.HttpChannel - /comicreader/335598
java.lang.OutOfMemoryError: GC overhead limit exceeded
20201127 11:20:41 [qtp122114483-763] ERROR com.ubooquity.d.b - Request not handled (should never happen, this is a bug !): /comicreader/335598
20201127 11:20:41 [qtp122114483-763] WARN  org.eclipse.jetty.server.HttpChannel - /comicreader/335598
java.lang.OutOfMemoryError: Java heap space
20201127 11:21:31 [qtp122114483-766] ERROR com.ubooquity.c.a - Could not serve stream with URI: /comicreader/335598
org.eclipse.jetty.io.EofException: null

When I checked the memory by using the "View System Info" button on the Ubooquity admin console's General tab, It said I had memory available, but it also seems to indicate that it was using the max memory:

Could not serve stream with URI: /comicreader/335598

I'm trying to add a huge collection of ebooks (80k more or less) to my Ubooquity installation based on docker. I've added some extra memory with parameter MAXMEM=2048 in order to avoid memory problems during the long indexation needed

The problem is that when it finishes to index (without any error in logs), the system becomes unstable, I cannot access to the web UI correctly. For this reason I need  to restart the docker container. When I restart it, in the startup log, the "Loading preferences"step takes about 10 minutes and it launches and error "Could not get number of existing tables".  I attached the error below. It seems like the database became corrupted, also I've checked the database generated (ubooquity-5.mv.db) and its size is 7GB. I have repeated the process several times, indexing the full library, or even indexing the library in 3 stages, but at the end, the last stage fails in the same way.

Is there any limitation in the size of the database which at the end makes the database corrupted?

Thx in advance. 

Error launched when I restart after indexing all the elements:

20201113 12:08:59 [main] INFO  com.ubooquity.Ubooquity - Loading preferences
20201113 12:11:08 [main] ERROR com.ubooquity.data.database.d - Cound not get number of existing tables
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-193]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.message.DbException.get(DbException.java:168) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.message.DbException.convert(DbException.java:295) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Database.openDatabase(Database.java:304) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Database.<init>(Database.java:267) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.openSession(Engine.java:64) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.openSession(Engine.java:176) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.createSession(Engine.java:137) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.createSession(Engine.java:27) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:188) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:351) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:383) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:225) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:197) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at com.ubooquity.data.database.d.h(SourceFile:132) [Ubooquity.jar:2.1.2]
    at com.ubooquity.data.database.d.<init>(SourceFile:52) [Ubooquity.jar:2.1.2]
    at com.ubooquity.Ubooquity.main(SourceFile:211) [Ubooquity.jar:2.1.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_252]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_252]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_252]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_252]
    at com.ubooquity.e.a.a(SourceFile:823) [Ubooquity.jar:2.1.2]
    at com.ubooquity.Launcher.main(SourceFile:10) [Ubooquity.jar:2.1.2]
Caused by: java.lang.NullPointerException: null
    at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:102) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.compare(MVMap.java:708) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.Page.binarySearch(Page.java:334) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.binarySearch(MVMap.java:461) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.get(MVMap.java:450) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.remove(MVMap.java:538) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.db.TransactionStore.rollbackTo(TransactionStore.java:502) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.db.TransactionStore$Transaction.rollback(TransactionStore.java:799) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Database.openDatabase(Database.java:273) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    ... 24 common frames omitted
20201113 12:13:03 [main] ERROR com.ubooquity.data.database.d - Could not configure collation strength
org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-193]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Database.<init>(Database.java:267) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.openSession(Engine.java:64) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.openSession(Engine.java:176) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Engine.createSession(Engine.java:27) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:349) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:115) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:99) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:188) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:351) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:383) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:225) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:197) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at com.ubooquity.data.database.d.i(SourceFile:155) [Ubooquity.jar:2.1.2]
    at com.ubooquity.data.database.d.<init>(SourceFile:53) [Ubooquity.jar:2.1.2]
    at com.ubooquity.Ubooquity.main(SourceFile:211) [Ubooquity.jar:2.1.2]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_252]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_252]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_252]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_252]
    at com.ubooquity.e.a.a(SourceFile:823) [Ubooquity.jar:2.1.2]
    at com.ubooquity.Launcher.main(SourceFile:10) [Ubooquity.jar:2.1.2]
Caused by: java.lang.NullPointerException: null
    at org.h2.mvstore.db.ValueDataType.compare(ValueDataType.java:102) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.compare(MVMap.java:708) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.Page.binarySearch(Page.java:334) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.binarySearch(MVMap.java:461) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.get(MVMap.java:450) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.MVMap.remove(MVMap.java:538) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.db.TransactionStore.rollbackTo(TransactionStore.java:502) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.db.TransactionStore$Transaction.rollback(TransactionStore.java:799) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.mvstore.db.MVTableEngine$Store.initTransactions(MVTableEngine.java:255) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Database.open(Database.java:765) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    at org.h2.engine.Database.openDatabase(Database.java:273) ~[h2-1.4.193.jar.8884071570020133214.tmp:1.4.193]
    ... 24 common frames omitted</init></init></init></init></init></init></init></init>

Bonjour,

Tout d'abord un grand bravo pour ce soft, je l'utilise depuis plusieurs années et j'en suis très content !

Récemment, j'ai perdu tout le contenu de mon synology suite à la perte de 2 des 4 disques durs, snif. J'ai réussi de nouveau à tout réinstaller et en ai profité pour passer à la version 2 !

Je me pose la question suivante : j'utilise Ubooquity uniquement pour les BD qui sont toutes en PDF, ça fait actuellement 6 jours que Ubooquity mouline car j'ai 10 000 PDF à remonter dans la base, serait-il mieux que je convertisse tous mes PDF en CBZ ? Est-ce que serait aussi mieux pour la lecture ?

Merci d'avance.

Hardware: Raspberry Pi 4B 8GB; OS: Raspberry Pi OS with latest updates. Any ideas would be very welcome. I'm new to systemd and linux in general. I did just resolve my Samba issues and got my Plex media server running so this is the last thing to solve!

I'm able to run Ubooquity from the command line, however, using systemd, it won't start using the exact same command. The error is highlighted below in the status listing: 

pi@RFDPi4BMediaServer:/ $ sudo systemctl daemon-reload
pi@RFDPi4BMediaServer:/ $ sudo systemctl start ubooquity
pi@RFDPi4BMediaServer:/ $ sudo systemctl status ubooquity
● ubooquity.service - Ubooquity
Loaded: loaded (/etc/systemd/system/ubooquity.service; enabled; vendor preset: enabled)
Active: inactive (dead) since Tue 2020-11-03 20:32:33 PST; 3s ago
Process: 9909 ExecStart=/usr/bin/java -jar /opt/ubooquity/Ubooquity.jar --adminport 2022 --libraryport 3456 --remoteadmin --headless (code=exited, status=0/SUCCESS)
Main PID: 9909 (code=exited, status=0/SUCCESS)

Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at java.base/java.lang.reflect.Method.invoke(Method.java:566)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at com.ubooquity.e.a.a(SourceFile:823)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at com.ubooquity.Launcher.main(SourceFile:10)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: Caused by: java.lang.ClassNotFoundException: Failure to load: javafx.application.Platform
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at com.ubooquity.e.a.loadClass(SourceFile:992)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
Nov 03 20:32:32 RFDPi4BMediaServer java[9909]: ... 7 more
Nov 03 20:32:33 RFDPi4BMediaServer systemd[1]: ubooquity.service: Succeeded.

The unit file is:

# acquired script from https://gist.github.com/thenaterhood/e79eb6f05badaa56a2d9
# revised 2020-11-03 for my installation

[Unit]
Description=Ubooquity
After=network.target

[Service]
WorkingDirectory=/opt/ubooquity
User=pi
Group=pi

Type=simple
ExecStart=/usr/bin/java -jar /opt/ubooquity/Ubooquity.jar --adminport 2022 --libraryport 3456 --remoteadmin --headless
TimeoutStopSec=20
KillMode=process
Restart=on-failure

[Install]
WantedBy=multi-user.target

I tried various ideas posted in this forum such as memory parameters to the execute command, but no joy. I thought this was permissions to start Java, but I can run the exact command at the command line successfully. Replacing pi with root also works, but moves the database. The working folder is owned by pi. I do notice the database does not go to the working folder specified... it goes to the root of pi's home folder. 

I’ve setup my ubooquity on a synology ansd using a reverseproxy to redirect https ports (443) to obqootuity server. 
it’s all working fine except for reader for books;

The reader for comics  is fine, navigating the server is fine, but the reader for books is broken

the problems seems to be the url: all pages, including reader for comics start with https://... but the reader for books starts with nothing : the url starts with ubooquity... (the url without https:// )

Hi ! 

Here is what I see :

Everything was working fine before I rebooted my server computer and my public IP changed. 

Now, it's working with :

- locahost

- any connexion with a browser that didn't previously connected with my server (Ex : Edge instead of Chrome, another tablet, etc.)

It does not work with :

- my local IP on Chrome on the server.

- my new public IP on a remote tablet that previously connected with my server.

What I tried :

- restart the server

- delete cache on client browser

- delete cookies about my IP and ubooquity on client browser.

- deactivated the user setting on the server.

- checked the logs. Nothing special.

Any ideas ?

I've been having a bit of an issue in the past 24 hours. Basically, I have been accessing my server entirely fine the past few weeks on another device, when it was unable to connect to it, displaying that it was taking too long to respond, with a connection timed out error. This is occurring on both my main IP and local IP, however localhost still works fine. I haven't touched any of the firewall settings since starting it up, so I am unsure what is actually causing this. Has anyone had experience with this problem before or have an idea as to how to fix it?