This write-up makes the following assumptions:

• Working copy of FreeBSD 6.2.
• Build: 6.2-RELEASE.

Which should work on 6.2-STABLE and 7.0 as well.

Please let me know if you run into typos or other technical issues when implementing this.

1. Download the latest binaries from mysql.com.

At write-up time this was:

mysql-5.0.45-freebsd6.0-i386.tar.gz
mysql-standard-4.1.22-unknown-freebsd6.0-i386.tar.gz
2. Install MySQL 4.

Uncompress the binary source.

# cd /usr/local
# gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
# ln -s full-path-to-mysql-VERSION-OS mysql4

Create the daemon user and group.

# pw groupadd mysql4
# pw useradd -n mysql4 -c "" -g mysql4 -d /nonexistent -s /usr/sbin/nologin

Set the file permissions.

# cd /usr/local/mysql4
# chown -R root:mysql4 .

Run the setup database setup script.

# scripts/mysql_install_db --user=mysql4

Copy the startup script to the proper location.

# cp /usr/local/mysql4/support-files/mysql.server /usr/local/etc/rc.d/mysql4.server.sh

Change two variables in the start script.

# pico /usr/local/etc/rc.d/mysql4.server.sh

Change “basedir=” to “basedir=/usr/local/mysql4″
Change “datadir=/usr/local/mysql/data” to “datadir=/usr/local/mysql4/data”
Change “pid_file=” to “pid_file=/var/run/mysql4/mysql4.pid”

Create configuration files.

Copy one of the sample configuration files based on your server usage replacing xxxx in the line below.

# cp /usr/local/mysql4/support-files/my-xxxx.cnf /usr/local/mysql4/data/my.cnf

Change variables in the configuration file.

# pico /usr/local/mysql4/data/my.cnf

Add a variable at the top of the [mysqld] section - “user = mysql5″
Change the “port = 3306″ variables to “port = 3304″
Change the “socket = /tmp/mysql.sock” variables to “socket = /tmp/mysql4.sock”

Create a run directory for the MySQL 4 process and set permissions on it.

# mkdir /var/run/mysql4
# chown -R mysql4:mysql4 /var/run/mysql4
3. Install MySQL 5.

Uncompress the binary source.

# cd /usr/local
# gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
# ln -s full-path-to-mysql-VERSION-OS mysql5

Create the daemon user and group.

# pw groupadd mysql5
# pw useradd -n mysql5 -c "" -g mysql5 -d /nonexistent -s /usr/sbin/nologin

Set the file permissions.

# cd /usr/local/mysql5
# chown -R root:mysql5 .

Run the setup database setup script.

# scripts/mysql_install_db --user=mysql5

Copy the startup script to the proper location.

# cp /usr/local/mysql5/support-files/mysql.server /usr/local/etc/rc.d/mysql5.server.sh

Change a few variables in the start script.

# pico /usr/local/etc/rc.d/mysql5.server.sh

Change “basedir=” to “basedir=/usr/local/mysql5″
Change “datadir=” to “datadir=/usr/local/mysql5/data”
Change “pid_file=” to “pid_file=/var/run/mysql5/mysql5.pid”
Change “server_pid_file=” to “server_pid_file=/var/run/mysql5/mysql5.pid”
Change “user=mysql” to “user=mysql5″

Create configuration files.

Copy one of the sample configuration files based on your server usage replacing xxxx in the line below.

# cp /usr/local/mysql5/support-files/my-xxxx.cnf /usr/local/mysql5/my.cnf

Change variables in the configuration file.

# pico /usr/local/mysql5/my.cnf

Add a variable at the top of the [mysqld] section - “user = mysql5″
Change the “port = 3306″ variables to “port = 3305″
Change the “socket = /tmp/mysql.sock” variables to “socket = /tmp/mysql5.sock”

Create a run directory for the MySQL 5 process and set permissions on it.

# mkdir /var/run/mysql5
# chown -R mysql5:mysql5 /var/run/mysql5
4. Start the daemons.
# /usr/local/etc/rc.d/mysql4.server.sh start
# /usr/local/etc/rc.d/mysql5.server.sh start
5. Post installation configuration.

MySQL4:

Connect to MySQL

