am3n portfolio

I was going to use “Proxy Server using CentOS 4.6 and Squid+Adzapper and DansGuardian+ClamAV” for title but that to long .

My current proxy server was a left over from the previous SysAdmin, and I never touch nor fix it, coz it aint broked :P. But after several monitoring, the use of Internet from users is getting high, virus risk, and they no longer productive (actually for the last I dont care as I am not their employer)

This new proxy it has ability to
• Scan all traffic for virus
• Zap/remove ads/banner
• Content filtering based on naughtyness level and sites category
• ACL based on IP Address

The Complete step by step installation is attached below:
Proxy Server Installation manual

Next phase will have: (after using CensorNet)

• Access list based on username (same as email account)
• Bandwidth priority, policy and scheduling based on user group
• Utilize Watchguard’s Web-blocker addon

To create the system I am using below referrence

• CentOS/RHEL : Web Proxy + Antivirus (ClamAV)
  <== most of how-to came from the fellow RHCE, thanks mate
• How to configure squid proxy server using Fedora
• Ad Zapping with Squid
• DansGuardian - True Web Content Filtering for All
• Clam Antivirus
• OpenDNS - Providing A Safer And Faster Internet

Do you use Yahoo Messenger? if so sometimes the ads a little bit bothering..?? if not then it takes up space to display your friends and it also consume a bandwidth (especially bothering home user with dial-up). If you want to chat comfortly using YM 8 or 9 but dont want to displaying the ads and also dont want to use GAIM then use this steps:

- Copy paste below script on notepad.
- Save as .bat file (i.e. noYMads.bat)
- Run it (double-click on the file)

Read the rest of this entry »

Summary of 6 Must Have Replacement Tools when Fixing a Computer Infected by Virus

If your PC infected by a good and powerfull virus/trojan/malware, it may disable access to Task Manager, Regedit, MSConfig, etc and unable to run several native Windows programs to clean it up. So in addition to your favorits anti virus softwares, here are list of utilities that you should have

Read the rest of this entry »

Kusma!!!, Now I know how to make old mysql front ver 2.5 which created on 2002 and using libmysql from mysql 3.23 accessing mysql5 server. I just realized this when Andry complaining and whining can’t access Ivory DB on new server which also mysql5 using his old mysql-front. He said, he can use mysql-front 2.5 accessing Mysql server 5 on his localhost and BOX server.

Now, if I can make sure old mysql-front program accessing mysql server 5 this will make major leap!!!
old zeos component (which also based on libmysql from mysql 3.23) for delphi 5 now can access Mysql 5 server. God know what happen when mysql5 take control, replacing old and dull mysql4. We can make master-master replication, clustering mysql server or make mysql serve faster by running mysql proxy. But it depend on how much the company will spend money for investing on hardware (and pay me of course to execute it)

Kusma, do you want to know how to enable Mysql server 5 to acknowledge old mysql-front program to access it? if so comment to this article please

From Howtoforge.com’s article: Running MySQL 4 And MySQL 5 Concurrently

But I did in another way, because current release of CentOS / RHEL 5 already include MySQL 5 and I install MySQL 4 manually. I need a server with 2 MySQL version for development purpose: as current development is using MySQL 4 so I’ll configure it to use default port 3306 and for MySQL 5 will use port 3307.

First install CentOS with MySQL 5, afterthat configure MySQL 5 to use port 3307

# cp /usr/share/doc/mysql-server-5.0.22/my-medium.cnf /etc/my.cnf
# vi /etc/my.cnf
...
[client]
#password       = your_password
port            = 3307
socket          = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port            = 3307
socket          = /var/lib/mysql/mysql.sock
...
# chkconfig mysqld on
# service mysqld start

To add new mysql user you can read “Adding mysql users“, to change mysql’s root password use:

# /usr/bin/mysqladmin -u root password 'newpassword'

Now we are going to install MySQL 4

Read the rest of this entry »