Camilo Lozano III

Lately, I was addicted playing the Cafe World by Zynga. There are some tricks that my fellow office mates how to earn coins so fast and its cafe popularity. I would like to share this to you all…

Deep freeze Popularity

Here’s the Tips and Tricks…

• Barricade your chef and waiter(s) with tables (shown in the images)
• Remove your doors if you have nothing to serve, this is to preserve your popularity rate
• Serve at least 2 or more varieties of food to boost the growth of popularity rate
• Having below 15 popularity rate, If you notice that few customers are coming in, click the Expand Cafe or Functional then click the check or OK. This will make the customer appear in your restaurant automatically
• Having 30 popularity rate, put many doors as possible

Speedy Food Distribution

Camilo III Entertainment, Games

… I’m chasing the dawn as it runaway with the night

… every single minute in slow motion welcome daybreak

… such charm is my heart’s favorite scenario

… resounds at every breath of wanting to see the sunrise

… will the silence and serenity suffice the need

… Am I to wish for you in a falling star or just be brave enough to accept that you are someone else’s prayer

… In this half way bridge my own constellation to make

… taking comfort with the gray sky, same hope that confess everything

… Please let be fair, have faith in me that I can love, even for how many tomorrows will come as I have been loving the yesterdays…

gelyle Gelyle's Poems

Since my first plug into the internet, I use yahoo. When I search, I also use Yahoo search and that was year 1998. But now, Yahoo change a lot with sophisticated functionality. For google, I only use for search as alternative for Yahoo. But now, Google has the best functionalities and all.

Gmail and Google Search

• Simple
• User-friendly
• Less Ads (if there’s an ads, it’s just a line)
• Powerful spam filter
• Lots of labs modules

Ymail and Yahoo Search

• Sophisticated Functionalities
• Lots of spam
• Copied the chat functionality of Google
• Lots of Ads (like really big ads)
• Stupid Seals

As a conclusion, Yahoo sucks! Google Rocks!!!

Camilo III Info.Tech

Since I’m young, I always experience about bombing here and there anywhere in Mindanao. After many-many years, I realized that its all a play. A way of having more money to come for the politicians.

1. Bombing of Maria Christina Bridge in Iligan City (April 20, 2009) – It seems the election is so near, all bombs away where the money comes. I think 64M has been released for the repair. And many months later from the released date, there no repair happened. Again, its a play to get the money from above.
2. Bombing of Sabayle Street, Iligan City (July 6, 2009 — includes also other places in Mindanao) – I think it all about the charter change. Since they want to change the constitution, they want to declare martial law by using the terrorist act and somehow, they were the terrorist.

As my conclusion to these events, Mindanao is the source of their money. Not to mention all the illegal drugs, firearms and etc are came from Mindanao and somehow protected by the highest position in this country. In short, Mindanao is the lab rats!

Camilo III History, Madness, Personal bomb, bombing, drugs, iligan, mindanao, philippines

Since I’m a child, I dream to be a pilot and someday join the Inter-Galactic Explorer but instead I became a System Administrator / PHP Web Developer. After watching Star Trek 2009 movie, it reminds me to my child’s dream.

In some point, what IF…

1. IF only U.S. , Russia and other major or rich country stop creating war but start researching how to expand our possibility to explore space, galaxy and universe
2. IF only richest people do some advance research traveling space
3. IF only stop using oil instead use energy
4. IF only people stop the hunger of power and greediness
5. IF only we concentrate to advance technology and health research

Because if these happens, I can imagine we already starting to build a large ship and start exploring nearby system and soon will be exploring galaxy and discover civilizations.

*sigh* But I think these will never happen withing my whole life. Might happen but take too long or too late for humans to expand because our sun is dieing already.

Funny imagination but the possibility is great.

Camilo III Personal earth, explore, galaxy, space, sun, universe

These comic trips by N.C. Winters relates my work pretty much…

Camilo III Administration, Personal, Web Development, Wooow! comic, design, freedom, freelance, nc winters

Oracle Database 10g Express Edition
Free to develop, deploy, and distribute

Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for:

* Developers working on PHP, Java, .NET, XML, and Open Source applications
* DBAs who need a free, starter database for training and deployment
* Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
* Educational institutions and students who need a free database for their curriculum

With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations. Read what users say about Oracle Database XE.

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

• Download Oracle Database 10g Express Edition

After installation, be sure to register for an exclusive Oracle Database 10g Express Edition Discussion Forum hosted by Oracle expert Tom Kyte—click on the “Registration” link on XE’s Database homepage.

Camilo III Info.Tech, Software Development, Web Development 10g, database, free, oracle

cPanel

This is a basic installation tutorial for the CentOS operating system for dedicated server duties.
CentOS is a free white label distro of RedHat Enterprise with all the bells and whistles, and is the OS of choice for many web hosting companies

Installing the OS using ‘Text Mode’ :

1 – Insert the first Linux installation CD-ROM (disc 1) in the CD-ROM drive of your server and restart the server.
2 – At the boot: prompt, type text and press the Enter key. This starts the installation process.
3 – On the Language Selection screen, select English as the language that you want to run the installation program in, then click OK.
4 – On the Keyboard Selection screen, select the keyboard attached to your server, then click OK.
5 – On the Mouse Selection screen, select the mouse attached to your server, then click OK.
6 – On the Welcome screen, review the installation information, then click OK.
7 – On the Installation Type screen, select Custom, then click OK.
8 – On the Disk Partitioning Setup screen, select Disk Druid. Quote:
- If your disk has existing partitions, select each partition and click Delete.
9 – Create the following disk partitions:

The following partitions are recommended prior to installing cPanel:

**1 GB /
*50 MB /boot (No seperate /boot for FreeBSD)
**1 GB /tmp
*10 GB /usr
**7 GB /var
**1 GB swap (swap should be 2x RAM)
Remaining space to /home

Note: The above partitioning scheme is assuming a 40 GB hard drive. If you have a larger hard drive, you should increment /usr & /var accordingly. To create the / partition ‘root’:

