Saturday, October 31, 2015

[IT-001]-InProgress: Backup & Archive for Server Room-20151101_1206

Backup & Archive for Server Room-20151101_1123

1. Background:- 
(a) Installed SAN storage and HP blade enclosure.
(b) Plan to deploy VMs, Linux VM, Window VMs, MySQL, XAMPP, MS SharePoint, MS Exchange and File Server

2. Problem:-
(a) What will happen if MySQL crashes. How to recover & restore?
(b) How to safeguard from total disaster at site?
(c)

3. Solution Architecture:-
(a) Disk-2-Disk-2-Tape

4. Unknown Issues:-
(a) How VMs get backup? Is it stored as single file?
(b) 

5. The Tour of IT Idiot [typical for IT Idiots, who searches in the dark ;)]


6. The Solution  (in progress!)


7. Lessons Learnt (so far!)

8. The Diary:-
20151101-

Tpt-Blog: Problem-n-Solution-by-an-IT-Idiot-20151101_1408

Template-Blog: Problem-n-Solution-by-an-IT-Idiot-20151101_1408

1. Background:- 
(a) Installed SAN storage and HP blade enclosure.
(b) Plan to deploy VMs, Linux VM, Window VMs, MySQL, XAMPP, MS SharePoint, MS Exchange and File Server

2. Problem:-
(a) What will happen if MySQL crashes. How to recover & restore?
(b) How to safeguard from total disaster at site?
(c)

3. Curious Questions


4. Solution Architecture:-
(a) Disk-2-Disk-2-Tape

5. Unknown Issues:-
(a) How VMs get backup? Is it stored as single file?
(b) 

6. The Tour of IT Idiot [typical for IT Idiots, who searches in the dark ;)]


7. The Solution  (in progress!)


8. Lessons Learnt (so far!)


9. The Diary:-
20151101-

[IT-003] Step-By-Step: Installation of Piwigo Photo Gallery-20151101

Step-By-Step: Installation of Piwigo Photo Gallery-20151101_1349


Thought of deploying a decent FOSS photo gallery and my search stopped at Piwigo, a PHP/MySQL based software.

Installation Steps:-


(a) Check for Pre-requisites:
(i) Installation Set:
    (aa) 01-xampp-win32-1.8.2-6-VC9-installer.exe
    (bb) 02-piwigo-2.7.1.zip
    (cc) 02a-piwigo-plugins.zip

(ii) Port-80 for apache & port-3306 for mysql to be free

(b) Preparation of Apache
01-Install XAMPP

02-Start Apache & MySQL from Xampp controller

03-Change ‘root’ password to ‘*****’ from phpmyadmin. It will cause inaccessible phpmyadmin.

04-Update root password in phpMyAdmin config file ‘config.inc.php’ at d:\xampp\phpMyAdmin. Archive original file. It will restore access to phpMyAdmin

05-Set password ‘*****’ for ‘pma’ user in MySQL. It will fix error msg  ‘Connection for controluser as defined in your configuration failed phpmyadmin xampp’.

06-Create ‘photogallery’ folder in htdocs folder of xampp

07-Unzip ‘Piwigo’ application to newly created ‘photogallery’ folder

08-Rename existing ‘galleries’ folder as ‘galleries-back‘

09-Create symlink ‘galleries’ folder using ‘mklink’ command from windows command prompt. Target to existing photo folder. (Ex.: > mklink /d .\galleries d:\myphotos)

10-Copy ‘index.php’ from ‘galleries-back’ into newly created symlink folder ‘galleries’

11-Unzip ‘piwigo-plugins.zip’ into ‘plugins’ folder of ‘photogallery’ folder in htdocs. My favourite plugins are 'SmartAlbum', 'stripped' etc.

(c) Configuration of Piwigo
12- Open http://localhost/photogallery

13- Enter following values in setup screen:
-       Default languate: English(GB)
-       Database Host: localhost
-       User: root
-       Password: *****
-       Database Name:  photogallery
-       Database tables prefix: photogallery_
-       Piwigo Admin User: photogallery-admin
-       Password: *****
-       Email: test@test.com

14-Create user ‘myuser’ in Piwigo. User name of your choice.

15-Activate plugins

16-Click ‘Quick Synchronisation’ to sync with your photo repository in local harddisk. It updates ‘Albums’ menu.

17-Installation Completed.