mysql root recover
Step # 1 : Stop mysql service # /etc/init.d/mysqld stop Output: Stopping MySQL database server: mysqld./ Step # 2: Start to MySQL server w/o password: […]
iptables 192.168.0.10 만 ftp 접속 허용하기
[ 예: 192.168.0.10 만 ftp 접속 허용하기 ] 설정 전 iptables 에 21번 port 가 open 되어있으면 안됩니다. 방법 1) 명령어 # iptables -A INPUT […]
con_cursor cursor for SELECT ~
DB 데이타 일관 처리 프로세서 STRING_SPLIT 문장을 구분으로 잘라 List 로 보여주기. (2016 버전 부터 적용가능)
vi /etc/sysconfig/iptables
[root@localhost ddd]# vi /etc/sysconfig/iptables # Generated by iptables-save v1.3.5 on Sun Jul 29 05:39:42 2012 *nat : PREROUTING ACCEPT [3465:769364] : POSTROUTING ACCEPT [194:11943] : […]
sudo iptables -L 세팅없는 경우
root@ubuntu:~# sudo iptables -L Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy […]
ip check
ifconfig ifconfig eth0
DB connect
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 |
class DBData { static string connectionString = "server= localhost;uid=user;pwd=pass;database=SSC"; public static string Select(int Sending_SSC) { string ADW = null; //SQL 연결설정 //Call stored procedure with parameter and return value SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "GetCachingADW"; SqlParameter paramSending_SSC = cmd.Parameters.Add("@Sending_SSC",SqlDbType.SmallInt); paramSending_SSC.Direction = ParameterDirection.Input; paramSending_SSC.Value = Sending_SSC; SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { ADW = reader["ADW"].ToString(); } reader.Close(); // <- too easy to forget reader.Dispose(); // <- too easy to forget conn.Close(); // <- too easy to forget return ADW; } catch (Exception ex) { //클라이언트에게 예외를 던진다. //throw ex; string Err = ex.ToString(); return ""; } } |
SMTP Error 500
SMTP Error 500 : The last command sent by your server was not recognized as a valid SMTP or ESMTP command, or is not formatted […]
iptables Basic Commands
1 2 3 |
sudo iptables -L |
1 2 3 4 |
sudo iptables -A INPUT -p tcp --dport ssh -j ACCEPT sudo iptables -A INPUT -p tcp --dport 80 -j ACCEPT |