phs
Member
Hi all,
So I've installed the latest RB release (5.8.1.0) to test the new MySQL feature, but I can't get it working.
I have a server running MariaDB 10.3.11 on CentOS 7 on the same local network as the RadioBoss PC. I configure RB to connect to the host, and the 'Test' button tells me "Connection Successful", however after restarting RadioBoss:
I have enabled query logging on the server, and these are the only queries that get run when RB starts:
I have tried with both a dedicated MariaDB user ('radioboss') and the MariaDB 'root' user, both with the same result.
The 'tracks' table definitely does exist:
What am I doing wrong?
So I've installed the latest RB release (5.8.1.0) to test the new MySQL feature, but I can't get it working.
I have a server running MariaDB 10.3.11 on CentOS 7 on the same local network as the RadioBoss PC. I configure RB to connect to the host, and the 'Test' button tells me "Connection Successful", however after restarting RadioBoss:
- After a few seconds I get "No Database Connection!" warning in red under the time.
- The log window says "Table 'tracks' already exists (1050)".
- Opening the Music Library gives me the same error in a modal dialog.
- Using the Tools -> Convert Additional Info feature tells me it processes X number of tracks, but nothing goes in to the database.
I have enabled query logging on the server, and these are the only queries that get run when RB starts:
Code:
190101 16:24:10 16 Quit
190101 16:25:15 17 Connect root@10.99.1.143 as anonymous on rb_live
17 Query SET NAMES utf8
17 Query SET SQL_AUTO_IS_NULL = 0
17 Query SHOW VARIABLES LIKE 'lower_case_table_names'
17 Query CREATE DATABASE IF NOT EXISTS rb_live CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
17 Prepare SELECT * FROM information_schema.tables WHERE table_schema='rb_live' AND table_name='version'
17 Query SHOW INDEX FROM `information_schema`.`tables`
17 Execute SELECT * FROM information_schema.tables WHERE table_schema='rb_live' AND table_name='version'
17 Close stmt
17 Query CREATE TABLE tracks (fn VARCHAR(768) UNIQUE NOT NULL, bpm TEXT, rating INT, gender INT, language TEXT, lastplayed TEXT, playcount INT, intro INT, outro INT, cuein INT, cueout INT, fadein INT, fadeout INT, mixpoint INT, tracklen INT, level DOUBLE, identifier TEXT, disablesong INT, startdate TEXT, enddate TEXT, rgtrack TEXT, rgalbum TEXT, hookin TEXT, hookout TEXT, voiceins TEXT, voiceinsparams TEXT, field1 TEXT, field2 TEXT, field3 TEXT, field4 TEXT, field5 TEXT)
The 'tracks' table definitely does exist:
Code:
MariaDB [rb_live]> SHOW TABLES;
+-------------------+
| Tables_in_rb_live |
+-------------------+
| tracks |
+-------------------+
1 row in set (0.000 sec)
MariaDB [rb_live]> SELECT * FROM tracks;
Empty set (0.000 sec)
MariaDB [rb_live]>
What am I doing wrong?