【GaussDB】x86环境下UGO的部署

最新推荐文章于 2024-04-15 10:23:00 发布
最新推荐文章于 2024-04-15 10:23:00 发布
阅读量377 收藏
点赞数 1
分类专栏： 国产数据库-GaussDB 文章标签： gaussdb linux 运维
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43346403/article/details/137454860
版权

1.安装依赖包 

yum install gawk gcc make which perl crontabs unzip tar numactl rsync cut iplogrotate sed sha256sum wc xargs
yum install -y gcc patch libffi-devel python-devel  
yum install -y zlib-devel 
yum install -y bzip2-devel 
yum install -y openssl-devel 
yum install -y ncurses-devel 
yum install -y sqlite-devel 
yum install -y readline-devel 
yum install -y tk-devel 
yum install -y gdbm-devel 
yum install -y db4-devel 
yum install -y libpcap-devel 
yum install -y xz-devel

useradd ugo 
passwd ugo  密码:ugo

2.上传包 

UGO24.1.T0229.zip 
unzip UGO24.1.T0229.zip 
cd UGO24.1.T0229
tar xvf ThirdPartySoftware.tar.gz
cd ThirdPartySoftware
bash install.sh

--第三方工具安装输出内容
[+] All the required softwares will be installed under root user and required environment variables will be configured for user where UGO will be installed.
[?] Enter the username where UGO is going to be installed (User will be created if not exists) : ugo
TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
[+] Pre-Check Started
[+] Pre-Check system Architecture
[+] Current System Architecture : x86_64
[+] Pre-Check OS
[!] Current OS Type is not compatible.
Do you want to continue(y/n)?y
[+] Pre-Check gcc
[+] current gcc version: gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44)
[+] Pre-Check Make command
[+] current make version: GNU Make 3.82
[+] Pre-Check which
[+] Pre-check Perl
[+] Current perl Version : 5.16.3
[+] Pre-Check cron
[+] Pre-Check unzip
[+] current unzip version: 6.00
[+] Pre-Check numactl libs
[+] Pre-Check rsync
[+] current rsync version: rsync  version 3.1.2  protocol version 31
[+] Pre-Check other system softwares
TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
[+] Pre-Check username
[+] Pre-Check Memory
[+] Current available memory : 14GB
[+] Pre-Check Disk
[+] Available disk space : 43GB
[+] Pre-Check CPU Cores
[+] Current CPU Core Count : 4
TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
[+] Installation Started.
[+] Start check haveged installed or not
warning: haveged-1.9.1-1.h1.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 255f3799: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:haveged-1.9.1-1.h1               ################################# [100%]
Created symlink from /etc/systemd/system/multi-user.target.wants/haveged.service to /usr/lib/systemd/system/haveged.service.
[+] Extracting libaio package.
[+] Installing libaio.
[+] Extracting zlib package.
[+] Configuring zlib.
[+] Compiling zlib.
[+] Installing zlib.
[+] Extracting libffi package.
[+] Configuring libffi.
[+] Compiling libffi.
[+] Installing libffi.
[+] Extracting openssl package.
[+] Configuring openssl.
[+] Compiling openssl.
[+] Installing openssl.
[+] Extracting Python tar.xz package to tar.
[+] Extracting Python tar package.
[+] Compiling python.
[+] Installing python.
[+] Installing python modules...
[+] Installing six.
[+] Installing protobuf.
[+] Installing pymysql.
[+] Installing pycparser.
[+] Installing cffi.
[+] Installing cryptography.
[+] Installing defusedxml.
[+] Installing xlsxwriter.
[+] Installing charset_normalizer.
[+] Installing certifi.
[+] Installing idna.
[+] Installing urllib3.
[+] Installing requests.
[+] Extracting jre package.
[+] Installation Completed.
TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
[+] Configuring .bashrc
[+] Configuring Crontab
[+] User has access to crontab.
[+] Configuration Completed.
TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
[+] Verification Started.
[+] Verifying Python installation
[+] Version : Python 3.10.12
[+] Verifying Python module ssl.
[+] Verifying Python module defusedxml.
[+] Verifying Python module zlib.
[+] Verifying Python module gzip.
[+] Verifying Python module pymysql.
[+] Verifying Python module pycparser.
[+] Verifying Python module cffi.
[+] Verifying Python module cryptography.
[+] Verifying Python module charset_normalizer.
[+] Verifying Python module certifi.
[+] Verifying Python module idna.
[+] Verifying Python module urllib3.
[+] Verifying Python module requests.
[+] Verification Ended.

2.python3版本检查 。

[root@oracle11gdg ThirdPartySoftware]# python3 --version
Python 3.10.12

3.手工创建WEB签名:

mkdir /root/ugo 
keytool -genkey -alias UGOWebKeystoreCRT -validity 3650 -keyalg RSA -keystore "/root/ugo/UGOWebKeystore" -keysize 2048 -storetype PKCS12

[root@oracle11gdg ~]# keytool -genkey -alias UGOWebKeystoreCRT -validity 3650 -keyalg RSA -keystore "/root/ugo/UGOWebKeystore" -keysize 2048 -storetype PKCS12
Enter keystore password:  
Re-enter new password: 
What is your first and last name?
  [Unknown]:  xueshuangqi
