Archive for the ‘English’ Category

Facebook – you failed me again… and again… and…

Facebook, how do expect anyone to develop anything for you if: your code samples provided don’t work your documentation page is broken and not accessible for over 6 hrs already there is no way of contacting anyone about issues above And to prove all above: And PHP SDK error page: https://github.com/facebook/facebook-php-business-sdk/issues/464 Full day wasted. Thanks a […]

Posted on July 25, 2018 at 18:59 by arte · Permalink · Leave a comment
In: English, Fighting the system

Little PHP script to create MySQL table from CSV/TSV/Excel file with or without data

Recently I needed a little tool to create many DB tables in MySQL from Excel/CSV docs and as an outcome of that I’ve created this little tool: https://github.com/aarefjev/csv_to_mysql It’s a little buggy I suppose, but does what it’s supposed to. Have fun!  

Posted on June 14, 2018 at 15:44 by arte · Permalink · Leave a comment
In: English, Fun, mySQL · Tagged with: ,

Password Protect Directory with NGinx

& Ubuntu 16.04 sudo apt-get install apache2-utils htpasswd -c /home/username/.htpasswd username Login: username Password: your_cool_password those lines are added to “/etc/nginx/sites-available/cool_site_config config location /restricted_area {        auth_basic “Administrator Login”;        auth_basic_user_file /home/username/.htpasswd; }

Posted on October 3, 2017 at 16:59 by arte · Permalink · Leave a comment
In: English, Linux, nginx, Ubuntu

How to find out your WiFi password details on Windows 8 & Windows 10

Two simple commands in the command line interface will help you:  first to list all saved connections second to get information about that connection in my sample: netsh wlan show profile key=clear After we have profile names – we can pinpoint to one: netsh wlan show profile name=”GEC_Cafe” key=clear   Key Content value is exactly […]

Posted on March 9, 2017 at 12:05 by arte · Permalink · Leave a comment
In: English, Windows

New Ubuntu 16.04 install with Apache2 & Multiple PHP versions on the same machine

Don’t have much time time – so a very quick guide: sudo apt install openssh-server sudo apt-get install -y mc openssh-client git wget apache2 build-essential php php-json apt install software-properties-common sudo add-apt-repository ppa:ondrej/php sudo apt-get update sudo apt-get install php5.6-fpm a2enmod proxy_fcgi setenvif a2enconf php7.0-fpm # if you want to make 5.6 main version: > […]

Posted on January 2, 2017 at 22:51 by arte · Permalink · Leave a comment
In: English, Linux

Craft CMS & Twig Snippets

Some samples dumped here Related Entries (aka “entries” type field) {% set authors = craft.entries.section(‘newsAuthors’).relatedTo(entry) %} {% set auth = authors.first() %} Current Page URL {{ url(craft.request.path) }} How to get NEO/ Matrix Field in template {{entry.textWithSubtitle.first().subtitle}} Loop entire section {% for key,job in craft.entries.section(‘jobs’) %} OUT {% endfor %} Neo/Matrix fields with block types […]

Posted on October 18, 2016 at 16:00 by arte · Permalink · Leave a comment
In: Craft CMS + Twig, English, Fighting the system

RapidSSL cert installation on nginx server

I recently installed RapidSSL cert and got “not trusted” message on Android (desktop browsers were both ok) Now… this is how to install RadidSSL cert properly. Step 1: got and check your installation here https://cryptoreport.rapidssl.com/checker/views/certCheck.jsp – if you’ve got nothing working yet – just download RapidSSL SHA256 CA cert from here: https://cryptoreport.rapidssl.com/chainTester/webservice/validatecerts/certificate?certKey=issuer.intermediate.cert.84&fileName=RapidSSL%20SHA256%20CA&fileExtension=txt Or choose the […]

Posted on April 29, 2016 at 11:53 by arte · Permalink · Leave a comment
In: English, Linux, nginx, Ubuntu · Tagged with: 

Install Android SDK on Linux – in my case Ubuntu 14.04 server

wget http://dl.google.com/android/android-sdk_r24.4.1-linux.tgz tar -xvf android-sdk_r24.4.1-linux.tgz cd android-sdk-linux/tools ./android update sdk –no-ui create file: ~/.zshrc with follwing content: export PATH=${PATH}:$HOME/sdk/android-sdk-linux/platform-tools:$HOME/sdk/android-sdk-linux/tools:$HOME/sdk/android-sdk-linux/build-tools/23.0.2/ sudo apt-get install libc6:i386 libstdc++6:i386 sudo apt-get install zlib1g:i386

Posted on March 8, 2016 at 14:41 by arte · Permalink · Leave a comment
In: English, Linux

Linux install Java 8 from Oracle

sudo add-apt-repository ppa:webupd8team/java sudo apt-get update sudo apt-get install oracle-java8-installer sudo apt-get install oracle-java8-set-default

Posted on March 8, 2016 at 13:22 by arte · Permalink · Leave a comment
In: English, Linux

How to resize (make it bigger) partition on Ubuntu 14.04 in Command Line

Let’s assume you have new virtual Linux Server box running and you “suddenly” out of space. Shit. Well, you stopped your VM and increased the size of you hard drive from 20Gb to 40Gb, started VM again and… nothing changed. This is what I did: Sttep1: First i run cfdisk and removed swap (yes, you […]

Posted on March 8, 2016 at 13:09 by arte · Permalink · Leave a comment
In: English, Fighting the system, Linux