Posts

Showing posts from June, 2015

create simple mysql table for testing

CREATE TABLE suppliers ( SupplierID SMALLINT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, SupplierName VARCHAR(40) NOT NULL, Phone VARCHAR(14) NOT NULL, Email VARCHAR(60) NULL, PRIMARY KEY (SupplierID) ); INSERT INTO suppliers (SupplierName, Phone, Email) VALUES ('ABCSupplier','1122334455','abc@dicforum.com');

VirtualBox: port forwarding to guest from host

Something weird in the new (2015-06) version.


NetworkSet "NAT"Click "Port Forwarding""Insert new rule" (right-hand nav button)Rule 1Host IP: 127.0.0.1Host port: 2222Guest IP: [leave blank]Guest Port: 22 To get to guest:

ssh -p 2222 myuser@localhost

where myuser is user you created when you installed Linux OS on to VM.

Connect to remote JMX over ssh and jconsole

ssh -N -f -D 7777 dev-cass-10.mydomain.internal jconsole -J-DsocksProxyHost=localhost -J-DsocksProxyPort=7777 service:jmx:rmi:///jndi/rmi://localhost:7199/jmxrmi