What is the name of your organizational unit?
  [Unknown]:  att
What is the name of your organization?
  [Unknown]:  att
What is the name of your City or Locality?
  [Unknown]:  chengdu
What is the name of your State or Province?
  [Unknown]:  sichuan
What is the two-letter country code for this unit?
  [Unknown]:  001
Is CN=xueshuangqi, OU=att, O=att, L=chengdu, ST=sichuan, C=001 correct?
  [no]:  yes

4.解压安装包。

cd /root/UGO24.1.T0229/
tar xvf UGO.tar.gz 

cp /root/LICUGO_2_20240327RWY55L.xml  /root/UGO24.1.T0229/UGO
cd /root/UGO24.1.T0229/UGO

LICUGO_2_20240327RWY55L.xml 是向华为申请的LICENSE文件，和MAC地址绑定。


--UGO的数据库安装时设置一个负载的密码:
设置一个UGO数据库用户密码: Ugo#1234

python3 install.py install --install-repo-db --license /root/UGO24.1.T0229/UGO/LICUGO_2_20240327RWY55L.xml --web-cert  /root/ugo/UGOWebKeystore --os-user ugo
PreCheck => Java                         |         OK | Java - ( Version: 1.8.0_392, Distribution: openjdk )        

Triggering install for given user ...

PreCheck => OS User                      |         OK | Current user verified successfully.                         
PreCheck => Java                         |         OK | Java - ( Version: 1.8.0_392, Distribution: openjdk )        
PreCheck => openssl                      |         OK | openssl verified successfully.                              
PreCheck => keytool                      |         OK | keytool verified successfully.                              
PreCheck => unzip                        |         OK | unzip verified successfully.                                
PreCheck => gzip                         |         OK | gzip verified successfully.                                 
PreCheck => rsync                        |         OK | rsync verified successfully.                                
PreCheck => cut                          |         OK | cut verified successfully.                                  
PreCheck => ip                           |         OK | ip verified successfully.                                   
PreCheck => sed                          |         OK | sed verified successfully.                                  
PreCheck => sha256sum                    |         OK | sha256sum verified successfully.                            
PreCheck => wc                           |         OK | wc verified successfully.                                   
PreCheck => xargs                        |         OK | xargs verified successfully.                                
PreCheck => OS                           |       WARN | Current OS may not be compatible. Current OS : Red Hat Enterprise Linux Server 7.9 (Maipo)
PreCheck => Cron job                     |         OK | Cron job verified successfully.                             
PreCheck => Locale                       |         OK | Verified Locale Successfully.                               
PreCheck => CPU Cores                    |         OK | No. of CPU Cores : 4                                        
PreCheck => License                      |         OK | License is valid till 28-May-2024 23:59:59 CST.             
Enter the password for Certificate : rootroot --输入认证密码，上面创建签名文件的签名密码。
PreCheck => WebCert                      |       WARN | Web Certificate is valid for 3649 day(s). Given certificate is self signed.
PreCheck => Disk                         |         OK | Available disk space : 41.44GB                              
PreCheck => Ports                        |         OK | Input ports verified successfully.                          
PreCheck => Memory                       |         OK | Available Memory : 14GB                    
Enter DB Name: ugo    --输入管理ugo的数据库
Enter DB UserName: ugo  --输入管理ugo的用户。
Enter the password for DB User -> ugo: Ugo#1234 --输入自定义密码,需要稍微复杂的密码。
Retype password: Ugo#1234 --输入自定义密码,需要稍微复杂的密码。
Enter the password for IAM User -> admin: Ugo#1234 --输入自定义复杂密码,WEB控制台用户密码。
Retype password: Ugo#1234   --输入自定义密码,需要稍微复杂的密码。WEB控制台用户密码
Installation started.

Cron => Python access check.             |         OK | Cron access check for Python started...                     
Cron => Java access check.               |         OK | Cron access check for Java started...                       
Create config DB => logrotate            |         OK | Config file created: /home/ugo/ugoserver/bin/script/mysql.conf
Configure => DB                          |         OK | Properties configured.                                      
Create config catalina => logrotate      |         OK | Config file created: /home/ugo/ugoserver/bin/script/catalina.conf
Configure => WebUI                       |         OK | Properties configured.                                      
Configure => UGO_AppMigration            |         OK | Properties configured.                                      
Configure => UGO_CharsetAssess           |         OK | Properties configured.                                      
Configure => UGO_DbObjectCollection      |         OK | Properties configured.                                      
Configure => UGO_Migration               |         OK | Properties configured.                                      
Configure => UGO_PreMigration            |         OK | Properties configured.                                      
Configure => UGO_Verification            |         OK | Properties configured.                                      
Configure => UGO_IAMService              |         OK | Properties configured.                                      
Start => DB                              |         OK | Service started successfully.                               
Test => DB connection                    |         OK | DB connection tested successfully.                          
Start => Create DataBase                 |         OK | Database created successfully.                              
Start => WebUI                           |         OK | Service started successfully.                               
Configure => IAM User Details            |         OK | IAM User details Configured.                                
Start => UGO_IAMService                  |         OK | Service started successfully.                               
Cron => Verify Python access Check       |         OK | Python access Check for Cron Verified.                      
Cron => Cleanup Python access check.     |         OK | Cleanup done for Python access check Cron.                  
Cron => Verify Java access Check         |         OK | Java access Check for Cron Verified.                        
Cron => Cleanup Java access check.       |         OK | Cleanup done for Java access check Cron.                    

