In the following tutorial i will describe the steps to optimize the performance of a MySQL database with the mysqltuner script:

Step1. Download the mysqltuner script:

cd /usr/bin
 wget http://mysqltuner.pl/mysqltuner.pl
 chmod +x mysqltuner.pl

Step2.  Run mysqltuner:

root@deb:~# /usr/bin/mysqltuner.pl

Enter the root as username and the  password and you will get a output like this:

root@deb:~# /usr/bin/mysqltuner.pl

>>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
>>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
>>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.58-1~dotdeb.1
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

Continue Reading…

Show Disk Usage with NCDU

Valic —  October 14, 2011 — 1 Comment

NCDU is a disk usage analyzer with an ncurses interface, aimed to be run on a remote server where you don’t have an entire gaphical setup, but have to do with a simple SSH connection.

ncdu aims to be fast, simple and easy to use, and should be able to run in any minimal POSIX-like environment with ncurses installed.

Installation:

[php]apt-get </code><code>install</code> <code>ncdu[/php]

Issuing ncdu inside the folder that you want to check will open a cool ncurses interface, really easy to use.

ncdu usage:

  •   -h                         This help message
  •   -q                         Quiet mode, refresh interval 2 seconds
  •   -v                         Print version
  •   -x                         Same filesystem
  •   –exclude PATTERN          Exclude files that match PATTERN
  •   -X, –exclude-from FILE    Exclude files that match any pattern in FILE

Screenshots:

Continue Reading…

For login into the VMware console are two ways. One through an SSL connection (port 8333) and second without SSl (port 8222).
Without SSL you can login only from the local machine which wmvare server is installed. Each connection attempt from a remote host to the VMware Server console on port 8222 will be redirected to the SSL channel to port 8333.

In this article I will show you how to disable SSL protocol and redirect to port 8333 in VMware Server 2.0 in Debian Squeeze.

Step1.  Shut down the vmware server:

[php]/etc/init.d/vmware stop
/etc/init.d/vmware-mgmt stop[/php]

Step2. Do a copy of  existing proxy.xml file and modify proxy.xml file:

[php]cp /etc/vmware/hostd/proxy.xml   /etc/vmware/hostd/proxy.xml_bak[/php]

Now open the proxy.xml file and replace all occurrences of the values “httpsWithRedirectwith  “httpAndHttps”

Step3.  Now you can start up vmware server:

[php]/etc/init.d/vmware start
/etc/init.d/vmware-mgmt start[/php]

Enjoy!

3 Ways to Secure SSH Server

Valic —  October 7, 2011 — Leave a comment

For Debian Squeeze configuration file is located in /etc/ssh/sshd_config and at the  end of all the changes that will need to restart the server.

1. First step to one more secured ssh server is:

Change the standard port for ssh server

The first  safety rule is to change the default port because the majority of automated tools to perform brute force or dictionary attacks right at this port.

In the sshd_config file change the port directive to anoter port. I recomend to use a port above 1024.

Port 22

Will become:

Port 22222 or some other port

2. The second change is:

Disable root access

Continue Reading…

I always had problems when i upgraded my wordpress.
So I made ​one script that automatically does this for me and i’ll share that with you.
With this script you can install or upgrade your wordpress install.

[php]

#!/bin/bash
#
# Homepage: http://www.debian-tutorials.com
# Email: contact@debian-tutorials.com
# Bash script to download and install or upgrade wordpress to specified directory.
install_wp ()
{
cd ~</pre>
<!–more–>
<pre>
mkdir wordpress
cd wordpress
wget https://wordpress.org/latest.tar.gz –no-check-certificate;
echo "Where would you like your new WordPress install to be located? Please Type the location(Eg:/var/www/) and press [ENTER]: "
read wordpress_dir
echo "Installing WordPress to $wordpress_dir";
if [ ! -d "$wordpress_dir" ]; then
mkdir $wordpress_dir
fi
tar -zxvf latest.tar.gz -C $wordpress_dir
}

clean_up ()
{
cd ~/wordpress
rm latest.tar.gz
cd ~
rmdir wordpress
cd $wordpress_dir/wordpress
mv *.* $wordpress_dir
mv wp-admin $wordpress_dir
mv wp-content $wordpress_dir
mv wp-includes $wordpress_dir/
rmdir $wordpress_dir/wordpress
cd $wordpress_dir/wp-content
mkdir uploads
chmod 777 uploads -R
cd $wordpress_dir
touch $wordpress_dir/.htaccess
chmod -v 666 .htaccess
echo "Wordpress is now Installed to" . $wordpress_dir . "Enjoy!"
}

update_wp ()
{
day=`date +%Y_%m_%d`
cd ~
mkdir wordpress_tmp
cd wordpress_tmp
wget https://wordpress.org/latest.tar.gz –no-check-certificate;
echo "In what directory does WordPress already exist, that you would like updated? Please Type the location(Eg:/var/www/) and press [ENTER]: "
read update_dir
tar -zxvf latest.tar.gz -C $update_dir
cd ~/wordpress_tmp
rm latest.tar.gz
cd ~
rmdir wordpress_tmp

cd $update_dir
cp $update_dir/ $update_dir/../wordpress_backup_$day -R
cp $update_dir/../wordpress_backup_$day/wp-config.php $update_dir

# Go to backup directory and remove the new install of WP
cd $update_dir/../wordpress_backup_$day
rm wordpress -rf

# back to the update directory
cd $update_dir/wordpress

#remove wp-admin and wp-includes
cd $update_dir
rm wp-admin -rf
rm wp-includes -rf

cd $update_dir/wordpress
mv wp-admin $update_dir
mv wp-includes $update_dir
#remove the extra updated directoroies
rm $update_dir/wordpress/ -rf

echo "Upgrade complete! Backup can be found in $update_dir/../$update_dir_backup_$day"
}
if ["$(id -u)" = "0"]; then {
echo "You are root we will continue" 2>&1
install_wp
clean_up
exit
}
else
{

read -p "If the location you want to install wordpress to requires Root access, Please press ‘N’ and run this script again as root, or ‘Y’ to run the script without root (y/n)? "
[ "$REPLY" == "n" ] & exit ||
[ "$REPLY" == "y" ] &
echo "Do you wish to install WordPress [Yes] or update [No]? Type 1 or 2 and press [ENTER]"
select yn in "Yes" "No"; do
case $yn in
Yes ) install_wp && clean_up && break;;
No ) update_wp && break;;
esac
done
}
fi
exit 1;

[/php]

You can download the script from here: Install or Upgrade wordpress bash script

Enjoy!

Page 20 of 44« First...10...16171819202122232425...40...Last »