Username 8 characters or less (preferably)
lower case username
Details needed for regular accounts
Date of Birth
UL ID No
Alternate email address
Username(8 characters or less)
Details needed for clubs&socs accounts
Name of account
Person in charge
In future if any requests come from accounts for password resets etc. can it be stated whether the particular request has been "approved" and OK'ed from accounts.
Accounts Scripts Details
All scripts should be run by the accounts user from the usermanage directory.
There is a README in the directory with the following information:
Checks the database for strange looking accounts, like ones which expire in the distance future but which aren't marked as lifetime, ones which haven't expired but are marked as having expired in the past etc.
Run it with no arguments.
Adds a user, prompts for all relevant information
Backs up the database and LDAP information - only usable by root.
Compares user entered material in LDAP to stuff in the database. If run normally without arguments it will show you what changes it thinks should be made. If you agree with those changes, run it again with the -d option.
Deletes a user from LDAP and the database, and deletes their home directory. Specify user with -u
Disables the user specified with -u, disabling access to their website, changing their shell and marking them in the database as disabled.
Lists all users who haven't paid. Accounts are considered to expiry on the 1st of July. Therefore, if someone's account expiry year is set to 2009, it will be considered unpaid after July 1st 2009. It shows the expiry year in brackets after the user's name to let you know how much payment is required.
If run without arguments will show you the arguments it accepts. With -d it shows you all disabled accounts, with -a shows you all admins, with -v shows you all accounts in need of verification. With -t it allows you to look at different kinds of account, -t h shows you the numbers that are possible. For example, showaccounts.pl -t 5 shows you all accounts belonging to a UL society.
Let's you update the real name, ID number, date of birth, phone number, alternate email address, etc. Enter -u <username> as an argument and it will then prompt you for each field to update.
Dumps all user info to a file in .. called 'userinfo.txt'.
Updates the user's account with a new expiry date. If run in before July, it will update it to the current year, if run after July, it will update it to the following year. To use it do ./userpaid.pl -u johnboy. If you want to set a life time or ten year account, use the -l or -t parameters. That is:
# updates johnboy's expiry date to this year or the following one. ./userpaid.pl -u johnboy # updates johnboy's expiry date to expire in 100 years. ./userpaid.pl -u -l johnboy # updates johnboy's expiry date to expire in 10 years. ./userpaid.pl -u -t johnboy
Searching Accounts Database
mysql -u compsoc -h mysql.skynet.ie -p (prompted for password)
Select compsoc db with: use compsoc;
Search using: select * from users where $field_name = '$value'; (sub in appropriate search terms for $field_name)
e.g. when is $user paid until: select expiry_year from users where user_name = '$user';