Wednesday, April 25, 2012

How to : Connect MYSQL and phpMyAdmin


Due to security measures you cannot connect phpMyAdmin to MYSQL "out of the box". You require to set MYSQL root password first!

After installing XAMPP,if you try to connect to MYSQL using phpMyAdmin from Tools menu, you may be greeted with this message  Access denied for user: 'root'@'localhost' (Using password: NO)
The following steps will help to resolve this problem.
1. First Set the MYSQL root password from command line
2. Then edit "config.inc.php" file
3. Take some additional steps

Step 1.Set the MYSQL root password from command line
Suppose XAMPP is installed in c:\XAMPP
Switch to folder c:\XAMPP\MYSQL\bin
Run the following command
$ MYSQL -u root -p
you will be in MYSQL prompt. It clearly indicates that the  password was set initially as blank. Now the password need to be set first. Lets set the password as "linux".
2) First switch to MYSQL database. issue the following command
MYSQL> use MYSQL;
3) In order to change password for user "root", enter the following update command:

MYSQL> update user set password=PASSWORD("linux") where User='root';
4) Then run following commands to reload the privileges
MYSQL> flush privileges;
MYSQL> quit

Up to this stage we have set the MYSQL root password to "linux" from blank password. Now we have to tell about this change to config.inc.php file.
Step 2. Edit "config.inc.php" file
Switch to folder C:\xampp\phpMyAdmin
open config.inc.php file in text editor,go to block which has comment /* Authentication type and info */ .There you can set the root password as follows
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'linux';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
 Restart the XAMPP. Hope you will be able to connect to phpMyAdmin (tools-> phpMyAdmin)

3. Additional Steps: 
Check seurity of database

