Archive for the ‘English’ Category

rsync to Amazon AWS server using PEM file

One liner here: rsync -rave –filter=’merge public/.rsync-filter’ “ssh -i /keypath/key.pem” $PWD/public/* ubuntu@

Posted on March 24, 2015 at 14:19 by arte · Permalink · Leave a comment
In: English, Linux

How quickly copy one DB to another

Well, this is quite simple actually: mysqldump -u db_user -pYourPass -h database_name_from | mysql -u db_user -pYourPass -h database_name_to

Posted on September 10, 2013 at 18:03 by arte · Permalink · Leave a comment
In: English, Linux, mySQL, Ubuntu

MS’SQL on Ubuntu Linux via PHP

Hi Folks, today we are going to install & use MS’SQL on Ubuntu Linux! Yay! Well, in fact installation is very simple with a tiny twists 😉 Installation (very simple): sudo apt-get install php5-mssql Now how to use it? PHP Code below: // Connect to MSSQL $link = mssql_connect($db[‘from’][‘server_ip’], $db[‘from’][‘username’], $db[‘from’][‘password’]); if (!$link) {     […]

Posted on September 10, 2013 at 15:21 by arte · Permalink · Leave a comment
In: English, Fighting the system, Linux, MS'SQL, Ubuntu

How to add new MySQL user from the command Line

Very simple actually. GRANT ALL PRIVILEGES ON *.* to root@ identified by ‘secretpassw0rd’

Posted on July 8, 2013 at 16:07 by arte · Permalink · Leave a comment
In: English, mySQL

MS NAV Web Services to/from PHP, receiving and sending data

Some time ago I came across a project where I had to connect MS’NAV and Drupal, two completely different systems one is proprietary (hello MS) and another is PHP & MySql (welcome, open source!) There where few options how both systems could communicate automatically, but unfortunately REST was not available as an option on the […]

Posted on April 2, 2013 at 17:51 by arte · Permalink · 32 Comments
In: Drupal, English, Fighting the system · Tagged with: , ,

Sendmail alternative – postfix on ubuntu (when PHP doesn’t send emails) in a few easy steps

Imagine you have your new shiny Ubuntu server. You installed your php, apache & mysql and everything seems fine until… you realised your system doesn’t  send emails. If there is a problem – there must be a solution! In our case it’s either install good (… not so in fact) sendmail or postfix. We decided […]

Posted on March 28, 2013 at 12:20 by arte · Permalink · 2 Comments
In: Fighting the system, Linux, Ubuntu · Tagged with: , , , ,

Tissot SeaTouch – how to remove error symbol (for example after changing battery)

Have you seen that strange wrench symbol on your watch? I did! And AFTER I changed battery and had my watch pressure tested for as “little” as 43€ 😉 Manual says… TA-DA! Error – Contact service centre. Well, thanks guys! Actually it’s THEY did it to my watch! I had two options – go back […]

Posted on August 1, 2012 at 12:49 by arte · Permalink · 17 Comments
In: English

HTML5 and … why it’s too early to use it in most of your projects

Well, today I decided to look into HTML5 and some statistics around it. First thing first – I went to the following page: and checked what is worth considering “an actual browser”. Here we go – my screenshot: Unfortunately most commonly used version of IE is… IE 8. Everything below, let’s say 3.5% (I […]

Posted on March 14, 2012 at 16:53 by admin · Permalink · Leave a comment
In: English, WEB2.0 · Tagged with: ,

Apache, how to protect directory with a password

Another Q&EG. Step 1: create .htpasswd file in your directory (or any other location on the server actually) htpasswd -c .htpasswd username Step2: create file / add following lines to the existing file; make sure AuthUserFile directive have full path. AuthUserFile /var/www/ AuthType Basic AuthName “Password Pup-up Title” Step3: Enjoy.

Posted on March 5, 2012 at 12:15 by admin · Permalink · Leave a comment
In: English, Q&EG · Tagged with: 

Thoughts about HTML and development. HTML Nazi.

Well, being a Russian Grammar Nazi, as it seems, now I am starting to pick up the same approach in HTML (4.01 transitional / XHTML 1.1 transitional / … ). So, if you ask me, what can a real HTML Nazi hero do?   Step 1: First of all –  your pages must have Uber […]

Posted on February 27, 2012 at 21:06 by admin · Permalink · Leave a comment
In: English, Uncategorized, WEB2.0 · Tagged with: