raspbian

Linux ~ phpmyadmin error on PHP 8

/ mr.ic4l Leave a comment

Back up phpMyAdmin

Backup dulu file yang lama.

 $ sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak

Create a new phpMyAdmin folder

$ sudo mkdir /usr/share/phpmyadmin/

Change to the directory

$ cd /usr/share/phpmyadmin/

Download and Extract phpMyAdmin

$ sudo wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz

Now extract

$ sudo tar xzf phpMyAdmin-*-all-languages.tar.gz

Once extracted, list folder

$ ls

Nanti akan kelihatan folder phpMyAdmin-*-all-languages

Kita akan memindah isi folder ke /usr/share/phpmyadmin

$ sudo mv phpMyAdmin-*-all-languages/* /usr/share/phpmyadmin

Make a copy of /usr/share/phpmyadmin/config.sample.inc.php

$ sudo cp /usr/share/phpmyadmin/config.sample.inc.php /usr/share/phpmyadmin/config.inc.php

Now edit the config.inc.php

$ sudo nano config.inc.php

$cfg['blowfish_secret'] = 'Zbwen/BEAFv:HTbqOROrqakJ;KUMIpV:'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

$ Ctrl+x /* to save the file */

Go to your site/phpmyadmin check all error is cleared.

=================================================

YOU MAY ENCOUNTER THIS ERROR MESSAGE ON PHPMYADMIN /INDEX.PHP

IT MAY SAY SOMETHING LIKE:

The $cfg['TempDir'] (/usr/share/phpmyadmin/tmp) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

===SOLUTION==

$ sudo mkdir -p /var/tmp/phpMyAdmin

$ sudo chown www-data:www-data /var/tmp/phpMyAdmin

$ sudo chmod -R 700 /var/tmp/phpMyAdmin

Edit the config.inc.php again

$ sudo nano config.inc.php

add or replace this line

$cfg['TempDir'] = '/var/tmp/phpMyAdmin';

Cleanup — You can now delete the tar.gz file and the empty folder.

$ sudo rm -rf /usr/share/phpmyadmin/phpMyAdmin-latest-all-languages.tar.gz

And if you’re certain your new phpMyAdmin install is working correctly you can delete the backup folder.

$ sudo rm -rf /usr/share/phpmyadmin.bak

Linux – Error Pada phpmyadmin

/ mr.ic4l Leave a comment

Jika kita install phpmyadmin pada ubuntu 18.* keatas kita akan menemukan error jika kita masuk ke sebuah tabel.

sudo sed -i "s/|\s*\((count(\$analyzed_sql_results\['select_expr'\]\)/| (\1)/g" /usr/share/phpmyadmin/libraries/sql.lib.php
sudo systemctl restart mysql
sudo service apache2 restart

Linux – Setting Akses Remote Database MariaDB

/ mr.ic4l Leave a comment

Terkadang jika kita mempunyai banyak komputer di rumah dan ingin menjadikan satu komputer sebagai server database dan bisa diakses melalui komputer mana saja di dalam intranet. maka kita harus membuat user untuk database yang bisa diakses melalui komputer lokal mana saja.

Secara default MariaDB hanya bisa di akses melalui komputer lokal saja. Agar bisa di akses melalui komputer yang lain maka harus diganti settingannya menjadi seperti dibawah ini.

Read more

Install Composer

/ mr.ic4l Leave a comment

 

 

sudo apt install curl php-cli php-mbstring git unzip php-curl
sudo apt-get install -y php7.*-gd
sudo apt-get install php7.*-intl
sudo apt-get install php7.*-xsl
sudo apt-get install php7.*-mbstring
sudo service apache2 restart
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('sha384', 'composer-setup.php') === 'e0012edf3e80b6978849f5eff0d4b4e4c79ff1609dd1e613307e16318854d24ae64f26d17af3ef0bf7cfb710ca74755a') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php
php -r "unlink('composer-setup.php');"
curl -sS https://getcomposer.org/installer |php
sudo mv composer.phar /usr/local/bin/composer

Raspberry Pi 1.1 ~ DHT11 Temperature & Humidity

/ mr.ic4l Leave a comment

 

dht11-module

DHT11 adalah sensor module untuk mengukur temperatur dan kelembapan udara. Disini kita tidak akan menggunakan python, karena udah di coba berapa kali gagal ngebaca datanya dari sensor. Kita akan menggunakan C untuk kali ini. Lets’s Do It……………!

Read more

Raspberry Pi 0.9 ~ Host Key Verification Failed

/ mr.ic4l Leave a comment 
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that the RSA host key has just been changed.
The fingerprint for the RSA key sent by the remote host is
NN:NN:NN:NN:NN:NN:NN:NN:NN:NN:NN:NN:NN:NN:NN:NN.
Please contact your system administrator.
Add correct host key in /Users/ic4l/.ssh/known_hosts to get rid of this message.
Offending key in /Users/ic4l/.ssh/known_hosts:8
RSA host key for [192.168.x.x]:22 has changed and you have requested strict checking.
Host key verification failed.

Read more

Raspberry Pi 0.8 ~ Add New User

/ mr.ic4l Leave a comment

RasPi_VT420

Terkadang berbahaya jika kita hanya menggunakan default user dan password dari raspi jika kita tidak menggantinya. Karena sudah sangat umum. Dengan mengganti password default atau lebih baik lagi membuat user baru dan password, akan membuat raspi kita jadi lebih aman dari segala ancaman dari luar.

Read more

Raspberry Pi 0.6 ~ Install APACHE, MariaDB, en PHP

/ mr.ic4l Leave a comment

lamp
Pengen punya webserver sendiri yang terpisah dari komputer kita? gue seh males klo harus install APACHE sama MySQL di komputer sendiri karena berasa rempong aja gitu. apalagi harus di setting sana sini klo ada error biasanya ngerasa komputer juga error. Jadilah klo bikin webserver di komputer yang terpisah. With Raspberry Pi, we can do it….. How is it? Let’s Do It Yourself….

Read more