Archive for the ‘Ubuntu’ Category

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

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: 

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

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

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: , , , ,