URL to access the Web: 
https://192.168.75.58:8090/ugo/

Note : Started WebUI Services in Backend. Please wait for sometime before accessing WebURL.
Configured Application Migration Port: 9040
Configured Charset Assess Port: 9040
Configured DB Object Collection Port: 9040
Configured Migration Port: 9040
Configured Pre Migration Port: 9040
Configured Verification Port: 9040
Configured IAM Port: 9001
Please refer installer log for more Information.

Installed in below mentioned Directory:
-----------------------------------------------------------------
path: /home/ugo/ugoserver

Total Execution time 0:04:07.577295
Installation completed.

5.-检查UGO进程 

[ugo@oracle11gdg ~]$ ps -ef |grep ugo
ugo        4815      1  0 10:34 ?        00:00:00 /bin/sh /home/ugo/ugoserver/db/server/bin/mysqld_safe --defaults-file=/home/ugo/ugoserver/db/server/my.cnf
ugo        5595   4815  4 10:34 ?        00:00:13 /home/ugo/ugoserver/db/server/bin/mysqld --defaults-file=/home/ugo/ugoserver/db/server/my.cnf --basedir=/home/ugo/ugoserver/db/server --datadir=/home/ugo/ugoserver/db/data --plugin-dir=/home/ugo/ugoserver/db/server/lib/plugin --log-error=/home/ugo/ugoserver/logs/db/repodb.err --pid-file=/home/ugo/ugoserver/db/server/mysqld.pid --socket=/home/ugo/ugoserver/db/server/mysql.sock --port=3306
ugo        6068      1 99 10:35 ?        00:10:24 /home/ugo/jre1.8.0_392/bin/java -Dnop -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Dlog4j2.formatMsgNoLookups=true -Djava.security.properties=/home/ugo/ugoserver/web/conf/provider.security -Xms3072m -Xmx5120m -XX:+PrintGCDetails -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -XX:+PrintGCDateStamps -Xloggc:/home/ugo/ugoserver/logs/services/gclog.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=5m -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/home/ugo/ugoserver/logs/services/ -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0077 -Djava.net.preferIPv4Stack=false -Djava.net.preferIPv4Addresses -Dorg.apache.catalina.connector.RECYCLE_FACADES=true -Dorg.apache.catalina.STRICT_SERVLET_COMPLIANCE=true -Dorg.apache.tomcat.util.http.ServerCookie.FWD_SLASH_IS_SEPARATOR=false -Dorg.apache.tomcat.util.http.ServerCookie.STRICT_NAMING=false -Dignore.endorsed.dirs= -classpath /home/ugo/ugoserver/web/bin/bootstrap.jar:/home/ugo/ugoserver/web/bin/tomcat-juli.jar -Djava.security.manager -Djava.security.policy==/home/ugo/ugoserver/web/conf/catalina.policy -Dcatalina.base=/home/ugo/ugoserver/web -Dcatalina.home=/home/ugo/ugoserver/web -Djava.io.tmpdir=/home/ugo/ugoserver/web/temp org.apache.catalina.startup.Bootstrap start
ugo        6102      1 21 10:35 ?        00:00:45 java -Dlog4j2.formatMsgNoLookups=true -XX:+PrintGCDetails -Djava.net.preferIPv4Addresses -Djava.net.preferIPv4Stack=false -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -XX:+PrintGCDateStamps -Xloggc:/home/ugo/ugoserver/logs/services/UGO_IAMService/gclog.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=5m -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/home/ugo/ugoserver/logs/services/UGO_IAMService/ -Xms512m -Xmx1024m -DIAM_HOME=/home/ugo/ugoserver/services/UGO_IAMService -DLOGFILE_PATH=/home/ugo/ugoserver/logs/services/UGO_IAMService -cp /home/ugo/ugoserver/services/UGO_IAMService/../../web/shared/3rd_party_lib/*:/home/ugo/ugoserver/services/UGO_IAMService/../../web/shared/UGO_lib/*:/home/ugo/ugoserver/services/UGO_IAMService/lib/* com.huawei.gauss.dsc.iamservice.IAMServiceApplication
*/
--可以看到，UGO的后台进程，有一个MySQL的后台数据库。

--mysql 的目录假如环境变量。
[ugo@oracle11gdg bin]$ cat ~/.bash_profile 
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi
# User specific environment and startup programs
PATH=/home/ugo/ugoserver/db/server/bin:$PATH:$HOME/.local/bin:$HOME/bin
export PATH

source ~/.bash_profile

6.登录UGO元数据库 。

 mysql -uugo -pUgo#1234 -S /home/ugo/ugoserver/db/server/mysql.sock -h127.0.0.1
--查看UGO相关的数据库元数据库。

mysql -uugo -pUgo#1234 -S /home/ugo/ugoserver/db/server/mysql.sock -h127.0.0.1
mysql> use ugo 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

