Changeset 382


Ignore:
Timestamp:
Aug 21, 2007, 7:52:10 PM (17 years ago)
Author:
presbrey
Message:
new SQL signup and server
Location:
locker
Files:
8 edited

Legend:

Unmodified
Added
Removed
  • locker/bin/signup-sql

    r157 r382  
    7777  fs sa $lroot/.sql system:authuser none
    7878  fs sa $lroot/.sql daemon.scripts write
     79  fs sa $lroot/.sql daemon.sql write
    7980  ln -nfs $lroot/.sql/my.cnf $lroot/.my.cnf 2>/dev/null
    8081fi
  • locker/deploy/bin/onathena

    r240 r382  
    112112  mkdir $lroot/.sql 2>/dev/null
    113113  fs sa $lroot/.sql daemon.scripts write
     114  fs sa $lroot/.sql daemon.sql write
    114115  ln -nfs $lroot/.sql/my.cnf $lroot/.my.cnf 2>/dev/null
    115116fi
  • locker/sql/bin/create-database

    r326 r382  
    44list($h,$u,$p) = explode("\t",`/mit/scripts/sql/bin/get-password`);
    55$d = $argv[1];
    6 $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)));
     6$create_r = explode(',',file_get_contents('https://sql.mit.edu/main/do/batch/create_db?d=' . urlencode($d) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
    77$return_r = array_shift($create_r);
    88$created = implode(',',$create_r);
  • locker/sql/bin/drop-database

    r327 r382  
    44list($h,$u,$p) = explode("\t",`/mit/scripts/sql/bin/get-password`);
    55$d = $argv[1];
    6 $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)));
     6$drop_r = explode(',',file_get_contents('https://sql.mit.edu/main/do/batch/drop_db?d=' . urlencode($d) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
    77$return_r = array_shift($drop_r);
    88$dropped = implode(',',$drop_r);
  • locker/sql/bin/get-next-database

    r326 r382  
    55$newdb = str_replace($u.'+','',$argv[1]);
    66$testdb = str_replace('.','',$u).'+'.$newdb;
    7 $dbs = explode("\n",file_get_contents('http://sql.mit.edu/~sql/tools/list_dbs.php?h=' . urlencode($h) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
     7$dbs = explode("\n",file_get_contents('https://sql.mit.edu/tools/list_dbs.php?h=' . urlencode($h) . '&u=' . urlencode($u) . '&p=' . urlencode($p)));
    88if (in_array($testdb,$dbs)) {
    99        $i = 1;
  • locker/sql/bin/get-password

    r326 r382  
    3232}
    3333
    34 $sql_status = file_get_contents('http://sql.mit.edu/~sql/main/do/batch/status?u=' . urlencode($env_user));
     34$sql_status = file_get_contents('https://sql.mit.edu/main/do/batch/status?u=' . urlencode($env_user));
    3535switch($sql_status) {
    3636        case 1:
  • locker/sql/bin/get-status

    r131 r382  
    11#!/bin/sh
    22
    3 status=`wget http://sql.mit.edu/~sql/main/do/batch/status?u=$USER -q -O-`
     3status=`wget --no-check-certificate https://sql.mit.edu/main/do/batch/status?u=$USER -q -O-`
    44
    55echo $status
  • locker/sql/bin/save-password

    r157 r382  
    55fs sa $lroot/.sql system:authuser none
    66fs sa $lroot/.sql daemon.scripts write
     7fs sa $lroot/.sql daemon.sql write
    78rm -f $lroot/.sql/my.cnf $lroot/.my.cnf
    89
Note: See TracChangeset for help on using the changeset viewer.