Tech N Me

vi search

2011-11-10T00:43:00.000-08:00

Vi: Search and Replace

Change to normal mode with .

Search (Wraped around at end of file):

  Search STRING forward :   / STRING.
 Search STRING backward:   ? STRING.

 Repeat search:   n
 Repeat search in opposite direction:  N  (SHIFT-n)

Replace: Same as with sed, Replace OLD with NEW:

First occurrence on current line:      :s/OLD/NEW

Globally (all) on current line:        :s/OLD/NEW/g

Between two lines #,#:                 :#,#s/OLD/NEW/g

Every occurrence in file:              :%s/OLD/NEW/g

Copy from cloud (big file)

2011-10-30T21:04:00.000-07:00

copy a very huge file from 1 location to other location. In my case I wanted to copy a very big DB from Cloud (amazon) to my production side.

the CL :

nohup mysql -uroot -pyourpassworddatabase --default-character-set=utf8 < a.sql > dump.log 2 > error.log &

WMI on windows for zenoss

2011-08-02T01:11:00.000-07:00

taken somewhere from internet.

Yes, there shoulb be a difference between Administrator and users even in Administrators built-in group for the UAC (User Account Control) feature in Windows Vista and Windows Server 2008.

Under UAC, accounts in the local Administrators group have two access tokens, one with standard user privileges and one with administrator privileges. Because of UAC access token filtering, a remote WMI query is always run under the standard user token.

So for a computer in workgroup, even if the account is in the Administrators group, UAC filtering means that a script runs as a standard user. A best practice is to create a dedicated local user account on the target computer with explicit DCOM and WMI namespace access rights granted specifically for remote connections.

1. Open the Component Services by run 'dcomcnfg' in command prompt.
2. Expand Component Services--->Computers nodes and right click My Computer.
3. In the COM Security tab, explicitly grant the AdminB local and remote Lauch and Activation permissions in both 'Edit Limits…' and 'Edit Default…'.
4. Open the WMI management by run 'wmimgmt.msc' in command prompt.
5. Connect it to local, right click--->Properties--->Security. Grant the AdminB local account 'Execute Methods' and 'Remote Enable' permission apply onto 'This namespace and subnamespaces'.

Note: The permissions for AdminB in DCOM and WMI namespace is much depend on what will the script do. Please make necessary change to fulfill the specific require.

Hope it helps

Proftpd on freebsd

2011-07-25T23:28:00.001-07:00

let say you have 1 machine fresh install FreeBSD.
here the step by step to make this server as FTP server.

install proftpd

cd /usr/ports/ftp/proftpd
make config (depend on your setting & use)
make install (wait for several minutes)

after complete
rehash
setting up your proftpd
ee /usr/local/etc/proftpd.conf
my setting

# For more informations about Proftpd configuration
# look at : http://www.proftpd.org/
#
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.

ServerName "ProFTPD Mediu"
ServerType standalone
DefaultServer on
ScoreboardFile /var/run/proftpd/proftpd.scoreboard

# Port 21 is the standard FTP port.
Port 21

# Use IPv6 support by default.
#UseIPv6 off

# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022

# To prevent DoS attacks, set the maximum number of child processes
# to 30. If you need to allow more than 30 concurrent connections
# at once, simply increase this value. Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd).
MaxInstances 30

CommandBufferSize 512

# Set the user and group under which the server will run.
User nobody
Group nogroup

# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
#DefaultRoot ~

# Normally, we want files to be overwriteable.
AllowOverwrite on

# Bar use of SITE CHMOD by default
DenyAll

# A basic anonymous configuration, no upload directories. If you do not
# want anonymous users, simply delete this entire section.

#########################################################################
# #
# Uncomment lines with only one # to allow basic anonymous access #
# #
#########################################################################

#
# User ftp
# Group ftp

### We want clients to be able to login with "anonymous" as well as "ftp"
# UserAlias anonymous ftp

### Limit the maximum number of anonymous logins
# MaxClients 10

### We want 'welcome.msg' displayed at login, and '.message' displayed
### in each newly chdired directory.
# DisplayLogin welcome.msg
# DisplayFirstChdir .message

### Limit WRITE everywhere in the anonymous chroot
# # DenyAll
#
#
# User guest
User ftp
# Group nobody
Group nogroup
AnonRequirePassword off
RequireValidShell off
UseFtpUsers off
# UserAlias anonymous guest
UserAlias anonymous ftp
UserAlias guest ftp
MaxClients 10
DenyAll
Umask 002
AllowAll
DenyAll
AllowAll

# Deny write access from all except trusted hosts.
##
## Order allow, deny
## Allow from 172.16.10.0.
## Deny from all
##
##

# FTPS
#Include /usr/local/etc/tls.conf

Reindexing Microsoft SQL Databases to Optimize Performance

2011-07-11T21:29:00.000-07:00

Reindexing Microsoft SQL Databases to Optimize Performance

To reindex all the indexes in a Microsoft SQL database, follow these steps:

1. On the Start menu, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.

2. In the Connect to SQL Server dialog box, click OK.

3. On the Query menu, click Change Database.

4. In the Select Database of dialog box, click the Microsoft CRM database that you want to work on, and then click OK.

5. In the Query window, type the following commands:

DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Reindexing ' + @TableName
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor

6. Click the Execute Query button on the toolbar, and the results will show in the results panel.

Thanks to webdigo

Enable htaccess on ubuntu

2011-06-29T21:36:00.001-07:00

Found the solution!! Apache2 in general, or it might be specifically to Ubuntu, is configured slightly differently than Apache1.x.. at least from what I've seen in the default installs in RH, FC, Mandrake, etc (I'm not Linux or Apache expert).

I went to /etc/apache2/sites-available and edited the file default
There you'll find:

Code:

NameVirtualHost *

       ServerAdmin admin@site.com

       DocumentRoot /var/www/
       
               Options FollowSymLinks
               AllowOverride None
       
       
               Options Indexes FollowSymLinks MultiViews
               AllowOverride All
               Order allow,deny
               allow from all
               # This directive allows us to have apache2's default start page
               # in /apache2-default/, but still have / go to the right place
               # Commented out for Ubuntu
               #RedirectMatch ^/$ /apache2-default/

Default for AllowOverride is none, should be all
/etc/init.d/apache2 restart to restart apache and your .htaccess files should now work!! How frustrating, but educational

Credit to Ubuntu forum

Freebsd apache rotation log / change directory

2011-06-20T20:26:00.000-07:00

Freebsd apache rotation log / change directory

add this line at ee /etc/newsyslog.conf

# Rotating Apache log ~ Dipetik dari : http://mikkel.hoegh.org/blog/2009/oct/8/rotating-apache-httpd-logfiles-freebsd

#/var/log/httpd-access.log www:www 440 9 * $W1D4 J /var/run/httpd.pid 30
/data/log/httpd-access.log www:www 440 9 * $D11 J /var/run/httpd.pid 30
/var/log/httpd-error.log www:www 440 9 * $W1D4 J /var/run/httpd.pid 30

after adding at httpd.conf

search http-access.log

CustomLog "/data/log/httpd-access.log" combined

and adding / replace at vhost.conf (if you using vhost)

CustomLog "/data/log/httpd-access.log" common

Restart Apache

error : (98)Address already in use: make_sock: could not bind to address 0.0.0.0:80

2011-06-15T02:17:00.000-07:00

(98)Address already in use: make_sock: could not bind to address 0.0.0.0:80

I would like to state first of all I am a novice with Linux, but have working in IT for 15 years. I have been searching the web on this issue for almost 2 days (off and on), and have found that my particular issue was not the same as the norm for this particular error code. I would like to give back (if you will).

Apparently having a cert.key password protected will hang Apache2 (maybe Apache as well). The solution was to remove the password on the cert.key and that solved my problem.

The general consensus with resolving this issue did help me figure out that apache2 was running but waiting for password on boot-up. The following command which you will find everywhere out in the cloud is as follows:

sudo netstat -ltnp | grep ':80' (it is important to note that apache was hanging and it did not matter what port I decided to investigate)

This would return the following:
tcp6 0 0 :::80 :::* LISTEN 1047/apache2

Then I ran the following command:

sudo kill -9 1047 (the pid that appears on your particular instance)

I was able to restart Apache and everything was groovy until I rebooted.

I suspected the password and started researching the how to remove the passphrase off of the cert key and found the following article:

http://www.mnxsolutions.com/apache/r...n-ssl-key.html

The following part of the page actually helped me:

Always backup the original key first (just in case)!

# cp www.key www.key.origThen unencrypt the key with openssl. You’ll need the passphrase for the decryption process:

# openssl rsa -in www.key -out new.keyNow copy the new.key to the www.key file and you’re done. Next time you restart the web server, it should not prompt you for the passphrase.

I hope this helps and saves someone some valuable time.

credit to : hhabashy & http://ubuntuforums.org/showthread.php?t=1636667

Change mysql directory on ubuntu 10.04

2011-06-12T20:14:00.000-07:00

First you need to Stop MySQL using the following command

sudo /etc/init.d/mysql stop

Now Copy the existing data directory (default located in /var/lib/mysql) using the following command

sudo cp -R -p /var/lib/mysql /path/to/new/datadir

All you need are the data files, so delete the others with the command

sudo rm /path/to/new/datadir

Note:- You will get a message about not being able to delete some directories, but that’s what you want.

Now edit the MySQL configuration file with the following command

gksu gedit /etc/mysql/my.cnf

Look for the entry for “datadir”, and change the path (which should be “/var/lib/mysql”) to the new data directory.

Important Note:-From Ubuntu 7.10 (Gutsy Gibbon) forward, Ubuntu uses some security software called AppArmor that specifies the areas of your filesystem applications are allowed to access. Unless you modify the AppArmor profile for MySQL, you’ll never be able to restart MySQL with the new datadir location.

In the terminal, enter the command

sudo gedit /etc/apparmor.d/usr.sbin.mysqld