showDatabase changed
mysql> show tables; 
+-------------------------------------+
| Tables_in_ugo                       |
+-------------------------------------+
| APPMIG_SOURCEDB_SUPPORT_INFO        |
| APP_CODE_FILE                       |
| APP_COLLECTION_TYPE_SUPPORT_INFO    |
| APP_DATA_PROCESSING_PROGRESS        |
| APP_FILE_PARSING_PROGRESS           |
| APP_FILE_PARSING_TASK_PROGRESS_INFO |
| APP_SOURCESQL_HISTORY               |
| APP_SQL_INFO                        |
| APP_TYPE_SUPPORT_INFO               |
| APP_UPLOAD_FILE_INFO                |
| AUDIT_COLLECTION_DATABASE_OBJECTS   |
| AUDIT_DATABASES                     |
| AUDIT_ERROR_FILES                   |
| AUDIT_PROJECT                       |
| AUDIT_RULES                         |
| AUDIT_SINGLE_SQL_HISTORY            |
| AUDIT_SQL                           |
| AUDIT_SQL_DEPENDENCE                |
| AUDIT_SQL_META_INFO                 |
| AUDIT_SQL_NO_MATCH_RULES            |
| AUDIT_SQL_VIOLATION                 |
| AUDIT_TASK                          |
| AUDIT_TASK_CAPTURE                  |
| AUDIT_TASK_SQL                      |
| AUDIT_TEMPLATES                     |
| AUDIT_TEMPLATE_RULES                |
| CHARSET_ASSESS_TABLE                |
| CHARSET_CONFIG                      |
| CHARSET_CONVERT_RECORD              |
| CHARSET_MAL_RECORD                  |
| CHARSET_PROJECT                     |
| CHARSET_TABLE_COLUMN_STAT           |
| DBAPP_UNZIP_FILE_PROGRESS           |
| DBTYPE_OBJTYPE_MAP                  |
| DBTYPE_SQLTYPE_MAP                  |
| DB_ALARM                            |
| DB_APPMIG_PROJECTS                  |
| DB_APPMIG_PROJECT_FILE_INFO         |
| DB_APPMIG_PROJECT_TRAN_SQL_MAP      |
| DB_APP_CPU_INFO                     |
| DB_APP_INCR_SQL_INFO                |
| DB_APP_INCR_SQL_SNAPSHOTS_INFO      |
| DB_APP_MEM_INFO                     |
| DB_APP_SQLOBJECT_TYPE               |
| DB_APP_SQL_COMPLEX_INFO             |
| DB_APP_SQL_INFO                     |
| DB_APP_SQL_INFO_STATS               |
| DB_APP_SYS_INFO                     |
| DB_COLLECTION_CHECKPOINT_STATE      |
| DB_COLLECTION_DIFF_DATA             |
| DB_COLLECTION_SCHEMA                |
| DB_COLLECTION_STATUS                |
| DB_COLLECTION_VERIFICATION          |
| DB_COLL_SRCDB_ROUTE_COUNTER         |
| DB_COMMON_TASK                      |
| DB_CONNECTIONS                      |
| DB_DELTA_COLLECTION_INFO            |
| DB_DELTA_COLLECTION_PROGRESS        |
| DB_DEP_ORDER_PROGRESS               |
| DB_DISTRIBUTED_COLUMN               |
| DB_EVALUATION_PROJECTS              |
| DB_EVAL_PROJECT_STATISTIC           |
| DB_EVAL_PROJECT_STATISTIC_DETAILS   |
| DB_EVA_DB2_TOKEN                    |
| DB_IAM_HISTORY                      |
| DB_IAM_OPERATION                    |
| DB_IAM_PERMISSION                   |
| DB_IAM_ROLE                         |
| DB_IAM_USER                         |
| DB_IAM_USER_ACCESS_CONTROL          |
| DB_IAM_USER_LOGIN_ATTEMPTS          |
| DB_IAM_USER_LOGIN_INFO              |
| DB_IAM_USER_SESSION                 |
| DB_MAPPING_TB_MIGRATION             |
| DB_MIGRATION                        |
| DB_MIGRATION_CONFIG                 |
| DB_MIGRATION_CONFIG_CATEGORY        |
| DB_MIGRATION_DEFAULT_CONFIG         |
| DB_MIGRATION_HISTORY                |
| DB_MIGRATION_OBJECT_BULK_HISTORY    |
| DB_MIGRATION_OBJECT_HISTORY         |
| DB_MIGRATION_PROJECTS               |
| DB_MIGRATION_SPLIT_STATEMENT        |
| DB_MIGRATION_SQL_CONVERT_CONFIG     |
| DB_MIGRATION_STATUS                 |
| DB_MIGRATION_TEMPLATE_CONFIG        |
| DB_MIGRATION_TEMPLATE_CONFIG_MAP    |
| DB_MIG_OBJ_UPLOAD_DETAIL            |
| DB_MIG_OBJ_UPLOAD_TASK              |
| DB_MIG_PROJECT_STATISTIC            |
| DB_OBJCOMP_PROJECTS                 |
| DB_OFFLINE_PARSE_FILE_INFO          |
| DB_OFFLINE_PROJECT_FILE_INFO        |
| DB_PREMIG_OBJECTSTAT                |
| DB_PREMIG_OBJECT_MATCH              |
| DB_PREMIG_OBJTYPE_SUMMARY           |
| DB_PREMIG_PROGRESS                  |
| DB_PREMIG_RISK_ANALYSIS             |
| DB_PREMIG_RISK_CATEGORY             |
| DB_PREMIG_SUBEVAL_MAPPING           |
| DB_PREMIG_SUMMARY                   |
| DB_PREMIG_SYSTEMOBJ                 |
| DB_PREMIG_SYSTEMOBJ_COLUMNS         |
| DB_PREMIG_TABLE_COMPLEXITY          |
| DB_PRE_MIGRATION                    |
| DB_PRE_MIGRATION_DATABASE_ANALYSIS  |
| DB_SCHEMA_COUNT_VERIFICATION        |
| DB_SCHEMA_DELTA_COUNT_PROGRESS      |
| DB_SQL_CONVERSION_STATISTIC         |
| DB_SQL_SIZE                         |
| DB_SRC_CATALOG                      |
| DB_SRC_DEPENDENCY                   |
| DB_SRC_INDEX_DEPENDENCY             |
| DB_SRC_MIGRATION_OBJ                |
| DB_SRC_TABLE_STATS                  |
| DB_SRC_TRACE_INFO                   |
| DB_SUPPORT_INFO                     |
| DB_TYPES                            |
| DB_VERIFICATION_CLEANUP             |
| DB_VERIFICATION_ERR_FREQUENCY       |
| DB_VERIFICATION_HISTORY             |
| DB_VERIFICATION_OBJECT_BULK_REQDATA |
| DB_VERIFICATION_ROLE_GRANT          |
| DB_VERIFICATION_SNAPSHOT            |
| DB_VERIFICATION_STATUS              |
| DOWNLOAD_LOG_TASK                   |
| EVAL_PROJECT_INFO_MSG               |
| EVAL_SYSTEM_ROLE_LIST               |
| EVA_DELTACOL_OBJINFO                |
| EVA_INFO_STATS                      |
| EVA_METRIC_DATA_CONFIGS             |
| EVA_METRIC_HIS                      |
| EVA_METRIC_MIN_MAX                  |
| EVA_PACKAGE_OBJECT_TYPES            |
| EVA_PRE_CHECK_ITEMS                 |
| EVA_SCHEMA_INFO                     |
| EVA_SKIPPED_OBJ                     |
| EVA_SQL_DATA                        |
| EXPORT_TASK                         |
| EXTRACT_SQL_TASK                    |
| MIGRATION_EVALUATION_PROJECT_MAP    |
| MIGRATION_SKIP_OBJECTS              |
| MIG_CACHE_STORE                     |
| MIG_OBJCOMP_COMPARE_RESULT          |
| MIG_OBJCOMP_OBJLIST                 |
| MIG_OBJCOMP_OBJLIST_COUNT           |
| MIG_OBJCOMP_OBJTYPELIST             |
| MIG_OBJCOMP_TRACE_INFO              |
| MIG_ONLINE_FILE_UPLOAD              |
| MIG_ONLINE_FILE_UPLOAD_INFO         |
| MIG_PRE_CHECK_PROGRESS              |
| MIG_PRE_CHECK_RESULT                |
| MIG_USERS_PASSWORD                  |
| OBJCOMP_OP_COUNT                    |
| OBJCOMP_PROJECT_MAP                 |
| OBJCOMP_SCHEMA_TYPE_LIST            |
| OBJECT_NAME_MAPPING                 |
| OFFLINE_SOURCEDB_SUPPORT_INFO       |
| REPO_DB_VERSION_INFO                |
| SOURCE_DB_OBJECT_FILTER             |
| SRC_SCHEMA_FILTER_LIST              |
| SRC_SYSTEM_ROLE_LIST_V11            |
| SRC_TO_TGT_VERSION_MAP              |
| TABLESPACE_DETAIL                   |
| TAG_INFO_STATS                      |
| UGO_ALARMRECORDS                    |
| UGO_ALARMS                          |
| UGO_AUDITRECORD                     |
| UGO_Configuration                   |
| UGO_PROJECT_CONFIG                  |
| UGO_SLI_SUMMARY                     |
| UGO_WEAK_PWD_DICT                   |
| USER_ROLES_COLLECTION               |
| seqgen                              |
+-------------------------------------+
174 rows in set (0.01 sec)