* On the Partitioning screen (see step 8 ) , click New.
* In the Mount Point field, type / .
* For the Filesystem type select ext3.
* In the Size (MB) field, type 1024, then click OK. To create the /boot partition: Quote:
* On the Partitioning screen (see step 8 ) , click New.
* In the Mount Point field, type /boot.
* For the Filesystem type select ext3.
* In the Size (MB) field, type 50, then click OK. To create the /tmp partition : Quote:
* On the Partitioning screen (see step 8 ) , click New.
* In the Mount Point field, type /tmp .
* For the Filesystem type select ext3.
* In the Size (MB) field, type 1024, then click OK. To create the /usr partition : Quote:
* On the Partitioning screen (see step 8 ) , click New.
* In the Mount Point field, type /usr .
* For the Filesystem type select ext3.
* In the Size (MB) field, type 10240, then click OK. To create the /var partition : Quote:
* On the Partitioning screen (see step 8 ) , click New.
* In the Mount Point field, type /var .
* For the Filesystem type select ext3.
* In the Size (MB) field, type 7168, then click OK. To create the swap partition: Quote:
* On the Partitioning screen (see step , click New.
* For the Filesystem type field, select swap.
* In the Size (MB) field, enter a number that is twice the current RAM (1024 If you are using 512 MB Ram), then click OK. To create the /home partition: Quote:
* On the Partitioning screen (see step , click New.
* In the Mount Point field, type /home.
* For the Filesystem type select ext3.
* In the Size (MB) field, select Fill all available space, then click OK.

10 – When finished, Click OK.
11 – On the Boot Loader Configuration screen, select LILO Boot Loader, then click OK.
12 – On each of the following three screens, click OK.
13 – On the Network Configuration screen, clear Use bootp/dhcp, enter your server network configuration, then click OK.
14 – On the Hostname Configuration screen, enter the fully qualified host name of your server, then click OK.
15 – On the Firewall Configuration screen, select No firewall, then click OK.
16 – On the Language Support screen, select English (USA), then click OK.
17 – On the Time Zone Selection screen, select the location, then click OK.
18 – On the Root Password screen, enter in the root password for your server, re-enter the password to confirm it, then click OK.
19 – If you want to create an account that you can use to remotely log on to your server using SSH or FTP, click Add.
*** Provide the login name and password, then click OK.
20 – Review the information on the User Account Setup screen, then click OK.
21 – Review the information on the Authentication Configuration screen, then click OK.
22 – On the Package Group Selection screen, verify that only the following packages are selected. Clear all other check boxes.

. Network Support
. Messaging and Web Tools
. DNS Name Server
. Network Managed Workstation
. Software Development

23 – Click OK.
24 – Review the Installation to begin screen, then click OK.
25 – Insert the second/third installation CD-ROM when notified to, then click OK.
26 – To create a boot disk, click Yes. Otherwise, click No.
27 – When done, the installation complete screen displays.
28 – Click OK, then press Enter to restart.

[2] Checking the host name and network settings :
After your first boot, you must check your system’s host name and network configuration to ensure that they are correct. To check your system’s host name and network configuration:
- Log on to the system as the root user.
- Type vi /etc/hosts to open the host file and modify the contents.
- Verify that the file is in the following format:
- Verify that the loopback entry (127.0.0.1) appears in the file. A correctly configured file should look like this: Note : The IP addresses used here are for illustration purposes only; they are not valid values.

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
10.1.1.1 myhost.mydomain.com myhost – Modify the file as needed.
- Type :wq to close the file.
- Type vi /etc/sysconfig/network to open the network sysconfig file and modify the contents.
- Verify the host name. A correctly configured file should look like this: Note : The IP addresses used here are for illustration purposes only; they are not valid values.

NETWORKING=yes
HOSTNAME=myserver.mydomain.com
GATEWAY=10.100.0.1 – Modify the file as needed.
- Type :wq to close the file.
- Type vi /etc/sysconfig/network-scripts/ifcfg-eth0 to open the network scripts file and modify the contents.
- Verify that network information. A correctly configured file should look like this: Note : The IP addresses used here are for illustration purposes only; they are not valid values.

DEVICE=eth0
BOOTPROTO=static
BROADCAST=10.1.1.1
IPADDR=10.1.1.1
NETMASK=255.255.0.0
NETWORK=10.1.0.0
ONBOOT=yes – Modify the file as needed.
- To make these changes active, restart the system by typing:

shutdown -r now

[3]cPanel Installation Instructions:

Important : You must have a valid cPanel license. If you do not have a valid cPanel license, please contact one of cPanel distributors listed at http://www.cpanel.net/dist.htm or buy a license directly from cPanel at http://www.cpanel.net/store/. cPanel now uses a universal install script which can be found at http://layer1.cpanel.net/. You can use the following commands in the root shell to download and start the installation script:

mkdir /home/cpins
cd /home/cpins
wget http://layer1.cpanel.net/latest
sh latest

At this point the installation has started and may take anywhere from 30 – 60 minutes to complete. At no point during the installation should you be prompted for user input. You will know the cPanel installation has been completed by the screen output coming to a stop & the statement “Done.” is printed on your screen. You should then hit “ctrl c”† to continue. Note: You must be on a stable connection to install cPanel. If your shell session disconnects during a cPanel install the cPanel installation will be aborted. You can restart the cPanel installation by completing “sh cpanel-*”† again, however it is recommended that you reformat your machine & start over to ensure a clean slate before placing the machine into production.

[4]cPanel/WHM Configuration: Following a successful install you should setup cPanel/WHM as soon as possible. In order to complete this process you will need to log into your machine using its main (eth0/fxp0) IP address; you should input something similar to this into your browser:

https://xxx.xxx.xxx.xxx:2087

Note: you should replace xxx.xxx.xxx.xxx with your actual IP address. Further to that, you will be prompted about a self signed SSL certificate; ignore this by clicking on “Yes”. A self signed certificate is generated by cPanel/WHM to ensure a secure/encrypted communication with your server. You will now be prompted with a few questions related to how you would like your installation of cPanel/WHM customized. You can walk through the wizard by clicking on “Next Step” or if you are an experienced user feel free to click on “Finish” to skip to the end. For a complete user guide on how to access cPanel/WHM and/or use any of the functions within cPanel/WHM, please visit cPanel do*****ents section at http://www.cpanel.net/docs.htm That’s all for now .. Just keep in mind, this is not the all-in-one package for server installaion, you’ll have to secure the server, update your kernel, install a firewall, configure SSH, apply patches …. etc.

Reference:

• www.zimbio.com
• mike.holownych.com

Camilo III Administration, Info.Tech, Operating Systems CentOS, cPanel, install, WHM

I have a current project that connects to a remote database server using Visual C# as client window application. So before I started my project, I tested it if it is possible to connect and the result, it does connect. For those does who failed to solve this problem, here’s my tutorial/guide.

Test Project Requirements:

• VMware Workstation 5.5
• CentOS 4.4
• Visual C# Express Edition
• MySQL Data Connector .Net v1.0.7

Scenario:

The client’s OS is MS Windows XP and the server is CentOS Linux. The client will connect to the Linux server to query and process some transaction. But in the sample code, it demonstrate only how to connect remotely in the server. My server’s IP address is 192.168.10.117 and a MySQL port of 3306 (default port).

Screenshots:

Step 1:

Setup the Linux server, be sure you already installed MySQL server. In our case, we use VMware and a CentOS 4.4 is installed. For installation help, google it! The first thing to do is configure your IP tables by using iptables command. see illustration below;

If your configuration does not allow foreign connection to your MySQL, then change that and allow it. In real scenario if your server is public, I recommend that you must have a new server which can only be access through local network. Or if cannot afford, just setup well the IP tables that only local connections are allowed. Anyway, here’s my new IP tables setup in my server;

In MySQL CLI, create a user that can access everywhere. To do this, see sample below;

mysql> GRANT ALL PRIVILEGES ON *.* to ‘beasaw’@'%’ IDENTIFIED BY ‘qwerty’;

Explained: the command shown above is to allow user, beasaw, to access anywhere using a password qwerty.

That’s it… server setup completed.

Step 2:

Before you create a new project in VCS, test first the connection using the command;

C:\> mysql\bin\mysql --host=192.168.10.117 --port=3306 --user=beasaw --password=qwerty

See image below;

Step 3:

1. Open your Visual C# and create a new project, name it to remoteMySQL.
2. In Form1.cs, layout just like the screenshot above.
3. Add a reference, MySql.Data.dll (assumed that you already installed the MySQL data connector .Net v1.0.7)
4. Add mysql to the project: using MySql.Data.MySqlClient;
5. Begin your codes, see sample code (download link below)…

That’s it… You can create as many applications you want with this method. Like Ticketing System, connecting 10 terminals to the servers simultaneously and etc. And of course, connection varies also to your MySQL server setup.

Download:

» VCS Remote Connect to MySQL Server (61)

Camilo III Info.Tech, Software Development, Visual C# connect, connecting remotely, database, mysql, remote, server, visual C#

When I watched Discovery channel about the Atomic Bomb dropped in Hiroshima which some of the scene have been cut. I continue watch in Youtube and read some articles. A review of history 101. Hehehe.. Somehow, I found the letter of Albert Einstein about the creation of the Atomic bomb using Uranium-235 and was introduce to President Roosevelt in US. The letter shown below…

My Opinion: It was such a destruction but I believe if the U.S. didn’t stop such war against Japan, more and more lives will be taken from that war. Not to mention here in the Philippines, Japanese rapes Filipinas and Filipinos killed by torture. Because of that, Japanese learn about their mistake attacking Pearl Harbor.

Reference:

• http://inventors.about.com/od/astartinventions/a/atomic_bomb.htm
• http://inventors.about.com/od/astartinventions/a/atomic_bomb_2.htm

Camilo III History albert, atomic bomb, einstein, letter, manhattan project, nuclear