Friday, May 30, 2008

IT sa pinas at ang isa sa balakid sa pag unlad..LAPTOP!

Mahigit sampung taon na akong nag tatrabaho sa larangan pinili ko ang “IT”. nakita ko na rin ang layo at bilis ng IT mula sa nang panahong nag tuturbo C at wordstar ako (OO ito ang mga unang gingamit ko nung nag aaral ako bago ako tuluyang mag linux) mula sa ngayong may mga tinatawag ng on-demand..autonomic at mga laruang clustering at virtualization na uso. malayo na ang nilakbay....

sa kabila ng layo nito , iilan palang dito sa pinas talaga ang nakakaintindi at nakakagamit ng teknolohiya ng tama? mapakatulad naming nagbibigay ng serbisyo o maging panig man ng binibigyan ng serbisyo. mga ilang obserbasyon marahil ang bibigyan ko ng mga kadahilanan na masarap iugnay sa isyu ng “laptop”.

OO, laptop. halimbawa isa kang “IT expert at IT consultant ngunit di mo kayang bumili ng laptop. Nagtitipid ka ba o sadyang sa dami mong prioridad di mo kayang bumili, o dahil ayaw mong bumili, may nagpahiram sa yo at ayun, tuwang tuwa ka na lang, IT Expert ka na...

Ito marahil ang isa sa mga sakit na malakas at pag hatak paibaba ng antas ng teknolohiya.
marami kasing sa ating mga Filipino (IT consutant daw) may ugaling mapag-angkin..kesyo proud tayong mag sabi na may LAPTOP TAYO at itutugma ito at proud na tayong mag sasabi na CONSULTANT NA TAYO,sa mga baguhan ng computer..nakakalinlang at IT EXPERT na itatawag sa atin...ngunit wala naman talagang kayang ipamalas o magpatibay...at ang masakit.hindi pa pala natin pag-aari ang laptop. IT consultant ang itatawag sa atin, ngunit ang kaexpertuhan naman kung hindi friendster ay yahoo messenger. ganun ang katotohanan! madaming mapagbalat kayo, masakit man isipin parte ito ng tinatawag na “LINISIN” ng mga tunay na nagpapahalaga sa larangan.

TATAK PILIPINO, madalas kasi mahilig ang “iba” sa atin sa tatak o “label” ngunit yung kaakibat na mga alituntunin hindi iniintindi o hindi lang talaga naintindihan, iresponsable. mahilig gumamit ng salita na parang ganun ganun nalang at walang respeto dito tulad ng “IT EXPERT”,”CFO” “Security Expert” or “MAY- ARI” ng isang company na kung sa susukatin, kapos...kaya madaming nadadamay at napeperwisyo.

walang pinagkaiba sa doctor na hindi marunong mag reseta
walang pinagkaiba sa lawyer na hindi marunong gumawa ng demand letter
walang pag kakaiba sa mga taong nag sasabi “IT Expert o IT consultant” na hindi marunong mag program at ang masakit, walang “sariling” laptop.

mga kwento..kabulaanan o katotohanan?..sa huli..sa tunay na giyera o larangan.. may mga ganitong klaseng nilalang pala, at dyan tayong lahat mag-iingat, ako nga natanso, sila pala'y salot at matinding kabalakidan ng kaunlaran.

Wednesday, May 28, 2008

Scalix 11.4

Kinana,habang nagsusuport ng isang client sa SCALIX re: email routing at konting scripting (ay..hindi nga pala ako marunong mag program hehehe =))
medyo napadpad at nakibasa basa sa blog ni tamang kulit.

http://tamangkulit.blogspot.com/

natuwa lang ako sa "steve" na nagpost o nag komento pero walang tapang namang ipakita ang kanyang identity..nasa aking palagay at kung lalaruin ko ang aking utak at imehinasyon eh si oploks din iyon base sa kanyang unang post na "bakit ka nangingi-alam?" anyway, hindi na magiging sakop siguro ng popost ko dito ang magpaliwanag ang kulit nang aking isipan na kung bakit si oploks nga iyon..

eto kwentong multitasking:
balik sa usaping scalix, matapos kong magawa ang aking mga maliliit na program patungkol sa proyekto ko(ang kulit mo meric..hindi ka nga marunong mag program..hehehe) kasabay ng pakikipagusap sa chat sa PLDT at sa isang client sa ISABELA para naman sa routing table na inaayus namin para sa isang VPN project eh at pag a-aup din ng isang router sa isang client na nasa LEGASPI...ayun, napadpad naman ako sa website ng scalix at nakakatuwang isipin na may bagong version na sya ulit..eto't isinama ko sa ibaba yung listahan ng mga bagong feature nya...

