:-[] :-|| Vivek Khokhar rambles here :-O :-[]

June 12, 2006

Tight Up /etc/profile

Filed under: Linux — Vivek Khokhar @ 11:56 pm

Set login Time out for all users. Do this by editing /etc/profile
TMOUT=7200
export TMOUT

Edit the profile file (vi /etc/profile) and change the line:
HISTSIZE=1000
To read:
HISTSIZE=10
Which means, the .bash_history file in each users home directory can store 10 old
commands and no more. Now, if a cracker tries to see the ~/.bash_history file of users on
your server to find some password typed by mistake in plain text, he or she has less chance to find one.
HISTFILESIZE=0
#each time a user logs out, its .bash_history file will be deleted so crackers will not be able to use .bash_history file of users who are not presently logged into the system.

Group and World Writable files

Filed under: Linux — Vivek Khokhar @ 11:56 pm

[] To locate all group & world-writable files on your system, use the command:
# find / -type f \( -perm -2 -o -perm -20 \) -exec ls -lg {} \;
[] To locate all group & world-writable directories on your system, use the command:
# find / -type d \( -perm -2 -o -perm -20 \) -exec ls -ldg {} \;

See “Tripwire”

Zombie files

Filed under: Linux — Vivek Khokhar @ 10:24 pm

To locate files on your system that do not have an owner, use the following command:
# find / -nouser -o -nogroup

NOTE: Ignore files reported under /dev/ directory.

.rhosts files

Filed under: Linux — Vivek Khokhar @ 10:23 pm

rhosts alleviates the need for a user to enter their password
You can locate all existing .rhosts files on your system with the following command:
[root@deep /]# find /home -name .rhosts

mysql case sensitive table name problem

Filed under: mysql — Vivek Khokhar @ 10:23 pm
As the title suggests, this is about mysql on case sensitive filesystem on *nix  Systems.
Situation is I had all my application written with SQL having uppercase table names.
But the mysql on linux had all in lowercase.
Quick Fix is to tell mysqlserver not to compare case while looking up table names
Edit /etc/my.cnf and add following setting.
[mysqld]
lower_case_table_names=1
Save File and Restart Mysql
Cross check variable value as follows
#mysqladmin variables
Done

Powered by WordPress