4th Floor, 4 Tabernacle Street London EC2A 4LU

SFTP Only for a user – Debian

SFTP Only for a user – Debian Add the user info the sshd_config file in /etc/ssh/sshd_config Ensure the line is uncommented; Subsystem sftp /usr/lib/openssh/sftp-server Match User userbob ForceCommand internal-sftp ChrootDirectory /home/userbob X11Forwarding no AllowTcpForwarding no   Ensure the home directory is not group writeable. It should be 755. /etc/init.d/ssh restart service ssh restart Test the […]

Extract Table from SQL Dump – MYSQL

Extract Table from SQL Dump – MYSQL The script below creates individual table exports from a SQL dump. ./MyDumpSplitter.sh yourfile.sql your_table_name [code] #!/bin/sh # http://kedar.nitty-witty.com #SPLIT DUMP FILE INTO INDIVIDUAL TABLE DUMPS # Text color variables txtund=$(tput sgr 0 1)    # Underline txtbld=$(tput bold)       # Bold txtred=$(tput setaf 1)    # Red txtgrn=$(tput setaf 2)    # […]

Outlook Crash – IMAP 0xc0000005 – ISPCONFIG

Outlook Crash – IMAP 0xc0000005 – ISPCONFIG Outlook was crashing on startup every time it synced IMAP folders, not a problem in Thunderbird. This is my fix; Removing the empty first empty line from the files subscriptions and courierimapsubscribed fixes it in /var/vmail/MAILBOX/Maildir/          

Extract CREATES from SQL dump

Extract CREATES from SQL dump If you are trying to extract the create routines from a SQL dump, this might help you! Basically it picks out the contents between “CREATE” and “\;” You can modify these two variables as need be..   [bash] cat dump.sql |awk ‘/CREATE/,/\;/ { print $0 ; }’ > create.sql   […]

Restrict Media Wiki Access

Restrict Media Wiki Access To prevent new user registrations add the following to LocalSettings.php # This snippet prevents new registrations from anonymous users # (Sysops can still create user accounts) $wgGroupPermissions[‘*’][‘createaccount’] = false; To prevent anonymous users reading pages add the following to LocalSettings.php #Disable reading line, for anonymous (not-logged-in => * ) : $wgGroupPermissions[‘*’][‘read’] […]

Amazon AMI – ‘ launch config name not found’

Amazon AMI – ‘ launch config name not found’ If you are receiving this: as-create-auto-scaling-group:  Service error: Launch configuration name not found – null Ensure you have set the region!! This was missing out of many of the docs I have read and appears that it only affects EU nodes.   For example; as-create-auto-scaling-group xxscale […]

Amazon – Ubuntu CPAN Perl Install

Amazon – Ubuntu CPAN Perl Install If you experiencing any issues with installing, upgrading or managing CPAN perl libraries on a refreshley deployed Amazon EC2 instance make sure you have your build essentials!! Run: sudo  apt-get install build-essential    

APE Server

Installing APE on Ubuntu Server 10.10 This small tutorial was made based on the ape-project install documentation. It summarizes things to help people get APE running on Ubunto ASAP.   This small tutorial was made based on the ape-project install documentation. It summarizes things to help people get APE running on Ubunto ASAP. Hope it […]