Simple, stable and low-cost IT setup for small businesses

By | AGIX Discussion, All Linux HowTo's, Windows HowTo's | No Comments

I update this article periodically to keep it current. The principles never change though. 

Do things the right way.

When you (as the IT manager or contractor) hear frases like “it should be easier” or “but why can’t it just be like…” you know staff are not using the computer network in the intended way. They’re using email as a CRM or their desktop as their filing system. For example, if the businesses needs a CRM then get one and stop using email for contact management. To continue the example, staff will start to ask how they can share their contacts, calendar appointments and resource bookings. It’s a slippery slope and one you want to avoid at all costs.

read more

Stop DDoS attack using IPTables

By | All Linux HowTo's, Security HowTo's | No Comments

A distributed denial of service attack (or DDoS) will either bring your server down or significantly degrade its performance. This article explains a quick way to tackle the problem.

The IPTables firewall rules that follow ensure packets are limited to a set number per period of time. This rule will ensure only 10 new requests can hit the server in a 20 second period. It won’t stop the attack but it will keep your server up.

read more

Configure NTP Client Gentoo

By | All Linux HowTo's | No Comments

Just a quick reference for setting up your Gentoo server to get its time from an NTP server either local or on the Internet.

Get NTP onto the machine

emerge --ask -jv ntp

Edit the NTP config

vi /etc/ntp.conf

Comment out the servers that you do not need and add your own, the address I have added below is a pool of servers so we only need to set one entry you could do this internally by creating a DNS round robin type situation or just specify three seperate entries.

read more

Create a self-signed Apache/HTTPS certificate on CentOS

By | All Linux HowTo's, Security HowTo's | No Comments

Create the key and set a passphrase:

openssl genrsa -des3 -out server.key 2048

Create the csr file making sure the CN (common name) matches whatever domain name it represents such as “www.agix.local”. This requires the passphrase from the step above:

openssl req -new -key server.key -out server.csr

Remove the passphrase:

openssl rsa -in server.key -out server.key.nopass

Generate the self-signed certificate:

read more

Import data into AWS’s MySQL – clean it first

By | All Linux HowTo's | No Comments

You’ve dumped a DB from MySQL and didn’t use the “–no-triggers” option. Now you’re trying to import your data into RDS MySQL which complains that:

ERROR 1227 (42000) at line xxx: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

You can solve this by editing the dump file with ‘sed’ and then importing into RDS’s MySQL from your newly modified dump file.

sed -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' dumpfile.sql > dumpfile_no_tags.sql

Source: http://xplus3.net/2013/10/10/remove-definer-clause-mysqldump/

read more

Contact AGIX Support

Level 2, 170 Greenhill Road
Parkside 5063 South Australia
Phone: (08) 7324 4429
or 0422 927 598
support@agix.com.au