Author Archive
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
How to install SVN server on Ubuntu (via dav_svn aka apache module)
Well, well, well. Today we are going to install subversion on Ubuntu server in a few easy steps. Step1: install all necessary software (considering Apache is up & running already) sudo apt-get install subversion libapache2-svn Step 2: Adding new user called “svn” sudo useradd -d /home/svn -m svn sudo passwd svn Step 3: creating repository […]
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
Scuba Diving in Doolin / Ireland. Dolphin and caves.
Well, well, well 🙂 Today I am going to tell you a story of a dolphin, a diver and… lost Go Pro Hero HD2 😉 But first lest start with a nice video of myself Scuba Diving in Doolin on 25 of August 2012: Hope you enjoyed it! What about Lost Camera? Well… on the […]
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 […]