Wordpress with IIS

I have noticed a strange thing of Wordpress: after pressing the Publish button, it takes me about 20 to 30 seconds to view the article. During the 20 seconds or more, no matter I cilck links or refesh pages, the server do not makes and feedbacks.

I then login the server and want to find where the problem is. By viewing the CPU graph, when the user make a save or publish operation, the server will be busy for over 15 seconds at least. But other sites on this server do not have the same question.

I think maybe the WordPress system is not very compatible with IIS server. For the Windows server platform, ASP (or ASP.NET) with access(or MSSQL) will be the better solution. Of course we all know the best choice for php+mysql site is linux or freebsd, but there is still many application I must put them running under windows, like tencent RTX. So I installed AppServ, the integration software of apache, mysql, php and phpmyadmin. Then I moved the WordPress site from IIS to apache.

Now what is the result? emoticon Everything can not be better.

——
·本文由 iamcj 原创，采用

“CC创作共用”方式共享

2月 15, 2006 | Filed Under WordPress | Leave a Comment

Add authentication to phpMyAdmin

phpMyAdmin is a very useful tool for www access to your MySQL database.

We know that MySQL is the great free database system and was developed under linux first. It comes with only command prompt interface. Of course for those who is familar with it this does not gives any trouble. But for a newbie like me emoticon , it was so difficult to remember these keystrikes.

Thanks to the phpMyAdmin. With it we can do nearly everything by browser like IE or FF.

But normally,to use phpMyAdmin we need to modify the config.inc.php and write your user name and password into it, otherwise you will get an error message which tells you "#1045 - Access denied for user ‘ODBC’@'localhost’ (using password: NO)". It is the normal way, but sometimes we want to enter the appropriate information when using phpMyAdmin.

So here is the right way, very easy:

Open the config.inc.php with a editor. I suggest to use EmEditor. Of course you can use and editor, like UltraEdit or Edit Plus, even notepad
Search the keyword "auth_type" and change its value from ‘config’ to ‘http’. This step enables you to enter username and password by browser.
Save the config file and refresh your browser.

Now you can see the pop up window like this?

Note you can delete the content of user and password in config.inc.php for secure reason, if you use the http method.

——
·本文由 iamcj 原创，采用

“CC创作共用”方式共享

2月 7, 2006 | Filed Under Computer | Leave a Comment

NS2 successfully installed

NS2 is a famous network simulation software. The great point of it is open source which means anyone can use and imporve it for free.

But the installation of NS2 under windows platform is somewhat troublesome, especially for the newbies like me. The true reason is it is developed under linux and there is something we have to do first to run it successfully under windows.

The guide tells three ways:

Install linux then NS2, you need only one ./install command and wait, normally everything will be OK. But I have no otiose PC now, So…
Install VC++ 6.0 then compile the NS2 source with it, one by one. You know there is several components of NS2: tcl, tclcl, tk, otcl and ns itself. In every step I have to edit the config file and compile them then pray nothing wrong. I am luck because unitl the last step I meet no errors…
Install cygwin then run install of NS2 under it. Although it took me more than 30 minutes to setup cygwin successfully ( the website of cygwin give the small setup file and then everything you need will be downloaded during the installation process ), I still think this way is the best one.

Some notice:

If you do not know which part of cygwin will be used by NS2, choose them all. By the other word, click and change the status of all components from "default" to "install".
If you want to specify the exact part of cygwin, there is the list of them. They MUST be included in order to install NS2: