Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
XBMC with MySQL support without installing MySQL
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Multimedia
View previous topic :: View next topic  
Author Message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Mon Aug 18, 2014 6:20 pm    Post subject: XBMC with MySQL support without installing MySQL Reply with quote

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
View user's profile Send private message
VoidMage
Watchman
Watchman


Joined: 14 Oct 2006
Posts: 6196

PostPosted: Mon Aug 18, 2014 7:07 pm    Post subject: Reply with quote

:roll: creating problems as if there were not enough real ones.
mysql has 'minimal' useflag which turns off building server.
Back to top
View user's profile Send private message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Mon Aug 18, 2014 8:12 pm    Post subject: Reply with quote

Lack of proper documentation comes to mind again.

But the USE flag will no doubt help. Thanks.
Back to top
View user's profile Send private message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Mon Aug 18, 2014 8:39 pm    Post subject: Reply with quote

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
View user's profile Send private message
mackal
Tux's lil' helper
Tux's lil' helper


Joined: 04 Aug 2011
Posts: 88

PostPosted: Tue Aug 19, 2014 4:46 pm    Post subject: Reply with quote

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
View user's profile Send private message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Tue Aug 19, 2014 4:51 pm    Post subject: Reply with quote

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
View user's profile Send private message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Sun Sep 07, 2014 8:48 pm    Post subject: Reply with quote

What gives you the idea I speak Arabic? If that is what I think it is.
Back to top
View user's profile Send private message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Sun Sep 07, 2014 8:52 pm    Post subject: Reply with quote

So, spam? Don't worry, already reported you.
Back to top
View user's profile Send private message
Aonoa
Guru
Guru


Joined: 23 May 2002
Posts: 589

PostPosted: Mon Sep 08, 2014 5:15 pm    Post subject: Reply with quote

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
View user's profile Send private message
weust
n00b
n00b


Joined: 28 Feb 2014
Posts: 26

PostPosted: Mon Sep 08, 2014 5:18 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Multimedia All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum