Serviio

Hi, i am trying to use my old laptop as a media server that i could upload important stuff on. If you are wondering the specs are:
i7 2670qm x64 & gt 630m. Here is the log.
2024-08-21 14:40:08,409 INFO [DBSchemaUpdateExecutor] Checking if DB schema needs to be updated
2024-08-21 14:40:08,420 INFO [DatabaseManager] Using DERBY database language
2024-08-21 14:40:08,675 WARN [DBConnectionPool] Can't create a new connection for jdbc:derby:db;create=true
java.sql.SQLException: Failed to create database 'db', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at org.serviio.db.DBConnectionPool.newConnection(DBConnetionPool.java:186)
at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:123)
at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:149)
at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:71)
at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:64)
at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:49)
at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:84)
at org.serviio.MediaServer.main(MediaServer.java:127)
Caused by: ERROR XJ041: Failed to create database 'db', see the next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 22 more
Caused by: ERROR XBM0A: The database directory '/opt/serviio-2.1/library/db' exists. However, it does not contain the expected 'service.properties' file. Perhaps Derby was brought down in the middle of creating this database. You may want to delete this directory and try creating the database again.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService.access$900(Unknown Source)
at org.apache.derby.impl.services.monitor.StorageFactoryService$10.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source)
at org.apache.derby.impl.services.monitor.FileMonitor.createPersistentService(Unknown Source)
at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection$5.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.jdbc.EmbedConnection.createPersistentService(Unknown Source)
... 19 more
2024-08-21 14:40:10,679 ERROR [MediaServer] An unexpected error occurred. Ending the application. Message: null
java.lang.NullPointerException
at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:50)
at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:84)
at org.serviio.MediaServer.main(MediaServer.java:127)

It appears the Serviio install failed at some point, and the database was not created properly. On rare occasions I've seen that happen on Windows installs as well. My first suggestion is to completely remove the installation and try it again. I have no experience with Linux, so can't offer specific advice on either removing the current install or doing the install again.

The Derby database system built into the Serviio program are Java dependent. I would do as follows:

1. "rm -R *" all the contents of the directory where Serviio is currently installed. This would remove any corrupt databases.

2. Run the following to make sure the program prerequites you need are installed. "sudo apt install software-properties-common openjdk-11-jre default-jre ffmpeg dcraw wget"

3. Reinstall Serviio. Recreate any paths to rebuild the database as necessary.

Good Luck.

The Serviio installation wiki is located here (I tested it under 24.04, and it still works.): https://wiki.serviio.org/doku.php?id=ho ... buntu18-04