Mit

Mysql Aes_Decrypt 쿼리 select cast(AES_DECRYPT(unhex('암호텍스트'),'비밀번호') as char(100)) from log_member; ---------------------------------------------------------------------------------------------------- C# Decrypt String public static string Decrypt(string _decryptString, string _passkey) { RijndaelManaged Rdael = new RijndaelManaged(); Rdael.Mode = CipherMode.CBC; Rdael.Padding = PaddingMode.PKCS7..

Nginx .Net Core5 Mysql Connection String static private MySqlConnection EDC_conn; static private string EDC_GetConnectionString() { return "Server=서버IP ; Port=3306; Database=log_in; Uid = 아이디; Pwd=비밀번호; SslMode=Required;"; } static private string member_search(Member_CHK Items) { try { string EDC_connectionString = EDC_GetConnectionString(); using (EDC_conn = new MySqlConnection(EDC_connectionSt..

Warning: The unit file, source configuration file or drop-ins of Test_API.service changed on disk. Run 'systemctl daemon-reload' to reload units. => $ sudo systemctl daemon-reload daemon-reload 하고 다시 실행.

Ubuntu Unhandled exception. System.IO.IOException: Failed to bind to address http://127.0.0.1:5000: address already in use. 1. sudo netstat -tunip 2. port 5000 PID num 확인 3. sudo kill -9 27481 4. 서비스 재시작. ------------------ $ sudo netstat -tunlp Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 4 0 127.0.0.1:5000 0.0.0.0:* LIS..

warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] 환경: ubuntu 20.04 LTS/ Nginx8.0 / .net Core5 http api 서비스는 정상. https api는 warning 다만.. 서비스는 정상 info: Microsoft.Hosting.Lifetime[0] Now listening on: http://localhost:5000 info: Microsoft.Hosting.Lifetime[0] Application started. Press Ctrl+C to shut down. info: Microsoft.Hosting.Lifetime[0] Hosting environment: Production info: M..

Certbot 에서 인증오류가 계속.. 인증받을 도메인의 홈 디렉토리에 폴더를 생성해 줬음. /var/www/html 에서 $ mkdir .well-known cd .well-known $ mkdir acme-challenge cd .. 그리고 certbot을 돌리니 정상실행. $ certbot certonly --webroot -w . -d api.mistic.co.kr

Cause: When you add labels in stackLayout ,stackLayout will not make the subviews fit the size. Stacklayout에 배치된 Label Width는 AutoFit 되지 않네.. >> Stacklayout 쓰지 말자. --> Frame나 Grid 배치하자.. https://stackoverflow.com/questions/55788834/element-not-expanding-in-xamarin-forms

SQLite SubString(), Len() 오류 SubString() --> SubStr() Len() --> Length() Left(), Right() --> SubStr() SQLIte Query ==> Substr(Chked_ID, 2, Length(Chked_ID)-2)=@IDS2

CGRect Error Control.LeftView = new UIView(new CGRect(0,0,5,0)); -->> var myBox = new UIView(new CoreGraphics.CGRect(10, 15, 15, 1)); Control.AddSubview(myBox);

DataTable Select 구문 오류: 'B' 연산자 뒤에 피연산자가 없습니다. "log_mac = " + STR[2] ; 0) { int SelectedIndex = Result_Table.Rows.IndexOf(result[0]); SMS_Result_LBX.Items.RemoveAt(SelectedIndex); }