I recently started using Ubuntu as my main OS, and in fact I successfully chmodded something for the first time today, so I’m not exactly an expert. But this was painful so once again, hopefully I’ll save others some time by writing it up.

Audiogalaxy is a platform for streaming your music from a pc to any number of other web-enabled devices (web browsers, smartphones, tablets). It’s not supported for Linux yet, but I found this post encouraging me to try using WINE (WINE Is Not an Emulator, as if that clears anything up ). so I gave it a go.

It installed just fine with WINE, but then sat there doing nothing. It didn’t seem to notice any music files that it would be able to stream. I checked that WINE was set up, and indeed the fake Windows filesystem in ~/.wine/drive_c/users/MY_USERNAME/My Music was a symlink (I think!) correctly pointing to my actual music directory (~/Music).

As the post above alludes to, I had to “hack the sqlite”, but I had to take a guess at what that meant. It’s working for me, but use at your own risk. I don’t even know what the “download” column in the appropriate table is for, so if at some point it chooses to overwrite your files with new downloads… let’s just say backups are important. So, that said…

Update: have a screenshot, on the house:

Uploaded with Shutter. Hosted by ImageShack.us. Click to make big.

1. Close the Audiogalaxy helper, if it’s open.
2. Open the file ~/.wine/drive_c/users/YOUR_USERNAME_HERE/Local Settings/Application Data/Audiogalaxy/ag.dat with your favourite SQLite browser thing (never having used one before, I picked Sqliteman from the Ubuntu Software Center, which worked just fine).
3. Find the table called shares_v1, and add a row (the table was initially empty for me, which suggested I’d found the issue!) with the values “C:\users\YOUR_USERNAME_HERE\My Music” in both “path” and “downloads” columns. Commit the change to the database if you haven’t already.
4. Start the Audiogalaxy helper again.
5. Hopefully now if you go to Audiogalaxy.com and log in, you’ll see your collection is starting to fill up with music! Play something triumphant and bask in the glory of success. Well, that’s what I did, YMMV.

You can leave questions below, but I’m honestly not sure I’ll be able to help much, being rather a n00b myself. Perhaps your fellow visitors might offer assistance though. I’ll give it a go too