IT Knowledge Base

du -h –max-depth=1 | sort -n -r

SELECT DATE_FORMAT(now(), ‘%d-%m-%y %H:%i:%s’);

I had some computer errors today so the first thing I usually do if I don’t know the error is jump on google and search for it. So I found a couple forums about that matter. Suprisingly I noticed that there were a couple of forums overlapping with exactly the same question + answers. Second thing I noticed is a lot of ads.
So if you put this two things together you will figure it out that somebody tries to make money out of it and it works like this. You design special for search engine optimized webpages and you steal content from other webpages, you get a content changing money making machine.

I just had to do a project in php and I used pear for the form validation and email authentication. I need to say that I had some difficulty to start with but these pages helped me a lot.

Forum:
www.pear-forum.org

Tutorials:
www.midnighthax.com/quickform.php
pear.php.net

I just moved from Europe to Australia and there you actually get a fast Internet Connection but with bandwidth limitation. So you get a bandwidth volume for peak and off peak time. Of course the one one for the off peak time is much bigger. So at the begin I didn’t care much about it and I was downloading as usual. Soon I had used my volume for the peak time and I could surf just with ISDN speed during the day. So I needed scheduled downloading but I missed that feature in Azureus and aMule. So what’s the solution to that dilemma?

We know MAC OS is based on Unix and there is service called crontab which does the trick. It is running in the background and is used to run commands in a specified interval. What I basically do is open and close the download program in a specific time.

1. Open Terminal
2. “crontab -e”
3. Modifie and put the commands below:

4. To save the file press “:” (run commands) and then press “qw” (quit and write)

Explanation:
2:05am Open aMule
2:05am Open Azureus
11:55am Close aMule
11:55am Close Azureus

Of course the interval time and paths needs to be adjusted. Do a google search if you want to know more about crontab.

You need to access your computer at home or company. Or do you need to fix you relatives computer but you are to lazy to get up from you chair and visit them. So you need a remote control software. You could use vnc or remote desktop etc. But usually they are behind a firewall and it needs first a lot of configuration. And not everybody knows how to make a ssh tunnel through port 80 to bypass the firewall. Anyway if you looking for a pretty good and fast solution that most of the time works have a look here:

www.logmein.com

It is by the way free to use, but there are a couple of limitations. One important feature which is missing in the free version is that you can’t share files. Still this service is great and helped me already a couple of times.

Google Map API is very powerful and can be integrated into your webpage. As long as everybody can access the maps in your webpage for free you don’t have to pay for the service. Even it is used commercially. I just start to learn the API and found a very helpful online tutorial. Especially don’t forget to check out the webpage.

http://doug.ricket.com/gdd2007/

I tried to login to my SQL Server with a new user I created and got following error:
Login failed for user ‘root’. The user is not associated with a trusted SQL Server connection.

You need to activate MS Sql Authentication and Windows Authentication Mode:
1. Open MS SQL Server Manegement Studio
2. Right click on the server
3. Properties
4. Security
5. Change from Windows Authentication Mode to SQL Server and Windows Authentication mode

I tried to remove the check_policy and check_expiration from a user and got following error in MS SQL Server:

I forgot to remove the must change password flag when I created the user. A simple SQL query to change the users password solved the problem:

ALTER LOGIN %USERNAME% WITH PASSWORD='%PASSWORD%'

									

I don’t have a lot of experience in Linux environment but anyway I got the job to install a new webserver at my work. The old server was running on debian already so I decided to take the same linux distribution.

The newest ISO you get from here from here:
www.debian.org

For my installation I just needed the CD1. Because I wanted to try it out first I decided to install debian on VMWare Server. So I booted the ISO file in VMWare and did the standard installation without the GUI. We don’t really need a GUI (Graphic User Interface) for a web server. The installation is actually straight forward.

So now we are logged in as root and are in the command line. So what now???

Follow the instructions on this webpage:
www.mysql-apache-php.com

I actually got some error when I tried to install apache and php with apt-get. To add some more sources to the apt source.list file solved the problem.

To edit the source do following:

You might want to use your own source list. This one worked for me: