Tech Meal

[PHP] - Connect to Unix / Linux server using SSH from Windows PC

2009-08-30T16:01:00.009+05:30

Setting up public key authentication:

1.  Login to the unix server you want to connect using putty.
2.  mkdir .ssh (there is a dot before ssh)
3.  cd .ssh
4.   ssh-keygen -t rsa -f mykey
5.  Enter passphrase as test
6.  ls -al -> you will find two files mykey , mykey.pub
7.  cat mykey.pub >>authorized_keys
8.  cat mykey
9.  Copy what you get on screen to notepad and save it as "c:\mykey" (within quotes)
10.  cat mykey.pub
11.  Copy what you get on screen to notepad and save it as "c:\mykey.pub" (within quotes)

PHP Code:

<?php

      // Functions to connect to Unix Server using SSH

      $methods = array(
      'kex' => 'diffie-hellman-group1-sha1',
      'client_to_server' => array(
      'crypt' => 'aes256-cbc',
      'comp' => 'none',
      'mac' => 'hmac-sha1'),
      'server_to_client' => array(
      'crypt' => 'aes256-cbc',
      'comp' => 'none',
      'mac' => 'hmac-sha1'));

      $callbacks = array('disconnect' => 'my_ssh_disconnect');

      // Function to run a command on the unix server

      function run_cmd($ssh_host, $user_name, $keyfilename, $ssh_command)
      {
          $connection = ssh2_connect($ssh_host, 22, $methods, $callbacks);
          if (!$connection) die('Connection failed');
          if (ssh2_auth_pubkey_file($connection, $user_name, $keyfilename.".pub", $keyfilename, 'test'))
          {
            echo "Public Key Authentication Successful as user: $user_name
";
          }
          else
          {
            die('Public Key Authentication Failed');
          }

          $stream = ssh2_exec($connection, $ssh_command);
          $i=0;
          stream_set_blocking($stream, true);
          $line = stream_get_line($stream, 1024, "\n");
          while (!feof($stream))
          {
                  echo $line.'
';
                  $line = stream_get_line($stream, 1024, "\n");
                  $i++;
          }
          echo "Count : ".$i;
          flush();
          unset($stream);
      }

      function my_ssh_disconnect($reason, $message, $language)
      {
            printf("Server disconnected with reason code [%d] and message: %s\n",
            $reason, $message);
      }

      // Main Code

      $user_name = "USERID";
      $keydir = "c:\\";
      $search_string = 'needle';
      $keyfilename= $keydir.'mykey';
      $ssh_host = "foo.bar.com";
      $ssh_command = 'grep "'.$search_string.'" /haystack/*.log';
      run_cmd($ssh_host, $user_name, $keyfilename, $ssh_command);

      $ssh_command = 'ls -al';
      run_cmd($ssh_host, $user_name, $keyfilename, $ssh_command);
?>

NC10 MAC OS X 10.5.7 - External Wi-Fi Works!!!

2009-07-12T03:57:00.005+05:30

1. Download MSIWindosx86.iso (Google search)
2. Download 10.5.7 Combo update (http://support.apple.com/downloads/Mac_OS_X_10_5_7_Combo_Update)
3. Buy http://www.meritline.com/wireless-mini-usb-2-pen-drive-adapter---p-33917.aspx for $10.99
4. Download Realtek driver version 1309 (http://www.realtek.com.tw/downloads/downloadsView.aspx?Langid=1&PNid=1&PFid=1&Level=6&Conn=5&DownTypeID=3&GetDown=false&Downloads=true#367)
5. Download keyboard and touchpad drivers (http://rapidshare.com/files/221309198/VoodooPS2Controller.pkg.zip)
6. Download other Drivers (http://rapidshare.com/files/233390302/Samsung_NC10_10.5.7_Post_Update_Patches.pkg.zip)
7. Install MSIWindosx86
8. Install OS X 10.5.7 combo update and before you restart, install VoodooPS2Controller driver
9. After restart, Install Samsung_NC10_10.5.7_Post_Update_Patches
10. Connect your USB and then Install the wifi driver

Everything except internal mic, internal ethernet, internal wifi will work

Note: You can play with few other drivers from this site - if wrongly installed, it'll crash your OS
http://www.rapidshare.com/users/4GZUA1

Quad Boot / Penta Boot on Samsung NC10 --> Windows XP - Windows 7 / Vista - Mac OS X - Linux

2009-06-23T08:55:00.032+05:30

I've tried more than 100 times to get Quad Boot / Penta Boot work, and the following works consistently on Samsung NC 10.
I recommend you to take backup of all important data you will need, before you start your quad boot setup.

What you'll need?
1. Samsung NC10 (Netbook)
2. External DVD Drive (USB)
3. XP Operating System CD (Optional)
4. Windows 7 DVD / Windows Vista DVD
5. OSX DVD ( MSIOSX86.ISO or NC10_JaS.OSx86.10.5.6.Intel.SSE2.SSE3_Mysticus)
6. Ubuntu / Kubuntu Live CD
7. USB Flash Drive / Blank CD

Steps:
1. Download GParted (http://gparted.sourceforge.net/download.php)
2. Create a bootable USB of GParted (http://gparted.sourceforge.net/liveusb.php) or create a bootable CD of GParted
3. After creating bootable USB drive (or CD Drive) boot from the USB (or CD)

4. GParted will display 160 GB as a two partitions. Delete the second partition.

5. Right Click and Resize the first partition. Set it to 10 Gig (or whatever you want for XP)
6. Now you should see the remaining as unallocated partition. Click new and create a NTFS Primary partition for Windows 7 or Vista (I set this as 15 GB)
7. Click on New and create a HFS+ Primary partition for Mac OSX
8. Click on New and create an Extended partition for the remaining space. We will be splitting this later for linux and other drives as needed.
9. Click on New and create a ext3 Partition in the extended partition for Linux.

10. Apply Changes.
Note: You can have a maximum of 4 primary partitions. You can make 3 Primary partitions and 1 extended partition, although the extended partition can then be split to multiple partitions again.
11. Right Click on the first partition (XP) >> Manage Flags >> Uncheck Boot & Check Hidden
12. Reboot with Windows 7 / Vista DVD and Install Windows 7 / Vista in the second partition
13. After installation, reboot to GParted, Right Click on the first partition (XP) >> Manage Flags >> Check Boot & Uncheck Hidden

14. Reboot with OS X DVD and Choose Disk Utility from the Utilities menu.

15. Select the OS X partition, goto Erase tab and select Mac OS Extended (Journaled) and click Erase
16. Quit Disk Utility (Alt + Q) and proceed with installation. Click on Customize and check NC10 pacakage and Do not check Cleanup. Proceed with installation and reboot.
17. The system may reboot continuously. Press 'F8' Key and in the boot command type in "cpus=1 -v -f -x" then try "cpus=1 -v -f".
Once you are in OS X, open terminal and type sudo -s
Edit the /Library/Preferences/SystemConfiguration/com.apple.Boot.plist file as follows:
Under Kernal Flags, in the strings tag enter cpus=1 then save and exit

18. Reboot with Linux CD and install it on extended partition. I've used Ubuntu and Kubuntu installation.
19. After installation, Restart into GParted.
20. You can configure (could be a time consuming process) your favorite boot loader by setting the boot flag on the partition. For Example, if you want to use OS X Darwin -> Right Click OS X patition >> Manage Flags and check Boot.

Hope this tutorial helps!!!

[PHP] - [Upload Multiple Images]

2006-08-02T11:33:00.000+05:30

[Initial Setup]
1. Create a folder "uploads" on the server
2. Create file.php and upload.php and use the code below

[file.php]
<form enctype="multipart/form-data" action="upload.php" method="post">
Image1: <input name="userfile[]" type="file" /><br />
Image2: <input name="userfile[]" type="file" /><br />
Image3: <input name="userfile[]" type="file" /><br />
Image4: <input name="userfile[]" type="file" /><br />
<input type="submit" value="Upload" />
</form>

[upload.php]
<?php
$success = 0;
$fail = 0;
$uploaddir = 'uploads/';
for ($i=0;$i<4;$i++)
{
   if($_FILES['userfile']['name'][$i])
   {
    $uploadfile = $uploaddir . basename($_FILES['userfile']['name'][$i]);
    $ext = strtolower(substr($uploadfile,strlen($uploadfile)-3,3));
    if (preg_match("/(jpg|gif|png|bmp)/",$ext))
    {
     if (move_uploaded_file($_FILES['userfile']['tmp_name'][$i], $uploadfile))
     {
     $success++;
     }
     else
     {
     echo "Error Uploading the file. Retry after sometime.\n";
     $fail++;
     }
    }
    else
    {
    $fail++;
    }
   }
}
echo "<br> Number of files Uploaded:".$success;
echo "<br> Number of files Failed:".$fail;
?>

[PHP - MYSQL] - Connect to database function

2006-06-16T15:14:00.001+05:30

1. Create a file dbconnect.php with the code below (Paste this code and change the values in blue as you need)
<?PHP
function exec_query($sql)
{
$server = "server_name";
$username = "user_name";
$pwd = "pwd";
$db_name = "db_name";
$link = mysql_connect($server,$username,$pwd) or die (mysql_error());
mysql_select_db($db_name) or die (mysql_error());
$result=mysql_query($sql) or die (mysql_error());
mysql_close($link);
return $result;
}
?>

2. The code below shows how to use this across files
<?PHP require("dbconnect.php") ?>
<?PHP
$sql = "Select * from tbl_name";
$result = exec_query($sql);
while($row = mysql_fetch_array($result))
{
echo $row[0];
echo $row[1];
}
?>

PHP Random String Generator function

2006-06-13T23:39:00.003+05:30

function random_gen($length)
{
  $random= "";
  srand((double)microtime()*1000000);
  $char_list = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
  $char_list .= "abcdefghijklmnopqrstuvwxyz";
  $char_list .= "1234567890";
  // Add the special characters to $char_list if needed

  for($i = 0; $i < $length; $i++)
{
     $random .= substr($char_list,(rand()%(strlen($char_list))), 1);
}
return $random;
}
$random_string = random_gen(10); //This will return a random 10 character string

Share it with others on:

[GMAIL] - [PHP] - Send email using PHP with Gmail

2006-06-10T23:34:00.005+05:30

[ This explains how to use gmail to send emails in php using PHPMailer]

1	Download PHPMailer from http://phpmailer.sourceforge.net
2	Extract to folder phpmailer
3	Create a file email.php
4	Paste this code and change the values in blue as you need (I modified the sample code given on the PHPMailer homepage) require("phpmailer/class.phpmailer.php"); $mail = new PHPMailer(); $mail->IsSMTP(); // send via SMTP IsSMTP(); // send via SMTP $mail->SMTPAuth = true; // turn on SMTP authentication $mail->Username = "username@gmail.com"; // SMTP username $mail->Password = "password"; // SMTP password $webmaster_email = "username@doamin.com"; //Reply to this email ID $email="username@domain.com"; // Recipients email ID $name="name"; // Recipient's name $mail->From = $webmaster_email; $mail->FromName = "Webmaster"; $mail->AddAddress($email,$name); $mail->AddReplyTo($webmaster_email,"Webmaster"); $mail->WordWrap = 50; // set word wrap $mail->AddAttachment("/var/tmp/file.tar.gz"); // attachment $mail->AddAttachment("/tmp/image.jpg", "new.jpg"); // attachment $mail->IsHTML(true); // send as HTML $mail->Subject = "This is the subject"; $mail->Body = "Hi, This is the HTML BODY "; //HTML Body $mail->AltBody = "This is the body when user views in plain text format"; //Text Body if(!$mail->Send()) { echo "Mailer Error: " . $mail->ErrorInfo; } else { echo "Message has been sent"; } ?>
5	Open the file class.smtp.php in phpmailer directory
6	Paste this code $host = "ssl://smtp.gmail.com"; $port = 465; before the line 104 #connect to the smtp server Hint: Search for #connect
7	Open this page in browser and it will send the email using GMail.
	Hint: When you want to email the details from a form, set the variables using the form variables. eg. $mail->Username=$_POST['email']

Configuring Apache - PHP - MySQL on Windows (WAMP Configuration)

2006-06-06T14:20:00.002+05:30

[Download and Install]

1	Download Apache, PHP, MySQL
2	Install Apache to its default location and make sure IIS is stopped during installation.
3	Extract PHP to C:\PHP folder
4	Install MySQL
5	Create a folder C:\MyWebsite (This is the folder where you want your website to be)

[Setup php.ini]

1	Goto C:\PHP folder and rename php.ini-dist to php.ini and open this file.
2	Search for "doc_root =" or goto line# 454 and change this to doc_root = "C:\MyWebsite\"
3	Goto Line# 461 and change this to extension_dir = "C:\PHP\ext"
4	Goto Line# 598 and change it to extension=php_mysql.dll

[Setup httpd.conf]

1	Open C:\Program Files\Apache Group\Apache2\conf\httpd.conf file
2	Goto Line# 120, change this to Listen 8080
3	Goto Line# 228 and change it to DocumentRoot "C:/MyWebsite"
4	Goto Line# 238 and change it to <Directory "C:/MyWebsite">
5	Goto Line# 321 and change it to DirectoryIndex index.html index.html.var index.php index.htm
6	Goto Line# 515 and remove the default ScriptAlias paste the following. ScriptAlias /php/ "c:/php/" AddType application/x-httpd-php .php .php5 Action application/x-httpd-php "/php/php-cgi.exe" SetEnv PHPRC "C:/php"

[Testing Your Configuration]

1	Goto C:\MyWebsite and create a file index.php
2	Open the file and paste this code and save it. <?PHP phpinfo(); ?>
3	Open your browser and type http://localhost:8080/
4	You should see the complete details of your PHP setup otherwise recheck your configuration.