From 8835695c2d1bb932a80a6e65162620a89dff6198 Mon Sep 17 00:00:00 2001
From: Joe Presbrey <presbrey@mit.edu>
Date: Tue, 6 Feb 2007 05:13:18 +0000
Subject: [PATCH] signup exits rather than die'ing updated home page to reflect
 backups status process runtime now limited to 10 rather than 20 secs session
 garbage collection turned off

git-svn-id: svn://presbrey.mit.edu/sql/web/main@124 a142d4bd-2cfb-0310-9673-cb33a7e74f58
---
 batch/signup.php        | 4 ++--
 contrib/deleteuser.sql  | 3 ++-
 cron/checkProcesses.php | 2 +-
 php.ini                 | 1 +
 tpl/index.php           | 6 +++---
 5 files changed, 9 insertions(+), 7 deletions(-)

diff --git a/batch/signup.php b/batch/signup.php
index 65a81a8..edfde59 100755
--- a/batch/signup.php
+++ b/batch/signup.php
@@ -1,4 +1,4 @@
-#!/usr/bin/php
+#!/usr/bin/php -q
 <?php
 
 require_once(dirname(__FILE__).'/../mitsql.cfg.php');
@@ -29,7 +29,7 @@ if (!$Login->exists() && !empty($myUsername)) {
 if ($Login->canSignup()) {
 	$User = new User($Login->getUserId());
 	$User->signup($myPassword);
-	die($myPassword);
+	exit($myPassword);
 }
 
 ?>
diff --git a/contrib/deleteuser.sql b/contrib/deleteuser.sql
index 2447df9..9de28a5 100644
--- a/contrib/deleteuser.sql
+++ b/contrib/deleteuser.sql
@@ -1,5 +1,6 @@
 
-SET @NAME=185;
+SET @NAME=904;
+REVOKE ALL PRIVILEGES, GRANT OPTION FROM `6.096`;
 
 USE mitsql;
 DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
diff --git a/cron/checkProcesses.php b/cron/checkProcesses.php
index a98a865..a33e969 100755
--- a/cron/checkProcesses.php
+++ b/cron/checkProcesses.php
@@ -5,7 +5,7 @@ require_once('mitsql.cfg.php');
 require_once('mitsql.lib.php');
 isOffline() && exit;
 
-define('MAX_PROC_TIME', 20);
+define('MAX_PROC_TIME', 10);
 
 $baddbs = $badusers = $bad = array();
 $result = mysql_query('SHOW FULL PROCESSLIST');
diff --git a/php.ini b/php.ini
index 62a9be2..89672f9 100755
--- a/php.ini
+++ b/php.ini
@@ -2,3 +2,4 @@ extension = mysql.so
 auto_append_file = "global.done.php"
 session.save_path = "/afs/athena.mit.edu/contrib/sql/web_tmp"
 output_buffering = 4096
+session.gc_probability=0
diff --git a/tpl/index.php b/tpl/index.php
index 9b940f1..56e4e82 100644
--- a/tpl/index.php
+++ b/tpl/index.php
@@ -16,9 +16,9 @@ All uses of this service must comply with the <a target="_blank" href="http://we
 </p>
 
 <p>
-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.
+This service has been designed with reliability in mind; we utilize RAID, live server mirroring and periodic offline backups to ensure data reliability.
+However, the SIPB MySQL service should not be used to host critical applications that cannot tolerate downtime.
+One nightly backup is available for your locker at <code>/mit/sql/backup/LOCKER_NAME</code>.  You should perform additional backups of your data using the <a href="http://scripts.mit.edu/cron">shortjobs service</a> or <a href="http://scripts.mit.edu/faq/10/how-can-i-back-up-or-restore-my-sql-data">phpMyAdmin</a>.
 </p>
 
 <?php
-- 
2.45.0