Madsonic Support

Hi!
I am trying to connect madsonic on windows to my sql Database.
Tried with mysql 5 and 8.
Connection works but the schema and tables are not created correctly.
Indexes are missing, tables are missing and so on, its only creating a part of the needed dataset it seems.
Is there a sql script to create the needed tables in mysql ?
It seems madsonic tries to create the tables at startup, but why isnt it creating everything then ?

Thx in advance,

I was able to connect now to Mysql now:
Here are some hints if anyone else has also issues:

I had to remove the root password, this should only be done when you set that only local connections are allowed.
update user set password=PASSWORD("") where User='root';

My Connections String in config file looks like this:
-Dmadsonic.db=jdbc:mysql://localhost:3306/madsonic?user=root&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC


I also had to change the timezone in my sql DB and add a colum to user_settings table
SET GLOBAL time_zone = "+2:00" 0,000 sec
ALTER TABLE `madsonic`.`user_settings` ADD COLUMN show_index tinyint

For the login into webfrontend i had to choose remember me checkbox, because else i could not log in (screen stayed at login page)

I also tried to use plsql in between, but there was an error in creation script. Creation user table was not sucessfull since the term user is a sql command an therefore it would need to be changed to "user" with the commas in creation step:

CREATE TABLE ""USER"" ("USER"NAME VARCHAR(256) NOT NULL PRIMARY KEY, PASSWORD VARCHAR(256) NOT NULL, BYTES_STREAMED BIGINT DEFAULT 0 NOT NULL, BYTES_DOWNLOADED BIGINT DEFAULT 0 NOT NULL, BYTES_UPLOADED BIGINT DEFAULT 0 NOT NULL, ldap_authenticated BOOLEAN DEFAULT FALSE NOT NULL, EMAIL VARCHAR(256), GROUP_ID INT NOT NULL, LOCKED VARCHAR(4) NOT NULL, COMMENT VARCHAR(256))

following.

I've been trying to do this as well

Hi there,

We finish the external database support in one of the next versions of Madsonic 7.
At the moment there are some troubles with the SQL schemas.

stay tuned

Best regards,
The Madsonic Team