7.UGOweb界面登录。

网络可联通的浏览器访问UGO WEB界面。
https://192.168.75.58:8090/ugo/#/console/dashboard
admin/Ugo#1234   --安装时设置的用户密码。
--可以登录控制台查看控制台的内容。目前只有单机UGO,无GaussDB,无法看到其他内容。

8.UGO服务重启。

su - ugo 
cd /home/ugo/ugoserver/bin/
python3 ugoserver.py restart
-----------------------------------------------------------------
 Service Name                   | Operation Details
-----------------------------------------------------------------
 DB                             | Service stopped successfully.
 WebUI                          | Service stopped successfully.
 UGO_IAMService                 | Service stopped successfully.
 DB                             | Service started successfully.
 WebUI                          | Service started successfully.
 UGO_IAMService                 | Service started successfully.
-----------------------------------------------------------------
Note : Started WebUI Services in Backend. Please wait for sometime before accessing WebURL.

9.查看UGO服务状态。

su - ugo 
cd /home/ugo/ugoserver/bin/
python3 ugoserver.py status
-----------------------------------------------------------------
 Service Name                   | Status    
-----------------------------------------------------------------
 DB                             | UP        
 DB                             | Service listening on port : 3306
 WebUI                          | UP        
 License                        | License is valid till 28-May-2024 23:59:59 CST.
 PREMIGRATION - Validity        | 2024-05-28
 OBJMIGRATION - Validity        | 2024-05-28
 APPMIGRATION - Validity        | 2024-05-28
 OBJCOMPARISON - Validity       | 2024-05-28
 SQLCONV - Validity             | 2024-05-28
 WebUI                          | Service listening on port : 8090
 UGO_AppMigration               | Service listening on port : 9040
 UGO_CharsetAssess              | Service listening on port : 9040
 UGO_DbObjectCollection         | Service listening on port : 9040
 UGO_Migration                  | Service listening on port : 9040
 UGO_PreMigration               | Service listening on port : 9040
 UGO_Verification               | Service listening on port : 9040
 UGO_IAMService                 | UP        
 UGO_IAMService                 | Service listening on port : 9001
