Apache

Java Keytool to OpenSSL

October 29, 2008

Extract the certificate


keytool -export -alias mykey -keystore  mpestore.dat -file  exported-der.crt

openssl x509 -noout -text -in exported-der.crt -inform der

openssl x509 -out exported-pem.crt -outform pem -in exported-der.crt -inform der

keytool -export -alias mykey -keystore mpestore.dat -file exported-der.crt

openssl x509 -noout -text -in exported-der.crt -inform der

openssl x509 -out exported-pem.crt -outform pem -in exported-der.crt -inform der

Extract private key


mkdir t
cd t
wget http://www.source-code.biz/snippets/java/Base64Coder.java.txt
wget http://mark.foster.cc/pub/java/ExportPriv.java
javac ExportPriv.java Base64Coder.java
java ExportPriv keystore alias password > exported-pkcs8.key

mkdir t

cd t

wget http://www.source-code.biz/snippets/java/Base64Coder.java.txt

wget http://mark.foster.cc/pub/java/ExportPriv.java

javac ExportPriv.java Base64Coder.java

java ExportPriv keystore alias password > exported-pkcs8.key

See http://conshell.net/wiki/index.php/Keytool_to_OpenSSL_Conversion_tips

Fix Plesk DBWebAdmin table copy problem

October 27, 2008

When trying to use the table copy operation in Plesk DBWebAdmin and error is received due to no space between the auto increment and default charset keywords. The following patch can be manually applied to: /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/sqlparser.lib.php to fix the problem.


--- trunk/phpMyAdmin/libraries/sqlparser.lib.php	2006/03/28 11:37:55	8834
+++ trunk/phpMyAdmin/libraries/sqlparser.lib.php	2006/07/30 11:21:59	9205
@@ -2093,6 +2093,12 @@
                         $after     .= ' ';
                     }
                     // workaround for
+                    // AUTO_INCREMENT = 31DEFAULT_CHARSET = utf-8
+
+                    if ($typearr[2] == 'alpha_columnAttrib' && $typearr[3] == 'alpha_reservedWord') {
+                        $before .= ' ';
+                    }
+                    // workaround for
                     // select * from mysql.user where binary user="root"
                     // binary is marked as alpha_columnAttrib
                     // but should be marked as a reserved word

--- trunk/phpMyAdmin/libraries/sqlparser.lib.php 2006/03/28 11:37:55 8834

+++ trunk/phpMyAdmin/libraries/sqlparser.lib.php 2006/07/30 11:21:59 9205

@@ -2093,6 +2093,12 @@

$after .= ' ';

}

// workaround for

+ // AUTO_INCREMENT = 31DEFAULT_CHARSET = utf-8

+ if ($typearr[2] == 'alpha_columnAttrib' && $typearr[3] == 'alpha_reservedWord') {

+ $before .= ' ';

+ }

+ // workaround for

// select * from mysql.user where binary user="root"

// binary is marked as alpha_columnAttrib

// but should be marked as a reserved word

osCommerce Upgrade MySQL from 4.1 to 5.0.x

July 28, 2008

There are several common problems in osCommerce with join syntax when upgrading MySQL from 4.1 to 5.0.x. The exact fix for each join problem depends of the version of oscommerce being used and the patches or contributions that have been applied. The general problem is that the comma operator precedence has changed so that list syntax joins can’t be mixed with explicit joins in the same way. Where this worked previously:


select t1.id
   , t2.some_column
from some_table as t1, another_table as t2
where t1.some_column = t2.some_column

select t1.id

, t2.some_column

from some_table as t1, another_table as t2

where t1.some_column = t2.some_column

It now needs to be:


select t1.id
   , t2.some_column
from some_table as t1
inner
   join another_table as t2
      on t1.some_column = t2.some_column

select t1.id

, t2.some_column

from some_table as t1

inner

join another_table as t2

on t1.some_column = t2.some_column

We’ve identified the following files that frequently need to be updated: catalog/index.php There are four complex queries in this file that need to be updated as follows. The queries are shown in the order that they appear in the code. PRODUCTS BY MFG + CATEGORY Change from:


 $listing_sql = "select " . $select_column_list . " pd.products_notes, p.products_packing_info, pd.products_description, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id = p2c.categories_id and c.categories_id = cd.categories_id and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id
                and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

$listing_sql = "select " . $select_column_list . " pd.products_notes, p.products_packing_info, pd.products_description, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id = p2c.categories_id and c.categories_id = cd.categories_id and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id

and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

to:


        $listing_sql = "select " . $select_column_list . " pd.products_notes, p.products_packing_info, pd.products_description, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "
