By default MySQL keeps a log of all transactions, if you don’t limit this in “my.cnf” it will keep growing and keep creating “mysql-bin.XXXXX” files. To delete these files and potentially free up lots of disk space do the following: If you are using DirectAdmin first find out the admin user account for MySQL: cat /usr/local/directadmin/conf/mysql.conf […]
You are browsing archives for
Categorie: Webhosting
Set the correct FROM and REPLY-TO addres...
When using a default install of Magento (>=1.9) on DirectAdmin the emails send by Magento can appear to come from [email protected] or from [email protected]. These addresses can appear in the “From”, “Reply-To” or “Return-Path”. Some email clients show this as [email protected] on behalf off [email protected] There is a simple fix for both these issues. Mail from [email protected] For […]
Setup a cron-job for Magento on DirectAd...
When using Magento it is important to setup a cron job to run all kinds of maintenance and since version 1.9.1 it is also needed to send some transactional emails. With a cron job the following jobs are performed: Catalog price rules Newsletters Generating Google sitemaps Customer Alerts/Notifications (product price change, product back in stock) […]
How to add an SSL certificate to DirectA...
If you have a server with DirectAdmin and would like to secure individual user websites with SSL, here is how to do it! Make sure the user has it’s own IP. In DirectAdmin as user go to “Advanced Features” and click “SSL Certificates”. Select “Create A Certificate Request” and fill out all fields. Press save […]
Changing default order/invoice/credit nu...
When setting up a new shop in Magento the default order number, invoice number, packing number and credit note number is always 100000001. Most people want to change this to some other number so it doesn’t look like they just started out with their website. Unfortunately it is not possible to change this from the […]
Creating SWAP space on new TransIP Blade...
Adding swap space First switch to root and enter your password: su Then check that there is no swap space: swapon -s If nothing is returned, there is no swap space in the system. Create the physical file for swap space: dd if=/dev/zero of=/swapfile bs=1024 count=512k This will create a 512MB file called “swapfile” in the root of […]
Installation of CSF on CentOS with Direc...
One of the first things to do when installing a new DirectAdmin server should be the installation of CSF (ConfigServer Security & Firewall). According to their own website this is: A Stateful Packet Inspection (SPI) firewall, Login/Intrusion Detection and Security application for Linux servers. You can use this software to configure the firewall on your […]