Mi-san's Blog

And then Finally, since the existence of linux and Ubuntu, i have a solution to the problem of playing games on Ubuntu 9.10
With the power of VirtualBox, It is now possible to play Windows games on a Windows XP SP2 Guest OS. For you who do not want to endlessly fiddle around with Windows Native DLL’s Wine, Here’s what to do.

Step one : Determine what type of Video card you have, and install the appropriate Linux drivers. I have an Ati Radeon Saphire HD 3870, and got mine from the Ati/AMD website. Make sure you have the latest driver available. It’s also possible to activate the proprietary FGLRX driver that ubuntu provides.

Step Two: Install the latest version of VirtualBox, using the directions on this VirtualBox Website

Step Three: Install your Licensed ( or hacked, but i do not encourage that ) copy of windows XP (SP2/SP3). Once VirtualBox is installed, it should be obvious how to do that, Otherwise google-dork an How To or something.

Step four: Assuming you have installed Windows XP correctly, Configure the Guest OS to make use of 3D acceleration. You can find this in the settings of your Guest OS.

Step Five: Fire up the Windows guest OS IN SAFE MODE , find one of your Windows games, and look for the DirectX9.0c installation. You will be asked to extract the files, just exstract them to C:\dx9\ or something. Once extracted, run the setup.

Step six: After a successful installation of DirectX9, Install the VirtualBox Guest additions. There is a link somewhere in the frame of the VirtualBox program that allows you to mount an .ISO file, that Windows picks up as a regular CD-ROM. Remeber, this should also be done in SAFE MODE ( you know, press F5 right after the SUN bios screen just as you were to press right after your machines BIOS).

Step Seven: Install some 3D game to test it out. I have tested it with Freelancer, and a couple of mods. Works like a charm.

Additional info,
If you manage to install a Game, and you are experiencing a RIDICULOUS FAST MOUSE CURSOR ( i had ), make sure you disable the Mouse intergration in the menu of the VirtualBox program on the Host OS.

Happy gaming

Save the planet ? we do not even know how to take care of ourselves; we have not learned how to take care for one another. We are going to save the planet ?!
There is nothing wrong with the planet…

The planet is fine, The people are Fucked!

Compared with the people, the planet is doing great, It has been here over four billion years.. the planet is not going anywhere, we are!

We trun to dust!

Ok, There where some problems while running the script for a value with 7 characters in it. A little while ago, i was indexing the table with an ID field, which had the type INT that is 32 Bits. Read the previous post for more information about that. Finally the script is completing the 7th length table, but this will take some more day’s to complete. Some stats : 3,204,000,118 records @ 27.5 Million INSERT’s per hour. MySQL data file is @ 174 GB.

Plans have been written out for an application that enables an individual to perform a lookup on my tables, to find the corresponding value by submitting an MD5 Hash. Also there will be a lot of checking the database for it’s accuracy, and consistency. Another thing i like to add is another database that saves the results from lookups that have been made on my tables, a sort of caching if you will. This way, the database will not be overloaded by query’s that have run before. What i also should mention is that i include the possibility of submitting your own value, that will be hashed and stored into the database off course.

Nick ( the kind geek he is ) arranged a VPS for me, and that VPS will be running this application i write about just now. I have limited storage capacity there, so i will not be able to host everything i’ve got on this project. In total when writing this post the current database size is already 174 GB, and the VPS has 10 GB. Therefore i will be hosting lower and upper case with a length from 1 char to 5 chars plus the additional caching database and Manual generated hash database.

So, this project was not a dud, i’m still working on it, and my computer is still crunching the value’s and hashes as i write this post. Keep coming back for more details and links to the new application that is being build the next couple of day’s. Trust your technolust, release you inner geek, and look forward to the day that your Coffee machine has networking capability’s, for me, i am going to bed.

Thanks to a good friend of my ( Nick! ), i have come to realize why in the hell my script stopped working while adding the 2147483647′th record. I gave every record an specific ID with auto-increment as primary key, which indeed is ridicules, because the value is always unique. Because i gave this ID field the type INT, ( which is 32 bits ) only stores numbers Smaller then 2147483647. And i am screwd because i have a 32 bit system inside this VM, so a 64Bit (BigInt) will also not do the job…

I should have listed to Nick, he Specificly told me not to use auto-increment ID’s on this. Thank you Nick ! Kudo’s ! ( if you are reading this. )

All that is left for me to do is remove the ID field, and set Value to primary key, and index every table.

