Archive for the ‘Tips’ Category

To send free sms, add your service provider’s domain name to the end of the 10-digit mobile number of the person whom you want to send SMS.

For example, if the mobile number is: 123-456-7890 and the provider is AT&T, then sms can be send through email as:

Recipient’s address: 1234567890@message.alltel.com

Type the message in the message ‘Subject’ or message ‘Body’.

Enjoy free messaging!!

Mobile Device Address:

Bell/President’s Choice/Solo: your 10-digit phone number@txt.bell.ca (7801234567@txt.bell.ca)

Fido: your 10-digit phone number@fido.ca (7801234567@fido.ca)

Koodo: your 10-digit phone number@msg.koodomobile.com (7801234567@msg.koodomobile.com)

Rogers: your 10-digit phone number@pcs.rogers.com (7801234567@pcs.rogers.com)

Telus: your 10-digit phone number@msg.telus.com (7801234567@msg.telus.com)

Virgin: your 10-digit phone number@vmobile.ca (7801234567@vmobile.ca)

Advertisements

Mysql setup

Install mysql

sudo yum search mysql // find the right names of the packages here

sudo yum install mysql-server.x86_64 mysql.x86_64 mysql-devel.x86_64

Edit mysql configuration

sudo vim /etc/my.cnf

Add the following lines if not already present:

[mysqld]

# Allow packets up to 4MB

max_allowed_packet=4M

# Allow small words in full-text indexes

ft_min_word_len=2

Start Mysql server

sudo /etc/init.d/mysqld start

Login as root

mysql -uroot // no password by default

Create the database for bugs in the mysql terminal by using the following sql

create database bugs;

Create the user bugs

create user bugs identified by ‘passw0rd’;

Grant the permissions to user bugs on bugs database

GRANT SELECT, INSERT,UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES, CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.* TO bugs@localhost identified by ‘passw0rd’;

Flush privileges in order to take effect immediately. Very important!

FLUSH PRIVILEGES;

NOTE: Update your password if you need to :

update mysql.user set Password=password(‘passw0rd’) where User=’bugs’



Bugzilla Setup

Download latest stable bugzilla version from the website. It’s 3.4.4 as of now

wget http://ftp.mozilla.org/pub/mozilla.org/webtools/bugzilla-3.4.4.tar.gz -O bugzilla-3.4.4.tar.gz

Change to the apache directory from where it serves files

cd /var/www/html/

Unzip the tar here /var/www/html/ so that apache can see it

sudo tar -xzvf ~/bugzilla-3.4.4.tar.gz

(optional) Rename the directory to hide the version

sudo mv bugzilla-3.4.4/ bugzilla

Change ownership so that apache can read/write to it

sudo chown -R apache.apache /var/www/html/bugzilla/

Change to bugzilla directory

cd /var/www/html/bugzilla/

Run checksetup.pl – this will show you the perl modules missing

sudo ./checksetup.pl –check-modules

Install gcc (if the linux distro doesn’t already come it), as you will need it to make/compile the modules

sudo yum install gcc.x86_64

Install any missing modules //here are commonly missing modules

sudo /usr/bin/perl install-module.pl CGI

sudo /usr/bin/perl install-module.pl Digest::SHA

sudo /usr/bin/perl install-module.pl Date::Format

sudo /usr/bin/perl install-module.pl DateTime

sudo /usr/bin/perl install-module.pl DateTime::TimeZone

sudo /usr/bin/perl install-module.pl DateTime::Locale

sudo /usr/bin/perl install-module.pl Template

sudo /usr/bin/perl install-module.pl Email::Send

sudo /usr/bin/perl install-module.pl Email::MIME

Run the checksetup.pl without any parameters to create a localconfig file.

sudo bash /var/www/html/bugzilla/checksetup.pl

Change the permissions in case there should be a conflict.

sudo chmod -R 777 /var/www/html/bugzilla/

Edit localconfig

sudo vim localconfig

Update the database connection details like username and password

# The DNS name of the host that the database server runs on.

$db_host = ‘localhost’;

# The name of the database

$db_name = ‘bugs’;

# Who we connect to the database as.

$db_user = ‘bugs’;

# Enter your database password here. It’s normally advisable to specify

# a password for your bugzilla database user.

# If you use apostrophe (‘) or a backslash (\) in your password, you’ll

# need to escape it by preceding it with a ‘\’ character. (\’) or (\)

# (Far simpler just not to use those characters.)

$db_pass = ‘passw0rd’;

# Sometimes the database server is running on a non-standard port. If that’s

# the case for your database server, set this to the port number that your

# database server is running on. Setting this to 0 means “use the default

# port for my database server.”

$db_port = 0;

# With the introduction of a configurable index page using the

# template toolkit, Bugzilla’s main index page is now index.cgi.

# Most web servers will allow you to use index.cgi as a directory

# index, and many come preconfigured that way, but if yours doesn’t

# then you’ll need an index.html file that provides redirection

# to index.cgi. Setting $index_html to 1 below will allow

# checksetup.pl to create one for you if it doesn’t exist.

# NOTE: checksetup.pl will not replace an existing file, so if you

# wish to have checksetup.pl create one for you, you must

# make sure that index.html doesn’t already exist

$index_html = 1;

Re-run the checksetup.pl

sudo bash /var/www/html/bugzilla/checksetup.pl

Apache setup

Almost all linux distributions come with httpd pre-installed (i.e. Apache)

If not, install it using

sudo yum install apache

or

sudo yum install httpd

Edit /etc/httpd/conf/httpd.conf

sudo vim /etc/httpd/conf/httpd.conf

and add the following lines

ScriptAlias /cgi-bin/ “/var/www/html/bugzilla/”

<Directory /var/www/html/bugzilla>

AddHandler cgi-script .cgi

Options +Indexes +ExecCGI

DirectoryIndex index.cgi

AllowOverride Limit

</Directory>

Find the line

DirectoryIndex index.html index.html.var

Change it to

DirectoryIndex index.html index.html.var index.cgi

Start the httpd server

sudo /etc/init.d/httpd restart

and you are good to go!

Try http://localhost/bugzilla and have fun!

Source: twincling

Deleting blank rows is a common thing one would like to do after importing data to excel. There are dozens of ways of achieving the same. I bet, this being one of the simplest:

1. Press F5 on the keyboard. The ‘Go To’ dialog window appears.
2. Click ‘Special..’ button at the bottom left corner of the dialog box.
3. The ‘Go To Special’ dialog window opens.
4. Select ‘Blanks’ radio button and click ok.
5. All the blank rows will be selected on the excel.
6. Click ‘Delete Cells’ under ‘Home’ Tab.
7. This will delete all blank rows on the excel.