Logo Background RSS

» sps

  • Enable caching in MySQL
    By on February 2nd, 2009 | 1 Comment1 Comment Comments

    Log into your mysql

    $ mysql -u root –p

    Output:

    Enter password:

    Welcome to the MySQL monitor. Commands end with ; or \g.

    Your MySQL connection id is 16 to server version: 4.1.15-Debian_1-log
    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

    mysql>

    Now setup cache size 32Mb:
    mysql> SET GLOBAL query_cache_size = 33554432;    
    
    Query OK, 0 rows affected (0.00 sec)
    mysql> SHOW VARIABLES LIKE 'query_cache_size';

    Output:

    +——————+———-+

    | Variable_name | Value |

    +——————+———-+

    | query_cache_size | 16777216 |

    +——————+———-+

    You can setup them in /etc/my.cnf (Red Hat) or /etc/mysql/my.cnf (Debian) file:
    # vi /etc/my.cnf
    Append config directives as follows:

    query_cache_size = 33554432
    query_cache_type=1
    query_cache_limit=2096576
    
                            
  • Using SSH by Putty
    By on December 12th, 2008 | 1 Comment1 Comment Comments

    Putty is a free software application for Windows 95,98, XP, & Vista which can be used to make a SSH Connection. You can find the application at Click here

    http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe

    1. Download it on your pc.
    2. Double-click on the putty.exe program to open.
    3. Next fill in the appropriate SSH settings for your service:
    Putty

    Putty

    Next fill in the appropriate SSH settings for your service:

    Host Name:

      • Host name

        Host name

        • (gs) Grid-Service – s#####.gridserver.com or mt-example.com
        • (dv) Dedicated-Virtual -mt-example.com or xxx.xxx.xxx.xxx
        • (ss) Shared-Server – mt-example.com or xxx.xxx.xxx.xxx
      • Port: 22
        port 22

        port 22

      • Connection Type: SSH

        Connection Type

        Connection Type

      • Next click Open to start the SSH Connection:

      putty open

      putty open

      Once the SSH Connection is open you should see a terminal prompt saying login as: Please provide your full username:

    Login

    Login Screen

      • (gs) Grid-Service – The default should be serveradmin@mt-example.com, however you may also login as username@mt-example.com.

        NOTE:

        Please make sure SSH is enabled for the user. SSH can be enabled from within the (ac) AccountCenter.

      • (dv) Dedicated-Virtual – You may login as the root user, or as a domain’s FTP user which has SSH access enabled
      • Next provide your password. Please note that you will not see any typing such as *** when providing your password. Once you hit enter you should now be connected to your service.

      Common SSH Command

  • Install Skype API Plugin for Pidgin in Ubuntu
    By on November 1st, 2008 | No Comments Comments

    This is the Skype API Plugin for Pidgin/libpurple/Adium. If you’re already running Skype, you can have your Skype contacts displayed with your Pidgin/libpurple/Adium contacts. It is intended as a complete replacement for the Skype user interface, hopefully everything you can do in Skype you can do with this plugin.

    Install Skype API Plugin for Pidgin in Ubuntu

    First you need to download the plugin using the following command

    wget http://eion.robbmob.com/skype4pidgin.deb

    Now you should have skype4pidgin.deb package.Install this .deb package using the following command

    sudo dpkg -i skype4pidgin.deb

    or you can download the following libskype.so file to the plugins directory, normally /usr/lib/purple-2/ or ~/.purple/plugins

    For 32 bit users download this

    wget http://eion.robbmob.com/libskype.so

    For 64 bit users download this

    wget http://eion.robbmob.com/libskype64.so

    This will complete the installation.After installation you need to restart Pidgin! You will then have a skype option enabled.

  • How to use SSH Via HTTP Proxy using Corkscrew in Ubuntu
    By on October 30th, 2008 | 1 Comment1 Comment Comments

    If you want to ssh your vps server or your home computer from your work place (assuming you are using http proxy).You need to use Corkscrew.

    corkscrew is a simple tool to tunnel TCP connections through an HTTP proxy supporting the CONNECT method. It reads stdin and writes to stdout during the connection, just like netcat.

    It can be used for instance to connect to an SSH server running on a remote 443 port through a strict HTTPS proxy.

    Install corkscrew in ubuntu using the following command

    sudo aptitude install corkscrew

    This will complete the installation.

    Configue corkscrew

    If your HTTP proxy uses authentication, then you’ll need to tell it about the username and password to use This is where the concept of ‘auth-file’ comes into play. All you have to do is put your username & password, separated by a colon, into a textfile. Once you’ve done this, you just have to tell corkscrew where to find the auth-file. Create a file called .corkscrew-auth in your home directory

    $touch .corkscrew-auth

    $gedit .corkscrew-auth

    and place your username and password in the following format

    username:password

    Save and exit the file.

    Configure ssh For Tunneling

    Now we’ll tell ssh what to do when connecting to all or specific hosts. Open up ~/.ssh/config (that’s /home/yourusername/.ssh/config) in your favourite text editor (gedit,nano,vim etc)

    $gedit /home/yourusername/.ssh/config

    and add the following lines

    Host *

    ProxyCommand corkscrew proxyhostname proxyport %h %p /home/username/.corkscrew-auth

    Save and exit the file

    Note: replace proxyhostname and proxyport with the equivalents for your network.

    Note: you won’t need to add the last section, ‘/home/username/.corkscrew-auth’, if your HTTP proxy doesn’t use authentication.

    What we’ve just told ssh to do is for all hostnames (’Host *’), use the following proxy command to route the connection.If you want more secure connections you can also list of hosts.

    Corkscrew Syntax

    corkscrew proxy proxyport targethost targetport [ authfile ]

    proxy – This is the name of the host running the HTTP proxy.

    proxyport – This is the port on which to connect on the proxy.

    target – This is the host to reach through the proxy.

    targetport – This is the port to connect to on the target host.

    Test your SSH connection

    ssh serverip

  • Hacking Windows Administrator Password (with good intentions) Using Linux
    By on October 29th, 2008 | 1 Comment1 Comment Comments

    In case you or a friend of yours has forgotten his/her Windows administrator password, there’s no need to panic as you can easily hack it by resetting the password provided you have the right tools. One way to do this is to use Linux as your knight in shining armor.

    I’m going to show you how you can smoothly hack a Windows Administrator password using Linux. You will only need a Live CD, and for this example, we will utilize Ubuntu. Also, I assume that you have the basic knowledge on using the Linux command line.

    Now let’s start hacking:

    The first thing you have to do is of course load your Ubuntu Live CD. You don’t have to install it, just boot straight into the desktop. Then, install a program called ‘chntpw’:

    $ sudo apt-get install chntpw

    After successfully installing ‘chntpw’, you have to access the Windows NTFS partition by mounting it and allowing read/write support. A good tutorial on how to do this can be found HERE.

    After that, use your command line skills by navigating to ‘WINDOWS/system32/config’.

    Once inside the ‘config’ directory, issue this command:

    $ sudo chntpw SAM

    A long display of information will follow. Just ignore them.

    Once you are prompted to reset the password, it is recommended to leave the password blank with an asterisk *. Reboot, and you can now login to freakin’ Windows.

  • Win NTFS Partitions R/W support made easy in Ubuntu
    By on October 29th, 2008 | 1 Comment1 Comment Comments

    This program allow you to easily configure all of your NTFS devices to allow write support via a friendly gui. For that use, it will configure them to use the open source ntfs-3g driver. You’ll also be able to easily disable this feature.

    Current Stable 0.5.5

    Project Home page :- http://flomertens.free.fr/ntfs-config/

    Requirements

    windows with Feisty dual-boot installation and external Hard Disk (Optional)

    Install NTFS-config in Ubuntu Feisty

    Now You can install NTFS-config from Ubuntu Feisty repositories

    sudo apt-get install ntfs-config

    This will install all the required packages for ntfs-config including ntfs-3g

    Using Ntfs-Config

    If you want to open this application go to Applications—>System Tools—>NTFS Configuration Tool

    Now it will prompt for root password enter root password and click ok

    It will show the available NTFS partition as follows in this example /dev/sda1 in NTFS partition

    You need to select the partitions you want to configure,add the name of the mount point and click on apply.In this example i have ticked the check box next to /dev/sda1 and click under mount enter the name you want to use i have entered as windows now the mount point showing as /media/windows and click on apply.

    Select the NTFS Write support which is suitable for you i.e internal or external

    In this example i have tick the check box next to Enable write support for internal device because i am using dualboot with windows.If you are using external hard drive select external option and click on ok

    Once it finished you should see the mount point on your desktop as follows

    You can see the windows mount point files as follows

    If you want to unmount you should be root to unmount and then right click on mount point select Unmount Volume