March 4, 2009 at 12:38 PM by Geediu Jing

A few days ago an ex-colleague of mine sent me a LinkedIn invite, and I finally went to set up my LinkedIn account... but apparently I already had one back in 2006, and it took me a while to figure out which email address I signed up with (thanks Arthur).

So here we are, my LinkedIn public profile. Please add me if you are also on LinkedIn.

 

Category: General

February 26, 2009 at 13:43 PM by Geediu Jing

Had a developer came to me recently because he forgot the root password for the MySQL instance running on his dev box.

Hmm...

"Let me Google that for you..." I said... (I went back to my desk and sent him that link)

Anyway jokes aside, now I know how it's done. Basically you need to start MySQL in "safe mode" and then set a new password, and then restart MySQL in normal mode:

root@devbox:~# /etc/init.d/mysql stop

root@devbox:~# /usr/bin/mysqld_safe --skip-grant-tables &
[1] 6702
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6763]: started

root@devbox:~# /mysql --user=root mysql
Enter password:

mysql> update uset set Password=PASSWORD('new-password-here') WHERE User='root';
Query OK, 2 rows affected (0.04 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

mysql> exit
Bye

[bring the MySQL server back to foreground using 'fg' and then Ctrl-C to stop it]

root@devbox:~# /etc/init.d/mysql start

 

Reference:

Resetting a forgotten MySQL root password

 

Category: IT

February 19, 2009 at 15:51 PM by Geediu Jing

Hi guys, haven't been on for a while, busy with wedding planning and all, check out my other blog http://www.vivianandjoe.com for more juicy details...

 

Today want to bookmark this good site with free-for-commercial-use fonts: http://www.fontsquirrel.com.  I found this on RedFlagDeals:

 

"For the small business owners, graphic designers, and aspiring graphic designers out there who can never have too many resources for free fonts, Font Squirrel is worth bookmarking. They've got over 300 font families all free, and all with commercial-use licenses. It's sorted by style and they've got nice previews of each font. Commercial fonts can quickly get very expensive so perhaps you can save a few hundred dollars this way."

 

Maybe one day I can stop using Arial... LOL


Category: IT

December 11, 2008 at 16:35 PM by Geediu Jint

Was still trying to figure out how to host the wiki using the virtual appliance provided by the vendor, and because of the way I have my servers set up in the office I've been struggling to figure out a solution... until now.

How I am able to use apache as the front end for all my web sites. Most of the sites are hosted on the main apache box and the wiki site will be running as a VM on another box and using the MOD_PROXY module it does the trick, making apache to act as a reverse proxy.

Example:

 

LoadModule proxy_module /usr/lib/apache2/modules/mod_proxy.so
LoadModule proxy_http_module /usr/lib/apache2/modules/mod_proxy_http.so

NameVirtualHost *
<VirtualHost *>
ServerName www.orange.com
DocumentRoot c:/sites/www/www.orange.com
</VirtualHost>

<VirtualHost *>
ServerName www.banana.com
DocumentRoot c:/sites/www/www.banana.com
</VirtualHost>

<VirtualHost *>
ServerName www.melon.com
ProxyRequests Off
<Proxy *>
Order deny,allow
Allow from all
</Proxy>
ProxyPass / http://10.1.1.102/
ProxyPassReverse / http://10.1.1.102/
</VirtualHost>

 

 

Category: IT

December 10, 2008 at 14:41 PM by Geediu Jing

Heard this song played live on Jay Leno last night... then I went to search for it online and found this MTV on YouTube which I enjoyed immensely. I hope you do too.

Sara Bareilles & Ingrid Michaelson - Winter Song

edit: I was told that some of you in Asia couldn't play the YouTube clip. Here's another link:

 

Category: General

December 6, 2008 at 1:08 AM by Geediu Jing

At work a little over a year ago I had to set up our intranet and a wiki for the developers to write their documentation and procedures. I chose to use Microsoft SharePoint Technologies that came with Windows because it was free and also there wasn't a lot of other choices out there at the time. It had a wiki "plug-in" that allowed me to create wiki-style sites and the developers were quickly on their way to write a ton of wiki pages.

Recently I've been tasked to find a good wiki tool and set up a support wiki site for our new product. After some poking around I came across a site called WikiMatrix. It has an extensive list of wiki software. Great comparison tool and in fact I thought it was a little too much information and I felt it was difficult to decide. It has a wizard-like tool and after a series of questions the wizard narrows down the list to about a dozen tools for me to choose. At the end I chose one called Dekiwiki. It is commercial software but also has an open-source, "community" edition. The first thing I noticed on the site was a link to a certified virtual appliance image download.

SWEEEEEEEEET.

The documentation is quite simple and straight-forward. Took me no time to set up the virtual appliance image on my ESX host. Powered on the VM and assigned it an IP address and voila: Dekiwiki is set up. Nice GUI interface, decent WYSIWYG editor, and a few minutes later I was able to customize the wiki with our corporate logo (with some tweaking) and a nice theme with color schemes that matches our corporate colors.

Gonna try to set one up for Digispec soon, load up all my tips and tricks and also troubleshooting procedures for my clients so I don't need to carry notes everywhere I go and I could access my knowledgebase at my clients' sites if Internet connection is available. Next step up: hire guys to take care of jobs for me, and they'd just need to log on to the wiki and search for solutions to fix problems.

Category: IT

October 15, 2008 at 1:07 AM by Geediu Jing

I suppose I am okay with the election results tonight.  I kinda knew that the Tories wouldn't get the majority they wanted but I am certainly (plesantly) surprised that the PQ did better than the NDP and that the Green Party didn't get any seats (not even Ms. May herself). I consider myself a green-ish person and I support efforts and causes for becoming more green, but seriously, I thought Ms May was an embarassment to herself and the party she represents on the English party leader debate.

I have to agree with people who think that the Conservatives screwed up, but only because they wasted our time and taxpayer's money running this election. I thought they were doing a decent job and they didn't have to pull this crazy stunt to try and get a majority government.

On one hand I thought the Green Shift is the way (I do see some flaws though), but on the other hand I don't think the public are ready for this change... I feel kinda bad for the Grits but hey thanks for trying. Now we know how Canadians feel about change; we are not ready for change. I also hope Dion is sincere about what he said tonight, about trying to work with the new minority government and work together to ride out the current economic wave.

I still think that my plan to solve the homeless problem and energy crisis and at the same time increasing government revenue would work. I will outline my plan some other time.

On Jay Leno's show tonight he said "Dubya" was a genius in that he fouled up the economy so bad that people spent less on fuels and thus helped countering Global Warming. Joking aside I thought there might be some truth to it... which is sad. I am happy to see gas prices back to $1.2/L level and I hope it doesn't creep back up.

Hey! RIM shot up 10% today, will we see $100 by Christmas? Pleeeeeeeeease???

Category: General

October 11, 2008 at 1:05 AM by Geediu Jing

I've been using Chrome for over a month now and I absolutely love the speed. I had both IE 7 and FireFox 3 although I have to admit I still use IE 7 almost all the time, because I have to work with a lot of sites powered by Microsoft technologies, and sites like hotmail and Outlook Web Client portals.

But after a couple of weeks of using Chrome I have set it to become my default browser.  Whenever I needed to use hotmail I just fire up IE again. But launching hotmail in IE would take forever to load, so I have since given up the enhanced interface and I am now using the classic hotmail interface with Chrome.

I also notice that Chrome sometimes doesn't work well with a few facebook apps I have installed, but generally works fine everywhere else on facebook.

Some sites with Java or Flash are still problematic but that's when I would use IE or FireFox instead.

I wish Chrome has a plug-in like FireFox where I could right click on any problematic site and have a "Open in IE" or "Open in FireFox" option.

Category: IT

July 21, 2008 at 23:03 PM by Geediu Jing

At work we have our intranet site set up using Windows Sharepoint Services 3 and on the site we have a wiki set up for the developers to submit their dev documents and procedures.

In the morning (around 10am) a developer came to me and told me our intranet site is down. We had some maintenance work done in the weekend; I tested everything after the maintenance work was done and they were okay, including the intranet site.  Took me a while to figure it out but it looks like the WSS database is broken.

Great - MSDE (Windows Internal Database) is broken. No worries, I thought to myself, because I had a vbscript that runs nightly to backup the whole WSS site. Well, it doesn't work. (Well it worked when I first set it up - I tried the vbscript and the .bak file gets created, and restoring the .bak file worked) Of course, all the bad shit happens on Monday.

I kept grinding this shit and attacked this problem from many front: reparing the WSS installation (failed) restoring the .bak file to my SQL2K5 server on another box (failed) reinstalling SQL2K5 right on the intranet server to try and upgrade the Windows Internal Databae (failed mierably). My last resort was to remove WSS and the MSDE installation and do a reinstall, but I know that by doing so I would lost whatever I got (I really believe all my data is still safe but just the database is somehow corrupt) anyway by 4pm I said "f*ck it" and crossed my fingers and removed those two evil-ass programs and reinstall. Yes I made a copy of the MSDE folder (somewhere in C:\WINDOWS\SYSIME or some shit - update the actual path later) and went to appwiz.cpl and "pull the plug".

After the clean installation of WSS3 (including MSDE) I started the Sharepoint Products and Technologies Wizard. At the end of the wizard it said it failed LOL - nice - I am dead, I thought. What am I going to tell my boss and my developers: "Hey guess what our wiki is now blank and everyone gotta re-write all their docs and procedures have a nice day weeeeeeeee". After swearing at the screen for a few minutes (I don't know why I did that - it's clearly not the screen's fault - nor it is the VM's fault - yes I run my intranet site on a VM) We know whose fault it is - FRIGGIN' MICROSOFT for giving us such a piece of crap software. I fixed the error the wizard complained about (I forgot to clean up the inetpub\wwwroot folder as it still had the stuff from the old installation. I renamed the old folder and tried the wizard again - it completed successfully. Now I have a blank intranet site and a blank wiki page. The decision now is: do I still use this crap for our intranet/wiki site? Or should I use another software?

Google is my best friend - the search for new wiki begins. Right off the bat I started looking for modules for CMS Made Simple since I already know CMSMS inside out. No luck. I asked my friend who is Joomla expert and she told me Joomla does have an extension for setting up wiki. I then looked at mediawiki, which is pretty much what everyone out there uses for their wiki sites, internal or external. I am too lazy to g through the installation and configuration guide (NB - if the software has BOTH an installation guide AND a configuration guide - it's too much work). I went on to look at other products and....

..... HEY WHAT DA FUC.....

A bulb just lit up on top of my head!

I haven't tried attaching the MDF/LDF pair from the crapped out MSDE instance to my SQL box! Guess what - after 5 minutes I have the database running on my dev box LOL... I blame it on the two cups of instant "Vietnamese" coffee I took after lunch... anyway the database is now at least in a browseable state. I went through the tables and the conclusion is that all my data are stored in one giant table (add the table name later). Went through the data browser and I found all my wiki documents are in one single column, all formatted in HTML!  JACKPOT!!!!!!!!!

After some trial and error, I figured out how to extract all the documents I need. I logged back on the WSS site and set up the proper permission for everyone in the office and set up a blank wiki site. I created the placeholders for the various documents and I went in the SQL query editor and extract the document in HTML format. Copied that cell from the result set and pasted it in notepad window. Saved it in HTML and used IE to view. Voila - the document intact. Copied it in the IE window and pasted it back to the Wiki page in Edit mode. Saved it and waaaaaaaaaaaaam - one wiki page recreated. Now about 80 left to go. I did a few more for the section for our new project (ecpro) and I called it a day. I will slowly finish the rest for the rest of the week.

Happy Monday everyone LOL

Category: IT

July 21, 2008 at 22:38 PM by Geediu Jing

This evening when I logged on to facebook on my home laptop I noticed across the top a new bar and a link that says try the new facebook. Once I clicked on it I got the following message:

--------

You are using an incompatible web browser.

We detect that you're using an old version Internet Explorer that doesn't work very well with Facebook.

To get the most out of Facebook, please upgrade or download one of the following browsers:

Note: The beta site is currently disabled in IE6 because it's all messed up and broken. Don't worry, we'll have it working IE6 soon.

--------

On that page, I noticed the link "Back to the Old Facebook", when I clicked on it, it gave me this error:

--------

Oops
Something went wrong. We're working on getting this fixed as soon as we can. You may be able to try again.

--------

I am running Vista and IE7, but I guess somehow it thinks I am still running IE6. I tried to go back to www.facebook.com but it automatically redirects me to the new page :(

I tried to delete the cookie but that didn't help so I figured the flag is probably on the server side. I fired up Firefox (2) and logged in to facebook. Thew new design looks alright, but I find there's nothing wrong with the old one. I clicked on the "Back to the Old Facebook" link at the upper right, and it takes me back to the old familiar layout. I then switched back to IE7 and I got my old layout back!

Category: IT