SE �� ̳��::��ȭ, KVM, HYPER-V, Virtualization, Ŭ��, CLOUD, LINUX, WINDOW,Security, DDOS, Network > ȣ�� TIP > ��Ÿ (Perl ��)

��

�ְ�� — Thu, 22 Aug 2019 14:43:48 +0900

https://whos.amung.us/

Sorting IP Addresses in MySQL

�ְ�� — Wed, 15 Nov 2017 15:48:06 +0900

��ó : http://matthewvince.com/2011/08/04/sorting-ip-addresses-in-mysql/

So you want to store IPv4 addresses in MySQL?

That��s great! So you reach for the obvious: varchar(15). This works pretty well for most web use cases (ex: event logging). The problem comes if you want to accurately sort the IP addresses. Let��s say we have the following records:

| ip_address   |
+--------------+
| 192.168.1.2  |
| 192.168.1.1  |
| 192.168.1.13 |
| 192.168.1.3  |
| 192.168.1.22 |

And we run the following statement and notice what happens:

SELECT * FROM ip_addresses ORDER BY ip_address;

| ip_address   |
+--------------+
| 192.168.1.1  |
| 192.168.1.13 |
| 192.168.1.2  |
| 192.168.1.22 |
| 192.168.1.3  |

That��s not really what we wanted, but why? MySQL is doing a standard string compare to order the results. We need to sort on the numeric representation, but how? We could write some complicated conversion function, but there��s something much more helpful found in the MySQL manual: INET_ATON.

Given the dotted-quad representation of an IPv4 network address as a string, returns an integer that represents the numeric value of the address in network byte order (big endian).

This is exactly what we need. Using this function in an ORDER BY clause will sort our IPv4 in perfect numerical order:

SELECT * FROM ip_addresses ORDER BY INET_ATON(ip_address);

| ip_address   |
+--------------+
| 192.168.1.1  |
| 192.168.1.2  |
| 192.168.1.3  |
| 192.168.1.13 |
| 192.168.1.22 |

I needed this for a particular Rails app I was developing. I hope it comes in handy for you as well.

�� ¥�� ؼ� �� ϴ� vbs

�ְ�� — Wed, 28 Sep 2016 17:32:57 +0900

��Ҷ� Ȱ��ϸ� ��....

http://bomdol.tistory.com/109

express �� ͸� ��

�ְ�� — Thu, 18 Aug 2016 17:30:26 +0900

https://github.com/RafalWilinski/express-status-monitor

Mongodb GUI TOOL

�ְ�� — Tue, 10 May 2016 11:44:23 +0900

https://robomongo.org/
http://3t.io/mongochef/

[MYSQL] Named timezone ��

�ְ�� — Tue, 20 Oct 2015 11:29:32 +0900

:: Ȯ��

MariaDB [(none)]> select count(*) from mysql.time_zone;

+----------+

| count(*) |

+----------+

| 0 |

+----------+

1 row in set (0.00 sec)

:: ��

mysql �� ϴ� utility_query�� mysql_tzinfo_to_sql�� ̿��ؼ� ��Ÿ ��

# mysql_tzinfo_to_sql /usr/share/zoneinfo |mysql -uroot -pghtmxldrltnfwldnjs23 mysql

MariaDB [(none)]> select count(*) from mysql.time_zone;

+----------+

| count(*) |

+----------+

| 1787 |

+----------+

1 row in set (0.00 sec)

MariaDB [(none)]> select b.name, a.time_zone_id from mysql.time_zone a, mysql.time_zone_name b where a.time_zone_id = b.time_zone_id and b.name like '%Seoul';

+------------------+--------------+

| name | time_zone_id |

+------------------+--------------+

| Asia/Seoul | 303 |

| posix/Asia/Seoul | 899 |

| right/Asia/Seoul | 1495 |

+------------------+--------------+

3 rows in set (0.00 sec)

MariaDB [nova]> select @system_time_zone;

+-------------------+

| @system_time_zone |

+-------------------+

