Using Serviio with MySQL

[npuser]

No need to reverse engineer using the 1.4.1 version.

Ok. Will give it a go.

@DenyAll - I think we can take this out of beta (restricted) subsection to main forum for a greater visibility. Hopefully, this will inspire someone to create a web library management tools.

Thanks
Npuser

[DenyAll]

Reverted back to General Discussions area of the forum.

db_schema_url=jdbc:mysql://localhost/serviio?user=istasi&password=main

Im using mysql-connector-java-5.1.28.jar

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FETCH FIRST 1 ROW ONLY' at line 1


Any reason why the databasemanager is still returning type as derby? -.-

Current version of serviio is 1.4.1.1 but i've tried with 1.4.1.2 and 1.4.1, just cause well, it might work? -.-'

I followed the instruction on the first post, serviio (version 1.4.1.2) doesn't complete the startup process, it's stuck somewhere, i enabled the debug level:

2014-09-30 17:16:33,649 INFO [DBSchemaUpdateExecutor] Checking if DB schema needs to be updated
2014-09-30 17:16:33,838 DEBUG [DBLogDAOImpl] Checking if script 'script-0.1.sql' has been run
2014-09-30 17:16:33,868 INFO [DatabaseManager] Using MYSQL database language
2014-09-30 17:16:43,761 DEBUG [DBSchemaUpdateExecutor] Error reading db log table, probably doesn't exist yet. Will execute the script.
2014-09-30 17:16:43,765 DEBUG [DBLogDAOImpl] Checking if script 'script-0.1.1.sql' has been run
2014-09-30 17:16:43,775 DEBUG [DBSchemaUpdateExecutor] Error reading db log table, probably doesn't exist yet. Will execute the script.
....
2014-09-30 17:16:44,071 INFO [DBSchemaUpdateExecutor] Updating DB schema
2014-09-30 17:16:44,138 DEBUG [JdbcUtils] An exception occurend when executing SQL statement
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'DB_SCHEMA_VERSION' already exists
.....
2014-09-30 10:06:52,487 INFO [DBSchemaUpdateExecutor] Cleaning temporary cache
2014-09-30 17:18:36,892 DEBUG [ConfigEntryDAOImpl] Reading all ConfigEntries

The last line says "Reading all ConfigEntries", after that nothing more appears and it doesnt' complete the startup
Do u have any idea? what do i miss to correctly switch to mysql?

Hi, I followed the instruction on the first page and all goes well (in my test enviroment!).

Now i'm writing a browser to manage the library metadata (change wrong data or add what's not recognised).

Where can i find tables fields associations or sql queries you are using?

Looking at the tables structure (i did just a quick look for now when i was migrating data from derby to mysql) i saw that in media_item table there's a column that is the id in cover_image and for genre, but not in person->person_role (why not using a base table for that like you did for genre?)

If you can put me in the right direction i'll appreciate.

Thanks.

P.s.
I'm using php so the library manager could be used in linux/windows/mac and i've already tested a very little "local web server" without installation for windows users.