A Forgetten Mysql Root Password

After long-long time not login on my server, I forget with my mysql root password. After searching on google, i just find how to solve my problem.
To get new password, following this procedure:

# Take down and restart mysqld with the –skip-grant-tables option as described above.
# Connect to the mysqld server with:
shell> mysql -u root mysql

# Issue the following commands in the mysql client:
mysql> UPDATE user SET Password=PASSWORD(‘mynewpassword’)
-> WHERE User=’root’;
mysql> FLUSH PRIVILEGES;

# After this, you should be able to connect using the new password.
# You can now stop mysqld and restart it normally.

>>aris<<

First post at Thursday, August 17, 2006, 08:39 AM

New hardisk and partition on linux

Today, i just have been asked to myselft how to add new hardisk and create new partition join to the partition which has been ready exist. The answers is very easy, here is:

1. Put the new hardisk on slave in beside the master which already exist.

2. Linux doesn’t detect the new hardisk automaticaly. It’s not same on windows system. Remember, In linux first HD looked on /dev/hda and second HD is detected on /dev/hdb

3. You must create new partition first before formating and mounting. To create new partition can use “fdisk /dev/hdb” command. Following the instruction on there. You can add, delete, or modife the parttion. Create the number of partition as your needed, the example 3 partition.

4. The next step is create filesystem to the new partition. Use this command:
mke2fs /dev/hdb1,2,3 –> to create ext2 file system
mkreiserfs /dev/hdb1,2,3 –> to create reiserfs file system
mke2fs -j /dev/hdb1,2,3 –> to create ext3 file system

5. After that, you must mount the partition to the mount point. If you want outomatically mounting the new partition, edit /etc/fstab and add the new line below:
dev/hdb1 /mp3 ext3 defaults 1 2
/dev/hdb2 /video ext3 defaults 1 2
dev/hdb3 /images ext3 defaults 1 2

Very easy Huh……

>>aris<<

First post at Monday, June 5, 2006, 11:08 PM

Setup MRTG

Today, I has configured Multi Router Traffic Grapher (MRTG). It can give us information about network traffic or server process condition. There are many open software of traffic grapher. One of all is Cacti: The Complete RRDTool-based Graphing Solution. I think it is better than MRTG. Of corse, at next day i want to oprek this software.

MRTG will monitor SNMP network devices and draw pretty pictures showing how much traffic has passed through each interface.

Before installing mrtg, there are some software must have installed on the server. There are:
1. net-snmp-5.1.1.tar.gz
2. zlib-1.2.1.tar.gz
3. libpng-1.2.6.tar.gz
4. gd-2.0.32.tar.gz
5. httpd-2.0.50.tar.gz

I only need to install snmp and mrtg, cause i have installed the other program.
A.INSTALL
1. Install snmp :
#tar -zxvf net-snmp-5.1.1.tar.gz
#mv net-snmp-5.1.1 snmp
#./configure
#make
#umask 022
#make install
#vi /usr/local/share/snmp/snmpd.conf
###############################################
com2sec public default public
group public v1 public
group public v2c public
group public usm public
view all included .1
access public “” any noauth exact all none none
###############################################
#/usr/local/sbin/snmpd
#netstat -pln | grep snmpd
#snmpwalk -v 1 -c public localhost system

2. Install mrtg :
#tar -zxvf mrtg-2.10.14.tar.gz
#mv mrtg-2.10.14 mrtg
#./configure –prefix=/usr/local/mrtg –with-gd=../gd –with-z=../zlib –with-png=../libpng
#make
#make install

B.CONFIGURATION
#/usr/local/mrtg/bin/cfgmaker –global “WorkDir: /var/www/html/mrtg” –global “Options[_]: growright,bits” public@202.51.233.168 –output /var/www/html/mrtg/cfg/202.51.233.168.cfg
#/usr/local/mrtg/bin/indexmaker –output=/var/www/html/mrtg/index.html /var/www/html/mrtg/cfg/202.51.233.168.cfg
#vim /var/www/html/mrtg/cfg/202.51.233.168.cfg
################################
RunAsDaemon:Yes
Interval:5
Refresh:300
###############################
#LANG=C
#/usr/local/mrtg/bin/mrtg /var/www/html/mrtg/cfg/202.51.233.168.cfg
#vim /etc/rc.local
################################
/usr/local/sbin/snmpd
lANG=C
/usr/local/mrtg/bin/mrtg /var/www/html/mrtg/cfg/202.51.233.168.cfg
###############################

