id	summary	reporter	owner	description	type	status	priority	milestone	component	resolution	keywords	cc
423	signup-sql is broken (signup.php is not accessible)	leee		"signup-sql has been broken for quite a while now.

Looking at [https://scripts.mit.edu/trac/browser/trunk/locker/bin/signup-sql signup-sql in locker/bin], it calls for [https://scripts.mit.edu/trac/browser/trunk/locker/sql/bin/get-password get-password in sql/bin], which then finally calls for [https://scripts.mit.edu/trac/browser/trunk/server/common/oursrc/sql-signup/sql-signup-sbin /usr/bin/sql-signup], provided all the right switches are hit. (e.g. get-password should be modified to know about the condition where a user could have `~/.sql/my.cnf`` and not be signed up, but that's for another ticket).

This complains!

{{{
$ /usr/bin/sql-signup
Traceback (most recent call last):
  File ""/usr/sbin/sql-signup"", line 21, in <module>
    execv(SQLBIN, [SQLBIN, str(user_name), str(user_uid), str(user_gid)])
OSError: [Errno 2] No such file or directory
}}}

Looking at it, the only file it would ever possibly play with is the one in the variable `SQLBIN`, which is `/afs/athena.mit.edu/contrib/sql/web_scripts/main/batch/signup.php`. I unfortunately am not on `sql-acl == scripts-root` or `sql-locker`, so cannot troubleshoot further, but [https://sql.scripts.mit.edu/main/batch/signup.php attempting to access this file via web] yielded a 404, giving a somewhat clear indicator of what is causing our signups to break.

"	defect	new	blocker		default