Generate CSV file with Header from MySQL Command Console

Generating a CSV file contains several records from MySQL Database using MySQL command console is something that can be done.Especially if we want to specifically define the header of each fields retrieved from each fields of MySQL specific table.

Below is the step which has to be followed in order to generate CSV file needed :

  1. Login to MySQL command console from the bash prompt as shown below :

Continue reading “Generate CSV file with Header from MySQL Command Console”

Laravel Elixir Module Installation

To be able to install Electron, Laravel Elixir is needed to be installed. This is where I am getting stuck while executing Electron application.

After getting Electron installed properly on the workstation, it need to be tested by executing the following command :

./node_modules/.bin/electron

Below is the real output of the command execution on bash prompt :

usernamei@hostname:/var/www/html/laravel-electron$ ./node_modules/.bin/electron .
App threw an error during load
Error: Cannot find module 'laravel-elixir'
at Module._resolveFilename (module.js:440:15)
at Function.Module._resolveFilename (/var/www/html/laravel-electron/node_modules/electron-prebuilt/dist/resources/electron.asar/common/reset-search-paths.js:35:12)
at Function.Module._load (module.js:388:25)
at Module.require (module.js:468:17)
at require (internal/module.js:20:19)
at Object.<anonymous> (/var/www/html/laravel-electron/gulpfile.js:1:93)
at Module._compile (module.js:541:32)
at Object.Module._extensions..js (module.js:550:10)
at Module.load (module.js:458:32)
at tryModuleLoad (module.js:417:12)
A JavaScript error occurred in the main process
Uncaught Exception:
Error: Cannot find module 'laravel-elixir'
at Module._resolveFilename (module.js:440:15)
at Function.Module._resolveFilename (/var/www/html/laravel-electron/node_modules/electron-prebuilt/dist/resources/electron.asar/common/reset-search-paths.js:35:12)
at Function.Module._load (module.js:388:25)
at Module.require (module.js:468:17)
at require (internal/module.js:20:19)
at Object.<anonymous> (/var/www/html/laravel-electron/gulpfile.js:1:93)
at Module._compile (module.js:541:32)
at Object.Module._extensions..js (module.js:550:10)
at Module.load (module.js:458:32)
at tryModuleLoad (module.js:417:12)
^C
username@hostname:/var/www/html/laravel-electron$ 

So, in order for executing Electron apps, laravel-elixir module need to be installed based on the error shown above : “Error: Cannot find module ‘laravel-elixir'”. Below is the step which is needed to be done to install module Laravel Elixir :

Continue reading “Laravel Elixir Module Installation”

Electron Installation

Electron is a framework for creating native applications with web technologies like Javascript, HTML and CSS. It takes care of the hard parts so you can focus on the core of your application. This information can be derived from its official website in http://electron.atom.io

To be able to install electron, npm which is a default package manager for the JavaScript runtime environment Node.js

is needed. Below is the command which is needed to be executed :

npm install --save electron-prebuilt

This is the output of the display from executing the above command :

Continue reading “Electron Installation”

How to Reset nagiosadmin Password

In one occasion, I try to access my Nagios monitoring server page and it is very tragic that I forgot the password to access it. Nagios installation itself by default has its primary username to be used for accessing Nagios monitoring server page. The username or the account is ‘nagiosadmin’ and I hardly remembered the password.

This is where the pop-up dialog box appears to ask for username and password to access Nagios monitoring server page where I edited the URL of Nagios monitoring server so it can be hidden :

nagios-entry-password-edit
Display of pop-up dialog box for authentication entering Nagios monitoring server page in Chrome web browser

Another image which is clearly shown the Nagios Administration authentication pop-up dialog box. I edited the image below so the URL of Nagios Administration monitoring server page didn’t shown up :

Continue reading “How to Reset nagiosadmin Password”

Using npm behind Proxy Server

Remember when I previously execute node but it accidentally display an error message as shown below :

root@hostname:/var/www/html# npm install --global gulp-cli
npm ERR! Linux 4.4.0-24-generic
npm ERR! argv "/usr/bin/nodejs" "/usr/bin/npm" "install" "--global" "gulp-cli"
npm ERR! node v4.2.6
npm ERR! npm v3.5.2
npm ERR! code ECONNRESET

npm ERR! network tunneling socket could not be established, cause=write EPROTO
npm ERR! network This is most likely not a problem with npm itself
npm ERR! network and is related to network connectivity.
npm ERR! network In most cases you are behind a proxy or have bad network settings.
npm ERR! network
npm ERR! network If you are behind a proxy, please make sure that the
npm ERR! network 'proxy' config is set properly. See: 'npm help config'

npm ERR! Please include the following file with any support request:
npm ERR! /var/www/html/laravel-electron/npm-debug.log
root@hostname:/var/www/html#

When I try to install gulp-cli using npm suddenly the error above has risen. Based on the information given npm has a network problem related to network connectity. Since I am positively sure that I execute npm behind a network proxy I try to configure the proxy for npm to be executed properly.

Continue reading “Using npm behind Proxy Server”

Cannot Install Laravel Elixir because permission denied access to node_modules

I am trying to install Laravel Elixir when I stumbled upon this site : https://www.laravel.com/docs/5.3/elixir. It is actually explained clearly on the site how to install Laravel Elixir.

It is can be done with the help of npm. But to ensure that we have already npm installed in our local workstation for those who can access their bash prompt, just do it by typing the following command :

root@hostname:/var/www/html# npm -v
v3.5.2
root@hostname:/var/www/html#

Clearly that node is already installed in the local workstation. So, the next thing which is stated in the guidance on https://www.laravel.com/docs/5.3/elixir as the next step is to execute the following command :

Continue reading “Cannot Install Laravel Elixir because permission denied access to node_modules”

Migrating WordPress based Website

Server   Operating System            : Any operating system available

WordPress Version                       : 4.5

Webserver Engine                       : Any Webserver engine will be fine as long as it supports PHP for server-side scripting.

Migrating WordPress-based Website

If you want to migrate your website which is based on WordPress platform from one host to another or even from your local PC to your hosted server, there are steps which is needed to be done before your WordPress based installation website can be viewed normally. The steps are detailed below :

  1. First of all, copy all of the source code of your website in your target location. It can be a PC, laptop or even your own personal server. Be sure that you have already setup your own Web Server such as Apache Web Server, Microsoft IIS or even any utilities available as a package of Web Server, Database Server, etc such as XAMPP.

Continue reading “Migrating WordPress based Website”