网站定制化服务,云南百度推广开户,做免费的网站教程,做相册网站推荐前言
在我学习guacamole的过程中发现全网大致有两种方式安装guacamole的方式#xff1a;
1. 直接安装#xff08;下载java环境/mysql/, 修改配置#xff09;
2. docker安装#xff08;和直接安装类似#xff0c;需要下载相关环境#xff0c;然后做配置#xff09;
然…前言
在我学习guacamole的过程中发现全网大致有两种方式安装guacamole的方式
1. 直接安装下载java环境/mysql/, 修改配置
2. docker安装和直接安装类似需要下载相关环境然后做配置
然后最近项目需要为了偷懒于是学习了docker-compose编写了docker-compose-guacamole脚本最后测试成功跑通。
具体步骤
新建文件docker-compose-guacamole.yml
将如下内容粘贴保存
version: 3services:guacamole:image: guacamole/guacamoledepends_on:- guacd- guacamole-mysql-serverenvironment:MYSQL_HOSTNAME: guacamole-mysql-serverMYSQL_DATABASE: guacamole_dbMYSQL_USER: guacamoleMYSQL_PASSWORD: winring2023GUACD_HOSTNAME: guacdports:- 9000:8080networks:- my-guacamole-networksguacd:image: guacamole/guacddepends_on:- guacamole-mysql-servernetworks:- my-guacamole-networksguacamole-mysql-server:image: mysql/mysql-servervolumes:- ./initdb.sql:/docker-entrypoint-initdb.d/initdb.sqlrestart: alwaysenvironment:MYSQL_ROOT_PASSWORD: winring2023MYSQL_DATABASE: guacamole_dbMYSQL_USER: guacamoleMYSQL_PASSWORD: winring2023networks:- my-guacamole-networksnetworks:my-guacamole-networks:driver: bridge
新建initdb.sql数据库
将如下内容粘贴保存
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements. See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership. The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- License); you may not use this file except in compliance
-- with the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
----
-- Table of connection groups. Each connection group has a name.
--CREATE TABLE guacamole_connection_group (connection_group_id int(11) NOT NULL AUTO_INCREMENT,parent_id int(11),connection_group_name varchar(128) NOT NULL,type enum(ORGANIZATIONAL,BALANCING) NOT NULL DEFAULT ORGANIZATIONAL,-- Concurrency limitsmax_connections int(11),max_connections_per_user int(11),enable_session_affinity boolean NOT NULL DEFAULT 0,PRIMARY KEY (connection_group_id),UNIQUE KEY connection_group_name_parent (connection_group_name, parent_id),CONSTRAINT guacamole_connection_group_ibfk_1FOREIGN KEY (parent_id)REFERENCES guacamole_connection_group (connection_group_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of connections. Each connection has a name, protocol, and
-- associated set of parameters.
-- A connection may belong to a connection group.
--CREATE TABLE guacamole_connection (connection_id int(11) NOT NULL AUTO_INCREMENT,connection_name varchar(128) NOT NULL,parent_id int(11),protocol varchar(32) NOT NULL,-- Guacamole proxy (guacd) overridesproxy_port integer,proxy_hostname varchar(512),proxy_encryption_method enum(NONE, SSL),-- Concurrency limitsmax_connections int(11),max_connections_per_user int(11),-- Load-balancing behaviorconnection_weight int(11),failover_only boolean NOT NULL DEFAULT 0,PRIMARY KEY (connection_id),UNIQUE KEY connection_name_parent (connection_name, parent_id),CONSTRAINT guacamole_connection_ibfk_1FOREIGN KEY (parent_id)REFERENCES guacamole_connection_group (connection_group_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of base entities which may each be either a user or user group. Other
-- tables which represent qualities shared by both users and groups will point
-- to guacamole_entity, while tables which represent qualities specific to
-- users or groups will point to guacamole_user or guacamole_user_group.
--CREATE TABLE guacamole_entity (entity_id int(11) NOT NULL AUTO_INCREMENT,name varchar(128) NOT NULL,type enum(USER,USER_GROUP) NOT NULL,PRIMARY KEY (entity_id),UNIQUE KEY guacamole_entity_name_scope (type, name)) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of users. Each user has a unique username and a hashed password
-- with corresponding salt. Although the authentication system will always set
-- salted passwords, other systems may set unsalted passwords by simply not
-- providing the salt.
--CREATE TABLE guacamole_user (user_id int(11) NOT NULL AUTO_INCREMENT,entity_id int(11) NOT NULL,-- Optionally-salted passwordpassword_hash binary(32) NOT NULL,password_salt binary(32),password_date datetime NOT NULL,-- Account disabled/expired statusdisabled boolean NOT NULL DEFAULT 0,expired boolean NOT NULL DEFAULT 0,-- Time-based access restrictionaccess_window_start TIME,access_window_end TIME,-- Date-based access restrictionvalid_from DATE,valid_until DATE,-- Timezone used for all date/time comparisons and interpretationtimezone VARCHAR(64),-- Profile informationfull_name VARCHAR(256),email_address VARCHAR(256),organization VARCHAR(256),organizational_role VARCHAR(256),PRIMARY KEY (user_id),UNIQUE KEY guacamole_user_single_entity (entity_id),CONSTRAINT guacamole_user_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id)ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of user groups. Each user group may have an arbitrary set of member
-- users and member groups, with those members inheriting the permissions
-- granted to that group.
--CREATE TABLE guacamole_user_group (user_group_id int(11) NOT NULL AUTO_INCREMENT,entity_id int(11) NOT NULL,-- Group disabled statusdisabled boolean NOT NULL DEFAULT 0,PRIMARY KEY (user_group_id),UNIQUE KEY guacamole_user_group_single_entity (entity_id),CONSTRAINT guacamole_user_group_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id)ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of users which are members of given user groups.
--CREATE TABLE guacamole_user_group_member (user_group_id int(11) NOT NULL,member_entity_id int(11) NOT NULL,PRIMARY KEY (user_group_id, member_entity_id),-- Parent must be a user groupCONSTRAINT guacamole_user_group_member_parent_idFOREIGN KEY (user_group_id)REFERENCES guacamole_user_group (user_group_id) ON DELETE CASCADE,-- Member may be either a user or a user group (any entity)CONSTRAINT guacamole_user_group_member_entity_idFOREIGN KEY (member_entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of sharing profiles. Each sharing profile has a name, associated set
-- of parameters, and a primary connection. The primary connection is the
-- connection that the sharing profile shares, and the parameters dictate the
-- restrictions/features which apply to the user joining the connection via the
-- sharing profile.
--CREATE TABLE guacamole_sharing_profile (sharing_profile_id int(11) NOT NULL AUTO_INCREMENT,sharing_profile_name varchar(128) NOT NULL,primary_connection_id int(11) NOT NULL,PRIMARY KEY (sharing_profile_id),UNIQUE KEY sharing_profile_name_primary (sharing_profile_name, primary_connection_id),CONSTRAINT guacamole_sharing_profile_ibfk_1FOREIGN KEY (primary_connection_id)REFERENCES guacamole_connection (connection_id)ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of connection parameters. Each parameter is simply a name/value pair
-- associated with a connection.
--CREATE TABLE guacamole_connection_parameter (connection_id int(11) NOT NULL,parameter_name varchar(128) NOT NULL,parameter_value varchar(4096) NOT NULL,PRIMARY KEY (connection_id,parameter_name),CONSTRAINT guacamole_connection_parameter_ibfk_1FOREIGN KEY (connection_id)REFERENCES guacamole_connection (connection_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of sharing profile parameters. Each parameter is simply
-- name/value pair associated with a sharing profile. These parameters dictate
-- the restrictions/features which apply to the user joining the associated
-- connection via the sharing profile.
--CREATE TABLE guacamole_sharing_profile_parameter (sharing_profile_id integer NOT NULL,parameter_name varchar(128) NOT NULL,parameter_value varchar(4096) NOT NULL,PRIMARY KEY (sharing_profile_id, parameter_name),CONSTRAINT guacamole_sharing_profile_parameter_ibfk_1FOREIGN KEY (sharing_profile_id)REFERENCES guacamole_sharing_profile (sharing_profile_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of arbitrary user attributes. Each attribute is simply a name/value
-- pair associated with a user. Arbitrary attributes are defined by other
-- extensions. Attributes defined by this extension will be mapped to
-- properly-typed columns of a specific table.
--CREATE TABLE guacamole_user_attribute (user_id int(11) NOT NULL,attribute_name varchar(128) NOT NULL,attribute_value varchar(4096) NOT NULL,PRIMARY KEY (user_id, attribute_name),KEY user_id (user_id),CONSTRAINT guacamole_user_attribute_ibfk_1FOREIGN KEY (user_id)REFERENCES guacamole_user (user_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of arbitrary user group attributes. Each attribute is simply a
-- name/value pair associated with a user group. Arbitrary attributes are
-- defined by other extensions. Attributes defined by this extension will be
-- mapped to properly-typed columns of a specific table.
--CREATE TABLE guacamole_user_group_attribute (user_group_id int(11) NOT NULL,attribute_name varchar(128) NOT NULL,attribute_value varchar(4096) NOT NULL,PRIMARY KEY (user_group_id, attribute_name),KEY user_group_id (user_group_id),CONSTRAINT guacamole_user_group_attribute_ibfk_1FOREIGN KEY (user_group_id)REFERENCES guacamole_user_group (user_group_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of arbitrary connection attributes. Each attribute is simply a
-- name/value pair associated with a connection. Arbitrary attributes are
-- defined by other extensions. Attributes defined by this extension will be
-- mapped to properly-typed columns of a specific table.
--CREATE TABLE guacamole_connection_attribute (connection_id int(11) NOT NULL,attribute_name varchar(128) NOT NULL,attribute_value varchar(4096) NOT NULL,PRIMARY KEY (connection_id, attribute_name),KEY connection_id (connection_id),CONSTRAINT guacamole_connection_attribute_ibfk_1FOREIGN KEY (connection_id)REFERENCES guacamole_connection (connection_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of arbitrary connection group attributes. Each attribute is simply a
-- name/value pair associated with a connection group. Arbitrary attributes are
-- defined by other extensions. Attributes defined by this extension will be
-- mapped to properly-typed columns of a specific table.
--CREATE TABLE guacamole_connection_group_attribute (connection_group_id int(11) NOT NULL,attribute_name varchar(128) NOT NULL,attribute_value varchar(4096) NOT NULL,PRIMARY KEY (connection_group_id, attribute_name),KEY connection_group_id (connection_group_id),CONSTRAINT guacamole_connection_group_attribute_ibfk_1FOREIGN KEY (connection_group_id)REFERENCES guacamole_connection_group (connection_group_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of arbitrary sharing profile attributes. Each attribute is simply a
-- name/value pair associated with a sharing profile. Arbitrary attributes are
-- defined by other extensions. Attributes defined by this extension will be
-- mapped to properly-typed columns of a specific table.
--CREATE TABLE guacamole_sharing_profile_attribute (sharing_profile_id int(11) NOT NULL,attribute_name varchar(128) NOT NULL,attribute_value varchar(4096) NOT NULL,PRIMARY KEY (sharing_profile_id, attribute_name),KEY sharing_profile_id (sharing_profile_id),CONSTRAINT guacamole_sharing_profile_attribute_ibfk_1FOREIGN KEY (sharing_profile_id)REFERENCES guacamole_sharing_profile (sharing_profile_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of connection permissions. Each connection permission grants a user or
-- user group specific access to a connection.
--CREATE TABLE guacamole_connection_permission (entity_id int(11) NOT NULL,connection_id int(11) NOT NULL,permission enum(READ,UPDATE,DELETE,ADMINISTER) NOT NULL,PRIMARY KEY (entity_id,connection_id,permission),CONSTRAINT guacamole_connection_permission_ibfk_1FOREIGN KEY (connection_id)REFERENCES guacamole_connection (connection_id) ON DELETE CASCADE,CONSTRAINT guacamole_connection_permission_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of connection group permissions. Each group permission grants a user
-- or user group specific access to a connection group.
--CREATE TABLE guacamole_connection_group_permission (entity_id int(11) NOT NULL,connection_group_id int(11) NOT NULL,permission enum(READ,UPDATE,DELETE,ADMINISTER) NOT NULL,PRIMARY KEY (entity_id,connection_group_id,permission),CONSTRAINT guacamole_connection_group_permission_ibfk_1FOREIGN KEY (connection_group_id)REFERENCES guacamole_connection_group (connection_group_id) ON DELETE CASCADE,CONSTRAINT guacamole_connection_group_permission_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of sharing profile permissions. Each sharing profile permission grants
-- a user or user group specific access to a sharing profile.
--CREATE TABLE guacamole_sharing_profile_permission (entity_id integer NOT NULL,sharing_profile_id integer NOT NULL,permission enum(READ,UPDATE,DELETE,ADMINISTER) NOT NULL,PRIMARY KEY (entity_id, sharing_profile_id, permission),CONSTRAINT guacamole_sharing_profile_permission_ibfk_1FOREIGN KEY (sharing_profile_id)REFERENCES guacamole_sharing_profile (sharing_profile_id) ON DELETE CASCADE,CONSTRAINT guacamole_sharing_profile_permission_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of system permissions. Each system permission grants a user or user
-- group a system-level privilege of some kind.
--CREATE TABLE guacamole_system_permission (entity_id int(11) NOT NULL,permission enum(CREATE_CONNECTION,CREATE_CONNECTION_GROUP,CREATE_SHARING_PROFILE,CREATE_USER,CREATE_USER_GROUP,ADMINISTER) NOT NULL,PRIMARY KEY (entity_id,permission),CONSTRAINT guacamole_system_permission_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of user permissions. Each user permission grants a user or user group
-- access to another user (the affected user) for a specific type of
-- operation.
--CREATE TABLE guacamole_user_permission (entity_id int(11) NOT NULL,affected_user_id int(11) NOT NULL,permission enum(READ,UPDATE,DELETE,ADMINISTER) NOT NULL,PRIMARY KEY (entity_id,affected_user_id,permission),CONSTRAINT guacamole_user_permission_ibfk_1FOREIGN KEY (affected_user_id)REFERENCES guacamole_user (user_id) ON DELETE CASCADE,CONSTRAINT guacamole_user_permission_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of user group permissions. Each user group permission grants a user
-- or user group access to a another user group (the affected user group) for
-- a specific type of operation.
--CREATE TABLE guacamole_user_group_permission (entity_id int(11) NOT NULL,affected_user_group_id int(11) NOT NULL,permission enum(READ,UPDATE,DELETE,ADMINISTER) NOT NULL,PRIMARY KEY (entity_id, affected_user_group_id, permission),CONSTRAINT guacamole_user_group_permission_affected_user_groupFOREIGN KEY (affected_user_group_id)REFERENCES guacamole_user_group (user_group_id) ON DELETE CASCADE,CONSTRAINT guacamole_user_group_permission_entityFOREIGN KEY (entity_id)REFERENCES guacamole_entity (entity_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- Table of connection history records. Each record defines a specific users
-- session, including the connection used, the start time, and the end time
-- (if any).
--CREATE TABLE guacamole_connection_history (history_id int(11) NOT NULL AUTO_INCREMENT,user_id int(11) DEFAULT NULL,username varchar(128) NOT NULL,remote_host varchar(256) DEFAULT NULL,connection_id int(11) DEFAULT NULL,connection_name varchar(128) NOT NULL,sharing_profile_id int(11) DEFAULT NULL,sharing_profile_name varchar(128) DEFAULT NULL,start_date datetime NOT NULL,end_date datetime DEFAULT NULL,PRIMARY KEY (history_id),KEY user_id (user_id),KEY connection_id (connection_id),KEY sharing_profile_id (sharing_profile_id),KEY start_date (start_date),KEY end_date (end_date),KEY connection_start_date (connection_id, start_date),CONSTRAINT guacamole_connection_history_ibfk_1FOREIGN KEY (user_id)REFERENCES guacamole_user (user_id) ON DELETE SET NULL,CONSTRAINT guacamole_connection_history_ibfk_2FOREIGN KEY (connection_id)REFERENCES guacamole_connection (connection_id) ON DELETE SET NULL,CONSTRAINT guacamole_connection_history_ibfk_3FOREIGN KEY (sharing_profile_id)REFERENCES guacamole_sharing_profile (sharing_profile_id) ON DELETE SET NULL) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- User login/logout history
--CREATE TABLE guacamole_user_history (history_id int(11) NOT NULL AUTO_INCREMENT,user_id int(11) DEFAULT NULL,username varchar(128) NOT NULL,remote_host varchar(256) DEFAULT NULL,start_date datetime NOT NULL,end_date datetime DEFAULT NULL,PRIMARY KEY (history_id),KEY user_id (user_id),KEY start_date (start_date),KEY end_date (end_date),KEY user_start_date (user_id, start_date),CONSTRAINT guacamole_user_history_ibfk_1FOREIGN KEY (user_id)REFERENCES guacamole_user (user_id) ON DELETE SET NULL) ENGINEInnoDB DEFAULT CHARSETutf8;--
-- User password history
--CREATE TABLE guacamole_user_password_history (password_history_id int(11) NOT NULL AUTO_INCREMENT,user_id int(11) NOT NULL,-- Salted passwordpassword_hash binary(32) NOT NULL,password_salt binary(32),password_date datetime NOT NULL,PRIMARY KEY (password_history_id),KEY user_id (user_id),CONSTRAINT guacamole_user_password_history_ibfk_1FOREIGN KEY (user_id)REFERENCES guacamole_user (user_id) ON DELETE CASCADE) ENGINEInnoDB DEFAULT CHARSETutf8;
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements. See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership. The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- License); you may not use this file except in compliance
-- with the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
---- Create default user guacadmin with password guacadmin
INSERT INTO guacamole_entity (name, type) VALUES (guacadmin, USER);
INSERT INTO guacamole_user (entity_id, password_hash, password_salt, password_date)
SELECTentity_id,xCA458A7D494E3BE824F5E1E175A1556C0F8EEF2C2D7DF3633BEC4A29C4411960, -- guacadminxFE24ADC5E11E2B25288D1704ABE67A79E342ECC26064CE69C5B3177795A82264,NOW()
FROM guacamole_entity WHERE name guacadmin;-- Grant this user all system permissions
INSERT INTO guacamole_system_permission (entity_id, permission)
SELECT entity_id, permission
FROM (SELECT guacadmin AS username, CREATE_CONNECTION AS permissionUNION SELECT guacadmin AS username, CREATE_CONNECTION_GROUP AS permissionUNION SELECT guacadmin AS username, CREATE_SHARING_PROFILE AS permissionUNION SELECT guacadmin AS username, CREATE_USER AS permissionUNION SELECT guacadmin AS username, CREATE_USER_GROUP AS permissionUNION SELECT guacadmin AS username, ADMINISTER AS permission
) permissions
JOIN guacamole_entity ON permissions.username guacamole_entity.name AND guacamole_entity.type USER;-- Grant admin permission to read/update/administer self
INSERT INTO guacamole_user_permission (entity_id, affected_user_id, permission)
SELECT guacamole_entity.entity_id, guacamole_user.user_id, permission
FROM (SELECT guacadmin AS username, guacadmin AS affected_username, READ AS permissionUNION SELECT guacadmin AS username, guacadmin AS affected_username, UPDATE AS permissionUNION SELECT guacadmin AS username, guacadmin AS affected_username, ADMINISTER AS permission
) permissions
JOIN guacamole_entity ON permissions.username guacamole_entity.name AND guacamole_entity.type USER
JOIN guacamole_entity affected ON permissions.affected_username affected.name AND guacamole_entity.type USER
JOIN guacamole_user ON guacamole_user.entity_id affected.entity_id;CREATE USER guacamole% IDENTIFIED BY winring123;
GRANT SELECT,INSERT,UPDATE,DELETE ON guacamole_db.* TO guacamole%;
FLUSH PRIVILEGES;
一键执行
在ubuntu下执行如下代码并等待执行完成。
docker-compose -f docker-compose-guacamole.yml up
访问
执行完成后即可访问地址
http://localhost:9000/guacamole/#/ 文章转载自： http://www.morning.wcghr.cn.gov.cn.wcghr.cn http://www.morning.bnlkc.cn.gov.cn.bnlkc.cn http://www.morning.lfxcj.cn.gov.cn.lfxcj.cn http://www.morning.stsnf.cn.gov.cn.stsnf.cn http://www.morning.bpwdc.cn.gov.cn.bpwdc.cn http://www.morning.jncxr.cn.gov.cn.jncxr.cn http://www.morning.qmfhh.cn.gov.cn.qmfhh.cn http://www.morning.pyzt.cn.gov.cn.pyzt.cn http://www.morning.yrjkp.cn.gov.cn.yrjkp.cn http://www.morning.hncrc.cn.gov.cn.hncrc.cn http://www.morning.gtmgl.cn.gov.cn.gtmgl.cn http://www.morning.pgcmz.cn.gov.cn.pgcmz.cn http://www.morning.grqlc.cn.gov.cn.grqlc.cn http://www.morning.tllhz.cn.gov.cn.tllhz.cn http://www.morning.xkwyk.cn.gov.cn.xkwyk.cn http://www.morning.addai.cn.gov.cn.addai.cn http://www.morning.nrgdc.cn.gov.cn.nrgdc.cn http://www.morning.dpfr.cn.gov.cn.dpfr.cn http://www.morning.pxdgy.cn.gov.cn.pxdgy.cn http://www.morning.jjnry.cn.gov.cn.jjnry.cn http://www.morning.kcxtz.cn.gov.cn.kcxtz.cn http://www.morning.ndhxn.cn.gov.cn.ndhxn.cn http://www.morning.sxlrg.cn.gov.cn.sxlrg.cn http://www.morning.zkgpg.cn.gov.cn.zkgpg.cn http://www.morning.skmpj.cn.gov.cn.skmpj.cn http://www.morning.rjtmg.cn.gov.cn.rjtmg.cn http://www.morning.hjbrd.cn.gov.cn.hjbrd.cn http://www.morning.gwhjy.cn.gov.cn.gwhjy.cn http://www.morning.zyytn.cn.gov.cn.zyytn.cn http://www.morning.ygkq.cn.gov.cn.ygkq.cn http://www.morning.rmmz.cn.gov.cn.rmmz.cn http://www.morning.bkpbm.cn.gov.cn.bkpbm.cn http://www.morning.dfltx.cn.gov.cn.dfltx.cn http://www.morning.mlzyx.cn.gov.cn.mlzyx.cn http://www.morning.rkqkb.cn.gov.cn.rkqkb.cn http://www.morning.bktly.cn.gov.cn.bktly.cn http://www.morning.pdtjj.cn.gov.cn.pdtjj.cn http://www.morning.drcnn.cn.gov.cn.drcnn.cn http://www.morning.tkcz.cn.gov.cn.tkcz.cn http://www.morning.lcdtb.cn.gov.cn.lcdtb.cn http://www.morning.jqwpw.cn.gov.cn.jqwpw.cn http://www.morning.rwqk.cn.gov.cn.rwqk.cn http://www.morning.cyfsl.cn.gov.cn.cyfsl.cn http://www.morning.mdgb.cn.gov.cn.mdgb.cn http://www.morning.ysrtj.cn.gov.cn.ysrtj.cn http://www.morning.lbgfz.cn.gov.cn.lbgfz.cn http://www.morning.cykqb.cn.gov.cn.cykqb.cn http://www.morning.uycvv.cn.gov.cn.uycvv.cn http://www.morning.ymhzd.cn.gov.cn.ymhzd.cn http://www.morning.jcwhk.cn.gov.cn.jcwhk.cn http://www.morning.bxfy.cn.gov.cn.bxfy.cn http://www.morning.yprjy.cn.gov.cn.yprjy.cn http://www.morning.lnrhk.cn.gov.cn.lnrhk.cn http://www.morning.bslkt.cn.gov.cn.bslkt.cn http://www.morning.dbrdg.cn.gov.cn.dbrdg.cn http://www.morning.phlwj.cn.gov.cn.phlwj.cn http://www.morning.flncd.cn.gov.cn.flncd.cn http://www.morning.hsksm.cn.gov.cn.hsksm.cn http://www.morning.brxzt.cn.gov.cn.brxzt.cn http://www.morning.yfrbn.cn.gov.cn.yfrbn.cn http://www.morning.lqws.cn.gov.cn.lqws.cn http://www.morning.xdlwm.cn.gov.cn.xdlwm.cn http://www.morning.rgtp.cn.gov.cn.rgtp.cn http://www.morning.ghssm.cn.gov.cn.ghssm.cn http://www.morning.tnnfy.cn.gov.cn.tnnfy.cn http://www.morning.bwgrd.cn.gov.cn.bwgrd.cn http://www.morning.qqhmg.cn.gov.cn.qqhmg.cn http://www.morning.gxeqedd.cn.gov.cn.gxeqedd.cn http://www.morning.krdxz.cn.gov.cn.krdxz.cn http://www.morning.cxnyg.cn.gov.cn.cxnyg.cn http://www.morning.mqss.cn.gov.cn.mqss.cn http://www.morning.pkmcr.cn.gov.cn.pkmcr.cn http://www.morning.fpqq.cn.gov.cn.fpqq.cn http://www.morning.xnwjt.cn.gov.cn.xnwjt.cn http://www.morning.wwsgl.com.gov.cn.wwsgl.com http://www.morning.lbbyx.cn.gov.cn.lbbyx.cn http://www.morning.xhftj.cn.gov.cn.xhftj.cn http://www.morning.lkbyj.cn.gov.cn.lkbyj.cn http://www.morning.ktskc.cn.gov.cn.ktskc.cn http://www.morning.djmdk.cn.gov.cn.djmdk.cn
