View previous topic :: View next topic |
Author |
Message |
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Mon Aug 18, 2014 6:20 pm Post subject: XBMC with MySQL support without installing MySQL |
|
|
I set up my XBMC machine and want to put the database on a MySQL instance on my NAS.
XBMC is emerged without the mysql USE flas in make.conf, and therefore it complains with the following (from xbmc.log):
Quote: | ERROR: MySQL library requested but MySQL support is not compiled in. Falling back to sqlite3.
ERROR: Unable to create new database |
Error is given twice. Once for Video and once for Music.
But if I add the mysql USE flag to make.conf it wants to install MariaDB with a virtual/mysql.
It sounds very silly to me that I need to install a full blown SQL server, without ever using it, on a XBMC machine just so it can connect to the actual SQL database on my NAS.
Is there a way to work around this? I only want to recompile XBMC wtih mysql support. |
|
Back to top |
|
|
VoidMage Watchman
Joined: 14 Oct 2006 Posts: 6196
|
Posted: Mon Aug 18, 2014 7:07 pm Post subject: |
|
|
creating problems as if there were not enough real ones.
mysql has 'minimal' useflag which turns off building server. |
|
Back to top |
|
|
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Mon Aug 18, 2014 8:12 pm Post subject: |
|
|
Lack of proper documentation comes to mind again.
But the USE flag will no doubt help. Thanks. |
|
Back to top |
|
|
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Mon Aug 18, 2014 8:39 pm Post subject: |
|
|
Ok, this is fun. not.
Since I only want dev-db/mysql to install with the minimal USE flag, I added it to packages.use (dev-db/mysql minimal).
For some reason dev-db/mariadb is then pulled in, blocking dev-db/mysql because both can't be installed at the same time.
I did not ask for mariadb, so why is it being pulled in?
Trying to use dev-db/mariadb with the minimal USE flag results in the same crap.
For now I just added minimal to make.conf, where I will remove it after the emerge of dev-db/mysql.
No doubt it will be merged fully during some upgrade. |
|
Back to top |
|
|
mackal Tux's lil' helper
Joined: 04 Aug 2011 Posts: 92
|
Posted: Tue Aug 19, 2014 4:46 pm Post subject: |
|
|
Is it possible you have something else installed that is forcing mysql/mariadb to be installed without the minimal flag? Quickly looking through the XBMC ebuilds, there should be no issue. Also, if you're using a single machine with XBMC, you're probably better off just using SQLite. You only really want to use MySQL/MariaDB if you have more than 1 XBMC box set up and want to have their libraries in sync. (Or if you want to do something else with the XBMC library I guess?) |
|
Back to top |
|
|
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Tue Aug 19, 2014 4:51 pm Post subject: |
|
|
No, when I add the mysql USE flag to make.conf, and run a emerge --new use and other options, XBMC is the only thing that needs recompiling.
I know for one machine sqlite3 is fine, but it was more to try it out.
So mostly to try it out.
And with the recent recompiles I've done, it almost makes sense to use an external database |
|
Back to top |
|
|
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Sun Sep 07, 2014 8:48 pm Post subject: |
|
|
What gives you the idea I speak Arabic? If that is what I think it is. |
|
Back to top |
|
|
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Sun Sep 07, 2014 8:52 pm Post subject: |
|
|
So, spam? Don't worry, already reported you. |
|
Back to top |
|
|
Aonoa Guru
Joined: 23 May 2002 Posts: 589
|
Posted: Mon Sep 08, 2014 5:15 pm Post subject: |
|
|
weust wrote: | Ok, this is fun. not.
Since I only want dev-db/mysql to install with the minimal USE flag, I added it to packages.use (dev-db/mysql minimal).
For some reason dev-db/mariadb is then pulled in, blocking dev-db/mysql because both can't be installed at the same time.
I did not ask for mariadb, so why is it being pulled in?
Trying to use dev-db/mariadb with the minimal USE flag results in the same crap.
For now I just added minimal to make.conf, where I will remove it after the emerge of dev-db/mysql.
No doubt it will be merged fully during some upgrade. |
Greetings,
You must enable the minimal flag on virtual/mysql and either dev-db/mariadb or dev-db/mysql. Mariadb is a drop-in replacement for mysql and so it technically does not matter which of them you choose, but I think mariadb is the more community friendly choice.
Hope it helps.
Last edited by Aonoa on Mon Sep 08, 2014 5:19 pm; edited 1 time in total |
|
Back to top |
|
|
weust n00b
Joined: 28 Feb 2014 Posts: 26
|
Posted: Mon Sep 08, 2014 5:18 pm Post subject: |
|
|
Aonoa wrote: | weust wrote: | Ok, this is fun. not.
Since I only want dev-db/mysql to install with the minimal USE flag, I added it to packages.use (dev-db/mysql minimal).
For some reason dev-db/mariadb is then pulled in, blocking dev-db/mysql because both can't be installed at the same time.
I did not ask for mariadb, so why is it being pulled in?
Trying to use dev-db/mariadb with the minimal USE flag results in the same crap.
For now I just added minimal to make.conf, where I will remove it after the emerge of dev-db/mysql.
No doubt it will be merged fully during some upgrade. |
Greetings,
You must enable the minimal flag on virtual/mysql and either dev-db/mariadb or dev-db/mysql. Mariadb is a drop-in replacement for mysql and so it technically matter which of them you choose, but I think mariadb is the more community friendly choice.
Hope it helps. |
I got it emerged but tbh I forgot what I did exactly.
Will check your tips when I boot it again. I don't use it every day, plus way too busy on the PS4 and waiting for Destiny atm |
|
Back to top |
|
|
|