HowtoForge provides user-friendly Linux tutorials.

• Creating .deb-Packages With Checkinstall

  Author: Falko Timme • Tags: linux, debian, ubuntu • Comments: 3

  Creating .deb-Packages With Checkinstall Checkinstall is a nice tool to create simple .deb-packages that you can use in your local network (e.g. if you have to install the same piece of software on multiple computers running Debian). It lets you compile and install software from the sources like before, but with the difference that you end up with a simple Debian package which also means that you can easily uninstall the software you just compiled by running dpkg -r!

  read more... | view as pdf

• Converting .rpm Packages To Debian/Ubuntu .deb Format With Alien

  Author: Falko Timme • Tags: debian, ubuntu • Comments: 5

  Converting .rpm Packages To Debian/Ubuntu .deb Format With Alien This article shows how you can convert .rpm packages to .deb packages with a tool called alien so that you can easily install them on Debian and Ubuntu systems. Sometimes this is quite convenient as not all software projects release their software as Debian/Ubuntu packages.

  read more... | view as pdf

• Using and Customizing Templates in OpenOffice.org

  Author: solveig • Tags: other • Comments: 0

  Using and Customizing Templates in OpenOffice.org I believe in using tools. And if the tools are easy to use and free, so much the better. That's why I'm a big proponent of using templates. Templates are one of the best ways to save time, effort, and be sure that your documents are consistent when they need to be.

  read more... | view as pdf

• How To Set Up A DHCP Server For Your LAN

  Author: Falko Timme • Tags: other, debian • Comments: 3

  How To Set Up A DHCP Server For Your LAN This tutorial describes how to set up a DHCP server (ISC-DHCP) for your local network. DHCP is short for "Dynamic Host Configuration Protocol", it's a protocol that handles the assignment of IP addresses, subnet masks, default routers, and other IP parameters to client PCs that don't have a static IP address. Such computers try to find a DHCP server in their local network which in turn assigns them an IP address, gateway, etc. so that they can connect to the internet or other computers from the local network.

  read more... | view as pdf

• How can I get a list of quotas assigned to my users and groups and of the space used by them?

  Author: Falko Timme • Tags: linux • Comments: 0

  repquota -avug shows a list for both users and groups. repquota -au shows a list for users, repquota -ag a list for groups.

  read more... | view as pdf

• How do I create SSL certificates with OpenSSL on the command line?

  Author: Falko Timme • Tags: apache • Comments: 0

  You do it like this: openssl genrsa -des3 -passout pass:yourpassword -out /path/to/your/key_file 1024 openssl req -new -passin pass:yourpassword -passout pass:yourpassword -key /path/to/your/key_file -out /path/to/your/csr_file -days 365 openssl req -x509 -passin pass:yourpassword -passout pass:yourpassword -key /path/to/your/key_file -in /path/to/your/csr_file -out /path/to/your/crt_file -days 365 openssl rsa -passin pass:yourpassword -in /path/to/your/key_file -out /path/to/your/key_file2 chmod 400 /path/to/your/key_file2

  read more... | view as pdf

• How do I make an sql dump of a MySQL database on the command line?

  Author: Falko Timme • Tags: mysql • Comments: 2

  If your MySQL user has a password: mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql Please note:  there's no space between -p and the password!If there's no password: mysqldump -h localhost -u [MySQL user, e.g. root] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql

  read more... | view as pdf

• How do I make my MySQL server use TCP connections instead of Unix sockets?

  Author: till • Tags: mysql, ispconfig • Comments: 0

  Comment out the option skip-networking in the file my.cnf which typically lies under /etc or /etc/mysql. Then restart your MySQL server: /etc/rc.d/init.d/mysql restart or /etc/init.d/mysql restart With netstat -ta you can check if MySQL is reachable via TCP.

  read more... | view as pdf

• I'd like to disable the use of the exec() function in my PHP. Can this be done?

  Author: Falko Timme • Tags: php • Comments: 0

  Yes, you can disable it in your php.ini. Search for the line disable_functions = and change it: disable_functions = exec Don't forget to restart Apache afterwards.

  read more... | view as pdf

• Making snapshots of the process table shown by the TOP command

  Author: till • Tags: shell • Comments: 0

  To make a snapshot of the current process table, use the following command: top -n 1 -b > /tmp/processtable.txt You can now view the textfile with any text editor, e.g. pico or vi.

  read more... | view as pdf