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.
- Close the Audiogalaxy helper, if it’s open.
- 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).
- 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.
- Start the Audiogalaxy helper again.
- 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.
#1 by Justin Wilson on 12 October, 2011 - 3:20 am
Thanks so much for getting me on the right track. Here are some tips for your readers in case they have the same problems I had:
(1) If you have many music dirs you thought you would symlink inside “My Music”, it probably won’t work. It would only work for me if the path specified to Audio Galaxy itself was a symlink’s direct name. Any symlinks WITHIN a specified symlink or specified dir were not followed. So I had to add a bunch of database entries, each is a symlink from the .wine/drive_c… to the real life directory. Save yourselves pain
(2) When Sqlliteman prompts you to “save” it is asking about the query text! Don’t overwrite your database with it *doh*. Database is already saved immediately on edit, so just cancel and exit.
#2 by Brian W on 26 January, 2012 - 1:20 am
Thanks a lot!
One thing to add, you need the C++ library: run “winetricks vcrun2008″ from the command line before you try to install audiogalaxy.
If you dual boot like me and have all your music on a windows drive, just drop a symlink to it in the wine drive_c location mentioned above and add the simlink to the database…syncs right up.