Sunday, January 10, 2010

System Explorer better than the Windows Task Manager

The task manager in Windows is well and good, but it goes even better. Better is the freeware-tool system, the Explorer is far more than the sandy task manager in the popular operating system.

The System Explorer shows you system information, such as processes, installed drivers, and links to current addons. Next registry and file-snapshot can be created and saved to compare it with previous or future system settings, if needed.

Other alternatives and tools that are far better and more mature, as are the Windows standards, the System Information Tool Process Explorer and the system monitoring tool Process Monitor. Both are comparable to the System Explorer, with the one or Other user-friendly tools for each of the three is.

The System Explorer 2.0.1 runs under all Windows systems, including Microsoft Windows 7.

Saturday, January 9, 2010

Hardware firewalls: A little tip

A little hint: In the near future will be the topic of "firewall increasingly addressed. Especially the "Firewall" is in my estimation will be more noticed soon.

I refer in this context is already down to "Yoggie", which (a variety of hardware solutions for home users) ready to act in any case intererssant. The overview can be found here. Specifically, the USB/PCExpress solution would be for small offices and home users of interest, especially as it normally can log in via SSH and change the system.

On the other hand, as much realism must be, is hardly a standard, users can log in via SSH, much can you configure on a console iptables/ipchains. To that extent, "normal" users in the future from the offeror or an external service, subject to - which is inevitabl

Sort results by chance in MySql

The MySql function rand () can query a random sequence of results in Mysql. If we add to these in his "order by" clause is a chance the results will be sorted. The whole looks like this:

select * from tabellenname order by rand()

It is for larger results note the following: As with any MySql functions will be executed within a query also affects rand () negatively on the performance out. If the result returns only a few lines, it is no problem with safety. At 1,000 or 10,000 records, the query has been delayed by a few 100ths of seconds. That may be at first glance, not much in performance-critical applications, or those that have many simultaneous requests, develops this circumstance, however, a drawback.

In such cases, it offers the chance to insert themselves in to sort table another column. For these will be provided as data type double and set a corresponding index. The insert command must be supplemented in each case:

insert into tabellenname set feld1=’wert1′, feld2=’wert2′, random=rand();

If you sort it directly via the index random field, the query is working much faster. However, it should first be considered whether the sorting of the new field is not ultimately prove to be disadvantageous. That would be the case if the query is used only rarely, and the MySql Server but little memory is available. For then the additional index may unnecessarily block the memory, the other queries need more necessary.

Mysql - recover debian-sys-maint account password

You would need as a Debian user specific start and stop scripts for MySql. These have unfortunately also the implication that Debian also created a separate user with own password: debian-sys-maint. The result of a careless handling of this fact could be that you accidentally overwrite this password, delete the user away, because nothing can do with it.

This will, however, after one "flush priviliges Or restarting the database to the problem.

The next reboot that is running next to it and kills the Debian MySql process. That's a not just at the sight of the console angst, it can have serious consequences. For the commonly used MyISAM table format allgergisch highly responding to a kill command. At least then, you know someone is in the database to write. The table on which was written during the kill command is then in fact be erstmal marked as crashed and should be repaired, which again poses new risks.

It's called security... Since the start and stop being root of the database does not have to. Actually, you should root almost never use it except to create vllt to other users. And since I'm still a question: if you have now overwritten your password and the database is not running anymore, how will you access the database to change the password ... There is still missing the reference vllt then start MySQL manually. Since the start of the script is nothing more.

Restoration of password

The password for the Mysql user debian-sys-maint located in the file /etc/mysql/debian.cnf.

Now only the following is done:

1.log in to the MySql server as root
2.using use mysql switch to the mysql database
3.using update mysql set password = password (Kennword-from-the-configfile) WHERE User = 'debian-sys-maint' password setting
4.flush privileges execute an amendment to incorporate

Alternatively, you can simply reset password in the configuration file. It should be noted that twice in the file. Once a section [client] and once in the section [mysql-upgrade].

Friday, January 8, 2010

My computer does not restart, or shuts down

A few days before I reinstall Windows 2000 need. Before, everything was fine. Until now .... Boot or program using a problem. Only if I want Unignore him or restart, nothing happens. If I want aushaben him, I have to press the button. What's wrong? For, without new start, I can not install my printer correctly.

If this is also in the boot (cold switch on) is probably the switch is broken when you restart the operation from the mean it rather shows that the operating system is running smoothly.

Where can I find drivers for my computer?

I am looking for drivers for my computer (Acer Aspire 5610) for example, for the video card and all this because I will make my new computer. Does anyone of you a few pages, where you get to her? Or where on my computer so I can save and then install? Happy new year and thank you! I really need any driver you need to ... There are quite a lot! How do I know now what I need for my computer? Many thanks to Decker and Paiwan! Unfortunately it must be decided by a coin!

On the home page of the video driver you could find the driver. Unfortunately, you have not told us which driver you need ... Otherwise you ever need to search Google for the software that you want.

To find out what hardware is installed on your Acer, thee I download SiSoft Sandra: The software analyzes your Acer and show you what hardware is installed. Afterwards you just go to the home page or the hardware manufacturer and invite download the appropriate driver. You burn the drivers to a CD, then you have them ready for a new installation.

Which computer game has inspired you the most so far?

What Were you stuck for months or weeks to get through to solve it or something? And what game Iht currently happy? Thanks for your answers.

The GTA and the GTA from GT series at part 3 (because from then 3d) gt and really takes a very very long time to win all the races, if you like online role-playing World of Warcraft has very very long game, offline, eg Morrowind and Oblivion, with online Of course shooters Counter Strike Source. In racing games does The Tony Hawk series quickly endless fun.

The Settlers I've played quite happy, especially the first versions, the graphics were still knuffiger and you had to create the path yourself ... got Railroad Tycoon, long I played. Strange really, the game is not the hit, but it's totally stress-free and it's easier to relax ... Command & Conquer Day of the Tentacle The first game that I really liked Morrowind was "elite". from today is of course completely out of date. Some games also make just the two of really fun, the whole zb Racing. I like very much like Need for Speed. important: it must have oncoming traffic, not even a "pure rennspiel. a lot more fun when you can push each other in other cars ...

Diablo 2 I've played through dozens of times. I habs sooo loved! hm ... actually I still have this afternoon anyway before anything yet. :-)

Metal Gear Solid. The continuations could be kicking in the barrel, but the first was very horny. The first two Monkey Island, Zak McKracken, Final Fantasy I also loved. Larry was of course very forefront. Currently I play Metal Gear Solid 3 (to be even older, but not as much time to play), and burnout.