Custom Query (196 matches)

Below is signup-sql failing on a locker because it's not attached.

The guilty code is this in signup-sql:

    echo OK.  A MySQL account will be created for a locker of your choice that
    echo you control.  Please enter the name of the selected locker below.
    echo "(For the locker /mit/sipb, you would enter sipb)."
    printf "Locker name: "
    read lname
    lroot="/mit/$lname" 

and a later line that tries to use $lroot (==/mit/stuff).

Rather, this section should do what signup-minimal does:

        while true; do
	    printf "Locker name: "
	    read lname
	    if attach "$lname"; then
		break
	    fi
	    echo "$lname is not a valid locker name."
        done
        lroot="/mit/$lname"

which has the double benefit of attaching the locker and making sure it's attachable / an actual locker name.

athena$ signup-sql

== Welcome to the sql.mit.edu signup process ==

For documentation, including a link to the Athena rules of use,
see <http://sql.mit.edu>.

Please report problems with this signup process to sql@mit.edu.

Are you performing this signup for:
1. Your personal Athena account
2. A locker that you control (a club, a course, etc)
If you do not understand this question, you should answer '1'.
Please enter either '1' or '2' (without quotes): 2

OK. A MySQL account will be created for a locker of your choice that
you control. Please enter the name of the selected locker below.
(For the locker /mit/sipb, you would enter sipb).
Locker name: stuff
attach: /afs/athena.mit.edu/contrib/scripts attached to /mit/scripts for filesystem scripts
mkdir: "/mit/stuff/.scripts-signup": Permission denied

ERROR:
It appears as though you do not have write access to the locker <stuff>.
Contact scripts@mit.edu if you are unable to solve the problem.

It's poor that users outside MIT or who otherwise haven't installed the MIT CA to be trusted get warnings when they visit scripts pages. We can get a cert for <$20/yr for scripts.mit.edu, and for $200/yr (maybe less) for *.scripts.

The phpMyAdmin installation(s) in the sql locker are old and somewhat screwed up. geofft was going to fix this but he went to sleep, so I’m recording the necessary steps here as a reminder.

• svn co https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/tags/STABLE/phpMyAdmin
• Copy config.sample.inc.php to config.inc.php.
  • Set $cfg['blowfish_secret'] to a secure random value.
  • Set $cfg['Servers'][$i]['host'] = 'sql.mit.edu'
  • Set $cfg['Servers'][$i]['extension'] = 'mysqli'
  • Set $cfg['ForceSSL'] = TRUE
• Copy /etc/php.ini to php.ini.
  • Add the mcrypt and mysqli extensions.

The patches and .htaccess redirect are then unnecessary, and future upgrades will be as simple as svn up. (Example: <​https://andersk.scripts.mit.edu/phpMyAdmin/>.)