• [问题求助] 【ECS产品】【(mysql-8.0.22-1.el7.aarch64.rpm-bundle.tar)安装功能】
    【功能模块】【操作步骤&问题现象】1、2、【截图信息】【日志信息】(可选,上传日志内容或者附件)[root@ecs-bde1-0001 ~]# lltotal 0[root@ecs-bde1-0001 ~]# systemctl stop firewalld.service[root@ecs-bde1-0001 ~]# systemctl disable firewalld.service[root@ecs-bde1-0001 ~]# systemctl status firewalld.service● firewalld.service - firewalld - dynamic firewall daemon   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor >   Active: inactive (dead)     Docs: man:firewalld(1)...skipping...● firewalld.service - firewalld - dynamic firewall daemon   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor >   Active: inactive (dead)     Docs: man:firewalld(1)[root@ecs-bde1-0001 ~]# [root@ecs-bde1-0001 ~]# [root@ecs-bde1-0001 ~]# [root@ecs-bde1-0001 ~]# [root@ecs-bde1-0001 ~]# systemctl status firewalld.service● firewalld.service - firewalld - dynamic firewall daemon   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor >   Active: inactive (dead)     Docs: man:firewalld(1)[root@ecs-bde1-0001 ~]# setenforce 0setenforce: SELinux is disabled[root@ecs-bde1-0001 ~]# getenforceDisabled[root@ecs-bde1-0001 ~]# groupadd mysql[root@ecs-bde1-0001 ~]# useradd -g mysql mysql[root@ecs-bde1-0001 ~]# passwd mysqlChanging password for user mysql.New password: BAD PASSWORD: The password is shorter than 8 charactersRetype new password: passwd: all authentication tokens updated successfully.[root@ecs-bde1-0001 ~]# mkdir /data[root@ecs-bde1-0001 ~]# ls /dev/nvme*ls: cannot access '/dev/nvme*': No such file or directory[root@ecs-bde1-0001 ~]# mkfs.xfs -f /dev/nvme0n1Error accessing specified device /dev/nvme0n1: No such file or directoryUsage: mkfs.xfs/* blocksize */         [-b size=num]/* metadata */          [-m crc=0|1,finobt=0|1,uuid=xxx,rmapbt=0|1,reflink=0|1]/* data subvol */       [-d agcount=n,agsize=n,file,name=xxx,size=num,                            (sunit=value,swidth=value|su=num,sw=num|noalign),                            sectsize=num/* force overwrite */   [-f]/* inode size */        [-i log=n|perblock=n|size=num,maxpct=n,attr=0|1|2,                            projid32bit=0|1,sparse=0|1]/* no discard */        [-K]/* log subvol */        [-l agnum=n,internal,size=num,logdev=xxx,version=n                            sunit=value|su=num,sectsize=num,lazy-count=0|1]/* label */             [-L label (maximum 12 characters)]/* naming */            [-n size=num,version=2|ci,ftype=0|1]/* no-op info only */   [-N]/* prototype file */    [-p fname]/* quiet */             [-q]/* realtime subvol */   [-r extsize=num,size=num,rtdev=xxx]/* sectorsize */        [-s size=num]/* version */           [-V]                        devicename<devicename> is required unless -d name=xxx is given.<num> is xxx (bytes), xxxs (sectors), xxxb (fs blocks), xxxk (xxx KiB),      xxxm (xxx MiB), xxxg (xxx GiB), xxxt (xxx TiB) or xxxp (xxx PiB).<value> is xxx (512 byte blocks).[root@ecs-bde1-0001 ~]# du -sh /dev/nvme0n1du: cannot access '/dev/nvme0n1': No such file or directory[root@ecs-bde1-0001 ~]# mount /dev/nvme0n1 /data/df -hmount: /data: special device /dev/nvme0n1 does not exist.[root@ecs-bde1-0001 ~]# df -hFilesystem      Size  Used Avail Use% Mounted ondevtmpfs        3.1G     0  3.1G   0% /devtmpfs           3.4G     0  3.4G   0% /dev/shmtmpfs           3.4G   13M  3.4G   1% /runtmpfs           3.4G     0  3.4G   0% /sys/fs/cgroup/dev/vda2       295G  3.2G  279G   2% /tmpfs           3.4G   64K  3.4G   1% /tmp/dev/vda1      1022M  5.8M 1017M   1% /boot/efitmpfs           682M     0  682M   0% /run/user/0[root@ecs-bde1-0001 ~]# fdisk /dev/nvme0n1Welcome to fdisk (util-linux 2.34).Changes will remain in memory only, until you decide to write them.Be careful before using the write command.fdisk: cannot open /dev/nvme0n1: No such file or directory[root@ecs-bde1-0001 ~]# cd home-bash: cd: home: No such file or directory[root@ecs-bde1-0001 ~]# cd ../[root@ecs-bde1-0001 /]# cd home[root@ecs-bde1-0001 home]# fdisk /dev/nvme0n1System information as of time:  Tue Jun  8 09:47:34 CST 2021[root@ecs-bde1-0001 ~]# mv /etc/yum.repos.d/ /etc/yum.repos.d-bakmkdir /etc/yum.repos.d[root@ecs-bde1-0001 ~]# mkdir /etc/yum.repos.d[root@ecs-bde1-0001 ~]# echo -e "[local]\nname=local\nbaseurl=file:///mnt\ngpgcheck=0\nenabled=1" > /etc/yum.repos.d/local.repo[root@ecs-bde1-0001 ~]# cat /etc/yum.repos.d/local.repo[local]name=localbaseurl=file:///mntgpgcheck=0enabled=1[root@ecs-bde1-0001 ~]# [root@ecs-bde1-0001 ~]# mkdir /home/mysql-rpm[root@ecs-bde1-0001 ~]# ^C[root@ecs-bde1-0001 ~]# [root@ecs-bde1-0001 ~]# cd /home/mysql-rpm[root@ecs-bde1-0001 mysql-rpm]# lltotal 849M-rw------- 1 root root 849M Jun  7 16:02 mysql-8.0.22-1.el7.aarch64.rpm-bundle.tar[root@ecs-bde1-0001 mysql-rpm]# tar xvf mysql-8.0.22-1.el7.aarch64.rpm-bundle.tarmysql-community-client-8.0.22-1.el7.aarch64.rpmmysql-community-client-plugins-8.0.22-1.el7.aarch64.rpmmysql-community-common-8.0.22-1.el7.aarch64.rpmmysql-community-devel-8.0.22-1.el7.aarch64.rpmmysql-community-embedded-compat-8.0.22-1.el7.aarch64.rpmmysql-community-libs-8.0.22-1.el7.aarch64.rpmmysql-community-libs-compat-8.0.22-1.el7.aarch64.rpmmysql-community-server-8.0.22-1.el7.aarch64.rpmmysql-community-test-8.0.22-1.el7.aarch64.rpm[root@ecs-bde1-0001 mysql-rpm]# yum -y remove mariadb-libsNo match for argument: mariadb-libsNo packages marked for removal.Dependencies resolved.Nothing to do.Complete![root@ecs-bde1-0001 mysql-rpm]# yum -y install net-toolslocal                                                                                                                                  0.0  B/s |   0  B     00:00    Error: Failed to download metadata for repo 'local': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried[root@ecs-bde1-0001 mysql-rpm]# yum -y install net-toolslocal                                                                                                                                  0.0  B/s |   0  B     00:00    Error: Failed to download metadata for repo 'local': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried[root@ecs-bde1-0001 mysql-rpm]# ^C[root@ecs-bde1-0001 mysql-rpm]# cd /home/mysql-rpm[root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-common-8.0.22-1.el7.aarch64.rpmwarning: mysql-community-common-8.0.22-1.el7.aarch64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYVerifying...                          ################################# [100%]Preparing...                          ################################# [100%]Updating / installing...   1:mysql-community-common-8.0.22-1.e################################# [100%][root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-libs-8.0.22-1.el7.aarch64.rpmwarning: mysql-community-libs-8.0.22-1.el7.aarch64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYerror: Failed dependencies:        libcrypto.so.10()(64bit) is needed by mysql-community-libs-8.0.22-1.el7.aarch64        libcrypto.so.10(libcrypto.so.10)(64bit) is needed by mysql-community-libs-8.0.22-1.el7.aarch64        libssl.so.10()(64bit) is needed by mysql-community-libs-8.0.22-1.el7.aarch64        libssl.so.10(libssl.so.10)(64bit) is needed by mysql-community-libs-8.0.22-1.el7.aarch64        mysql-community-client-plugins = 8.0.22-1.el7 is needed by mysql-community-libs-8.0.22-1.el7.aarch64[root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-libs-8.0.22-1.el7.aarch64.rpm --nodeps --forcewarning: mysql-community-libs-8.0.22-1.el7.aarch64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYVerifying...                          ################################# [100%]Preparing...                          ################################# [100%]Updating / installing...   1:mysql-community-libs-8.0.22-1.el7################################# [100%][root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-client-8.0.22-1.el7.aarch64.rpm --nodeps --force[root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-client-8.0.22-1.el7.aarch64.rpm --noderror: open of mysql-community failed: No such file or directory[root@ecs-bde1-0001 mysql-rpm]# [root@ecs-bde1-0001 mysql-rpm]# [root@ecs-bde1-0001 mysql-rpm]# [root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-client-8.0.22-1.el7.aarch64.rpm --nodeps --forcewarning: mysql-community-client-8.0.22-1.el7.aarch64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYVerifying...                          ################################# [100%]Preparing...                          ################################# [100%]Updating / installing...   1:mysql-community-client-8.0.22-1.e################################# [100%]rpm -ivh mysql-community-server-8.0.22-1.el7.aarch64.rpm --nodeps --force[root@ecs-bde1-0001 mysql-rpm]# rpm -ivh mysql-community-server-8.0.22-1.el7.aarch64.rpm --nodeps --forcewarning: mysql-community-server-8.0.22-1.el7.aarch64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYVerifying...                          ################################# [100%]Preparing...                          ################################# [100%]Updating / installing...   1:mysql-community-server-8.0.22-1.e################################# [100%]/usr/lib/tmpfiles.d/mysql.conf:23: Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly./usr/lib/tmpfiles.d/subscription-manager.conf:1: Line references path below legacy directory /var/run/, updating /var/run/rhsm → /run/rhsm; please update the tmpfiles.d/ drop-in file accordingly.[root@ecs-bde1-0001 mysql-rpm]# [root@ecs-bde1-0001 mysql-rpm]# rm -f /etc/my.cnf[root@ecs-bde1-0001 mysql-rpm]# echo -e "[mysqld_safe]\nlog-error=/data/mysql/log/mysql.log\npid-file=/data/mysql/run/mysqld.pid\n[mysqldump]\nquick\n[mysql]\nno-auto-rehash\n[client]\ndefault-character-set=utf8\n[mysqld]\nbasedir=/usr/local/mysql\nsocket=/data/mysql/run/mysql.sock\ntmpdir=/data/mysql/tmp\ndatadir=/data/mysql/data\ndefault_authentication_plugin=mysql_native_password\nport=3306\nuser=mysql\n" > /etc/my.cnf[root@ecs-bde1-0001 mysql-rpm]# cat /etc/my.cnf[mysqld_safe]log-error=/data/mysql/log/mysql.logpid-file=/data/mysql/run/mysqld.pid[mysqldump]quick[mysql]no-auto-rehash[client]default-character-set=utf8[mysqld]basedir=/usr/local/mysqlsocket=/data/mysql/run/mysql.socktmpdir=/data/mysql/tmpdatadir=/data/mysql/datadefault_authentication_plugin=mysql_native_passwordport=3306user=mysql[root@ecs-bde1-0001 mysql-rpm]# chown mysql:mysql /etc/my.cnfll /etc/my.cnf[root@ecs-bde1-0001 mysql-rpm]# ll /etc/my.cnf-rw------- 1 mysql mysql 353 Jun  8 10:32 /etc/my.cnf[root@ecs-bde1-0001 mysql-rpm]# chmod 777 /usr/local/mysql/support-files/mysql.serverchmod: cannot access '/usr/local/mysql/support-files/mysql.server': No such file or directory[root@ecs-bde1-0001 mysql-rpm]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqlcp: cannot stat '/usr/local/mysql/support-files/mysql.server': No such file or directory[root@ecs-bde1-0001 mysql-rpm]# chkconfig mysql onerror reading information on service mysql: No such file or directory[root@ecs-bde1-0001 mysql-rpm]# chown -R mysql:mysql /etc/init.d/mysqlchown: cannot access '/etc/init.d/mysql': No such file or directory[root@ecs-bde1-0001 mysql-rpm]# ll /etc/init.d/mysqlls: cannot access '/etc/init.d/mysql': No such file or directory[root@ecs-bde1-0001 mysql-rpm]# chown mysql:mysql /etc/profile[root@ecs-bde1-0001 mysql-rpm]# ll /etc/profile-rw-r--r--. 1 mysql mysql 2.1K Apr  9  2019 /etc/profile[root@ecs-bde1-0001 mysql-rpm]# su - mysqlwhoami[mysql@ecs-bde1-0001 ~]$ whoamimysql[mysql@ecs-bde1-0001 ~]$ echo export PATH=$PATH:/usr/local/mysql/bin >> /etc/profile[mysql@ecs-bde1-0001 ~]$ source /etc/profileWelcome to 4.19.90-2003.4.0.0036.oe1.aarch64System information as of time:  Tue Jun  8 10:33:39 CST 2021System load:    0.26Processes:      145Memory used:    5.9%Swap used:      0.0%Usage On:       3%IP address:     192.168.0.97Users online:   4[mysql@ecs-bde1-0001 ~]$ envSHELL=/bin/bashHISTCONTROL=HISTSIZE=1000HOSTNAME=ecs-bde1-0001HISTTIMEFORMAT=GOMP_CPU_AFFINITY=0-3PWD=/home/mysqlLOGNAME=mysqlHOME=/home/mysqlSSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpassLANG=en_US.UTF-8PROMPT_COMMAND=openEuler_historyTERM=vt100USER=mysqlSHLVL=1PATH=/home/mysql/.local/bin:/home/mysql/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/local/mysql/binMAIL=/var/spool/mail/mysql_=/usr/bin/env[mysql@ecs-bde1-0001 ~]$ mysqld --defaults-file=/etc/my.cnf --initializemysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory[mysql@ecs-bde1-0001 ~]$ /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize-bash: /usr/local/mysql/bin/mysqld: No such file or directory[mysql@ecs-bde1-0001 ~]$ ls /data/mysql/datals: cannot access '/data/mysql/data': Permission denied[mysql@ecs-bde1-0001 ~]$ rm -rf /data/mysql/data/rm: cannot remove '/data/mysql/data/': Permission denied[mysql@ecs-bde1-0001 ~]$ ll /data/mysql/datals: cannot access '/data/mysql/data': Permission denied[mysql@ecs-bde1-0001 ~]$ /usr/sbin/mysqld --defaults-file=/etc/my.cnf &[1] 6905/usr/sbin/mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory[1]+  Exit 127                /usr/sbin/mysqld --defaults-file=/etc/my.cnf[mysql@ecs-bde1-0001 ~]$ service mysql startRedirecting to /bin/systemctl start mysql.service==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====Authentication is required to start 'mysql.service'.Authenticating as: rootPassword: riipolkit-agent-helper-1: pam_authenticate failed: Permission denied==== AUTHENTICATION FAILED ====Failed to start mysql.service: Access deniedSee system logs and 'systemctl status mysql.service' for details.[mysql@ecs-bde1-0001 ~]$ service mysql startRedirecting to /bin/systemctl start mysql.service==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====Authentication is required to start 'mysql.service'.Authenticating as: rootPassword: polkit-agent-helper-1: pam_authenticate failed: Permission denied==== AUTHENTICATION FAILED ====Failed to start mysql.service: Access deniedSee system logs and 'systemctl status mysql.service' for details.[mysql@ecs-bde1-0001 ~]$ mysqld --defaults-file=/etc/my.cnf &[1] 6986mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory[1]+  Exit 127                mysqld --defaults-file=/etc/my.cnf[mysql@ecs-bde1-0001 ~]$ [mysql@ecs-bde1-0001 ~]$ /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &[1] 7010-bash: /usr/local/mysql/bin/mysqld_safe: No such file or directory[1]+  Exit 127                /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf[mysql@ecs-bde1-0001 ~]$ ps -ef | grep mysqlroot        6671    3261  0 10:33 pts/3    00:00:00 su - mysqlmysql       6672    6671  0 10:33 pts/3    00:00:00 -bashmysql       7023    6672  0 10:35 pts/3    00:00:00 ps -efmysql       7024    6672  0 10:35 pts/3    00:00:00 grep --color=auto mysql[mysql@ecs-bde1-0001 ~]$  netstat -anpt(No info could be read for "-p": geteuid()=1000 but you should be root.)Active Internet connections (servers and established)Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      -                   tcp        0    344 192.168.0.97:22         116.253.157.124:4512    ESTABLISHED -                   tcp        0      0 192.168.0.97:22         116.253.157.124:8107    ESTABLISHED -                   tcp        0      0 192.168.0.97:34536      100.125.1.29:443        ESTABLISHED -                   tcp        0      0 192.168.0.97:22         116.253.157.124:4432    ESTABLISHED -                   tcp        0      0 192.168.0.97:22         116.253.157.124:7476    ESTABLISHED -                   tcp        0      0 192.168.0.97:22         116.253.157.124:6938    ESTABLISHED -                   tcp6       0      0 :::22                   :::*                    LISTEN      -                    netstat -anpt | grep mysql[mysql@ecs-bde1-0001 ~]$  netstat -anpt | grep mysql(No info could be read for "-p": geteuid()=1000 but you should be root.)[mysql@ecs-bde1-0001 ~]$  netstat -anpt | grep 3306(No info could be read for "-p": geteuid()=1000 but you should be root.)[mysql@ecs-bde1-0001 ~]$ mysql -uroot -p -S /data/mysql/run/mysql.sockmysql: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory[mysql@ecs-bde1-0001 ~]$ /usr/local/mysql/bin/mysql -uroot -p -S /data/mysql/run/mysql.sock-bash: /usr/local/mysql/bin/mysql: No such file or directory[mysql@ecs-bde1-0001 ~]$ alter user 'root'@'localhost' identified by "123456";-bash: alter: command not found[mysql@ecs-bde1-0001 ~]$ ps -ef | grep mysqlroot        6671    3261  0 10:33 pts/3    00:00:00 su - mysqlmysql       6672    6671  0 10:33 pts/3    00:00:00 -bashmysql       7117    6672  0 10:35 pts/3    00:00:00 ps -efmysql       7118    6672  0 10:35 pts/3    00:00:00 grep --color=auto mysql[mysql@ecs-bde1-0001 ~]$ /usr/local/mysql/bin/mysql -uroot -p -S /data/mysql/run/mysql.sock-bash: /usr/local/mysql/bin/mysql: No such file or directory[mysql@ecs-bde1-0001 ~]$ mysql -uroot -p -S /data/mysql/run/mysql.sockmysql: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory[mysql@ecs-bde1-0001 ~]$ service mysql startRedirecting to /bin/systemctl start mysql.service==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====Authentication is required to start 'mysql.service'.Authenticating as: rootPassword: polkit-agent-helper-1: pam_authenticate failed: Permission denied==== AUTHENTICATION FAILED ====Failed to start mysql.service: Access deniedSee system logs and 'systemctl status mysql.service' for details.[mysql@ecs-bde1-0001 ~]$ service mysql startRedirecting to /bin/systemctl start mysql.service==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====Authentication is required to start 'mysql.service'.Authenticating as: rootInfo: Account temporarily locked due to 3 failed loginsInfo: (51 seconds left to unlock)Password: polkit-agent-helper-1: pam_authenticate failed: Authentication failure==== AUTHENTICATION FAILED ====Failed to start mysql.service: Access deniedSee system logs and 'systemctl status mysql.service' for details.[mysql@ecs-bde1-0001 ~]$ systemctl status mysql.serviceUnit mysql.service could not be found.[mysql@ecs-bde1-0001 ~]$ server status mysql.service-bash: server: command not found[mysql@ecs-bde1-0001 ~]$ service status mysql.serviceThe service command supports only basic LSB actions (start, stop, restart, try-restart, reload, force-reload, status). For other actions, please try to use systemctl.[mysql@ecs-bde1-0001 ~]$ systemctl status mysql.serviceUnit mysql.service could not be found.[mysql@ecs-bde1-0001 ~]$ service mysql startRedirecting to /bin/systemctl start mysql.service==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====Authentication is required to start 'mysql.service'.Authenticating as: rootPassword: polkit-agent-helper-1: pam_authenticate failed: Permission denied==== AUTHENTICATION FAILED ====Failed to start mysql.service: Access deniedSee system logs and 'systemctl status mysql.service' for details.[mysql@ecs-bde1-0001 ~]$ /usr/sbin/mysqld --defaults-file=/etc/my.cnf &[1] 7322/usr/sbin/mysqld: error while loading shared libraries: libssl.so.10: cannot open shared object file: No such file or directory[1]+  Exit 127                /usr/sbin/mysqld --defaults-file=/etc/my.cnf
  • [技术讨论] 弹性云服务器openeuler通过官网RPM安装mysql8.0.22
    弹性云服务器openeuler通过官网RPM方式,安装mysql8.0.22,然后官网RPM安装方式安装:软件安装目录默认为“/usr”并没有看到对应mysql目录出现。如下错误也不知道是出现了什么问题?
  • [技术干货] matepad 联ecs
    去年年末攒了一件蓝牙键盘,可妮兔的;今年年初又换了一个蓝牙鼠标;今天,他们的队长,matepad终于来了~要求不高,能简单的文件处理,联ecs就行了,剩下难干的活儿,可以用云服务器做。软件商城里并没有secureCrt的安卓版本。找了下有几种解决方案:换系统,直接装Linux,现在还舍不得。模拟终端,term,试了下,没有反应。juiceSSH,这个亲测可以用。字体和背景不错,我很喜欢。
  • [技术讨论] openeuler弹性云服务器怎么安装mysql 8.0.22版本的
    openeuler弹性云服务器怎么安装mysql 8.0.22版本的,因为安装8.0.17的版本好像在服务器环境安全扫描后,发现Oracle MySQL Server安全漏洞CVE-2019-5443和Oracle MySQL Server组件安全漏洞CVE-2019-5482。
  • [技术干货] 重启后出现No bootable device场景下使用testdisk恢复数据
    【关键字】数据恢复,No bootable device,dd【约束与限制】1、请对故障磁盘创建私有镜像或者快照,为了避免破坏源磁盘的数据,恢复操作在备份的磁盘上进行。2、该文档中的恢复建立在误操作对磁盘破坏比较轻微,不能确保可以完全恢复数据,恢复程度取决于破坏的程度。【问题场景】使用中的ECS重启后无法使用,登录vnc查看显示No bootable device【根因分析】出现No bootable device通常为MBR分区表故障,将故障的ECS关机并挂载到其他Linux服务器上可以进行排查。挂盘后发现故障的系统盘(vdb)没有分区和文件系统,如下图所示出现该问题的可能原因有:      1、对已运行中的磁盘使用fifo进行性能测试导致磁盘文件系统被擦除;      2、使用dd命令擦除了磁盘MBR分区表和文件系统。      该场景下是否可以恢复数据取决于错误操作的严重程度,如果擦除较少可以找回未被擦除的数据。【操作步骤】步骤一:恢复分区1.1、将故障ECS关机,卸载系统盘并挂载至其他Linux服务器(这里我们使用CentOS7上。1.2、安装testdisk工具# yum install testdisk1.3、使用testdisk进行恢复,执行# testdisk /dev/vdb1.4、光标移动至“proceed”回车。1.5、选择要恢复的磁盘并点击“下一步”1.6、选择“Analyse”(分析当前分区架构并搜索丢失的分区信息)。1.7、选择“Quick search”。1.8、选择“Continue”。1.9、直接回车1.10、选择“Deeper Search”会进入分析过程,等待分析结束。1.11、分析完成,点击“Continue”。1.2、点击“Write”并确认输入“y”,将分析的结果写入。1.13、连续选择“Quit”退出。步骤二:恢复文件系统2.1、查看分区和文件系统,并尝试挂载2.2、如上图所示分区和文件系统可以看到,但是挂载时提示文件系统存在错误,我们可以尝试恢复文件系统,执行# fsck.ext4 /dev/vdb1 –y2.3、再次尝试挂载文件系统后成功,恢复的数据存放在挂载下的lost+found目录下,由于文件系统被破坏,原始的目录无法看到,数据存放在以#开始的目录,可以通过打开各个目录确认是哪个原始目录。2.4、查询root用户的操作记录,确定是否有擦除磁盘的操作。我们找到目录中原始的root目录,打开.bash_history文件,可以查到确实存在dd的操作,如下图所示,该操作擦除了磁盘的从开始计算的2G空间。
  • [安装] 【mindspore1.2.0】【在ECS docker中通过源码编译安装】找不到ms_profile和adump_server
    【功能模块】在swr.cn-north-4.myhuaweicloud.com/modelarts-job-dev-image/mindspore-ascend910-cp37-euleros2.8-aarch64-training:1.2.0-3.1.2-roma中尝试从源码编译安装mindspore。【操作步骤&问题现象】1、bash build.sh -e ascend -m train  -D off2、Grenerate step failed, 找不到ms_profile和adump_server。3、目前尝试过在/usr/local/Ascend/nnae/和/usr/local/Ascend/driver中搜索这两个库文件,均没有找到。【截图信息】
  • [问题求助] Ascend CANN 弹性云服务器 YOLOv3目标检测sample aclrtSynchronizeStream
    【功能模块】Ascend CANN 弹性云服务器 ,在运行YOLOv3目标检测sample 时出现 aclrtSynchronizeStream报错decode aclrtSynchronizeStream failed aclret=507018【操作步骤&问题现象】【截图信息】【日志信息】(可选,上传日志内容或者附件)
  • [技术干货] ECS内存使用常见问题
     【问题背景】在ECS的使用中会出现一些关于内存的使用问题,例如:1、我的ECS实际可以使用的总内存(MemTotal)与购买的规格不一致2、free查到的服务器内存已使用数量跟top显示的进程使用内存不一致上述问题中通常为系统设置产生,该文档对以上问题场景进行分析和处理。【问题分析与处理】问题一:我的ECS实际可以使用的总内存(MemTotal)与购买的规格不一致问题现象从free和/proc/meminfo中看到的总内存小于购买的规格内存(实际ECS规格为2G)问题分析1、可以通过dmesg查看系统启动时内存分配情况# dmesg | grep Memory如上图所示,实际总内存为2096440KB,其中可用内存为1860840KB,absent 392KB,reserved 235408KB。kdump使用kexec引导到第二个内核(捕获内核),第二个内核位于第一​​个内核无法访问的系统内存的reserved部分中,第二个内核捕获崩溃的内核内存的内容(崩溃转储)并保存,且reserved 内存属于第二内核,并且永远不会被释放或交换。系统可用内存的计算方式为:available = 物理内存 – absent – reserved确认是否配置crashkernel,可以通过查看/proc/cmd# cat /proc/cmdline如上图所示可以确认crashkernel已开启,crashkernel中内存包含在reserved中。确认不需要kdump可以释放该部分内存。释放crashkernel使用的内存会导致kdump无法使用。操作步骤1、修改grub配置,删除crashkernel配置项。# cp /etc/default/grub /etc/default/grub.bak打开/etc/default/grub找到GRUB_CMDLINE_LINUX行,将crashkernel=auto(crashkernel的值可能为具体的值或者范围,以实际参数设置为准)参数删除。2、使用grub2-mkconfig 命令重新生成cfg文件# grub2-mkconfig -o /boot/grub2/grub.cfg3、重启服务器说明步骤2中如果出现:error: environment block too small则运行以下命令后:# mv /boot/grub2/grubenv /grubenv.bak# grub2-mkconfig -o /boot/grub2/grub.cfg 问题二:free查到的服务器内存已使用数量跟top显示的进程使用内存不一致问题现象在4U8G的linux弹性云服务器,执行free –lh 命令后发现显示已使用内存5.9G,使用率将近78%,top查询的内存使用率只有不到10%,与free –lh的结果不匹配。问题分析在某些场景和应用中需要在系统内配置hugepage(大页内存)和共享内存,而大页内存和共享内存体现在free的结果中的used但是不会计算在进程的使用内存中,针对此类问题可以从这个方向进行定位。我们可以通过atop命令在MEM行可以看到内存的分配详情,如下图标记处可以看到hptot(hugepage total)项为4.9G。这部分内存,即被“大内存页”占用的这些存储器永远不会被交换出内存。它会一直保留除非修改了配置。大页内存的详情可以通过/proc/meminfo查看# cat /proc/meminfo |grep Huge可以看到开启了Huge,每个大页内存的大小是2048kB,大页内存的数据是2520个,加起来一共使用了5G内存。free –lh显示的5.9G的内存使用量,减去大页内存5G,实际使用的是0.9G.使用率跟top查询的结果相匹配。 大页内存在某些应用是必要的配置,是否取消大页内存需要根据实际场景进行决定。大页内存的设置可以通过内核参数vm.nr_hugepages进行设置。说明:1、HugePages 是 Linux 操作系统的一个内核特性,让操作系统可以支持现代硬件架构的大页面容量功能。通过启用 HugePages 并使用大页面,可以用一个页表条目代表一个大页面,而不是使用许多条目代表较小的页面,从而可以管理更多内存,减少操作系统对页面状态的维护并提高 TLB 缓存命中率。在 Linux 中,Hugepage默认大小为 2 MB。2、共享内存是多个进程间共同地使用同一段物理内存空间,它是通过将同一段物理内存映射到不同进程的 虚拟空间来实现的。由于映射到不同进程的虚拟空间中,不同进程可以直接使用,不需要像消息队列那样进行复制,所以共享内存的效率很高。列出共享内存的使用# ipcs –m共享内存的设置可以通过内核参数kernel.shmall进行设置
  • [问题求助] 华为专属加密服务可以支持多大的数据量加密传输?它是怎么加密传输的呢?流程是什么?
    华为专属加密服务可以支持多大的数据量加密传输?它是怎么加密传输的呢?流程是什么?
  • [问题求助] 【ECS产品】鲲鹏系列 ECS 编译安装drizzle 识别不了系统版本
    【功能模块】鲲鹏系列服务器编译安装openresty的时候,需要drizzle 库,编译安装drizzle这个额库的时候识别不了系统版本./configure: error: the ngx_drizzle addon requires the libdrizzle library.[root@kp-open11 drizzle7-2011.07.21]# ./configure --without-serverchecking build system type... config/config.guess: unable to guess system typeThis script, last modified 2009-06-10, has failed to recognizethe operating system you are using
  • [问题求助] 【ECS(曼谷区)】【Debian 10.2.0 64bit with ARM】执行apt upgrade后,在bios界面卡死
    【操作步骤&问题现象】复现流程:apt update apt-mark unhold base-files apt upgrade reboot结果:重启时卡在bios界面目前仅在曼谷区发现这一问题。国内区(贵阳)执行类似操作可以正常启动。【截图信息】
  • [问题求助] 【ECS(曼谷区)】【Debian 10.2.0 64bit with ARM】执行apt upgrade后,在bios界面卡死
    【操作步骤&问题现象】复现流程:apt update apt-mark unhold base-files apt upgrade reboot结果:重启时卡在bios界面目前仅在曼谷区发现这一问题。国内区(贵阳)执行类似操作可以正常启动。【截图信息】
  • [新手课堂] 微认证之路 通过鲲鹏ECS搭建免费个人书库
    ### 名称及链接 [通过鲲鹏ECS搭建免费个人书库](https://edu.huaweicloud.com/certifications/e0c0bdbb169c4b7aabd937066d70b9a5)   ### 课程章节 1. 为什么选择云上搭建个人书库 2. 搭建个人书库相关技术实现 3. 搭建个人书库的华为云实践   ### 证书   ![wrz-kp-cj-ecsshuku.png](https://bbs-img.huaweicloud.com/data/forums/attachment/forum/202105/17/194256ufrmba3obc8qjrpb.png) ### 笔记 1. 方案:EIP + 鲲鹏ECS + VPC + EVS + 宝塔linux(linux运维工具) 2. 鲲鹏ECS 1. IaaS层最核心的产品 2. 入门级:鲲鹏KC1通用型(网站部署、APP、测试环境) 3. 企业级:鲲鹏KM1内存优化型(Hadoop集群、spark集群、深度学习) 3. calibre-linux 1. 电子书管理软件 2. 开发语言为Python 4. 安全组、防火墙、端口、出入规则 5. centos基础操作命令   ### 备注 1. 感谢老师的教学与课件 2. 欢迎各位同学一起来交流学习心得^_^ 3. 在线课程、沙箱实验、博客和直播,其中包含了许多优质的内容,推荐了解与学习。
  • [技术干货] 【转】HCS场景下如何测Windows弹性云服务器性能
    测试性能前请先登录Iometer官方网站下载并安装Iometer性能测试工具注意事项测试云硬盘性能时,如果分区的初始磁柱编号是非4KB对齐,则对云硬盘性能影响较大,请先确保分区的初始磁柱编号已经4KB对齐,再开始测试。请不要在系统盘上进行fio测试,避免损坏系统重要文件。fio测试建议在空闲的、未保存重要数据的磁盘上进行,并在测试完成后重新创建文件系统。请不要在业务数据盘上测试,避免底层文件系统元数据损坏导致数据损坏登录实例。使用“win+r”组合键打开运行窗口,并输入“msinfo32”,单击“确定”。弹出系统信息窗口。选择“组件 > 存储 > 磁盘”,在右侧区域查看分区起始偏移值,确认云硬盘分区的初始磁柱编号是否已经4KB对齐。如果4096能被该参数值整除,则表示已经4KB对齐,请执行4进行性能测试。如果4096不能被该参数值整除,则表示未4KB对齐,如需继续测试请重新按照4KB对齐分区。删除分区并重新按照4KB对齐选取初始磁柱编号时会导致磁盘原有数据的丢失,请谨慎操作。使用Iometer工具测试云硬盘性能,具体方法请参见Iometer产品文档。在进行IOPS和吞吐量测试时,Iometer参数配置和fio工具的参数相同。转载自:https://forum.huawei.com/enterprise/zh/thread-738815.html
  • [其他] 弹性云服务器 ECS开机失败
    [问题求助] 弹性云服务器 ECS开机失败【功能模块】ECS云服务器开机【操作步骤&问题现象】开机失败,显示故障。没有修改过服务器的配置等等信息,就像平常一样开机,卡了一段时间后就显示故障了。现在重启、开机、关机都不允许进行。请问有什么恢复方法吗?还是说要等5天后才能允许重启?【截图信息】