You can see my mrtg server at mrtg neta. It can viewed how large bandwitdh that we have using are.

It’s nice day.
Happy trying……..

>>aris<<

First post at Sunday, March 26, 2006, 04:50 PM

Very Secure FTPd

Introduction:
I’m interested to use vsftpd in my ftp server. It’s caused by purposes of speed, security and stability for ftp site. There are feature of vsftpd:
1. Virtual IP configurations
2. Virtual users
3. Standalone or inetd operation
4. Powerful per-user configurability
5. Bandwidth throttling
6. Per-source-IP configurability
7. Per-source-IP limits
8. IPv6
9. Encryption support through SSL integratio
10. etc…
This is a small sample of lots of critical internet sites which use vsftpd:
a. ftp.redhat.com
b. ftp.suse.com
c. ftp.debian.org
d. ftp.openbsd.org
e. ftp.freebsd.org
f. ftp.gnu.org

Installation:
====pre-installation====
#tar xvfz vsftpd-2.0.4.tar.gz
#cd vsftpd-2.0.4
#make
#useradd nobody
#mkdir /usr/share/empty/
====for anonymous ftp====
#mkdir /var/ftp/
#useradd -d /var/ftp ftp
#chown root.root /var/ftp
#chmod og-w /var/ftp
====install vsftpd config file====
#make install
====copy manual, binary and config file====
#cp vsftpd /usr/local/sbin/vsftpd
#cp vsftpd.conf.5 /usr/local/man/man5
#cp vsftpd.8 /usr/local/man/man8
#cp vsftpd.conf /etc
====run anonymous ftp on standalone mode====
#echo “listen=YES” >> /etc/vsftpd.conf
#/usr/local/sbin/vsftpd &

Configuration
====Available option on vsftpd.conf file====
anonymous_enable=YES
local_enable=YES
write_enable=YES
#local_umask=022
anon_upload_enable=YES
anon_mkdir_write_enable=YES
anon_other_write_enable=YES
anon_world_readable_only=NO
anon_root=/home/ftp
dirmessage_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
#chown_uploads=YES
#chown_username=whoever
xferlog_file=/var/log/vsftpd.log
xferlog_std_format=YES
idle_session_timeout=600
data_connection_timeout=120
#nopriv_user=ftpsecure
#async_abor_enable=YES
#ascii_upload_enable=YES
#ascii_download_enable=YES
ftpd_banner=Welcome to FTP service.
#deny_email_enable=YES
#banned_email_file=/etc/vsftpd.banned_emails
#chroot_list_enable=YES
#chroot_list_file=/etc/vsftpd.chroot_list
#ls_recurse_enable=NO
#anon_max_rate=100
#local_max_rate=500
max_clients=15
max_per_ip=10
chroot_local_user=YES
secure_chroot_dir=/var/empty
listen=YES

It’s wonderfull ftp daemon
Happy trying……..

>>aris<<

First post at Friday, February 17, 2006, 01:06 AM

WebcamXp

I think It’s very cool shareware program, WebcamXP. It’s can accessed our cam using browser at the other computer which connect to internet. It is integrated with chatting room too. Someone who being watching this cam in the same time can chat with anoter in that site. Nice This is discribing from WebcamXP Official site.
“WebcamXP is one of the most popular webcam software for private and professional use. it offers unique features and unequaled ease of use to let you broadcast / manage your video sources or secure your company with up to 10 video sources per computer. the software supports all video for windows / WDM sources and most file-based or ip based sources (providing jpeg stream)”

I try to use this program and the result is wonderfull. This is images you can see in my webcam. Picture 1 is me and picture 2 is my elka’s friends have being dinner.

WebcamXp can used to supervise a home, office, or lab likes my site.
Click Here to watch my webcam.

>>aris<<

First post at Saturday, December 24, 2005, 09:05 PM -