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 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) # […]
Ubuntu – IPtables – redirect port to different IP Read IP tables; iptables -t nat -L -n -v For redirecting port to different IP and port echo “1” > /proc/sys/net/ipv4/ip_forward Then, we will add a rule telling to forward the traffic on port 1111 to ip 2.2.2.2 on port 1111: # iptables -t […]
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/
Automatically find and re-attach to a detached screen session SCREEN -RR OR SCREEN -X SCREEN -R ……
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 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’ 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 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
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 […]