Laravel 7 Digitalocean managed database error: The server requested authentication method unknown to the client

July 20, 2020

I am using Laravel 7 to do testing on DigitalOcean’s managed database cluster. Laravel connection doesn’t work, with error and I have fo find the fix that causing it. Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client This issue has been fixed in PHP7.4, please install PHP7.4 in the Droplet. If […]

Laravel & NPM installation Steps

July 15, 2020

Create a new laravel project. $ composer create-project –prefer-dist laravel/laravel   my-project (NOTE: if you do not have composer, please install in your machine and make it global. This will make a lot easier) Or Clone the repository from github or your private repo. $ git clone <your repo> Install NPM globally if you haven’t installed that […]

PHP Apache2 Laravel Resource interpreted as Stylesheet but transferred with MIME type text/html: “

July 13, 2020

Depending on your server configuration. Some condition, it can be solved by creating an .htaccess file into your root folder (or update the existing one) with this line inside AddType text/css .css this will tell apache to send the right content-type header for .css file On my case, the above won’t work at all. My own hosted Ubuntu needs below changes so […]

Ubuntu un-tar/extract tar ball/file to another directory

January 4, 2015

To extract an archive to a directory different from the current, use the -C, or –directory, tar option, as in: tar -xf archive.tar -C /target/directory

Linux Ubuntu move file from one directory to another directory command

November 26, 2014

In Linux, type: To move file mv somefile /anotherfolder/ To move all folder content: mv /somefolder/* /anotherfolder/* In Ubuntu, type: To move file sudo mv somefile /anotherfolder/ To move all folder content: sudo mv /somefolder/* /anotherfolder/* There’s almost always more than way to do something in Linux. And more importantly, there are almost always caveats. […]

Ubuntu user management command line

November 14, 2014

Change user password To change self password #passwd To change other user password #passwd username Removes the user’s home directory as well as deleting the user #sudo userdel -r [username] Add new user: #sudo adduser <username> Add user to admin #sudo adduser <username> admin Add user to sudoer #visudo Switch user sudo <username>

SSL certificate problem, verify that the CA cert is OK Windows AWS

October 23, 2014

It’s a pretty common problem in Windows, curl used to include a list of accepted CAs, but no longer bundles ANY CA certs. So by default it’ll reject all SSL certificates as unverifiable. You need just to set cacert.pem to curl.cainfo. Since PHP 5.3.7 you could do: 1.download http://curl.haxx.se/ca/cacert.pem and save it somewhere. 2.update php.ini […]

Ubuntu install PHPMyAdmin

September 18, 2014

  Type the following line in terminal: #sudo apt-get install phpmyadmin Package configuration – when asked which web server to use, select apache or lighthttpd – When asked “Configure database for phpmyadmin with dbconfig-common”? Choose “Yes” – Next key in “Password of the database’s administrative user:”. This is password for MySQL that you set during […]

Linux how to exit man page

September 18, 2014

After finished reading a man page manual, press “q” on your keyboard to quite or exit the page. Linux manual pages can be easily accessed via the terminal by typing man program-name. Manual or info page navigation can be accomplished by using the up and down arrow keys or in some cases, by pressing enter for more Once your finished viewing a […]

Ubuntu check PHP and mysql version

April 7, 2014

From command line: php -v mysql -V or php -i | grep -i ‘^libxml’