MySQL example to convert UTC timestamp to specific timezone.
SELECT
SensorName,
MAX(CONVERT_TZ(LastUpdated, 'UTC', 'Europe/Amsterdam')) AS LastUpdated
FROM Sensors
WHERE (TIME_TO_SEC(TIMEDIFF(NOW(), CONVERT_TZ(LastUpdated, 'UTC', 'Europe/Amsterdam'))) < 1800)
GROUP BY SensorName;Bash script to auto-mount NFS share when it is available (and not already mounted).
#!/bin/bash
ping -c 1 -n 192.168.1.250 > /dev/null
if [ $? -eq 0 ] && [ ! -d /mnt/nas1/directory ]; then
sudo mount -t nfs 192.168.1.250:/mnt/nfsmountpoint /mnt/nas1
fiPOST a Soap Message using curl using Mutual SSL…
curl -k --cert certchain.pem:password --key server.key \
-d "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:tot=\"http://timvkn.nl/services/testservice\" ><soapenv:Header/><soapenv:Body><tot:getTest><Name>%</Name></tot:getTest></soapenv:Body></soapenv:Envelope>" \
-H 'Content-Type: application/soap+xml' \
-H 'SOAPAction: "http://timvkn.nl/services/testservice/getTest"' \
https://timvkn.nl/testservice/getTest --tlsv1.2 -o result.xml -v
Query some values from a XML datatype result…
SELECT [datumtijd]
,(CAST(body AS XML).query('declare namespace ns1="http://totietoot.nl/example/person/1/0";
declare namespace soapenv="http://schemas.xmlsoap.org/soap/envelope/";
declare default element namespace "http://totietoot.nl";
//soapenv:Envelope/soapenv:Body/ns1:Members/ns1:Person/ns1:ID'
).value('.', 'nvarchar(100)')) AS ID
,(CAST(body AS XML).query('declare namespace ns1="http://totietoot.nl/example/person/1/0";
declare namespace soapenv="http://schemas.xmlsoap.org/soap/envelope/";
declare default element namespace "http://totietoot.nl";
//soapenv:Envelope/soapenv:Body/ns1:Members/ns1:Person/ns1:Name'
).value('.', 'nvarchar(100)')) AS Name
--,[body]
FROM [DATABASE].[dbo].[Logtable]
WHERE [kolom1] = 'waarde'
ORDER BY datumtijd DESCSimple Dockerfile example for a dockered teiid instance…
# HU Teiid Docker QuickRef:
# ->docker build -t dteiid-example .
# ->docker run --name dteiid-example -p 8081:8080 -p 9991:9990 -v /var/log/docker/dteiid-example/:/opt/jboss/teiid-10.0.0.Final/standalone/log/ --env-file=teiid-test.env --restart unless-stopped -it dteiid-example
FROM teiid/teiid:10.0.0.Final
MAINTAINER Tim van Kooten Niekerk (tim@totietoot.nl)
# Pass logs to host; Location on host needs chmod 1000:1000 so jboss can write...
RUN mkdir /opt/jboss/teiid-10.0.0.Final/standalone/log/
RUN chown -R jboss:jboss /opt/jboss/teiid-10.0.0.Final/standalone/log/
VOLUME /opt/jboss/teiid-10.0.0.Final/standalone/log/
# Add config files...
ADD customization /opt/jboss/teiid-10.0.0.Final/customization/
# Add Drivers...
ADD ojdbc7-12.1.0.1.0.jar /opt/jboss/teiid-10.0.0.Final/standalone/deployments/
ADD sqljdbc42.jar /opt/jboss/teiid-9.3.4/standalone/deployments/
# Deploy VDB's....
ADD cursuscatalogus-vdb-vdb.xml /opt/jboss/teiid-10.0.0.Final/standalone/deployments/
# Configure Environment and Start server...
CMD ["/opt/jboss/teiid-10.0.0.Final/customization/execute.sh"]
# You can expose ports...
EXPOSE 8081 8080
EXPOSE 9991 9990Build a docker…
docker build -t dteiid-example .Run, Start, Stop commands…
docker run --name dteiid-example -p 8081:8080 -p 9991:9990 --env-file=teiid-test.env --restart unless-stopped -it dteiid-example
docker ps -a
docker rm <containername|id>
docker start|stop <containername|id>
docker attach <containername|id>
docker image[s] [save|load|ls|rm|prune|...] [-[o|i] image.tar.gz]
Connect to a container…
docker exec [-u 0] -it <containername|id> bashSome tcpdump examples.
tcpdump -vv -i eth0 -w tcpdump.log 'tcp port 443'
tcpdump -vv -i eth0 -w tcpdump.log dst 145.89.57.121| ODATA Query Option | Description |
|---|---|
| $orderby | Uri parameter for sorting… |
| $select | Uri parameter to select specific coluimns… |
| $top | Uri parameter to limit the result… |
| $skip | Uri parameter to skip number of rows… |
| $filter | Uri parameter to filter result… |
| $expand | Uri parameter to expand related entity… |
| $inlinecount | Uri parameter to include a total record count… |
Example to retrieve metadata from JBoss DV Odata service…
https://localhost:8443/odata/vdbname/$metadataRetrieve all records in JSON format…
https://localhost:8443/odata/vdbname/modelname?$format=jsonOrder by column ‘Name’ and retrieve first 5 records…
https://localhost:8443/odata/vdbname/modelname?amp;$orderby=Name&$top=5Order by column ‘Name’ and retrieve records 6-10 records…
https://localhost:8443/odata/vdbname/modelname?$orderby=Name&skip=5&$top=5Filter ODATA result ($filter=Name eq ‘John’)…
https://localhost:8443/odata/vdbname/modelname?$filter=Name%20eq%20%27John%27Select specific rows…
https://localhost:8443/odata/vdbname/modelname?$select=ID,Name,DescriptionFunction to convert a HEX value to Ascii. Example:
>fnHex2Ascii -HexValue “00000000”
function fnHex2Ascii()
{
param (
[string]$HexString
)
Clear-Variable -Name sAscii -ErrorAction SilentlyContinue
$HexString -Split '(.{2})' | %{ if ($_ -ne "") { $sAscii+=[CHAR]([CONVERT]::toint16($_,16)) } }
# Return metadata and body...
return $sAscii
}
Test LDAP server SSL/TLS connection using LDAP commandline client…
ldapsearch -H ldaps://dc01.totietoot.nl -b "OU=Employees,OU=Totietoot,DC=Totietoot,DC=nl" "userPrincipalName=john@totietoot.nl" -W -D john@totietoot.nl -d 1env LDAPTLS_REQCERT=never|allow|try|demand LDAPTLS_CACERT=/path/to/ca-cert.pem ldapsearch -H ldaps://dc01.totietoot.nl -b "OU=Employees,OU=Totietoot,DC=Totietoot,DC=nl" "userPrincipalName=john@totietoot.nl" -W -D john@totietoot.nl -d 1Add user certificate to a specific encrypted file…
cipher /ADDUSER /CERTHASH:CERTIFICATE_THUMBPRINT file.txtAdd user certificate to a specific encrypted directory…
cipher /ADDUSER /CERTHASH:CERTIFICATE_THUMBPRINT /S:directory