Index: /server/common/oursrc/sql-signup/Makefile
===================================================================
--- /server/common/oursrc/sql-signup/Makefile	(revision 119)
+++ /server/common/oursrc/sql-signup/Makefile	(revision 119)
@@ -0,0 +1,12 @@
+install:
+	install -Dpm 644 sql-signup-capps ${DESTDIR}/etc/security/console.apps/sql-signup
+	install -Dpm 644 sql-signup-pam ${DESTDIR}/etc/pam.d/sql-signup
+	install -DpT sql-signup-sbin ${DESTDIR}/usr/sbin/sql-signup
+	mkdir -p ${DESTDIR}/usr/bin
+	ln -nfs /usr/bin/consolehelper ${DESTDIR}/usr/bin/sql-signup
+
+clean:
+	rm -f ${DESTDIR}/usr/bin/sql-signup
+	rm -f ${DESTDIR}/usr/sbin/sql-signup
+	rm -f ${DESTDIR}/etc/pam.d/sql-signup
+	rm -f ${DESTDIR}/etc/security/console.apps/sql-signup
Index: /server/common/oursrc/sql-signup/sql-signup-capps
===================================================================
--- /server/common/oursrc/sql-signup/sql-signup-capps	(revision 119)
+++ /server/common/oursrc/sql-signup/sql-signup-capps	(revision 119)
@@ -0,0 +1,1 @@
+PROGRAM=/usr/sbin/sql-signup
Index: /server/common/oursrc/sql-signup/sql-signup-pam
===================================================================
--- /server/common/oursrc/sql-signup/sql-signup-pam	(revision 119)
+++ /server/common/oursrc/sql-signup/sql-signup-pam	(revision 119)
@@ -0,0 +1,5 @@
+#%PAM-1.0
+auth		sufficient	pam_succeed_if.so uid >= 500 quiet
+auth		include		config-util
+account		include		config-util
+session		include		config-util
Index: /server/common/oursrc/sql-signup/sql-signup-sbin
===================================================================
--- /server/common/oursrc/sql-signup/sql-signup-sbin	(revision 119)
+++ /server/common/oursrc/sql-signup/sql-signup-sbin	(revision 119)
@@ -0,0 +1,23 @@
+#!/usr/bin/python
+
+from pwd import getpwuid
+from os import getenv, setuid, setgid, execv
+from sys import exit
+
+SQLUID = 537704221
+SQLGID = 537704221
+SQLBIN = '/afs/athena.mit.edu/contrib/sql/web_scripts/main/batch/signup.php'
+
+caller = int(getenv('USERHELPER_UID'))
+if caller is None or caller == 0:
+	exit('No user specified.')
+else:
+	pw = getpwuid(caller)
+	(user_name, user_uid, user_gid) = (pw[0], pw[2], pw[3])
+
+	if len(user_name) and user_uid > 1000:
+		setgid(SQLGID)
+		setuid(SQLUID)
+		execv(SQLBIN, [SQLBIN, str(user_name), str(user_uid), str(user_gid)])
+	else:
+		print 'Invalid UID:', user_uid
Index: /server/fedora/Makefile
===================================================================
--- /server/fedora/Makefile	(revision 118)
+++ /server/fedora/Makefile	(revision 119)
@@ -20,5 +20,5 @@
 
 upstream	= openafs krb5 httpd mit-zephyr
-oursrc		= execsys tokensys accountadm sqladm httpdmods
+oursrc		= execsys tokensys accountadm httpdmods sql-signup
 allsrc		= $(upstream) $(oursrc)
 oursrcdir	= ${PWD}/../common/oursrc
@@ -90,6 +90,8 @@
 	for i in $$list; do \
 		pushd $$i; \
-		./mrproper; \
-		autoconf; \
+		if [ -x ./mrproper ]; then \
+			./mrproper; \
+			autoconf; \
+		fi; \
 		popd; \
 		tar -czf $(tmp_src)/$$i.tar.gz $$i; \
Index: /server/fedora/specs/sql-signup.spec
===================================================================
--- /server/fedora/specs/sql-signup.spec	(revision 119)
+++ /server/fedora/specs/sql-signup.spec	(revision 119)
@@ -0,0 +1,43 @@
+Summary:        Signup interface to <sql.mit.edu> for <scripts.mit.edu>.
+Group:			Applications/System
+Name:           sql-signup
+Version:        1.0
+Release:        1
+Vendor:			The scripts.mit.edu Team (scripts@mit.edu)
+URL:			http://scripts.mit.edu
+License:        GPL
+Source0:        %{name}.tar.gz
+BuildRoot:      %{_tmppath}/%{name}-%{version}-%{release}-root-%(%{__id_u} -n)
+%define debug_package %{nil}
+
+BuildRequires:  make
+Requires:       pam, usermode
+
+%description
+
+
+%prep
+%setup -q -n %{name}
+
+%build
+
+
+%install
+rm -rf $RPM_BUILD_ROOT
+make install DESTDIR=$RPM_BUILD_ROOT prefix=/usr/local
+
+%clean
+rm -rf $RPM_BUILD_ROOT
+
+%files
+%defattr(-,root,root,-)
+%defattr(755,root,root,-)
+%{_bindir}/sql-signup
+%{_sbindir}/sql-signup
+%defattr(644,root,root,-)
+%config /etc/pam.d/sql-signup
+%config /etc/security/console.apps/sql-signup
+
+%changelog
+* Fri Jan 26 2007 Joe Presbrey <presbrey@mit.edu>
+- First release.
Index: rver/fedora/specs/sqladm.spec
===================================================================
--- /server/fedora/specs/sqladm.spec	(revision 118)
+++ 	(revision )
@@ -1,41 +1,0 @@
-Summary: scripts.mit.edu sql account administration system
-Group: Applications/System
-Name: sqladm
-Version: 0.00
-Release: scripts
-Vendor: The scripts.mit.edu Team (scripts@mit.edu)
-URL: http://scripts.mit.edu
-License: GPL
-Source: %{name}.tar.gz 
-BuildRoot: %{_tmppath}/%(%{__id_u} -n)-%{name}-%{version}-root
-%define debug_package %{nil}
-
-%description 
-
-scripts.mit.edu sql account administration system
-Contains:
- - setuid C program used to start a sql signup request <signup-sql>
-See http://scripts.mit.edu/wiki for more information.
-
-%prep
-%setup -q -n %{name}
-
-%build
-./configure --with-sqluid=537704221 --with-sqlgid=537704221
-make
-
-%install
-[ $RPM_BUILD_ROOT != / ] && rm -rf $RPM_BUILD_ROOT
-make install DESTDIR=$RPM_BUILD_ROOT prefix=/usr/local
-
-%clean
-[ $RPM_BUILD_ROOT != / ] && rm -rf $RPM_BUILD_ROOT
-
-%files
-%defattr(4755, signup, signup)
-/usr/local/sbin/signup-sql
-
-%changelog
-
-* Sat Sep 30 2006  Jeff Arnold <jbarnold@MIT.EDU> 0.00
-- initial prerelease version
