1. No user installed addons are supported, python or otherwise.
2. No, they really are not supported.
3. They are not coming back
4. Read from 1. again

Any mention of illegal streaming sites, addons or any pirated material will not be tolerated. This is not democracy and any offenders will be banned and posts deleted immediately without warning.

Other than that, we hope you enjoy MrMC so far and we welcome any input and feedback you might have.

Team MrMC.

Enabling MySQL  [SOLVED]

Support for any MySQL database connection issues
Post Reply
drpeeper
Posts: 4
Joined: 18 Nov 2015, 22:08

Enabling MySQL

Post by drpeeper »

I'm attempting to set up MySQL under the settings menu, and keep getting the error: "Couldn't Open Database: Failed to set the new configuration. Please check your settings." every time I click 'enable'.

10.0.0.18 (Apple-TV 4): MrMc Services Settings
Server: 10.0.0.10
Port: 3306
Username: mrmc
Password: mrmc
Define video database name: mrmc
Define Music database name: music
10.0.0.10: /etc/my.conf
bind-address = 0.0.0.0
10.0.0.10: MySQL commands
create database mrmc;
create database music;
GRANT ALL PRIVILEGES ON mrmc.* To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
GRANT ALL PRIVILEGES ON music.* To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
flush privileges;
iptables is not dropping connections.. Am I missing something obvious?
drpeeper
Posts: 4
Joined: 18 Nov 2015, 22:08

Re: Enabling MySQL  [SOLVED]

Post by drpeeper »

Thank you @amet & @davilla for troubleshooting with me!

The correct MySQL commands are:
drop database mrmc;
drop database music;
GRANT ALL PRIVILEGES ON `mrmc%.*` To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
GRANT ALL PRIVILEGES ON `music%.*` To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
flush privileges;
I needed to drop the databases that I created and grant permissions to the tables: `mrmc%.*` and `music%.*` using the backticks. @amet let me know that MrMC concatenates the version numbers to the table names. Including the wildcard character '%' did the trick. Also, once done issuing the commands on the MySQLd granting permissions, allow MrMC to create the databases for you.
drpeeper
Posts: 4
Joined: 18 Nov 2015, 22:08

Re: Enabling MySQL

Post by drpeeper »

Of course, don't forget that after setting up the database, you have to go back to: Videos - Files - [all of your existing added directories] and change content. Highlight the appropriate share, hold down the top button on the AT4 remote, and select 'Change content'. Adjust as necessary.
XX_Keo_XX
Posts: 5
Joined: 02 Mar 2016, 06:35

Re: Enabling MySQL

Post by XX_Keo_XX »

I am no database admin, so I have no Idea what I am doing wrong. Do I need to create tables and junk to make this work or does MrMC create them for me? I have tried the examples above and I keep getting the error:
The following errors were reported:
No database selected
No database selected
I am using this:
GRANT ALL PRIVILEGES ON `mrmc%.*` To 'mrmc' IDENTIFIED BY 'mrmc';
GRANT ALL PRIVILEGES ON `music%.*` To 'mrmc' IDENTIFIED BY 'mrmc';
flush privileges;
Was I supposed to make the mrmc and music databases?

I am trying to do this on my QNAP NAS with MySQL 5.5.44
Post Reply