Category: Tech

date

date -s “09/29/2005 10:18:00”

Sychronize date

ntpdate pool.ntp.org

sed

sed -e ‘1,5d’ filename

Problem:
It’s extreme slow to connect to the Samba printer on Linux from Windows XP with SP2.

The solution see http://groups.google.com/group/linux.samba/browse_thread/thread/c373f517ad8b1351/f52b374e11548a70?lnk=st&q=samba+linux+printer+slow+driver&rnum=3&hl=en#f52b374e11548a70

Using regedit, under
HKEY_CURRENT_USER\Printers\Connections\

subkeys “DevModePerUser” and deleted all keys for this printer. And entry in “DevModes2” and “Settings”, delete these also.

List all installed packages
rpm -qa

For others, see
http://www.linuxdocs.org/HOWTOs/RPM-for-Unix-HOWTO-5.html

MySQL:

create table user
(
user_id int NOT NULL AUTO_INCREMENT,
name varchar(100),
phone varchar(100),
email varchar(100),
password varchar(100),
role_id int,
primary key(user_id),
unique index email_idx(email),
index role_idx(role_id)
);

Oracle:

create table user2
(
user_id int NOT NULL,
name varchar2(100),
phone varchar2(100),
email varchar2(100),
password varchar2(100),
role_id int,
primary key(user_id),
unique (phone),
foreign key (role_id) references role(role_id)
);
create unique index cu on user2 (email);
create index role_idx on user2 (role_id);

or
create table foo (a int primary key,
b varchar(20) unique);

. Copy GPG keys
copy the following files pubring.gpg random_seed secring.gpg trustdb.gpg from your old directory to your new directory, usually ~/.gngpg under Linux

. Encrypt a file
gpg -e -r me@hongyu.org test.pdf

. Decrypt a file
gpg -d test.pdf.gpg > test.pdf