I think I've changed the database scripts to set the right ACLs now. Postgres works great. The only lingering issue is to figure out what quota to set on new database volumes. Do we even want to have dbtool scripts creating volumes? Would it be better to create a database volume for every new user as part of the adduser script? If not, we end up with issues of telling the Postgres and MySQL scripts the same default quota, allowing us to change the value in one place and have it used in both scripts.
I'm running into problems creating MySQL databases. A database creation attempt ends up like this: ERROR 1049 (42000): Unknown database 'adamc_admin_adamc' For MySQL, I've verified that the /var/lib/mysql file exists that I thought indicated that the database exists. I've also verified that trying to launch an interactive mysql session on that database fails with the same error message dbtool gives. Any ideas? _______________________________________________ HCoop-SysAdmin mailing list [email protected] http://hcoop.net/cgi-bin/mailman/listinfo/hcoop-sysadmin
