Automatic Restart of OSGI bundle

1. Following script can be used

pswd=`pass OSGI-admin`
echo -e `date`
echo -e "start script"
echo -e "stop bundle"
curl -u admin:"$pswd" http://OSGI-IP:Port/system/console/bundles/bundle.jsp -F action=stop
echo -e ""
echo -e "Waiting for 3 seconds"
sleep 3
echo -e "start bundle"
curl -u admin:"$pswd" http://OSGI-IP:Port/system/console/bundles/bundle.jsp -F action=start
echo -e ""
echo -e `date`
echo -e ""
echo -e ""
echo -e ""

2. Add above script to crontab

crontab -e

Add following line to run every 4 hours:
0 */4 * * * /home/user/bundle-script.sh >> /home/user/history-bundle-script.log

In history-bundle-script.log you shall get logged all events.

Fix ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%' when using MySQL 8

1. Connet to MySQL DB:
mysql -u user -pPASSWORD
 
2. Just Run the following command:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';

Fix mysqli_real_connect(): (HY000/2002): No such file or directory

1. When trying to access http://localhost/phpmyadmin, following messafe is displayed:
mysqli_real_connect(): (HY000/2002): No such file or directory

2. In order to fix, edit config.inc.php
vi config.inc.php

3. Replace
$cfg['Servers'][$i]['host'] = 'localhost';
with
$cfg['Servers'][$i]['host'] = '127.0.0.1';

After this change, it works!

Install MySQL on MAC OSX and integrate with Apache PHP

1. Download and install MySQL DMG package

https://dev.mysql.com/downloads/mysql/


2. Make sure PHP and MySQL work together:

cd /var mkdir mysql cd mysql ln -s /tmp/mysql.sock mysql.sock


3. Add PATH to include MySQL:

export PATH=/usr/local/mysql/bin:$PATH

4. Download PHPMyAdmin latest version from here:

https://www.phpmyadmin.net/
 
5. Install phpmyadmin under default Apache folder:

cd /Library/WebServer/Documents/ 
cp /Users/myuser/Downloads/phpMyAdmin-4.8.3-all-languages.zip .
unzip phpMyAdmin-4.8.3-all-languages.zip 
mv phpMyAdmin-4.8.3-all-languages phpmyadmin 
cd phpmyadmin 
mv config.sample.inc.php config.inc.php

6. Access http://localhost/phpmyadmin