# /usr/local/mysql4/bin/mysql -u root -P3304 -S/tmp/mysql4.sock

Remove the anonymous account.

mysql> DELET FROM mysql.user WHERE Host='localhost' AND User='';

Set the root password

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('difficultpassword1');
mysql> SET PASSWORD FOR 'root'@'server.domain.com' = PASSWORD('difficultpassword1');

Create a backupoperator account for backup script access to all databases.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'backupoperator'@'localhost' IDENTIFIED BY 'difficultpassword2';

Apply changes.

mysql> FLUSH PRIVILEGES;

Quit.

mysql> QUIT;

MySQL5:

Connect to MySQL

# /usr/local/mysql5/bin/mysql -u root -P3305 -S/tmp/mysql5.sock

Remove the anonymous account.

mysql> DROP USER '';

Set the root password.

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('difficultpassword1');
mysql> SET PASSWORD FOR 'root'@'server.domain.com' = PASSWORD('difficultpassword1');
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('difficultpassword1');

Create a backupoperator account for backup script access to all databases

mysql> GRANT ALL PRIVILEGES ON *.* TO 'backupoperator'@'localhost' IDENTIFIED BY 'difficultpassword2';

Quit

mysql> QUIT;

That’s it! Create your mysql users and databases and connect your applications.

Notes:

1. Command line connections to mysql now require additional connection info to specify port and socket:
   MySQL4 - # /usr/local/mysql4/bin/mysql -u username -ppassword -P3304 -S/tmp/mysql4.sock
MySQL5 - # /usr/local/mysql5/bin/mysql -u username -ppassword -P3305 -S/tmp/mysql5.sock
2. Remote connections to mysql will require specifying the correct port in the connection string instead of assuming port 3306.

If you just memorize the answers without any lab work, simulations or real world experience, you will never be able to really stand behind your certifications.

One of the most important things to remember with Microsoft Certification tests is that you have to think about the answer in terms of how Microsoft would want you to answer using only their products and practices. It is not about how it would really be done in practice with the resources and vendors at your disposal.

We all know that budgets can be tight and the managers won’t always spring for the full solution right out of the gate but with the Microsoft tests you have to set aside the real-world and force yourself to think specific to Microsoft. I find that with the Microsoft tests it is imperative that you study multiple practice exams to get a well rounded feel for the tests. For some of the core exams for the MCSE it is also important that you have many years of real world experience working with Microsoft products, designing networks, designing security and implementing full solutions for clients (especially 070-291). If you just memorize the answers without any lab work, simulations or real world experience you will never be able to really stand behind your certifications.

With that being said, I do have some great tips on how to help you get through the tests once you have the experience and knowledge:

I found the Exam Cram series of books very useful for learning the material for each exam. They have a great writing style to keep you focused on getting through the content. Each book also comes with a pretty good practice engine for sample tests. An online company Pass4Sure.com also had great practice tests that I found very useful as well. My favorite site was Exam Collection. All of the tests on this site have been created with Visual CertExam Suite. Visual CertExam Suite is an exam simulator developed for certification exam preparation. It is a very active site with tests and content being added regularly. Like I stated previously it is a great way to help you study for the exams but will in no way provide the value of hands-on lab based studying and years of work experience.

Test Engine Tips + Memorization Technique

Once you have read the material, done the labs and have studied hard, I have a tip on how to hold more data in your brain when studying for the tests. It is a technique used for memorization.

1. When you are going through the practice exam engine you don’t read the question at all, you just read the answer. Go through the test engine with the answers turned on and just read the correct answer for each one.
2. Do this 3 times completely. This should take you no more than an hour or two depending on how many questions are in the sample question sets.
3. Then you start taking practice exams in question subsets of around 46 – 50 questions. Try to select the answers again without reading the questions.
4. You will repeat this process of taking sample tests until you are consistently scoring 850 or higher. Once you can consistently score 850 or higher (three tests in a row at least) you are ready to take the exam.

If you follow this method you will be assured to pass. This memorization technique is a great way to cram for tests but do note: if you don’t actually know the content or practice these things in the real world your certifications won’t really mean anything. Make sure to read the material, do the labs, practice in real world jobs and understand the content first. Once that is out of the way then use this technique to just obtain your certifications to back what you already do on a daily basis.

