크롬에서 글자 깨지는 경우 / Text broken on Chrome
chrome 앱 스토어에서 Set Character Encoding 찾아서 설치 후 세팅 Set Character Encoding 설치 UTF-8 로세팅
[해결중] 오디날(ordinal) 8452을(를) DLL mfc90u.dll에서 찾을 수 없습니다.
알약삭제 시 에러 The ordinal 8452 could not be located in the dynamic link library mfc90u.dll. 다운로드 후 설치 : https://www.microsoft.com/en-us/download/details.aspx?id=10015
win10 파일 공유 문제 (SMB)
|
1 2 3 4 5 6 |
안전하지 않기 때문에 파일 공유에 연결할 수 없습니다. 이 공유에는 안전하지 않아 시스템 공격에 노출될 수 있는데 더 이상 사용되지 않는 SMB1 프로토콜이 필요합니다. 시스템에 SMB2 이상이 필요합니다. 이 문제를 해결하는 방법에 대한 자세한 내용은 https://go.microsoft.com/fwlink/?linid=852747을 참조하십시오. |
SMB1 활성화 제어판 – 프로그램 – 프로그램 및 기능 – Windows 기능 사용/사용안함 진입 후 SMB1을 체크하여 SMB1을 설치 및 활성화 재부팅 후 […]
Let’s Encrypt Windows (win7, win2012) SSL 설치
win7 에서도 netframework 4.6.01 이상이면 잘 설치 됩니다. 새버전은 wacs.exe 입니다.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
C:\inetpub\letsencrypt> wacs.exe [INFO] A simple Windows ACMEv2 client (WACS) [INFO] Software version 2.1.0.539 (RELEASE, UNPLUGGABLE) [INFO] IIS version 8.5 [INFO] Running with administrator credentials [INFO] Scheduled task looks healthy [INFO] Please report issues at https://github.com/PKISharp/win-acme N: Create new certificate (simple for IIS) M: Create new certificate (full options) L: List scheduled renewals R: Renew scheduled S: Renew specific A: Renew *all* O: More options... Q: Quit Please choose from the menu: r [INFO] Renewal for [IISBinding] gpan.webtest.kr is due after 03/15/20 20 09:00:37 [INFO] Renewal for [IISBinding] www.webtest.kr is due after 03/16/2020 09: 00:10 N: Create new certificate (simple for IIS) M: Create new certificate (full options) L: List scheduled renewals R: Renew scheduled S: Renew specific A: Renew *all* O: More options... Q: Quit Please choose from the menu: q |
1.다운로드 2.압축풀기 3.0 netframework4.6.01 이상 필요 참조 : https://auctionpro.co.kr/?p=5648 3.도스에서 실행 LetsEncrypt.exe […]
downloading .NET Framework 4.7.2
download : https://www.microsoft.com/net/download/thank-you/net472
ubuntu 18.04 LTS 에 Let’s Encrypt SSL 설치하기
Ubuntu 18.04 에서 Let’s Encrypt SSL Cert 설치 방법이 달라졌다. 1. Install Let’s Encrypt client (Certbot)
|
1 2 3 4 5 |
sudo add-apt-repository ppa:certbot/certbot sudo apt update sudo apt install python-certbot-apache |
2. Get an SSL Certificate
|
1 2 3 |
sudo certbot --apache -d test.com -d www.test.com |
결과
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
Please choose whether or not to redirect HTTP traffic to HTTPS, removing HTTP access. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1: No redirect - Make no further changes to the webserver configuration. 2: Redirect - Make all requests redirect to secure HTTPS access. Choose this for new sites, or if you're confident your site works on HTTPS. You can undo this change by editing your web server's configuration. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Select the appropriate number [1-2] then [enter] (press 'c' to cancel): 1:수정없이 2:자동수정되게 (아래와 같은 문제 발생됨) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Your existing certificate has been successfully renewed, and the new certificate has been installed. The new certificate covers the following domains: https://aaa.auctionpro.co.kr You should test your configuration at: https://www.ssllabs.com/ssltest/analyze.html?d=aaa.auctionpro.co.kr - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - |
XMRing CPU miner
As there is no outward indication that the program is running, here is a list of symptoms that a user can use to determine if […]
javascript 특수문자 체크
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
function CheckID(str) { var reg2 = /[a-z]/g; var reg3 = /\d/; return (reg2.test(str) && reg3.test(str) ); //var reg1 = /^[a-z0-9]{6,12}$/; //영문 또는 숫자 4-8자리인지 //var reg2 = /[a-z]/g; //문자중에 영문이 있는지 //var reg3 = /[0-9]/g; //문자중에 숫자가 있는지 //var reg4= /[!@#$]/g; //문자중에 특수문자가 있는지 //return (reg1.test(str) && reg2.test(str) && reg3.test(str) ); } |
|
1 2 3 4 5 6 7 8 9 10 11 |
if(!CheckID(frm.password.value)) { //alert("비밀번호는 영문소문자,특수문자(@#!$)와 숫자를 조합하여 생성해 주세요"); alert("비밀번호는 영문소문자와 숫자를 조합하여 생성해 주세요"); frm.password.value = ""; frm.passwordconf.value = ""; frm.password.focus(); return; } |
JQuery for Element loop
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
<style type="text/css"> div.container {text-align: center; padding-top: 5px;} h2 {background-color: #7ab800; color:white; text-align: center;} table {border: 0px: padding: 0px; border-collapse: collapse; margin:10px;} td {text-align: center; font-size:9pt; border: 1px solid #0075b0; width:20px } td.legend {font-size:10pt; text-align:left; border:0px; padding-right:6px;width:310px} td.outside, td.wing {border: none; } td.wing {background-color: #DCDCDC; width:75px } td.exitLeft {text-align:right;font-weight:bold;} td.exitRight {text-align:left;font-weight:bold;} td.occupied {background-image: url("images/Unavailable.jpg");background-repeat: no-repeat;cursor: not-allowed;} td.aisle {text-align: center; font-size:9pt; border:0x solid #0075b0; width:20px } td.aisleUpper {font-weight:bold; border-top:none; border-bottom: none;} td.aisleUpper {background-color: #333333;border: 0px solid #0075b0; color: white;} td.noseat {border:none; border: 0px solid #0075b0; width:20px; cursor: not-allowed;} td.availableHandicap {background-image: url("images/Handicapped.jpg");background-repeat: no-repeat} td.availableSeat {background-image: url("images/Available.jpg");background-repeat: no-repeat;cursor:pointer;} td.availableSeat.active {background-image: url("images/Selected.jpg");background-repeat: no-repeat;cursor:pointer;} td.blockedSeat {background-image: url("images/Blocked.jpg");background-repeat: no-repeat;cursor: not-allowed;} td.selectedSeat {background-image: url("images/Selected.jpg");background-repeat: no-repeat;cursor:pointer;} td.fontBold {font-weight:bold;} td.fontDarkGrey {color:#A9A9A9;} </style> <script src="http://code.jquery.com/jquery-1.12.4.min.js"></script> <script> $(document).ready(function(){ $(".availableSeat").click(function(){ var id = $(this).attr("id"); $("#SeatNum").val(id); $(".availableSeat.active").each(function(){ $(this).removeClass("active"); }); $(this).toggleClass("active"); }); }); </script> |
msslq 프로시저) 오래된 데이타 자동 삭제
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
-- ============================================= -- Author: Author -- Create date: 2018-03-28 -- Description: 오래된 데이타 자동 삭제 -- ============================================= CREATE PROCEDURE [dbo].[ClearDataSchedule] -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Declare @OldDate DateTime Declare @sOldDate varchar(10) Set @OldDate=(DATEADD(mm,-5,GETDATE())) -- 5달 이전꺼 삭제 Set @sOldDate = CONVERT(CHAR(10),@OldDate, 23) -- Insert statements for procedure here delete FROM [MYDB].[dbo].[MYTABLE1] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE2] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE3] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE4] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE5] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE6] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE7] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE8] where [Regi_Date]<@sOldDate delete FROM [MYDB].[dbo].[MYTABLE9] where [Regi_Date]<@sOldDate End |
Ripmime simscan 설치 /spamassassin 구동시 필요 filtering
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 |
* Ripmime 설치 -- 수동 설치 -- [root@localhost]#cd /usr/local/src [root@localhost]# wget https://dl.fedoraproject.org/pub/epel/6/x86_64/Packages/r/ripmime-1.4.0.9-2.el6.x86_64.rpm [root@localhost]# rpm -ivh ripmime-1.4.0.9-2.el6.x86_64.rpm [root@localhost]# cd /usr/src/redhat/SPECS [root@localhost]# rpmbuild -ba ripmime.spec [root@localhost]# cd /usr/src/redhat/RPMS/i386 [root@localhost]# rpm -Uvh ripmime* [간단 설치 비고] Download the latest epel-release rpm from https://dl.fedoraproject.org/pub/epel/6/x86_64/Packages/r/ripmime-1.4.0.9-2.el6.x86_64.rpm Install epel-release rpm: # rpm -Uvh epel-release*rpm Install ripmime rpm package: -- 자동 설치 * 추천 -- [root@ns1 src]# yum install ripmime Loaded plugins: fastestmirror, security Setting up Install Process Determining fastest mirrors epel/metalink | 6.2 kB 00:00 Could not retrieve mirrorlist http://rpms.remirepo.net/enterprise/6/remi/mirror error was 14: PYCURL ERROR 7 - "Failed to connect to 2001:bc8:33a1:100::1: Network is unreachable" * base: data.aonenetworks.kr * epel: mirror.premi.st * extras: data.aonenetworks.kr * remi: mirrors.thzhost.com * remi-safe: ftp.riken.jp * rpmforge: ftp.riken.jp * updates: data.aonenetworks.kr base | 3.7 kB 00:00 epel | 3.2 kB 00:00 epel/primary | 3.2 MB 00:00 epel 12522/12522 epel-httpd24 | 2.9 kB 00:00 extras | 3.4 kB 00:00 remi | 2.9 kB 00:00 remi/primary_db | 2.2 MB 00:05 remi-safe | 2.9 kB 00:00 remi-safe/primary_db | 1.0 MB 00:00 rpmforge | 1.9 kB 00:00 updates | 3.4 kB 00:00 updates/primary_db | 1.2 MB 00:09 Resolving Dependencies --> Running transaction check ---> Package ripmime.x86_64 0:1.4.0.9-2.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: ripmime x86_64 1.4.0.9-2.el6 epel 83 k Transaction Summary ================================================================================ Install 1 Package(s) Total download size: 83 k Installed size: 201 k Is this ok [y/N]: y Downloading Packages: ripmime-1.4.0.9-2.el6.x86_64.rpm | 83 kB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : ripmime-1.4.0.9-2.el6.x86_64 1/1 Verifying : ripmime-1.4.0.9-2.el6.x86_64 1/1 Installed: ripmime.x86_64 0:1.4.0.9-2.el6 Complete! ------------------------------------------------------------------------------------------------------ * simscan 설치 [root@localhost]#cd /usr/local/src [root@localhost]#wget http://downloads.sourceforge.net/project/simscan/simscan/simscan-1.4.0/simscan-1.4.0.tar.gz [root@localhost]#wget https://notes.sagredo.eu/files/qmail/patches/simscan-1.4.0.patch [root@localhost]tar xvfz simscan-1.4.0.tar.gz [root@localhost]cd simscan-1.4.0 [root@localhost]patch -p1 < ../simscan-1.4.0.patch [root@localhost]useradd -r -g clamav -s /bin/false -c "Simscan - a qmail-queue substitute" simscan ./configure --prefix=/usr --sysconfdir=/etc --mandir=/usr/share/man --enable-user=simscan --enable-clamav=y --enable-attach=y --enable-dropmsg=y --enable-per-domain=y --enable-spam=y --enable-spamc-user=y --enable-spamc=/usr/bin/spamc --enable-spam-hits=30.0 --enable-qmaildir=/var/qmail --enable-workdir=/var/qmail/simscan --enable-controldir=/var/qmail/control --enable-quarantinedir=/var/qmail/quarantine --enable-qmail-queue=/var/qmail/bin/qmail-queue --enable-ripmime=/usr/bin/ripmime --enable-received=y --enable-spamassassin-path=/usr/bin/spamassassin --enable-clamavdb-path=/var/clamav --enable-clamdscan=/usr/bin/clamdscan --enable-sigtool-path=/usr/bin/sigtool --enable-spam-passthru=y [root@localhost]# make [root@localhost]# make install-strip [root@localhost]# mkdir /var/qmail/quarantine [root@localhost]# chown simscan:clamav /var/qmail/quarantine/ [root@localhost]# chmod 770 /var/qmail/quarantine/ [root@localhost]# cat /var/qmail/control/simcontrol :clam=yes,spam=yes,attach=.scr:.bat:.com:.pif:.exe:.mp3:.avi:.mpeg:.wmv [root@localhost]# /var/qmail/bin/simscanmk -g simscan versions cdb file built. /var/qmail/control/simversions.cdb [root@localhost]# /var/qmail/bin/simscanmk simscan cdb file built. /var/qmail/control/simcon |
Dynamic Web Project option missing in Eclipse
Go to Eclipse->Help menu->Install new software choose the Web, XML, Java EE plugin and install it.
Windows 7 사용 중 대화형 서비스 감지 메시지 창
Windows 7 사용 중 대화형 서비스 감지 메시지 창이 나타나는 문제로 문의를 주셨습니다. 문의주신 내용의 경우, 대화형 서비스 감지 메시지 창은 특정 프로그램 및 장치 […]
mysql Error -> mysql_upgrade
Error Saving Account Error creating account vpopmail@%: Column countof mysql.user is wrong, Expected 42… Please use myslq_upgrade to fix this error. mysql_upgrade -u root -p […]
아이패드 9인치 데스크탑에서 충전하기
맥북, 미니 에서 충전이 되는데 win 노트북/데스크 탑에서 충전이 안되는 경우가 대부분 특히 용량이 큰 아이패드인 경우 대부분 ‘충전 중이 아님’ 으로 나옵니다. 이럴때 USB […]
최신 HP 에 win10 / win7 설치 방법 Bios 설정
최신 HP bios 어렵게 되어 있네. 1.컴퓨터 전원 버튼을 누르고, F10번 키를 2초 간격으로 눌러 [BIOS 설정]으로 진입 합니다. 2.[System Configuration]메뉴를 선택합니다. 3.[Boot Options]항목을 선택합니다. […]
FileZilla 실행시 오류 해결
|
1 2 3 4 5 6 |
Connection to server closed. Connecting to server... Error, could not connect to server Trying to reconnect in 5 seconds |
Start FileZilla Server 실행 하면 됩니다.
저장 프로시저 기준 날짜 세팅
|
1 2 3 4 5 6 7 8 9 10 11 12 |
Declare @OldDate DateTime Declare @sOldDate varchar(10) Set @OldDate=(DATEADD(mm,-12,GETDATE())) --12달 전꺼 삭제 set @sOldDate = CONVERT(CHAR(10),@OldDate, 23) Select @sOldDate as DT -- 결과 2017-03-28 |
visual studio webservice 초기화 오류
HTTP 오류 403.14 – Forbidden 웹 서버가 이 디렉터리의 내용을 표시하지 못하도록 구성되었습니다. 가능성이 높은 원인: 요청된 URL에 대해 기본 문서가 구성되지 않았으며 서버에서 디렉터리 […]
이전 버전의 Excel에서 마지막으로 저장 된 통합 문서를 열 때 외부 연결을 계산할 수 있습니다.
https://support.microsoft.com/ko-kr/help/925893/external-links-may-be-calculated-when-you-open-a-workbook-that-was-las