New Features in Scalix 11.4
http://www.scalix.com/enterprise/technology/news_11.4.php

Scalix 11.4 provides the following new features:
General

* Full support for CentOS 4 and 5
* New Products: Scalix AntiSpam and Scalix ZeroHour AntiVirus (optionally licensed)

Scalix Server

* New MILTER interface on SMTP Relay
* Added support for Proxy Folders: Ability to integrate external read-only feeds (WebCal/ics and RSS/ATOM) as virtual folders

Scalix Messaging Services

* Extended CalDAV support for Apple iCal
o Ability to create new calendars and manage calendar properties
o Ability to schedule meetings and view Free/Busy information
* Support for Lightning/Sunbird with initial support for Lightning 0.8

Scalix Web Access

* Support for Firefox 3.0b5
* New calendaring mode with overlay views
* Ability to open other user's calendar without adding the whole mailbox
* Support for theming and new Scalix Default theme
* Reduced server load and improved performance when handling large mailboxes

Scalix Connect for Outlook (for Scalix "Premium" users only)

* Support for Windows Vista 32-bit/64-bit*
* Improved SmartCache usability and stability
* Increased compatibility with additional AntiVirus, AntiSpam Packages
* Ability to use multiple network names and IP addresses for connection configuration
* SSL certificate management integrated with Windows certificate store

* Running Outlook 2003 and Outlook 2007 on Vista 64bit is subject to a number of issues and known limitations.

Sunday, May 25, 2008

hindi kailangan mahal ang kaalaman...My Booksale Experience

Sa aking mga libreng oras, lagi ko minamake sure na may nababasa ako at nakakagawa ako ng mga bagay bagay patungkol sa aking work, madalas nasa online ako para magtingin tingin at magbasa basang mga kaganapan sa IT lately eto sa dalaang site ako bumababad [1]free software magazine,[2] cioinsight.

May mga books din ako lagi sa likod g red car na vios namin para pag mahahabang biyahe nakakabasa basa din ako, lately kasi madami dami din akong biniling book sa BOOKSALE.. oo sa BOOKSALE dati kasi pumupunta lang ako dun para bumili ng mga paborito kong magazine pero lately puro books naman yung nakukuha o nabibili ko.

Kamakailan lang, nakakuha ako ng books re: Redhat Enterprise,MySQL,Advance PHP,QMAIL and guide sa LPI certification. yung mga books na ito eh nag ra-range sa 300 to 500 pesos; magandang presyo kumpara kung bibili ako sa national bookstore o amazon na mahigit sa libo ang aking magagastos. kaya lang syempre tsambahan yung mga books na makukuha mo.Katulad kanina yung dumaan ako sa BOOKSALE sa SM WEST wala na akong mapiling books o di ko trip bilhin bukod sa puro microsoft yung title yung iba naman eh patungkol sa design like photoshop o flash na sya namang hindi pa ang interest ko ngayon, yung iba naman eh mga CISCO na books.

kaya balik ako bilang mangangalkal ng magazine, nakakatuwa lang kasi.. this time marami akong nakakal na patungkol sa LINUX..ayus! LINUX MAGAZINE na dec 2007 issue pero 20 pesos lang meron ding february 2008 edition n 33 pesos at isang inux journal Dec 2007 ISsUE 164 na halagang 90pesos

ngayon, medyo bababad na muna ako sa mga ito...tamang tama pag umebs ako =)

kaya kayo, kung tulad ko na bukod sa maraming e-books na koleksyon at babasahing hard copy, kung may konti kayong panahon bumusita lang sa booksale o mga kaparehang tindahan nito, malay nyo makakuha din kayo ng mga ilang babasahin na makakatulong o dagdaga kaalaman sa munting presyo lamang...laging tatandaan hindi kailangan mahal o magastos para madagdagan ang kaalaman..sipag at diskarte lang magandang puhunan na.


PAHABOL: HAPPY BIRTHDAY KONGKONG! nitong May 23 kasi bertday ng kapatid ko na Linux girl naman.

1. http://www.freesoftwaremagazine.com/
2. http://www.cioinsight.com

Monday, May 12, 2008

Build on a strong foundation

Have you heard of NITIX before?

The TOO GOOD TO BE TRUE, First AUTONOMIC Operating System on Linux...
For more than two years now, 8layer has deployed and established IT infrastructure for various Filipino organizations built on this Robust System, NITIX.
Now, let us share to you the new face and a stronger expanded team that embraced and realized the value of this magnificent solution.

