How to install a mysql database ?
- Thread starter JeanXeb
- Start date
JeanXeb
Member
When radioboss starts I have the message "not database connection!"
Log radioboss : [2019-08-28 12:17:30] Specified key was too long; max key length is 767 bytes (1071)
In the option tab, however, the connection test works !
When I open "Music library" I have the same message :
Database error: Specified key was too long; max key length is 767 bytes (1071) ???
Log radioboss : [2019-08-28 12:17:30] Specified key was too long; max key length is 767 bytes (1071)
In the option tab, however, the connection test works !
When I open "Music library" I have the same message :
Database error: Specified key was too long; max key length is 767 bytes (1071) ???
HMMMM
Active member
Hi Jean, Sorry to jump on to your post I am just curious in regard to this data logger and what you can achieve by using it and mySQL . I presume from reading your posts you require two parts mySQL and the data logger. Does this put song track info into a database. Can you then do something positive with it . You seem to have gone further to try to connect it to a website or SQL on a website you might try serving web pages from your own server giving you SQL data to your pages. i.e https://makeawebsitehub.com/host-website-computer/
JeanXeb
Member
For now I have a local database MySQL.
Now I would like to make a database on an external database MySQL.
For now HMMMM I'm blocking ...
What are the prerequisites to connect radioboss with a remote virtual private server who has a public IP address ? and which ports must be opened ?
Now I would like to make a database on an external database MySQL.
For now HMMMM I'm blocking ...
What are the prerequisites to connect radioboss with a remote virtual private server who has a public IP address ? and which ports must be opened ?
HMMMM
Active member
I have seen some control in help file giving localport addresses to trigger remote start https://manual.djsoft.net/radioboss/en/index.html?title-format-variables.htm
ttp://IP
ort/?pass=PASSWORD&cmd=COMMAND
(substitute ?COMMAND? and ?PASSWORD? accordingly)
Example 1: Play the next track (command: next)
http://127.0.0.1:9001/?pass=WxPe2JXh&cmd=next
Example 2: Play the first track in the playlist (command: ?play 1?)
http://127.0.0.1:9001/?pass=WxPe2JXh&cmd=play%201
This might be a similar port?
If you are trying to just make a back up can you not export data to tab or comma delimited file and transport or back this up you can usual reinstate data from this type of file format.
ttp://IP
ort/?pass=PASSWORD&cmd=COMMAND(substitute ?COMMAND? and ?PASSWORD? accordingly)
Example 1: Play the next track (command: next)
http://127.0.0.1:9001/?pass=WxPe2JXh&cmd=next
Example 2: Play the first track in the playlist (command: ?play 1?)
http://127.0.0.1:9001/?pass=WxPe2JXh&cmd=play%201
This might be a similar port?
If you are trying to just make a back up can you not export data to tab or comma delimited file and transport or back this up you can usual reinstate data from this type of file format.
JeanXeb
Member
Radioboss is on an external machine :
Serveur Host-32 - 32G Opteron 4334 SoftRaid 2x2 To
Syst?me (OS)
VPS Proxmox VE 3.4
Windows 7 Pro
But we do not have a sound back to set the music (Intro, pointmix...) ... (VNC)
That's why I wanted to make a database that exports with MySQL the database...
Serveur Host-32 - 32G Opteron 4334 SoftRaid 2x2 To
Syst?me (OS)
VPS Proxmox VE 3.4
Windows 7 Pro
But we do not have a sound back to set the music (Intro, pointmix...) ... (VNC)
That's why I wanted to make a database that exports with MySQL the database...
It will be easier to configure the sound, e.g. use Remote Desktop connection with "Local sound playback" option.jean sebastien said:
Using MySQL would also be possible, but you will have to use the same paths for music files, including the drive name, on your computer and the server.
