-/* #define GDSS */
/*
* $Source$
* $Author$
extern char *whoami, *strsave();
extern int ingres_errno, mr_errcode;
-EXEC SQL BEGIN DECLARE SECTION;
-int idummy;
-extern char cdummy[];
+EXEC SQL BEGIN DECLARE SECTION;
extern char stmt_buf[];
-EXEC SQL END DECLARE SECTION;
+EXEC SQL END DECLARE SECTION;
/* Specialized Access Routines */
return(MR_SUCCESS);
}
-
+
/* access_login - verify that client name equals specified login name
*
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id;
char qual[256];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
build_qual(q->qual, q->argc, argv, qual);
- EXEC SQL SELECT users_id INTO :id FROM users WHERE :qual;
+ if (!strncmp(q->name,"get_user_account",strlen("get_user_account"))) {
+ EXEC SQL SELECT users_id INTO :id FROM users u, strings str WHERE :qual;
+ } else {
+ EXEC SQL SELECT users_id INTO :id FROM users u WHERE :qual;
+ }
if (sqlca.sqlerrd[2] != 1 || id != cl->users_id)
return(MR_PERM);
return(MR_SUCCESS);
}
-
+
/* access_list - check access for most list operations
*
* - check that client is a member of the access control list
* - OR, if the query is add_member_to_list or delete_member_from_list
* and the list is public, allow access if client = member
- */
+ */
access_list(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int list_id, acl_id, flags, gid;
char acl_type[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *client_type;
int client_id, status;
list_id = *(int *)argv[0];
- EXEC SQL SELECT acl_id, acl_type, gid, publicflg
+ EXEC SQL SELECT acl_id, acl_type, gid, publicflg
INTO :acl_id, :acl_type, :gid, :flags
FROM list
WHERE list_id = :list_id;
*
* Inputs: argv[0] - list_id
* cl - client identifier
- */
+ */
access_visible_list(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int list_id, acl_id, flags ;
char acl_type[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *client_type;
int client_id, status;
list_id = *(int *)argv[0];
- EXEC SQL SELECT hidden, acl_id, acl_type
+ EXEC SQL SELECT hidden, acl_id, acl_type
INTO :flags, :acl_id, :acl_type
FROM list
WHERE list_id = :list_id;
*
* Inputs: argv[0] - list name
* cl - client identifier
- */
+ */
access_vis_list_by_name(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int acl_id, flags, rowcount;
char acl_type[9], *listname;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *client_type;
int client_id, status;
return(MR_SUCCESS);
}
+ if (!strcmp(argv[0], "KERBEROS") || !strcmp(argv[0], "RKERBERO")) {
+ if (cl->client_id == *(int *)argv[1])
+ return(MR_SUCCESS);
+ }
+
return(MR_PERM);
}
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int acl_id;
char *name, acl_type[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int client_id, status;
char *client_type, *c;
- name = argv[0];
+ name = argv[0];
for(c=name;*c;c++) if(islower(*c)) *c = toupper(*c); /* uppercasify */
EXEC SQL SELECT acl_id, acl_type INTO :acl_id, :acl_type FROM servers
WHERE name = :name;
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int users_id, list_id;
char *name;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status, client_id;
char *client_type;
- name = argv[0];
+ name = argv[0];
EXEC SQL SELECT owner, owners INTO :users_id, :list_id FROM filesys
WHERE label = :name;
return(MR_PERM);
}
-
+
\f
/* Setup Routines */
client *cl;
{
int row;
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int nuid;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
if (!strcmp(q->shortname, "uusr") || !strcmp(q->shortname, "uuac"))
row = 2;
}
-/* setup_dusr - verify that the user is no longer being referenced
+/* setup_dusr - verify that the user is no longer being referenced
* and may safely be deleted.
*/
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int flag, id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int flag, id, cnt;
+ EXEC SQL END DECLARE SECTION;
id = *(int *)argv[0];
/* For now, only allow users to be deleted if their status is 0 */
- EXEC SQL REPEATED SELECT status INTO :flag FROM users
+ EXEC SQL REPEATED SELECT status INTO :flag FROM users
WHERE users_id = :id;
if (flag != 0 && flag != 4)
return(MR_IN_USE);
- EXEC SQL REPEATED DELETE FROM quota WHERE entity_id = :id AND type = 'USER';
+ EXEC SQL REPEATED DELETE FROM quota WHERE entity_id = :id AND type='USER';
EXEC SQL REPEATED DELETE FROM krbmap WHERE users_id = :id;
- EXEC SQL REPEATED SELECT member_id INTO :idummy FROM imembers
+ EXEC SQL REPEATED SELECT COUNT(member_id) INTO :cnt FROM imembers
WHERE member_id = :id AND member_type = 'USER';
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT label INTO :cdummy FROM filesys WHERE owner = :id;
- if (sqlca.sqlerrd[2]> 0)
+ EXEC SQL REPEATED SELECT COUNT(label) INTO :cnt FROM filesys
+ WHERE owner = :id;
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT name INTO :cdummy FROM list
+ EXEC SQL REPEATED SELECT COUNT(name) INTO :cnt FROM list
WHERE acl_id = :id AND acl_type = 'USER';
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT name INTO :cdummy FROM servers
+ EXEC SQL REPEATED SELECT COUNT(name) INTO :cnt FROM servers
WHERE acl_id = :id AND acl_type = 'USER';
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT acl_id INTO :idummy FROM hostaccess
+ EXEC SQL REPEATED SELECT COUNT(acl_id) INTO :cnt FROM hostaccess
WHERE acl_id = :id AND acl_type = 'USER';
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
if (ingres_errno)
return(mr_errcode);
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id, mid, flag;
char type[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
- id = *(int *)argv[0];
+ id = *(int *)argv[0];
EXEC SQL REPEATED SELECT potype, pop_id INTO :type, :mid FROM users
WHERE users_id = :id;
if(sqlca.sqlerrd[2] = 0)
return(MR_MACHINE);
- EXEC SQL REPEATED SELECT mach_id INTO :mid FROM machine
+ EXEC SQL REPEATED SELECT mach_id INTO :mid FROM machine
WHERE mach_id = :mid;
if (sqlca.sqlerrd[2] = 0)
return(MR_MACHINE);
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id, user;
char type[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
user = *(int *)argv[0];
EXEC SQL REPEATED SELECT potype, pop_id INTO :type, :id FROM users
}
-/* setup_dmac - verify that the machine is no longer being referenced
+/* setup_dmac - verify that the machine is no longer being referenced
* and may safely be deleted.
*/
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int flag, id;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int flag, id, cnt;
EXEC SQL END DECLARE SECTION;
id = *(int *)argv[0];
- EXEC SQL REPEATED SELECT login INTO :cdummy FROM users
+ EXEC SQL REPEATED SELECT COUNT(login) INTO :cnt FROM users
WHERE potype='POP' AND pop_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT mach_id INTO :idummy FROM serverhosts
+ EXEC SQL REPEATED SELECT COUNT(mach_id) INTO :cnt FROM serverhosts
WHERE mach_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT mach_id INTO :idummy FROM nfsphys
+ EXEC SQL REPEATED SELECT COUNT(mach_id) INTO :cnt FROM nfsphys
WHERE mach_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT mach_id INTO :idummy FROM hostaccess
+ EXEC SQL REPEATED SELECT COUNT(mach_id) INTO :cnt FROM hostaccess
WHERE mach_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT mach_id INTO :idummy FROM printcap
+ EXEC SQL REPEATED SELECT COUNT(mach_id) INTO :cnt FROM printcap
WHERE mach_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT quotaserver INTO :idummy FROM printcap
+ EXEC SQL REPEATED SELECT COUNT(quotaserver) INTO :cnt FROM printcap
WHERE quotaserver = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT mach_id INTO :idummy FROM palladium
+ EXEC SQL REPEATED SELECT COUNT(mach_id) INTO :cnt FROM palladium
WHERE mach_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
EXEC SQL REPEATED DELETE FROM mcmap WHERE mach_id = :id;
}
-/* setup_dclu - verify that the cluster is no longer being referenced
+/* setup_dclu - verify that the cluster is no longer being referenced
* and may safely be deleted.
*/
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int id, cnt;
+ EXEC SQL END DECLARE SECTION;
id = *(int *)argv[0];
- EXEC SQL REPEATED SELECT mach_id INTO :idummy FROM mcmap
+ EXEC SQL REPEATED SELECT COUNT(mach_id) INTO :cnt FROM mcmap
WHERE clu_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
- EXEC SQL REPEATED SELECT clu_id INTO :idummy FROM svc
+ EXEC SQL REPEATED SELECT COUNT(clu_id) INTO :cnt FROM svc
WHERE clu_id = :id;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
if (ingres_errno)
return(mr_errcode);
* a new gid and put it in argv[6]. Otherwise if argv[6] is UNIQUE_ID but
* argv[5] is not, then remember that UNIQUE_ID is being stored by putting
* a -1 there. Remember that this is also used for ulis, with the indexes
- * at 6 & 7.
+ * at 6 & 7. Also check that the list name does not contain uppercase
+ * characters, control characters, @, or :.
*/
+static int badlistchars[] = {
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* ^@ - ^O */
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* ^P - ^_ */
+ 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, /* SPACE - / */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, /* 0 - ? */
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* @ - O */
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, /* P - _ */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, /* ` - o */
+ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, /* p - ^? */
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+ 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
+};
+
int setup_alis(q, argv, cl)
struct query *q;
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int ngid;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *malloc();
+ unsigned char *p;
int idx;
if (!strcmp(q->shortname, "alis"))
- idx = 6;
+ idx = 0;
else if (!strcmp(q->shortname, "ulis"))
- idx = 7;
+ idx = 1;
- if (!strcmp(argv[idx], UNIQUE_GID) || atoi(argv[idx]) == -1) {
- if (atoi(argv[idx - 1])) {
+ for (p = (unsigned char *) argv[idx]; *p; p++)
+ if (badlistchars[*p])
+ return(MR_BAD_CHAR);
+
+ if (!strcmp(argv[6 + idx], UNIQUE_GID) || atoi(argv[6 + idx]) == -1) {
+ if (atoi(argv[5 + idx])) {
if (set_next_object_id("gid", "list", 1))
return(MR_INGRES_ERR);
EXEC SQL REPEATED SELECT value INTO :ngid FROM numvalues
WHERE name = 'gid';
if (ingres_errno) return(mr_errcode);
- sprintf(argv[idx], "%d", ngid);
+ sprintf(argv[6 + idx], "%d", ngid);
} else {
- strcpy(argv[idx], "-1");
+ strcpy(argv[6 + idx], "-1");
}
}
}
-/* setup_dlis - verify that the list is no longer being referenced
+/* setup_dlis - verify that the list is no longer being referenced
* and may safely be deleted.
*/
struct query *q;
char *argv[];
{
- EXEC SQL BEGIN DECLARE SECTION;
- int flag, id;
- EXEC SQL END DECLARE SECTION;
+ int flag, id, ec;
id = *(int *)argv[0];
- EXEC SQL REPEATED SELECT member_id INTO :idummy FROM imembers
- WHERE member_id = :id AND member_type='LIST';
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT member_id INTO :idummy FROM imembers
- WHERE list_id = :id;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT label INTO :cdummy FROM filesys
- WHERE owners = :id;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT tag INTO :cdummy FROM capacls
- WHERE list_id = :id;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT name INTO :cdummy FROM list
- WHERE acl_id = :id AND acl_type='LIST' AND list_id = :id;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT name INTO :cdummy FROM servers
- WHERE acl_id = :id AND acl_type='LIST';
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT entity_id INTO :idummy FROM quota
- WHERE entity_id = :id AND type='GROUP';
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT acl_id INTO :idummy FROM hostaccess
- WHERE acl_id = :id AND acl_type='LIST';
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT class INTO :cdummy FROM zephyr z
- WHERE z.xmt_type = 'LIST' AND z.xmt_id = :id
- OR z.sub_type = 'LIST' AND z.sub_id = :id
- OR z.iws_type = 'LIST' AND z.iws_id = :id
- OR z.iui_type = 'LIST' AND z.iui_id = :id;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- if (ingres_errno)
- return(mr_errcode);
+ sprintf(stmt_buf,"SELECT member_id FROM imembers WHERE member_id = %d AND member_type='LIST'",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT member_id FROM imembers WHERE list_id = %d",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT label FROM filesys WHERE owners = %d",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT tag FROM capacls WHERE list_id = %d",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT name FROM list WHERE acl_id = %d AND acl_type='LIST' AND list_id != %d",id,id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT name FROM servers WHERE acl_id = %d AND acl_type='LIST'",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT entity_id FROM quota WHERE entity_id = %d AND type='GROUP'",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT acl_id FROM hostaccess WHERE acl_id = %d AND acl_type='LIST'",id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
+ sprintf(stmt_buf,"SELECT class FROM zephyr z \
+WHERE z.xmt_type = 'LIST' AND z.xmt_id = %d \
+OR z.sub_type = 'LIST' AND z.sub_id = %d \
+OR z.iws_type = 'LIST' AND z.iws_id = %d \
+OR z.iui_type = 'LIST' AND z.iui_id = %d",id,id,id,id);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS) return(MR_IN_USE); else return(ec);
+ }
+
return(MR_SUCCESS);
}
-/* setup_dsin - verify that the service is no longer being referenced
+/* setup_dsin - verify that the service is no longer being referenced
* and may safely be deleted.
*/
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
- char *name;
- EXEC SQL END DECLARE SECTION;
- char *c;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int ec;
+ char *svrname;
+ EXEC SQL END DECLARE SECTION;
- name = argv[0];
- for(c=name;*c;c++) if(islower(*c)) *c = toupper(*c);
- EXEC SQL REPEATED SELECT service INTO :cdummy FROM serverhosts
- WHERE service = :name;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- EXEC SQL REPEATED SELECT inprogress INTO :idummy FROM servers
- WHERE name = :name;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- if (ingres_errno)
+ sprintf(stmt_buf,"SELECT service FROM serverhosts WHERE service = UPPERCASE('%s')",argv[0]);
+ if(ec=mr_select_any(stmt_buf)) {
+ if(ec==MR_EXISTS)
+ return(MR_IN_USE);
+ else
+ return(ec);
+ }
+
+ svrname=argv[0];
+ EXEC SQL SELECT inprogress INTO :ec FROM servers
+ WHERE name=UPPERCASE(:svrname);
+ if(ingres_errno)
return(mr_errcode);
+ if(ec)
+ return(MR_IN_USE);
+
return(MR_SUCCESS);
}
-/* setup_dshi - verify that the service-host is no longer being referenced
+/* setup_dshi - verify that the service-host is no longer being referenced
* and may safely be deleted.
*/
struct query *q;
char **argv;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int id;
- char *name, *c;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int id, ec;
+ char *svrname;
+ EXEC SQL END DECLARE SECTION;
- name = argv[0];
- for(c=name;*c;c++) if(islower(*c)) *c = toupper(*c); /* to uppercase */
+ svrname=argv[0];
id = *(int *)argv[1];
- EXEC SQL REPEATED SELECT inprogress INTO :idummy FROM serverhosts
- WHERE service = :name AND mach_id = :id;
- if (sqlca.sqlerrd[2] > 0)
- return(MR_IN_USE);
- if (ingres_errno)
+
+ EXEC SQL SELECT inprogress INTO :ec FROM serverhosts
+ WHERE service=UPPERCASE(:svrname) AND mach_id = :id;
+ if(ingres_errno)
return(mr_errcode);
+ if(ec)
+ return(MR_IN_USE);
+
+
return(MR_SUCCESS);
}
**
**/
-EXEC SQL BEGIN DECLARE SECTION;
+EXEC SQL BEGIN DECLARE SECTION;
static int var_phys_id;
-EXEC SQL END DECLARE SECTION;
+EXEC SQL END DECLARE SECTION;
setup_afil(q, argv, cl)
struct query *q;
{
char *type, *name;
int mach_id;
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int ok;
char ftype[32], *access;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
type = argv[1];
mach_id = *(int *)argv[2];
var_phys_id = 0;
sprintf(ftype, "fs_access_%s", type);
- EXEC SQL SELECT trans INTO :cdummy FROM alias
- WHERE name = :ftype AND type = 'TYPE' and trans = :access;
+ EXEC SQL SELECT COUNT(trans) INTO :ok FROM alias
+ WHERE name = :ftype AND type = 'TYPE' and trans = :access;
if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] == 0) return(MR_FILESYS_ACCESS);
+ if (ok == 0) return(MR_FILESYS_ACCESS);
- if (!strcmp(type, "NFS"))
- return (check_nfs(mach_id, name, access));
-
if((mr_errcode=prefetch_value(q,argv,cl))!=MR_SUCCESS)
return(mr_errcode);
+ if (!strcmp(type, "NFS"))
+ return (check_nfs(mach_id, name, access));
+
return(MR_SUCCESS);
}
client *cl;
{
int mach_id, status;
- char *type, *name;
- EXEC SQL BEGIN DECLARE SECTION;
- int fid, total, who;
+ char *type, *name;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int fid, total, who, ok;
char *entity, ftype[32], *access;
int var_phys_id = 0;
- EXEC SQL END DECLARE SECTION;
+ short int total_null;
+ EXEC SQL END DECLARE SECTION;
type = argv[2];
mach_id = *(int *)argv[3];
entity = cl->entity;
sprintf(ftype, "fs_access_%s", type);
- EXEC SQL SELECT trans INTO :cdummy FROM alias
+ EXEC SQL SELECT COUNT(trans) INTO :ok FROM alias
WHERE name = :ftype AND type='TYPE' AND trans = :access;
if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] == 0) return(MR_FILESYS_ACCESS);
+ if (ok == 0) return(MR_FILESYS_ACCESS);
+
+ EXEC SQL SELECT type INTO :ftype FROM filesys
+ WHERE filsys_id = :fid;
+ strtrim(ftype);
+ if (ingres_errno) return(mr_errcode);
if (!strcmp(type, "NFS")) {
status = check_nfs(mach_id, name, access);
WHERE filsys_id = :fid;
if (ingres_errno) return(mr_errcode);
return(status);
- } else if (!strcmp(type, "AFS")) {
+ } else if (!strcmp(type, "AFS") && strcmp(ftype, "AFS")) {
total = 0;
- EXEC SQL REPEATED DELETE FROM quota
+ EXEC SQL REPEATED DELETE FROM quota
WHERE type = 'ANY' AND filsys_id = :fid;
- EXEC SQL SELECT SUM (quota) INTO :total FROM quota
+ EXEC SQL SELECT SUM (quota) INTO :total:total_null FROM quota
WHERE filsys_id = :fid AND phys_id != 0;
if (ingres_errno) return(mr_errcode);
- if (total != 0) {
+ if (!total_null && (total != 0)) {
/*
* append quota (quota = total, filsys_id = fid,
* phys_id = 0, entity_id = 0, type = "ANY",
* modtime = "now", modby = who, modwith = entity)
*/
- EXEC SQL INSERT INTO quota (quota, filsys_id, phys_id, entity_id,
+ EXEC SQL INSERT INTO quota (quota, filsys_id, phys_id, entity_id,
type, modtime, modby, modwith)
- VALUES (:total, :fid, 0, 0,
+ VALUES (:total, :fid, 0, 0,
'ANY', 'now', :who, :entity) ;
if (ingres_errno) return(mr_errcode);
}
/* Find the NFS physical partition that the named directory is on.
* This is done by comparing the dir against the mount point of the
- * partition. To make sure we get the correct match when there is
+ * partition. To make sure we get the correct match when there is
* more than one, we sort the query in reverse order by dir name.
*/
check_nfs(mach_id, name, access)
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int mach_id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *name;
char *access;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char dir[81];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char caccess;
register int status;
register char *cp1;
status = MR_NFS;
EXEC SQL DECLARE csr101 CURSOR FOR
SELECT nfsphys_id, TRIM (dir) FROM nfsphys
- WHERE mach_id = :mach_id
+ WHERE mach_id = :mach_id
ORDER BY 2 DESC;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr101;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr101 INTO :var_phys_id, :dir;
if(sqlca.sqlcode != 0) break;
if (*cp2 == 0) {
status = MR_SUCCESS;
break;
- }
+ }
}
EXEC SQL CLOSE csr101;
if (ingres_errno)
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int id, total;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int id, total, phys_id;
+ short int none;
+ EXEC SQL END DECLARE SECTION;
id = *(int *)argv[0];
- EXEC SQL REPEATED SELECT SUM (quota) INTO :total FROM quota
+ EXEC SQL REPEATED SELECT SUM (quota) INTO :total:none FROM quota
+ WHERE filsys_id = :id;
+
+ if(none) total=0;
+
+ /** What if there are multiple phys_id's per f/s? (bad data) **/
+ EXEC SQL REPEATED SELECT phys_id INTO :phys_id FROM filesys
WHERE filsys_id = :id;
EXEC SQL REPEATED UPDATE nfsphys SET allocated = allocated - :total
- WHERE nfsphys_id = filesys.phys_id AND filesys.filsys_id = :id;
- /** Is SQL smart enough to do the PRODUCT above? */
- /** Or should we code it using another SELECT? */
+ WHERE nfsphys_id = :phys_id;
- EXEC SQL REPEATED DELETE FROM quota WHERE filsys_id = :id;
+ if(!none) {
+ EXEC SQL REPEATED DELETE FROM quota WHERE filsys_id = :id;
+ }
EXEC SQL REPEATED DELETE FROM fsgroup WHERE filsys_id = :id;
EXEC SQL REPEATED DELETE FROM fsgroup WHERE group_id = :id;
if (ingres_errno) return(mr_errcode);
}
-/* setup_aftg: needed only because using the query table would
- * create an invalid SQL statement. *sigh* Basically just validates
- * that the first argument has type 'FSGROUP' in table 'filesys'.
- */
-
-setup_aftg(q, argv, cl)
- struct query *q;
- char **argv;
- client *cl;
-{
- EXEC SQL SELECT filsys_id INTO :idummy FROM filesys
- WHERE type='FSGROUP';
-
- if (sqlca.sqlcode != 0)
- return(MR_NO_MATCH); /* Is there a better error code to return? */
-
- return(MR_SUCCESS);
-}
-
-
/* setup_dnfp: check to see that the nfs physical partition does not have
* any filesystems assigned to it before allowing it to be deleted.
*/
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int id;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int id, cnt;
char *dir;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
id = *(int *)argv[0];
dir = argv[1];
- EXEC SQL REPEATED SELECT label INTO :cdummy FROM filesys fs, nfsphys np
- WHERE fs.mach_id = :id AND fs.phys_id = np.nfsphys_id
+ EXEC SQL REPEATED SELECT fs.tid INTO :cnt FROM filesys fs, nfsphys np
+ WHERE fs.mach_id = :id AND fs.phys_id = np.nfsphys_id
AND np.mach_id = :id AND np.dir = :dir;
- if (sqlca.sqlerrd[2] > 0)
+ if (cnt > 0)
return(MR_IN_USE);
if (ingres_errno)
return(mr_errcode);
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int quota, fs, id;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int quota, fs, id, physid;
char *qtype;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
fs = *(int *)argv[0];
if (!strcmp(q->name, "update_quota") || !strcmp(q->name, "delete_quota")) {
EXEC SQL REPEATED SELECT quota INTO :quota FROM quota
WHERE type = :qtype AND entity_id = :id AND filsys_id = :fs;
- EXEC SQL REPEATED UPDATE nfsphys
- SET allocated = nfsphys.allocated - :quota
- WHERE nfsphys_id = filesys.physid AND filesys.filsys_id = :fs;
-
+ EXEC SQL REPEATED SELECT phys_id INTO :physid FROM filesys
+ WHERE filsys_id = :fs;
+ EXEC SQL REPEATED UPDATE nfsphys SET allocated = allocated - :quota
+ WHERE nfsphys_id = :physid;
+
if (ingres_errno) return(mr_errcode);
return(MR_SUCCESS);
}
/* setup_sshi: don't exclusive lock the machine table during
* set_server_host_internal.
*/
-
+/** Not allowed under (INGRES) SQL **/
setup_sshi(q, argv, cl)
struct query *q;
char **argv;
client *cl;
{
-#ifsql INGRES
+#if 0
+#ifsql INGRES
EXEC SQL set lockmode session where readlock = system;
#endsql
+#endif
+ return(MR_SUCCESS);
}
-/* setup add_kerberos_user_mapping: add the string to the string
+/* setup add_kerberos_user_mapping: add the string to the string
* table if necessary.
*/
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id, rowcount;
char *name;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
name = argv[1];
if (name_to_id(name, "STRING", &id) != MR_SUCCESS) {
if (q->type != APPEND) return(MR_STRING);
- EXEC SQL SELECT value INTO :id FROM numvalues
- WHERE name = 'strings_id';
- id++;
- EXEC SQL UPDATE numvalues SET value = :id
- WHERE name = 'strings_id';
- EXEC SQL INSERT INTO strings (string_id, string) VALUES (:id, :name);
+ id=add_string(name);
cache_entry(name, "STRING", id);
}
if (ingres_errno) return(mr_errcode);
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int users_id, who;
char *entity;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int users_id, who;
char *entity;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
sprintf(stmt_buf,"UPDATE %s SET modtime = 'now', modby = %d, modwith = '%s' WHERE %s.name = UPPERCASE(LEFT('%s',SIZE(%s.name)))",table,who,entity,table,name,table);
EXEC SQL EXECUTE IMMEDIATE :stmt_buf;
-
+
return(MR_SUCCESS);
}
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *entity;
int who, id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
id = *(int *)argv[0];
EXEC SQL UPDATE machine SET modtime='now', modby = :who, modwith = :entity
WHERE machine.mach_id = :id;
-
+
return(MR_SUCCESS);
}
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *entity;
int who, id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *entity, *serv;
int who, id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
serv = argv[0];
id = *(int *)argv[1];
- EXEC SQL UPDATE serverhosts
+ EXEC SQL UPDATE serverhosts
SET modtime = 'now', modby = :who, modwith = :entity
- WHERE service = :serv AND mach_id = :id;
+ WHERE service = :serv AND mach_id = :id;
return(MR_SUCCESS);
}
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *entity, *dir;
int who, id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *label, *entity;
int who;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
if (!strcmp(q->shortname, "ufil"))
label = argv[1];
- EXEC SQL UPDATE filesys SET modtime = 'now', modby = :who,
+ EXEC SQL UPDATE filesys SET modtime = 'now', modby = :who,
modwith = :entity, phys_id = :var_phys_id
WHERE label = LEFT(:label,SIZE(label));
return(MR_SUCCESS);
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *class, *entity;
int who;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
entity = cl->entity;
who = cl->client_id;
EXEC SQL UPDATE zephyr SET modtime = 'now', modby = :who, modwith = :entity
WHERE class = LEFT(:class,SIZE(class));
-
+
return(MR_SUCCESS);
}
register int i, j;
char **argv, *malloc();
#ifdef GDSS
- char sigbuf[256], *rawsig, *kname;
+ unsigned char sigbuf[256];
+ char *kname;
SigInfo si;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int timestamp, who;
+ char *login;
+ varchar struct { short data_size; char data_buf[257];} rsig;
+ EXEC SQL END DECLARE SECTION;
#endif /* GDSS */
int id, status;
i = q->vcnt - 2;
while (sq_get_data(sq, &argv)) {
+#ifdef DEBUG
+ com_err(whoami, 0, "argv[SIGNATURE] = \"%s\"", argv[U_SIGNATURE]);
+#endif /* DEBUG */
id = atoi(argv[i]);
if (id > 0)
status = id_to_name(id, "USER", &argv[i]);
if (status && status != MR_NO_MATCH)
return(status);
#ifdef GDSS
- if (q->vcnt == U_END) {
- com_err(whoami, 0, "compressing signature");
- rawsig = argv[U_SIGNATURE];
- bcopy(&rawsig[0], &id, sizeof(int));
- id = ntohl(id);
- status = id_to_name(id, "STRING", &kname);
- bcopy(&rawsig[4], &si.timestamp, sizeof(int));
- si.timestamp = ntohl(si.timestamp);
+ if (q->vcnt == U_END && strlen(argv[U_SIGNATURE])) {
+ login = argv[U_NAME];
+ EXEC SQL REPEATED SELECT signature, sigdate, sigwho
+ INTO :rsig, :timestamp, :who FROM users
+ WHERE login = :login;
+ /** What about (INGRES) error handling? **/
+ kname = malloc(1);
+ status = id_to_name(who, "STRING", &kname);
+ si.timestamp = timestamp;
si.SigInfoVersion = 0; /* XXXXX this isn't used */
kname_parse(si.pname, si.pinst, si.prealm, kname);
- si.rawsig = (unsigned char *)&rawsig[8];
+ free(kname);
+ rsig.data_buf[rsig.data_size] = 0;
+ si.rawsig = (unsigned char *)strsave(rsig.data_buf);
+ if (log_flags & LOG_GDSS)
+ com_err(whoami, 0, "rawsig length = %d, sig=\"%s\"", strlen(si.rawsig), si.rawsig);
GDSS_Recompose(&si, sigbuf);
+ free(si.rawsig);
+ free(argv[U_SIGNATURE]);
argv[U_SIGNATURE] = strsave(sigbuf);
+ if (log_flags & LOG_GDSS)
+ com_err(whoami, 0, "generated signature length %d", strlen(sigbuf));
}
#endif /* GDSS */
(*action)(q->vcnt, argv, actarg);
char *argv[];
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int who, status, sigwho, id;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int who, status, id;
char *login, *entity, *src, *dst, *name;
char fullname[129];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
#ifdef GDSS
char databuf[32], *kname_unparse();
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char rawsig[128];
- EXEC SQL END DECLARE SECTION;
+ int sigwho, timestamp;
+ EXEC SQL END DECLARE SECTION;
SigInfo si;
#endif /* GDSS */
sprintf(fullname, "%s", argv[3]);
#ifdef GDSS
- sprintf(databuf, "%s:%s", argv[U_NAME], argv[U_MITID]);
- /* skip bytes for timestamp & kname */
- si.rawsig = (unsigned char *)&rawsig[8];
- status = GDSS_Verify(databuf, strlen(databuf), argv[U_SIGNATURE], &si);
- if (status == 0) {
- name = kname_unparse(si.pname, si.pinst, si.prealm);
- status = name_to_id(name, "STRING", &sigwho);
- if (status == MR_NO_MATCH) {
- EXEC SQL REPEATED SELECT value INTO :sigwho FROM numvalues
- WHERE name = 'strings_id';
- sigwho++;
- EXEC SQL REPEATED UPDATE numvalues SET value = :sigwho
- WHERE name = 'strings_id';
- EXEC SQL INSERT INTO strings (string_id, string)
- VALUES (:sigwho, :name);
- } else if (status)
- return(status);
- sigwho = htonl(sigwho);
- bcopy(&sigwho, &rawsig[0], sizeof(int));
- si.timestamp = htonl(si.timestamp);
- bcopy(&si.timestamp, &rawsig[4], sizeof(int));
- } else
- return(status);
+ if (q->vcnt == U_END && *argv[U_SIGNATURE]) {
+ /* unquote ' chars in signature */
+ for (dst = src = argv[U_SIGNATURE]; *src; ) {
+ if (*src == '\'')
+ src++;
+ *dst++ = *src++;
+ }
+ *dst = 0;
+ sprintf(databuf, "%s:%s", argv[U_NAME], argv[U_MITID]);
+ /* skip bytes for timestamp & kname */
+ si.rawsig = (unsigned char *) rawsig;
+ status = GDSS_Verify(databuf, strlen(databuf), argv[U_SIGNATURE], &si);
+ if (strlen(rawsig) > mr_sig_length) {
+ com_err(whoami, 0, "GDSS signature would be truncated."); /** untested **/
+ return(MR_INTERNAL);
+ }
+ if (status == 0) {
+ name = kname_unparse(si.pname, si.pinst, si.prealm);
+ status = name_to_id(name, "STRING", &sigwho);
+ if (status == MR_NO_MATCH) {
+ sigwho=add_string(name);
+ } else if (status)
+ return(status);
+ timestamp = si.timestamp;
+ } else {
+ if (log_flags & LOG_GDSS)
+ hex_dump(argv[U_SIGNATURE]);
+ return(gdss2et(status));
+ }
+ } else {
+ rawsig[0] = 0;
+ sigwho = 0;
+ timestamp = 0;
+ }
#endif /* GDSS */
login = argv[0];
/* create finger entry, pobox & set modtime on user */
#ifdef GDSS
- EXEC SQL REPEATED UPDATE users
- SET modtime='now', modby=:who, modwith = :entity,
- fullname = :fullname, affiliation = type,
- signature = :rawsig,
+ EXEC SQL REPEATED UPDATE users
+ SET modtime='now', modby=:who, modwith = :entity,
+ fullname = :fullname, affiliation = type,
+ signature = :rawsig, sigdate = :timestamp, sigwho = :sigwho,
fmodtime='now', fmodby = :who, fmodwith = :entity,
potype='NONE', pmodtime='now', pmodby = :who, pmodwith = :entity
WHERE login = :login;
#else /* GDSS */
EXEC SQL REPEATED UPDATE users
- SET modtime='now', modby=:who, modwith = :entity,
- fullname = :fullname, affiliation = type,
+ SET modtime='now', modby=:who, modwith = :entity,
+ fullname = :fullname, affiliation = type,
fmodtime='now', fmodby = :who, fmodwith = :entity,
potype='NONE', pmodtime='now', pmodby = :who, pmodwith = :entity
WHERE login = :login;
}
+/**
+ ** followup_uusr - do signature, set_user_modtime
+ **
+ ** Inputs:
+ ** argv[0] - login (add_user)
+ ** argv[U_SIGNATURE] - sig
+ **
+ **/
+
+followup_uuac(q, argv, cl)
+ struct query *q;
+ char *argv[];
+ client *cl;
+{
+ EXEC SQL BEGIN DECLARE SECTION;
+ int who, status, id;
+ char *entity, *name, *src, *dst;
+ EXEC SQL END DECLARE SECTION;
+#ifdef GDSS
+ char databuf[32], *kname_unparse();
+ EXEC SQL BEGIN DECLARE SECTION;
+ char rawsig[128];
+ char *login;
+ int sigwho, timestamp;
+ EXEC SQL END DECLARE SECTION;
+ SigInfo si;
+#endif /* GDSS */
+
+ id = *(int *)argv[0];
+ who = cl->client_id;
+ entity = cl->entity;
+
+#ifdef GDSS
+ if (q->vcnt == U_MODTIME && *argv[U_SIGNATURE + 1]) {
+ /* unquote ' chars in signature */
+ for (dst = src = argv[U_SIGNATURE+1]; *src; ) {
+ if (*src == '\'')
+ src++;
+ *dst++ = *src++;
+ }
+ *dst = 0;
+ login = malloc(1);
+ status = id_to_name(id, "USER", &login);
+ sprintf(databuf, "%s:%s", login, argv[U_MITID+1]);
+ free(login);
+ /* skip bytes for timestamp & kname */
+ si.rawsig = (unsigned char *) rawsig;
+#ifdef DEBUG
+ com_err(whoami, 0, "verifying sig");
+#endif /* DEBUG */
+ status = GDSS_Verify(databuf, strlen(databuf), argv[U_SIGNATURE+1], &si);
+#ifdef DEBUG
+ com_err(whoami, 0, "verified");
+#endif /* DEBUG */
+ if (strlen(rawsig) > mr_sig_length) {
+ com_err(whoami, 0, "GDSS signature would be truncated."); /** untested **/
+ return(MR_INTERNAL);
+ }
+ if (status == 0) {
+ name = kname_unparse(si.pname, si.pinst, si.prealm);
+ status = name_to_id(name, "STRING", &sigwho);
+ if (status == MR_NO_MATCH) {
+ sigwho=add_string(name);
+ } else if (status)
+ return(status);
+ timestamp = si.timestamp;
+ } else {
+ if (log_flags & LOG_GDSS)
+ hex_dump(argv[U_SIGNATURE+1]);
+ return(gdss2et(status));
+ }
+ } else {
+ rawsig[0] = 0;
+ sigwho = 0;
+ timestamp = 0;
+ }
+#endif /* GDSS */
+
+ /* create finger entry, pobox & set modtime on user */
+
+#ifdef GDSS
+ EXEC SQL REPEATED UPDATE users SET modtime='now', modby = :who, modwith = :entity,
+ signature = :rawsig, sigdate = :timestamp, sigwho = :sigwho
+ WHERE users_id = :id;
+#else /* GDSS */
+ EXEC SQL REPEATED UPDATE users SET modtime='now', modby = :who, modwith = :entity
+ WHERE users_id = :id;
+#endif /* GDSS */
+ return(MR_SUCCESS);
+}
+
+
/* followup_gpob: fixes argv[2] based on the IDs currently there and the
* type in argv[1]. Then completes the upcall to the user.
*
(*action)(q->vcnt, argv, actarg);
skip:
/* free saved data */
- for (i = 0; i < q->vcnt; i++)
+ for (i = 0; i < q->vcnt; i++)
free(argv[i]);
free(argv);
}
(*action)(q->vcnt, argv, actarg);
/* free saved data */
- for (i = 0; i < q->vcnt; i++)
+ for (i = 0; i < q->vcnt; i++)
free(argv[i]);
free(argv);
}
{
register int j;
char **argv, *malloc();
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id;
char *name, *label;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status, idx;
if (!strcmp(q->name, "get_quota") ||
name = argv[idx];
if (id == 0) {
label = argv[0];
- EXEC SQL REPEATED SELECT name INTO :name FROM filesys
+ EXEC SQL REPEATED SELECT name INTO :name FROM filesys
WHERE label = :label;
} else {
- EXEC SQL REPEATED SELECT dir INTO :name FROM nfsphys
+ EXEC SQL REPEATED SELECT dir INTO :name FROM nfsphys
WHERE nfsphys_id = :id;
}
if (sqlca.sqlerrd[2] != 1) {
* argv[3 or 2] = ascii(quota)
*/
-followup_aqot(q, argv, cl)
- struct query *q;
+followup_aqot(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
+{
+ EXEC SQL BEGIN DECLARE SECTION;
+ int quota, id, fs, who, physid;
+ char *entity, *qtype, *table_name;
+ EXEC SQL END DECLARE SECTION;
+ char incr_qual[60];
+ char *incr_argv[2];
+ int status;
+
+ table_name=q->rtable;
+ fs = *(int *)argv[0];
+ EXEC SQL REPEATED SELECT phys_id INTO :physid FROM filesys
+ WHERE filsys_id = :fs;
+ if(ingres_errno)
+ return(mr_errcode);
+
+ if (!strcmp(q->shortname, "aqot") || !strcmp(q->shortname, "uqot")) {
+ qtype = argv[1];
+ id = *(int *)argv[2];
+ quota = atoi(argv[3]);
+ sprintf(incr_qual,"q.filsys_id = %d",fs);
+ } else {
+ qtype = "USER";
+ id = *(int *)argv[1];
+ quota = atoi(argv[2]);
+ sprintf(incr_qual,"q.filsys_id=%d AND q.type='%s' AND q.entity_id=%d",
+ fs,qtype,id);
+ }
+
+ /* quota case of incremental_{before|after} only looks at slot 1 */
+ incr_argv[1]=qtype;
+
+ /* Follows one of many possible gross hacks to fix these particular
+ * conflicts between what is possible in the query table and what
+ * is possible in SQL.
+ */
+ if(q->type==APPEND) {
+ incremental_clear_before();
+ EXEC SQL INSERT INTO quota
+ (filsys_id, type, entity_id, quota, phys_id)
+ VALUES (:fs, :qtype, :id, :quota, :physid);
+ incremental_after(table_name, incr_qual, incr_argv);
+ } else {
+ incremental_before(table_name, incr_qual, incr_argv);
+ EXEC SQL UPDATE quota SET quota = :quota
+ WHERE filsys_id = :fs AND type = :qtype AND entity_id = :id;
+ status = mr_errcode;
+ incremental_after(table_name, incr_qual, incr_argv);
+ }
+
+ if (ingres_errno)
+ return(mr_errcode);
+ flush_name(argv[0], q->rtable);
+ if(q->type==APPEND) {
+ EXEC SQL UPDATE tblstats SET appends = appends + 1, modtime = 'now'
+ WHERE table_name = :table_name;
+ } else {
+ EXEC SQL UPDATE tblstats SET updates = updates + 1, modtime = 'now'
+ WHERE table_name = :table_name;
+ }
+
+ /* Proceed with original followup */
+ who = cl->client_id;
+ entity = cl->entity;
+
+ EXEC SQL REPEATED UPDATE quota
+ SET modtime = 'now', modby = :who, modwith = :entity
+ WHERE filsys_id = :fs and type = :qtype and entity_id = :id;
+ EXEC SQL REPEATED UPDATE nfsphys SET allocated = allocated + :quota
+ WHERE nfsphys_id = :physid;
+ if (ingres_errno) return(mr_errcode);
+ return(MR_SUCCESS);
+}
+
+
+/* Necessitated by the requirement of a correlation name by the incremental
+ * routines, since query table deletes don't provide one.
+ */
+followup_dqot(q,argv,cl)
+ struct query *q;
char **argv;
- client *cl;
+ struct client *cl;
{
+ char *qtype;
+ int id, fs;
+ char *incr_argv[2];
EXEC SQL BEGIN DECLARE SECTION;
- int quota, id, fs, who;
- char *entity, *qtype;
+ char incr_qual[80];
+ char *tblname;
EXEC SQL END DECLARE SECTION;
fs = *(int *)argv[0];
- if (!strcmp(q->name, "add_quota") || !strcmp(q->name, "update_quota")) {
+ if (!strcmp(q->shortname, "dqot")) {
qtype = argv[1];
id = *(int *)argv[2];
- quota = atoi(argv[3]);
} else {
qtype = "USER";
id = *(int *)argv[1];
- quota = atoi(argv[2]);
}
- who = cl->client_id;
- entity = cl->entity;
+ sprintf(incr_qual,"q.filsys_id=%d AND q.type='%s' AND q.entity_id=%d",
+ fs,qtype,id);
- EXEC SQL REPEATED UPDATE quota
- SET modtime = 'now', modby = :who, modwith = :entity
- WHERE filsys_id = :fs and type = :qtype and entity_id = :id;
- EXEC SQL REPEATED UPDATE nfsphys
- SET allocated = allocated + :quota
- WHERE nfsphys_id = filesys.phys_id AND filesys.filsys_id = :fs;
- if (ingres_errno) return(mr_errcode);
+ /* quota case of incremental_{before|after} only looks at slot 1 */
+ incr_argv[1]=qtype;
+
+ incremental_before(q->rtable, incr_qual, incr_argv);
+ EXEC SQL DELETE FROM quota q WHERE :incr_qual;
+ incremental_clear_after();
+
+ if (ingres_errno)
+ return(mr_errcode);
+ flush_name(argv[0], q->rtable);
+
+ tblname = q->rtable;
+ EXEC SQL UPDATE tblstats SET deletes = deletes + 1, modtime = 'now'
+ WHERE table_name = :tblname;
return(MR_SUCCESS);
}
(*action)(q->vcnt, argv, actarg);
/* free saved data */
- for (i = 0; i < q->vcnt; i++)
+ for (i = 0; i < q->vcnt; i++)
free(argv[i]);
free(argv);
}
(*action)(q->vcnt, argv, actarg);
/* free saved data */
- for (i = 0; i < q->vcnt; i++)
+ for (i = 0; i < q->vcnt; i++)
free(argv[i]);
free(argv);
}
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int user, id;
char *box, potype[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status;
box = argv[2];
return(MR_BAD_CHAR);
status = name_to_id(box, "STRING", &id);
if (status == MR_NO_MATCH) {
- EXEC SQL REPEATED SELECT value INTO :id FROM numvalues
- WHERE name='strings_id';
- id++;
- EXEC SQL REPEATED UPDATE numvalues SET value = :id
- WHERE name='strings_id';
- EXEC SQL INSERT INTO strings (string_id, string)
- VALUES (:id, :box);
+ id=add_string(box);
} else if (status)
return(status);
EXEC SQL REPEATED UPDATE users SET potype='SMTP', box_id = :id
set_pobox_modtime(q, argv, cl);
EXEC SQL REPEATED UPDATE tblstats SET updates = updates+1, modtime='now'
- WHERE tblstats.table_name='users';
+ WHERE table_name='users';
if (ingres_errno) return(mr_errcode);
return(MR_SUCCESS);
}
int actarg;
{
char *argv[13], *malloc(), *realloc();
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name, acl_type[9], listname[33], active[5], public[5], hidden[5];
char maillist[5], grouplist[5], gid_str[6], acl_name[256], desc[256];
char modtime[27], modby[256], modwith[9];
int id, rowcount, acl_id, hid, modby_id;
- EXEC SQL END DECLARE SECTION;
+ char qual[80];
+ EXEC SQL END DECLARE SECTION;
int returned, status;
struct save_queue *sq, *sq_create();
convert_wildcards(name);
sq = sq_create();
- EXEC SQL DECLARE csr102 CURSOR FOR SELECT list_id FROM list
- WHERE name LIKE :name ESCAPE '*';
+ sprintf(qual,"name LIKE '%s' ESCAPE '*'",name);
+ optimize_sql_stmt(qual);
+ EXEC SQL DECLARE csr102 CURSOR FOR SELECT list_id FROM list
+ WHERE :qual;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr102;
+ if (ingres_errno)
+ return(mr_errcode);
while(1)
{
EXEC SQL FETCH csr102 INTO :id;
return(MR_NO_MATCH);
argv[0] = listname; argv[1] = active; argv[2] = public; argv[3] = hidden;
- argv[4] = maillist; argv[5] = grouplist; argv[6] = gid_str;
+ argv[4] = maillist; argv[5] = grouplist; argv[6] = gid_str;
argv[7] = acl_type; argv[9] = desc; argv[10] = modtime; argv[12] = modwith;
while (sq_get_data(sq, &id)) {
argv[6] = gid_str;
EXEC SQL REPEATED SELECT name, CHAR(active), CHAR(publicflg),
CHAR(hidden), hidden, CHAR(maillist), CHAR(grouplist), CHAR(gid),
- TRIM(acl_type), acl_id, description, CHAR(modtime), modby, modwith
+ TRIM(acl_type), acl_id, description, CHAR(modtime), modby, modwith
INTO :listname, :active, :public, :hidden, :hid, :maillist,
- :grouplist, :gid_str, :acl_type, :acl_id, :desc,
+ :grouplist, :gid_str, :acl_type, :acl_id, :desc,
:modtime, :modby_id, :modwith
FROM list WHERE list_id = :id;
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int id, lid, mid, error, who, ref;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int id, lid, mid, error, who, ref, rowcnt;
char *mtype, dtype[9], *entity;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int ancestors[MAXLISTDEPTH], aref[MAXLISTDEPTH], acount, a;
int descendants[MAXLISTDEPTH], dref[MAXLISTDEPTH], dcount, d;
int status;
mtype = argv[1];
mid = *(int *)argv[2];
/* if the member is already a direct member of the list, punt */
- EXEC SQL REPEATED SELECT list_id INTO :idummy FROM imembers
- WHERE list_id = :lid AND member_id = :mid
+ EXEC SQL REPEATED SELECT COUNT(list_id) INTO :rowcnt FROM imembers
+ WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype AND direct = 1;
- if (sqlca.sqlerrd[2] > 0)
+ if (rowcnt > 0)
return(MR_EXISTS);
if (!strcasecmp(mtype, "STRING")) {
buf = malloc(0);
EXEC SQL DECLARE csr103 CURSOR FOR
SELECT list_id, ref_count FROM imembers
WHERE member_id = :lid AND member_type='LIST';
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr103;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr103 INTO :id, :ref;
if(sqlca.sqlcode != 0) break;
aref[acount] = ref;
ancestors[acount++] = id;
- if (acount >= MAXLISTDEPTH) break;
+ if (acount >= MAXLISTDEPTH) break;
}
EXEC SQL CLOSE csr103;
if (ingres_errno) return(mr_errcode);
dcount = 1;
error = 0;
if (!strcmp(mtype, "LIST")) {
- EXEC SQL DECLARE csr104 CURSOR FOR
+ EXEC SQL DECLARE csr104 CURSOR FOR
SELECT member_id, member_type, ref_count
FROM imembers
WHERE list_id = :mid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr104;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr104 INTO :id, :dtype, :ref;
if(sqlca.sqlcode != 0) break;
if (mid == lid && !strcmp(mtype, "LIST")) {
return(MR_LISTLOOP);
}
- EXEC SQL REPEATED SELECT ref_count INTO :idummy FROM imembers
- WHERE list_id = :lid AND member_id = :mid
+ EXEC SQL REPEATED SELECT COUNT(ref_count) INTO :rowcnt
+ FROM imembers
+ WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype;
ref = aref[a] * dref[d];
- if (sqlca.sqlerrd[2] > 0) {
+ if (rowcnt > 0) {
if (a == 0 && d == 0) {
- EXEC SQL UPDATE imembers
- SET ref_count = ref_count+ref, direct=1
+ EXEC SQL UPDATE imembers
+ SET ref_count = ref_count+:ref, direct=1
WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype;
} else {
EXEC SQL UPDATE imembers
- SET ref_count = ref_count+ref
+ SET ref_count = ref_count+:ref
WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype;
}
} else {
incremental_clear_before();
if (a == 0 && d == 0) {
- EXEC SQL INSERT INTO imembers
+ EXEC SQL INSERT INTO imembers
(list_id, member_id, direct, member_type, ref_count)
VALUES (:lid, :mid, 1, :mtype, 1);
} else {
lid = *(int *)argv[0];
entity = cl->entity;
who = cl->client_id;
- EXEC SQL REPEATED UPDATE list
+ EXEC SQL REPEATED UPDATE list
SET modtime='now', modby = :who, modwith = :entity
WHERE list_id = :lid;
if (ingres_errno) return(mr_errcode);
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id, lid, mid, cnt, error, who, ref;
char *mtype, dtype[9], *entity;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int ancestors[MAXLISTDEPTH], aref[MAXLISTDEPTH], acount, a;
int descendants[MAXLISTDEPTH], dref[MAXLISTDEPTH], dcount, d;
char *dtypes[MAXLISTDEPTH];
mtype = argv[1];
mid = *(int *)argv[2];
/* if the member is not a direct member of the list, punt */
- EXEC SQL REPEATED SELECT list_id INTO :idummy FROM imembers
- WHERE list_id = :lid AND member_id = :mid
+ EXEC SQL REPEATED SELECT COUNT(list_id) INTO :cnt FROM imembers
+ WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype AND direct = 1;
if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlcode == 100)
+ if (cnt == 0)
return(MR_NO_MATCH);
ancestors[0] = lid;
aref[0] = 1;
acount = 1;
- EXEC SQL DECLARE csr105 CURSOR FOR
+ EXEC SQL DECLARE csr105 CURSOR FOR
SELECT list_id, ref_count FROM imembers
WHERE member_id = :lid AND member_type = 'LIST';
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr105;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr105 INTO :id, :ref;
if(sqlca.sqlcode!=0) break;
if (acount >= MAXLISTDEPTH) break;
}
EXEC SQL CLOSE csr105;
- if (ingres_errno)
+ if (ingres_errno)
return(mr_errcode);
if (acount >= MAXLISTDEPTH)
return(MR_INTERNAL);
dcount = 1;
error = 0;
if (!strcmp(mtype, "LIST")) {
- EXEC SQL DECLARE csr106 CURSOR FOR
+ EXEC SQL DECLARE csr106 CURSOR FOR
SELECT member_id, member_type, ref_count FROM imembers
WHERE list_id = :mid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr106;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr106 INTO :id, :dtype, :ref;
if(sqlca.sqlcode!=0) break;
if (dcount >= MAXLISTDEPTH) break;
}
EXEC SQL CLOSE csr106;
- if (ingres_errno)
+ if (ingres_errno)
return(mr_errcode);
if (error)
return(MR_INTERNAL);
iargv[1] = mtype;
iargv[2] = (char *)mid;
incremental_before("members", 0, iargv);
- EXEC SQL DELETE FROM imembers
- WHERE list_id = :lid AND member_id = :mid
+ EXEC SQL DELETE FROM imembers
+ WHERE list_id = :lid AND member_id = :mid
AND member_type= :mtype;
incremental_clear_after();
} else if (a == 0 && d == 0) {
- EXEC SQL UPDATE imembers
- SET ref_count = refcount - :ref, direct = 0
- WHERE list_id = :lid AND member_id = :mid
+ EXEC SQL UPDATE imembers
+ SET ref_count = ref_count - :ref, direct = 0
+ WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype;
} else {
- EXEC SQL UPDATE imembers
- SET ref_count=refcount-:ref
- WHERE list_id = :lid AND member_id = :mid
+ EXEC SQL UPDATE imembers
+ SET ref_count = ref_count - :ref
+ WHERE list_id = :lid AND member_id = :mid
AND member_type = :mtype;
}
}
int actarg;
{
int found = 0;
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *atype;
int aid, listid, id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
struct save_queue *sq, *sq_create();
atype = argv[0];
if (!strcmp(atype, "RLIST")) {
sq_save_data(sq, aid);
/* get all the list_id's of containing lists */
- EXEC SQL DECLARE csr107 CURSOR FOR
+ EXEC SQL DECLARE csr107 CURSOR FOR
SELECT list_id FROM imembers
WHERE member_type='LIST' AND member_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr107;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr107 INTO :listid;
if(sqlca.sqlcode != 0) break;
}
if (!strcmp(atype, "RUSER")) {
- EXEC SQL DECLARE csr108 CURSOR FOR
+ EXEC SQL DECLARE csr108 CURSOR FOR
SELECT list_id FROM imembers
WHERE member_type='USER' AND member_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr108;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr108 INTO :listid;
if(sqlca.sqlcode != 0) break;
}
if (!strcmp(atype, "RKERBERO")) {
- EXEC SQL DECLARE csr109 CURSOR FOR
+ EXEC SQL DECLARE csr109 CURSOR FOR
SELECT list_id FROM imembers
WHERE member_type='KERBEROS' AND member_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr109;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr109 INTO :listid;
if(sqlca.sqlcode != 0) break;
found++;
}
- sq_destroy(sq);
+ sq_destroy(sq);
if (ingres_errno) return(mr_errcode);
if (!found) return(MR_NO_MATCH);
return(MR_SUCCESS);
*/
get_ace_internal(atype, aid, action, actarg)
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *atype;
int aid;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int (*action)();
int actarg;
{
char *rargv[2];
int found = 0;
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char name[33];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
rargv[1] = name;
if (!strcmp(atype, "LIST")) {
rargv[0] = "FILESYS";
- EXEC SQL DECLARE csr110 CURSOR FOR
+ EXEC SQL DECLARE csr110 CURSOR FOR
SELECT label FROM filesys
WHERE owners = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr110;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr110 INTO :name;
if(sqlca.sqlcode != 0) break;
EXEC SQL CLOSE csr110;
rargv[0] = "QUERY";
- EXEC SQL DECLARE csr111 CURSOR FOR
+ EXEC SQL DECLARE csr111 CURSOR FOR
SELECT capability FROM capacls
WHERE list_id = :aid ;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr111;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr111 INTO :name ;
+ EXEC SQL FETCH csr111 INTO :name ;
if(sqlca.sqlcode != 0) break;
(*action)(2, rargv, actarg);
found++;
EXEC SQL CLOSE csr111;
} else if (!strcmp(atype, "USER")) {
rargv[0] = "FILESYS";
- EXEC SQL DECLARE csr112 CURSOR FOR
+ EXEC SQL DECLARE csr112 CURSOR FOR
SELECT label FROM filesys
WHERE owner = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr112;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr112 INTO :name ;
if(sqlca.sqlcode != 0) break;
(*action)(2, rargv, actarg);
found++;
}
- EXEC SQL CLOSE csr112;
+ EXEC SQL CLOSE csr112;
}
-
+
rargv[0] = "LIST";
- EXEC SQL DECLARE csr113 CURSOR FOR
+ EXEC SQL DECLARE csr113 CURSOR FOR
SELECT name FROM list
WHERE acl_type = :atype AND acl_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr113;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr113 INTO :name;
+ EXEC SQL FETCH csr113 INTO :name;
if(sqlca.sqlcode != 0) break;
(*action)(2, rargv, actarg);
found++;
}
EXEC SQL CLOSE csr113;
-
+
rargv[0] = "SERVICE";
- EXEC SQL DECLARE csr114 CURSOR FOR
+ EXEC SQL DECLARE csr114 CURSOR FOR
SELECT name FROM servers
WHERE acl_type = :atype AND acl_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr114;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr114 INTO :name;
if(sqlca.sqlcode != 0) break;
(*action)(2, rargv, actarg);
found++;
}
- EXEC SQL CLOSE csr114;
+ EXEC SQL CLOSE csr114;
rargv[0] = "HOSTACCESS";
- EXEC SQL DECLARE csr115 CURSOR FOR
- SELECT name FROM machine, hostaccess
- WHERE mach_id = hostaccess.mach_id AND hostaccess.acl_type = :atype
- AND hostaccess.acl_id = :aid;
+ EXEC SQL DECLARE csr115 CURSOR FOR
+ SELECT name FROM machine m, hostaccess ha
+ WHERE m.mach_id = ha.mach_id AND ha.acl_type = :atype
+ AND ha.acl_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr115;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr115 INTO :name;
if(sqlca.sqlcode != 0) break;
EXEC SQL CLOSE csr115;
rargv[0] = "ZEPHYR";
- EXEC SQL DECLARE csr116 CURSOR FOR
- SELECT class FROM zephyr
- WHERE zephyr.xmt_type = :atype AND zephyr.xmt_id = :aid
- OR zephyr.sub_type = :atype AND zephyr.sub_id = :aid
- OR zephyr.iws_type = :atype AND zephyr.iws_id = :aid
- OR zephyr.iui_type = :atype AND zephyr.iui_id = :aid;
+ EXEC SQL DECLARE csr116 CURSOR FOR
+ SELECT class FROM zephyr z
+ WHERE z.xmt_type = :atype AND z.xmt_id = :aid
+ OR z.sub_type = :atype AND z.sub_id = :aid
+ OR z.iws_type = :atype AND z.iws_id = :aid
+ OR z.iui_type = :atype AND z.iui_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr116;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr116 INTO :name;
+ EXEC SQL FETCH csr116 INTO :name;
if(sqlca.sqlcode != 0) break;
(*action)(2, rargv, actarg);
found++;
{
int found = 0, direct = 1;
char *rargv[6];
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *atype;
int aid, listid, id;
char name[33], active[5], public[5], hidden[5], maillist[5], grouplist[5];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
atype = argv[0];
aid = *(int *)argv[1];
rargv[4] = maillist;
rargv[5] = grouplist;
if (direct) {
- EXEC SQL DECLARE csr117a CURSOR FOR
- SELECT name, CHAR(active), CHAR(publicflg), CHAR(hidden),
- CHAR(maillist), CHAR(grouplist)
- FROM list l, imembers m
- WHERE l.list_id = m.list_id AND m.direct = 1
- AND m.member_type = :atype AND m.member_id = :aid;
+ EXEC SQL DECLARE csr117a CURSOR FOR
+ SELECT l.name, CHAR(l.active), CHAR(l.publicflg), CHAR(l.hidden),
+ CHAR(l.maillist), CHAR(l.grouplist)
+ FROM list l, imembers im
+ WHERE l.list_id = im.list_id AND im.direct = 1
+ AND im.member_type = :atype AND im.member_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr117a;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr117a
+ EXEC SQL FETCH csr117a
INTO :name, :active, :public, :hidden, :maillist, :grouplist;
- if(sqlca.sqlcode != 0) break;
+ if(sqlca.sqlcode != 0) break;
(*action)(6, rargv, actarg);
found++;
}
EXEC SQL CLOSE csr117a;
} else {
- EXEC SQL DECLARE csr117b CURSOR FOR
- SELECT name, CHAR(active), CHAR(publicflg), CHAR(hidden),
- CHAR(maillist), CHAR(grouplist)
- FROM list l, imembers m
- WHERE l.list_id = m.list_id
- AND m.member_type = :atype AND m.member_id = :aid;
+ EXEC SQL DECLARE csr117b CURSOR FOR
+ SELECT l.name, CHAR(l.active), CHAR(l.publicflg), CHAR(l.hidden),
+ CHAR(l.maillist), CHAR(l.grouplist)
+ FROM list l, imembers im
+ WHERE l.list_id = im.list_id
+ AND im.member_type = :atype AND im.member_id = :aid;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr117b;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr117b
+ EXEC SQL FETCH csr117b
INTO :name, :active, :public, :hidden, :maillist, :grouplist;
- if(sqlca.sqlcode != 0) break;
+ if(sqlca.sqlcode != 0) break;
(*action)(6, rargv, actarg);
found++;
}
* where clause based on the arguments, then doing a retrieve.
*/
-static char *lflags[5] = { "active", "publicflg", "hidden", "maillist", "group" };
+static char *lflags[5] = { "active", "publicflg", "hidden", "maillist", "grouplist" };
int qualified_get_lists(q, argv, cl, action, actarg)
struct query *q;
}
-/** get_members_of_list - optimized query for retrieval of list members
+/* get_members_of_list - this gets only direct members */
+
+get_members_of_list(q, argv, cl, action, actarg)
+ struct query *q;
+ char *argv[];
+ client *cl;
+ int (*action)();
+ int actarg;
+{
+ return(gmol_internal(q, argv, cl, action, actarg, 1));
+}
+
+/* get_end_members_of_list - this gets direct or indirect members */
+
+get_end_members_of_list(q, argv, cl, action, actarg)
+ struct query *q;
+ char *argv[];
+ client *cl;
+ int (*action)();
+ int actarg;
+{
+ return(gmol_internal(q, argv, cl, action, actarg, 0));
+}
+
+/** gmol_internal - optimized query for retrieval of list members
+ ** used by both get_members_of_list and get_end_members_of_list
**
** Inputs:
** argv[0] - list_id
** - retrieve USER members, then LIST members, then STRING members
**/
-get_members_of_list(q, argv, cl, action, actarg)
+gmol_internal(q, argv, cl, action, actarg, flag)
struct query *q;
char *argv[];
client *cl;
int (*action)();
int actarg;
+ int flag;
{
- EXEC SQL BEGIN DECLARE SECTION;
- int list_id, member_id;
+ EXEC SQL BEGIN DECLARE SECTION;
+ int list_id, member_id, direct;
char member_name[129], member_type[9];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *targv[2];
int members;
struct save_queue *sq;
+ /* true/false flag indicates whether to display only direct members. */
+ if (flag)
+ direct = 0;
+ else
+ direct = -1;
+
list_id = *(int *)argv[0];
members = 0;
sq = sq_create();
- EXEC SQL DECLARE csr118 CURSOR FOR
+ EXEC SQL DECLARE csr118 CURSOR FOR
SELECT member_type, member_id FROM imembers
- WHERE list_id = :list_id AND direct=1;
+ WHERE list_id = :list_id AND direct > :direct;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr118;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr118 INTO :member_type, :member_id;
+ EXEC SQL FETCH csr118 INTO :member_type, :member_id;
if (sqlca.sqlcode != 0) break;
- if (members++ > 49)
+ if (members++ > 49)
break;
sq_save_data(sq, ((int)member_type[0] << 24) | (member_id & 0xffffff));
}
targv[1] = member_name;
targv[0] = "USER";
- EXEC SQL DECLARE csr119 CURSOR FOR
- SELECT users.login FROM users, imembers
- WHERE imembers.list_id = :list_id AND imembers.member_type = 'USER'
- AND imembers.member_id = users.users_id AND imembers.direct=1
+ EXEC SQL DECLARE csr119 CURSOR FOR
+ SELECT u.login FROM users u, imembers im
+ WHERE im.list_id = :list_id AND im.member_type = 'USER'
+ AND im.member_id = u.users_id AND im.direct > :direct
ORDER BY 1;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr119;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr119 INTO :member_name;
if(sqlca.sqlcode != 0) break;
if (ingres_errno) return(mr_errcode);
targv[0] = "LIST";
- EXEC SQL DECLARE csr120 CURSOR FOR
- SELECT list.name FROM list, imembers
- WHERE imembers.list_id = :list_id AND imembers.member_type='LIST'
- AND imembers.member_id = list.list_id AND imembers.direct=1
+ EXEC SQL DECLARE csr120 CURSOR FOR
+ SELECT l.name FROM list l, imembers im
+ WHERE im.list_id = :list_id AND im.member_type='LIST'
+ AND im.member_id = l.list_id AND im.direct > :direct
ORDER BY 1;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr120;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr120 INTO :member_name;
+ EXEC SQL FETCH csr120 INTO :member_name;
if(sqlca.sqlcode != 0) break;
(*action)(2, targv, actarg);
}
if (ingres_errno) return(mr_errcode);
targv[0] = "STRING";
- EXEC SQL DECLARE csr121 CURSOR FOR
- SELECT strings.string FROM strings, imembers
- WHERE imembers.list_id = :list_id AND imembers.member_type='STRING'
- AND imembers.member_id = strings.string_id AND imembers.direct=1
+ EXEC SQL DECLARE csr121 CURSOR FOR
+ SELECT CHAR(str.string) FROM strings str, imembers im
+ WHERE im.list_id = :list_id AND im.member_type='STRING'
+ AND im.member_id = str.string_id AND im.direct > :direct
ORDER BY 1;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr121;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr121 INTO :member_name;
+ EXEC SQL FETCH csr121 INTO :member_name;
if(sqlca.sqlcode != 0) break;
(*action)(2, targv, actarg);
}
if (ingres_errno) return(mr_errcode);
targv[0] = "KERBEROS";
- EXEC SQL DECLARE csr122 CURSOR FOR
- SELECT strings.string FROM strings, imembers
- WHERE imembers.list_id = :list_id AND imembers.member_type='KERBEROS'
- AND imembers.member_id = strings.string_id AND imembers.direct=1
+ EXEC SQL DECLARE csr122 CURSOR FOR
+ SELECT CHAR(str.string) FROM strings str, imembers im
+ WHERE im.list_id = :list_id AND im.member_type='KERBEROS'
+ AND im.member_id = str.string_id
+ AND im.direct > :direct
ORDER BY 1;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr122;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
- EXEC SQL FETCH csr122 INTO :member_name;
+ EXEC SQL FETCH csr122 INTO :member_name;
if(sqlca.sqlcode != 0) break;
(*action)(2, targv, actarg);
}
int (*action)();
int actarg;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int list, ct = 0;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *rargv[1], countbuf[5];
list = *(int *)argv[0];
strcpy(qual, start);
for (i = 0; i < q->argc; i++) {
if (!strcmp(argv[i], "TRUE")) {
- sprintf(buf, " and %s.%s != 0", range, flags[i]);
+ sprintf(buf, " AND %s.%s != 0", range, flags[i]);
(void) strcat(qual, buf);
} else if (!strcmp(argv[i], "FALSE")) {
- sprintf(buf, " and %s.%s = 0", range, flags[i]);
+ sprintf(buf, " AND %s.%s = 0", range, flags[i]);
(void) strcat(qual, buf);
}
}
-
+
rargv[0] = SQLDA->sqlvar[0].sqldata;
- sprintf(stmt_buf,"SELECT %s.%s FROM %s %s WHERE %s",q->rtable,field,q->rtable,q->rvar,qual);
- EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
+ sprintf(stmt_buf,"SELECT CHAR(%s.%s) FROM %s %s WHERE %s",range,field,q->rtable,range,qual);
+ EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
if(sqlca.sqlcode)
return(MR_INTERNAL);
EXEC SQL DECLARE csr123 CURSOR FOR stmt;
/* qualified_get_serverhost: passed "TRUE", "FALSE", or "DONTCARE" for each of
* the five flags associated with each serverhost. It will return the name of
- * each service and host that meets the quailifications. It does this by
+ * each service and host that meets the quailifications. It does this by
* building a where clause based on the arguments, then doing a retrieve.
*/
int (*action)();
int actarg;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char sname[33], mname[33], qual[256];
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
char *rargv[2], buf[32];
int i, rowcount;
- /** the uppercase() function is INGRES-specific */
- sprintf(qual, "machine.mach_id = serverhosts.mach_id AND \
-serverhosts.service = uppercase('%s')",
+ sprintf(qual, "m.mach_id = sh.mach_id AND sh.service = uppercase('%s')",
argv[0]);
for (i = 1; i < q->argc; i++) {
if (!strcmp(argv[i], "TRUE")) {
- sprintf(buf, " AND serverhosts.%s != 0", shflags[i]);
+ sprintf(buf, " AND sh.%s != 0", shflags[i]);
strcat(qual, buf);
} else if (!strcmp(argv[i], "FALSE")) {
- sprintf(buf, " AND serverhosts.%s = 0", shflags[i]);
+ sprintf(buf, " AND sh.%s = 0", shflags[i]);
strcat(qual, buf);
}
}
-
+
rargv[0] = sname;
rargv[1] = mname;
- EXEC SQL DECLARE csr124 CURSOR FOR
- SELECT serverhosts.service, machine.name FROM serverhosts, machine
- WHERE :qual;
+ EXEC SQL DECLARE csr124 CURSOR FOR
+ SELECT sh.service, m.name FROM serverhosts sh, machine m
+ WHERE :qual;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr124;
+ if (ingres_errno)
+ return(mr_errcode);
while(1) {
EXEC SQL FETCH csr124 INTO :sname, :mname;
if(sqlca.sqlcode != 0) break;
/* register_user - change user's login name and allocate a pobox, group,
* filesystem, and quota for them. The user's status must start out as 0,
* and is left as 2. Arguments are: user's UID, new login name, and user's
- * type for filesystem allocation (MR_FS_STUDENT, MR_FS_FACULTY,
+ * type for filesystem allocation (MR_FS_STUDENT, MR_FS_FACULTY,
* MR_FS_STAFF, MR_FS_MISC).
*/
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
- char *login, dir[65], *entity, *directory, machname[33];
+ EXEC SQL BEGIN DECLARE SECTION;
+ char *login, dir[65], *entity, directory[129], machname[33];
int who, rowcount, mid, uid, users_id, flag, utype, nid, list_id, quota;
- int size, alloc, pid, m_id, ostatus, nstatus, gidval, fsidval, npidval;
- EXEC SQL END DECLARE SECTION;
+ int size, alloc, pid, ostatus, nstatus, gidval, fsidval, npidval;
+ static int m_id = 0, def_quota = 0;
+ EXEC SQL END DECLARE SECTION;
char buffer[256], *aargv[3];
- int maxsize;
entity = cl->entity;
who = cl->client_id;
return(MR_NOT_UNIQUE);
/* check new login name */
- EXEC SQL REPEATED SELECT login INTO :cdummy FROM users
- WHERE login = LEFT(:login,SIZE(login)) AND users_id != :users_id;
+ EXEC SQL REPEATED SELECT COUNT(login) INTO :rowcount FROM users
+ WHERE login = :login AND users_id != :users_id;
if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] > 0) return(MR_IN_USE);
- EXEC SQL REPEATED SELECT name INTO :cdummy FROM list
- WHERE name = LEFT(:login,SIZE(name));
+ if (rowcount > 0) return(MR_IN_USE);
+ EXEC SQL REPEATED SELECT COUNT(name) INTO :rowcount FROM list
+ WHERE name = :login;
if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] > 0) return(MR_IN_USE);
- EXEC SQL REPEATED SELECT label INTO :cdummy FROM filesys
- WHERE label = LEFT(:login,SIZE(label));
+ if (rowcount > 0) return(MR_IN_USE);
+ EXEC SQL REPEATED SELECT COUNT(label) INTO :rowcount FROM filesys
+ WHERE label = :login;
if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] > 0) return(MR_IN_USE);
+ if (rowcount > 0) return(MR_IN_USE);
com_err(whoami, 0, "login name OK");
/* choose place for pobox, put in mid */
- EXEC SQL DECLARE csr130 CURSOR FOR
+ EXEC SQL DECLARE csr130 CURSOR FOR
SELECT sh.mach_id, m.name FROM serverhosts sh, machine m
WHERE sh.service='POP' AND sh.mach_id=m.mach_id
AND sh.value2 - sh.value1 =
(SELECT MAX(value2 - value1) FROM serverhosts
WHERE service = 'POP');
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL OPEN csr130;
+ if (ingres_errno)
+ return(mr_errcode);
EXEC SQL FETCH csr130 INTO :mid, :machname;
if (sqlca.sqlerrd[2] == 0) {
EXEC SQL CLOSE csr130;
}
/* change login name, set pobox */
- sprintf(buffer, "users.users_id = %d", users_id);
+ sprintf(buffer, "u.users_id = %d", users_id);
incremental_before("users", buffer, 0);
nstatus = 2;
if (ostatus == 5 || ostatus == 6)
return(MR_NO_ID);
if (set_next_object_id("list_id", "list", 0))
return(MR_NO_ID);
- EXEC SQL REPEATED SELECT value INTO :list_id FROM numvalues
+ EXEC SQL REPEATED SELECT value INTO :list_id FROM numvalues
WHERE name='list_id';
if (ingres_errno) return(mr_errcode);
if (sqlca.sqlerrd[2] != 1)
EXEC SQL SELECT value INTO :gidval FROM numvalues WHERE name = 'gid';
EXEC SQL REPEATED INSERT INTO list
(name, list_id, active, publicflg, hidden, maillist, grouplist,
- gid, description, acl_type, acl_id,
+ gid, description, acl_type, acl_id,
modtime, modby, modwith)
VALUES (:login, :list_id, 1, 0, 0, 0, 1,
:gidval, 'User Group', 'USER', :users_id,
if (ingres_errno) return(mr_errcode);
if (sqlca.sqlerrd[2] != 1)
return(MR_INTERNAL);
- sprintf(buffer, "list_id = %d", list_id);
+ sprintf(buffer, "l.list_id = %d", list_id);
incremental_after("list", buffer, 0);
aargv[0] = (char *) list_id;
aargv[1] = "USER";
aargv[2] = (char *) users_id;
incremental_clear_before();
- EXEC SQL REPEATED INSERT INTO imembers
+ EXEC SQL REPEATED INSERT INTO imembers
(list_id, member_type, member_id, ref_count, direct)
VALUES (:list_id, 'USER', :users_id, 1, 1);
if (ingres_errno) return(mr_errcode);
return(MR_INTERNAL);
incremental_after("members", 0, aargv);
- /* decide where to put filesystem */
- maxsize = 0;
- directory = NULL;
- EXEC SQL DECLARE csr125 CURSOR FOR
- SELECT mach_id, trim(dir), nfsphys_id, status, partsize, allocated
- FROM nfsphys;
- EXEC SQL OPEN csr125;
- while(1) {
- EXEC SQL FETCH csr125 INTO :mid, :dir, :nid, :flag, :size, :alloc;
- if(sqlca.sqlcode)
- break;
- if ((flag & utype) && (size != 0) && (size - alloc > maxsize)) {
- maxsize = size - alloc;
- if (directory)
- free(directory);
- directory = strsave(dir);
- pid = nid;
- m_id = mid;
- }
+ if (m_id == 0) {
+ /* Cell Name (I know, it shouldn't be hard coded...) */
+ strcpy(machname, "ATHENA.MIT.EDU");
+ EXEC SQL SELECT mach_id INTO :m_id FROM machine
+ WHERE name = :machname;
}
- EXEC SQL CLOSE csr125;
- if (ingres_errno) return(mr_errcode);
- if (maxsize == 0)
- return(MR_NO_FILESYS);
/* create filesystem */
if (set_next_object_id("filsys_id", "filesys", 0))
return(MR_NO_ID);
- incremental_clear_before();
+ incremental_clear_before();
+ if (islower(login[0]) && islower(login[1])) {
+ sprintf(directory, "/afs/athena.mit.edu/user/%c/%c/%s",
+ login[0], login[1], login);
+ } else {
+ sprintf(directory, "/afs/athena.mit.edu/user/other/%s", login);
+ }
+
EXEC SQL SELECT value INTO :fsidval FROM numvalues
WHERE numvalues.name='filsys_id';
EXEC SQL REPEATED INSERT INTO filesys
- (filsys_id, phys_id, label, type, mach_id, name,
- mount, access, comments, owner, owners, createflg,
+ (filsys_id, phys_id, label, type, mach_id, name,
+ mount, access, comments, owner, owners, createflg,
lockertype, modtime, modby, modwith)
VALUES
- (:fsidval, :pid, :login, 'NFS', :m_id, :directory+'/'+:login,
+ (:fsidval, 0, :login, 'AFS', :m_id, :directory,
'/mit/'+:login, 'w', 'User Locker', :users_id, :list_id, 1,
- 'HOMEDIR', 'now', :who, :entity) ;
+ 'HOMEDIR', 'now', :who, :entity);
+
if (ingres_errno) return(mr_errcode);
if (sqlca.sqlerrd[2] != 1)
return(MR_INTERNAL);
sprintf(buffer,"fs.filsys_id = %d",fsidval);
incremental_after("filesys", buffer, 0);
- com_err(whoami, 0, "filesys on mach %d in %s/%s", m_id,
- directory, login);
/* set quota */
- EXEC SQL REPEATED SELECT value INTO :quota FROM numvalues
- WHERE name='def_quota';
- if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] != 1)
- return(MR_NO_QUOTA);
+ if (def_quota == 0) {
+ EXEC SQL REPEATED SELECT value INTO :def_quota FROM numvalues
+ WHERE name='def_quota';
+ if (ingres_errno) return(mr_errcode);
+ if (sqlca.sqlerrd[2] != 1)
+ return(MR_NO_QUOTA);
+
+ }
incremental_clear_before();
- EXEC SQL REPEATED INSERT INTO quota
+ EXEC SQL REPEATED INSERT INTO quota
(entity_id, filsys_id, type, quota, phys_id, modtime, modby, modwith)
VALUES
- (:users_id, :fsidval, 'USER', :quota, :pid, 'now', :who, :entity);
- if (ingres_errno) return(mr_errcode);
- if (sqlca.sqlerrd[2] != 1)
- return(MR_INTERNAL);
- EXEC SQL SELECT phys_id INTO :npidval FROM filesys
- WHERE filsys_id=:fsidval;
- EXEC SQL REPEATED UPDATE nfsphys SET allocated=allocated + :quota
- WHERE nfsphys.nfsphys_id = :npidval;
+ (0, :fsidval, 'ANY', :def_quota, 0, 'now', :who, :entity);
if (ingres_errno) return(mr_errcode);
if (sqlca.sqlerrd[2] != 1)
return(MR_INTERNAL);
aargv[0] = login;
- aargv[1] = "USER";
+ aargv[1] = "ANY";
aargv[2] = login;
- sprintf(buffer, "q.entity_id = %d and q.filsys_id = %d and q.type = 'USER'", users_id, fsidval);
+ sprintf(buffer, "q.entity_id = 0 and q.filsys_id = %d and q.type = 'ANY'", fsidval);
incremental_after("quota", buffer, aargv);
- com_err(whoami, 0, "quota of %d assigned", quota);
+ com_err(whoami, 0, "quota of %d assigned", def_quota);
if (ingres_errno) return(mr_errcode);
cache_entry(login, "USER", users_id);
**/
static int set_pop_usage(id, cnt)
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int id;
int cnt;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
{
EXEC SQL REPEATED UPDATE serverhosts SET value1 = value1 + :cnt
WHERE serverhosts.service = 'POP' AND serverhosts.mach_id = :id;
-
+
if (ingres_errno) return(mr_errcode);
return(MR_SUCCESS);
}
+int _sdl_followup(q, argv, cl)
+ struct query *q;
+ char **argv;
+ client *cl;
+{
+ int i;
+ i = atoi(argv[0]);
+ log_flags = i;
+ if (i & LOG_SQL) {
+ EXEC SQL set printqry;
+ } else {
+ EXEC SQL set noprintqry;
+ }
+ return(MR_SUCCESS);
+}
+
\f
/* Validation Routines */
char *argv[];
register struct validate *v;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name;
char qual[128];
int rowcount;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
/* build where clause */
build_qual(v->qual, v->argc, argv, qual);
if (log_flags & LOG_VALID)
/* tell the logfile what we're doing */
com_err(whoami, 0, "validating row: %s", qual);
-
+
/* look for the record */
sprintf(stmt_buf,"SELECT COUNT (*) FROM %s WHERE %s",q->rtable,qual);
- EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
+ EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
if(sqlca.sqlcode)
return(MR_INTERNAL);
EXEC SQL DECLARE csr126 CURSOR FOR stmt;
switch (vo->type) {
case V_NAME:
if (log_flags & LOG_VALID)
- com_err(whoami, 0, "validating %s in %s: %s",
+ com_err(whoami, 0, "validating %s in %s: %s",
vo->namefield, vo->table, argv[vo->index]);
status = validate_name(argv, vo);
break;
case V_ID:
if (log_flags & LOG_VALID)
- com_err(whoami, 0, "validating %s in %s: %s",
+ com_err(whoami, 0, "validating %s in %s: %s",
vo->idfield, vo->table, argv[vo->index]);
status = validate_id(q, argv, vo);
break;
/* validate_chars: verify that there are no illegal characters in
- * the string. Legal characters are printing chars other than
+ * the string. Legal characters are printing chars other than
* ", *, ?, \, [ and ].
*/
static int illegalchars[] = {
char *argv[];
register struct valobj *vo;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name, *tbl, *namefield, *idfield;
int id, rowcount;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status;
register char *c;
return(MR_EXISTS);
} else if (status == MR_NO_MATCH && !strcmp(tbl, "strings") &&
(q->type == APPEND || q->type == UPDATE)) {
- EXEC SQL SELECT value INTO :id FROM numvalues
- WHERE name = 'strings_id';
- id++;
- EXEC SQL UPDATE numvalues SET value = :id WHERE name = 'string_id';
- EXEC SQL INSERT INTO strings (string_id, string) VALUES (:id, :name);
+ id=add_string(name);
cache_entry(name, "STRING", id);
*(int *)argv[vo->index] = id;
return(MR_EXISTS);
} else {
sprintf(stmt_buf,"SELECT %s FROM %s WHERE %s = '%s'",idfield,tbl,namefield,name);
}
- EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
+ EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
if(sqlca.sqlcode)
return(MR_INTERNAL);
EXEC SQL DECLARE csr127 CURSOR FOR stmt;
if(sqlca.sqlcode == 0) rowcount++;
}
EXEC SQL CLOSE csr127;
- if (ingres_errno)
+ if (ingres_errno)
return(mr_errcode);
- if (rowcount != 1) return(vo->error);
+ if (rowcount != 1) return(vo->error);
bcopy(SQLDA->sqlvar[0].sqldata,argv[vo->index],sizeof(int));
return(MR_EXISTS);
}
char *argv[];
register struct valobj *vo;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name, *tbl, *namefield;
int rowcount;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
register char *c;
name = argv[vo->index];
}
sprintf(stmt_buf,"SELECT DISTINCT COUNT(*) FROM %s WHERE %s.%s = '%s'",
tbl,tbl,namefield,name);
- EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
- if(sqlca.sqlcode)
+ EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
+ if(sqlca.sqlcode)
return(MR_INTERNAL);
EXEC SQL DECLARE csr128 CURSOR FOR stmt;
EXEC SQL OPEN csr128;
- EXEC SQL FETCH csr128 USING DESCRIPTOR :SQLDA;
+ EXEC SQL FETCH csr128 USING DESCRIPTOR :SQLDA;
rowcount = *(int *)SQLDA->sqlvar[0].sqldata;
EXEC SQL CLOSE csr128;
char *argv[];
struct valobj *vo;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *idate;
double dd;
int errorno;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
idate = argv[vo->index];
EXEC SQL SELECT interval('years',date(:idate)-date('today')) INTO :dd;
char *argv[];
struct valobj *vo;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name, *tbl, *namefield, *idfield;
int id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status;
register char *c;
return(MR_EXISTS);
sprintf(stmt_buf,"SELECT %s FROM %s WHERE %s = LEFT('%s',SIZE(%s))",
namefield,tbl,namefield,name,namefield);
- EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
+ EXEC SQL PREPARE stmt INTO :SQLDA USING NAMES FROM :stmt_buf;
if(sqlca.sqlcode)
return(MR_INTERNAL);
EXEC SQL DECLARE csr129 CURSOR FOR stmt;
EXEC SQL OPEN csr129;
- EXEC SQL FETCH csr129 USING DESCRIPTOR :SQLDA;
+ EXEC SQL FETCH csr129 USING DESCRIPTOR :SQLDA;
if(sqlca.sqlcode == 0) id=1; else id=0;
EXEC SQL CLOSE csr129;
-
+
if (ingres_errno) return(mr_errcode);
if (id)
return(vo->error);
char *argv[];
register struct valobj *vo;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *typename;
char *val;
- EXEC SQL END DECLARE SECTION;
+ int cnt;
+ EXEC SQL END DECLARE SECTION;
register char *c;
typename = vo->table;
/* uppercase type fields */
for (c = val; *c; c++) if (islower(*c)) *c = toupper(*c);
- EXEC SQL SELECT trans INTO :cdummy FROM alias
+ EXEC SQL SELECT COUNT(trans) INTO :cnt FROM alias
WHERE name = :typename AND type='TYPE' AND trans = :val;
if (ingres_errno) return(mr_errcode);
- return (sqlca.sqlerrd[2] ? MR_EXISTS : vo->error);
+ return (cnt ? MR_EXISTS : vo->error);
}
/* validate member or type-specific data field */
register char *argv[];
register struct valobj *vo;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name;
char *field_type;
char data_type[129];
int id;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status;
char *index();
register char *c;
field_type = argv[vo->index-1];
/* get corresponding data type associated with field type name */
- EXEC SQL SELECT trans INTO :data_type FROM alias
+ EXEC SQL SELECT trans INTO :data_type FROM alias
WHERE name = :field_type AND type='TYPEDATA';
if (ingres_errno) return(mr_errcode);
if (sqlca.sqlerrd[2] != 1) return(MR_TYPE);
*index(data_type, ' ') = 0;
if (!strcmp(data_type, "user")) {
/* USER */
+ if (index(name, '@'))
+ return(MR_USER);
status = name_to_id(name, data_type, &id);
if (status && (status == MR_NO_MATCH || status == MR_NOT_UNIQUE))
return(MR_USER);
return(MR_STRING);
if (status == MR_NO_MATCH) {
if (q->type != APPEND && q->type != UPDATE) return(MR_STRING);
- EXEC SQL SELECT value INTO :id FROM numvalues WHERE name = 'strings_id';
- id++;
- EXEC SQL UPDATE numvalues SET value = :id WHERE name = 'strings_id';
- EXEC SQL INSERT INTO strings (string_id, string) VALUES (:id, :name);
+ id=add_string(name);
cache_entry(name, "STRING", id);
} else if (status) return(status);
} else if (!strcmp(data_type, "none")) {
/* now set value in argv */
*(int *)argv[vo->index] = id;
-
+
return (MR_EXISTS);
}
{
sprintf(stmt_buf,"UPDATE %s SET modtime='now' WHERE %s.%s = 0",
vo->table,vo->table,vo->idfield);
- EXEC SQL EXECUTE IMMEDIATE :stmt_buf;
+ EXEC SQL EXECUTE IMMEDIATE :stmt_buf;
if (ingres_errno) return(mr_errcode);
if (sqlca.sqlerrd[2] != 1)
return(vo->error);
}
for(j=0; j<QMAXARGS; j++) {
- if((it->sqlvar[j].sqldata=malloc(sizeof(short)+QMAXARGSIZE))==NULL) {
+ if((it->sqlvar[j].sqldata=malloc(sizeof(short)+ARGLEN))==NULL) {
com_err(whoami, MR_NO_MEM, "setting up SQLDA variables");
exit(1);
}
- it->sqlvar[j].sqllen=QMAXARGSIZE;
+ it->sqlvar[j].sqllen=ARGLEN;
it->sqlvar[j].sqlind=null_indicators+j;
null_indicators[j]=0;
}
}
-/* Use this after FETCH USING DESCRIPTOR one or more
+/* Use this after FETCH USING DESCRIPTOR one or more
* result columns may contain NULLs. This routine is
* not currently needed, since db/schema creates all
* columns with a NOT NULL WITH DEFAULT clause.
*intp=0;
}
break;
- }
+ }
}
}
*
* Correct functioning of this routine may depend on the assumption
* that this query is an APPEND.
- */
+ */
prefetch_value(q,argv,cl)
struct query *q;
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
char *name = q->validate->object_id;
int value;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int status, limit, argc;
/* set next object id, limiting it if necessary */
- if(!strcmp(name, "uid") || !strcmp(name, "gid"))
+ if(!strcmp(name, "uid") || !strcmp(name, "gid"))
limit = 1; /* So far as I know, this isn't needed. Just CMA. */
- else
+ else
limit = 0;
if((status = set_next_object_id(name, q->rtable, limit)) != MR_SUCCESS)
return(status);
if(sqlca.sqlerrd[2] != 1) return(MR_INTERNAL);
argc = q->argc + q->vcnt; /* end of Argv for APPENDs */
- sprintf(argv[argc],"%d",value);
+ sprintf(argv[argc],"%d",value); /** Could save this step by changing tlist from %s to %d **/
return(MR_SUCCESS);
}
* see comments at prefetch_value().
*
* Assumes the existence of a row where filsys_id = argv[0], since a
- * filesys label has already been resolved to a filsys_id.
+ * filesys label has already been resolved to a filsys_id.
*/
prefetch_filesys(q,argv,cl)
struct query *q;
char **argv;
client *cl;
{
- EXEC SQL BEGIN DECLARE SECTION;
+ EXEC SQL BEGIN DECLARE SECTION;
int fid,phid;
- EXEC SQL END DECLARE SECTION;
+ EXEC SQL END DECLARE SECTION;
int argc;
fid = *(int *)argv[0];
if(ingres_errno) return(mr_errcode);
argc=q->argc+q->vcnt;
- sprintf(argv[argc++],"%d",fid);
- sprintf(argv[argc],"%d",phid);
+ sprintf(argv[argc++],"%d",phid);
+ sprintf(argv[argc],"%d",fid);
return(MR_SUCCESS);
}
convert_wildcards(arg)
char *arg;
{
- static char buffer[QMAXARGSIZE];
+ static char buffer[ARGLEN];
register char *s, *d;
for(d=buffer,s=arg;*s;s++) {
case '*': *d++='%'; *d++='%'; break;
case '?': *d++='_'; break;
case '_':
- case '[':
+ case '[':
case ']': *d++='*'; *d++ = *s; break;
case '%': *d++='*'; *d++='%'; *d++='%'; break;
default: *d++ = *s; break;
/* This version includes uppercase conversion, for things like gmac.
* This is necessary because "LIKE" doesn't work with "uppercase()".
* Including it in a wildcard routine saves making two passes over
- * the argument string.
+ * the argument string.
*/
convert_wildcards_uppercase(arg)
char *arg;
{
- static char buffer[QMAXARGSIZE];
+ static char buffer[ARGLEN];
register char *s, *d;
for(d=buffer,s=arg;*s;s++) {
case '*': *d++='%'; *d++='%'; break;
case '?': *d++='_'; break;
case '_':
- case '[':
+ case '[':
case ']': *d++='*'; *d++ = *s; break;
case '%': *d++='*'; *d++='%'; *d++='%'; break;
default: *d++=toupper(*s); break; /* This is the only diff. */
/* Copy back into argv */
strcpy(arg,buffer);
-
+
return(MR_EXISTS);
}
+
+/* Looks like it's time to build an abstraction barrier, Yogi */
+mr_select_any(stmt)
+ EXEC SQL BEGIN DECLARE SECTION;
+ char *stmt;
+ EXEC SQL END DECLARE SECTION;
+{
+ int result=0;
+
+ EXEC SQL PREPARE stmt FROM :stmt;
+ EXEC SQL DESCRIBE stmt INTO :SQLDA;
+ if(SQLDA->sqld==0) /* Not a SELECT */
+ return(MR_INTERNAL);
+ EXEC SQL DECLARE csr CURSOR FOR stmt;
+ EXEC SQL OPEN csr;
+ EXEC SQL FETCH csr USING DESCRIPTOR :SQLDA;
+ if(sqlca.sqlcode==0)
+ result=MR_EXISTS;
+ else if((sqlca.sqlcode<0) && mr_errcode)
+ result=mr_errcode;
+ else
+ result=0;
+ EXEC SQL CLOSE csr;
+ return(result);
+}
+
+
+
+static hex_dump(p)
+unsigned char *p;
+{
+ char buf[BUFSIZ];
+ int i;
+
+ fprintf(stderr, "Size: %d\n", strlen(p));
+ while (strlen(p) >= 8) {
+ fprintf(stderr, "%02x %02x %02x %02x %02x %02x %02x %02x\n",
+ p[0], p[1], p[2], p[3], p[4], p[5], p[6], p[7]);
+ p += 8;
+ }
+ switch (strlen(p)) {
+ case 7:
+ fprintf(stderr, "%02x %02x %02x %02x %02x %02x %02x\n",
+ p[0], p[1], p[2], p[3], p[4], p[5], p[6]);
+ break;
+ case 6:
+ fprintf(stderr, "%02x %02x %02x %02x %02x %02x\n",
+ p[0], p[1], p[2], p[3], p[4], p[5]);
+ break;
+ case 5:
+ fprintf(stderr, "%02x %02x %02x %02x %02x\n",
+ p[0], p[1], p[2], p[3], p[4]);
+ break;
+ case 4:
+ fprintf(stderr, "%02x %02x %02x %02x\n",
+ p[0], p[1], p[2], p[3]);
+ break;
+ case 3:
+ fprintf(stderr, "%02x %02x %02x\n",
+ p[0], p[1], p[2]);
+ break;
+ case 2:
+ fprintf(stderr, "%02x %02x\n",
+ p[0], p[1]);
+ break;
+ case 1:
+ fprintf(stderr, "%02x\n",
+ p[0]);
+ break;
+ default:
+ return;
+ }
+}
+
+
+
+/* Adds a string to the string table. Returns the id number.
+ *
+ */
+int add_string(name)
+ EXEC SQL BEGIN DECLARE SECTION;
+ char *name;
+ EXEC SQL END DECLARE SECTION;
+{
+ EXEC SQL BEGIN DECLARE SECTION;
+ char buf[256];
+ int id;
+ EXEC SQL END DECLARE SECTION;
+
+ EXEC SQL SELECT value INTO :id FROM numvalues WHERE name = 'strings_id';
+ id++;
+ EXEC SQL UPDATE numvalues SET value = :id WHERE name = 'strings_id';
+
+ /* Use sprintf to get around problem with doubled single quotes */
+ sprintf(buf,"INSERT INTO strings (string_id, string) VALUES (%d, '%s')",id,name);
+ EXEC SQL EXECUTE IMMEDIATE :buf;
+
+ return(id);
+}
+
+
/* eof:qsupport.dc */
andersk / moira.git / blobdiff