Friday, November 02, 2007
Tuesday, November 07, 2006
Thursday, November 02, 2006
Wednesday, October 25, 2006
Monday, October 16, 2006
Crystal Report 8.5 sql query
It seems it will not show the condition on sql query if we said {?input} = {field}, or iif ({?input}="whatever",,); it show when {field}={?input}
recover hard deleted item from outlook
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Exchange\Client\Options
Value name: DumpsterAlwaysOn
Data type: DWORD
Value data: 1
http://support.microsoft.com/kb/246153/en-us
Value name: DumpsterAlwaysOn
Data type: DWORD
Value data: 1
http://support.microsoft.com/kb/246153/en-us
Tuesday, October 03, 2006
MS Exchange database max GB
creating a DWORD registry key named “Database Size Limit in GB” in
- HKLM\SYSTEM\CurrentControlSet\Services\MSExchangeIS\<servername>\Private-GUID
- HKLM\SYSTEM\CurrentControlSet\Services\MSExchangeIS\<servername>\Public-GUID
- HKLM\SYSTEM\CurrentControlSet\Services\MSExchangeIS\<servername>\Private-GUID
- HKLM\SYSTEM\CurrentControlSet\Services\MSExchangeIS\<servername>\Public-GUID
MS exchange database
check the recyclable space:
- searching for event 1221 in the Application log. This is a conservative estimate and it seems only includes the EDB file only.
- ESEUTIL.EXE /MS <databases.edb>
check the recoverable items:
- use Performance Monitor with a specific counter called: “Total Size of Recoverable Items”.
defragment to copy to a new database (need to be offline and 110% of free space):
ESEUTIL.EXE /D <databases.edb>
- searching for event 1221 in the Application log. This is a conservative estimate and it seems only includes the EDB file only.
- ESEUTIL.EXE /MS <databases.edb>
check the recoverable items:
- use Performance Monitor with a specific counter called: “Total Size of Recoverable Items”.
defragment to copy to a new database (need to be offline and 110% of free space):
ESEUTIL.EXE /D <databases.edb>
Thursday, September 21, 2006
shell script -- while loop read file
#!/bin/sh
# Illustrates use of a while loop to read a file
cat file | \
while read line
do
echo "Found line: $line"
done
# Illustrates use of a while loop to read a file
cat file | \
while read line
do
echo "Found line: $line"
done
tape backup -- tar, cpio
tar:
tar cvfM /dev/st0 sample //save; M for multivolume
tar tvf /dev/st0 //list
tar xvf /dev/st0 //restore
tar xvf /dev/st0 file //restore a file
cpio:
find . -depth -print | cpio -ov -C32768 > /dev/st0 //save
cpio -itv -C32768 < /dev/st0 //list
cpio -ivd -C32768< /dev/st0 //restore
find out file type on tape:
file - < /dev/st0
tar cvfM /dev/st0 sample //save; M for multivolume
tar tvf /dev/st0 //list
tar xvf /dev/st0 //restore
tar xvf /dev/st0 file //restore a file
cpio:
find . -depth -print | cpio -ov -C32768 > /dev/st0 //save
cpio -itv -C32768 < /dev/st0 //list
cpio -ivd -C32768< /dev/st0 //restore
find out file type on tape:
file - < /dev/st0
tape backup -- mt
mt -f /dev/st0 status //for status
mt -f /dev/st0 rewind // rewind the tape
mt -f /dev/st0 fsf1 // forward 1
mt -f /dev/st0 rewoffl // rewind and eject
mt -f /dev/st0 retension // forward and rewind
mt -f /dev/st0 erase // erase tape
mt exits with a status of 0 if the operation succeeded, 1 if the operation or device name given was invalid, or 2 if the operation failed.
find blocksize of tape:
dd if=/dev/st0 of=/tmp/dummy bs=128k count=1
mt -f /dev/st0 rewind // rewind the tape
mt -f /dev/st0 fsf1 // forward 1
mt -f /dev/st0 rewoffl // rewind and eject
mt -f /dev/st0 retension // forward and rewind
mt -f /dev/st0 erase // erase tape
mt exits with a status of 0 if the operation succeeded, 1 if the operation or device name given was invalid, or 2 if the operation failed.
find blocksize of tape:
dd if=/dev/st0 of=/tmp/dummy bs=128k count=1
Wednesday, September 20, 2006
mysql -- grant
grant <priv> on <database> to <user> identified by <password> with grant option;
http://dev.mysql.com/doc/refman/5.0/en/grant.html
http://dev.mysql.com/doc/refman/5.0/en/grant.html
Tuesday, September 19, 2006
postfix (Linux email)
To check for port listening for all incoming:
netstat -ltn | grep 25
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN
/etc/postfix/main.cf
inet_interfaces = all //for listening all incoming
/etc/postfix/transport
something.com smtp:[x.x.x.x] // for relay
.something.com smtp:[x.x.x.x]
postmap transport
postfix reload
/etc/virtual (email list)
netstat -ltn | grep 25
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN
/etc/postfix/main.cf
inet_interfaces = all //for listening all incoming
/etc/postfix/transport
something.com smtp:[x.x.x.x] // for relay
.something.com smtp:[x.x.x.x]
postmap transport
postfix reload
/etc/virtual (email list)
SUSE 10 inetd becomes xinetd
Just found out that in SUSE 10, there is no inetd. It becomes xinetd.
I think we use YaST --> System --> Runlevel to control it.
I think we use YaST --> System --> Runlevel to control it.
Monday, September 18, 2006
amd.streamload.com
It seems there are 2 more size for the picture to download.
download-v5.streamload.com/<user>/Hosted/<pic.jpg>?dpath=thumb.jpg
download-v5.streamload.com/<user>/Hosted/<pic.jpg>?dpath=640.jpg
download-v5.streamload.com/<user>/Hosted/<pic.jpg>?dpath=thumb.jpg
download-v5.streamload.com/<user>/Hosted/<pic.jpg>?dpath=640.jpg
Avocent - AutoView 3200
AutoView 3200 Digital KVM Switch
http://www.avocent.com/web/en.nsf/Content/AutoView3200
It didn't work until install java-1_5_0-sun-plugin
Also, java 1.5.0.03 not working but java 1.5.0.06 works
need to have IE 6 SP1+
http://www.avocent.com/web/en.nsf/Content/AutoView3200
It didn't work until install java-1_5_0-sun-plugin
Also, java 1.5.0.03 not working but java 1.5.0.06 works
need to have IE 6 SP1+
rsync backup
My goal is to sync all backup files to a directory using rsync, rsyncd; and then for tape backup.
Method 1: using ssh rsync, it need to input password unless using ssh authentication (ssh-auth-keys).
e.g. rsync -avcrog --delete /source/ user@backupip:/backup
Method 2: using rsyncd, and rsync to push / pull the data from the rsyncd server. However, the rsyncd need to be running either by stand-alone daemon (rsync --daemon), inetd.
e.g. /etc/rsyncd.conf
uid = root
gid = root
[name]
hosts allow =
read only = true/false
write only = true
path = /path
auth users = user1,user2
secrets file = rsyncd.secrets
rsyncd.secrets / rsyncd.password
user:password
(old version need cr)
It seems it don't need to restart rsyncd after modify the rsyncd.conf to take effect.
Method 1: using ssh rsync, it need to input password unless using ssh authentication (ssh-auth-keys).
e.g. rsync -avcrog --delete /source/ user@backupip:/backup
Method 2: using rsyncd, and rsync to push / pull the data from the rsyncd server. However, the rsyncd need to be running either by stand-alone daemon (rsync --daemon), inetd.
e.g. /etc/rsyncd.conf
uid = root
gid = root
[name]
hosts allow =
read only = true/false
write only = true
path = /path
auth users = user1,user2
secrets file = rsyncd.secrets
rsyncd.secrets / rsyncd.password
user:password
(old version need cr)
It seems it don't need to restart rsyncd after modify the rsyncd.conf to take effect.
Friday, September 15, 2006
MS Exchange User account Name change
After rename user from AD, the user can logon as the new username and using the old user profile. Nothing need to be changed/moved.
However, Outlook 2003 still showing the old name when the user send email.
I reset the AutoComplete Names from Outlook 2003 and sent the user an email using Addressbook and after that the new username show correctly...
I wonder if that is the real problem or actually the ADs are not in-sync...
However, Outlook 2003 still showing the old name when the user send email.
I reset the AutoComplete Names from Outlook 2003 and sent the user an email using Addressbook and after that the new username show correctly...
I wonder if that is the real problem or actually the ADs are not in-sync...
Monday, September 11, 2006
OWL Intranet upgrade from 0.8x to 0.92
OWL Intranet upgrade is easy and it seems to work with php5.
Only need to replace the php files and run mysql script update, modify browser config and php.ini.
However, the ACL is totally different and I cannot find any scripts to do that.
need to add all files and folders to table advanced_acl with different rights accordingly to the security field on table files, folders. Also userid = 0 for everybody in the 0.9x
Also, php.ini need to change such as the following default values:
memory_limit = 8M
upload_max_filesize = 2M
Also, view.php need to comment the /lib/Mail_Mime/mimeDecode.php if pear is not installed for some file types. I wonder how to install some file types in pear
Only need to replace the php files and run mysql script update, modify browser config and php.ini.
However, the ACL is totally different and I cannot find any scripts to do that.
need to add all files and folders to table advanced_acl with different rights accordingly to the security field on table files, folders. Also userid = 0 for everybody in the 0.9x
Also, php.ini need to change such as the following default values:
memory_limit = 8M
upload_max_filesize = 2M
Also, view.php need to comment the /lib/Mail_Mime/mimeDecode.php if pear is not installed for some file types. I wonder how to install some file types in pear
Subscribe to:
Posts (Atom)