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@55.55.55.55:/var/www/www.server.com/
How quickly copy one DB to another
Well, this is quite simple actually: mysqldump -u db_user -pYourPass -h 127.0.0.1 database_name_from | mysql -u db_user -pYourPass -h 127.0.0.1 database_name_to
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) { […]
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@127.0.0.1 identified by ‘secretpassw0rd’
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 […]
In: Drupal, English, Fighting the system · Tagged with: microsoft, MS'NAV, SOAP
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 […]
In: Fighting the system, Linux, Ubuntu · Tagged with: install, linux, php, postfix, ubuntu
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 […]
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: http://www.w3schools.com/browsers/browsers_explorer.asp 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 […]
In: English, WEB2.0 · Tagged with: html, HTML5
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/www.site.com/html/.htpasswd AuthType Basic AuthName “Password Pup-up Title” Step3: Enjoy.
In: English, Q&EG · Tagged with: Apache
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 […]
In: English, Uncategorized, WEB2.0 · Tagged with: humor