Changeset 382 for locker/sql

Timestamp:

Aug 21, 2007, 7:52:10 PM (18 years ago)

Author:

presbrey

Message:

new SQL signup and server

Location:

locker/sql/bin

Files:

• create-database (modified) (1 diff)
• drop-database (modified) (1 diff)
• get-next-database (modified) (1 diff)
• get-password (modified) (1 diff)
• get-status (modified) (1 diff)
• save-password (modified) (1 diff)

locker/sql/bin/create-database

@@ -4 +4 @@
 list($h,$u,$p) = explode("\t",`/mit/scripts/sql/bin/get-password`);
 $d = $argv[1];
-$create_r = explode(',',file_get_contents('http://sql.mit.edu/~sql/main/do/batch/create_db?d=' . urlencode($d) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
+$create_r = explode(',',file_get_contents('https://sql.mit.edu/main/do/batch/create_db?d=' . urlencode($d) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
 $return_r = array_shift($create_r);
 $created = implode(',',$create_r);

locker/sql/bin/drop-database

@@ -4 +4 @@
 list($h,$u,$p) = explode("\t",`/mit/scripts/sql/bin/get-password`);
 $d = $argv[1];
-$drop_r = explode(',',file_get_contents('http://sql.mit.edu/~sql/main/do/batch/drop_db?d=' . urlencode($d) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
+$drop_r = explode(',',file_get_contents('https://sql.mit.edu/main/do/batch/drop_db?d=' . urlencode($d) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
 $return_r = array_shift($drop_r);
 $dropped = implode(',',$drop_r);

locker/sql/bin/get-next-database

@@ -5 +5 @@
 $newdb = str_replace($u.'+','',$argv[1]);
 $testdb = str_replace('.','',$u).'+'.$newdb;
-$dbs = explode("\n",file_get_contents('http://sql.mit.edu/~sql/tools/list_dbs.php?h=' . urlencode($h) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
+$dbs = explode("\n",file_get_contents('https://sql.mit.edu/tools/list_dbs.php?h=' . urlencode($h) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
 if (in_array($testdb,$dbs)) {
         $i = 1;

locker/sql/bin/get-password

@@ -32 +32 @@
 }
 
-$sql_status = file_get_contents('http://sql.mit.edu/~sql/main/do/batch/status?u=' . urlencode($env_user));
+$sql_status = file_get_contents('https://sql.mit.edu/main/do/batch/status?u=' . urlencode($env_user));
 switch($sql_status) {
         case 1:

locker/sql/bin/get-status

@@ -1 +1 @@
 #!/bin/sh
 
-status=`wget http://sql.mit.edu/~sql/main/do/batch/status?u=$USER -q -O-`
+status=`wget --no-check-certificate https://sql.mit.edu/main/do/batch/status?u=$USER -q -O-`
 
 echo $status

locker/sql/bin/save-password

@@ -5 +5 @@
 fs sa $lroot/.sql system:authuser none
 fs sa $lroot/.sql daemon.scripts write
+fs sa $lroot/.sql daemon.sql write
 rm -f $lroot/.sql/my.cnf $lroot/.my.cnf