updates to make a MySQL UPS service usable in the app