Copy the lines beginning with “/var/lib/mysql”, comment out the originals with hash marks (“#”), and paste the lines below the originals.

Now change “/var/lib/mysql” in the two new lines with “/path/to/new/datadir”. Save and close the file.

Restart the AppArmor profiles with the command

sudo /etc/init.d/apparmor reload

Restart MySQL with the command

sudo /etc/init.d/mysql restart

Now MySQL should start with no errors, and your data will be stored in the new data directory location.

credit to : http://www.ubuntugeek.com/how-to-change-the-mysql-data-default-directory.html

How to block port 80 on ubuntu

2011-05-05T00:46:00.000-07:00

I just block my port 80 by using this CLI

iptables -A INPUT -j DROP -p tcp --destination-port 80 -i eth0

The code above will drop all tcp packets coming into your Linux computer on device eth0 on port 80. If your Internet connection runs through a device other than eth0, go ahead and make the adjustment.

To remove the iptables rule use the following code:
iptables -D INPUT -j DROP -p tcp --destination-port 80 -i eth0

credit to : foogazi

SSL on Ubuntu

2011-05-04T20:02:00.000-07:00

I just install SSL configuration on my backup server for security reason & i have made it with Mr. Mike how to.

Currently my machine running on Ubuntu 10.10 with Apache2 & Backuppc

Below step by step how to :

Setting up SSL with Ubuntu 8.10 is a simple process but it does have a few gotchas that you need to be aware of. The setup has changed from 8.04. One issue is that the +CompatEnvVars is no longer used as it created a bug in 8.10 and you will have to enable the default-ssl site to get everything working.

First, log on to your server Install Apache:

sudo apt-get install apache2

Change to the /etc/apache2/mods-available directory and look at the available modules. Then change to the /etc/apache2/mods-enabled directory to see what modules are enabled:

cd /etc/apache2/mods-available
ls
cd /etc/apache2/mods-enabled
ls

Now, install and enable SSL:

sudo a2enmod ssl
sudo /etc/init.d/apache2 force-reload

Change to the default webserver directory, and create a simple web page:
cd /var/www
sudo vim index.html

Add the following content:

Save and exit. On your own local computer, open a tab or window for your web browser. For the URL, enter:

http://IP_address_of_my_server

You should be able to view your web page. Now, you’ll want to encrypt your site. Create the server encryption keys:

cd /etc/apache2
sudo openssl genrsa -des3 -out server.key 1024

Use this set of keys to create a certificate request:

sudo openssl req -new -key server.key -out server.csr

When asked to input data, use your imagination to create something appropriate. Be sure to write down your passphrase. Use this request to create your self-signed certificate:

sudo openssl x509 -req -days 365 -in server.csr -signkey server.key -out server.crt

Install the key and certificate:

sudo cp server.crt /etc/ssl/certs/
sudo cp server.key /etc/ssl/private/

Open the “defaults” file for editing:

cd /etc/apache2/sites-available
sudo vim default-ssl

This file is basically set up but you will want to uncomment the SSLOptions line and also change the SSLCertificate lines to reflect the location and name of your new information.

SSLEngine on
SSLOptions +FakeBasicAuth +ExportCertData +StrictRequire
SSLCertificateFile /etc/ssl/certs/server.crt
SSLCertificateKeyFile /etc/ssl/private/server.key

The port 443 is enabled when you use SSL so that is ready to go.

Enable the default SSL site:
sudo a2ensite default-ssl

If you do not enable the default-ssl you will get this error:
“ssl_error_rx_record_too_long apache”

Restart Apache.

sudo /etc/init.d/apache2 restart

You now be able to see your web site running on https

Thanks & credit to : http://beginlinux.com/blog/2009/01/ssl-on-ubuntu-810-apache2/ & Mr. Mike

Restore backup mysql to a remote mysql server.

2011-05-02T18:26:00.000-07:00

Restore backup mysql to a remote mysql server.

mysql -unameuser -p --default-character-set=utf8 < dbname.sql --host=yourIPmysqlServer

* Please take note you must granted the user before restore the DB.

This is for me.

2011-04-19T01:18:00.001-07:00

copy mysql db to cloud

- dump your db
- mv to www server
- go to amazon aws server
- run this

sudo scp username@www.mediu.edu.my: ./

wait untuil it finish

SNMPD on freebsd

2011-04-07T21:33:00.000-07:00

I'm using FreeBSD 8.2 and here's the basics for getting snmp working:

cd /usr/ports/net-mgmnt/net-snmp
make
make install
make clean

edit /etc/rc.conf
add snmpd_enable="YES"

cd /usr/local/share/snmp
edit snmpd.conf (you may have to create it)
add the following
syslocation home (replace home with whatever you'd like)
syscontact me@here.com (put in your e-mail or whatever)
rocommunity private (replace with whatever read only name you'd like)
rwcommunity public (again, change this to whatever you'd like)
master yes
now save and exit

cd /usr/local/etc/rc.d
./snmpd.sh start

This will get you up and running with a very basic snmp configuration. There's a handy utility called 'snmpconf' that can be run to help you generate the snmp.conf (optional) and snmpd.conf files. This will give you more options and help tighten up security.

at this point you should be able to snmpwalk your host
snmpwalk -v1 -c public 127.0.0.1

format HDD on Ubuntu 10.10

2011-04-06T18:46:00.001-07:00

After add HDD on your ubuntu box
check your hdd either its already present or not by using

fdisk -l

on your screen you will see

Disk /dev/cciss/c0d1: 1499.8 GB, 1499832039424 bytes
Disk /dev/cciss/c0d1 doesn't contain a valid partition table

after you know your OS HDD first hdd must be c0d0 and the number will increse on d example c0d0,c0d1,c0d2 etc

run this command to format your hdd, for this tutorial i will format ext3 for my HDD

mkfs.ext3 /dev/cciss/c0d1

wait for few minutes
now you done!

FreeBSD Update from 7. (01234) or 8.(01)

2011-02-27T23:27:00.001-08:00

FreeBSD Update

The freebsd-update(8) utility supports binary upgrades of i386 and amd64 systems running earlier FreeBSD releases. Systems running 7.[01234]-RELEASE, 8.[01]-RELEASE, 8.2-BETA1, or 8.2-RC[123] can upgrade as follows:

# freebsd-update upgrade -r 8.2-RELEASE

During this process, FreeBSD Update may ask the user to help by merging some configuration files or by confirming that the automatically performed merging was done correctly.

# freebsd-update install

The system must be rebooted with the newly installed kernel before continuing.

# shutdown -r now

After rebooting, freebsd-update needs to be run again to install the new userland components:

# freebsd-update install

At this point, users of systems being upgraded from FreeBSD 7.4-RELEASE or earlier will be prompted by freebsd-update to rebuild all third-party applications (e.g., ports installed from the ports tree) due to updates in system libraries.

After updating installed third-party applications (and again, only if freebsd-update printed a message indicating that this was necessary), run freebsd-update again so that it can delete the old (no longer used) system libraries:

# freebsd-update install

Finally, reboot into 8.2-RELEASE:

# shutdown -r now

** taken from FreeBSD Website

No Hup

2011-01-11T01:04:00.001-08:00

Run nohup mysql

nohup mysql -uroot -pyourpasswddb --default-character-set=utf8 <> dump.log 2> error.log &

or

nohup mysql -uroot -pyourpasswddb --default-character-set=utf8 < namedb > error.log &

How To Monitor Mysql using Zenoss

2010-11-04T00:31:00.000-07:00

On the Zenoss server ensure your device has the Mysql zenpack

On the mysql server you plan to monitor do the following;

Add a user to Mysql so that zenoss can connect.

mysql -u root -p

grant ALL PRIVILEGES ON *.* TO ‘zenoss’@'yourzenossdomain’ IDENTIFIED BY ‘yourpassword’;

FLUSH PRIVILEGES;

Don’t forget to open port 3306 on the firewall of the Mysql server if necessary.

On the Zenoss server add the mysql user and password to zproperties of the device.

If Mysql version <5> 5

You can test that your monitored server can authenticate from your Zenoss server by

mysql -u zenoss -p -h yourmonitoredserverip

credit to http://www.how-to-linux.com

Downgrade PHP on ubuntu Server

2010-10-29T01:37:00.001-07:00

go to /usr/local/sbin

create this script

nano downgrade.sh

enter

#!/bin/bash
# by Ruben Barkow (rubo77) http://www.entikey.z11.de/

# Originally Posted by Bachstelze http://ubuntuforums.org/showthread.php?p=9080474#post9080474
# OK, here's how to do the Apt magic to get PHP packages from the karmic repositories:

echo "Am I root?  "
if [ "$(whoami &2>/dev/null)" != "root" ] && [ "$(id -un &2>/dev/null)" != "root" ] ; then
 echo "  NO!

Error: You must be root to run this script.
Enter
sudo su
"
 exit 1
fi
echo "  OK";


# finish all apt-problems:
apt-get -f install

# remove all your existing PHP packages. You can list them with dpkg -l| grep php
PHPLIST=$(for i in $(dpkg -l | grep php|awk '{ print $2 }' ); do echo $i; done)
echo these pachets will be removed: $PHPLIST
# you need not to purge, if you have upgraded from karmic:
aptitude remove $PHPLIST
# on a fresh install, you need purge:
# aptitude remove --purge $PHPLIST


#Create a file each in /etc/apt/preferences.d like this (call it for example /etc/apt/preferences.d/php5_2);
#
#Package: php5
#Pin: release a=karmic
#Pin-Priority: 991
#
#The big problem is that wildcards don't work, so you will need one such stanza for each PHP package you want to pull from karmic:

echo ''>/etc/apt/preferences.d/php5_2
for i in $PHPLIST ; do echo "Package: $i
Pin: release a=karmic
Pin-Priority: 991
">>/etc/apt/preferences.d/php5_2; done

# duplicate your existing sources.list replacing lucid with karmic and save it in sources.list.d:
#sed s/lucid/karmic/g /etc/apt/sources.list | sudo tee /etc/apt/sources.list.d/karmic.list

# better exactly only the needed sources, cause otherwise you can get a cachsize problem:
echo "# needed sources vor php5.2:
deb http://de.archive.ubuntu.com/ubuntu/ karmic main restricted
deb-src http://de.archive.ubuntu.com/ubuntu/ karmic main restricted

deb http://de.archive.ubuntu.com/ubuntu/ karmic-updates main restricted
deb-src http://de.archive.ubuntu.com/ubuntu/ karmic-updates main restricted

deb http://de.archive.ubuntu.com/ubuntu/ karmic universe
deb-src http://de.archive.ubuntu.com/ubuntu/ karmic universe
deb http://de.archive.ubuntu.com/ubuntu/ karmic-updates universe
deb-src http://de.archive.ubuntu.com/ubuntu/ karmic-updates universe

deb http://de.archive.ubuntu.com/ubuntu/ karmic multiverse
deb-src http://de.archive.ubuntu.com/ubuntu/ karmic multiverse
deb http://de.archive.ubuntu.com/ubuntu/ karmic-updates multiverse
deb-src http://de.archive.ubuntu.com/ubuntu/ karmic-updates multiverse

deb http://security.ubuntu.com/ubuntu karmic-security main restricted
deb-src http://security.ubuntu.com/ubuntu karmic-security main restricted
deb http://security.ubuntu.com/ubuntu karmic-security universe
deb-src http://security.ubuntu.com/ubuntu karmic-security universe
deb http://security.ubuntu.com/ubuntu karmic-security multiverse
deb-src http://security.ubuntu.com/ubuntu karmic-security multiverse
" >> /etc/apt/sources.list.d/karmic.list

aptitude update

apache2ctl restart

echo install new from karmic:
aptitude -t karmic install $PHPLIST

# at the end retry the modul libapache2-mod-php5 in case it didn't work the first time:
aptitude -t karmic install libapache2-mod-php5

apache2ctl restart

chmod +x /usr/local/sbin/downgrade.sh
run the script
sh downgrade/sh

wait until it finish
now you done

APR-1 Apache upgrade problem

2010-08-31T18:03:00.000-07:00

I face a problem when i want to upgrade apache form 2.2.14 to 2.2.16.
When the upgrade is running the running stop at apr-1
than this step save my life.

It wasn't clear to me, but, in the end I uninstalled apr1, and then let the 'apache install' reinstall it. Here's the sequence that worked for me

pkgdb -F;portsclean -CDD;portsnap fetch update
cd /usr/ports/www/apache22
make deinstall clean
portupgrade -f -o devel/apr1 devel/apr
cd /usr/ports/devel/apr1
make deinstall clean
cd /usr/ports/www/apache22
make install clean

Taken from http://forums.freebsd.org/archive/index.php/t-14338.html

Portupgrade

2010-08-19T19:21:00.000-07:00

I learn something new from my sifoo

try to run portupgrade :

portupgrade /var/db/pkg/namepackage

make fetch-recursive-list

Mysql Replication

2010-07-22T20:50:00.000-07:00

Follow this step to create / install a replication DB for mysql

http://www.howtoforge.com/mysql_database_replication

if uo have an error after / fini9sh installation using thie replication try this :

error 1 =

>LOAD DATA FROM MASTER;
Query OK, 0 rows affected, 1 warning (0.12 sec)
>

try to run this :

mysql> GRANT RELOAD on *.* to repl@'%' identified by 'your_password';
OR
mysql> GRANT SUPER on *.* to repl@'%' identified by 'your_password';

Reference : http://www.linuxismybff.com/howto/mysql/mysql-basic-replication-setup/

if you still have this warning error try to run this :

mysql -u root -p
Enter password:
SLAVE STOP;

CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user', MASTER_PASSWORD='', MASTER_LOG_FILE='mysql-bin.006', MASTER_LOG_POS=183;

START SLAVE;
quit;

Install SNMPD on Ubuntu

2010-06-28T18:20:00.000-07:00

1.Installation

root@ibsen:~# sudo apt-get install snmpd
Reading package lists... Done
Building dependency tree     
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libmpich1.0gf libdc1394-22 genisoimage linux-headers-2.6.27-7 libgfortran2 dvd+rw-tools linux-headers-2.6.27-7-generic libcarp-clan-perl libxml-xql-perl libparse-yapp-perl
  rdate python-xml localechooser-data gcc-4.2-base libimage-size-perl libdebconfclient0 libvisual-0.4-0 libmyth-python perlmagick libvisual-0.4-plugins libavdevice52
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  libperl5.10 libsensors3 libsnmp-base libsnmp15
Suggested packages:
  lm-sensors
The following NEW packages will be installed:
  libperl5.10 libsensors3 libsnmp-base libsnmp15 snmpd
0 upgraded, 5 newly installed, 0 to remove and 3 not upgraded.
Need to get 2463kB of archives.
After this operation, 7987kB of additional disk space will be used.
Do you want to continue [Y/n]?

answer y

2. Configuration

Move existing /etc/snmp/snmpd.conf configuration file to /etc/snmp/snmpd.conf.org

mv /etc/snmp/snmpd.conf  /etc/snmp/snmpd.conf.org

Create a new /etc/snmp/snmpd.conf file:

rocommunity  public
syslocation  "PDC, Peters DataCenter"
syscontact  peter@it-slav.net

Make snmpd use the newly created file and make it listen to all interfaces:

Edit /etc/default/snmpd

Change from:

# snmpd options (use syslog, close stdin/out/err).
SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid 127.0.0.1'

To:

# snmpd options (use syslog, close stdin/out/err).
#SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid 127.0.0.1'
SNMPDOPTS='-Lsd -Lf /dev/null -u snmp -I -smux -p /var/run/snmpd.pid -c /etc/snmp/snmpd.conf'

and restart snmpd

/etc/init.d/snmpd restart

Credit to http://www.it-slav.net/blogs/2009/02/05/install-and-configure-snmp-on-ubuntu/

Change usr directory to other HDD / Partition

2010-06-23T19:25:00.000-07:00

to change the usr directory in freebsd (i already make it)
add new hdd to your server, format it. let say i give the new patition is /usr2
after finish format

cd /usr2
dump 0af - /usr | restore rf -

After the dump completed, edited /etc/fstab.
Delete the line with /usr in /etc/fstab.
Updated the line with /usr2, changed /usr2 for /usr. (inside fstab)
Then rebooted. Finally the system started with a new /usr filesystem.

Done!

Credit to BSD Forum!

reset your mysql root password

2010-06-23T00:33:00.000-07:00

Stop mysql dulu

#/usl/local/etc/rc.d/mysql-server stop.

#mysqld_safe --skip-grant-tables

than open new shell and go to the mysql-server

#mysql --user=root mysql

now you enter the mysql server and run this command

update user set Password=PASSWORD('new-password') where user='root';
flush privileges;
exit;

start the server

done

make symbolic link on Unix

2010-06-15T00:13:00.001-07:00

# ln -s /usr/home /home or ln -s /data/moodle2/ moodle2

How to Lock / Unlock User in ubuntu

2010-06-13T20:43:00.000-07:00

For Locking User from command Line

$ sudo usermod -L waxs This will Lock user account named waxs

For Locking User from command Line

$ sudo usermod -U waxs This will UnLock user account named waxs

list all installed application on ubuntu

2010-06-03T00:29:00.000-07:00

list all installed application on ubuntu

dpkg --get-selections

Centos - Adduser

2010-06-01T23:49:00.001-07:00

You can also do this from the command line, below are the equivalent commands. You need to have root level access to use the commands below.

usr/sbin/useradd [options] login_name
creates a new user
usr/sbin/usermod [options] login_name
modifies a user’s attributes
usr/sbin/userdel [options] login_name
deletes the specified user. Use the -r option to automatically remove the user’s home directory and mail spool.
usr/bin/passwd login_name
sets the password for the specified user
usr/sbin/groupadd [options] group_name
creates a new group
usr/sbin/groupmod [options] group_name
modifies a group’s attributes
usr/sbin/groupdel group_name
deletes the specified group

Restore compressed backup files (MYSQL)

2010-05-23T20:05:00.000-07:00

the commandline is :

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

** if you dump file bz2 you can use bunzip2

Script to rename multiple table in MySQL

2010-05-20T01:00:00.001-07:00

Baru-baru ni aku faced problem untuk rename table prefix secara pukal...kat database tu ada 186 tables...
kalau nak tukar satu-satu...pergghh...memang lebam...setelah google punya google...aku jumpa solution ni...tapi kena pakai ruby script dan tukar ke sql statement..tapi kalau korang nak pakai convert ke php pun x de hal...guna concept yg sama jek...

Ikut ni :

masuk mysql...pastu show tables;
copy semua tables yg korang nak rename tu...
paste kat dlm script ni (dlm cth ni aku bagi nama file ni batch_rename.sh ) :

OLD_PREFIX = "mdl"
NEW_PREFIX = "mdlsirap"
data=<<-EOD | mdl_assignment | | mdl_assignment_submissions | | mdl_backup_config | | mdl_backup_courses | | mdl_backup_files | | mdl_backup_ids | | mdl_backup_log | | mdl_block | | mdl_block_instance |
| mdl_block_pinned |
EOD
tables = []
data.each_line do |line|
if line=~/(#{OLD_PREFIX}\w+)/
puts "RENAME TABLE #{$1} TO #{NEW_PREFIX}#{$1};"
end
end
Pastu runkan script ni pakai ruby punya command-line (aku assume korang dah install ruby) :
#ruby batch_rename.sh
Dia akan kluar output :
RENAME TABLE mdl_assignment TO mdlsirap_assignment;
RENAME TABLE mdl_assignment_submissions TO mdlsirap_assignment_submissions;
RENAME TABLE mdl_backup_config TO mdlsirap_backup_config;
RENAME TABLE mdl_backup_courses TO mdlsirap_backup_courses;
RENAME TABLE mdl_backup_files TO mdlsirap_backup_files;
RENAME TABLE mdl_backup_ids TO mdlsirap_backup_ids;
RENAME TABLE mdl_backup_log TO mdlsirap_backup_log;
RENAME TABLE mdl_block TO mdlsirap_block;
RENAME TABLE mdl_block_instance TO mdlsirap_block_instance;
RENAME TABLE mdl_block_pinned TO mdlsirap_block_pinned;
just masukan sql statement ni dlm satu file lain...tapi kalau nak senang...buat step no. 4 tu camni :
#ruby batch_rename.sh > a.sql
Runkan sql file tu guna mysql...:
#mysql namadatabase <>
Selesai....

reference :
http://zerokspot.com/weblog/e/676/

Repair table MYSQL

2010-05-19T21:01:00.001-07:00

Today i face 1 problem when i want mysqldump my D. my error is

Incorrect key file for table 'mdl_block_instance'; try to repair it

This command to help you to auto-repair your table on mysql

mysqlcheck -uusername -p --auto-repair namedatabase

Netcat Tar

2010-05-11T01:33:00.001-07:00

This is suitable if you don't have enough space on the source machine.

On sender :

tar -czf - directory-name | nc -l 3333

on receiver :

nc sender-ip-address 3333 > mybackup.tar.gz

Courtesy : Sifoo Zaman.

Change Login Directory (FreeBSD)

2010-05-11T01:16:00.000-07:00

today i learn something.

How to change directory when login.

Login as root
setenv EDITOR ee (i need this because i don't know how to use VI in BSD)
type vipw
edit the directory at user you want to edit
save & exit

DONE

Hidden Apache directory listing

2010-05-06T01:39:00.000-07:00

If you are on an RPM installation of Apache (which i dont really recommend) you will find the apache configuration file probably here:

/etc/httpd/conf/httpd.conf

If you are using apache from the source tar balls ( like real men ) probably you will find the configuration file here:

/usr/local/apache/conf/httpd.conf

Using an editor like vi , edit the httpd.conf file and scroll until you find a line like this:

Options All Indexes FollowSymLinks MultiViews

To disable directory browsing carefully remove the line that says: Indexes and leave the line like this:

Options All FollowSymLinks MultiViews

Restart your apache webserver and thats it

reference http://www.felipecruz.com/blog_disable-directory-listing-browsing-apache.php

Setting Clock on Centos

2010-05-04T23:48:00.000-07:00

what im doing to configure clock on centos

install ntp

yum install ntp

after finish run

ntpdate ntp.asia.pool.org

done!

Search using mysqlbinlog (troubleshoot)

2010-05-04T20:29:00.000-07:00

simply go to or where your mysqlbinlog located :

after you find it run this command
mysqlbinlog mysql-bin.0000xx | grep nametosearch > namefile.txt

Dump using sed & mysqldump

2010-05-04T20:26:00.000-07:00

Dump table mysql using sed

sed -n '/^-- Table structure for table \`nametable\`/,/^-- Table structure for table/p" namedb > namatable.sql

using mysqldump

mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

restore DB / table

mysql -u username -ppassword databasename < /tmp/databasename.sql Dump table mysql using sed

sed -n '/^-- Table structure for table \`nametable\`/,/^-- Table structure for table/p" namedb > namatable.sql

using mysqldump

mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

restore DB / table

mysql -u username -ppassword databasename < /tmp/databasename.sql

Mysqldump only the structure

2010-05-04T20:24:00.000-07:00

run this command for mysql backup only the data structure

mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql

2010-04-21T19:02:00.000-07:00

How To Rsync at Freebsd Using ssh.

Before rsync,your have to make sure your BSD box already insttaled rsync. If you don't have it please to do so and please to install both of your server.

You can install rsync using ports (Please to csup your ports 1st to get the new packages)

#cd /usr/ports/net/rsync/
#make config
#make && make install
#rehash.

Start to rsync.

i am only rsync forder usr/src.
#rsync -av -e "ssh -l admin" root@servername:/usr/src/ /usr/src/

After finish do not reboot, please re-compile.
** I recommended to csup the stable_supfile 1st before your compile your kernel.

#cd /usr/src
#make cleanworld && make cleandir
#make buildworld
#make buildkernel KERNCONF=YOUR_KERNEL_HERE' (default is GENERIC).
#make installworld
#make installkernel KERNCONF=YOUR_KERNEL_HERE' (default is GENERIC).
#reboot

Then start to rsync other folder.
Your can exclude any folder that you think not necessary.
I am rsync some folder such as boot or usr/src.

#rsync -av --exclude=/boot --exclude=/usr/src -e "ssh -l admin" root@servername:/ /

password will be prompted. Then enter password. wait until finish the rsync.

After finish

change ip address,hostname and vhost.

To change hostname.
#ee /etc/hosts

To change ip address
#ee /etc/rc.conf

to change vhost ** If you use it.
# ee /usr/local/etc/apache22/extra/httpd-vhosts.conf

then reboot your server

Rsync on linux box

2010-04-21T18:57:00.000-07:00

Consider you already have 2 Linux server then open terminal or ssh at the new Linux server.

type command below

#rsync -av --exclude=/boot-e ssh username@oldserverhost:/(source) /(destination)

or standard rsync

#rsync -av -e ssh username@oldserverhost:/home/old_home/ /home/new_home/

password will be prom then enter password.
i exclude boot file because it need difficult configuration. You also can exclude the folder you want to rsync too such as /root /home /lib or anything else.

After finish the transferring data, your have to reconfigure, the Ip address,hostname or any necessary file need such as apache, mysql or others that you use.

*Ip tables or firewall at linux sometime need to stop to running the application.

Mysqldump

2010-03-22T18:53:00.000-07:00

this how the usual CLI for mysqldump

mysqldump -u username -p dbname > backupname.sql

restore back from mysql

mysql -u username -p dbname '<' yousqldumpfile.sql

Recently, I was facing problem to restore a UTF8-Enabled database which stores a lot of Arabic text in the db itself.

I have to re-dump back the db by appending the --default-character-set=charset_name option in the dump command :

mysqldump -uroot -p --default-character-set=utf8 --databases yourdbname > yourdumpfile.sql

To restore, again you have to append the same option :

mysql -uroot -p --default-character-set=utf8 '<' youdumpsql.sql ** i need to add '<' because i will become hidden in this blog,if you want tu use the sqldump please to remove ' at '<' on restore CLI.

Thanks

Backup filesystem using dumpfs (FreeBSD)

2010-03-16T21:22:00.001-07:00

finally i got to backup filesystem using dumpfs

- i got script from this web http://my.galagzee.com/2009/07/17/freebsd-dump-filesystem-shell-script/
- touch a new file name "dumpfs.sh" and put at /usr/local/sbin/
- paste the script inside dumpfs.sh
- set at /etc/crontab

to restore from backup dumps
- restore rf 20100305_0

reference :
- http://my.galagzee.com/2009/07/17/freebsd-dump-filesystem-shell-script/

Vmware format ubuntu add hdd

2010-03-09T22:45:00.000-08:00

Let's get going!
Removing and creating a partition
Having decided your drive's name (let's call it sda) we must now remove the default partition that the manafacturer put there:
sudo fdisk /dev/sda
This will start fdisk. We want to remove the partion(s), there should only be one.
Press d (for delete).
It might ask you for the partition number, press 1 and enter. If there are more then delete them too.

Now to make a new partition.
Press n (for new), then p (for primary), then 1 and then simply press enter for the next two questions.
This will make a new partition that uses the entire disk. If you want more complex partitioning then read the fdisk manual (man fdisk) or use parted or some other app.
Here's what we did with n, the values will differ from yours:

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (197-621, default 197):
Using default value 197
Last cylinder or +size or +sizeM or +sizeK (197-621, default 621): +128M

Now to write the new partion and exit, press w and enter.
You should be ready to make a filesystem now.

Making a filesystem : "Formatting"
You need to put a system in-place, on the disk, such that it can handle files. This is called (unsurprisingly) a filesystem.
The one we are going to use is called "ext3". On Gnu/Linux we are spoiled for choice and there are loads of filesystems you can use, go do some research if you want to.
So, let's make the filesystem:sudo mkfs.ext3 /dev/sda1
* Note the 1 at the end, because we are making the filesystem in that partition (thanks Mike)

Now it will go off and do strange stuff, simply wait for it to finish.

Using the new file system
Well, at this point you should be able to right-click on the icon (on your Desktop) and choose "mount" (I assume that's the verb it will present to you). After that you should be able to open a window and use the drive*
* all this assumes it's an external USB drive.
If you cannot then you will need to mount it yourself, try:
sudo mkdir /media/sda1
sudo mount /dev/sda1 /media/sda1
Note: We are actually mounting the first partition on the drive, hence the 1 at the end: sda1
And the mounted directory can be anywhere you like, but its common location is /media.

Change location HDD from original VM to another VM

2010-03-08T22:52:00.000-08:00

If you have 1 server seperate 2 HDD example 1 for OS & another for data. Let talk about when the OS have a problem than how gonna you take out the HDD data to another VM machine. So this tutorial i made for me and for you as a knowledge tp know.

server A - original server have 2 HDD
server B - server

scenario

- when OS in server A crash or corrupted, don't panic! here the step. your data is save because you have a separated HDD on your VM.
- firstly create your new VM, install OS (for me i using Freebsd) after finish please add another HDD when the installation is completed. so now you have 2 HDD (the size on additional HDD depend on your server & need (in my case i create same capacity with the original server capacity for data))
- log in into server B and format the HDD using sysinstall (fdisk & label) the HDD. (remember to add at /etc/fstab for your new HDD)
- after finish format, open VM client browse the datastore your server A located.
- copy the second HDD.vmdk ( by default your HDD will namely nameserver_1.vmdk) copy this file and browse the folder server B & paste inside the folder server B.
- after finish copy you need to rename your the vmdk file that you copy from server B. To this try to ssh inside the vmware machine, by default your vm not allow the ssh protocol you need to open it.
- ssh your VM, go to /vmfs/volumes/datastore1 , go to path your server directory
- backup the nameserverB_1.vmdk to nameserverB_1ORI.vmdk
- rename the vmdk that you copy before nameserverA_1.vmdk to nameserverB_1.vmdk
- turn on your VM.

DONE

htpasswd tips

2010-03-02T22:30:00.000-08:00

to add another user on htpasswd file

htpasswd -s alimdevpass username

FreeBSD (add extra HDD on VMWare Environment)

2010-03-01T23:16:00.000-08:00

FreeBSD add another HDD on VMWARE and format it

- shutdown your server.
- open your vmware & choose the server you want to add
- edit & add HDD
- Turn on your server.
- become as root type sysinstall
- choose configure & FDISK
- choose a additional HDD that you add before. (BEWARE!!! Do not edit the existing HDD on your server,this may cause your server corrupted!)
- choose entire disk if you want to use all disk & W button (write)
- please choose NONE "do not tpuch master boot record"
- after finish push q button
- go back to main menu & choose Label (this is use to label your HDD)
- select C to create the FS (depend on your need) exp : /test01
- and select W to write the changes
- Select Q and edit at FSTAB (ee /etc/fstab)
- add this line to you fstab line
exp : /dev/da1s1 /test01 ufs rw 2 2
- save and reboot your server.

Update / Upgrade Ubuntu Server

2010-02-21T22:12:00.000-08:00

sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade

If the kernel or kernel modules have been updated, you should reboot your computer/server.

No netwrok after clone/copy using VMWare ESX

2010-02-11T18:00:00.000-08:00

After making a copy/clone of an ubuntu server 8.10, i face a network problem.

1. "ifconfig" shows no eth0 device, just the 127.0.0.1 loopback
2. "/etc/init.d/networking restart" reports:

SIOCSIFADDR: No such device
eth0: ERROR while getting interface flags: No such device
SIOCSIFNETMASK: No such device
SIOCSIFBRDADDR: No such device
eth0: ERROR while getting interface flags: No such device
Failed to bring up eth0.

Solution
When you create a complete clone/copy of your vmware machine, a new ethernet MAC address is assigned.

follow this step :
as a root
run this CLI

# rm -fr /etc/udev/rules.d/70-*
# reboot

after wakeup, try ifconfig.
now you get your network back.

Salud!

SUDO on FreeBSD

2010-02-09T18:55:00.000-08:00

as root install

sudo located at /usr/ports/security/sudo
make configure
make && make install

edit conf at

ee /usr/local/etc/sudoers

example and edit :

# Runas alias specification

# User privilege specification
root ALL=(ALL) ALL
kenan ALL=(www) ALL

note :

This Sudo command limits the user's power on the basis of the configuration made on the file "/etc/sudoers".
Generally in default case you might see something like this:

root ALL=(ALL) ALL
Above, you can see ALL 3 times. But what does it mean?
The first ALL: Run from any(all) host
The Second ALL: From any Terminal
The third ALL: Can Run any command

example :
usename ALL=(group) ALL

** note : !/usr/bin/su (this will prevent user to sudo su)

General sudoers File Record Format
usernames/group servername = (usernames command can be run as) command

Lock / Unlock user on FreeBSD

2010-02-09T18:52:00.000-08:00

Lock user :

pw lock nameuser

unlock user :

pw unlock nameuser

Rollback with MySQL Transaction Log

2010-01-19T16:48:00.000-08:00

Yesterday was a Grey Monday (almost turning into Black Monday)..

It happened that one of the MySQL DB was not backed-up and to make things more thrilling, one the table on the db was compromised.
Alhamdulillah, again, Zaman came to save the day.

Here what we did to rollback the transaction using the transaction log :

Read the transaction log in /var/db/myql/hostname-bin.xxxxxx
This is binary format. In order to read the file, you have to use mysqlbinlog command :

mysqlbinlog mysql-bin.000001

This will show every single transaction happened on that particular server.
Then setup new MySQL server (I strongly advise you to setup a new database since we do not want to mess the existing one.)
Dump the compromised db structure only (without data) then restore it in the new server.
Then simply run the mysqlbinlog command and extend it to restore back to the server :

mysqlbinlog mysql-bin.xxxxxx --database=yourdbname | mysql -uroot -p yourdbname

If you want to exclude the last transaction which normally will be the culprit, you can use --stop-datetime option. You should know when is the last point/time (before the culprit transaction) of the transaction.

By reading the transaction log, you will find the timestamp provided by MySQL. For example : 1263759884

Since mysqlbinlog format needs human readable format, you have to convert the timestamp to human readable format. Here is one of the online date converter :

http://www.epochconverter.com/

Once converted, append it into the command :

mysqlbinlog mysql-bin.000024 --database=yourdbname --stop-datetime="2010-01-17 22:11:16" | mysql -uroot -p yourdbname

That's it.

Add HDD on VMWARE (linux)

2010-01-14T18:36:00.000-08:00

- choose vm that you wish to add the HDD
- edit setting
- add and choose HDD
- follow the instruction
- fdisk -l to see all hdd status
- you will noticed /dev/sdb (not partitoned)
- format new partition : [root@localhost ~]# mkfs -t ext3 /dev/sdb1
- Create mount point and set up automatic mount when system start up [root@localhost ~]# mkdir /newdisk
- Add the following line into fstab
/dev/sdb1 /newdisk ext3 defaults 1 1

reboot machine

Add HDD on VMWARE (FreeBSD)

2010-01-13T17:52:00.001-08:00

I just finish adding HDD onto my Vmware server.

the step :

- choose vm that you wish to add the HDD
- edit setting
- add and choose HDD
- follow the instruction
- after adding go to server (freebsd)
- type sysinstall
- choose fdisk
- BEWARE! please make sure your HDD before you format it!
- after you choose your HDD, choose A and W (write the HDD)
- after finish,exit and choose label
- choose C (create) , edit the label and W (write) the HDD.
- edit the fstab (ee /etc/fstab)

example :
but beware too remember the path your HDD before edit the fstab.

/dev/da1s1d /data ufs rw 2 2

- save and reboot.

Setting in FSTAB add HDD in FreeBSD or Unix

2010-01-13T01:34:00.000-08:00

ee /etc/fstab

/dev/da2s1 /studentdata ufs rw 2 2

Script to rename multiple table in MySQL

2010-01-11T23:14:00.000-08:00

masuk mysql...pastu show tables;
copy semua tables yg korang nak rename tu...
paste kat dlm script ni (dlm cth ni aku bagi nama file ni batch_rename.sh ) :

OLD_PREFIX = "mdl"
NEW_PREFIX = "mdlsirap"
data=<<-EOD | mdl_assignment | | mdl_assignment_submissions | | mdl_backup_config | | mdl_backup_courses | | mdl_backup_files | | mdl_backup_ids | | mdl_backup_log | | mdl_block | | mdl_block_instance |
| mdl_block_pinned |
EOD
tables = []
data.each_line do |line|
if line=~/(#{OLD_PREFIX}\w+)/
puts "RENAME TABLE #{$1} TO #{NEW_PREFIX}#{$1};"
end
end
Pastu runkan script ni pakai ruby punya command-line (aku assume korang dah install ruby) :
#ruby batch_rename.sh
Dia akan kluar output :
RENAME TABLE mdl_assignment TO mdlsirap_assignment;
RENAME TABLE mdl_assignment_submissions TO mdlsirap_assignment_submissions;
RENAME TABLE mdl_backup_config TO mdlsirap_backup_config;
RENAME TABLE mdl_backup_courses TO mdlsirap_backup_courses;
RENAME TABLE mdl_backup_files TO mdlsirap_backup_files;
RENAME TABLE mdl_backup_ids TO mdlsirap_backup_ids;
RENAME TABLE mdl_backup_log TO mdlsirap_backup_log;
RENAME TABLE mdl_block TO mdlsirap_block;
RENAME TABLE mdl_block_instance TO mdlsirap_block_instance;
RENAME TABLE mdl_block_pinned TO mdlsirap_block_pinned;
just masukan sql statement ni dlm satu file lain...tapi kalau nak senang...buat step no. 4 tu camni :
#ruby batch_rename.sh > a.sql
Runkan sql file tu guna mysql...:
#mysql namadatabase <>
Selesai....

Credit to Sirap.Dol.

Enable the query cache in MySQL to improve performance

2010-01-11T17:29:00.000-08:00

from mysql server

$ mysql -u root –p

set cache inside mysql shell

mysql> SET GLOBAL query_cache_size = 16777216;

mysql> SHOW VARIABLES LIKE 'query_cache_size';

exit and edit my.cnf

(on ubuntu)
cd /etc/mysql/my.cnf

# nano /etc/my.cnf

add

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

SUDO in FreeBSD / Unix

2010-01-10T23:00:00.000-08:00

as root install

sudo located at /usr/ports/security/sudo
make configure
make && make install

edit conf at

ee /usr/local/etc/sudoers

example and edit :

# Runas alias specification

# User privilege specification
root ALL=(ALL) ALL
kenan ALL=(www) ALL

example :
usename ALL=(group) ALL

** note : !/usr/bin/su (this will prevent user to sudo su)

Set environment : setenv EDITOR ee

General sudoers File Record Format
usernames/group servername = (usernames command can be run as) command

example using sudo : -list the dir- sudo -u www ls -lah /usr/local/www/apache22/data/ -create a file- sudo -u www touch /usr/local/www/apache22/data/test - edit a file- sudo -u www ee /usr/local/www/apache22/data/test

Can't create table (errno: 708) (Mysql BUGS)

2010-01-08T01:45:00.000-08:00

I recently face my mysql problem like this.

mysql> alter table 19m4t_enrol_authorize engine=ndbcluster;
ERROR 1005 (HY000): Can't create table './lmsdb/#sql-2ece_a.frm' (errno: 708)

when i want to cluster my tables on my other nodes this error appear.

The Solution is go to my mysql management node and i increase

increase "MaxNoOfAttributes"

into my ndb_mgm.conf

example :

DataMemory = 24G
IndexMemory = 4G
MaxNoOfOrderedIndexes = 1024
MaxNoOfAttributes = 10000
MaxNoOfTables = 2500
MaxNoOfConcurrentOperations = 250000
MaxNoOfConcurrentIndexOperations = 250000

reboot all machine.

DONE!

Check RAM on FreeBSD

2010-01-06T17:49:00.000-08:00

Install :

# cd /usr/ports/sysutils/freecolor
# make install clean

$ freecolor -m -o

Set time zone on Ubuntu

2009-12-20T23:59:00.001-08:00

Here the CLI :
as root or sudo

dpkg-reconfigure tzdata

Upgrade / updating CentOS 5.3

2009-12-03T20:30:00.000-08:00

here some step upgrade and update for CentOS 5.3 (Work for Me!!)

# yum clean all

# yum update

# yum upgrade

# reboot

or you can upgrade your kernel using

# yum upgrade kernel

than

# reboot


updating package :
example

yum list updates {package-name}
yum list updates 'package-name*'
yum list updates '*package-name*'

or

# yum list updates 'php*'
or

# yum list updates 'kernel*'

you can currently list your installed package by using

# rpm -q kernel

do multiple

# yum list installed 'kernel*' 'php*'

or update your kernel by using

# yum update kernel.i686

than reboot your box

That All!

To check CentOS Version

2009-12-03T19:34:00.001-08:00

run this command :

cat /etc/redhat-release

Upgrade FreeBSD 7.2 to 8.0 using csup

2009-12-03T00:49:00.000-08:00

I finally did it upgrade my box from 7.2 to 8.0
here some step for you guys

1 - Edit your supfile file

# cp /usr/share/examples/cvsup/standard-supfile /root/supfile.8
# ee /root/supfile.8

find and change this line

*default host=cvsup2.jp.FreeBSD.org

and

*default release=cvs tag=RELENG_8_0

save n close this file

csup your box using this command

# csup /root/supfile.8

to build freebsd file system enter :

# cd /usr/src
# make cleanworld && make cleandir

if you have problem when you make cleanworld && make cleandir please csup using normal csup and than try back csup /root/supfile.8.

# make buildworld

after that build and install your new / custom kernel :

# make buildkernel
# make installkernel


after finish REBOOT your box and at bootloader section please choose 4 (single mode) to finish the upgrade.


after you login as a single user you will get something like this (/sbin/sh). For me i use this :


csh


than mount

# mount -a -t ufs

and after that run mergemaster

# mergemaster -p


WARNING !!!

Be careful with /etc/passwd, /etc/group and other files in base system. Verify each file before installing new version or merging exiting configuration files.


than you need to install FreeBSD Base System

# cd /usr/src
# make installworld

after finish run :

# mergemaster -i

WARNING !!!

Be careful with /etc/passwd, /etc/group and other files in base system. Verify each file before installing new version or merging exiting configuration files.

after finish reboot your system

after finish start you box as usual. Please check your status :

# uname -a
# tail -f /var/log/messages

than upgrade your ports :

# portsnap fetch update
# vi /usr/ports/UPDATING
# portmaster -Da

than your box is up to date!

Thanks to nixcraft for the great article!

Install heartbeat on Ubuntu Mysql Cluster & HA Proxy

2009-11-23T22:33:00.000-08:00

I already done (BUT NOT TESTED YET) my heartbeat installing heartbeat on ubuntu.

$ sudo apt-get install haproxy
$ sudo apt-get install heartbeat

HAproxy

The config file for HAProxy is in "/etc/haproxy.cfg"

here my sample of my haproxy.conf

global
log 127.0.0.1 daemon debug
stats socket /tmp/stats
maxconn 4096
pidfile /var/run/haproxy.pid
daemon

defaults
log global
mode tcp
option dontlognull retries 3 option redispatch
maxconn 2000
contimeout 5000
clitimeout 50000
srvtimeout 50000

listen MySQL 172.16.100.240:3306
mode tcp
option httpchk
stats enable
stats uri /haproxy-stats
balance roundrobin

server mysql_master 172.16.100.241:3306
server mysql_slave 172.16.100.242:3306

Heartbeat

/etc/ha.d/ha.cf #main config file
/etc/ha.d/authkeys #authorization keys file
/etc/ha.d/haresource #share resources on nodes

example on my conf :

You must set on both machines

Primary machine

Secondary machine

keepalive 2

warntime 10

deadtime 25

initdead 50

udpport 694

auto_failback on

bcast eth0

node niti.joey.net

node niti.aniket.net

debugfile /var/log/ha-debug

logfile /var/log/ha-log

keepalive 2

warntime 10

deadtime 25

initdead 50

udpport 694

auto_failback on

bcast eth1

node niti.joey.net

node niti.aniket.net

debugfile /var/log/ha-debug

logfile /var/log/ha-log

haresources conf

ubuntu-mysqlclusterA 172.168.1.241/24/eth0 # set in machine B

ubuntu-mysqlclusterB 172.168.1.242/24/eth0 # set in machine A

authkeys

Syntax:
auth
[]

example :

auth 1

1 md5 mypassword

Starting Heartbeat’s Services

Once, you are through with the above configurations in both of the machines, use the following to start the Heartbeat daemon.

$ /etc/init.d/heartbeat start

This command has to be run simultaneously on both the machines.

Following commands can also be used as required:

$ /etc/init.d/heartbeat stop

$ /etc/init.d/heartbeat restart

Reference for my project :

Thanks and credits to these blog and people :

http://theitaxis.wordpress.com/2009/11/14/heartbeat-a-step-by-step-configuration-guide-to-high-availability-linux-clusters/

http://raghupathy.wordpress.com/2008/05/01/high-availabilitycluster-with-load-balancing-by-using-heartbeat-and-haproxy/

http://oceanobservatories.org/spaces/display/CIDev/High+availability+Load+Balancer+-+HAProxy+and+heartbeat

Uninstall / Delete / Remove Package on Ubuntu

2009-11-23T17:52:00.000-08:00

For example remove package called mplayer, enter:

$ sudo apt-get remove mplayer

Remove package called lighttpd along with all configuration files, enter:

$ sudo apt-get --purge remove lighttpd

To list all installed package, enter:\

dpkg --list dpkg --list | less dpkg --list | grep -i 'http'

Change hostname on CentOS

2009-11-22T18:56:00.000-08:00

Change the hostname machine running CentOS.

Login with putty.exe / or SSH
Goto : cd /etc/sysconfig/
Type vi / nano network
Press i (for VI) on the keyboard and change the HOSTNAME to your preferred servername
Press ESC on the keyboard
Save the configuration by :wq! (For VI) or control x and save Y (for nano)
Reboot

Squid Guard

2009-11-19T22:11:00.000-08:00

Scenario 1 :

Hi,

I want to block certain web site with specific time using squid. I want to block all social web site during office hour. After office hour, they can access the site.

How to set in squid? Is there any link?

Thank you.

The solution :

install SquidGuard then u can do time-based blocklist.

Use time based acl and url regex.

Example:
Block http access to certain website between 8.00am to 12.00pm and 1.00pm to 4.00pm.
This mean that sites only can be accessed between 12.01pm and 12.59pm.

acl on squid.conf will be like this:

ex:

CODE

acl waktu1 time 08:00-12:00
acl waktu2 time 13:00-16:00
acl blocksocialnetwork url_regex "/etc/squid/socialnetworkdomain.acl"
http_access deny blocksocialnetwork waktu1
http_access deny blocksocialnetwork waktu2

Put domains of social network sites you want to block in /etc/squid/socialnetworkdomain.acl

ex:

CODE

.facebook.com
.blogspot.com
.twitter.com
.lowyat.net
.youtube.com
.adultfriendfinder.com
.friendster.com
.livejournal.com
.microsoft.com

Taken from forum.lowyat.net.my for my revision.
Thanks

FreeBSD Check CPU Info

2009-11-04T23:21:00.000-08:00

as root run this :

# sysctl -a | egrep -i 'hw.machine|hw.model|hw.ncpu'

Mysql Cluster In Ubuntu

2009-10-19T02:39:00.000-07:00

**Thanks to Bieg for this great great article and knowledge.

I spent some time getting MySQL clustering working with Ubuntu after reading a guide on Howto Forge. The guide however went into the details of compiling and installing MySQL from source so I’m creating this to show the steps needed to get it set up on a fresh Ubuntu installation.

For a correct setup you will need 3 machines. The first machine will serve as the management node, and the other two will be storage nodes.

At the time of writing, the current stable version of Ubuntu is 8.04.1 and the MySQL version that is installed is 5.0.51

During the configuration I log onto the machines and use the command

sudo su -

to gain permanent root access and saving myself from having to type sudo in front of every command. Use your own discretion.

Installing MySQL

Using apt this is straight forward. Just type the following command on all three machines to install MySQL server.

apt-get install mysql-server

Once asked to, set the root password to the MySQL database. You’ll need to remember this one. Once MySQL server is installed we’ll proceed to configure the management node.

Configuring the Management Node

Create and edit the file /etc/mysql/ndb_mgmd.cnf. Copy and paste the text bellow changing the ip addresses to match your setup as necessary.

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=80M    # How much memory to allocate for data storage
IndexMemory=18M   # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
# IP address of the management node (this system)
HostName=192.168.1.5

# Section for the storage nodes
[NDBD]
# IP address of the first storage node
HostName=192.168.1.6
DataDir=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster/backup
DataMemory=512M
[NDBD]
# IP address of the second storage node
HostName=192.168.1.7
DataDir=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster/backup
DataMemory=512M

# one [MYSQLD] per storage node
[MYSQLD]
[MYSQLD]

Configuring the Storage Nodes

As you can see in the file we created in the previous step, the cluster will be using /var/lib/mysql-cluster on the storage machines. This path is created when you install MySQL server but they are owned by root. We want to create the backup directory and change ownership to mysql.

mkdir /var/lib/mysql-cluster/backup

chown -R mysql:mysql /var/lib/mysql-cluster

Now we’ll need to edit the MySQL configuration so that the storage nodes will communicate with the Management Node.

Edit /etc/mysql/my.cnf

Search for [mysqld] and add the following.

[mysqld]
ndbcluster
# IP address of the cluster management node
ndb-connectstring=192.168.1.5

Then scroll down to the bottom until you see [MYSQL_CLUSTER]. Uncomment the line and edit so it looks like

[MYSQL_CLUSTER]
ndb-connectstring=192.168.1.5

* edit bind-address  = IPaddress server

The reason the connect string it found twice in the mysql file is because one is used by mysql server, and the other is used by the ndb data node app. Save the changes to the file.

Make sure you complete the changes on both data nodes.

Start the Management Node

Start the Management Node using

/etc/init.d/mysql-ndb-mgm restart

The process shouldn’t be running but using restart doesnt hurt. Once it is started we can access the management console using the command ndb_mgm. At the prompt type show; and you will see

ndb_mgm> show;
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]    2 node(s)
id=2 (not connected, accepting connect from 192.168.1.6)
id=3 (not connected, accepting connect from 192.168.1.7)

[ndb_mgmd(MGM)]    1 node(s)
id=1    @192.168.1.5  (Version: 5.0.51)

[mysqld(API)]    2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

As you can see the management node is waiting for connections from the data nodes.

Start the Data Nodes

On the data nodes, issue the commands

/etc/init.d/mysql restart
/etc/init.d/mysql-ndb restart

Go back to the management node, type show; again, and now you should see something similar to

id=2    @192.168.1.6  (Version: 5.0.51, starting, Nodegroup: 0)
id=3    @192.168.1.7  (Version: 5.0.51, starting, Nodegroup: 0)

Once they have started properly, the show command should display

ndb_mgm> show;
Cluster Configuration
---------------------
[ndbd(NDB)]    2 node(s)
id=2    @192.168.1.6  (Version: 5.0.51, Nodegroup: 0, Master)
id=3    @192.168.1.7  (Version: 5.0.51, Nodegroup: 0)
[ndb_mgmd(MGM)]    1 node(s)
id=1    @192.168.1.5  (Version: 5.0.51)
[mysqld(API)]    2 node(s)
id=4    @192.168.1.7  (Version: 5.0.51)
id=5    @192.168.1.6  (Version: 5.0.51)

Congratulations, your cluster is now setup.

Testing the cluster

Issue the following on both data nodes to create the test database. Since clustering is done on a table basis in MySQL we have to create the database manually on both data nodes.

$> mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database clustertest;
Query OK, 1 row affected (0.00 sec)

Once this i done, on ONE of the data nodes, create a test table and add an entry.

mysql> use clustertest;
Database changed
mysql> create table test (i int) engine=ndbcluster;
Query OK, 0 rows affected (0.71 sec)

mysql> insert into test values (1);
Query OK, 1 row affected (0.05 sec)

mysql> select * from test;
+------+
| i    |
+------+
|    1 |
+------+
1 row in set (0.03 sec)

We’ve just created a table test, added a value to this table and made sure that the table contains one entry. Note that engine=ndbcluster must be used to let MySQL know that this table should be clustered among the data nodes. Let’s make sure that the table is infact created on the other data node, and contains one entry.

mysql> use clustertest;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------------+
| Tables_in_clustertest |
+-----------------------+
| test                  |
+-----------------------+
1 row in set (0.01 sec)

mysql> select * from test;
+------+
| i    |
+------+
|    1 |
+------+
1 row in set (0.04 sec)

As you can see, the cluster is working.

Moving an existing database to the cluster

Now that we have the cluster working, we can easily change an existing database to be clustered. All you need to do is run the following command on each of the tables.

alter table my_test_table engine=ndbcluster;

The table, and all it’s data will be copied to the datanodes and you can now access/change then through any nodes in the cluster. Very simple.

Format / Create partition on CentOS (LINUX perhaps)

2009-10-15T01:38:00.000-07:00

Today i manage to remove and create the partition on CentOS 5.2 (i386).
BTW this server contain VMFS patition inside the server, so i need to remove this partition first.

as root, i run fdisk -l and you will get

Disk /dev/cciss/c0d0: 146.7 GB, 146778685440 bytes
255 heads, 32 sectors/track, 35132 cylinders
Units = cylinders of 8160 * 512 = 4177920 bytes

Device Boot Start End Blocks Id System
/dev/cciss/c0d0p1 * 1 25 101984 83 Linux
/dev/cciss/c0d0p2 26 1279 5116320 8e Linux LVM
/dev/cciss/c0d0p3 1280 35132 138120240 fb VMFS

So I decide to remove the partition first and i will use this partition as a ext3 partition. You can delete this VMFS partition by run

fdisk /dev/cciss/c0d0 or fdisk /dev/cciss/c0d0p3
then type p

the partition containing the VMFS is the one with type FB

to delete the partition type d
you will be asked for the number
enter it and the partition is gone
then type w to write out the partition table to the disk, then type q to exit

than reboot

the VMFS will be deleted after the reboot finish. Now let start to install / create a new partition using fdisk
as root run

fdisk /dev/cciss/c0d0
help
choose n
you will be ask some question to answer to suit your needs
after finish
w

reboot

after finish rebooting now we can start to create a new partition.
using

parted /dev/cciss/c0d0
p
mkfs 3
Yes
partition number (depend on your partition to create) : 3
wait for a sec

or you can use this to create a partition

Create the partition using parted or fdisk.

Format the partition with the ext3 file system using mkfs.

Label the partition using e2label.

Create the mount point.

Add the partition to the /etc/fstab file.

after finish please reboot your machine

Now you can use your new partition.
Thanks all.

Missing VMDK

2009-10-06T19:31:00.000-07:00

On VMWare ESX3 (I tried already on ESX4 and it works!) , your VM has one or more VMDK files (extension .vmdk) and one or more flat vmdk files (last characters flat.vmdk )

In some cases, you may corrupt, lose or accidentally delete your VMDK files. Your VMDK’s contain metadata for your flat.vmdk files. Without your VMDK’s, you cannot load your flat.vmdk-files. Consequence: you cannot load the VM in your VirtualCenter and you cannot start the VM.
The following steps will guide you to recreate your vmdk files (.vmdk):

Determine the hard disk sizes of your original VM (I call this VM from now on: VM A)
Create a new VM (I call this VM from now on: VM B) with VirtualCenter with the same number of hard disks as your old VM, and the exact same sizes. So: if your original VM contained 2 harddisks from 8,00GB and 12,00GB, recreate these harddisks exactly the same in your new VM.
After your VM B has been created, use Putty (or a similar tool) to navigate to your ESX server. Then navigate to the location / directory where your VM B is stored.
Copy all VMDK’s (not the flat ones, but only the metadata files) to your VM A directory. The filesize of your META-data files should be a few KB.
Navigate to your VM A directory. You just copied the *.VMDK files to this directory. Edit the VMDK’s with a text editor: (For my case i using nano inside the ESX server)You should replace the old filenames with the correct file names -> They refer to the new VM B, but they should refer to your old (original) VM A **
Save the files.
Load the VM in your VirtualCenter. You should now be able to add th flat.vmdk to your VM.

** # Extent description RW 62914560 VMFS "your_new_VM-flat.vmdk" to RW 62914560 VMFS "your_old_VM_name-flat.vmdk" and save

Tar on Ubuntu

2009-09-14T00:38:00.000-07:00

Command line using tar command on ubuntu

tar -xf namefile.tar.gz or tar -xf namefile.tar.bz2

Thanks

Adding HDD using VMware On FreeBSD

2009-09-13T17:40:00.000-07:00

Let me show you how :

- Open your esx server console and choose server that you need to add another HDD.
- Edit server than choose HDD tab than click add
- follow the instruction to suit your need.
- after add click finish.

Now you need to format the HDD. Below will show you how.

- ssh or open console to the server you add the HDD
- as root run sysinstall
- than choose label (label disk editor)
- now you need to create slice for you disk.Currently I choose auto to create the disk
- after you name the disk than choose "w"
- that all mate.

Have a good day ahead.

Xcache on Lighty

2009-09-01T21:27:00.001-07:00

Now I already UP my new webserver running on FreeBSD 7.2 PHP5 Mysql 5.1 And Lighttpd plus Xcache for boost my PHP opcode

ok here my c0nfiguration based on Nicraft website :

Install xcache, enter:
# cd /usr/ports/www/xcache
# make install clean

To enable xcahce copy the /usr/local/share/examples/xcache/xcache.ini config file into /usr/local/etc/php/ and modify it to suit your needs, enter:

# cp /usr/local/share/examples/xcache/xcache.ini /usr/local/etc/php/
# cd /usr/local/etc/php/
# vi xcache.iniSet xcache.size and other parameters as per your requirements.

sample xcache :

[xcache-common]
extension = xcache.so

[xcache.admin]
xcache.admin.enable_auth = On
xcache.admin.user = "admin"
; xcache.admin.pass = md5($your_password)
xcache.admin.pass = ""

[xcache]
; ini only settings, all the values here is default unless explained

; select low level shm/allocator scheme implemenation
xcache.shm_scheme = "mmap"
; to disable: xcache.size=0
; to enable : xcache.size=64M etc (any size > 0) and your system mmap allows
xcache.size = 512M
; set to cpu count (cat /proc/cpuinfo grep -c processor)
xcache.count = 4
; just a hash hints, you can always store count(items) > slots
xcache.slots = 8K
; ttl of the cache item, 0=forever
xcache.ttl = 0
; interval of gc scanning expired items, 0=no scan, other values is in seconds
xcache.gc_interval = 0

; same as aboves but for variable cache
xcache.var_size = 128M
xcache.var_count = 1
xcache.var_slots = 8K
; default ttl
xcache.var_ttl = 0
xcache.var_maxttl = 0
xcache.var_gc_interval = 300

xcache.test = Off
; N/A for /dev/zero
xcache.readonly_protection = Off
; for *nix, xcache.mmap_path is a file path, not directory.
; Use something like "/tmp/xcache" if you want to turn on ReadonlyProtection
; 2 group of php won't share the same /tmp/xcache
; for win32, xcache.mmap_path=anonymous map name, not file path
xcache.mmap_path = "/dev/zero"

; leave it blank(disabled) or "/tmp/phpcore/"
; make sure it's writable by php (without checking open_basedir)
xcache.coredump_directory = ""

; per request settings
xcache.cacher = On
xcache.stat = On
xcache.optimizer = Off

[xcache.coverager]
; per request settings
; enable coverage data collecting for xcache.coveragedump_directory and xcache_coverager_start/stop/get/clean() functions (will hurt executing performance)
xcache.coverager = Off

; ini only settings
; make sure it's readable (care open_basedir) by coverage viewer script
; requires xcache.coverager=On
xcache.coveragedump_directory = ""

Than restart your Lighttpd

Mysql Tips

2009-08-24T17:48:00.000-07:00

If you want to see mysql job status run this command

log in mysql
run this status

mysql > show processlist;

you can got the output.

FreeBSD CPU Information

2009-08-24T17:35:00.000-07:00

run this command

# sysctl -a | egrep -i 'hw.machine|hw.model|hw.ncpu'

enter

you can get the output.

List Installing Perl Modules on your box

2009-07-27T19:10:00.000-07:00

PHP problem

2009-07-26T20:20:00.000-07:00

Just to remind me and for all,
After installing PHP5, we need to add this line to apache.conf in httpd.conf

AddType application/x-httpd-php .php
AddType application/x -httpd-php-source .phps

Install Jails In FreeBSD

2009-07-07T23:13:00.000-07:00

I finally done to do jails in virtual freebsd in the bsd box.

here the step

ail is an virtual BSD in your current BSD Box… It uses the same kernel with ur BSD Box…

you can read the complete reference here or use man jail in the shell/ terminal window

I’ll only give a little explanation about this, this documentation will guide you so you’ll get a full new jailed system

OK this is the first step you must do…

Create a directory in a partition/slice which has largest freespace .. in this example i use /usr partition

# mkdir /usr/vbsd

# sysinstall

in sysinstall menu go to Custom > Options … in this section change the ‘Install Root‘ to /usr/vbsd

then exit by pressing Q.

then choose Distributions and select custom :

check list base, and others ( depend on your needs, i usually add man, ports, and local only ), in this case don’t choose kernel, because this jail system will use the same kernel as your host system.

After all’ve done, go to Media section and choose the proper media, you can use CD, FTP, etc. I prefer to use FTP because my campus network have a mirror of FreeBSD FTP, and it’s faster than read from CD.

after that… choose the last options ‘commit’ to install freebsd in that directory..

after finished….

you can enter to your jail system by type this to your shell window :

# jail /usr/vbsd/ 5.arc.itb.ac.id 167.205.3.47 /bin/tcsh

you’ll get yourself in new freebsd shell config your basic configuration like /etc/rc.conf, /etc/resolv.conf

(Check my other tutorial about this, note that jail system use the same interface as host system)

this is my /etc/rc.conf configuration for this new box :

defaultrouter=”167.205.3.1″
hostname=”5.arc.itb.ac.id”
ifconfig_rl0=”inet 167.205.3.37 netmask 255.255.255.192″
ipv6_enable=”YES”
nfs_client_enable=”YES”
ntpdate_enable=”YES”
ntpdate_flags=”ntp.kim.lipi.go.id”

#Daemon
sshd_enable=”YES”

and this is my /etc/resolv.conf

domain arc.itb.ac.id

nameserver 167.205.3.1

nameserver 167.205.22.123

I reccomend you to add user and change the root password.

I assume you have configured your Jail Box (added user, enable ssh, configure network, etc)

now switch to your host by pressing ctrl+D so you disconnect the jail server.

now we will start config jail daemon to be ran when system boot in /etc/rc.conf :

##Jail-Virtual##
jail_enable=”YES”
jail_list=”vmachine”
jail_vmachine_rootdir=”/usr/vbsd/”
jail_vmachine_hostname=”5.arc.itb.ac.id”
jail_vmachine_ip=”167.205.3.47″
jail_vmachine_devfs_enable=”YES”

#Network Alias

ifconfig_rl0_alias0=”inet 167.205.3.47 netmask 255.255.255.192″

add some config in /etc/sysctl.conf :

security.jail.allow_raw_sockets=1

restart your computer or just execute /etc/rc script :

# sh /etc/rc

now you can access your jail box via ssh….

Enjoy…

Malaysian CVSup Mirror for FreeBSD and OpenBSD

2009-06-30T17:48:00.000-07:00

mirror cvsup for malaysian people.

1. cvsup.free.MyBSD.org.my (untuk cvsup FreeBSD)
2. cvsup.open.MyBSD.org.my (untuk cvsup OpenBSD)

Change Hostname and network in Linux

2009-06-29T01:06:00.000-07:00

In Linux, you can use command simply like this to change your hostname

shell#hostname nameyourhost

or directory store your hostname

in RHEL
shell#nano /etc/hosts
in Ubuntu
shell# nano /etc/hostname

in case to edit to static IP

in RHEL Interface for network locate at

nano /etc/sysconfig/network-scripts/interface

in ubuntu

nano /etc/network/interface

add DNS in ubuntu / RHEL

nano /etc/resolv.conf

finally restart your network in linux

/etc/init.d/network restart

Apache22 LDAP integration on FreeBSD

2009-06-28T22:59:00.000-07:00

Finally I make it doing apache22 auth using LDAP

the solution

open your apache configuration httpd.conf and add this lines

Directory /path/directory/toauth>
Order deny,allow
Deny from All
AuthName "Please Login Using password"
AuthType Basic
AuthBasicProvider ldap
AuthzLDAPAuthoritative on
AuthLDAPURL ldap://xxx.xx.xxx.xx:389/
Require valid-user
Satisfy any
/Directory>

restart your apache

Community FreeBSD in Malaysia

2009-06-28T19:58:00.000-07:00

For community FreeBSD in Malaysia.

Register!

http://forum.mybsd.org.my

To remove Parent Directory

2009-06-24T18:08:00.000-07:00

Ok I already remove "Parent Directory" from Apache22 on BSD platform

- open your httpd.conf
- add this

Directory /data/yogya/>
IndexIgnore ..
/Directory>

- save and restart
- done

ps: please add < into the script directory.

Apache Aut

2009-06-22T23:34:00.000-07:00

Apache authorised for single mode.

now I already done doing apache auth in single mod

here the step

edit http.conf
add the following line in http.conf

#
#apache permission testing
#
Directory /directory/to/auth/>
AllowOverride AuthConfig
/Directory>
#

ps: please put < at the begining of file Directory /directory/to/auth and /Directory because i cannot put right now because it will hidden that conf if i put < now.

Create a file /directory/to/auth/.htaccess in that director that looks something like this:

AuthName "Add your login message here."
AuthType Basic
AuthUserFile /directory/to/auth/.htpasswd
AuthGroupFile /dev/null
require user name-of-user

after that create the file .htpasswd to /directory/to/auth/ (to store password for user)
after that run this htpasswd -c .htpasswd name-of-user
and
restart apache

done for single user

now I try to auth with LDAP and stil searching the conf. I will let share with you guys if my work done.

taken at : http://www.yolinux.com/TUTORIALS/LinuxTutorialApacheAddingLoginSiteProtection.html

Thanks

Mergemaster Problem (FreeBsd 7.0 to 7.2)

2009-06-18T18:22:00.000-07:00

after i doing mergemaster i can't login as user to root privileges.
mergemaster have change all my /etc/group

if this happen to you run this as root

pw usermod username -Gwheel

Copy a file

2009-06-18T02:05:00.000-07:00

simple command cp

cp namefile newnamefile

here the command i use for copy a file

go to /usr/local/etc/folder
maybe inside the folder have 3 files.

you just run this command will cp all files to the point folder and no need to tar.

cp -rp * /path/directory/to/copy
or
cp -rp feedback /usr/local/www/apache22/data/

Nginx Logrotated

2009-06-17T21:22:00.000-07:00

ok here i wanted to share nginx logrotated run in RHEL. I run this script because iam using Dimdim with nginx engine and it store a huge log file.

Script for nginx logrotate.

Logs is located at /usr/local/dimdim/nginx/logs
Add nginx file and edit or add at /etc/logrotate.d

copy & paste this script

/usr/local/dimdim/nginx/logs/*.log {

daily
missingok
rotate 9
compress
delaycompress
notifempty
postrotate
kill -USR1 `cat /usr/local/dimdim/nginx/logs/nginx.pid`
endscript

}

restart

add rules at crontab so it can be run in time you set for the log

add
# rotating logrotate
59 23 * * * root /usr/sbin/logrotate -f /etc/logrotate.conf

done!

Installing OCS agent in Windows N Unix and FreeBSD

2009-06-17T21:15:00.000-07:00

Ok here what i do when i installing OCS agent for OCS inventory server

Installing Ocsinventory agent in unix / linux

in linux we need to use / and download source at http://www.ocsinventory-ng.org/index.php?page=1-02

and installing using tar methods using tar -xzvf

and than running

perl Makefile.pl

make

make install

if have problem when installing ocs and need perl module try to install CPAN

installing CPAN

just type cpan on your shell

after you installing CPAN try to installing perl modules using this CPAN

example

cpan> install LWM::UserAgent

Installing Ocsinventory agent in FreeBSD.

Install agent using /usr/ports/net_mngmt

make && make install

running ocsinventory -d -l or ocsinventory -d -l

Also you can use tar.gz running on linux installer too the step of installing just follow the linux step.

after done the OCS will prompt some question regarding your system / server.

Small Linux in town!

2009-06-17T21:05:00.000-07:00

The are too many Linux Distro out there so when i googling some open source forum i found this and i like to share with you guys some info of this linux

It is "SLAX 6"

It's 32 bit X86 based Linux platform.
It's ultra portable , it has only 190MB,
included all basic tools and ultilities.
Lots of softwares support too.

The awesome features are:

1. It can be boot from USB thumbdrive, CD, and Harddisk.

2. Install softwares by "Copy And Paste". No headache on installing softwares, drivers, etc...
Because you just need to find and download softwares (known as Modules) in Slax.org website, and paste it in the folder "Module".

3. Support many softwares, eg: Avast Antivirus, FireFox, VLC player, Messenger, Open Office, Flash Player, J2RE, media codec...

4. Multi Language supported. Can switch OS language. Chinese display/input available.

5. Read and Write NTFS, FAT, FAT32, formatted Harddisk/Flash Disk.

6. Easy to use, fast, compact, reliable, compatible, stable, secure, portable...

It's best to use as alternative OS, and back up agent when you can't load Windows at all.

more more info logon "http://www.slax.org/"

Is up!!!

2009-06-17T06:30:00.000-07:00

Finally i already up my tech blog for me to store all script and job what have i done before. This blog will be my reference or for you if have any problem and still search the solution.

And maybe my blog will help you a lot.

OPEN SOURCE for ALL!!

Thanks!