| NULL |

+-------------------+

1 row in set (0.02 sec)

MariaDB [nova]> select @@global.time_zone, @@session.time_zone;

+--------------------+---------------------+

| @@global.time_zone | @@session.time_zone |

+--------------------+---------------------+

| SYSTEM | SYSTEM |

+--------------------+---------------------+

1 row in set (0.03 sec)

MariaDB [(none)]> set time_zone = 'Asia/Seoul';

Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]> select @@time_zone;

+-------------+

| @@time_zone |

+-------------+

| Asia/Seoul |

+-------------+

1 row in set (0.00 sec)

MariaDB [(none)]> select @@global.time_zone, @@session.time_zone;

+--------------------+---------------------+

| @@global.time_zone | @@session.time_zone |

+--------------------+---------------------+

| SYSTEM | Asia/Seoul |

+--------------------+---------------------+

1 row in set (0.00 sec)

MariaDB [(none)]> select @@system_time_zone;

+--------------------+

| @@system_time_zone |

+--------------------+

| KST |

+--------------------+

1 row in set (0.00 sec)

Character Encoding (ascii chart)

�ְ�� — Mon, 27 Apr 2015 11:14:46 +0900

��ó : https://grox.net/utils/encoding.html

character	encoding	decimal
NULL	%0	0
	%1	1
	%2	2
	%3	3
	%4	4
	%5	5
	%6	6
	%7	7
	%8	8
TAB	%9	9
CR	%A	10
	%B	11
	%C	12
LF	%D	13
	%E	14
	%F	15
	%10	16
	%11	17
	%12	18
	%13	19
	%14	20
	%15	21
	%16	22
	%17	23
	%18	24
	%19	25
	%1A	26
	%1B	27
	%1C	28
	%1D	29
	%1E	30
	%1F	31
