Hello!

Here are some instructions on how to patch an old interworx server to make it stop trying
to include mysql data in system quotas.

Step 1:

  wget http://updates.interworx.com/_internal/patches/4783/mysql.php.txt -O ~iworx/bin/mysql.php
  chown iworx:iworx ~iworx/bin/mysql.php

Step 2:
  Edit ~iworx/iworx.ini, under the [mysql] section, add:
  group_quota="0"

  Here's a bash snippet that'll do it:
----------------------------
~iworx/bin/php <<EOF
<?php
include '/home/interworx/include/iworx.conf.php';
Ini::set( Ini::MYSQL, 'group_quota', '0' );
Ini::write();
EOF
----------------------------

Step 3: 
  Fix all the existing databases: 
  
  chown -R mysql:mysql /var/lib/mysql/


Done.

Note that this patch will only prevent newly created databases from being chgrp'd to the 
corresponding unix user.  That's why Step 3 above is needed.


Complete script below
---------------------------------------
#!/bin/sh

# Step 1
wget http://updates.interworx.com/_internal/patches/4783/mysql.php.txt -O ~iworx/bin/mysql.php
chown iworx:iworx ~iworx/bin/mysql.php

# Step 2
~iworx/bin/php <<EOF
<?php
include '/home/interworx/include/iworx.conf.php';
Ini::set( Ini::MYSQL, 'group_quota', '0' );
Ini::write();
EOF

# Step 3
chown -R mysql:mysql /var/lib/mysql/

---------------------------------------