notfounduser's diary

## yum update [root@localhost ~]# yum update Loaded plugins: fastestmirror Setting up Update Process Loading mirror speeds from cached hostfile https://vault.centos.org/centos/6/os/x86_64/repodata/repomd.xml: [Errno 14] problem making ssl connection Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: base. Please verify its path and try again ## fix repo [root@localhost ~]# cd /etc/yum yum/ yum.conf yum.repos.d/ [root@localhost ~]# cd /etc/yum.repos.d/ [root@localhost ~]# yum clean all Loaded plugins: fastestmirror Cleaning repos: base update Cleaning up Everything Cleaning up list of fastest mirrors ## fix repo [root@localhost yum.repos.d]# vi CentOS-Base.repo [base] name= CentOS-6 - Base baseurl= http://mirror.nsc.liu.se/centos-store/6.6/os/x86_64/ gpgcheck=0 priority=1 protect=1 [update] name=CentOS-6 - Updates baseurl=https://archive.kernel.org/centos-vault/6.6/updates/x86_64/ gpgcheck=0 priority=1 protect=1

install python 3.7 on centos7 #install yum repository [root@localhost ~]# yum install -y https://centos7.iuscommunity.org/ius-release.rpm Loaded plugins: fastestmirror, langpacks ius-release.rpm | 8.2 kB 00:00:00 Examining /var/tmp/yum-root-CBgYb0/ius-release.rpm: ius-release-2-1.el7.ius.noarch Marking /var/tmp/yum-root-CBgYb0/ius-release.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package ius-release.noarch 0:2-1.el7.ius will be installed --> Finished Dependency Resolution base/7/x86_64 | 3.6 kB 00:00:00 base/7/x86_64/group_gz | 165 kB 00:00:00 base/7/x86_64/primary_db

install mysql 8.0 commercial on centos #install the MySQL Server [root@localhost ~]# mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm bash: mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm: 명령을 찾을 수 없습니다... [root@localhost ~]# yum install mysql-commercial-server-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-client-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-libs-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-common-8.0.17-1.1.el7.x86_64.rpm mysql-commercial-libs-compat-8.0.17-1.1.el7.x86_64.rpm Loaded plugins: fastestmirror, langpacks Examining mysql-commercial-server-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-server-8.0.17-1.1.el7.x86_64 Marking mysql-commercial-server-8.0.17-1.1.el7.x86_64.rpm to be installed Examining mysql-commercial-client-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-client-8.0.17-1.1.el7.x86_64 Marking mysql-commercial-client-8.0.17-1.1.el7.x86_64.rpm to be installed Examining mysql-commercial-libs-8.0.17-1.1.el7.x86_64.rpm: mysql-commercial-libs-8.0.1

centos를 주력으로 사용하다보니.. sqlite3의 데이터 crud 및 테이블 구조 변경등을 GUI를 통해 쉽게 변경할 수 있는 툴을 설명합니다. https://sqlitestudio.pl/index.rvt  에서 Lastest stable release (3.2.1): Distribution Platform Size Version Link Windows (portable) 32-bit 27.5MB 3.2.1 SQLiteStudio-3.2.1.zip Windows (installer) 32-bit 33.3MB 3.2.1 InstallSQLiteStudio-3.2.1.exe Linux (portable) 64-bit 30.0MB 3.2.1 sqlitestudio-3.2.1.tar.xz Linux (installer) 64-bit 46.1MB 3.2.1 InstallSQLiteStudio-3.2.1 MacOSX (portable) 64-bit (ix86_64) 30.9MB 3.2.1 SQLiteStudio-3.2.1.dmg MacOSX (installer) 64-bit (ix86_64) 25.5MB 3.2.1 InstallSQLiteStudio-3.2.1.dmg Sources (zip) Independent 9.8MB 3.2.1 sqlitestudio-3.2.1.zip Sources (tar.gz) Independent 9.0MB 3.2.1 sqlitestudio-3.2.1.tar.gz 1. Linux 64-bit portable판을 다운로드 합니다. 2. 적당한 위치에 압축 파일을 해제 합니다.  tar -zvf  sqlitestudio-3.2.1.tar.xz 3. 압축 해제된 폴더로 이동해서  cd SQLiteStudio 4. 실행파일을 실행합니다.  [root@superset SQLiteStudio]# ./sqlitestudio Qt: Session management error: None of the