All (not) Open Source

Cannot Connect to Shared Printer on Windows 8

2022-08-18T03:27:00.001-07:00

I hosted Epson L565 printer on Windows 8 PC.

Sharing this Epson L565 printer so other PC in the same LAN can use this printer.

From other PC I can see the shared printer in the network explorer, but I cannot connect it.

Follow the instruction from this https://www.youtube.com/watch?v=5R15NKBU9co, I fixed the problem.

How to Upgrading Flutter SDK On Windows 10 Pro 64

2021-09-28T04:02:00.003-07:00

This is the way to upgrading flutter sdk from version 2.2.0 to 2.5.1

1. Go to Command Prompt ( I was using Git CMD)

2. Go to the recent flutter folder

3. run command "flutter upgrade"

4. If everything running well, then you will see that there is "No issues found!

Confused about setting a static IP on Blackberry Bold?

2013-10-08T21:41:00.003-07:00

First of all, you need to save the "connection" that you want to assign a static IP Address.

Then Go to "Networks and Connections".
Then to "Wi-Fi Network".
Then to "Saved Wi-Fi Networks".
Choose the network you want to assign a static IP Address (The Network that you have saved before).
Uncheck the box next to "Automatically obtain IP address and DNS" to show the static IP Address form.
Enter your networking information (IP Address, SubNet Mask,Router, DNS).
Hit the "Save and Connect" button.
After this, you should connect to the network you want.

I hope this guide would help.

Video Tutorial on Programming

2013-02-09T04:16:00.000-08:00

Many sites on internet publish article on programming.
Some sites publish video tutorial on programing.
One of this kind of video tutorial site is http://showmedo.com/

ShowMeDo has many videos tutorial on Python, Ruby and others programming language.
Do you like that?

Free Hosting

2013-02-09T03:21:00.002-08:00

Wanna to learn how to develop a website?

First thing that you may need is a free hosting account. And you can try http://byethost.com/free-hosting as your first step.

Already try that?
Share your experience to others here...

How to Hide Comment in Excel 2010 Worksheet

2012-10-03T00:31:00.003-07:00

Every month I receive an excel file from my colleague that contains a recapitulation of employee attendance data and my coworkers insert comments in cells which provide explanations on the day an employee is absent.

This of course is a very good thing because I could easily see the reason why one employee did not come to work that day. However, because of all the comments displayed, then it becomes a mess. So to read the comments of the adjacent cell, then I have to close the comments one by one.

Actually excel has provided comments and indicator display options, which we can set it in the Excel Options. Here's how:

Open Excel Options.
Click on the File tab and in the left panel, then click Options.
Click on Advanced menu in the left column.
Scroll down to the Display section then go to "For cells with comments, show:"

Select "No comments or indicators" if you want to hide all comments and indicators, then click OK.
Select "Indicators only, and comments on hover" if you want to hide all comments but still show the red indicators, then click OK. In this setting you can mouse over on the red indicator in the cell to show the comment.
Select "comments or indicators" if you want to show all comments and indicators, then click OK.

And now you have some options to display comments and indicator in Excel 2010 work sheet. Still has a problem on this? Write your question below.

Your server's SSL certificate for cpanel will expire in less than 30 days

2012-10-02T20:00:00.002-07:00

I managed CentOs Server with Cpanel inside.
One day, I receive warning like this:
Your server's SSL certificate for cpanel will expire in less than 30 days. You need to install a new certificate as soon as possible. You can install a new certificate using WHM's "Manage Service SSL Certificates" interface: https://my.server.com:2087/scripts2/manageservicecrts (Main >> Service Configuration >> Manage Service SSL Certificates).

This warning is not indicate a problem in my server. This just a warning that I need to reset SSL certificate on my server. So here the solution to this warning:

I Login to my server via WHM.
Then I Go to "Service Configuration" menu and then to "Manage Service SSL Certificates" sub menu.
I Click "Reset Certificate" button that corresponding to the service which need a new certificate.
After that the self signed certificate is renewed for one year ahead.

I hope the above explanation will give solution to all of you too. Do you? Send your experience below

How to calculate year, month and day between 2 cells in MS Excel 2010

