Kodi Community Forum
Issue with Shared Database - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Issue with Shared Database (/showthread.php?tid=144536)

Issue with Shared Database - kbfirebreather - 2012-11-05

I have 2 raspberry Pi's. I have a PogoPlug that is running Debian and hosting my content and the shared database.

If I SSH into the PogoPlug and execute:

Code:
sudo mysql -u root -p

It will prompt for password, I'll enter 'root' and I'll be in mysql.

In my advance settings on my Pi's, I have:

Code:
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>192.168.1.147</host>
        <port>3306</port>
        <user>root</user>
        <pass>root</pass>
    </videodatabase>

    <musicdatabase>
        <type>mysql</type>
        <host>192.168.1.147</host>
        <port>3306</port>
        <user>root</user>
        <pass>root</pass>
    </musicdatabase>


    <loglevel>2</loglevel>
</advancedsettings>

My log file looks like:

http://pastebin.com/WRUu2dDV

I haven't for the life of me been able to figure out why this is happening. Any ideas? Thank you for any help.

Here is the entire log file: http://pastebin.com/StyvytCa

RE: Issue with Shared Database - kbfirebreather - 2012-11-05

Further Info:

My bind-address in /etc/mysq/my.cnf is set to 192.168.1.147.

RE: Issue with Shared Database - kbfirebreather - 2012-11-05

I think I figured it out. I was messing around, attempted to restart the mysql service and when it tried to start back up, it said it couldn't because the disk space was full. I checked, and it indeed was pretty full. Deleted some files, made some room, restarted the Pi's, and they're connected now. I think I'm going to need to get a bigger flash drive for the pogo plug.