KeyID=0x712a867e997e41fb Fingerprint=7910 45D1 AD59 B1DD AAF7 1A0E 712A 867E 997E 41FB
Categories
Author: Tim van Kooten Niekerk
POST 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://totietoot.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://totietoot.nl/services/testservice/getTest"' \ https://totietoot.nl/testservice/getTest --tlsv1.2 -o result.xml -v
Categories
MSSQL Query Value From XML Datatype
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 DESC
Categories
GNU/Linux Docker QuickRef
Simple 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 9990
Build 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> bash
Categories
GNU/Linux TCPDump QuickRef
Some tcpdump examples.
tcpdump -vv -i eth0 -w tcpdump.log ‘tcp port 443’
tcpdump -vv -i eth0 -w tcpdump.log dst 145.89.57.121