1 2 3 4 5 6 7 8 9 | aws elb create-load-balancer
--load-balancer-name ELB_NAME
--listener "Protocol=HTTP,
LoadBalancerPort=80,
InstanceProtocol=HTTP,
InstancePort=80"
--scheme internal
--subnets subnet-xxxx subnet-yyyy
--security-groups sg-123456
|
1 2 3 | aws elb add-tags
--load-balancer-names ELB_NAME
--tags "Key='keyA',Value='valueA'" "Key='keyB',Value='valueB'"
|
1 2 3 | aws elb register-instances-with-load-balancer
--load-balancer-name MY_ELB
--instances i-xxxxx
|
1 2 3 | aws elb deregister-instances-with-load-balancer
--load-balancer-name MY_ELB
--instances i-xxxxx
|
1 2 3 4 5 | aws iam upload-server-certificate
--server-certificate-name MY_CERT
--certificate-body file://c:\temp\public.pem
--private-key file://c:\temp\private.pem
--certificate-chain file://e:\temp\chain.pem
|
<Ec2ConfigurationSettings>
<Plugins>
<Plugin>
<Name>Ec2SetPassword</Name>
<State>Enabled</State>
</Plugin>
1 2 3 4 5 6 | $s3uri = "myBucket/mylogs/important.log" $expireSec = 120 $output = aws s3 presign $s3uri --expires-in $expireSec $objIE = new-object -ComObject InternetExplorer.Application $objIE.Navigate($output) $objIE.visible = $true |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | {
"Version": "2012-10-17",
"Id": "PolicyForPrincipal",
"Statement": [
{
"Sid": "AccountAllow",
"Effect": "Allow",
"Principal": {
"AWS": "arn:aws:iam::XXXXXX:root"
},
"Action": "s3:*",
"Resource": [
"arn:aws:s3:::myBucket",
"arn:aws:s3:::myBucket/*"
]
}
]
}
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | {
"Version": "2012-10-17",
"Id": "PolicyForIP",
"Statement": [
{
"Sid": "IPAllow",
"Effect": "Allow",
"Principal": "*",
"Action": "s3:*",
"Resource": "arn:aws:s3:::myBucket/*",
"Condition": {
"IpAddress": {
"aws:SourceIp": [
"10.10.10.10/32",
"168.0.0.10/32"
]
}
}
}
]
}
|
1 2 3 4 5 6 7 | aws ec2 run-instances --image-id ami-xxxxxxxxxx --network-interface "NetworkInterface='eni=xxxxxx',DeviceIndex=0" --key-name MY_KEY --instance-type "m4.xlarge" --disable-api-termination --iam-instance-profile "Arn=arn:aws-iso:iam::1234567890:instance-profile/myiamprofile" |
1 2 3 4 | aws ec2 create-image --instance-id i-xxxxxxxxxxxxxxxxxx --name MY_AMI_NAME_01 --description "My Description" |
aws ec2 create-tags --resources SOME_ID --tags "Key=MYKEY,Value='MYVALUE'..."
aws ec2 describe-images --owners "self"
aws ec2 describe-instances --filters "Name=owner-id,Values=XXXXXX"
aws ec2 describe-snapshots --owner-ids XXXXXXX
1 2 3 | aws ec2 modify-instance-attribute
--instance-id i-xxxxxxxxxxx
--no-disable-api-termination
|
1 2 | aws ec2 terminate-instances
--instance-id i-xxxxxxxxxxx
|
1 2 3 4 5 | aws ec2 create-volume --snapshot-id snap-xxxxxxxxxx --size 50 --availability-zone us-east-1a --volume-type gp2 |
aws s3 cp filename.log s3://bucketname
aws s3 cp \\path\directory\ s3://bucketname/prefix --recursive
aws s3 cp \\path\directory\ s3://bucketname/prefix/ --exclude '*' --include '*.log' --recursive
aws s3 cp s3://bucketA s3://bucketB --recursive
aws s3 sync \\localpath\ s3://bucketA/path/ --exclude '*' --include '*.log' --delete
aws s3 sync s3://bucketA/path/ \\localpath\test\ --exclude 'Special/*'
aws s3 cp filename.txt s3:/bucketA/path/
aws s3 cp filename.txt s3:/bucketA/path/ --acl public-read
aws s3 cp filename.txt s3:/bucketA/path/ --acl public-read-write
aws s3 cp filename.txt s3:/bucketA/path/ --acl bucket-owner-full-control
aws s3api put-bucket-policy --bucket myBucket --policy file://myPolicy.json
c:\pt857\pt\bea\OPatch\opatch.bat apply -oh c:\pt857\pt\bea -silent
c:\pt857\pt\bea\OPatch\opatch.bat lsinventory -oh c:\pt857\pt\bea
1 2 3 4 5 6 7 8 9 10 11 12 | call net stop "ORACLE ProcMGR v12.2.2.0.0_VS2015" call net stop "psDEMO-WebLogicAdmin" call net stop "psDEMO-PIA" aws s3 cp s3://my-repo-name/7zip/7z920.exe c:\temp aws s3 cp s3://my-repo-name/patches/p30386660_122130_Generic.zip c:\temp cd c:\temp call 7z920.exe /S /D="C:\Program Files (x86)\7-Zip" call "C:\Program Files (x86)\7-Zip\7z.exe" x C:\temp\p30386660_122130_Generic.zip call c:\pt857\pt\bea\OPatch\opatch.bat apply -oh c:\pt857\pt\bea -silent call "c:\Program Files (x86)\7-Zip\Uninstall.exe" /S cd c:\pt857\pt\bea\opatch call c:\pt857\pt\bea\opatch\opatch.bat lsinventory -oh c:\pt857\pt\bea |
<html> <head> </head> <body> <p>Hello World</p> </body> </html>
<html> <head> </head> <body> <?php print("Hello World"); phpinfo(); ?> </body> </html>
LoadModule ssl_module modules/mod_ssl.so
Listen 443
<VirtualHost *:443>
ServerName myserver
SSLEngine on
SSLCertificateFile "/etc/ssl/private/myserver.crt"
SSLCertificateKeyFile "/etc/ssl/private/myserver.key"
</VirtualHost>
LoadModule ssl_module modules/mod_ssl.so
Listen 443
<VirtualHost *:443>
ServerName myserver
SSLEngine on
SSLCertificateFile "/etc/ssl/private/myserver.crt"
SSLCertificateKeyFile "/etc/ssl/private/myserver.key"
SSLCACertificateFile "/etc/ssl/private/myserver.crt" ## Your choice here is required, optional, and optional_no_ca SSLVerifyClient optional_no_ca ## this is number of depths of CA to traverse, use 1 SSLVerifyDepth 1 ## this send the cert info to PHP SSLOptions +StdEnvVars +ExportCertData ## this will allow it to accept your own CA unknown to browser SSLCADNRequestPath /etc/ssl/private/ </VirtualHost>
CREATE TABLE users ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) NOT NULL UNIQUE, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, lastvisit_at DATETIME DEFAULT CURRENT_TIMESTAMP );
SET GLOBAL validate_password.policy=LOW; CREATE USER 'mylampuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; GRANT ALL ON mylamp.* TO 'mylampuser'@'localhost' WITH GRANT OPTION;
<?php /* Database credentials. */ define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'mylampuser'); define('DB_PASSWORD', 'password'); define('DB_NAME', 'mylamp'); /* Attempt to connect to MySQL database */ $link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } ?>
<?php // Include config file session_start(); require_once "config.php"; if(isset($_SERVER['SSL_CLIENT_S_DN_Email'])){ $_SESSION['username'] = $_SERVER['SSL_CLIENT_S_DN_Email']; $username = $_SERVER['SSL_CLIENT_S_DN_Email']; $sql = "SELECT id FROM users WHERE username = ?"; if($stmt = mysqli_prepare($link, $sql)){ // Bind variables to the prepared statement as parameters mysqli_stmt_bind_param($stmt, "s", $username); // Attempt to execute the prepared statement if(mysqli_stmt_execute($stmt)){ /* store result */ mysqli_stmt_store_result($stmt); if(mysqli_stmt_num_rows($stmt) == 1){ //update user $sql = "UPDATE users SET lastvisit_at = now() where username = ?"; } else{ //add a new user $sql = "Insert into users (username) values (?)"; } if($stmt = mysqli_prepare($link, $sql)){ mysqli_stmt_bind_param($stmt, "s", $username); if(mysqli_stmt_execute($stmt)){ mysqli_stmt_store_result($stmt); mysqli_stmt_free_result($stmt); mysqli_stmt_close($stmt); } }else{ echo "Oops! Something went wrong. Please try again later."; } } else{ echo "Oops! Something went wrong. Please try again later."; } } }else{ $_SESSION['username'] = 'unknown'; } echo $_SESSION['username']; mysqli_close($link); ?>
<?php require_once "config.php"; $sql = "SELECT * from users"; if($stmt = mysqli_prepare($link, $sql)){ if(mysqli_stmt_execute($stmt)){ mysqli_stmt_store_result($stmt); printf("Number of rows: %d.<br>", mysqli_stmt_num_rows($stmt)); mysqli_stmt_bind_result($stmt, $id, $username, $created, $lastuse); while(mysqli_stmt_fetch($stmt)){ printf("%s -- %s -- %s -- %s. <br>",$id,$username,$created,$lastuse); } mysqli_stmt_free_result($stmt); mysqli_stmt_close($stmt); } }else{ echo "Oops! Something went wrong. Please try again later."; } /* close connection */ mysqli_close($link); ?>
<html> <head> </head> <body> <?php include 'login.php'; print("Hello World"); ?> </body> </html>
import json import decimal import boto3 from boto3.dynamodb.conditions import Key, Attr # Helper class to convert a DynamoDB item to JSON. class DecimalEncoder(json.JSONEncoder): def default(self, o): if isinstance(o, decimal.Decimal): if o % 1 > 0: return float(o) else: return int(o) return super(DecimalEncoder, self).default(o) def lambda_handler(event, context): # TODO implement #define DynamoDB object dynamodb = boto3.resource('dynamodb') #define which table we want to use table = dynamodb.Table("yourOwnTable") #print the status of the table print(table.table_status) #Get the body string from the event input json #we convert this to json so we can use it easier body = json.loads(event['body']) #we enter this into the DB respose1 = table.put_item( Item={ 'RequestTime': body['myFormVariables']['RequestTime'], 'User': body['myFormVariables']['User'], 'entryID': body['myFormVariables']['entryID'], 'Field1': body['myFormVariables']['Field2'], 'Field2': body['myFormVariables']['Field1'] } ) print("Table Output") ##get it all response2 = table.scan() ##Get only the objects that match the given key #response = table.query(KeyConditionExpression=Key('entryID').eq("L3dVGMDS7yqzdoxCxOm4fg")) #Print all values in the response for i in response2['Items']: print(i['entryID'], ":", i['Field1'], ":", i['Field2'], ":", i['RequestTime']) #Just to illustrate how I handled cognito user information that was passed in cognito = event['requestContext']['authorizer']['claims']['cognito:username'] return { 'statusCode': 200, 'body': json.dumps(response2, cls=DecimalEncoder) }
{
"path": "/entry",
"httpMethod": "POST",
"headers": {
"Accept": "*/*",
"Authorization": "eyJraWQiOiLTzRVMWZs",
"content-type": "application/json; charset=UTF-8"
},
"queryStringParameters": null,
"pathParameters": null,
"requestContext": {
"authorizer": {
"claims": {
"cognito:username": "the_username"
}
}
},
"body": "{\"myFormVariables\":{
\"RequestTime\":"2019-01-11T05:56:22.517Z\",
\"User\":\"the_username\",
\"entryID\":\"L3dVGMDS7yqzdoxCxOm4f1\",
\"Field1\":47,
\"Field2\":122}}"
}
