php-excel-reader Parse and retrieve information from XLS files
When the excel reader is run on PHP 5.3, below mentioned deprecated warning messages gets shown.
i) Assigning the return value of new by reference is deprecated
Remove & from the line below
$this->_ole =& new OLERead();
$this->_ole = new OLERead();
ii) Function split() is deprecated
Function split() is deprecated and we can use explode() instead of that.
$parts = split(“;”,$format);
change it to
$parts = explode(“;”,$format);
In certain scenarios, users encounter above message when they try to connect to their web hosting accounting using one of their ftp programs like filezilla, ws-ftp, cuteftp, smartftp
Solutions that seemed to have worked for me
i) Host name: Try adding ftp://www.mysite.com and set the port to 21
ii) User name: Try typing firstname.lastname@example.org instead of just the user name of the ftp user
This will be a simple step by step tutorial to help beginners catch up with ASTERISK – an open source tool for voice communication. It is a software installation of PBX connecting even the PSTN and VOIP networks.
Originally developed for Linux, Asterisk now runs on a variety of operating systems including Solaris, Windows and MacOS.
Check for the existence of the file sshd_config (/etc/ssh/sshd_config).
Before editing the file check that path settings for sftp-server
$ locate sftp-server
Check for the existence of following line in sshd_config
Subsystem sftp /usr/libexec/openssh/sftp-server
Turn on warnings by
To run a perl script with warnings, type -w with the shebang as in
print “Content-type: text/html\n\n”;
print “Hello World\n”;
Check if you have the following line in the program
print “Content-type: text/html\n\n”;
This will output the text to the browser from the server.
Print error messages to the browser using
use CGI::Carp qw(fatalsToBrowser);
The other way is to use the print command to debug your program.
Common error messages
» The specified CGI application misbehaved by not returning a complete set of HTTP headers.
» Can’t locate missing-file.pm in @INC (@INC contains: ….. )
Full backup is process of backing up ALL data.
First step towards all other types of backup
Backup time will be longer
Restore operation takes less time
Differential backup is the process of backing up data that has changed since the last FULL backup.
Requires file maintenance as the backup file will be of similar size or larger than its previous backup
Longer backup time than incremental backup
Faster restoration than incremental backup
Incremental backup is the process of backing up data that has changed since the last Full, Incremental or Differential backup
Takes lesser backup time as it will have small data to archive
Takes longer restoration time
Mirror backup is similar to full backup and is a direct copy of the files/folders
Files are not compressed in zip files and are not protected with password. They remain the mirror or exact copy of the source.
InfraRecorder – available under GPL license and can be used to convert MP3 music to audio (cda) format in Microsoft Windows.
To convert mp3 to audio (cda) format, all you need to do is to select InfraRecorder » choose Audio Disc » drag the MP3 file to file list » Click Burn the current compilation to disc
Using InfraRecorder, you can also compile a CD/DVD, record disc images (ISO, BIN, CUE), record dual layer DVD’s, fixate discs and many such features.
You can check InfraRecorder at http://infrarecorder.org
When moving mysql database from one server to another or, to test that the data backup works as expected we need to import mysql dump file in the testing environment.
Create the database (test-database) in the testing environment and identify the location of the .gz or .sql file.
If the mysql dump was a .gz file, you need to gunzip to uncompress the file by typing
$ gunzip mysqldump.sql.gz
This will uncompress the .gz file and will just store mysqldump.sql in the same location.