Category: technical

 

How to use port forwarding when you are behind a firewall.

to access a service running locally on the remote server.

To setup a proxy

ssh -L 3128:localhost:80 <username>@YOURREMOTESERVER

REMOTE Port forwarding

Below example could be used to access RDP behind a firewall, but accessible from YOURREMOTESERVER

ssh -L 3389:YOURREMOTE_SERVER_WHERESERIVERUN_IP:3389 <username>@YOURREMOTESERVER -N

3389 – RDP port

N – will not start a terminal session.

 

 

Use localhost as the hostname/IP to establish connection from your desktop

Use Ghost Script from commandline

gs -sDEVICE=pdfwrite -dNOPAUSE -dQUIET -dBATCH -dPDFSETTINGS=/screen -dCompatibilityLevel=1.6 -sOutputFile=pdfoutsmallfile.pdf pdfinputlargefile.pdf

-dNOPAUSE – disable the interactive prompting
pdfwrite – create pdf files
-dCompatibilityLevel=1.6 – compatibility with each versions of adobe. Use 1.3,1.4,1.6,1.7
-sOutputFile – name of the output file.

#!/bin/bash
RED=’\033[0;31m’
GREEN=”\033[0;32m”
NC=’\033[0m’ # No Color

function checkport {
if nc -zv -w30 $1 $2 <<< ” &> /dev/null
then
echo “${GREEN}[O]${NC} $1:$2”
else
echo “${RED}[C]${NC} $1:$2”
fi
}

printf “server list:”;
read server
printf “ports list[enter for default]:”
read ports_to_check

if [[ $ports_to_check = “” ]]; then
echo “using default port list”;
ports_to_check=”22 389 3306 8080″; #enter your default list of ports here
echo “$ports_to_check”;
fi

for i in $server;do
{
echo “==========================================”
for j in $ports_to_check ; do
checkport $i $j
done
}; done

RED=’\033[0;31m’
NC=’\033[0m’ # No Color

echo -e “${RED}Mathew${NC} Touchriver”

ERROR 1217 (23000) at line 287: Cannot delete or update a parent row: a foreign key constraint fails

If you got this error, it means that you are trying to restore a database sql file which got dependancy on other tables.

To override and restore anyway, add this to the top of the .sql dump file

SET FOREIGN_KEY_CHECKS = 0;

This will make sure that the foreign key checks are disabled for the session while restoring.