SQL copy data from one table to another: |
INSERT INTO table1 (column1, column2 )
SELECT collumnn1, collumn2 FROM table2 WHERE collumnn1 > 0 ; |
|---|---|
CentOS
- Update server and fix problem with apache not starting because
of port conflict: |
[root@domain ~]# yum -y update //updates packages. -y
responds with yes to all [root@domain ~]# reboot //restart server [root@domain ~]# lsof -i :80 //httpd not working so checking for services on 80 COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME httpd 2907 root 4u IPv6 9367 TCP *:http (LISTEN) [root@domain ~]# kill 2907 //kill the process [root@domain ~]# lsof -i :80 //check for additional processes on 80 [root@domain ~]# apachectl -k start //now apache can load on 80 Apache/2.2.x mod_ssl/2.2.x (Pass Phrase Dialog) Some of your private key files are encrypted for security reasons. In order to read them you have to provide the pass phrases. |
Emails header show localhost.localdomain [127.0.0.1]
and sender as apache@localhost when sending mail through postfix
using php mail() function. So how do you remove localhost from
the header?: |
Fix is to change the directive in the php.ini file from: sendmail_path = /usr/sbin/sendmail -t -i to: sendmail_path = /usr/sbin/sendmail.postfix -t -i |