2012-09-12T01:35:00.001-07:00

Sometimes we need to calculate year, month and day between 2 cells in Microsoft Excel.
For example, You have an employees database in excel that record the date they joined the company and then you want to know "how long each employee has worked for the company until now?"

In the such above case, I do the following in Microsoft Excel 2010:

I Input the "signed date" in cell C3 after "No" in cell C1 and "Full Name" in cell C2.
Make sure to assign "Date" as Cell Format for Cell C3.
I input =NOW() in Cell C4 and this will show the current date.
And the calculation begin in cell C5.
In cell C5, I put formula like this: =DATEDIF(C3,C4,"y") & " years, " & DATEDIF(C3,C4,"ym") & " months, " & DATEDIF(C3,C4,"md") & " days"
And the result of the above formula is like this: 19 years, 3 months, 11 days.

If you do not want to show the "day", just cut the last part of the formula (& DATEDIF(C3,C4,"md") & " days").

So now, you know how to calculate year, month and day between 2 cells in MS Excel 2010.

Do you have other formula to calculate the same above case?
Please share on the comment below.
Thank You

How to do a mx lookup in win 7

2012-08-06T03:26:00.000-07:00

Sometimes we need to know whether our mx records are configured correctly.

How to do it in Win 7?

Here are the step:
Go to start button, All Program
Go to accessories menu
Click on Command Prompt

After the Command Prompt window appear, do this:
type: "nslookup" and press enter
type: "set type=mx" and press enter
type "the domain name which you want to check its mx configuration"

All done, and you will see the result

Still having problem?
You can ask in the comment bellow.

How to give a color in Microsoft Office Excel cell

2012-07-12T06:18:00.004-07:00

Some time we want to highlight some cell in Microsoft Office Excel which we considered as important or give stressed for a certain term.

How to do that? Below are the instruction, especially for MS Office Excel 2007 that we can use conditional formating

How to delete saved Username/Password when you browse password protected folder on network in win 7?

2011-12-27T00:54:00.000-08:00

I have Bufallo data link station 1 terabyte attached to my LAN.
I have created some shared folders and each of shared folder has user access restriction only for certain user.

One day I have to change my admin password.

Open Command Prompt (Start > Search "cmd" > Enter)
Enter the line: rundll32.exe keymgr.dll, KRShowKeyMgr
When the window comes up you should be able to manage stored keys.

Installing ImageMagick on CPanel Server

2011-08-25T02:58:00.000-07:00

ImageMagick is dealing with image processing (on the web) that used by imagick PHP extension.

MODx, one of PHP popular Content Management Framework is using ImageMagick for its gallery module.
My CPanel Server does not have ImageMagick, so I have to install it.

My server uses WHM version 11.30.2 and I plan to install ImageMagick from WHM dash board.
In WHM, I go to "Software" and then go to "Install a RPM". From RPM list, I install ImageMagick and ImageMagick Devel respectively. This step basically will install ImageMagick application.

Then the second step, I install Imagick PHP extension. I go to "Software" and then go to "Modules Installer". After that I choose PHP-pecl menu by clicking the "manage" button. Input "imagick" into "Install a PHP Pecl" form then hit the "Install Now" button.

And the final step is to restart httpd (apache) web server services.
And thats all.

Default Application on Ubuntu 11.04

2011-05-05T04:48:00.000-07:00

I try Ubuntu 11.04 live cd on my Virtual Box to see all applications on its package. I just want to know all default application before I install it. Using Desktop Recorder, I make a video to show all Ubuntu 11.04 default application and what its looks like.

How to Record Revision on Libre (Open) Office Writer

2011-05-02T03:21:00.000-07:00

When I work together with my partners in my office, sometimes I should make some revision on a document that proposed by my partner.

It is easy to modify the word document with Libre Office Writer, but I want to track what character, word or sentences that I have changed, so my partner can easily find my revision.

In Libre Office Writer, after I open a word document, then I go to the "Edit" menu. From "Edit" menu, I choose "Changes" sub-menu and then give a check mark on "Record" sub-menu.

