Roy Verrips rverrips

## index.php
<? session_start(); ?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8"/>
    <title>Adapt</title>
    <style type="text/css">
        .num{
            font-size: 244px;
            height: 270px;

## EXAMPLE - Querying Incident table from client-side script.js
//Client-side
doThing();

function doThing() {
	let eGR = new EfficientGlideRecord('incident')
		.setLimit(10)
		.addNotNullQuery('assignment_group')
		.addField('number')
		.addField('short_description')
		.addField('assignment_group', true) //Get display value as well

## README.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                rverrips
                / README.md
            
            
              Last active
              November 8, 2018 00:17
                — forked from denvazh/README.md
            
              
                Scheduled update for homebrew
              
          
    Scheduled updates for homebrew

This two launchdaemon scripts provide scheduled updates and upgrade for homebrew packages.
It will run in the following way:

brew update every day at 12:10
brew upgrade every day at 12:20

How to installload


## Howto convert a PFX to a seperate .key & .crt file
source: http://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/

`openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key]`

What this command does is extract the private key from the .pfx file. Once entered you need to type in the importpassword of the .pfx file.  This is the password that you used to protect your keypair when you created your .pfx file.  If you cannot remember it anymore you can just throw your .pfx file away, cause you won’t be able to import it again, anywhere!.  Once you entered the import password OpenSSL requests you to type in another password, twice!. This new password will protect your .key file.

Now let’s extract the certificate:

`openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt]`

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                rverrips
                / keybase.md
            
            
              Last active
              May 6, 2017 06:37
            
          
    Keybase proof

I hereby claim:

I am rverrips on github.
I am rverrips (https://keybase.io/rverrips) on keybase.
I have a public key ASAC4DGUn4G8mafCQw05vWpLd6W7et-01rq2UDvTrjQK9Ao

To claim this, I am signing this object:

  
## Howto-Migrate-MySQL.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                rverrips
                / Howto-Migrate-MySQL.md
            
            
              Created
              December 4, 2016 13:23
            
              
                How To Migrate a MySQL Database Between Two Servers
              
          
    How To Migrate a MySQL Database Between Two Servers
Transferring a database between virtual private servers can be accomplished using a SCP (Secure Copy), a method of copying files derived from the SSH Shell. Keep in mind, you will need to know the passwords for both virtual servers.
In order to migrate the database, there are two steps:
Step One—Perform a MySQL Dump
Before transferring the database file to the new VPS, we first need to back it up on the original virtual server by using the mysqldump command.
mysqldump -u root -p --opt [database name] > [database name].sql
After the dump is performed, you are ready to transfer the database.

  
## webmin-install.sh
#Install Perl Dependancies
apt-get install -f -y perl libnet-ssleay-perl openssl libauthen-pam-perl \
libpam-runtime libio-pty-perl libdbd-pg-perl apt-show-versions python

#Download Most Current Version Webmin
wget -c http://www.webmin.com/download/deb/webmin-current.deb

#Install Webmin
dpkg --install webmin-current.deb

## VLAN-Details
/** Pulls data from various tables in HP IMC 7.0 Database to:
    Show all details for a specific VLAN across a campus.
    Useful for sizing a migration of that VLAN to another VLAN, etc.
    Change the VLan PVID on the "Where" section .. the example listes uas pv=6.
**/

SELECT [report_db].[report].[plat_v_dev].[symbol_name]           AS Name,
       [report_db].[report].[plat_v_dev].[dev_ip]                AS IP,
       [report_db].[report].[plat_v_dev].[dev_series_name]       AS Series,
       [report_db].[report].[plat_v_phy_if_info].[ifoptstatus]   AS Status,

## gist:7412492
### put the switch ip address in lines 3 and 17 ###
### put the username in to lines 4 and 18 and the password into lines 5 and 19 ###
telnet 10.1.0.11
admin
### put your password here ###
configure terminal
crypto key generate ssh rsa
ip ssh
ip ssh filetransfer
aaa authentication ssh login local none

## gist:7412307
/** In Microsoft SQL with unixtime ... do  **/

Select DATEADD(second, @Unixtime-Variable, {d '1970-01-01'})
	<? session_start(); ?>
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8"/>
	<title>Adapt</title>
	<style type="text/css">
	.num{
	font-size: 244px;
	height: 270px;
	//Client-side
	doThing();

	function doThing() {
	let eGR = new EfficientGlideRecord('incident')
	.setLimit(10)
	.addNotNullQuery('assignment_group')
	.addField('number')
	.addField('short_description')
	.addField('assignment_group', true) //Get display value as well
	source: http://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/

	`openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key]`

	What this command does is extract the private key from the .pfx file. Once entered you need to type in the importpassword of the .pfx file. This is the password that you used to protect your keypair when you created your .pfx file. If you cannot remember it anymore you can just throw your .pfx file away, cause you won’t be able to import it again, anywhere!. Once you entered the import password OpenSSL requests you to type in another password, twice!. This new password will protect your .key file.

	Now let’s extract the certificate:

	`openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt]`
	#Install Perl Dependancies
	apt-get install -f -y perl libnet-ssleay-perl openssl libauthen-pam-perl \
	libpam-runtime libio-pty-perl libdbd-pg-perl apt-show-versions python

	#Download Most Current Version Webmin
	wget -c http://www.webmin.com/download/deb/webmin-current.deb

	#Install Webmin
	dpkg --install webmin-current.deb
	/** Pulls data from various tables in HP IMC 7.0 Database to:
	Show all details for a specific VLAN across a campus.
	Useful for sizing a migration of that VLAN to another VLAN, etc.
	Change the VLan PVID on the "Where" section .. the example listes uas pv=6.
	**/

	SELECT [report_db].[report].[plat_v_dev].[symbol_name] AS Name,
	[report_db].[report].[plat_v_dev].[dev_ip] AS IP,
	[report_db].[report].[plat_v_dev].[dev_series_name] AS Series,
	[report_db].[report].[plat_v_phy_if_info].[ifoptstatus] AS Status,
	### put the switch ip address in lines 3 and 17 ###
	### put the username in to lines 4 and 18 and the password into lines 5 and 19 ###
	telnet 10.1.0.11
	admin
	### put your password here ###
	configure terminal
	crypto key generate ssh rsa
	ip ssh
	ip ssh filetransfer
	aaa authentication ssh login local none
	/ In Microsoft SQL with unixtime ... do /

	Select DATEADD(second, @Unixtime-Variable, {d '1970-01-01'})