This script will allow you to see the top user agents, urls, IPs for your log files: Script name: ls-httpd #!/bin/bash # Usage # ls-httpd type count # Eg: # ls-httpd url 1000 # will find top URLs in…
Script Details This is example will show you how to disable folks that have a password older than x number of days AND / OR have not logged in for X number of days Requirements ActiveRoles Management Shell (free) Powershell…
Here’s a bash kill liferay script! This should kill any running liferay or liferay social office on a linux system. Open up your favorite editor and paste this in #!/bin/bash # #Script name: kill_liferay.sh # #Purpose: To kill any running…
To Gzip files older than one day place this in a cronjob: TODAY=`date +”%Y-%m-%d”` for logfile in ; do # grab the %Y-%m-%d out of the name DTS=${logfile:(-14):10} if [ $DTS != $TODAY ]; then # compress in place gzip…
to kill orphaned httpd processes create a script called killhttpd.sh with the following code #!/bin/bash for pid in `ps -C httpd|sed -e ‘s/^\ \+//g’ | grep httpd|awk ‘{print $1}’` do kill $pid done
to move mysql on freebsd without using a dump file follow these steps: stop mysql copy /var/db/mysql to its new location chown -R mysql:mysql modify and add line mysql_dbdir=”“ modify and change mysql_dbdir=”/var/db/mysql” to the new location of…
How can you rename a mysql Schema? easy! Create the new schema In this example the new schema is called my_new_schema mysqladmin -u root -p create my_new_schema Dump the old schema and pipe in to new schema mysqldump -u root…
A ssh port forwarding example would be to map a remote host’s 3306 port to your local machines 3306 port over ssh. Remote Host: 192.168.0.1 Your Host: localhost To port forward a mysql connection on a remote host to your…
perl replace text in multiple files perl -pi -e ‘s~OLDTEXT~NEWTEXT~g’ /path/to/filenames/* Alternative (to avoid escaping slashes): perl -pi -e ‘s|w/|with|g’
how to convert ascii mysql db to utf8 ? I had a MyISAM mediawiki 1.11.0 database that needed to be utf8 to upgrade to the latest version. Before I could upgrade it I had to convert it to utf8. Here’s…