After I do the above operation, I found that when I type a revision on the opened document, it will typed on orange. So my partner will easily find what I have revised. When I deleted a character, word or sentences, the deleted character/word/sentences would become a single strikethrough character/word/sentences.

So, it easy to collaborate with other staff using Libre (Open) Office Writer.

Orange HRM Help You Manage Your Human Resources

2011-04-21T00:26:00.000-07:00

Orange HRM is most pupular Human Resources Management Software in the world. Orange HRM is an open source application that developed base on php Symfony framework.

I try to install it on localhost and in my production server, a Centos server that managed by Cpanel. The steps are:

I download the Orange HRM source code from http://www.orangehrm.com/download.php. I download OrangeHRM 2.6.3 Stable Release for Linux which has .tar.gz extension.
I upload orangehrm-2.6.0.2.tar.gz file into my server and place it in public_html directory. I upload it using Cpanel File Manager.
I extract orangehrm-2.6.0.2.tar.gz into public_html directory.
I change the owner and the group off all directory and all file inside public_html to nobody, since apache in Cpanel server run as nobody. To change the owner and the group of all file inside public_html, I had to be a root first.
I create an orangehrm database and a user that has all privilege to orangehrm database.
From my browser, I call www.my-domain.com and follow the installation wizard.

Enjoying to manage your human resources...
Employee database, Company Structure, Time sheets, absences, etc.

Monitoring Internet Traffic in IPCOP2

2011-03-29T21:15:00.000-07:00

IPCop is one of my favorite router firewall linux distro. I had tried IPCop version 1 and now I use IPCop version2 (1.9.17).

On many occasion I find the internet traffic in my office going slow. I have to monitor who has make it slow. I using iftop command line to monitor it. How to do that, it simple, since iftop is builtin on IPCop.

First I have to enable SSH access to my IPCop router firewall box. From the web administration panel of my IPCop, I go to System menu then into SSH Access sub menu. I give a check mark on "SSH Access" and click the save button.

Secondly, from my Linux Mint Debian Edition console, I login to my IPCOP box via ssh, with this command: ssh -p 8022 root@192.168.0.1 and login with root password.

In my IPCop console, I run this command to monitor internet traffic: iftop -i lan-1. It means iftop will monitor the interface lan-1 which is my Office LAN connected to. Iftop give me a real time internet traffic monitoring.

By the way, I got the name lan-1 from my IPCop web administration on Network Status sub menu .

How to hide gridline on Open Office Calc 3

2011-03-28T20:14:00.000-07:00

Open Office is one of free office suite that suitable for home and office user. It has word processor, spreadsheet, presentation tool like microsoft powerpoint, database and some other. You can find the detail information on open office website.

Some time we need to show or to hide gridline in openoffice calc. It is easy to do that. Open Option Menu and from the option left menu choose Openoffice calc then view. You can give "Visual Aid" a check mark on or off to show or to hide gridline.

Installing IPFire Router Firewall on Virtual Box OSE

2011-02-28T20:20:00.000-08:00

Just for experiment, I install IPFire router firewall in virtual box inside my PC that running Linux Mint Debian Edition.

IPFire is a wellknown router firewall linux distro today. In my opinion, IPFire is more like IPCOP router firewall, but has more integrated modules in default installation. The installation process is more like IPCOP. IPFire easy to use and administered through its web admin page.

Since my PC only has on ethernet card, so I missed the RED network configuration, but all install process is completed. The RED interface can be setup later by running setup command.

See the installation process video on Youtube.

Desktop Recorder

2011-02-28T02:09:00.000-08:00

Some times I need to record some certain activities in my desktop in order to make a kind of video documentation or a kind of tutorial on a certain topic. I used recordMyDesktop in my Linux Mint Debian Edition PC to record my desktop.

To install recordMyDesktop, I use the Synaptic Package Manager. After installed, I can access recordMyDesktop through "Sound & Video" Menu then clicking "Desktop Recorder".

With recordMyDesktop I can select a certain windows to record to by clicking on "select window" button. Or I can leave it to record the whole desktop. The result is a video file in format ogv named output.ogv that placed on my home folder.

RecordMyDesktop give me an option to save the video result as another name. To start recording my desktop, I hit the "record" button, then recordMyDesktop application windows will disappear. To stop the recording process, I hit the red circle on my lower desktop panel.

