Jon L.'s questions

I have an Ubuntu 12.04 server. Server is running rsyncd (rsync daemon), and allows an external process to rsync in files to a given path, with full control of the file structure within that given path.

These files will be ultimately used by multiple environments, in a staged fashion:

• immediate/live access for "dev", updates multiple times per day
• frozen copy of "dev" for "stage", updates manually, generally every couple of weeks
• frozen copy of "stage" for "prod", updates manually, generally every month or so

I'm attempting to find out what the best process is to be able to essentially version these files for each "frozen" release. These are binary files, so something like Git isn't ideal. I've heard that hard-linking could be useful in such a situation, but I'm not sure if that's fully applicable or where to begin looking.

A full solution is appreciated, or failing that, links/documentation pointing to either existing software or a general related solution would be fine.

EDIT: just a note, while the full directory tree could grow to several gigabytes, generally the only changes are file additions, with occasional (rare) file updates.

I have configured an Ubuntu webserver with Nginx + PHP5-FPM. I have created a chrooted environment (using jailkit) that I'm tossing my developers into, from where they can develop their test applications.

Chroot jail: /home/jail

Nginx and PHP5-FPM run outside the chroot, but are configured to function with websites within the chrooted environment.

So far, Nginx and PHP5-FPM are serving up files without issue, except for the following: When attempting to connect to MySQL, we receive this error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Now, I believe the issue is due to the non-chrooted php.ini referencing mysqld.sock outside of the chroot environment (it's actually using the MySQL default setting currently).

My question is, how can I configure PHP to access MySQL via loopback or similar? (Found that as a suggestion in a google result, but without any instructions)

Or if I'm missing some other obvious setting, let me know. If there's an option of creating a hardlink (that would remain available even if mysql is restarted), that would be handy as well.

Without getting into proxying, or port redirects, port forwards, etc, is there any native method to bind Resin (a Java server) to port 80, on an Ubuntu server, while Resin is started by root but then operates as an unprivileged user (www-data)?

This is on Ubuntu 10.10, running Resin from the caucho apt repository. I know if I run & operate Resin as root, I can make it use port 80, but as you can imagine, that's not ideal.