Using the built in MYSQL server to share XBMC library

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Using the built in MYSQL server to share XBMC library

Postby bigfoot65 » Wed Jun 18, 2014 3:19 pm

Did you look in the location specified in an earlier post in this thread? You can also try

Code: Select all

find / -name my.cnf
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

User avatar
cpg
Administrator
Posts: 2618
Joined: Wed Dec 03, 2008 7:40 am
Contact:

Re: Using the built in MYSQL server to share XBMC library

Postby cpg » Wed Jun 18, 2014 4:22 pm

it's in /etc/my.cnf
(be careful, or your HDA will break if this file is not set up well)
My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 8GB RAM, 1TBx2+3TBx1

modem7
Posts: 215
Joined: Tue Mar 20, 2012 6:00 pm

Re: Using the built in MYSQL server to share XBMC library

Postby modem7 » Thu Jun 19, 2014 11:33 am

Ah yes, that's where I found it before - wasn't 100% sure though as it didn't have the bind-address value inside it - so I didn't want to mess with it in case I broke something!

Code: Select all

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
So all I was going to do was:

Code: Select all

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 bind-address = 192.168.1.254 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

modem7
Posts: 215
Joined: Tue Mar 20, 2012 6:00 pm

Re: Using the built in MYSQL server to share XBMC library

Postby modem7 » Sat Jun 28, 2014 11:21 am

In the end, this is what solved it for me:

http://www.robvanhamersveld.nl/2013/02/ ... other-nas/

I think the issue was that Gotham creates it's own database, so creating one manually messed it up for me.

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: Using the built in MYSQL server to share XBMC library

Postby bigfoot65 » Sat Jun 28, 2014 12:19 pm

Is this worthy of adding to the wiki? If so, it would be great if you could so so.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

Who is online

Users browsing this forum: No registered users and 7 guests