Since the output file is in ogv format file, so I need to convert it to other popular video format file, AVI. I use the following command to convert it:
"ffmpeg -i output.ogv -vcodec mpeg4 -sameq -acodec libmp3lame output.avi", the output will have the same quality with the source.
I used following command to produce the vga quality output:
"ffmpeg -i virtualbox.ogv -vcodec mpeg4 -s vga -acodec libmp3lame virtualboxvga.avi".

Ahh.. the final result is good...
Finally I can make good video tutorial

Mozilla Thunderbird Inbox is Full

2011-02-23T02:01:00.000-08:00

Several days ago, my friend had a trouble with his Thunderbird email client. He is a windows XP user and had used Thunderbird for several years.

Thunderbird showing an error that indicate the inbox folder is full so it fails to download new message. I have found the similar error with Microsoft outlook 2000 at one of my friend PC, since Microsoft outlook 2000 personal folder has 2GB limitation.

I ask uncle "Google" about this error... and I found that Thunderbird Inbox has 4 GB Limitation. But why my Thuderbird never show this error event my email size more than 4 GB?

By comparing the internal folder structure between my Thunderbird and his, I found the cause of error. My friend put all messages into inbox only and never separate or categorize them into folders in local folder.

And the solution come....
1. I close Thunderbird
2. I copy the inbox and inbox.msf file as a backup into other folder.
3. I open Thunderbird again
4. In Thunderbird, I make several new folder in order to categorize all inbox messages. My friend likes yearly categorization. So I make folder like this: 2011, 2010, 2009, 2008 etc, according to the year of each message.
5. I move all inbox messages into each yearly appropriate folder until inbox empty.
6. I close Thunderbird again
7. I delete the empty inbox file and inbox.msf file too.
8. I start again Thunderbird and Thunderbird will create a new inbox file.
9. I try do download new message but it still shows error message that Inbox folder is Full event actually the inbox file is empty at the moment.
10. I compact inbox folder and try to download new message again.
11. Finally it was working.

So,..it is better to categorize your email and separate them into each appropriate folder. I like to separate and categorize them by sender name.

Virtual Box OSE

2011-02-21T19:20:00.000-08:00

I am using Linux Mint Debian Edition (LMDE) right now. Some times I interest to try other Linux Distro or other Operating System, but still want to keep working on LMDE. I only have one PC and one hardisk. I could make a new empty partition on my hardisk, but this would make my PC become a dual boot system. I don't like dual boot system.

And I think the better solution is using Virtualization. It is my lucky day, that we have virtual box ose in Debian repository. I install it using "Software Manager" in Administration menu. After properly installed, I can access Virtual Box via "System Tools" Menu.

And then the journey to other linux distro is begin...

Installing Apache PHP MySql PhpMyAdmin on Linux Mint Debian Edition

2011-02-08T03:41:00.000-08:00

For Development purpose, I set up a local LAMP Server in my Linux Mint Debian Edition.

For the first effort, I try the simplest way, using "tasksel".
What is tasksel? Tasksel is a tool in Debian or Ubuntu Linux Distro that install multiple related package as a co-ordinated task onto our system. You can find more information about tasksel from Ubuntu Documentation.

The available "co-ordinated task" in recent version of Ubuntu and Debian are different. In Ubuntu I can find: DNS server, Edubuntu server, LAMP server, Edubuntu desktop, Kubuntu desktop, Xubuntu desktop, Edubuntu live CD, Kubuntu live CD, Ubuntu live CD and Xubuntu live CD tasksel list.
In Debian I can find: Graphical desktop environment, Web server, Print server, DNS server, File server, Mail server, SQL database, SSH server, Laptop and manual package selection.

Here is the screenshot of LMDE tasksel.

As you see in the above screenshot, I choose Web server and SQL database. The system prompt me with question about "root password for MySql server" and I think this is a good practice to input the password.

Then I install phpmyadmin using manual install, with "sudo apt-get install phpmyadmin".

I run Firefox web browser to open http://localhost. It is to make sure that apache webserver was installed. I open http://localhost/phpmyadmin to make sure phpmyadmin was installed. Then I can login to MySql database server with user root and root password that I have made before.

