repairing mysql database

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

vi search

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)

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

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

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