VestaCP can’t enable LETSENCRYPT
If you are facing problem to enable SSL Support with Let’s Encrypt in VestaCP GUI, you may try this method. open file with your favorite editor/usr/local/vesta/data/users/—user_name—/web.conffind…
Where is Manage.io data file stored?
Manager.io data is stored in SQLite database, with .manager extension. (e.g. f565db9ce123456188729588d6f5f2269.manager) By default, you can locate it in /Users/yourusername/.local folder. You can backup this file…
Copy folder path in MacOSX
Either you like to run a command at terminal or open hidden folder in, the fastest way to get the folder path is using Finder and…
SQL query valid email format data
Suitable for creating eNewsletter or bulk email application. We can use wildcard method in SQL. SELECT * FROM tableName WHERE emailField LIKE ‘%_@__%.__%’
MySQL Select Statement to joint 2 fields value into 1 return
You can use CONCAT to join 2 fields and return in 1 select statement value. e.g SELECT CONCAT(firstName,’, ‘,lastName) as fullName FROM tableName
Upgrade insecure request
Sometime an https will show an insecure sign due to some contents or 3rd party contents are not a secure https. The easier way to ensure…
Braintree for Paypal Client_Token
Paypal integration now required Braintree SDK, to use the Braintree SDK, you will require the Client_Token generate from the server. What is Client Token? A client…
Opencart 2.2 view order undefined error solution
If you have problem after enabled SSL, here is the quick fix. Go to admin/controller/sale/order.php in line 850 change $data[‘store_url’] = $this->request->server[‘HTTPS’] ? str_replace(“http”, “https”, $order_info[‘store_url’]) :…
Configure Monit
After installing Monit, you may want to use the web Interface. To access it you need to go to http://your.ip.address:2812 eg http://127.0.0.1:2812 If you have firewall…
Monit Installation for CentOS7
To keep thing short, I straight into Monit installation assuming you have installed CentOS7. Configure EPEL repo to download the latest version of Monit rpm -ivh…