Thursday, July 28, 2011

Google PageRank Historical Analysis

Cool tool:
Check your website Historical Google PageRank
http://3wtemplates.com/tools/pagerank_checker/pr_report.php

redhat apache issue: caught SIGTERM, shutting down

issue:
========================================
[Thu Jul 28 11:48:34 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 28 11:48:34 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Jul 28 11:48:34 2011] [notice] Digest: done
[Thu Jul 28 11:48:34 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations
[Thu Jul 28 11:52:34 2011] [notice] caught SIGTERM, shutting down
[Thu Jul 28 11:52:37 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 28 11:52:37 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Jul 28 11:52:37 2011] [notice] Digest: done
[Thu Jul 28 11:52:37 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations
[Thu Jul 28 11:58:45 2011] [notice] caught SIGTERM, shutting down
[Thu Jul 28 11:58:48 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 28 11:58:48 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Jul 28 11:58:48 2011] [notice] Digest: done
[Thu Jul 28 11:58:48 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations
[Thu Jul 28 12:07:43 2011] [notice] caught SIGTERM, shutting down
[Thu Jul 28 12:13:07 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 28 12:13:07 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Jul 28 12:13:07 2011] [notice] Digest: done
[Thu Jul 28 12:13:07 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations
[Thu Jul 28 12:18:07 2011] [notice] caught SIGTERM, shutting down
[Thu Jul 28 12:18:12 2011] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 28 12:18:12 2011] [notice] Digest: generating secret for digest authentication ...
[Thu Jul 28 12:18:12 2011] [notice] Digest: done
[Thu Jul 28 12:18:12 2011] [notice] Apache/2.2.3 (Red Hat) configured -- resuming normal operations

==================================
solution:
I forgot to open port 80 in firewall

[root@aaa var]# /sbin/service iptables stop

open port 80:
[root@localhost ~]# vim /etc/sysconfig/iptables
# add this line
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT

[root@aaa var]# /sbin/service iptables start

Friday, July 22, 2011

jpgraph: The function imageantialias() is not available

error message:

Fatal error: Call to undefined function imageantialias() in /var/www/vhosts/bar.php on line 13

The function imageantialias() is not available in your php installation. Use the GD version that comes with PHP and not the standalone version.

SOLUTION:
Open the file jpgraph.x.x.x/src/gd_image.inc.php, find the function SetAntiAliasing and comment this line (about line 110 in the version jpgraph-3.5.0b1):

else {
//JpGraphError::RaiseL(25128);//('The function imageantialias() is not available in your PHP installation. Use the GD version that comes with PHP and not the standalone version.')
}

Monday, July 11, 2011

duplicate mysql table

mysql> CREATE TABLE products_excel_20110711 select * from products_excel;