Good luck.

I recently attended a Microsoft Certified Systems Engineer Boot Camp, put on by TECHPROS Group, in an attempt to obtain my MCSE. Yet, the certification wasn’t the only goal, I intended to meet all the criteria for the certification - in one week.

Back in August, I hopped on a plane from Portland, OR to Irvine, CA. To start the trip off, the plane had maintenance issues, so as we started to take off - literally as the front of the plane left the ground - the pilot immediately landed the plane. The plane barely stopped in time before its tires rolled off the end of the runway. For the next two hours we were stalled, waiting for the mechanical issues to be resolved.

MCSE credentials are the certifications for professionals who analyze the business requirements and design and implement the infrastructure for business solutions based on the Microsoft Windows Server System.

Because of this travel hurdle, I arrived three hours late to the boot camp. Missing certification orientation and dinner might phase one’s moral, but here at opus:interactive, it takes more than a false start at the beginning of the race to thwart a victory - a lot more.

The boot camp was held at a rented house in the hills outside Irvine, CA. It was a very nice house with plenty of space and rooms for all fifteen of the boot camp attendees (below). TECHPROS had great content setup for us in terms of lectures and labs (below). The first three days we worked through labs with VMware as well as lectures. I finished the first lab Sunday night before turning in around 1AM. The second day I finished the second lab by dinner time and was ready to start studying for the tests. I crammed for 14 hours straight and attempted my first test on Tuesday:

I passed with a perfect score 1000/1000! The rest of the day was spent going through more labs and some simulations TECHPRO had setup to prepare us for the simulations on 70-291. I studied until around 2AM and was ready to take more tests on Wednesday.

I was the only student to attempt three tests in one day and the ones I chose were:

I ended up passing all three that day with a 984/1000 on the XP test! Even with these three tests behind me, I didn’t stop. I continued cramming and working on other labs and lectures for the rest of the day into the wee hours of Thursday, turning in around 3AM.

I wanted to continue the testing insanity and scheduled three more tests for Thursday as follows:

I was again the only student to attempt three tests that passed them all in one day.

The camp was winding down and there was only one more testing opportunity before the flight back to Portland on Friday afternoon. I schedule one final test on Friday morning which would achieve my MCSE +Messaging.

I ended up taking a second test because I had two hours to kill before catching a ride to the airport. I took the following tests:

Both of these test I completed and passed, which brought my total of successfully passed tests to nine in four days! (Phew, what a relief!) I was literally brain dead at this point.

One week later I felt the itch again and decided I should take the last elective for the Security add-on to the MCSE. I quickly scheduled this test:

Another perfect score of 1000/1000! Completing that exam gave me my MCSE +Security.

Why stop there! I thought and continued a study for the new Hosting Specialization Exam:

This test encapsulates what we offer here at opus:interactive and as such: I nailed it with a 987/1000 score! That achieved me the MCTS: Hosting Specialization certification as well.

In recent months we’ve been internally studying the ITIL Foundations and was finally ready to take that exam. This particular exam was administered by EXIN the Examination Institute for Information Science and is the first step in us implementing ITIL for our organization. I studied all the material I could find and ran some practice exam engines. I was finally ready to take the test. I aced that test with a perfect score of 1000/1000! Obtaining my ITIL Foundations Certification.

A lot of testing and a lot of proof of just how excellent our organization and team are. Some might even say: the best in the business.

It’s time to unscrew the bolts of the opus:interactive server cluster and take a look at some of the behind-the-scenes flesh-and-bone bipedal hardware the keeps our data center and managed services running.

If you’ve ever called into our facility late one evening, chances are you’ve spoken to the man we’re highlighting this entry: Orlando, the night-time voice of support serenity.

One theme rings common from our data center to our homes: our collective love of hardware. From Android powered gPhones to human sized Gundam Robots in a brawl with Asimo we like to keep ahead of our peers on what’s new.

Orlando is a different breed, he calmly challenges the cutting edge notion of the newest always being the greatest hardware. He looks back to a cooler piece of hardware: his stock Vespa P200.

Recently Orlando took a week off from the data center and traveled the Pacific coastline with his Scooter Gang and documented his journey for our enjoyment, so please follow his Scooter-worn path to his travel-journal: