The Worst Hosting Company Ever

If you’re deep inside computer related world you have to learn one of the virtues in this world. That’s patience. Your must be keep patience everytime, every day, every hour. Because you need that. In a complex senario everything goes wrong in a second. One second before you’re all right with any kind of job but after a second everything starts to come on you.

Last 4 years i’ve managed, administrated or used hostings or dedicated hostings from many company around the world. If one is from USA the other is from Germany. I tested about more than 7 hosting companies at least.

One month ago we’ve moved our sites to a new company. Infact we do not have any idea about that we’re moving our sites to worst hosting company ever. Before move i’ve checked internet for user comments about leaseweb. Most of the comments are around the support saying that worst support ever you can find. But i did not mind that comments cause success stories are not told most but failures are always spoken.

And i did a mistake!

After one month of working with Leaseweb we’ve encountered a problem. We tried to restart server but could’t. Tried to power-cycle server but we couldn’t.

Then asked leaseweb’s worst suppor ever to examine the problem.

I waited 2 days for them to make them send me a response. They said our harddisk has a problem. Needs to change with another harddisk.

We said O.K. do it.

They done it after 6 days!. For 6 days we’re closed. We could not reach any of sites. We could not reach server through SSH. The hosted firms that we’ve could not reach their emails. So nobody could do their daily works for six days!

The nightmare is not just like simple that i’ve told.

After 6 days they’ve send us an email including SSH, Panel details. But they were fully wrong. Then restarted to send emails. They’ve respond us after 1 day saying sorry for wrong details, here your true details!

Can a harddisk may burn. We can look this process as a simple process cause we’ve learned the one virtue called patience a long time ago.

But nobody can explain that to change a disk, image it, mount old disk in 7 days! That’s all totally one hour process.

But it took 7 days if you’re working with a poor hosting company that has poor customer support. Infact we can say there are no support. There are so many people saying “hey, i inform one my colleague for your process. Keep on” but you never have a chance to find a colleague that solve your problem.

For your information i neve suggest Leaseweb for any of you including my enemies!

The Time to Upgrade LAN to 1 GBit but how ?

Two month ago i bought out a Western Digital My Book World Edition II to save my downloads and keep my archives in a single media to quick access. My version of My Book is created for LAN usage. It has no USB connection directly to PC ( It has a USB port but it’s for data storage ). So you have to transfer files from LAN using your ethernet cable.

The problem starts here.

I’m using a 100Mbit LAN at my home. My switch is a 100Mbit switch. My other two PC’s can 1Gbit but because of my switch i use them in 100Mbit mode. And my laptop… It has 100Mbit connection also.

You can say that why you do not prefer to upgrade your switch and buy out a PCMCIA port for your laptop. I can’t. But this impossibility is not dedicated to my fault. It’s because in my country to follow technology beyond most people can not be! I searched all markets, shops, internet shops but i have no chance on finding a PCMCIA cart for my laptop and a 1Gbit switch.

So what are you doing you say.

I’m trying to reach nirvana while i’m sending 45GB of fresh downloaded DVD’s, Archives, Education Videos (It’s a huge set consisting of so many legal ( and some illegal ) things ) to my storage drive. I hope this patience will be raise my rank on the God’s eyes.

Patience must be first virtue in computer related world i think. If not i’ll be confused of my time which i spent on waiting data transfers using 100Mbit connection!

Alternative PDF Reader For Windows

I don’t know why but my laptop is uncompatible with Adobe PDF Reader. I try to examine the cause, lost lots of many time but cannot found out a solution. My Problem was the adobe updater. Whenever i start Adobe Pdf Reader to view a document adobe updater agent comes front and started to aet all unused CPU time. And also it is a un-endable process.

At last i was tired of this process cycle and tried to search for a fine alternative. I found Foxit PDF Reader. I’m using it for two months now. It’s a very little and rapid program. I cannot see the difference between adobe reader. “A reader is a reader” is the main point of my philosophy.