-----------------------------------------------------------------

10.检查license状态。

python3 ugoserver.py status -s webui

-----------------------------------------------------------------
 Service Name                   | Status    
-----------------------------------------------------------------
 WebUI                          | UP        
 License                        | License is valid till 28-May-2024 23:59:59 CST.
 PREMIGRATION - Validity        | 2024-05-28
 OBJMIGRATION - Validity        | 2024-05-28
 APPMIGRATION - Validity        | 2024-05-28
 OBJCOMPARISON - Validity       | 2024-05-28
 SQLCONV - Validity             | 2024-05-28
 WebUI                          | Service listening on port : 8090
 UGO_AppMigration               | Service listening on port : 9040
 UGO_CharsetAssess              | Service listening on port : 9040
 UGO_DbObjectCollection         | Service listening on port : 9040
 UGO_Migration                  | Service listening on port : 9040
 UGO_PreMigration               | Service listening on port : 9040
 UGO_Verification               | Service listening on port : 9040
-----------------------------------------------------------------



--执行以下命令，查看UGO服务的License证书状态:
python3 ugoserver.py license-status

-----------------------------------------------------------------
 License                        | Status    
-----------------------------------------------------------------
 Status                         | Valid     
 Message                        | License is valid
 Validity                       | 28-May-2024 23:59:59 CST
 PREMIGRATION - Validity        | 2024-05-28
 OBJMIGRATION - Validity        | 2024-05-28
 APPMIGRATION - Validity        | 2024-05-28
 OBJCOMPARISON - Validity       | 2024-05-28
 SQLCONV - Validity             | 2024-05-28
-----------------------------------------------------------------

11.查看特定License证书文件中的License证书的状态：

su - root 
cd /root/UGO24.1.T0229/UGO/
python3 install.py license-check --ip 192.168.75.58 --license  /root/UGO24.1.T0229/UGO/LICUGO_2_20240327RWY55L.xml

-----------------------------------------------------------------
 License                        | Status    
-----------------------------------------------------------------
 Status                         | Valid     
 Message                        | License is valid
 Validity                       | 28-May-2024 23:59:59 CST
 PREMIGRATION - Validity        | 2024-05-28
 OBJMIGRATION - Validity        | 2024-05-28
 APPMIGRATION - Validity        | 2024-05-28
 OBJCOMPARISON - Validity       | 2024-05-28
 SQLCONV - Validity             | 2024-05-28
-----------------------------------------------------------------

12.Ugo数据库root密码未知，修改数据库root用户的密码。

--修改root用户密码。
vi /home/ugo/ugoserver/db/server/my.cnf
skip-grant-tables = FALSE 
--修改为:
skip-grant-tables = TRUE

--重启服务。
su - ugo 
cd /home/ugo/ugoserver/bin
python3 ugoserver.py restart

