Difference between revisions of "Desktop:X1 Nano"

Revision as of 16:24, 9 January 2022

Windows 11 New Computer Setup December 2021/January 2022

Fresh Installs

Chrome - Version 96.0.4664.110 (Official Build) (64-bit)
KeePass 2.49 
Eset NOD32 Antivirus 15.0.21.0
MS Office Professional Plys 2013 - Excel Only (Intend to replace with Office 365)
PuTTY - 64 Bit version 0.76
Greenshot (Greenshot-RELEASE-1.2.10.6)
GIT - 2.34.1 (Accepted all defaults)

Restore Files

Map Network Drives to NAS (M:=\\radonnas\Multimedia, H:=\\radonnas\homes\Matt) - User:Admin
KeePass Database and Key (MCARTER.bkdx MCARTER.key)

Restore MYOB EXO Employee Services

Copy to directory C:\CLIENTS\_COMACC 
Run File network
Setup - Special Options - Import - File Location C:\CLIENTS\_COMACC\
Setup - Backup Path - C:\CLIENTS\_BACKUP\MYOB_PAYROLL\

Install Quickbooks 2008/09 SP3

Apply Registry Fix - regfix_QB_Win10.reg
Restart Computer

Mount Image QB0809_SP3.iso
Run autorun.exe
...License Key: 85301-26735-37644-220162
...Install Quickbooks with the Company File Server
...Installs .NET 1.1

Run QuickBooks
...Select General Business
...Open an Existing Company File
...Activate Customer ID: 1247912

Can no longer activate license (as this version has been retired), but created script QB_Hack.ps1 to reset access

#Changes qbmode to the value as per installation, so can access QB 6 more times before activation
$file = Get-Content C:\Users\Public\Documents\Intuit\qbw.ini
($file).Replace($file.Get(1),'Qbmode=000063c07b28') | Out-File C:\Users\Public\Documents\Intuit\qbw.ini

Install WAMP DEV Environment

SSH Public/Private Key added to GIT Server
  ssh-keygen –t rsa –C "matt.carter@radon.nz"
  Accept default name, and enter your own pass phrase
  This creates two files in folder ~/.ssh/
    id_rsa (private Key) 
    id_rsa.pub (public key)
  id_rsa.pub copied to the gitolite-admin respository on the server as keydir/<username>.pub
  But copied files (id_rsa and id_rsa.pub) from old computer

Configure GIT
  Create file ~/.ssh/config with the following

Host git.radon.nz
Hostname git.radon.nz
Port 22
User gitolite3
UserKnownHostsFile ~/.ssh/known_hosts

Clone Repositories

mkdir /c/GIT
cd /c/GIT
git clone git

WAMP - wampserver3.1.3_x86 (have to install all the prerequisite VC distributables both 32 and 64 bit)
MySQL Workbench 6.3.10 https://dev.mysql.com/downloads/file/?id=474210
NetBeans 8.2 64 Bit with PHP http://download.netbeans.org/netbeans/8.2/final/bundles/netbeans-8.2-php-windows-x64.exe
Clone GIT Respository

Configure Web Server
  Edit hosts file (C:\Windows\System32\drivers\etc\hosts) and add line "127.0.0.1 ticktock"
  Edit httpd-vhosts.conf file (within wampserver) and add the following Virtual Hosts

<VirtualHost *:80>
  ServerName localhost
  ServerAlias localhost
  DocumentRoot "C:/GIT/XeroApi/xero-php-oauth2-app"
  <Directory "C:/GIT/XeroApi/xero-php-oauth2-app">
    Options +Indexes +Includes +FollowSymLinks +MultiViews
    AllowOverride All
    Require local
  </Directory>
</VirtualHost>
<VirtualHost ticktock:80>
  ServerName ticktock
  ServerAlias ticktock
  DocumentRoot "C:/GIT/ticktock/app/webroot"
  <Directory "C:/GIT/ticktock/app/webroot">
    Options +Indexes +Includes +FollowSymLinks +MultiViews
    AllowOverride All
    Require local
  </Directory>
</VirtualHost>

Configure MySQL

 Add MySQL Bin path to PATH environmental (i.e. C:\WAMP\bin\mysql\mysql5.7.21\bin\)
 Create database users for ticktock

create user 'ticktock'@'localhost' identified by 'ticktock';
create user 'ticktock_dev'@'localhost' identified by 'ticktock_dev';
create user 'ticktock_demo'@'localhost' identified by 'ticktock_demo';
grant all privileges on ticktock.* to 'ticktock'@'localhost';
grant all privileges on ticktock_dev.* to 'ticktock_dev'@'localhost';
grant all privileges on ticktock_demo.* to 'ticktock_demo'@'localhost';
grant select on ticktock.* to 'ticktock_dev'@'localhost';
grant select on ticktock.* to 'ticktock_demo'@'localhost';