After 15 hours of crunching, the script has started to compute the table for string with the length of 7, lower case. The total records is 557,577,787, and the size of the database is 31.1 GB. It will cost another estimated 4 or 5 day’s for this to complete. The script for the upper-case strings is standing by. Below a screenshot of phpmyadmin, with the totals, click it twice to get the full size.

The MySQL MD5R database

Today i have decided to start a Rainbow table project. It’s for the MD5 hash algorithm. What this does is it creates strings, with corresponding hashes. The first table set consists of all lower-case characters, from strings with a length of 1 character , to strings with a length of 8 characters.

The tables are stored in a MySQL database, that i have installed on a Virtual machine. This Virtual machine runs Debian 4.0 Etch, with MySQL server 5.0, PHP 5, and Apache 2. The script that generates the strings and hashes is written and PHP. This may not be the fastest approach, but it gets the job done pretty well. I can imagine that the same script in C with some other Database technique will get the job done faster, but currently the language C is not a language i understand that well.

I probably need some new hard drives as well. The table that will have the strings with the length of 6 stored within them, is estimated to grow to a size of 15 Gigabytes. I have no idea what the size will be for the table that is going to house the strings with the length of 7 an 8, but my best estimate is that when this script is done ( in a few day’s ) the database will be around 200 Gigabytes in size ( which is quite ridicules to be honnest ).

When i have the hard drives, i am afraid i have to set up more VM’s to house more MySQL databases each with they’re own mounted 1 TB disk. This is because i am planning on doing the same for The upper-case characters with a string length of 1 to 8 ( which will have the same amount of records and Gigabytes ). The mixed-cases is also going to happen, the numerical , the special characters etc etc.

This project will take an incredible amount of time, and Hard drive space when it is completed, probably years. If this project really is going to escalate, the estimated total database size will be somewhere around the 14 to 20 TB (!!) which is just mind boggling.

But, what can one do with such incredible amount of data? well crack MD5 hashes off course.
You just send me your MD5 hash, and i will run it trough the database to see what string matches. I say strings, because that is what will be hashed. There are still a lot of people around that store passwords encrypted with the MD5 algorithm which is really unsafe. And this project will once again be the proof of that.

Source code and related information will be posted soon on the forums. if you have any questions, comments, or if you think that my script can be better, Visit my forums and look for the MD5R in programming -> PHP scripting.

I will update on this every now and then, until next time.

Yesterday i’ve uploaded the framework of my new main website. As you probably already noticed. It has been a few hours of programming and messing around with some perameters, but finally a start has been made. The MP3 player works, the page handling works, and the style is definitive. You may not see it, but it also sets up a database connection, this is where alot of content will be stored in.

Upcoming is a kind of wordpress hack, but not completely. i am planning to read out the table inside the wordpress database, to view the three latest BlogPosts on my Home page, on the main site. This way the weblog will be linked to the main site in another way, other than just a hardlink.
It will be just the Subject of the blogpost that appears on the main site, if you want to read the full text of it, you should click the topic so that it will lead you to this blog. Maybe i will do this aswell with my forum, it would be neat. *he drinks some more coffee, and puts his cup down.*

As a little advice, if there are readers out there that want to leave a comment to some of my posts, be sure to Register first, the link for that can be found somwhere right, in the middle, under the test “Meta”, there should be a link called “Register”. Please do that in order to place comments, this way spam is greatly reduced. Also please note that your comment does not appear right away, I personally have to approve the comment first before it appears. Be patient, and don’t go mad with posting the same thing over and over again untill it appears. Thank you.

For all the people out there that were a member on one of my previous Forum systems, please register again. Also all the data of the previous boards are gone. From the start, the forum may look big and huge.. but really, find something of your interest and start posting experiences, questions, or comments, or really anything what’s on your mind. This forum is for information sharing, for a great deal it’s information about computers. I am finally happy with the whole domain setup, so there will no longer be any risk of losing all the data that has been posted. This one will Stick around for a long time, from now on. If you have any problems registring on my forum, please feel free to send me an E-mail to “administrator@mi-san.net” probably i will create one for you, if you are somehow not able to register.

As i was saying, the board is coming back to life, and there already is some content to read, and post back on. Check out the forum here , and sign in if you like. Hope to see you soon!

Currently i have completely reconfigured everything on my domain. Computer forum is up again, and users are registering again.
Also the gallery application is working, and there are some nice pictures there to look at. Take a look at My main page .

The main page is still under construction, but it has some links to various other stuff on this domain. Keep coming back here for more updates. For now, have a nice day and all.