Issue with Shared Database
#1
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
Reply
#2
Further Info:

My bind-address in /etc/mysq/my.cnf is set to 192.168.1.147.
Reply
#3
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.
Reply

Logout Mark Read Team Forum Stats Members Help
Issue with Shared Database0