Home | panticz.de

Install SQL developer

VSCode addon
https://marketplace.visualstudio.com/items?itemName=Oracle.sql-developer

code --install-extension Oracle.sql-developer

Get Oracle SQL Developer package
http://www.oracle.com/technology/software/products/sql/index.html
https://www.oracle.com/database/sqldeveloper/technologies/download/

accept the licence
login
download "Oracle SQL Developer for other platforms"

Install

# download sqldeveloper-*-no-jre.zip archive
#https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-22.2.1.234.1810-no-jre.zip
https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-23.1.0.097.1607-no-jre.zip

# OPTIONAL: archive previous version
sudo mv  /opt/sqldeveloper{,.$(date -I)}

# extract
sudo unzip -q ~/Downloads/sqldeveloper-*-no-jre.zip -d /opt/

Configure JDK home / version

# find latest configuration file
SQL_DEVELOPER_COFIG=$(find ~/.sqldeveloper/*/product.conf | sort -V | tail -1)
#sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/default-java/|g' ${SQL_DEVELOPER_COFIG}
sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/java-1.17.0-openjdk-amd64/|g' ${SQL_DEVELOPER_COFIG}

Create starter

# Create desktop starter
cat <

<strong>Reduced memory usage</strong>
<code>
sed -i 's|-Xmx640M|-Xmx384M|g' /opt/sqldeveloper/ide/bin/ide.conf

Connect to MySQL server
https://oracle-base.com/articles/mysql/mysql-connections-in-sql-developer

sudo dpkg -i mysql-connector-java_8.0.26-1ubuntu21.04_all.deb 
# "Tools > Preferences > Database > Third Party JDBC Driver"
/usr/share/java/mysql-connector-java-8.0.26.jar

# DEP:
https://raw.githubusercontent.com/panticz/installit/master/install.sqldeveloper.sh

Install Dropbox under Ubuntu

[embed_url: https://raw.githubusercontent.com/panticz/installit/master/install.dropbox.sh]

# create delayed start
# run this as user
sed -i 's|dropbox start -i|/usr/sbin/dropbox_start_dely|g' ~/.config/autostart/dropbox.desktop

# run this as root
cat < /usr/sbin/dropbox_start_dely

#!/bin/sh
sleep 120
ionice -c 3 dropbox start -i
EOF

chmod a+x /usr/sbin/dropbox_start_dely

Create account and get free Dropbox account with extra 250mb space
https://www.dropbox.com/referrals/NTQxNzA2OTU5

Enable folder share
http://www.dropbox.com/enable_shmodel

Links
http://wiki.ubuntuusers.de/Dropbox
http://www.getdropbox.com/download?plat=lnx.x86
http://www.maximumpc.com/article/features/15_things_you_have_know_about_dropbox

Install Tipp10

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.tipp10.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Install Skype from repository

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.skype.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Fix upside down webcam
<?php
$URL="https://raw.githubusercontent.com/panticz/scripts/master/fix_skype_upsidedown_webcam.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Install with snap

sudo snap install skype --classic

Disable "contacts comes online" notification

# Notify
sed -i 's|1|0|g' /home/${USER}/.Skype/*/config.xml
sed -i 's|1|0|g' /home/${USER}/.Skype/*/config.xml

# Sound
sed -i 's|1|0|g' /home/${USER}/.Skype/*/config.xml
sed -i 's|1|0|g' /home/${USER}/.Skype/*/config.xml

Links
https://www.linuxbabe.com/ubuntu/install-skype-ubuntu-18-04-lts-desktop
http://wiki.ubuntuusers.de/Canonical_Partner - Ubuntu partner repository
http://www.semanticpool.de/hidden-skype-emoticons/ - hidden skype emoticons
https://help.ubuntu.com/community/SkypeTroubleshooting
https://wiki.ubuntu.com/SkypeWebCams

Magento Shadowbox (Rewrite EasyLightBox to Shadowbox)

# install easy light box

http://www.magentocommerce.com/magento-connect/TemplatesMaster/extension/1487/magento-easy-lightbox

# xml

edit

./app/design/frontend/default/default/layout/easylightbox.xml

replace
easylightbox
to
shadowbox

# phtml

copy

./app/design/frontend/default/default/template/easylightbox/media.phtml

./app/design/frontend/default/default/template/shadowbox/media.phtml

edit or download
http://www.panticz.de/sites/default/files/magento/shadowbox/media.phtml

# js

copy

./custom/shadowbox/shadowbox.js

./skin/frontend/default/default/js/shadowbox.js

edit ./skin/frontend/default/default/js/shadowbox.js
add
onclick="Shadowbox.close()"
to
id="sb-wrapper-inner"

# css

copy

./custom/shadowbox/shadowbox.css

./skin/frontend/default/default/css/shadowbox.css

edit ./skin/frontend/default/default/css/easylightbox.css
add
#sb-body,#sb-loading{background-color: #FFFFFF;}
#sb-wrapper-inner{background-color: #FFFFFF;padding: 5px;}

replace
url(
with
url(/skin/frontend/default/default/images/shadowbox/

replace
#sb-loading-inner{position:absolute;font-size:14px;line-height:24px;height:24px;top:50%;margin-top:-12px;width:100%;text-align:center;}
with
#sb-loading-inner{position:absolute;font-size:14px;line-height:32px;height:32px;top:50%;margin-top:-12px;width:100%;text-align:center;}

replace
#sb-loading-inner span{background:url(/skin/frontend/default/default/images/shadowbox/loading.gif) no-repeat;padding-left:34px;display:inline-block;color:#666666;}
to
#sb-loading-inner span{background:url(/skin/frontend/default/default/images/shadowbox/loading.gif) no-repeat;padding-left:38px;display:inline-block;color:#666666;}

# images

create dir

./skin/frontend/default/default/images/shadowbox/

copy *.png and *.gif to

./skin/frontend/default/default/images/shadowbox/

copy

./skin/frontend/default/default/images/lightbox/loading.gif

Install VirtualBox

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.virtualbox.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

?>
--allow-unauthenticated

Fix kernel module

sudo /etc/init.d/vboxdrv setup

Links
http://wiki.ubuntuusers.de/VirtualBox/Installation
http://www.virtualbox.org/wiki/Linux_Downloads
http://www.panticz.de/node/143

Install Java JRE

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.java-jre.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Download Oracle Java JRE & JDK using a script
https://ivan-site.com/2012/05/download-oracle-java-jre-jdk-using-a-script/

Fix mozilla java plugin

JAVA_HOME=/usr/lib/jvm/jdk1.7.0
MOZILLA_HOME=~/.mozilla
mkdir $MOZILLA_HOME/plugins
ln -s $JAVA_HOME/jre/lib/i386/libnpjp2.so $MOZILLA_HOME/plugins

ln -s $JAVA_HOME/jre/lib/amd64/libnpjp2.so $MOZILLA_HOME/plugins

ln -s /usr/lib/jvm/java-7-oracle/jre/lib/amd64/libnpjp2.so  ~/.mozilla/plugins/

Links
http://wiki.ubuntuusers.de/make-jpkg
https://github.com/flexiondotorg/oab-java6 - Create a local apt repository for Sun Java 6 and/or Oracle Java 7 packages.
http://www.webupd8.org/2012/01/install-oracle-java-jdk-7-in-ubuntu-via.html
http://www.webupd8.org/2011/03/install-java-in-ubuntu-1104-natty.html
http://www.sysadminslife.com/linux/howto-oracle-sun-java-7-installation-unter-debian-6-squeeze/

Fix Magento order tax view

mkdir -p ./app/design/frontend/default/default/template/tax/order
cp ./app/design/frontend/base/default/template/tax/order/tax.phtml ./app/design/frontend/default/default/template/tax/order

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/tax/tax.phtml.diff";

echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

mkdir -p ./app/design/frontend/default/default/template/sales/order/ 
cp ./app/design/frontend/base/default/template/sales/order/totals.phtml ./app/design/frontend/default/default/template/sales/order

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/tax/totals.phtml.diff";

echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Fix Magento 1.4.0.1 PayPal shipping costs bug

wget http://www.boostingecommerce.com/files/Magento_1_4_0_1_PayPal_fix.zip -O /tmp/Magento_1_4_0_1_PayPal_fix.zip
unzip /tmp/Magento_1_4_0_1_PayPal_fix.zip -d /tmp/
cp -a /tmp/Magento_1_4_0_1_PayPal_fix/app/code/local/Mage/Paypal /var/www/app/code/local/Mage/

Links
http://www.magentocommerce.com/bug-tracking/issue?issue=8467
http://www.boostingecommerce.com/fix-for-magento-1-4-0-1-paypal-and-shipping-costs

Magento: Fix PayPal order confirmation email not sent

<?php
$URL="http://" . $_SERVER['SERVER_NAME'] . "/sites/default/files/magento/paypal/Onepage.php.diff";

echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Links
http://screencastworld.com/2010/03/magento/magento-commerce-how-to-fix-order-confirmation-email-not-sent
http://inchoo.net/ecommerce/magento/debugging-paypal-ipn-in-magento/
http://sergiy.kyrylkov.name/blog/2010/05/payment-problems-in-magento-paypal-standard-with-ipn-after-upgrade-from-1-3-x-to-1-4-0-1/