앨리스래빗팀 기술블로그

전체 글 515

[ DB2 ] AS400 드라이버 Drop column 권한 설정

CALL QSYS2.QCMDEXC('ADDRPYLE SEQNBR(1500) MSGID(CPA32B2) RPY(''I'')'); CALL QSYS2.QCMDEXC('CHGJOB INQMSGRPY(*SYSRPYL)'); https://stackoverflow.com/questions/4504548/db2-400-drop-column DB2 400 drop column I want to drop a column called id which is an auto incrementing PK. The SQL: alter table "CO88GT"."XGLCTL" drop column id cascade; And I get: Error: [SQL0952] Processing of the SQL statement e...

DB/DB2 HEON.D 2023.09.15

[ AWS ] VPC 환경에서 EC2 인스턴스 생성

The EC2 instances failed to communicate with AWS Elastic Beanstalk, either because of configuration problems with the VPC or a failed EC2 instance. Check your VPC configuration and try launching the environment again. VPC 라우팅 테이블에 인터넷 게이트웨이를 연결해주지 않으면 Beanstalk 에서 EC2 생성 시 실패

BE/AWS HEON.D 2023.09.14

[ OpenCV ] sharp 플러그인 EXIF 정보 유실된 케이스

{ failOnError: false } 속성을 추가하면 됨 { failOnError: false } sharp(imageBuffer, { failOnError: false }) .rotate() .resize({ width: dimension, height: dimension, fit: sharp.fit.cover, position: sharp.strategy.entropy, }) .jpeg({ quality: 90, mozjpeg: true }) .toBuffer() https://github.com/lovell/sharp/issues/2780 VipsJpeg: Invalid SOS parameters for sequential JPEG / with sharp(imageBuffer, originalF..

Team/난감했던 이슈들 HEON.D 2023.09.08

[ AWS ] RDS parameter utf8mb4

character_set_client : utf8mb4 character_set_connection : utf8mb4 character_set_database : utf8mb4 character_set_results : utf8mb4 character_set_server : utf8mb4 collation_connection : utf8mb4_unicode_ci collation_server : utf8mb4_unicode_ci https://evst.tistory.com/22 AWS RDS(Mysql)에서 emoji 관련 설정하기 기본으로 설정된 utf8 charset에서는 4바이트로 표현 가능한 Emoji를 저장할 수 없다. 그래서 데이터베이스의 Charset을 utf8mb4로 변경해야 하는데, 1...

BE/AWS HEON.D 2023.09.06

[ ANGULAR ] Current URL

import { Router } from '@angular/router'; constructor(private router: Router) { } ngOnInit() { const currentUrl = this.router.url; console.log('Current URL:', currentUrl); }

FE/Angular HEON.D 2023.09.04

[ AWS ] [Warning] Aborted connection xxx to db: '<database name>' user: '<user name>' host: '<host IP>' (Got an error reading communication packets)

[Warning] Aborted connection xxx to db: '' user: '' host: '' (Got an error reading communication packets) https://repost.aws/knowledge-center/rds-mysql-communication-packet-error Resolve the communication packets error in Amazon RDS for MySQL I received a "Got an error reading communication packets" error. I want to resolve this error in an Amazon Relational Database Service (Amazon RDS) for MyS..

Team/난감했던 이슈들 HEON.D 2023.08.30

[ GIT ] Git branch list

로컬 git branch 리모트 git branch -r 전체 git branch -a

Team/GIT HEON.D 2023.08.30

[Flutter] package 이름 변경 android 편

위치 정리 1. AndroidManifest.xml 2. build.gradel defaultConfig { applicationId "your.package.name" minSdkVersion 16 targetSdkVersion 27 versionCode 1 versionName "1.0" testInstrumentationRunner "android.support.test.runner.AndroidJUnitRunner" } 3.MainActivity.kt / java package your.package.name; import android.os.Bundle; import io.flutter.app.FlutterActivity; import io.flutter.plugins.GeneratedPlugi..

카테고리 없음 브레인야또 2023.08.29

[Android] 안드로이드 서명 der to jdk

### key 생성 sudo keytool -importcert -file [다운로드 der 파일] -keystore [만들 이름] ### key 확인 keytool -keystore [키 경로] -list -v ### 안드로이드 키 등록 기준 jdk = MD5 der = SHA-1

App/Android 브레인야또 2023.08.29