* Creates a new sms database
*
* Copyright 1988 by the Massachusetts Institute of Technology.
+ * For copying and distribution information, please see the file
+ * <mit-copyright.h>.
*/
+#include <mit-copyright.h>
#include <stdio.h>
#include "../server/query.h"
int ingerr();
extern char *tables[];
-extern struct query Queries1[], Queries2[];
-extern int QueryCount1, QueryCount2;
+extern struct query Queries2[];
+extern int QueryCount2;
-char *values[] = { "users_id", "machine_id", "cluster_id", "list_id",
- "nfsphys_id", "filsys_id", "strings_id", 0 };
+char *values[] = { "users_id", "mach_id", "clu_id", "list_id",
+ "nfsphys_id", "filsys_id", "strings_id", "dcm_enable",
+ 0 };
struct alias { char *name;
char *type;
char *trans;
} aliases[] = {
- {"acl_type", "TYPE", "USER"},
- {"acl_type", "TYPE", "LIST"},
- {"acl_type", "TYPE", "NONE"},
+ {"ace_type", "TYPE", "KERBEROS"},
+ {"ace_type", "TYPE", "LIST"},
+ {"ace_type", "TYPE", "NONE"},
+ {"ace_type", "TYPE", "USER"},
+ {"alias", "TYPE", "FILESYS"},
+ {"alias", "TYPE", "PALLADIUM"},
{"alias", "TYPE", "TYPE"},
+ {"alias", "TYPE", "SERVICE"},
{"alias", "TYPE", "TYPEDATA"},
+ {"alias", "TYPE", "VALUE"},
{"boolean", "TYPE", "FALSE"},
{"boolean", "TYPE", "DONTCARE"},
{"boolean", "TYPE", "TRUE"},
- {"class", "TYPE", "staff"},
- {"class", "TYPE", "1988"},
- {"class", "TYPE", "1989"},
+ {"class", "TYPE", "STAFF"},
{"class", "TYPE", "1990"},
{"class", "TYPE", "1991"},
{"class", "TYPE", "1992"},
+ {"class", "TYPE", "1993"},
+ {"class", "TYPE", "FACULTY"},
{"class", "TYPE", "G"},
- {"class", "TYPE", "guest"},
+ {"class", "TYPE", "GUEST"},
+ {"class", "TYPE", "TEST"},
+ {"class", "TYPE", "SYSTEM"},
+ {"filesys", "TYPE", "ERR"},
+ {"filesys", "TYPE", "FSGROUP"},
{"filesys", "TYPE", "NFS"},
{"filesys", "TYPE", "RVD"},
- {"mac_type", "TYPE", "#"},
+ {"filesys", "TYPE", "AFS"},
+ {"fs_access_AFS", "TYPE", "w"},
+ {"fs_access_AFS", "TYPE", "n"},
+ {"fs_access_NFS", "TYPE", "r"},
+ {"fs_access_NFS", "TYPE", "n"},
+ {"fs_access_NFS", "TYPE", "w"},
+ {"fs_access_RVD", "TYPE", "r"},
+ {"fs_access_RVD", "TYPE", "x"},
+ {"gaus", "TYPE", "LIST"},
+ {"gaus", "TYPE", "USER"},
+ {"gaus", "TYPE", "RLIST"},
+ {"gaus", "TYPE", "RUSER"},
+ {"lockertype", "TYPE", "COURSE"},
+ {"lockertype", "TYPE", "HOMEDIR"},
+ {"lockertype", "TYPE", "OTHER"},
+ {"lockertype", "TYPE", "PROJECT"},
+ {"lockertype", "TYPE", "SYSTEM"},
+ {"mac_type", "TYPE", "MAC"},
+ {"mac_type", "TYPE", "NEXT"},
+ {"mac_type", "TYPE", "PMAX"},
{"mac_type", "TYPE", "RT"},
{"mac_type", "TYPE", "VAX"},
+ {"member", "TYPE", "KERBEROS"},
{"member", "TYPE", "LIST"},
{"member", "TYPE", "STRING"},
{"member", "TYPE", "USER"},
{"pobox", "TYPE", "SMTP"},
{"pobox", "TYPE", "NONE"},
{"pobox", "TYPE", "POP"},
- {"service", "TYPE", "replicated"},
- {"service", "TYPE", "unique"},
- {"slabel", "TYPE", "usrlib"},
- {"slabel", "TYPE", "syslib"},
- {"slabel", "TYPE", "lpr"},
- {"slabel", "TYPE", "zephyr"},
- {"slabel", "TYPE", "kerberos"},
+ {"quota_type", "TYPE", "USER"},
+ {"quota_type", "TYPE", "GROUP"},
+ {"quota_type", "TYPE", "ANY"},
+ {"rmember", "TYPE", "LIST"},
+ {"rmember", "TYPE", "STRING"},
+ {"rmember", "TYPE", "USER"},
+ {"rmember", "TYPE", "KERBEROS"},
+ {"rmember", "TYPE", "RLIST"},
+ {"rmember", "TYPE", "RSTRING"},
+ {"rmember", "TYPE", "RUSER"},
+ {"rmember", "TYPE", "RKERBEROS"},
+ {"service", "TYPE", "REPLICAT"},
+ {"service", "TYPE", "REPLICATED"},
+ {"service", "TYPE", "UNIQUE"},
+ {"slabel", "TYPE", "LPR"},
+ {"slabel", "TYPE", "KERBEROS"},
+ {"slabel", "TYPE", "USRLIB"},
+ {"slabel", "TYPE", "SYSLIB"},
+ {"slabel", "TYPE", "ZEPHYR"},
+ {"ANY", "TYPEDATA", "none"},
+ {"KERBEROS", "TYPEDATA", "string"},
+ {"GROUP", "TYPEDATA", "list"},
{"LIST", "TYPEDATA", "list"},
- {"NONE", "TYPEDATA", ""},
+ {"NONE", "TYPEDATA", "none"},
{"POP", "TYPEDATA", "machine"},
+ {"RLIST", "TYPEDATA", "list"},
+ {"RSTRING", "TYPEDATA", "string"},
+ {"RUSER", "TYPEDATA", "user"},
{"SMTP", "TYPEDATA", "string"},
{"STRING", "TYPEDATA", "string"},
- {"USER", "TYPEDATA", "user"},
+ {"USER", "TYPEDATA", "user"},
0 };
char **argv;
{
char buffer[256];
-## char *table, *user, *value, *query, *trans, *type;
+## char *table, *user, *value, *query, *trans, *type, *db;
## int i, flag;
+ if (argc == 2)
+ db = argv[1];
+ else
+ db = "sms";
IIseterr(ingerr);
-## ingres testsms
+## ingres db
if (ingres_errno) {
printf("Unable to open the database\n");
exit(1);
printf("Unable to install 0 user\n");
exit(1);
}
-## append machine (name = "[none]", #type="NONE")
+## append machine (name = "[NONE]", #type="NONE")
if (ingres_errno) {
printf("Unable to install 0 machine\n");
exit(1);
printf("Unable to install 0 list\n");
exit(1);
}
+## append filesys (label = "[none]", #type = "NONE")
+ if (ingres_errno) {
+ printf("Unable to install 0 filesys\n");
+ exit(1);
+ }
+## append nfsphys (device = "/dev/null")
+ if (ingres_errno) {
+ printf("Unable to install 0 nfsphys\n");
+ exit(1);
+ }
/* magic for ALL_USERS */
## append users (login = "default", users_id = 1, potype="NONE")
printf("Unable to install default list\n");
exit(1);
}
-## append members (list_id = 1, member_type = "USER", member_id = 1)
+## append imembers (list_id = 1, member_type = "USER", member_id = 1,
+## ref_count = 1, direct = 1)
if (ingres_errno) {
printf("Unable to install default user on default list\n");
exit(1);
}
- /* Priveleged users */
+ /* Privileged users */
## append users (login = "root", users_id = 2, potype="NONE")
if (ingres_errno) {
printf("Unable to install root user\n");
exit(1);
}
- printf("What is the name of a priveleged user: ");
+ printf("What is the name of a privileged user: ");
fflush(stdout);
gets(buffer);
user = buffer;
printf("Unable to install user %s\n", buffer);
exit(1);
}
-## append members (list_id = 2, member_type = "USER", member_id = 3)
+## append imembers (list_id = 2, member_type = "USER", member_id = 2,
+## ref_count = 1, direct = 1)
+ if (ingres_errno) {
+ printf("Unable to put user root on list dbadmin\n");
+ exit(1);
+ }
+## append imembers (list_id = 2, member_type = "USER", member_id = 3,
+## ref_count = 1, direct = 1)
if (ingres_errno) {
printf("Unable to put user %s on list dbadmin\n", buffer);
exit(1);
}
/* And the capacls */
- for (i = 0; i < QueryCount1; i++) {
- query = Queries1[i].name;
- value = Queries1[i].shortname;
+ for (i = 0; i < QueryCount2; i++) {
+ query = Queries2[i].name;
+ value = Queries2[i].shortname;
## repeat append capacls (capability = @query, tag = @value, list_id = 2)
if (ingres_errno) {
printf("Unable to install query ACL for %s (%s)\n", query, value);
exit(1);
}
}
- for (i = 0; i < QueryCount2; i++) {
- query = Queries2[i].name;
- value = Queries2[i].shortname;
-## repeat retrieve (flag = any(capacls.tag where capacls.tag = @value))
- if (!flag) {
-## repeat append capacls (capability = @query, tag = @value, list_id = 2)
- if (ingres_errno) {
- printf("Unable to install query ACL for %s (%s)\n", query, value);
- exit(1);
- }
- }
- }
+## append capacls (capability = "trigger_dcm", tag = "tdcm", list_id = 2)
/* and the aliases */
for (i = 0; aliases[i].name ; i++) {
/* dummy routines */
+int access_user() {}
+int access_login() {}
int access_list() {}
int access_visible_list() {}
-int access_maillist() {}
-int access_user() {}
+int access_vis_list_by_name() {}
+int access_member() {}
+int access_qgli() {}
+int access_service() {}
+int access_filesys() {}
int setup_ausr() {}
-int setup_add_group() {}
-int setup_add_filesys() {}
-int setup_update_filesys() {}
-int setup_umac() {}
+int setup_dusr() {}
+int setup_spop() {}
+int setup_dpob() {}
int setup_dmac() {}
-int setup_uclu() {}
int setup_dclu() {}
-int setup_dusr() {}
+int setup_alis() {}
+int setup_dlis() {}
int setup_dsin() {}
int setup_dshi() {}
-int setup_dlis() {}
-int validate_label() {}
-int validate_label_2() {}
-int uusr_login_check() {}
-int delete_user_poboxes() {}
-int delete_current_quota() {}
+int setup_afil() {}
+int setup_ufil() {}
+int setup_dfil() {}
+int setup_dnfp() {}
+int setup_dqot() {}
+int setup_sshi() {}
+int setup_akum() {}
+int followup_fix_modby() {}
+int followup_ausr() {}
+int followup_gpob() {}
+int followup_glin() {}
+int followup_aqot() {}
+int followup_gzcl() {}
+int followup_gsha() {}
+int followup_gqot() {}
int set_modtime() {}
int set_modtime_by_id() {}
-int set_user_modtime() {}
-int set_user_modtime_by_id() {}
int set_finger_modtime() {}
-int set_filesys_modtime() {}
-int set_mach_modtime() {}
+int set_pobox_modtime() {}
+int set_uppercase_modtime() {}
int set_mach_modtime_by_id() {}
+int set_cluster_modtime_by_id() {}
int set_serverhost_modtime() {}
-int followup_amtl() {}
-int followup_ausr() {}
-int followup_delete_list() {}
-int followup_add_pobox() {}
-int followup_delete_pobox() {}
-int followup_usha() {}
-int followup_old_gpob() {}
-int followup_fix_acl() {}
-int translate_ids() {}
-int expand_list_flags() {}
-int add_new_quota() {}
-int add_hostaccess() {}
-int delete_hostaccess() {}
-int get_query_need() {}
-int get_list_is_group() {}
-int get_list_is_maillist() {}
-int add_locker() {}
-int delete_locker() {}
-int add_user_group() {}
-int set_user_pobox() {}
-int get_members_of_list() {}
-int get_groups_of_user() {}
-int get_groups_of_all_users() {}
-int get_all_poboxes() {}
-int get_new_poboxes() {}
-int get_lists_of_administrator() {}
-int followup_gpob() {}
+int set_nfsphys_modtime() {}
+int set_filesys_modtime() {}
+int set_zephyr_modtime() {}
int set_pobox() {}
-int setup_spop() {}
-int set_pobox_modtime() {}
-int setup_dpob() {}
-int set_cluster_modtime_by_id() {}
-int access_service() {}
-int followup_glin() {}
+int get_list_info() {}
+int add_member_to_list() {}
+int delete_member_from_list() {}
+int get_ace_use() {}
+int qualified_get_lists() {}
+int get_members_of_list() {}
int qualified_get_server() {}
int qualified_get_serverhost() {}
int trigger_dcm() {}
-int set_nfsphys_modtime() {}
-int setup_alis() {}
-int access_member() {}
-int get_acl_use() {}
-int access_qgli() {}
-int qualified_get_lists() {}
+int count_members_of_list() {}
+int get_lists_of_member() {}
+int register_user() {}
+int followup_gpce() {}
andersk / moira.git / blobdiff