KNOWLEDGE BASE

23Aug 2013

If you need to connect to an MS Sql Server remotely from your DirectAdmin server via php, you need to rebuild PHP with necessary components. Get the latest stable release of FreeTDS and install it. cd /root wget ftp://ftp.astron.com/pub/freetds/current/freetds-current.tgz tar -xvzf freetds-current.tgz cd freetds-dev.0.92.377 ./configure –prefix=/usr/local/freetds make make install Now we should tell Direct Admin’s […]

21Aug 2013

In our case, we were using postfix via iRedMail and every incoming mail had a delay around 7 minutes. The problem was fixed by disabling the chroot operation in the settings. Edit the file /etc/postfix/master.cf It probably looks like this # ============================================================= # service type private unpriv chroot wakeup maxproc command # (yes) (yes) (yes) […]

21Aug 2013

This can get quite important when your mail server is blacklisted, or if you somehow want to simply change the outgoing IP address. First of all, check that you DO have another ip address on another interface at the server. Either by ifconfig or anything else. To change the outgoing IP on a postfix mail […]

16May 2013

If you struggled to cope with disk I/O on virtual host machines which runs on Centos or RHEL, there is a great system performance tuning tool named TUNED, comes with different profiles. for installing tuned; yum install tuned -y starting the service permanently; service tuned start chkconfig tuned on service ktune start chkconfig ktune on […]

18Jan 2013

Deleting email from the exim queue is unfortunately not that simple. If you have a massive spammer in your system, you can clear the email originating from them with the command below. exim -bpru | tr ‘\n’ + | sed -e “s/++/=/g” | tr -d + | tr = ‘\n’ | grep “spammer@email.com” | awk […]

31Dec 2012

Last time I get into an embedded project I realised that I am getting tired of USART interface errors and I should definetely switch to a better organized tracing system. While sending debug data or any relevant data through network interface you can use an open source  syslog server available through google. I used Syslog […]

21Dec 2012

Opening an sql connection from your game isn’t really safe. So you should write, use a server software or find another solution like the one I wrote this article. Why you should use http protocol instead of server software doing this ? These software might have bugs and if you don’t know any low level […]