SPACE	%20	32
!	%21	33
"	%22	34
#	%23	35
$	%24	36
%	%25	37
&	%26	38
'	%27	39
(	%28	40
)	%29	41
*	%2A	42
+	%2B	43
,	%2C	44
-	%2D	45
.	%2E	46
/	%2F	47
0	%30	48
1	%31	49
2	%32	50
3	%33	51
4	%34	52
5	%35	53
6	%36	54
7	%37	55
8	%38	56
9	%39	57
:	%3A	58
;	%3B	59
<	%3C	60
=	%3D	61
>	%3E	62
?	%3F	63
@	%40	64
A	%41	65
B	%42	66
C	%43	67
D	%44	68
E	%45	69
F	%46	70
G	%47	71
H	%48	72
I	%49	73
J	%4A	74
K	%4B	75
L	%4C	76
M	%4D	77
N	%4E	78
O	%4F	79
P	%50	80
Q	%51	81
R	%52	82
S	%53	83
T	%54	84
U	%55	85
V	%56	86
W	%57	87
X	%58	88
Y	%59	89
Z	%5A	90
[	%5B	91
\	%5C	92
]	%5D	93
^	%5E	94
_	%5F	95
`	%60	96
a	%61	97
b	%62	98
c	%63	99
d	%64	100
e	%65	101
f	%66	102
g	%67	103
h	%68	104
i	%69	105
j	%6A	106
k	%6B	107
l	%6C	108
m	%6D	109
n	%6E	110
o	%6F	111
p	%70	112
q	%71	113
r	%72	114
s	%73	115
t	%74	116
u	%75	117
v	%76	118
w	%77	119
x	%78	120
y	%79	121
z	%7A	122
{	%7B	123
\|	%7C	124
}	%7D	125
~	%7E	126
&127;	%7F	127
��	%80	128
	%81	129
‚	%82	130
ƒ	%83	131
„	%84	132
��	%85	133
��	%86	134
��	%87	135
ˆ	%88	136
��	%89	137
Š	%8A	138
‹	%8B	139
��	%8C	140
	%8D	141
Ž	%8E	142
	%8F	143
	%90	144
��	%91	145
��	%92	146
��	%93	147
��	%94	148
•	%95	149
–	%96	150
—	%97	151
˜	%98	152
��	%99	153
š	%9A	154
›	%9B	155
��	%9C	156
	%9D	157
ž	%9E	158
Ÿ	%9F	159
	%A0	160
��	%A1	161
��	%A2	162
��	%A3	163
��	%A4	164
��	%A5	165
\|	%A6	166
��	%A7	167
��	%A8	168
��	%A9	169
��	%AA	170
��	%AB	171
��	%AC	172
	%AD	173
��	%AE	174
¯	%AF	175
��	%B0	176
��	%B1	177
��	%B2	178
��	%B3	179
��	%B4	180
��	%B5	181
��	%B6	182
��	%B7	183
��	%B8	184
��	%B9	185
��	%BA	186
��	%BB	187
��	%BC	188
��	%BD	189
��	%BE	190
��	%BF	191
A	%C0	192
A	%C1	193
A	%C2	194
A	%C3	195
A	%C4	196
A	%C5	197
��	%C6	198
C	%C7	199
E	%C8	200
E	%C9	201
E	%CA	202
E	%CB	203
I	%CC	204
I	%CD	205
I	%CE	206
I	%CF	207
��	%D0	208
N	%D1	209
O	%D2	210
O	%D3	211
O	%D4	212
O	%D5	213
O	%D6	214
��	%D7	215
��	%D8	216
U	%D9	217
U	%DA	218
U	%DB	219
U	%DC	220
Y	%DD	221
��	%DE	222
��	%DF	223
a	%E0	224
a	%E1	225
a	%E2	226
a	%E3	227
a	%E4	228
a	%E5	229
��	%E6	230
c	%E7	231
e	%E8	232
e	%E9	233
e	%EA	234
e	%EB	235
i	%EC	236
i	%ED	237
i	%EE	238
i	%EF	239
��	%F0	240
n	%F1	241
o	%F2	242
o	%F3	243
o	%F4	244
o	%F5	245
o	%F6	246
��	%F7	247
��	%F8	248
u	%F9	249
u	%FA	250
u	%FB	251
u	%FC	252
y	%FD	253
��	%FE	254
y	%FF	255

REST API Client �� ġ

�ְ�� — Fri, 17 Apr 2015 15:42:51 +0900

REST API Client �� ġ

Chrome --> ��۾۽�� --> REST HTTP API �˻� --> �߰�

[POWERSHELL] �ʺ��ڸ� �� POWERSHELL ��̵� - PDF

�ְ�� — Fri, 27 Feb 2015 02:00:05 +0900

POWERSHELL FOR NEWBIES Getting started with PowerShell 4.0

Jeffery Hicks

[POWERSHELL] HOST�� GUEST�� Ϻ��

�ְ�� — Fri, 27 Feb 2015 01:50:03 +0900

http://www.petri.com/copy-files-hyper-v-host-guest.htm

[PowerShell] Find Orphaned Hyper-V VM Files

�ְ�� — Fri, 21 Nov 2014 08:54:21 +0900

http://www.altaro.com/hyper-v/free-script-find-orphaned-hyper-v-vm-files/?utm_content=buffer623ac&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

[MYSQL] substring_index (��й�� ڸ��)

�ְ�� — Thu, 02 Oct 2014 13:48:24 +0900

��й��ڸ� �� ڸ��

ex1) . ��й��ڸ� �� 3�� ڸ��

mysql> select substring_index('192.168.1.111','.',3);

+----------------------------------------+

| substring_index('192.168.1.111','.',3) |

+----------------------------------------+

| 192.168.1 |

+----------------------------------------+

1 row in set (0.01 sec)

ex2)

select substring_index(nic_ip,'.',3) as ip_class from TB_TEST where isused='0' group by ip_class order by INET_ATON(nic_ip);

+------------+

| ip_class |

+------------+

| 192.168.20 |

| 192.168.21 |

| 192.168.22 |

| 192.168.23 |

| 192.168.24 |

| 192.168.25 |

| 192.168.27 |

| 192.168.29 |

| 192.168.30 |

| 192.168.74 |

| 192.168.108 |

| 192.168.141 |

| 192.168.181 |

| 192.168.182 |

+------------+

14 rows in set (0.05 sec)

[PowerShell] Get-WmiObject -NameSpace "root\virtualization" -Class "MsVM_VirtualSwitch"

�ְ�� — Wed, 03 Sep 2014 14:53:43 +0900

PS C:\bin> (Get-WmiObject -class Win32_OperatingSystem).Caption

Microsoft Windows Server 2012 Standard

PS C:\bin> (Get-WmiObject -NameSpace "root\virtualization" -Class "MsVM_VirtualSwitch").elementname

Realtek PCIe GBE Family Controller #2 - Virtual Switch

PS C:\bin> (Get-WmiObject -class Win32_OperatingSystem).Caption

Microsoft Windows Server 2012 R2 Datacenter

PS C:\bin> (Get-WmiObject -NameSpace "root\virtualization" -Class "MsVM_VirtualSwitch").elementname

Get-WmiObject : �߸�� Ŭ��Դϴ�. "MsVM_VirtualSwitch"

��ġ ��:1 ��:2

+ (Get-WmiObject -NameSpace "root\virtualization" -Class "MsVM_VirtualSwitch").el ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidType: (:) [Get-WmiObject], ManagementException

+ FullyQualifiedErrorId : GetWMIManagementException,Microsoft.PowerShell.Commands.GetWmiObjectCommand

setTimeout

�ְ�� — Wed, 09 Jul 2014 18:18:32 +0900

http://koxo.com/lang/js/method/setTimeout.html

[MYSQL] ��ڿ� �ڸ�� left, substring, right

�ְ�� — Fri, 16 May 2014 10:41:36 +0900

mysql> select product_name from TB_SVC where ip='XXX.XXX.XXX.XXX';

+------------------------------------------+

| product_name |

+------------------------------------------+

| �׽�Ʈ�� Ϻл� �ε�߶�� (1 CORE ) |

+------------------------------------------+

1 row in set (0.00 sec)

1. ��ʿ�� ڿ� �ڸ��

left(�÷�� Ǵ� ��ڿ�, ��ʿ�� ߶� ��ڿ�� )

mysql> select left(product_name,5) from TB_SVC where ip='XXX.XXX.XXX.XXX';

+----------------------+

| left(product_name,5) |

+----------------------+

| �׽�Ʈ�� |

+----------------------+

1 row in set (0.00 sec)

2. �߰�� ڿ� �ڸ��

substring(�÷� �Ǵ� ��ڿ�, ��ġ, ��);

mysql> select substring(product_name,19,1) from TB_SVC where ip='XXX.XXX.XXX.XXX';

+------------------------------+

| substring(product_name,19,1) |

+------------------------------+

| 1 |

+------------------------------+

1 row in set (0.00 sec)

�� PHP �� ڿ� �ڸ�� Լ�� substr �̸�, ��ġ�� 0�� , substring�� 1��

3. ��ʿ�� ڿ� �ڸ��

right(�÷�� Ǵ� ��ڿ�, ��)

mysql> select right(product_name,9) from TB_SVC where ip='XXX.XXX.XXX.XXX';

+-----------------------+

| right(product_name,9) |

+-----------------------+

| (1 core ) |

+-----------------------+

1 row in set (0.00 sec)

[POWERSHELL] Disable-VMEventing

�ְ�� — Thu, 21 Nov 2013 09:25:19 +0900

get-vm : cmdlet�� Ϸ�Ǿ�� WMI �̺�Ʈ�� ߽��ϴ�. �� Ϸ�� Disable-VMEventing cmdlet��

�Ͽ� ��̺� ��ü�� ʵ�� ϰų� �� ǻ�Ϳ�� Ϻ� �� Ŭ��̾�Ʈ�� ʽÿ�.

��ġ ��:1 ��:1

+ get-vm

+ ~~~~~~

+ CategoryInfo : ResourceUnavailable: (:) [Get-VM], VirtualizationOperationFailedException

+ FullyQualifiedErrorId : OperationFailed,Microsoft.HyperV.PowerShell.Commands.GetVMCommand

[POWERSHELL] get-content , ��

�ְ�� — Tue, 17 Sep 2013 10:27:43 +0900

http://blog.naver.com/PostView.nhn?blogId=yyb7436&logNo=80115855419&redirect=Dlog&widgetTypeCall=true

http://blog.naver.com/PostView.nhn?blogId=yyb7436&logNo=80114105086

PowerShell String Comparison and List Filtering

�ְ�� — Tue, 17 Sep 2013 09:26:59 +0900

https://www.simple-talk.com/iwritefor/articlefiles/1304-PS_Strings_chart_1.htm

PDF ��÷��

[POWERSHELL] Hyper-V ��

�ְ�� — Wed, 28 Aug 2013 17:45:57 +0900

VM_Backup.ps1

## Create a backup of all the vm's

$dest = "D:\backup"

$VM_Service = get-wmiobject -namespace root\virtualization Msvm_VirtualSystemManagementService

$ListofVMs = get-wmiobject -namespace root\virtualization Msvm_ComputerSystem -filter "ElementName <> Name"

foreach ($VM in [array] $ListOfVMs)

{

$VMReturnState = $VM.EnabledState

$VMName = $VM.ElementName

if (($VM.EnabledState -eq 2) -or ($VM.EnabledState -eq 32768) -or ($VM.EnabledState -eq 32770))

{

$VM.RequestStateChange(32769)

echo "Saving the state of $VMName"

}

while (!($VM.EnabledState -eq 32769) -and !($VM.EnabledState -eq 3))

{

Start-Sleep(1)

$VM = get-wmiobject -namespace root\virtualization -Query "Select * From Msvm_ComputerSystem Where ElementName='$VMName'"

}

if ([IO.Directory]::Exists("$dest\TmpDir\$VMName"))

{

[IO.Directory]::Delete("$dest\TmpDir\$VMName", $True)

}

echo "Exporting the VM"

$status = $VM_Service.ExportVirtualSystem($VM.__PATH, $True, "$dest\TmpDir")

if ($status.ReturnValue -eq 4096)

{

$job = [Wmi]$status.Job

while (!($job.PercentComplete -eq 100) -and ($job.ErrorCode -eq 0))

{

Start-Sleep(5)

$job = [Wmi]$status.Job

echo $job.PercentComplete

}

## Store the files on in a temp directory before moving them to their location and then remove the old files.

if ([IO.Directory]::Exists("$dest\$VMName"))

{

[IO.Directory]::Move("$dest\$VMName", "$dest\$VMName-OldTmpDir")

[IO.Directory]::Move("$dest\TmpDir\$VMName", "$dest\$VMName")

[IO.Directory]::Delete("$dest\$VMName-OldTmpDir", $True)

}

else

{

[IO.Directory]::Move("$dest\TmpDir\$VMName", "$dest\$VMName")

}

echo "Done with $VMName"

$VM.RequestStateChange($VMReturnState)

}

[POWERSHELL] Connect-VM

�ְ�� — Wed, 28 Aug 2013 11:44:45 +0900

http://www.powershellmagazine.com/2012/10/11/connecting-to-hyper-v-virtual-machines-with-powershell/

#requires -Version 3.0 function Connect-VM { [CmdletBinding(DefaultParameterSetName='name')] param( [Parameter(ParameterSetName='name')] [Alias('cn')] [System.String[]]$ComputerName=$env:COMPUTERNAME, [Parameter(Position=0, Mandatory,ValueFromPipelineByPropertyName, ValueFromPipeline,ParameterSetName='name')] [Alias('VMName')] [System.String]$Name, [Parameter(Position=0, Mandatory,ValueFromPipelineByPropertyName, ValueFromPipeline,ParameterSetName='id')] [Alias('VMId','Guid')] [System.Guid]$Id, [Parameter(Position=0,Mandatory, ValueFromPipeline,ParameterSetName='inputObject')] [Microsoft.HyperV.PowerShell.VirtualMachine]$InputObject, [switch]$StartVM ) begin { Write-Verbose "Initializing InstanceCount, InstanceCount = 0" $InstanceCount=0 } process { try { foreach($computer in $ComputerName) { Write-Verbose "ParameterSetName is '$($PSCmdlet.ParameterSetName)'" if($PSCmdlet.ParameterSetName -eq 'name') { # Get the VM by Id if Name can convert to a guid if($Name -as [guid]) { Write-Verbose "Incoming value can cast to guid" $vm = Get-VM -Id $Name -ErrorAction SilentlyContinue } else { $vm = Get-VM -Name $Name -ErrorAction SilentlyContinue } } elseif($PSCmdlet.ParameterSetName -eq 'id') { $vm = Get-VM -Id $Id -ErrorAction SilentlyContinue } else { $vm = $InputObject } if($vm) { Write-Verbose "Executing 'vmconnect.exe $computer $($vm.Name) -G $($vm.Id) -C $InstanceCount'" vmconnect.exe $computer $vm.Name -G $vm.Id -C $InstanceCount } else { Write-Verbose "Cannot find vm: '$Name'" } if($StartVM -and $vm) { if($vm.State -eq 'off') { Write-Verbose "StartVM was specified and VM state is 'off'. Starting VM '$($vm.Name)'" Start-VM -VM $vm } else { Write-Verbose "Starting VM '$($vm.Name)'. Skipping, VM is not not in 'off' state." } } $InstanceCount+=1 Write-Verbose "InstanceCount = $InstanceCount" } } catch { Write-Error $_ } } }

SE �������� �̳����::����ȭ, KVM, HYPER-V, Virtualization, Ŭ����, CLOUD, LINUX, WINDOW,Security, DDOS, Network > ȣ���� TIP > ��Ÿ (Perl ��)

�������� ����

Sorting IP Addresses in MySQL

��ó : http://matthewvince.com/2011/08/04/sorting-ip-addresses-in-mysql/

So you want to store IPv4 addresses in MySQL?

������ ������ ��¥���� �����ؼ� ���� ������ �����ϴ� vbs

express ���� ����͸� ���

Mongodb GUI TOOL

[MYSQL] Named timezone ����

Character Encoding (ascii chart)

REST API Client �� ��ġ

[POWERSHELL] �ʺ��ڸ� ���� POWERSHELL ���̵� - PDF

[POWERSHELL] HOST�� GUEST���� ���Ϻ���

[PowerShell] Find Orphaned Hyper-V VM Files

[MYSQL] substring_index (���й��� �������� �����ڸ���)

[PowerShell] Get-WmiObject -NameSpace "root\virtualization" -Class "MsVM_VirtualSwitch"

setTimeout

[MYSQL] ���ڿ� �ڸ��� left, substring, right

[POWERSHELL] Disable-VMEventing

[POWERSHELL] get-content , ��������

PowerShell String Comparison and List Filtering

[POWERSHELL] Hyper-V ���

[POWERSHELL] Connect-VM

SE �� ̳��::��ȭ, KVM, HYPER-V, Virtualization, Ŭ��, CLOUD, LINUX, WINDOW,Security, DDOS, Network > ȣ�� TIP > ��Ÿ (Perl ��)

��

�� ¥�� ؼ� �� ϴ� vbs

express �� ͸� ��

[MYSQL] Named timezone ��

REST API Client �� ġ

[POWERSHELL] �ʺ��ڸ� �� POWERSHELL ��̵� - PDF

[POWERSHELL] HOST�� GUEST�� Ϻ��

[MYSQL] substring_index (��й�� ڸ��)

[MYSQL] ��ڿ� �ڸ�� left, substring, right

[POWERSHELL] get-content , ��

[POWERSHELL] Hyper-V ��