Ok, I will go to further experiment.

Linux Mint Debian Edition

2011-02-01T03:17:00.000-08:00

Linux Mint is one of popular linux distribution. Its rank in distrowatch.com is always in the five biggest linux distro of the world.
Linux Mint becomes popular since it has a very user friendly "user interface". You can see it on mint menu and in the software manager, besides "out of the box" of Linux Mint. Windows user would face no difficulties to use this linux distro.

Linux Mint actually develop from Ubuntu as a base distro. Since this is not a rolling distro, so I usually do a clean install if Linux Mint release a new version. I really do this for several years using Linux Mint. And then I am glad that Linux Mint developer try a new way to break this kind situation and make a Linux Mint Debian Edition as a rolling distro.

Right now I install Linux Mint Debian Edition in my Office PC. This more light than (Ubuntu based) Linux Mint. Linux Mint Debian Edition has GUI installation process, so it still easy to install.

One of the lack on Linux Mint Debian Edition that I found is, smbclient. I know this when I want to install a network printer that attached to a windows machine on my LAN. I can not find an option to "Windows Printer via Samba" when I add a new printer. From terminal, I know that smbclient is not installed. Then I install smbclient to fix this. An option to "Windows Printer via Samba" appears in the Add new printer dialogue box.

I recommend all of you to use this distro. It is a great distro.
Enjoy..

Cpanel Default Web Page

2011-01-19T02:03:00.000-08:00

When you setup a new cpanel server and want to test the apche service then you try to call the IP address like http://74.xxx.xx.xx. to see if its working.
You will see the default webpage defaultwebpage.cgi. This is the standard system on cpanel.

The defaultwebpage.cgi actualy is the result of redirection of index.html in /usr/local/apache/htdocs/index.html. The defaultwebpage.cgi itself is placed in /usr/local/cpanel/cgi-sys/defaultwebpage.cgi.

To modify this defaultwebpage, try this 2 simple options:
1. Edit /usr/local/apache/htdocs/index.html. and change the meta http redirection. Index.html consist this simple html script:
META HTTP-EQUIV="refresh" CONTENT="0;URL=/cgi-sys/defaultwebpage.cgi

You can change the value in URL=/cgi-sys/defaultwebpage.cgi to URL=/another/page.

2. Or you can edit /usr/local/apache/htdocs/index.html to what ever you like.

Wana try....?

ZevenOS 3.0 (stable)

2010-12-29T02:24:00.000-08:00

For several years ago, I was using Linux Mint on my desktop PC and on my Lenovo Laptop. For years ago, actually I impressed and satisfied with Linux Mint. And for years ago, I was keep searching for more-lightweight linux distro that suitable for daily use at office and home, until I met ZevenOS.

I see ZevenOS is unique. This Linux distro is inspired by Haiku OS. At the time I write this article, Haiku OS is still alpha 2 stage, but if you interrested, you can download and try it.

I downloaded the iso file of ZevenOS 3.0 stable version from its download page. I burned this iso file into a CD. And since it is a live CD, I was testing it on my PC for a week.

I impressed with the idea of Deskbar on top-right of my work space. The deskbar give me a quick access to menu navigation and to application window that already opened. I think this is great and very helpful. My PC used a small-old 14 inches screen, so when I open an application in full windows, the application windows will cover all my workspace. Then it is hard for me to reach other open windows in the back with mouse. Through this deskbar, I just need to mouse over it and I see all the "shorcut bar" of all opened application windows.

In default installation, ZevenOS use Firefox as web broser, Clawsmail as email client, Gimp as image editor, Abiword as word processor, Gnumeric as spreadsheet application, Geany as programming tool, Deadbeef as audio player, Parole as video player and Shotwell as photo manager.

ZevenOS shipped with Magi 2.0, a kind of control center in ZevenOS. Through Magi 2.0, you can configure your ZevenOS to what you like.

Since I need thunderbird as my favourite email client and OpenOffice as my Office suite, I installed it via "Ubuntu Software Center". I think this is a great software manager.

At last, I encourage you all to try ZevenOS 3.0.