If you can't run like this please stay at home quietly! pic.twitter.com/eJgfwmFmfY
— Ila Sharma (@ila_home) March 31, 2020
Category Archives: Uncategorized
How to get the size of the MySQL database?
SELECT table_schema "Databases",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema; Run this query and you’ll probably get what you’re looking for.
क बाट आउने २० अंग हरु यिनै हुन् बुझ!
क बाट आउने २० अंग हरु यिनै हुन् बुझ!
— Bhaktaraz Bhatta (@bhaktaraz) August 25, 2019
केश
कन्चेट
कुहुनु
कपाल
कलेजों
काखी
करंग
कन्सिरी
कानेगुजी
कुर्कुच्चा
कटी
कान
कम्मर
कापा
कान्छिऔला
काँध
कुम
कँदो
कोखो
कन्पारो
Add SSH Keys to authorized_keys file
cat ~/.ssh/id_rsa.pubCopy the key from terminal.
Then, login to server.
sudo vi ~/.ssh/authorized_keys
Paste your key.
Done!
Or,
cat ~/.ssh/id_rsa.pub | ssh USER@HOST "mkdir -p ~/.ssh && cat >> ~/.ssh/authorized_keys"Done!!
Installing Dnsmasq for wildcard local domains on Debian
Install
sudo apt-get install dnsmasq
Configure
sudo vim /etc/dnsmasq.conf
Add this:
address=/example.com/127.0.0.1 listen-address=127.0.0.1
This maps *.example.com to 127.0.0.1 – replace with the domain you want to use. It also makes dnsmasq only respond to local requests for security – this is optional.
Restart to load the new configuration:
sudo /etc/init.d/dnsmasq restart
Test it:
nslookup abc.example.com 127.0.0.1
It should say something like:
Server: 127.0.0.1 Address: 127.0.0.1#53 Name: abc.example.com Address: 127.0.0.1
Override the nameserver to use for lookups
sudo vim /etc/dhcp/dhclient.conf
Add:
prepend domain-name-servers 127.0.0.1;
Restart the network:
sudo ifdown eth0; sudo ifup eth0
Adjust as necessary if your interface is not named eth0. Run ifconfig to get the interface name if you’re not sure.
Check that it worked:
cat /etc/resolv.conf
It should say something like:
domain home search home nameserver 127.0.0.1 nameserver 192.168.32.254
Note that 127.0.0.1 is the first nameserver.
Test:
nslookup abc.example.com
It should say the same thing as it did above.
The original post is here.
Nepals Top Payment Gateway nPay Integration – Symfony 3 Example
Here today I’m going to post a piece of code to integrate Nepal’s one of top payment gateway nPay.
Setting server for first time to deploy PHP application to cloud
Apache
- sudo apt-get update
- sudo apt-get install apache2
Click Here for more details.
MySql
- sudo apt-get update
- sudo apt-get install mysql-server
- mysql_secure_installation
Click Here for more details.
Composer
- sudo apt-get update
- sudo apt-get install composer
Click Here for more details.
PHP
- sudo add-apt-repository ppa:ondrej/php
- sudo apt-get update
- sudo apt-get install php7.1 php7.1-common
- sudo apt-get install php7.1-curl php7.1-xml php7.1-zip php7.1-gd php7.1-mysql php7.1-mbstring
Click Here for more details.
Upgrade from PHP 7.0 to PHP 7.1
Add Ondrejs PPA Repo
PPA’s or Personal Package Archive, is a collection of software not included in Ubuntu by default. Typically these repositories focus on a single program, but they can include more depending on the person maintaining them. Ondřej Surý has created this PPA which has the latest versions of PHP in it. Lets add it to your system, and update to get a list of all the software we can install.
$ sudo add-apt-repository ppa:ondrej/php$ sudo apt-get updateInstall PHP 7.1
Lets stop our server first, then install PHP 7.1.
$ service apache2 stop$ sudo apt-get install php7.1 php7.1-common
We’ll also install some extra packages for our PHP installation – these are needed for Laravel and Composer!
$ sudo apt-get install php7.1-curl php7.1-xml php7.1-zip php7.1-gd php7.1-mysql php7.1-mbstring php7.1-mysql
Once that is done, lets check PHP is updated on the CLI
$ php -v
If the first row looks like this, we’ve done good so far! PHP 7.1.11-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Oct 27 2017 13:49:56) ( NTS )
Remove PHP 7.0
Now we have PHP7.1, lets get rid of PHP7.0
$ sudo apt-get purge php7.0 php7.0-common
Once this has been done, I usually restart the server.
$ sudo shutdown -r now
Make PHP7.1 used by Apache
Finally, we need to tell Apache to use PHP7.1 now PHP 7.0 is not being used. Lets enable the PHP mod!
$ a2enmod php7.1$ service apache2 restartThats it – PHP should now be using PHP 7.1 – enjoy your amazing new features such as function return types and multiple error catch’s! If you are having issues, feel free to prod me on Twitter at @bhaktaraz
Bhamkeni Dham, Bhimdatta Nagar, Kanchanpur, Nepal
My last visit to vamkeni dham a historic hindu place.
Detect OnePlus5 in Ubuntu in MTP mode
So if you have connected OnePlus 5 to Ubuntu, you will notice that you can only see “OnePlus Drivers” as mounted but you cannot access the internal memory using MTP, although ptp works!
So here is what you need to do to make it possible
1. Enable Developer options in Settings
2. Enable ADB ( this needs to be enabled else, mtp doesnt work )
3. Open a terminal window and follow this :
– we will edit 2 files and add some lines in them. My preferred editor is vim. you may use nano / emacs etc.
COMMAND :
sudo vim /lib/udev/rules.d/69-mtp.rules
ADD LINE :
ATTR{idVendor}==”2a70″, ATTR{idProduct}==”9011″, SYMLINK+=”libmtp-%k”, ENV{ID_MTP_DEVICE}=”1″, ENV{ID_MEDIA_PLAYER}=”1″
save and exit
COMMAND :
sudo vim /etc/udev/rules.d/51-android.rules
ADD LINE :
ATTR{idVendor}==”2a70″, ATTR{idProduct}==”9011″, MODE=”0666″
save and exit
COMMAND :
sudo service udev restart
Now disconnect and reconnect your phone, you will have “Android Device” as the mtp device.
If you still cannot see, reboot and try to see if the device is now visible!
Thankyou!