. "from " . TABLE_PRODUCTS . " p "
. "INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p.products_id = p2c.products_id "
. "INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' "
. "INNER JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id "
. "INNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = p2c.categories_id "
. "INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_id "
. "LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id "
. "where p.products_status = '1' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

. "from " . TABLE_PRODUCTS . " p "

. "INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p.products_id = p2c.products_id "

. "INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' "

. "INNER JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id "

. "INNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = p2c.categories_id "

. "INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_id "

. "LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id "

. "where p.products_status = '1' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

PRODUCTS BY MFG Change from:

$listing_sql = "select " . $select_column_list . " pd.products_notes, p.products_packing_info, pd.products_description, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ". "from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id = p2c.categories_id and c.categories_id = cd.categories_id and p.products_id = p2c.products_id and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

$listing_sql = "select " . $select_column_list . " pd.products_notes, p.products_packing_info, pd.products_description, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ". "from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id = p2c.categories_id and c.categories_id = cd.categories_id and p.products_id = p2c.products_id and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

to:

        $listing_sql = "select " . $select_column_list . " pd.products_notes, p.products_packing_info, pd.products_description, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "
. "from " . TABLE_PRODUCTS . " p "
. "INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id AND pd.language_id = '" . (int)$languages_id . "' "
. "INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p.products_id = p2c.products_id  "
. "INNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = p2c.categories_id "
. "INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_id "
. "INNER JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id "
. "left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id "
. "where p.products_status = '1' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

. "from " . TABLE_PRODUCTS . " p "

. "INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id AND pd.language_id = '" . (int)$languages_id . "' "

. "INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p.products_id = p2c.products_id "

. "INNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = p2c.categories_id "

. "INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_id "

. "INNER JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id "

. "left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id "

. "where p.products_status = '1' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

PRODUCTS BY CATEGORY + MFG Change from:


        $listing_sql = "select " . $select_column_list . " pd.products_notes, pd.products_description, p.products_packing_info, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id = cd.categories_id and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and c.categories_id = p2c.categories_id and pd.language_id = '" .
                (int)$languages_id . "' and (p2c.categories_id = '" . (int)$current_category_id . "' or c.parent_id = '" . (int)$current_category_id . "')";

$listing_sql = "select " . $select_column_list . " pd.products_notes, pd.products_description, p.products_packing_info, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and c.categories_id = cd.categories_id and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and c.categories_id = p2c.categories_id and pd.language_id = '" .

(int)$languages_id . "' and (p2c.categories_id = '" . (int)$current_category_id . "' or c.parent_id = '" . (int)$current_category_id . "')";

to:


        $listing_sql = "select " . $select_column_list . " pd.products_notes, pd.products_description, p.products_packing_info, p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "
. "from " . TABLE_PRODUCTS . " p "
. "INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p.products_id = p2c.products_id  "
. "INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p2c.products_id AND pd.language_id = '" . (int)$languages_id . "'"
. "INNER JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id "
. "INNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = p2c.categories_id "
. "INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_id "
. "LEFT JOIN "  . TABLE_SPECIALS . " s on p.products_id = s.products_id "
. "where p.products_status = '1' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and (p2c.categories_id = '" . (int)$current_category_id . "' or c.parent_id = '" . (int)$current_category_id . "')";

. "from " . TABLE_PRODUCTS . " p "

. "INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ON p.products_id = p2c.products_id "

. "INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p2c.products_id AND pd.language_id = '" . (int)$languages_id . "'"

. "INNER JOIN " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id "

. "INNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = p2c.categories_id "

. "INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_id "

. "LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id "

. "where p.products_status = '1' and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and (p2c.categories_id = '" . (int)$current_category_id . "' or c.parent_id = '" . (int)$current_category_id . "')";

ALL PRODUCTS Change from:

FrontPage / Apache 2.2

June 25, 2008

How to install FrontPage extensions for Apache 2.2: http://www.swart.org.za/wordpress/urrgghh-frontpage.htm

Force SSL

May 18, 2008

RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}

Category: Apache

Java Keytool to OpenSSL

Fix Plesk DBWebAdmin table copy problem

osCommerce Upgrade MySQL from 4.1 to 5.0.x

FrontPage / Apache 2.2

Force SSL

Recent Updates

Categories

Category: Apache

Java Keytool to OpenSSL

Fix Plesk DBWebAdmin table copy problem

osCommerce Upgrade MySQL from 4.1 to 5.0.x

FrontPage / Apache 2.2

Force SSL

Recent Updates

Categories

Get a free consultation from Reliable Penguin