redhat network config - ip address mask etc

[root@reloadedOld ~]# vim  /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
BOOTPROTO=none
BROADCAST=x.x.x.191
IPADDR=x.x.x..169
NETMASK=255.255.255.224
NETWORK=x.x.x.160
ONBOOT=yes
TYPE=Ethernet
GATEWAY=x.x.x.161
HWADDR=00:11:25:c4:6a:aa

mysql date format yyyymmdd

update signatures
set day_index_updated=(CURDATE()+0)
where id=39;

show detail table info and drop unique key

mysql> alter table commenting drop key user_ip;
Query OK, 4 rows affected (0.03 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> show create table commenting;
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table      | Create Table                                                                                                                                                                                                                                                                                                                                                                                 |
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| commenting | CREATE TABLE `commenting` (
  `id` int(10) NOT NULL auto_increment,
  `product_id` int(10) default NULL,
  `user_ip` varchar(15) default NULL,
  `uname` varchar(255) default NULL,
  `uemail` varchar(160) default NULL,
  `comments` text NOT NULL,
  `ctime` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1 |
+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

add unique key and show full table

mysql> show create table rating;
+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                                                                                                                                                                                                   |
+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| rating | CREATE TABLE `rating` (
  `id` int(10) NOT NULL auto_increment,
  `domain_name` varchar(255) default NULL,
  `product_id` int(10) default NULL,
  `user_ip` varchar(15) default NULL,
  `rate` int(1) default '5',
  `comments` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `domain_name` (`domain_name`,`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=369 DEFAULT CHARSET=latin1 |
+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> alter table rating add UNIQUE (domain_name, product_id);

how to disable directory indexing in ubuntu Apache2, virtual hosting?

1, greg@SS:~$ sudo vim /etc/apache2/sites-available/yourwebsite.com


ServerAdmin xxxxx@gmail.com
ServerName yourwebsite.com
ServerAlias www.yourwebsite.com

DocumentRoot /var/www/vhosts/yourwebsite.com/htdocs
Options -Indexes

ErrorLog /var/www/vhosts/yourwebsite.com/log/error.log
LogLevel warn

CustomLog /var/www/vhosts/yourwebsite.com/log/access.log combined



2, restart apache service
sudo /etc/init.d/apache2 stop
sudo /etc/init.d/apache2 start

check ssl version - linux command

#openssl s_client -connect localhost:443

linux show yesterday date in shell script

yday=$(date --date "1 day ago" +%Y%m%d)

echo "Backup table CSummary day=$yday"