--密码登录后修改密码。
mysql -uroot -p -S /home/ugo/ugoserver/db/server/mysql.sock
mysql> flush privileges; 
Query OK, 0 rows affected (0.01 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.35    |
+-----------+
1 row in set (0.00 sec)
mysql> select user,host from mysql.user; 
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| ugo              | 127.0.0.1 |
| ugo-root         | 127.0.0.1 |
| ugo-root         | ::1       |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| ugo-root         | localhost |
+------------------+-----------+


ALTER USER 'ugo-root'@'localhost' IDENTIFIED BY 'Ugo#1234';
ALTER USER 'ugo-root'@'127.0.0.1' IDENTIFIED BY 'Ugo#1234';
ALTER USER 'ugo-root'@'::1' IDENTIFIED BY 'Ugo#1234';


--创建一个UGO能够远程登陆的ROOT用户。
create user 'ugo-root'@'%' identified by 'Ugo#1234';
grant all privileges on *.* to 'ugo-root'@'%';

--修改参数文件设置skip-grant-tables = FALSE ，重启UGO;
vi /home/ugo/ugoserver/db/server/my.cnf
skip-grant-tables = FALSE

su - ugo 
cd /home/ugo/ugoserver/bin
python3 ugoserver.py restart

--创建SOCKET软链接。
ln -sv /home/ugo/ugoserver/db/server/mysql.sock /tmp/mysql.sock

--登录UGO的root管理员账号即可查看和管理UGO;
mysql -u'ugo-root' -pUgo#1234  
mysql> show databases; 
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| ugo                |
+--------------------+
5 rows in set (0.00 sec)


--登录UGO;
--UGO的用户里面有127.0.0.1的名称。所以登录时需要带h参数。
mysql -uugo -pUgo#1234 -h127.0.0.1
mysql> show databases; 
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| ugo                |
+--------------------+
5 rows in set (0.00 sec)

13.如何修改 UGO 运行内存参数？

cd /home/ugo/ugoserver/web/bin
vim setenv.sh
-XmsXXXXm -XmxYYYYm
python3 ugoserver.py restart

--当前默认值如下。
cd /home/ugo/ugoserver/web/bin
cat setenv.sh
#!/bin/bash
umask 0077
export LOGGING_HOME=/home/ugo/ugoserver/logs/services
export UGO_HOME=/home/ugo/ugoserver
export UGO_DB_DRIVER_LIB=/home/ugo/ugoserver/web/shared/UGO_DBDriver_Lib
export JAVA_OPTS="$JAVA_OPTS -Dlog4j2.formatMsgNoLookups=true -Djava.security.properties=$UGO_HOME/web/conf/provider.security -Xms3072m -Xmx5120m -XX:+PrintGCDetails -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCApplicationConcurrentTime -XX:+PrintGCDateStamps -Xloggc:$LOGGING_HOME/gclog.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=5m -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=$LOGGING_HOME/"
export CATALINA_OUT=/home/ugo/ugoserver/logs/web/catalina.out
export CATALINA_PID=/home/ugo/ugoserver/web/HwEoLrLlOd.tcatpid

--修改这个值即可。
-Xms3072m -Xmx5120m
--更新 JVM 内存的规则：
● 对于62 GB或更多RAM计算机：maxJVMMemory（或）Xmx
● 对于32 GB RAM计算机：maxJVMMemory（或）Xmx
● 对于16 GB RAM计算机：maxJVMMemory（或）Xmx
● 对于大于16 GB的RAM计算机：maxJVMMemory（或）Xmx

戒掉贪嗔痴(薛双奇)
关注
专栏目录
pg兼容oracle语法,GaussDB(for PostgreSQL)性能超原生PG 5倍，兼容Oracle的语法！
weixin_33873297的博客
04-04 2212
在今年的全联接大会期间，华为云对外公布了数据库服务的全景图，下图可以看到，产品覆盖开源和华为自研两大生态。开源生态服务如RDS for MySQL、DDS社区版等主要面向成本相对敏感用户群，目标是在超越开源的前提下打造极致性价比。华为自主生态服务GaussDB系列主要面向政企客户打造企业级商用数据库，满足行业客户高可靠、高性能的极致要求。其中包括关系型数据库：GaussDB(openGauss)、...
ugo
03-21
"ugo"是一个与CSS相关的项目，很可能是一个前端框架或者库，命名可能源于“雨果”这一中文词汇，寓意该项目如雨水般滋润Web开发，提供便利。由于提供的信息有限，我们将主要探讨CSS这一主题，它是网页设计和开发中的...
GaussDB云数据库配套工具UGO
Gauss松鼠会
07-21 4304
UGO负责对源库进行风险和工作量评估，自动转换异构数据库语法，据了解，目前已经做到了95%的自动化；DRS负责全量和增量数据的实时在线迁移和同步，通过数据一致性比对确保数据零丢失。 华为云数据库提供“GaussDB + UGO + DRS”一站式迁移上云解决方案，可帮助用户提前识别迁移风险，提升迁移效率，最大化降低用户的数据库迁移成本 。
GaussDB数据库适配工具DRS和UGO介绍
最新发布
weixin_45430425的博客
04-15 821
DRS 数据复制服务，UGO 数据库和应用迁移。简单一点说 ，数据库适配过程分两个工具对应的是两个阶段。数据库对象适配 用UGO工具，这里有个区别就是。
❤️‍【GaussDB精品课第6期】数据库和应用迁移UGO服务❤️‍
Gauss松鼠会
10-13 1564
【GaussDB精品课第6期】数据库和应用迁移UGO服务
Linux-UGO用户权限
weixin_44850244的博客
05-27 916
一个文件有三种权限分别是读、写、执行，实际应用中我们需要某一文件根据场景对不同人群想要限制其读写执行的权限限制则需要使用到此技术。语法格式：chmod (u/g/o)(+/-/=)(r/w/x) 文件。UGO代表的是User、Group、Other。语法格式：chown 属主.属组 文件。简写：o、g、o、a(o+g+o)权限对象有用户、组、其他人。权限类型有读、写、执行。
文件权限管理 ugo
anqiujiaduizhang的博客
08-02 1134
我们linux服务器上有严格的权限等级，如果权限过高导致误操作会增加服务器的风险。所以对于了解linux系统中的各种权限及要给用户，服务等分配合理的权限十分重要
HCIP-GaussDB for MySQL题库.docx
08-20
4. **GaussDB(for MySQL)部署模式**： - 支持计算存储分离架构，这有利于资源的独立扩展和管理。 - 部署模式包括公有云和混合云，适应不同环境需求。 5. **正则表达式与SQL**： - 正则表达式如`h+`用于匹配一个...
GaussDB云数据库行业解决方案.pdf
10-14
7. **迁移与兼容性**：华为云数据库迁移服务（如UGO和DRS）能够帮助企业在不中断业务的情况下，高效、安全地完成结构和数据的迁移，同时通过流量回放技术确保业务稳定性和性能。 8. **持续创新与演进**：GaussDB自...
华为云GaussDB数字化转型解决方案.pdf
10-17
例如，GaussDB (for Mongo) 提供MongoDB兼容服务，GaussDB (for Influx) 适用于时序数据处理，而GaussDB (for Cassandra) 和GaussDB (for Redis) 则分别针对Cassandra和Redis的特性进行了优化。 在全栈软硬件能力...
GaussDB 200 6.5.1 软件安装 02.pdf
11-15
GaussDB 200 6.5.1 软件安装 02.pdf，华为GaussDB数据库安装教程。本文档介绍GaussDB 200的部署方案及软件安装的具体操作过程。本文档适用于安装工程师。
GaussDB_T_1.0.2-EULER20SP8-ARM.tar.gz
04-14
GaussDB_T_1.0.2-EULER20SP8-ARM是集群版包含单机版的安装包，在华为的欧拉系统上安装所需要的包
gaussDB安装
bolinmengling的博客
03-23 7032
云平台_gaussDB安装
GaussDB_200_6.5.1部署安装
刘元林的博客
05-08 2158
# 连接gaussdb（如果不加载${BIGDATA_HOME}/mppdb/.mppdbgs_profile ，执行就会报下面的错误）web操作创建集群，具体操作参考：https://www.jianshu.com/p/ffb47ab1d0f6。## omm用户执行，加载环境变量（此时再次查看数据库版本就不同了，是kernel version）# 创建用户和数据库，用户密码必须包含三种字符，否则会报错；## omm用户执行，查看数据库版本。修改install安装配置文件。GaussDB200测试。
【GaussDB】华为云环境下安装Docker管理的GaussDB
weixin_43346403的博客
04-07 542
经过安装发下:docker方式部署，只需要一个 / 目录，就可以，不必所有节点都挂载。挂很多盘浪费资源，测试环境，可以只挂一个目录。18.以root用户进入上传软件包节点appctl.sh文件所在目录。22.由于是自动安装，无法找到密码，所以无法登录/12.python3 版本检查。14.selinux配置修改。9.libcgroup 检查。21.docker 进程查看。11.关闭GSSAPI认证。5.安装 expect。7.安装dos2unix。15.设置pam规则。16.开启安装步骤。
GaussDB_T 单机版轻量安装
jnrjian的博客
11-09 2648
1、GaussDB T 软件安装目录存储空间不足导致安装失败，存储空间最少要求20GB。在安装完成，会在omm用户配置文件.bashrc添加4个环境变量。具体安装过程说明，下面日志表示安装成功。表2 zengine.ini配置表。表1 install安装参数说明。
GaussDB 200单机实例安装使用教程【入门必看】
热门推荐
留歌__36的博客
05-22 1万+
写在前面 GaussDB的产品，最初GaussDB的产品定义有三大产品线系列GaussDB 100、GaussDB 200、GaussDB300，简单介绍下： 1）GaussDB 100：主要以OLTP为主。目前该产品已经应用在招商银行。在 2020年6月，将会开源单机版本； 2）GaussDB 200：以OLAP为主，兼顾OLTP。该产品以 PostgreSQL 为出发点，面向 MPP 研发，目前已经在工商银行得到上线应用。 3）GaussDB 300：以 HTAP 为方向，是企业级分布式HTAP数据库（
2.GaussDB分布式数据库部署
weixin_43346403的博客
08-29 2582
这里需要注意，配置文件尽量不要手工编辑，容易出错。在GaussDB,OceanBase，TiDB等分布式数据库部署时，配置文件都是严格按照对齐方式的，手工编辑的会出现多次失败，直到配置信息正确。执行如上两个命令能够有效方式，在部署结束后集群启动失败，600s超时的问题。集中式部署有集中式部署的包，分布式有分布式部署的包。（2）分布式数据库的部署，尽量使用数据库自带的配置文件进行修改，手工修改容易出错，导致部署失败。配置信息看起来没有问题，接下来我们部署，看看手工配置的的信息能不能部署成功。
GaussDB 100单机版安装
cuirise的博客
09-26 3073
1.准备linux系统 Centos7.6（虚拟机4G 内存，40GB硬盘） 2.准备远程登录软件mobaxterm 3.修改系统配置文件（为安装做准备） vim /etc/profile ulimit -c unlimited vim /etc/sysctl.conf kernel.core_pattern = /corefile/core-%e-%p-%t 4.生效系统配置文件 source /ect/profile sysctl -p 5.关闭防火墙 iptables -F
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值