From 79ffa7719bedd98ba94a37c1217dbafe56ea1a72 Mon Sep 17 00:00:00 2001 From: Joe Presbrey Date: Fri, 27 Oct 2006 21:36:33 +0000 Subject: [PATCH] git-svn-id: svn://presbrey.mit.edu/sql/web@112 a142d4bd-2cfb-0310-9673-cb33a7e74f58 --- .htaccess.main | 2 +- contact.php | 3 +++ defaults.cfg.php | 3 +++ global.act.php | 3 +++ global.done.php | 3 +++ lib/dbaccess.lib.php | 3 +++ lib/display.lib.php | 3 +++ lib/errorhandler.lib.php | 3 +++ lib/joe.lib.php | 1 - lib/proc.lib.php | 7 +++++-- lib/security.lib.php | 3 +++ login.php | 3 +++ logout.php | 3 +++ main.php | 3 +++ setup.php | 3 +++ signup.php | 3 +++ test.php | 3 +++ tpl/index.php | 34 +--------------------------------- 18 files changed, 49 insertions(+), 37 deletions(-) diff --git a/.htaccess.main b/.htaccess.main index cd38f11..cddad44 100755 --- a/.htaccess.main +++ b/.htaccess.main @@ -55,7 +55,7 @@ RewriteBase /~sql/main/ ## REVISION 4 RewriteCond %{REQUEST_URI} ^.*/do/(.+)$ -RewriteRule ^do/(.+)$ $1.php [QSA] +RewriteRule ^do/(.+)$ $1.php [L,QSA] RewriteCond %{REQUEST_FILENAME} !-f RewriteRule .* do/index [R,L,QSA] diff --git a/contact.php b/contact.php index 68ecd24..d0e68af 100644 --- a/contact.php +++ b/contact.php @@ -1,4 +1,7 @@ getUsername(); $uname = str_replace('.','',$uname); $dbname = $uname.DELIMETER.$i_newdb; - if ($User->isOverQuota()) { + if ($User->isOverQuota() && !isAdmin()) { $err1[] = 'You are over your quota. You may not add more databases.'; - } elseif (count($User->getDBList())>MAXDBS) { + } elseif (count($User->getDBList())>MAXDBS && !isAdmin()) { $err1[] = 'You have too many databases. You may not add more databases.'; } elseif (empty($i_newdb)) { $err1[] = 'Your database name may not be empty.'; diff --git a/lib/security.lib.php b/lib/security.lib.php index 2084e53..0b7c384 100644 --- a/lib/security.lib.php +++ b/lib/security.lib.php @@ -1,4 +1,7 @@ -About -*/?>

This service provides MySQL databases to MIT certificate holders. -You must choose a MySQL password (which should be different from your Athena account password) when you sign up, and you can +You must choose a MySQL password (which should be different from your Athena account password) when you sign up, and then use this interface to create and drop databases. All subsequent SQL commands can be issued from any host, client, and/or script of your choice; simply connect to the MySQL server at sql.mit.edu using your username and your new MySQL password. You may find it convenient to run scripts using the web script service or @@ -18,37 +15,8 @@ You may find it convenient to run scripts using the MITnet rules of use.

-Backups - -

-We strongly recommend you keep your own backups of your SQL schema and data. Your MySQL data is not stored in AFS. -Although we use various technical means to try to ensure the availability of your data (including hardware-level redundancy and real-time replication), we can make no guarantees about the reliability of the service and access to your data. -

- -

Quotas

- -

-By default, new users can create up to 5 databases, consuming a total of 50 megabytes of SQL data. -The system will periodically check your database sizes and suspend creation of new data (INSERT statements) if your total usage exceeds your allotted quota. -

- -

-This service is not designed to store gratuitous amounts of information in the BLOB or BINARY formats. Extra quota space will not be allotted to users for this type of data. -Users should instead store these types of data in AFS and use SQL tables only to catalogue it. -

- -

-Always use this interface to create and drop databases. -Although you can drop any of your databases outside this interface, doing so will not relinquish your rights to that database and will therefore still count against your quota. -

- -

Disclaimer

-*/?> -

Although this service has been designed with reliability in mind, the SIPB MySQL service should not be used to host critical applications that cannot tolerate downtime. - We perform no query logging, schema or data backups, or any other backups otherwise generally available. You are solely responsible for performing backups of your data. We maintain general usage statistics of this service by the MIT community at large.

-- 2.45.0