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

diff --git a/batch/signup.php b/batch/signup.php
index 65a81a81f34cfad66b414381ded3602536836666..edfde59b3757369814f2ca64d2b9fdaa42c9f038 100755 (executable)
--- 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 2447df938ffee7cfa78a5fbe95a13af7f85fe41d..9de28a5e2bc2c55e0da1a14504dd6088173cd595 100644 (file)
--- 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 a98a86589dca97798ca4e8a30648dd40c4645f03..a33e9694adf1418f8b38d92350dcd95a303124d6 100755 (executable)
--- 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 62a9be2c8e44a920d17386033e561e5017f7892b..89672f9b850b9da048813ba1495ec4961a384184 100755 (executable)
--- 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 9b940f18a0e907abcdd3f5ccda2084599a0eba24..56e4e823d7d516b77e5961162bcef3aeb55fdeca 100644 (file)
--- 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