3.1. Click on Security tab to confirm that MYSQL root is protected. (http://localhost/security/). you should now able to see following.
The MYSQL admin user root has no longer no password                :    Secure
Done! Not only you get rid off from error but also secure MYSQL too.

Allow MYSQL to import larger sized file
3.2. By default MYSQL permit you to import file size upto 8MB .(MYSQL maximum import ax 8,192KiB). Must get rid off at this initial stage itself
Open php.ini file from c:\xampp\php folder and search for "post_max_size ". Change the value to 32.

Happy MYSQLing with phpMyAdmin

Sunday, June 12, 2011

Drive letter to Tape drive? How to assign drive letter to Tape drive in MS Windows?

Normally you cannot assign drive letter to Tape drive. By using LTFS, you will be able to assign drive letter to LTO tape drive.

Users are dealing with the media like Hard disk, CD/DVD/BD disks, floppy disks etc. In MS windows environment, a Drive Letter is assigned to accesses these media. In *NIX environment, these drives get access by mounting to mount point.

Here arises the question. Why cannot we use Tape drive in the same manner as we use other drives i.e by assigning the drive letter in MS Windows? Tape drive is one of the oldest storage mediums, while USB/SSD based drives are recent ones. One can access USB/SSD by assigning drive letters, but for tape it cannot be done (normally) …why?

To get answer,consider the following points:

(1) The way data being stored thus accessed on Tape drive is different then HDD/CD/DVD. In tape drive, data access is Linear or Sequential while in other drives it is Random.

(2) The way Meta information, for data access purpose is stored on the media. While HDD, CD/DVD and other media starts storing the information about their files and folders at beginning of disk (In case of HDD it may be in form of FAT/NTFS area, Root directory etc and in case of CD/DVD it is in form of TOC in lead-in area). This arrangement facilitates random access, thus assigning drive letter serves its purpose of Single point of reference. Tape doesn't have such Meta information for all of its data at the beginning. The file name, location etc information of file and folders is spread out, throughout the tape, stored normally at the end of each data block. To get list of files and folders in tape, all data blocks need to be accessed that too in linear way and then at the end of each data block, such information can be found. There is no such consolidated index of stored data in tape , no Single point of reference. Only tape backup/restore software creates such information after scanning the whole tape and stores in their own database..Above all, being the proprietary in nature, the tape drive get accessed and controlled by their special drivers and application software, which only can communicate and control tape drive. Windows cannot access tape as Nativity as it accesses other drives, thus eliminates the drive letter assignment.

The Tape industry is quite aware about it since long. Finally, the open source"Linear tape file system", LTFS is arrived in March 2011. Note that LTFS is not a panacea , it has limitations too: It works with LTO drivers only , that too with LTO-5 onward in full fledge manner. LTFS permits user to assign a drive letter to tape drive in windows and access the tape data in same manner as of HDD, CD/DVD or any other random access drive.

See what wikipedia writes about LTFS (hhttp://goo.gl/ilmmf )

" The Linear Tape File System is a method of storing file metadata on a separate part of the tape. This makes it possible to copy and pastefiles or directories to a tape as if it were just like another disk, but does not change the fundamental sequential access nature of tape."

So if you have tape drive which is not LTO, you have to access it in the same way as you are doing now. But if you are planning to go for LTO-5 and onwards you can access it by assigning drive letter to it using LTFS.

Post Your Comments....

Thursday, November 18, 2010

Know about Light Peak

Light Peak is often termed as "USB3 replacement" or USB 3 Killer. A recent announcement by Intel about early arrival of Light peak interface in mid 2011 raises the hopes of its take-off.

Some facts about Light peak
What is Light peak?
Over a period of time, many types of interfaces like Serial, parallel, SATA, SCSI , USB etc got evolved. These interfaces or buses have many limitation mainly speed and compatibility. Now time has reached where all these interfaces can be replaced with some new generation interfaces. Light peak is one of such intended candidate.
Light peak is an interface based on optical technology, developed and promoted by Intel/Apple, capable to carry data at the rate of 10gigabits/second in both directions.

Why light peak termed as USB 3.0 killer ?

It’s all because of Intel’s stand on USB 3.0 and Light Peak, as of now.
Though USB 3.0 (speed 4.8Gbits/s or 3.2 MB/sec) is almost 10 times faster than USB 2.0 (480 Mbit/s & USb 1.0 is 1.5 Mbit/s ) , Intel has yet to implement it in its various chipset family of motherboards. That’s why majority of modern PCs which are based on Intel chipsets and even Apple’s Macbook has not equipped with USB 3.0 directly.(Though , using PCIe cards one can add USB 3.0 using add-on card). Also many peripherals like External HDD, tape devices, Printers do not get much benefit out of USB 3.0 due to their own technological reasons. Intel is already serving the need of higher speed by providing e-SATA interface hence eclipsing the demand of USB 3.0.Now Light peak is going to see light sooner which is 3 times faster than USB3.0 and capable to be 300 times faster in next decade , hence it is termed as USB 3.0 killer.(Details on USB 3.0: http://goo.gl/VV5Q )
The shining part of USB 3.0 is universally adoptability across the platforms ranging from PC to media players, its backward compatibility with USB 2.0 and 1.0 ,and its simplicity . USB interface is able to fulfill the most of the user’s need.

Point to note that Light peak and USB are not compatible with each other.

How fast Light peak is ?

If one has to express how fast light peak is , one may refer Intel which says " At 10Gb/s, you could transfer a full-length Blu-Ray movie in less than 30 seconds." http://goo.gl/MIUG

Salient features of Light peak

  1. Light Peak is based on fiber optic technology hence faster. Data delivery and transmission in fiber optics cable is much better, almost twice as compared to copper wire. The throughput of data is determined by the frequency which cable carries. More the frequency, more the throughput. Fiber optics supports much higher frequencies for data transfer. Additionally, by polarizing the light signals, more data can be sent using fiber optics.(Refer: http://goo.gl/YhOVf )
  2. Light peak supports cable lengths of up to 100 meters. Note that USB 3.0 support up 3 meters, USB 2.0 up to 5 meters, and USB 1 up to 3 meters.
  3. On performance parameter, Light Peak eclipses every other interface available in market as of now. It is as high as 10 Gbps, it is capable to upscale up 100 Gbps.USB 3.0 supports up to 4.8 Gbps, USB 2.0 , 480 Mbps and USB 1.0 is 1.5 Mbit/s.
  4. Light Peak is bi directional and hot pluggable. Support for Multiple protocols is another characteristic.
  5. Light peak is perceived as a single universal replacement for available buses like USB/SATA/e-SATA/Firewire/SCSI/HDMI etc.These buses posses limited transfer capabilities & requires multiple connectors which creates compatibility problems.
Questions with Light peak
  1. Can Light peak be single replacement of all interfaces or add one more in plethora of interfaces and cables?
  2. Is it going to be as simple as USB when comes to implementation?
  3. Optical cables are fragile and complex in handling, how nicely light peak will implement it?
  4. How would it affect the cost of PC, total cost of ownership etc?
  5. And last but not least why cannot both USB 3.0 and Light peak co-exist in user space?
Post Your Comments....

Friday, October 22, 2010

Simple Solution: Extract text from Protected PDF document

Just two stages : First convert PDF page in to TIFF image format and then run OCR software (Optical character recognition) over it to get a Text. Here is step by step guide by using freeware tools.

One of the common hurdles which many users face is “How to copy text from protected PDF file”?

When PDF file gets protected, the feature which permits to copy selected text and later paste it gets disabled.

One can get the text easily from protect PDF file . To achieve it, following two freeware required

  1. IrfanView from http://www.irfanview.com : Free for non-commercial use, 32-Bit graphic viewer
  2. SimpleOCR from http://www.simpleocr.com : Freeware OCR software

How to Do ?

Step 1: Open PDF document, open desired page and perform Screen Capturing. You can use print Screen key (Prt Scr) of keyboard. This key is situated in the same section where Scroll Lock and Pause/Break keys lies.

Step2: Open IrfanView , and press Control-V to paste the screen shot of PDF page. Alternatively, one may also click on "Edit" menu and choose "Paste" form it

Step 3: This step is optional but better if get performed. Select that area of image which contains the desired Text by dragging a box with the help of mouse.

Step 4. Again optional step: If box is drawn as mentioned in step 3, then click on "Edit" menu and choose “Crop selection”. It will remove unwanted stuff.

Note: Even If you have not perform steps 3 and 4, you can directly go to step 5

Step5: It is an important step: Press Ctrl + G here or click on "Image" menu and select “convert to Grayscale “. This operation will remove the color information from image and it will make it grayscale (similar to black and white)

Step 6: Now it’s time to save file. Click on "File" menu and select “Save as”. Here select “Save as” type as “TIFF”. Save it to desired path.

So up to this stage we have saved the image of entire page of Protected PDF file or Image from protected PDF file (from Step 3 and Step 4) into Grayscale TIFF file format, a must required input to “ SimpleOCR “ software.

How to grab text ?

Step 1: Download and Install SimpleOCR from http:// www.simpleocr.com

Step 2 : Run the SimpleOCR Program. During the start up of SimpleOCR, select "Machine Print option".

As program gets open, click on "Add page", it will ask you for select Source. Choose File option, navigate through the desired path and select the TIFF file of Protected PDF .

Step 3 : Now Software will show you a Preview Screen . Just skip it and click on Continue button. Now one can see TIFF image in software. A new button Convert to text will appear.

Step 4 : Here lies the actual magic. Click on Convert to text button”. This process will run OCR operation on TIFF Image, try to recognize the text and display the text.

(There are some options available here with captured text like one can correct the spelling mistakes from text or skip it.)

Step 5: As text is captured, it can be saved too. Click on File menu, select “Save as” option. This option let you save in either as "MS Doc" document or plain text format. Better select plain text format instead of MS doc and save it to desired location.

Write your Comment............