Custom Query (196 matches)

(Imported from ​help.mit.edu #548433.)

aseering:

Hm, this'd be useful in general: "Go look at Scripts faq #N; s/scripts.mit.edu/linux.mit.edu/", etc.

Here's some sample text for people to play with, if anyone's interested. Intended to replace the last paragraph of FAQ #41. I used really informal markup; feel free to be un-lazy and make it better / consistent with whatever conventions you have.

If you're trying to log into scripts.mit.edu from home and you don't
have an SSH client on your computer, you can log into
athena.dialup.mit.edu from <http://athena.dialup.mit.edu/>, and log
into scripts from there.

You can also log in directly from most personal computers, with the
correct software installed. To connect to scripts.mit.edu from a
Windows computer, install MIT SecureCRT and Kerberos For Win from <http://web.mit.edu/software/win.html
>.

Then, open MIT SecureCRT (from the Start menu). Click the "Quick
Connect" button in the toolbar of the Sessions dialog box that appears
(the second button from the left). Fill out the dialog that appears,
as follows:

Protocol: SSH2
Hostname: scripts.mit.edu
Port: 22
Firewall: None
Username: /Athena Username/

If you are connecting to a group locker, replace /Athena Username/
with the name of the locker.

In the "Authentication" selectbox, scroll down and click on "GSSAPI"
to highlight it. Make sure that the checkbox beside it is checked.
Then, use the black arrows to the right of the box to move "GSSAPI" to
the top of the list of Authentication methods.

Then, click "Connect" to connect to scripts.mit.edu. You may be
prompted for your MIT username and password; if so, enter them.


To connect to scripts.mit.edu from a Mac, download and install the MIT
Kerberos Extras from <http://web.mit.edu/software/mac.html>. Then,
open "Terminal" (in /Applications/Utilities/), and type:

kinit /Athena Username/
ssh -k /Athena Username/@scripts.mit.edu

If you're connecting to a group locker, replace /Athena Username/ with
the name of the locker you want to connect to.

The "-k" flag to ssh doesn't exist for older MacOS X versions. For
these versions and with Apple's default ssh configuration, it is safe
to not use this flag. If you have customized your ssh configuration,
make sure you have "GSSAPIAuthentication yes" and
"GSSAPIDelegateCredentials no" set for scripts.mit.edu.


To connect from a Linux (or other UNIX) computer, install ssh and
Kerberos, and set up Kerberos to use the ATHENA.MIT.EDU realm. Many
Linux distributions provide packages that can do this for you. Then,
run the two Mac command-line commands listed above.

(Imported from ​help.mit.edu #492117.)

tabbott:

Something else seems to have changed in the ssh configuration. Now when I ssh from an Athena workstation (which auto-xforwards) I get a really long delay followed by an xauth timeout.

andersk:

Hmm. I disabled X11Forwarding on the primary server for now. This reduced but did not eliminate the delay (i.e. there's still a huge difference between ssh and ssh -o ForwardX11=no), so I'm not entirely sure what's going on. I don't see the delay from my machine or mega-man.

(Imported from ​help.mit.edu #545970.)

andersk:

The SQL web interface should make it clear that it's going to prepend lockername+ to the database name. An easy solution would be

new database: andersk+[text box ] [add]

geofft:

I've added your suggestion to the live version in the locker (/mit/sql/web_scripts/main/tpl/main.php).

Joe, could you check this in to SVN? I don't seem to have access to the repository.

andersk:

This change has apparently gotten reverted, and users continue to be confused by it (such as stjerne who thought his database name was amanger, and me who keeps creating databases like hmmt+hmmt+database). Can this change be reapplied?

andersk:

What is the status of this sql.mit.edu UI bug? It was fixed and then reverted.