Build on a strong foundation:

* http://www-306.ibm.com/software/lotus/smb/build-your-business/
* http://www.nitix.com/partners/approved/whypartnermovies/movies/steve.swf

For interested modern IT practitioners (whether IT savvy or not), we are just an email or a phone call away.

http://www.8layertech.com/contactus.php

Thursday, May 08, 2008

MySQL database replication

It was a long time since I last posted technical tips in my blog. I’ll post one this time for some reason. Topic? “MySQL database replication”

As I commence implementation and testing for my internal project in relation to High availability I am concurrently doing an internal project with regards to MYSQL database replication. I will be happy sharing this information; not only will this be very exciting but if given utmost attention, will shed aid for every database administrator that using mySQL server.

As you read along, the things and steps are scribbled to make this solution possible.

In my example below, I used the following information.

Database name to be on mirror/replicated: mericdb

My Network/Server Information:
Master: Primary Database
IP ADDRESS: 192.168.69.108
Server name: node01

Slave: Secondary Database
IP ADDRESS: 192.168.69.208
Server name: node02

My SLAVE USER NAME: mericuser

Another thing that we need to note is that I already installed my web and database server using “yum” and downloaded phpmyadmin to handle the administration of My MySQL over the Web.

wget http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.6-all-languages-utf-8-only.tar.gz

On My MASTER SERVER


1. Configure Master /etc/my.cf:
[root@node01 ~]# vi /etc/my.cnf

Under [mysqld]
log-bin
binlog-do-db=mericdb
server-id=1
Then let’s restart MySQL:
[root@node01 ~]# service mysqld restart
2. Then, log into the MySQL database as root and create a user with replication privileges:
mysql -u root -p
Enter password:
Now we are on the MySQL shell.
GRANT REPLICATION SLAVE ON *.* TO ' mericuser'@'%' IDENTIFIED BY '123'; FLUSH PRIVILEGES;
Next (still on the MySQL shell), do this:
USE mericdb;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;
The last command will display something like this:
mysql> SHOW MASTER STATUS;
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| node01-bin.000002 | 282 | mericdb | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)

Write down this information specifically the “File” and the “Position”
In this case “node01-bin.000002” and “282”

3. Getting data undo SLAVE

[root@node01 ~]#mysqldump -u root -p --opt mericdb > mericdb.sql
[root@node01 ~]#scp mericdb.sql root@192.168.69.208:/tmp/
Enter password:
Okay, now let’s unlock the tables in mericdb:
mysql -u root -p
Enter password:
UNLOCK TABLES;
quit;
(magkape ka muna, tapos cr na rin… - for my international readership: get a cup of batangas coffee, then take a long pee)

On My SLAVE SERVER
1. On the slave server, we first need to create the database mericdb:
[root@node02 ~]# mysql -u root -p
Enter password:
CREATE DATABASE mericdb;
quit;
[root@node02 ~]# mysql -u root -p mericdb < /tmp/mericdb.sql
2. Configure server /etc/my.cf:
[root@node02 ~]# vi /etc/my.cnf

Under [mysqld]

server-id=2
master-host=192.168.69.108
master-connect-retry=60
master-user= mericuser
master-password=123
replicate-do-db=mericdb

Then, we restart MySQL:
[root@node02 ~]# service mysqld restart
[root@node02 ~]# mysql -u root -p
Enter password:
LOAD DATA FROM MASTER;
quit;

[root@node02 ~]# mysql -u root -p
Enter password:
SLAVE STOP;
In the next command (still on the MySQL shell), you have to replace the values appropriately:
CHANGE MASTER TO MASTER_HOST='192.168.69.108', MASTER_USER=' mericuser ', MASTER_PASSWORD='123', MASTER_LOG_FILE=' node01-bin.000002', MASTER_LOG_POS=282;
• MASTER_HOST is the IP address of the master database
• MASTER_USER is the user we granted replication privileges on the master.
• MASTER_PASSWORD is the password of MASTER_USER on the master.
• MASTER_LOG_FILE is the file MySQL given back (resulting) when you run /running SHOW MASTER STATUS; on the master.
• MASTER_LOG_POS is the position MySQL given back when you run/ running SHOW MASTER STATUS; on the master.
For our Final steps, let’s start the slave server. Still on the MySQL shell we run
START SLAVE;
quit;
Finished!
Every time we update mericdb on the master, all changes will be replicated to mericdb on the slave. I use my phpmyadmin tool to test and update my databases.

Now, you know why it took me a while before it got to post again….
Happy replicating….