com.aoindustries.aoserv.master.linux.Server_GetTableHandler Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of aoserv-master Show documentation
Show all versions of aoserv-master Show documentation
Master server for the AOServ Platform.
/*
* aoserv-master - Master server for the AOServ Platform.
* Copyright (C) 2018, 2019 AO Industries, Inc.
* [email protected]
* 7262 Bull Pen Cir
* Mobile, AL 36695
*
* This file is part of aoserv-master.
*
* aoserv-master is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* aoserv-master is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with aoserv-master. If not, see getTableIds() {
return EnumSet.of(Table.TableID.AO_SERVERS);
}
@Override
protected void getTableMaster(DatabaseConnection conn, RequestSource source, StreamableOutput out, boolean provideProgress, Table.TableID tableID, User masterUser) throws IOException, SQLException {
MasterServer.writeObjects(
conn,
source,
out,
provideProgress,
CursorMode.AUTO,
new Server(),
"select\n"
+ " server,\n"
+ " hostname,\n"
+ " daemon_bind,\n"
+ " daemon_key,\n"
+ " pool_size,\n"
+ " distro_hour,\n"
+ " last_distro_time,\n"
+ " failover_server,\n"
+ " \"daemonDeviceId\",\n"
+ " daemon_connect_bind,\n"
+ " time_zone,\n"
+ " jilter_bind,\n"
+ " restrict_outbound_email,\n"
+ " daemon_connect_address,\n"
+ " failover_batch_size,\n"
+ " monitoring_load_low,\n"
+ " monitoring_load_medium,\n"
+ " monitoring_load_high,\n"
+ " monitoring_load_critical,\n"
+ " \"uidMin\",\n"
+ " \"gidMin\",\n"
+ " \"uidMax\",\n"
+ " \"gidMax\",\n"
+ " \"lastUid\",\n"
+ " \"lastGid\",\n"
+ " sftp_umask\n"
+ "from\n"
+ " linux.\"Server\""
);
}
@Override
protected void getTableDaemon(DatabaseConnection conn, RequestSource source, StreamableOutput out, boolean provideProgress, Table.TableID tableID, User masterUser, UserHost[] masterServers) throws IOException, SQLException {
MasterServer.writeObjects(
conn,
source,
out,
provideProgress,
CursorMode.AUTO,
new Server(),
"select distinct\n"
+ " ao2.server,\n"
+ " ao2.hostname,\n"
+ " ao2.daemon_bind,\n"
+ " ao2.daemon_key,\n"
+ " ao2.pool_size,\n"
+ " ao2.distro_hour,\n"
+ " ao2.last_distro_time,\n"
+ " ao2.failover_server,\n"
+ " ao2.\"daemonDeviceId\",\n"
+ " ao2.daemon_connect_bind,\n"
+ " ao2.time_zone,\n"
+ " ao2.jilter_bind,\n"
+ " ao2.restrict_outbound_email,\n"
+ " ao2.daemon_connect_address,\n"
+ " ao2.failover_batch_size,\n"
+ " ao2.monitoring_load_low,\n"
+ " ao2.monitoring_load_medium,\n"
+ " ao2.monitoring_load_high,\n"
+ " ao2.monitoring_load_critical,\n"
+ " ao2.\"uidMin\",\n"
+ " ao2.\"gidMin\",\n"
+ " ao2.\"uidMax\",\n"
+ " ao2.\"gidMax\",\n"
+ " ao2.\"lastUid\",\n"
+ " ao2.\"lastGid\",\n"
+ " ao2.sftp_umask\n"
+ "from\n"
+ " master.\"UserHost\" ms\n"
+ " inner join linux.\"Server\" ao on ms.server=ao.server\n"
// Allow its failover parent
+ " left join linux.\"Server\" ff on ao.failover_server=ff.server\n"
// Allow its failover children
+ " left join linux.\"Server\" fs on ao.server=fs.failover_server\n"
// Allow servers it replicates to
+ " left join backup.\"FileReplication\" ffr on ms.server=ffr.server\n"
+ " left join backup.\"BackupPartition\" bp on ffr.backup_partition=bp.id,\n"
+ " linux.\"Server\" ao2\n"
+ "where\n"
+ " ms.username=?\n"
+ " and (\n"
// Allow direct access
+ " ms.server=ao2.server\n"
// Allow its failover parent
+ " or ff.server=ao2.server\n"
// Allow its failover children
+ " or fs.server=ao2.server\n"
// Allow servers it replicates to
+ " or bp.ao_server=ao2.server\n"
+ " )",
source.getCurrentAdministrator()
);
}
@Override
protected void getTableAdministrator(DatabaseConnection conn, RequestSource source, StreamableOutput out, boolean provideProgress, Table.TableID tableID) throws IOException, SQLException {
MasterServer.writeObjects(
conn,
source,
out,
provideProgress,
CursorMode.AUTO,
new Server(),
"select distinct\n"
+ " ao.server,\n"
+ " ao.hostname,\n"
+ " ao.daemon_bind,\n"
+ " ?,\n"
+ " ao.pool_size,\n"
+ " ao.distro_hour,\n"
+ " ao.last_distro_time,\n"
+ " ao.failover_server,\n"
+ " ao.\"daemonDeviceId\",\n"
+ " ao.daemon_connect_bind,\n"
+ " ao.time_zone,\n"
+ " ao.jilter_bind,\n"
+ " ao.restrict_outbound_email,\n"
+ " ao.daemon_connect_address,\n"
+ " ao.failover_batch_size,\n"
+ " ao.monitoring_load_low,\n"
+ " ao.monitoring_load_medium,\n"
+ " ao.monitoring_load_high,\n"
+ " ao.monitoring_load_critical,\n"
+ " ao.\"uidMin\",\n"
+ " ao.\"gidMin\",\n"
+ " ao.\"uidMax\",\n"
+ " ao.\"gidMax\",\n"
+ " ao.\"lastUid\",\n"
+ " ao.\"lastGid\",\n"
+ " ao.sftp_umask\n"
+ "from\n"
+ " account.\"User\" un,\n"
+ " billing.\"Package\" pk,\n"
+ " account.\"AccountHost\" bs,\n"
// Allow servers it replicates to
//+ " left join backup.\"FileReplication\" ffr on bs.server=ffr.server\n"
//+ " left join backup.\"BackupPartition\" bp on ffr.backup_partition=bp.id,\n"
+ " linux.\"Server\" ao\n"
+ "where\n"
+ " un.username=?\n"
+ " and un.package=pk.name\n"
+ " and pk.accounting=bs.accounting\n"
+ " and (\n"
+ " bs.server=ao.server\n"
// Allow servers it replicates to
//+ " or bp.ao_server=ao.server\n"
+ " )",
AoservProtocol.FILTERED,
source.getCurrentAdministrator()
);
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy