Turn Monolith server of LAMP stack using php-fpm that also uses MEAN stack into microservices

Hits: 1640 The project is to make microservices in place of a monolithic nodejs application stack. Apache Web Server, php-fpm, nodejs application server with mongodb, mysql backend. This got divided into 2 seperate projects, of LAMP and MEAN stack. It can be tweaked to have the php-fpm LAMP read/Write from the MongoDB Database and to have …

Binary log error in mysql – put your configs under [mysqld] not [mysqld_safe]- Stack Overflow

Hits: 539When I am trying to check binary log: SHOW BINARY LOGS; I get this error: ERROR 1381 (HY000): You are not using binary logging. How to resolve this? Can anybody help? Remove section [mysqld_safe] and replace with [mysqld]. It works for me. I had placed new config data under mysqld_safe, which is wrong. I …

Setup Hmailserver  with ssl works with Outlook 2016 but not with Roundcube 

Hits: 1874How to generate custom self-signed SSL certificates and apply it to Dovecot – Plesk Help Center, producing the certs for HmailServer worked using these directions for OpenSSl for windows. http://slproweb.com/products/Win32OpenSSL.html cd into install dir c:\openssl-win32\bin use .\ before each command.   I followed Generate root private key: # openssl genrsa -out rootCA.key 2048 Generate …

How to clean up mysql installation on centos / Amazon Linux ? I want to make simpler servers available for my Charming Customers

Hits: 243 Some time we faces issues with MySQL installation on Linux machine. If we simply remove MySQL packages and re-install doesn’t fixes the issue, in that case old settings may still exists on server which again affects new install. In that case first uninstall MySQL completely from system and erase all settings of old …

vTiger 7 Webforms broken – fields, form, 500 error in – Here’s the fix for  CRM

Hits: 4578Vtiger WebForms don’t work, so here is a quick and needed fix. Vtiger version 5, 6 and 7 have issue creating webforms to capture leads from their website. They have added the ability to have the form work with other modules than just leads, but it still didn’t work. Install OpenSource Charming CRM. Everything …

Can we write a script to restart MySQL every time the website is down? – Stack Overflow

Hits: 924   I love MySql and I love it even more on Nano Servers, but it doesn’t like them. I bit too much work or a tiny DDOS attack brings down the database. I hope to implement the following answer Use a bash script to monitor the mysql port and restart it if it …

Import and export databases using phpMyAdmin – TechRepublic

Hits: 896phpMyAdmin offers one of the easiest ways to import and export databases on a MySQL environment. Follow along with Jack Wallen’s phpMyAdmin tutorial. Source: Import and export databases using phpMyAdmin – TechRepublic Exporting databases The first step in this process is to export the working database from the source server. Log in to the …