VirtualBox - Waiting for network configuration issue (Missing eth0)

• if MAC address changed
• Remove /etc/udev/rules.d/70-persistent-net.rules file to make sure the new adapter to be eth0;
• Or update the /etc/network/interfaces for proper configuration for the new adapter (it maybe eth1, eth2 or ...)

[FW] Using gzip and gunzip with mysql to import/export backups

Exporting:

mysqldump -u user -p database | gzip > database.sql.gz

Importing:

gunzip < database.sql.gz | mysql -u user -p database

refer: http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/

Mount cifs on Ubuntu Server (Microsoft Windows Shares)

1. sudo apt-get install cifs-utils
2. Temporary
2.1. mount -t cifs //XXX/XXX -o username=XXX,password=xxx /media/mnt
3. Permanent (for user MyAccount which uid is 1000)
3.1. Add a file .smbcredentials under /home/MyAccount with following informaiton
       username=XXX
       password=xxx
3.2 Add following into /etc/fstab
      //XXX/XXX /media/mnt cif uid=1000,credentials=/home/MyAccount/.smbcredentials 0 0
3.3. mount -a

refer: https://wiki.ubuntu.com/MountWindowsSharesPermanently

Update timezone on Ubuntu Server

1. Check Timezone
$ cat /etc/timezone
  Etc/UTC
2. sudo dpkg-reconfigure tzdata
  select Asia
  select Taipei

Refer: http://www.christopherirish.com/2012/03/21/how-to-set-the-timezone-on-ubuntu-server/

Redmine - Implementation

• System installation
• Basic installation
• standard installation
• Ubuntu Linux(or  MS Windows)
• Apache
• MySQL (or Postgre SQL)
• Redmine
• Ruby & Rails
• bitnami installation
• packed installer
• Virtual Machine (*)
• VMWare and VirtualBox are all workable.
• Email setup
• Modify configuration.yml under /opt/bitnami/apps/redmine/htdocs/config
• Fill up the SMTP information (our SMTP server or Email)
• Subversion integration
• Link the exist repository
• Link between Revision and Issue
• Standard link
• Go to specified revision under Repository page
• Add the Issue id releated.
• Subversion message log
• #XXX will be translated to a link refer to the Issud ID XXX
• Issue comment log
• rXXX will be translated to a link refer to the Revision ID XXX.
• System backup/restore
• Backup items
• Redmine database
• For MySQL:
• mysqldump -u root -p XXX bitnami_redmine > sqldump.sql
• Attached files
• rsync -a /opt/bitnami/apps/redmine/htdocs/files /mnt/storage/redmine/files

• Work Flow
• Issue reporting flow
• Bug fix flow
• Reporter creates an issue with “New” state and assign to TaskOwner
• TaskOwner assigns the issue to the Developer (TaskOwner may be the issue owner). 
• Developer changes the state to “In Progress” when handling.  
• Developer changes the state to “Resolved” or “Rejected” then assigned to Verifier. 
• Resolved: Solution provided for verification. 
• Verifier changes the state to “Closed” and changes the assignee to NULL if the solution has been verified. 
• Verifier changes the state to “ReOpen” and assign back to Developer if the solution is not workable. 
•  Rejected: Invalid testing procedure or Work As Design issue. 
• Verifier changes the assignee to NULL if he/she agree with that. 
• Verifier changes the state to “ReOpen” and assign back to Developer if the “Rejected” reason if not acceptable.
• Reporter/Verifier has right to change state from “Closed” to “ReOpen” and assign to Developer if the same issue happens again.
• Project management of a development flow
• TaskOwner Creates ToDo list
• Creates issues with "Feature" category
• Setting constraints between issues.
• Fills up the estimated start/end date and working hours of the issue
• Checks the Gantt Chart 
• TaskOwner Create Roadmap
• Create Versions and assign feature issues to specified Version 
• Team work (TaskOwner)
• Assign specified issue to Developer
• Update the start/end date of the issue and related issues.
• Checks the Gantt Chart.

Redmine - Project Management & Issue Tracking system

• Issue Tracking system comparison
• Not Free
• JIRA (project management feature as well)
• basecamp (project management feature as well)
• Cost Free
• Trac (project management feature as well)
• Written by Python
• Redmine (project management feature as well)
• Written by Ruby & Rails
• Mantis
• Bugzilla

• Roles in Redmine (For our design flow)
• Manager
• Project administrator (Permission Controller)
• Task Owner
• Main Developer, Version creator.
• Developer
• Issue fixer
• Reporter
• Main issue reporter
• Verifier
• Solution verifier

• Issue state in Redmine (For our design flow)
• New
• In Progress
• Resolved
• Solution provided
• Feedback
• Needs more informaiton
• Closed (issue finished)
• Solution verified
• Rejected (issue finished)
• Due to some reason, the issue has been terminated
• ReOpen
• Issue happens again.

Using VirtualBox raw disk on Win7

1. Offline the Physical Disk 0 and clear the read-only flag
1. run diskpart.exe
2. run "SELECT DISK 0" -- 0 is the physical disk I would like to use.
3. run "OFFLINE DISK"
4. run "ATTRIBUTES DISK CLEAR READONLY"
5. run "ATTRIBUTES DISK" to check the readonly flag has been cleared.
2. Create the raw disk in the Virtualbox Host - Ubuntu-Local
1. Open up a command prompt.
2. cd C:\Program Files\Oracle\VirtualBox
3. VBoxManage internalcommands createrawvmdk -filename "G:\Ubuntu.vmdk" -rawdisk "\\.\PhysicalDrive0"
4. VBoxManage storageattach "Ubuntu-Local" --storagectl "IDE" --port 0 --device 0 --type hdd --medium G:\Ubuntu.vmdk
   (Noted: You are able to create this by VirtualBox GUI, but be sure to run as an administrator when launching VirtualBox GUI)
3.  Run VirtualBox as an administrator