Tag Archive: vestacp
SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP
If you have multiple databases hosted on VestaCP the easiest way I found to backup all the databases is to use a script. The first thing you need to do is create a backup account in mySQL that has view only access to all the databases.
1 2 |
<span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">USER</span> <span class="hljs-string">'backupuser'</span>@<span class="hljs-string">'localhost'</span> <span class="hljs-keyword">IDENTIFIED</span> <span class="hljs-keyword">BY</span> <span class="hljs-string">'xxx'</span>; |
1 2 3 |
<span class="hljs-keyword">GRANT</span> <span class="hljs-keyword">SELECT</span>, <span class="hljs-keyword">SHOW</span> <span class="hljs-keyword">VIEW</span>, <span class="hljs-keyword">LOCK</span> <span class="hljs-keyword">TABLES</span>, RELOAD, <span class="hljs-keyword">REPLICATION</span> <span class="hljs-keyword">CLIENT</span> <span class="hljs-keyword">ON</span> *.* <span class="hljs-keyword">TO</span> <span class="hljs-string">'backupuser'</span>@<span class="hljs-string">'localhost'</span>; |
1 |
<span class="hljs-keyword">FLUSH</span> <span class="hljs-keyword">PRIVILEGES</span>; |
Then use this bash script. You […]
HOW TO FIX ERROR 99 CANNOT ASSIGN REQUESTED ADDRESS NGINX
I recently received this error message when I manually started my VestaCP Nginx service: 99: Cannot assign requested address nginx: configuration file /etc/nginx/nginx.conf test failed I tried searching for a solution on Google but none of them helped. After some digging around, I managed to work out what the issue was. A few weeks ago […]

HOW TO MANAGE SUB-DIRECTORY PERMISSIONS IN APACHE
If you want to set permissions for subdirectories e.g restrict public access to /home/folder1/ but allow access to /home/folder1/folder2 then this is one way of doing it: NOTE: I’m using VestaCP, an open source control panel for web hosting so these steps may not work for you Copy and the default.stpl and default.tpl files in /usr/local/vesta/data/templates/web/httpd/ […]

CHANGING DOCUMENT ROOT IN VESTACP WEBSITES
The best way I have found to change the Document Root for specific websites in VestaCP is to create a new Web Template for each domain. I previously edited the document root path in the config file for each for each domain but when NGINX or the server restarted it would revert back to the […]

HOSTING WITH ALICLOUD ALIBABA -HOW TO AND TIPS
Currently, Alicloud has a special that give you Elastic Cloud hosting for USD$30 for the first year – this is really cheap! What you get is: If you want to try it out click on this link – AliCloud or click on the image. One of the main reasons why I decided to try Alicloud was […]
April 13, 2016 / by Marco / app installer, joomla, opencart, phpbb, prestashop, simple machines forum., textpattern cms, vesta, vestacp, Wordpress

WEB APPLICATION INSTALLER FOR VESTA CP
For all you Vesta CP users, you’ll be happy to know that there is now a Web Application Installer which was developed by CDN Mall. Currently there are only 8 Applications you can install: WordPress Nibble Blog OpenCart PrestaShop Textpattern CMS Joomla phpBB Simple Machines Forum To install the Web Application Installer run the following […]
HOW TO FIX UPSTREAM TIMED OUT (110: CONNECTION TIMED OUT) ERROR IN VESTACP NGINX
This was the most annoying issue I’ve ever experienced. I had to import large XML files into a SQL database using a WordPress plugin and kept getting the 500 Internal Server Error message. When I checked the error log I noticed this: *19 upstream timed out (110: Connection timed out) while reading response header from […]
HOW TO DISABLE IPV6 IN EXIM VESTACP
Strangely, today an email delivery failed and I decided to investigate further. The email subject was “Mail delivery failed: returning message to sender” The content in the bounced email was: [codesyntax lang=”php”]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: emailaddress@domain.com (ultimately generated from xxx@domain.com) SMTP error from remote mail server after end of data: host ASPMX.L.GOOGLE.COM [ipv6 address]: 550-5.7.1 [ipv6 address] Our system has detected that this message does 550-5.7.1 not meet IPv6 sending guidelines regarding PTR records and 550-5.7.1 authentication. Please review 550-5.7.1 https://support.google.com/mail/?p=ipv6_authentication_error for more 550 5.7.1 information. z10si11396270par.118 - gsmtp |
[/codesyntax] I’m using VPS hosting with VESTACP and it currently doesn’t support IPV6. However, for some strange reason EXIM (the mail […]