Category: tech

Cisco CLI Commands

For future reference:

ENABLE PASSWORD: example 1

switch> enable
switch# conf t
switch# enable password somethinghere
switch# end
switch# show running-config
switch# copy running-config startup-config

ENABLE PASSWORD: example 2

switch> enable
switch# conf t
switch# enable password level 15 0 cisco
switch# ip http server
switch# ip http authentication enable
switch# show running-config
switch# copy running-config startup-config

ENABLE WEB AUTHENTICATION:

switch> enable
switch# conf t
switch# ip http server
switch# end
switch# show running-config
switch# copy running-config startup-config

Other commands:

switch> enable
switch# show running-config
switch# copy running-config startup-config (save the config)
switch> dir flash: (show flash files)
switch> rename flash:config.text flash:config.text.old
switch# sho run | inc http (show running config with http)
switch# ip http authentication local (using enable password/username saved in the switch)

 

Posted on by kuan

Password encrypted as SecureString in powershell

Create a password file with securestring:

Read-Host -AsSecureString | ConvertFrom-SecureString | Out-File -FilePath C:\encrypted.securestring

Use the password file to create a PSCredential

$credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "username",(Get-Content -Path C:\encrypted.securestring | ConvertTo-SecureString)

Reference here.

I realized that this encrypted password only work on the machine which encrypting it.
To have this works on a different computer(s), you would need the key and the encrypted file.

Posted on by kuan

Enable/Disable Windows 10 Startup programs in Registry

Beside those well known registry location such as HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
Not sure this registry exist since Windows 8 or not, but it took me a while to find it out in Windows 10 that there is this registry location to Enable/Disable programs to run during startup.

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\StartupApproved\Run32

If you need to add this to GPO through GPP, and the key value is type REG_Binary.
You may want to import this registry item, and then browse to it (I added them manually, which didn't work). Or lookup on the internet on how to convert the binary data first.

* this is same as using msconfig to enable/disable startup item.

Posted on by kuan

Remote SQL Logging for TMG 2010

Setup SQL Server 2012 Logging for TMG on a different server according to this guideline here
However, the TMG is still not logging remotely.
After some investigation and testing, it was the name of the Database that we setup which is causing problem!
The name of the database contain a dash (ex: XXX-XXXX), which we could see and browse to in Management Studio.

But when I tested from the command line using sqlcmd, it would give me an error saying XXX is not recognise.
And it was the AHA moment that I realised it was something to do with the name!

sqlcmd is really helpful in this instance!

Here is an example using sqlcmd to list table's columns in a database:

> sqlcmd -S servername
1> use databasename
2> select column_name
3> from information_schema.columns
4> where table_name = 'Tablename'
5> go

More information about this useful utility can be found here.

If any reason you need to access the old records for the TMG in sqlexpress, here is how:
In management studio, servername: localhost\msfw 

Other tip: create any file with extension .udl, you would be able to use it to test Database connection in GUI

 

Posted on by kuan

Crontab - Force Shutdown in OSX

sudo crontab -e

Press i (insert text in vim)
30 19 * * 5 /sbin/shutdown -h now

Press esc (to exit editing)
Press shift+z shift+z (Writes changes and quit vim)

Time format in Crontab:
* * * * * command to execute
│ │ │ │ │
│ │ │ │ └─── day of week (0 - 6) (0 to 6 are Sunday to Saturday, or use names; 7 is Sunday, the same as 0)
│ │ │ └──────── month (1 - 12)
│ │ └───────────── day of month (1 - 31)
│ └────────────────── hour (0 - 23)
└─────────────────────── min (0 - 59)

Posted on by kuan

OSX Terminal Commands

Caching related:
sudo serveradmin stop caching
sudo serveradmin start caching
sudo serveradmin status caching


tail -F /Private/var/log/system.log
tail -F /Library/Server/Caching/Logs/Debug.log

example:
grep 'Since server start:' /Library/Server/Caching/Logs/Debug.log
grep 'B from cache' /Library/Server/Caching/Logs/Debug.log
egrep 'Since server start|B from cache' /Library/Server/Caching/Logs/Debug.log
grep '2015-09' /Library/Server/Caching/Logs/Debug.log | grep 'Since server start|B from cache'
grep -J 'MB downloaded' /Library/Server/Caching/Logs/Debug* > fromInternet.txt
grep -J 'MB from cache' /Library/Server/Caching/Logs/Debug* > fromCached.txt
grep -J 'Since server start' /Library/Server/Caching/Logs/Debug* > SinceServerStart.txt

SSH, Mapped Drive & Copy stuffs:
ssh computername
cd /
sudo mkdir scripts
sudo mkdir /Volumes/mnt
sudo mount_afp afp://osxserver.domain.com/mnt /Volumes/mnt
sudo cp /Volumes/mnt/homedrive.sh /scripts
sudo cp -R /Volumes/mnt/MappedDrive.app /Applications
sudo cp -R /Volumes/mnt/StudentShared.app /Applications
sudo cp -R /Volumes/mnt/Microsoft\ Remote\ Desktop.app /Applications
sudo umount /Volumes/mnt

Posted on by kuan

Map drive and copy in OSX's Terminal

I do this via ssh (putty):

cd /
sudo mkdir scripts
sudo mkdir /Volumes/mnt
sudo mount_afp afp://server.share/mnt /Volumes/mnt
sudo cp /Volumes/mnt/homedrive.sh /scripts
sudo cp -R /Volumes/mnt/MappedDrive.app /Applications
sudo cp -R /Volumes/mnt/StudentShared.app /Applications
sudo cp -R /Volumes/mnt/Microsoft\ Remote\ Desktop.app /Applications
sudo umount /Volumes/mnt

 

Posted on by kuan

第一次拆開Macbook Pro

Still remembered my first day at PCSSC was to fix an IMAC.
As days goes by, my skills and knowledge in OSX also gaining paces.
Just recently we were able to deploy 2 labs of iMAC with imaging software (DeployStudio).
With ssh enabled on the machines, it also make our job a lot easier by remote into it and do some works as required.
I probably should do some Apple courses in the future.

Macbook Pro

It was actually quite easy to open up the Macbook Pro, but not iMAC though.

Posted on by kuan

My First Shell Script in OSX

#!/bin/sh
# Enable SSH
echo "Enabling SSH"
systemsetup -setremotelogin on
echo “Set computer name to this format eg: LRC-IMACXX, where xx is numbers.”
scutil --set HostName
ComputerName=$(HostName)
scutil --set LocalHostName $ComputerName
scutil --set ComputerName $ComputerName
echo “Computer name set to: “ $ComputerName
echo “Changing power preference”
sudo pmset -c ttyskeepawake 1
sudo pmset -c sleep 15
sudo pmset -c displaysleep 10
sudo pmset -c womp 1
sudo pmset -c halfdim 1
sudo pmset -c disksleep 10
echo “Schedule MAC wakeup at 8am and shutdown at 6pm everyday”
sudo pmset repeat shutdown MTWRF 18:00:00 wakeorpoweron MTWRF 08:00:00
echo “Set proxy”
sudo networksetup -setautoproxyurl Ethernet http://something.pac
sudo networksetup -setautoproxyurl Wi-Fi http://something.pac
echo “Joining Domain…”
sudo dsconfigad -f -a $ComputerName -domain domain.com -u username -p password
echo “Done”

to run this in terminal>
sudo sh scritpt.sh

Posted on by kuan