I can freely suggest you to use that program if you’re tired of adobe updater.

Multiple Subdomains with Plesk and Apache for Drupal and Wordpress Mu

I’m using Wordpress Mu and Drupal in some of my sites.

But when you want to use wordress mu and use drupal as a service for multiple subdomains you need to do some changes on configurations of server. ( In here i must thank to one of my friend )

Here’s how you do it on a plesk powered server :

1. There’s a folder in named conf in the domain you want to configure. The path will be like this : /var/www/vhosts/domain.com/conf. Create a file with a name vhost.conf to there (using pico vhost.conf for ex). Write a line ServerAlias *.domain.com in it. And save it.

2. Open plesk. Go to domain’s DNS settings. Add an A record *.domain.com

After all run this command : /usr/local/psa/admin/sbin/websrvmng -v -a

That’ll help.

Extracting Plesk Backups

Last day i need to extract one of my site’s plesk backup. I tried the “open it with your email client” solution but it can’t help me. (I’m using The Bat! as email client). So i searched and find an effective solution.

There are two same programs to do it. One is ripmime. But in my debian server i’ve mpack tools. So i’ve extract with second way using mpack tools ( Document mirror on focusoncode.com )

It works fine except mySQL unicode problem. I want a world that has no character encoding problems like two or more years ago…

Simple WinRAR Backup Script for mySQL

net stop mysql
rar a -ag+YYYYMMDDHHMMSS- -rr -r -k -s -m0
      C:\BACKUPS\MYSQL-BACKUP.RAR C:\MYSQL\data
net start mysql

Save three lines as something.bat or autoexec.bat and then use it by Cron Jobs. Output file names like this :

20060808120000-MYSQL-BACKUP.RAR
20060808120001-MYSQL-BACKUP.RAR
20060808120002-MYSQL-BACKUP.RAR

( Before this you can update you path configuration. You can add a line at the end of PATH variable like this : C:\Program Files\WinRAR\ etc.)

Exe Packers, Crypters and Compressors

Mostly Delphi you have always chance to manage your executable. You can re-pack it, crypt it ( you know that we can see most of the strings or code strings in an executable compiled with delphi. Remember DeDe ) or compress the executable.

There’re many programs doing this job. You can look most of them at protools.

I tested most of them for my personal use. At last i choose pelock.

Pelock is a packer, crypter and compressor for your delphi programs. It has very simple and easy to use interface. Additionally you can make demo check by this program.

But not most of these are pelock’s good side. The good with pelock is the producer. If you encounter some problems he always help you on your job. He wants you to send the files, extra libs, etc. Solve the problem and recompile his program and then send it to you. So pelock is my first choice because of the very very nice producer.

While using pelock you always now that the producer is at the other side waiting there to solve the problem related to his software!

Distributing Applications With Advantage Local Server

If you’ve written an application using Advantage Local Server and want your application to run on another machine you have to distribute some files with your application. These files are Advantage’s API dlls, charset configs, and configuration file.

Lets check which files to be copied :

Continue reading ‘Distributing Applications With Advantage Local Server’

A Note About Fulltext Search on Databases (like Advantage)

As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

Continue reading ‘A Note About Fulltext Search on Databases (like Advantage)’

Internet Touring with Jake #2

If you make a tag system and want to make a tag cloud page which will writes tags in different sizes accoring to use time refer to Tag Cloud document. That’s an easy and practical way for you. (Document Mirror on Focus on Code (186KB))

If you want to learn CSS Positioning or need a manual in your pocket you can refer to Learn CSS Positioning in Ten Steps article. That’s a very good and simple article including most of positioning styles. (Document Mirror on Focus on Code (88KB))

If you want to read and write to TWebBrowser component on Delphi you can refer to How to read and write form elements article. Article contains most wishes while using TWebBrowser. Before using these just insert Microsoft HTML Object Library to your project and add MSHTML_TLB class to your uses block.(Document Mirror on Focus on Code (52KB))