I had a customer with a problem using a web based email marketing software application. Importing data and deleting data seemed to stop working. The database uses InnoDB tables so I used phpMyAdmin to try to execute the delete SQL code and received the following error: 1205 lock wait timeout exceeded For future reference: To… Read more »
Posts By: jonny
Find and Replace Strings in Files
The Wikipedia article on find is great. Searching To check for the existence of the string in any of the files in the directory structure: find . -exec grep -H “searchstring” ‘{}’ \; -print On Solaris ommit the ‘-H’.or using grep only: grep -r “searchstring” /tmp Replacing Find in the current directory (.) type file… Read more »
rsync: fatal: libpopt.so.0: open failed
I was trying to use Rsync on a Solaris machine and received the following error message: ld.so.1: /usr/local/bin/rsync: fatal: libpopt.so.0: open failed: No such file or directory I discovered from http://www.sunmanagers.org/pipermail/sunmanagers/2002-May/014178.html that it is an evil LD_LIBRARY issue which can be overcome with the following (as root): crle -l /usr/lib:/usr/local/lib crle -u
Tor and Privoxy in Ubuntu
Tor is a free implementation of anonymity network which protects your privacy over the internet. Tor enable this by providing virtual tunnels to internet application through SOCKS interface. This post will show you how to setup and use Tor to browse the web anonymously. First of all you need to install tor and privoxy package… Read more »
Sun Solaris Screen Resolution
When moving some Sun Solaris servers to a new server room with a new KVM solution (Raritan Paragon 2) we had difficulty getting the Sun servers to display on the KVM. Keyboard seemed to work fine but the display would not. The issue seems to be with the default screen display resolution used on the… Read more »
Changing the default Horde theme for Plesk
On my Plesk installation the Horde themes are installed to /usr/share/psa-horde I downloaded the wps_sober theme. To install it: – extract all the files of the archive to the /usr/share/psa-horde/ directory (Extract files directly to that dir, not to /usr/share/psa-horde/wps_sober !)– if you want your users to use this theme by default, edit the file… Read more »
Determine Linux Operating System Version
To determine the Operating System/Distribution version from the command line / terminal interface. How to tell the Ubuntu version? # lsb_release -rRelease: 7.10 How to tell the Slackware version? # more /etc/slackware-versionSlackware 10.2.0 (x86_64) How to tell Red Hat / CentOS version? #more /etc/redhat-releaseRed Hat Enterprise Linux AS release 4 (Nahant Update 5) How to… Read more »
Freecom Media Player with Samba
Instructions here for setting up Samba with the Freecom Network Media Player. http://www.lauracowen.co.uk/blog/2008/01/13/setting-up-a-freecom-media-player-with-ubuntu/
Sticky Bit
From Linux Format magazine. The Sticky Bit:“changes the rules about who can delete files. If the sticky bit is set on a directory, files within it can be deleted only by their owner, the directory’s owner or the superuser.”
Default Gateway Location
Centos and Red Hat:/etc/sysconfig/network NETWORKING=yesNETWORKING_IPV6=noHOSTNAME=myhostGATEWAY=123.123.123.1 Ubuntu/Debian:/etc/network/interfaces gateway 192.168.1.254 Command Line: route add default gw 192.168.1.254