Oct 29 2008

Webfaction Limited Review

Tag: Yada — Dustin @ 5:48 am

I’ve seen a lot of recommendations for Webfaction for new Django developers who want an easy to use hosting solution. As you can see from previous posts that I have a VPS that I’ve set up Django on. I was having problems getting one of my applications to work, and I wondered if it was because of my setup. So I decided to try out Webfaction. After all, they offered a 60 day money back guarantee. So I signed up and set up my account. I must admit it was much easier to set up than my VPS, plus I could choose to use Python 2.5 (which was never really able to get working on my server setup) and you can use mod_python or WSGI. I was quite impressed with their setup options and the ease of setup. It turns out there there was a problem in my code because I ended up getting the same error on their servers as I did mine. I was just confused because it was working on my windows develpement machine, by not my linux servers.Â

So having lost the need for Webfaction, I decided to exercise their money back guarantee. I think this was the best part of the process. I sent them an email. The responded quickly telling me how to cancle the account from the control panel. I think within a half hour I had the money back in my PayPal account and an email confirmation letting me know and saying thanks for trying their service.

Surely, If I ever need another Django host or if it comes to the point where I need to use the latest version of Python, I will look to Webfaction. If I have a client looking for hosting, I will recommend Webfaction.

Comments (7)

Oct 03 2008

Django Tip: get_FIELD_display()

Tag: Yada — Dustin @ 3:45 pm

I’m posting this because it seems rather simple, but it took me a while to find - even with some tips from some helpful people in the #django IRC channel.

Let’s say you have a ChoiceField set up like the documents describe:

class Foo(models.Model):
    GENDER_CHOICES = (
        ('M', 'Male'),
        ('F', 'Female'),
    )
    gender = models.CharField(max_length=1, choices=GENDER_CHOICES)

Now, you want to display the gender field in a template. If you use the {{ person.gender }} variable, you would get “M” or “F” to display on your page. But what if you want “Male” or “Female”? Then you would use {{ person.get_gender_display }}.

Nifty.

Comments (3)

Oct 03 2008

Dynamic Filtered Drop-Down Choice Fields With Django

Tag: Yada — Dustin @ 10:05 am

I’m enjoying the Django framework. Sometimes, what was seems rather easy (relatively speaking) gets sort of complicated when working within the boundaries of a framework. Such was the case with my latest endeavor to filter on drop-down based on the selection of another drop-down.

Here is the situation: I have a database with car makes and models. When a user selects a make, I want to update the models drop-down with only the models associated with that make. Sounds pretty common, right? The database has a lot of entries, so I don’t want to do it with pure javascript because that could make for big script, and maybe I don’t want to give away all my data so easily so some hacker can just parse a simple javascript file to get all the make/model data out of my database (not that I care, but some people might). Therefore I want to use Ajax to populate the data.

First, the proof of concept. I created this simple html file to test how it might work:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" Â Â Â "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”> <html> Â Â Â <head> Â Â Â Â Â Â Â <meta http-equiv=”Content-type” content=”text/html; charset=utf-8″ /> Â Â Â Â Â Â Â <title>Update Drop-Down Without Refresh</title> Â Â Â Â Â Â Â <script type=”text/javascript” charset=”utf-8″> Â Â Â Â Â Â Â Â Â Â Â function FilterModels() { Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var makeslist = document.getElementById(’makes’); Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var modelslist = document.getElementById(’models’); Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var make_id = makeslist.options[makeslist.selectedIndex].value; Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var modelstxt = new Array(); Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â modelstxt[1] = “1\tEscort\n2\tTaurus”; Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â modelstxt[2] = “1\tAltima\n2\tMaxima”; Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var models = modelstxt[make_id].split(”\n”); Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â for (var count = modelslist.options.length-1; count >-1; count–){ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â modelslist.options[count] = null; Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â for (i=0; i<models.length; i++){ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var modelvals = models[i].split(”\t”); Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â var option = new Option(modelvals[1], modelvals[2], false, false); Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â modelslist.options[modelslist.length] = option; Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } Â Â Â Â Â Â Â Â Â Â Â } Â Â Â Â Â Â Â </script> Â Â Â </head> Â Â Â <body> Â Â Â Â Â Â Â <p>This is a proof of concept to update a select (drop-down) list of values, based on the selection of another select (drop-down) element using ajax.</p> Â Â Â Â Â Â Â <form action=”" method=”get” accept-charset=”utf-8″> Â Â Â Â Â Â Â Â Â Â Â <select name=”makes” onchange=”FilterModels()” id=”makes”> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â <option>–</option> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â <option value=”1″>Ford</option> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â <option value=”2″>Nissan</option> Â Â Â Â Â Â Â Â Â Â Â </select> Â Â Â Â Â Â Â Â Â Â Â <select name=”models” id=”models”> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â <option>Choose Make</option> Â Â Â Â Â Â Â Â Â Â Â </select> Â Â Â Â Â Â Â </form> Â Â Â </body> </html>

That basically helped me organize the code I needed to change the drop-down, now I just need to plug in the Ajax and server side code to make it happen.

Notice, in the proof of concept, I used a tab delimited format for my models. I really didn’t want to mess with parsing xml or json or whatever. So I wrote a model feed based on my automobile make id.

URL:

(r'^feeds/models-by-make-id/(\d+)/$', 'autos.views.feed_models'),

View:

def feed_models(request, make_id):
Â Â Â  make = AutoMake.objects.get(pk=make_id)
Â Â Â  models = AutoModel.objects.filter(make=make)
Â Â Â  return render_to_response('feeds/models.txt', {'models':models}, mimetype="text/plain")

Template:

{% for model in models %}{{ model.id }}Â Â Â  {{ model.model }}
{% endfor %}

That gave me the data feed that I needed to request via Ajax. Now for my form. Because the model field loads dynamically, I had to override the clean function in the ChoiceField class and use it instead so I didn’t get invalid choice errors:

class DynamicChoiceField(forms.ChoiceField):Â

Â Â  Â def clean(self, value):Â

Â Â  Â  Â  Â return value

class MyForm(forms.Form):Â

Â Â  Â make = ModelChoiceField(AutoMake.objects, widget=forms.Select(attrs={'onchange':'FilterModels();'}))Â

Â Â  Â model = DynamicChoiceField(widget=forms.Select(attrs={'disabled':'true'}), choices=(('-1','Select Make'),))

Notice that I am making a call to FilterModels() on my ModelChoiceField’s onchange event. So, here is that code as well:

function FilterModels(sel_val) {
        var modelList = $('id_model');
        for (var count = modelList.options.length-1; count >-1; count--){
                modelList.options[count] = null;
        }
        modelList.options[0] = new Option('Loading...', '-1', false, false);
        modelList.disabled = true;

        var makeList = $('id_make');
        var make_id = makeList.options[makeList.selectedIndex].value;
        if (make_id > 0) {
                new Ajax.Request('/feeds/models-by-make-id/' + make_id + '/', {
                        method: 'get',
                        onSuccess: function(transport){
                                var response = transport.responseText || 'no response text';
                                var kvpairs = response.split("\n");
                                for (i=0; i<kvpairs.length - 1; i++) {
                                        m = kvpairs[i].split("\t");
                                        var option = new Option(m[1], m[0], false, false);
                                        modelList.options[i] = option;
                                }
                                modelList.disabled = false;
                                if (sel_val > 0) {
                                        modelList.value = sel_val;
                                }
                        },
                        onFailure: function(){
                                alert('An error occured trying to filter the model list.');
                                modelList.options[0] = new Option('Other', '0', false, false);
                                modelList.disabled = false;
                        }
                });
        }
        else {
                modelList.options[0] = new Option('Select Make', '-1', false, false);
                modelList.disabled = true;
        }
}

I also make a call to this function in my template after the form loads. This is incase the form is refreshed, or it fails validation and a make is still selected. It will populate the model list and select the value that was selected previously:

<script type="text/javascript" charset="utf-8">
        FilterModels({{ model_id }});
</script>

Note that in order to get the model_id, I had to set it in my view:

def add_classified(request):
        if request.method == 'POST':
                form = AdForm(request.POST)
        if request.POST.has_key('model'):
                model_id = request.POST['model']
        else:
                model_id = 0
        return render_to_response('add_classified.html', {'form':form,'model_id':model_id}, context_instance=RequestContext(request))

I think that’s about it… Did I miss anything?

Comments (2)

Sep 25 2008

Setting up Django on a WHM/cPanel VPS (LiquidWeb)

Tag: Programming & Internet — Dustin @ 5:55 am

I ordered a new VPS from LiquidWeb for the purpose of using it to host our company’s new product that I’m currently writing in Django. I have another VPS with LiquidWeb and I highly recommend them!

I got Django up and running on my other server with some help of LiquidWeb support. This time I’m going to attempt to do it on my own and document the process as I’m sure this won’t be the last time I need to set this up. Hopefully, it can help someone else out there looking to do the same.

Python 2.4.3 is installed by default. My original plan was to use Python 2.5.2, but I had problems compiling database bindings with 2.5, so I finally gave up and decided to stick with 2.4.

Install PostgreSQL & Python Database Bindings

I’m quite familiar with MySQL, but knowing that Django creators have a fondness for PostgreSQL, I thought I might attempt to use it for this project. (My development so far has been using SQLIte, but I don’t think that it will be adequate for this project). I didn’t have PostgreSQL installed, but installing it was pretty straight forward. cPanal has an installer script (thanks LiquidWeb support for the tip):

# /scripts/installpostgres

After installation, I set the password in WHM and now the database options appeared in cPanel:

Just follow the wizard to create your database.

Next, I installed psycopg to bind python to PostgreSQL.

# cd /usr/local/src # wget http://initd.org/pub/software/psycopg/psycopg2-2.0.8.tar.gz # tar xzvf psycopg2-2.0.8.tar.gz # cd psycopg2-2.0.8 # python setup.py build # python setup.py install

Build and Install WSGI

Basically, here are the commands I ran to download and complie wsgi:

cd /usr/local/src/ wget http://modwsgi.googlecode.com/files/mod_wsgi-2.3.tar.gz gzip -dc mod_wsgi-2.3.tar.gz | tar xf - cd mod_wsgi-2.3 ./configure make && make install

After compiling the module, I was given the path to where it was located (/usr/lib/httpd/modules/mod_wsgi.so).

I logged in to WHM -> Server Configuration -> Apache Setup -> Include Editor to add the following line to load the module:

LoadModule wsgi_module /usr/lib/httpd/modules/mod_wsgi.soAddHandler wsgi-script .wsgi

If it works for you… Lucky you. Unfortunately I got this error:

Configuration problem detected on line 220 of file /usr/local/apache/conf/httpd.conf: : Syntax error on line 1 of /usr/local/apache/conf/includes/pre_virtualhost_2.conf: API module structure ‘wsgi_module’ in file /usr/lib/httpd/modules/mod_wsgi.so is garbled - expected signature 41503232 but saw 41503230 - perhaps this is not an Apache module DSO, or was compiled for a different Apache version? — /usr/local/apache/conf/httpd.conf — 214 215 216 217# SUEXEC is supported 218 219Include “/usr/local/apache/conf/includes/pre_virtualhost_global.conf” 220 ===> Include “/usr/local/apache/conf/includes/pre_virtualhost_2.conf” <=== 221 222# DO NOT EDIT. AUTOMATICALLY GENERATED. IF YOU NEED TO MAKE A CHANGE PLEASE USE THE INCLUDE FILES. 223NameVirtualHost * 224 225# Default vhost for unbound IPs 226 — /usr/local/apache/conf/httpd.conf —

My first thought was that I had two versions of Apache installed, but I noticed my ./configure command said it found Apache 2.2.9. I asked LiquidWeb Support and they said that it was likely because I needed FastCGI installed.

So in WHM again, I went to Software -> Apache Update and reinstalled Apache and added fastcgi support.

That didn’t help either.

So I posted to the modwsgi google group and got help from the modwsgi author himself, Graham Dumpleton and was able to install the correct version by specifying the apxs file located in /usr/local/apache/bin/. So back in /usr/local/src/mod_wsgi-2.3, I ran the following commands to rebuild modwsgi:

# make distclean # ./configure --with-apxs=/usr/local/apache/bin/apxs # make && make install

The output was more concise this time. Then I when back into WHM -> Server Configuration -> Apache Setup -> Include Editor and loaded the module and restarted apache and it all worked this time! Thank you Graham!

I followed the Quick Configuration Guide to test WSGI to make sure it was working and learn a bit more about how it works. I recommend that you do too. Everything worked by the way. Well come back to modwsgi setup in a moment, but first we need to install Django.

Install Django

Download and installation of Django 1.0 was quite simple really - the easiest part of the gig.

cd /usr/local/src wget http://www.djangoproject.com/download/1.0/tarball/ tar xzvf Django-1.0.tar.gz cd Django-1.0 python setup.py install

Run Baby, Run

Now, we attempt to put it all together!

This set up will need to be run per domain/account. First, lets create our wsgi app that will call the Django application.

I already have my account set up on WHM where I will run my Django app. It is fcabi.net and the username is fcabi, so where every you see this, be mindful to replace it with your specifics.

Create a file in /home/fcabi/public_html with the following python code:

import os, sys sys.path.append('/home/fcabi/public_html') sys.path.append('/home/fcabi/public_html/fcabinet') os.environ['DJANGO_SETTINGS_MODULE'] = ‘fcabinet.settings’

import django.core.handlers.wsgi

application = django.core.handlers.wsgi.WSGIHandler()

Next I create a file to add my virtual host directives in.

# mkdir -p /usr/local/apache/conf/userdata/std/2/fcabi/fcabi.net/ # vi /usr/local/apache/conf/userdata/std/2/fcabi/fcabi.net/wsgi.conf

I enter the following:

<IfModule mod_alias.c> Alias /robots.txt /home/fcabi/public_html/fcabinet/media/robots.txt Alias /favicon.ico /home/fcabi/public_html/fcabinet/media/favicon.ico Alias /media /home/fcabi/public_html/fcabinet/mediaAlias /adminmedia /home/fcabi/public_html/fcabinet/media/adminmedia</IfModule>

<IfModule mod_wsgi.c>
WSGIScriptAlias / /home/fcabi/public_html/django.wsgi
WSGIDaemonProcess django threads=15 display-name=%{GROUP}
WSGIProcessGroup django
WSGIApplicationGroup %{GLOBAL}
</IfModule>

Next I run the cPanel script to add the include file to the main httpd.conf file and make sure the changes stick, then I restart apache.

# /usr/local/cpanel/bin/build_apache_conf

After running this command, I should see the Include to the file I just created:

Â Â Â ServerName fcabi.net Â Â Â ServerAlias www.fcabi.net Â Â Â DocumentRoot /home/fcabi/public_html Â Â Â ServerAdmin webmaster@fcabi.net Â Â Â UseCanonicalName Off Â Â Â CustomLog /usr/local/apache/domlogs/fcabi.net combined Â Â Â CustomLog /usr/local/apache/domlogs/fcabi.net-bytes_log "%{%s}t %I .\n%{%s}t %O ." Â Â Â ## User fcabi # Needed for Cpanel::ApacheConf Â Â Â <IfModule !mod_disable_suexec.c> Â Â Â Â Â Â Â SuexecUserGroup fcabi fcabi Â Â Â </IfModule><VirtualHost 67.227.189.54:80>

Include “/usr/local/apache/conf/userdata/std/2/fcabi/fcabi.net/*.conf”

</VirtualHost>

It’s there, so I restart apache.

# /usr/sbin/apachectl restart

Notice that I added an alias to adminmedia. To get this to work, I also had to add a symbolic link to to the contrib/admin/media files:

# ln -s /usr/local/lib/python2.4/site-packages/django/contrib/admin/media/ /home/fcabi/public_html/fcabinet/media/adminmedia

Bonus: Wildcard Subdomains

My application makes use of wildcard sub-domains, so I also needed this to work as well. This was fairly easy to implement.

For the subdomain, enter “*” and click create (Document Root may autopopulate with “/public_html”, this is normal).

Now, set up virtual host directives for this subdomain like you did with your original domain.

# mkdir -p /usr/local/apache/conf/userdata/std/2/fcabi/wildcard_safe.fcabi.net/ # vi /usr/local/apache/conf/userdata/std/2/fcabi/wildcard_safe.fcabi.net/wsgi.conf

Enter the following:

<IfModule mod_wsgi.c> WSGIScriptAlias / /home/fcabi/public_html/django.wsgi WSGIDaemonProcess django-sub threads=15 display-name=%{GROUP} WSGIProcessGroup django-sub WSGIApplicationGroup %{GLOBAL} </IfModule>

* Notice the the WSGIDaemonProcess name is must be different.

Rebuild the config file and restart apache.

# /usr/local/cpanel/bin/build_apache_conf # /usr/sbin/apachectl restart

PS. If you’re using sub-domains, you might find my sub-domain middleware useful.

Comments (1)

Sep 22 2008

I Hate RC Willey

Tag: Yada — Dustin @ 9:49 am

So it was labor day. For some reason - likely do to excessive advertising, I think of RC Willey on Labor day. My wife has been wanting a bedroom set. We were planning on ordering from Canopy, but I thought it would be fun to go look at RC Willey and see if they had any sales going on. Big mistake!

So we found a set we liked and decided to order. We were told we could pick it up at the warehouse, way out west, so we drove down to Alpine and borrowed my father-in-law’s truck, since my truck was not registered at the moment (a long crazy story).

Once we get there we were told that the bed frame was on back order and won’t be available until next month. Frustrated and angry, I told them to cancel the order. One the way back I called the salesman (Michael F. Langeland) and asked if he knew that information and didn’t bother telling us just so he could get his commission. He said he wasn’t aware of that. He pulled it up in the computer and said, yeah, the bed is on back-order.

We looked around at other furniture sets and we decided to order the Canopy one we wanted originally, but found that one piece we wanted was also not in stock. So as long as we were going to wait, we figured we would get the RC Willey furniture because it was a little cheaper and we wouldn’t have to put it together. So we called back and said, OK we’ll get this set as long as you deliver it free. We were still mad about wasting all the gas to go pick it up. So that deal was made. In the process of that deal they double billed us.

A few days later my wife is wondering when they are going to arrive with the furniture that was in stock. So she called and learned that no delivery was ever scheduled and now all of the furniture set was on back order. We were really annoyed with our salesman now, so we went in to another store to talk with another salesman (we didn’t want Michael to get any commission at this point) and look around at other furniture sets. We found something we like, but a bit more expensive. So we decided to just cancel our order and save a bit longer. We stood in line and eventually had them cancel our order and fix the double billing problem and return all the money to our account.

So now its two weeks later. We’ve had one charge returned but still have $1100+ that needs to be returned to our account. It shouldn’t take two weeks to get a return right? So I called again to find out what is going on. It turns out they never canceled our order. The question was “so you don’t want your bed?” Uh, no! We were in the store and we canceled that. The response was. “No, you didn’t. Do you want to cancel it now?” Oh, I didn’t huh? Whatever. “YES. CANCEL IT!” Now it can’t just be that easy. She said, “you’ll have to call back at ten o’clock to speak with a cashier to get your money back.” Seriously, it was 9:56!

So I called back and I think I got it taken care of. But something that urks me about the whole process is how everyone seems to treat me like I’M stupid.

“What’s your account number?”

“I don’t know”

“What’s your social security number… You account doesn’t come up with that. What do you need?”

I need my money back. Then I swear, I’ll never BOTHER you people again!

Comments (2)

Sep 19 2008

Windows Live Writer

Tag: Yada — Dustin @ 8:53 am

This is a test post from Windows Live Writer.

Someone said it was the "bomb diggity" so I had to check it out!

Not bad indeed!

It certainly looks cool:

And it’s like editing directly in my blog as it uses my existing CSS!

Wow!

Comments (4)

Sep 11 2008

Django Accounts on Subdomains

Tag: Programming & Internet — Dustin @ 11:33 am

*Disclaimer: I’m a Django and Python newbie. Your mileage may vary following my advice.

My Goal is to create an accounts system similar to Unfuddle, where to register for a new account, a user will enter a subdomain and admin login (see Unfuddle registration).

Users can’t really log in from the home page - only from their subdomain. Once they are logged in, administrators can add more users that only have access to that subdomain.

FYI, I’m not competing against Unfuddle. I’m just very familiar with their system as I am a happy paying user. There are a number of other sites using this kind of accounting system. I’m sure I could implement it in PHP, but I really want to learn Django so I’m sticking with it on this project.

I would like to give props to the developers of Unfuddle as they have been more than helpful in reguards to sharing the structure of their application and the way they do things. Thanks guys! I’m sure if I were writing this in Ruby on Rails they would be even more helpful as their application is written in Rails.

Now, back to the show.

I’m trying to use as much pre-existing code as possible so I can take advantage of others knowledge and so I don’t have to reinvent any wheels.

I’m doing my development and testing on Windows. So in order to test this, I’ve edited my hosts files (C:\WINDOWS\system32\drivers\etc\hosts) with my main domain and a few subdomains that I want to test. When I go live, I will likely remove these from the hosts files and set up wildcard dns & subdomains on the server.

Here is an example of my hosts file entries used to test:

127.0.0.1    sample.com
127.0.0.1    www.sample.com
127.0.0.1    test.sample.com
127.0.0.1    company.sample.com
127.0.0.1    django.sample.com
127.0.0.1    nerd.sample.com
127.0.0.1    dork.sample.com

So far, this is what I’ve done to implement:

1. Install django-registration - I just checked out the latest source and plugged the registration folder into my project. Once I got it set up, I added a field to the form.

This is still a work in progress so I’ll have to come update later. Basically my goal is to have a registration form that also asks for the subdomain and title of the user or company. Then I will append the subdomain to the username before saving it to the Users table so that username can be unique within sub-domains.

2. I created a simple middleware inside my application. This basically reads the HTTP_HOST and sets request.domain and request.subdomain. If there is no subdomain, or the subdomain is ‘www’, then it returns and empty string.

3. My main template will have a link to log in. If they are on their subdomain they will see the login screen (I’m using django.contrib.auth for authentication and login forms). If they are on the main site, they will first be asked for their subdomain. After entering their subdomain, they will be redirected.

Here are the contents of my app’s login function.
The subdomain form and template are quite trivial to create.

I hope this helps someone. I hope to expand this post when I get further into it.

Comments (4)

Sep 11 2008

Setting up Wildcard DNS & Subdomains on cPanel

Tag: Programming & Internet — Dustin @ 8:18 am

*** UPDATE: DON’T READ THIS POST… JUST READ COMMENT #2 FROM CPANEL ***

I’ve posted instructions in the past on how to set up wildcard DNS and subdomains on DirectAdmin. DirectAdmin makes it rather trivial, which is quite nice. There is a little bit more effort involved in cPanel - manly because you actually have to make some modifications via SSH. So I would say this tutorial involves and intermediate skill level to accomplish (it can’t be more because this is about the extent of my skill level). You will need access to WHM and root access to your server.

Background: I’m currently learning Django and trying to create a solution for sub-domaining accounts. I’ve been told by a few people that this will be the hardest part to set up. At my currently Django level, this part is trivial. I hope to make more posts when I get the Django parts figured out as well. Stay tuned.

Step 1: DNS: A Record

First we’ll need to log in to WHM. Under DNS Functions, select Edit DNS Zone. Choose the domain for the zone in which you wish to edit. Add an A record mapped to asterisk (wildcard) for the subdomain and the IP Address the site is hosted on. You likely already have A records for ftp, webmail, etc. just model this new one after those.

You should now be able to enter any subdomain on your domain, but it will not likely find your main site. So now we need to set that up.

Step 2: ServerAlias

Log in to your server via SSH and go open /etc/httpd/conf/httpd.conf (I’ll assume you know your way around linux via command line as well as vi or some other editor)

*Note: wherever you see deqb.com you should expect to see your domain name that you are setting up

Now, we could edit this file and make everything work, but there is a problem with that. Look at the top of the document and you should see something like this:

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
#Â Â Direct modifications to the Apache configuration file may be lost upon subsequent regeneration of theÂ Â Â Â Â Â #
#Â Â configuration file. To have modifications retained, all modifications must be checked into theÂ Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â configuration system by running:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â Â Â /usr/local/cpanel/bin/apache_conf_distiller –updateÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â To see if your changes will be conserved, regenerate the Apache configuration file by running:Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â Â Â /usr/local/cpanel/bin/build_apache_confÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â and check the configuration file for your alterations. If your changes have been ignored, then they willÂ Â Â #
#Â Â need to be added directly to their respective template files.Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â It is also possible to add custom directives to the various “Include” files loaded by this httpd.confÂ Â Â Â Â Â #
#Â Â For detailed instructions on using Include files and the apache_conf_distiller with the new configurationÂ Â #
#Â Â system refer to the documentation at: http://www.cpanel.net/support/docs/ea/ea3/customdirectives.htmlÂ Â Â Â Â Â #
#Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â This configuration file was built from the following templates:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â /var/cpanel/templates/apache2/main.defaultÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â /var/cpanel/templates/apache2/main.localÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â /var/cpanel/templates/apache2/vhost.defaultÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â /var/cpanel/templates/apache2/vhost.localÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â /var/cpanel/templates/apache2/ssl_vhost.defaultÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â /var/cpanel/templates/apache2/ssl_vhost.localÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
#Â Templates with the ‘.local’ extension will be preferred over templates with the ‘.default’ extension.Â Â Â Â Â Â Â #
#Â The only template updated by the apache_conf_distiller is main.default.Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â #
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

Basically what it’s saying is don’t edit this file directly because you’re changes may be lost.

Do a search for the domain you are adding the wildcard to. You should find the VirtualHost set up for your domain. Here is mine:

# DO NOT EDIT. AUTOMATICALLY GENERATED.Â IF YOU NEED TO MAKE A CHANGE PLEASE USE THE INCLUDE FILES.

Â Â Â ServerName<VirtualHost 67.225.128.241:80> deqb.com
Â Â Â ServerAlias www.deqb.com
Â Â Â DocumentRoot /home/deqb/public_html
Â Â Â ServerAdmin webmaster@deqb.com
Â Â Â UseCanonicalName Off
Â Â Â Â Â Â Â Options -ExecCGI -Includes
Â Â Â Â Â Â Â RemoveHandler cgi-script .cgi .pl .plx .ppl .perl
Â Â Â CustomLog /usr/local/apache/domlogs/deqb.com combined
Â Â Â CustomLog /usr/local/apache/domlogs/deqb.com-bytes_log “%{%s}t %I .\n%{%s}t %O .”
Â Â Â ## User deqb # Needed for Cpanel::ApacheConf
Â Â Â <IfModule !mod_disable_suexec.c>
Â Â Â Â Â Â Â SuexecUserGroup deqb deqb
Â Â Â </IfModule>

Â Â Â # To customize this VirtualHost use an include file at the following location
Â Â Â # Include “/usr/local/apache/conf/userdata/std/2/deqb/deqb.com/*.conf”

</VirtualHost>

Notice the highlighted lines. This is where we are going to create a file. We are going to create a file at:
/usr/local/apache/conf/userdata/std/2/deqb/deqb.com/ServerAlias_wildcard.conf
(you can give it any name you want really)

*Hint: You may need to create the directories first, run this command:
mkdir -p /usr/local/apache/conf/userdata/std/2/deqb/deqb.com/

So really, you don’t need to edit anything it httpd.conf, we just needed some info.

Inside of the ServerAlias_wildcard.conf file, enter this line:
ServerAlias *.deqb.com

Now, you’ll need to rebuild the httpd.conf file per the instructions at the top of that file by running the following command:
/usr/local/cpanel/bin/build_apache_conf

If you open your /etc/httpd/conf/httpd.conf file again you should see that your VirtualHost for your domain as changed slightly:

Â Â Â Include “/usr/local/apache/conf/userdata/std/2/deqb/deqb.com/*.conf”

</VirtualHost>

Step 3: Restart Apache

The last step required is to restart apache. I suppose there are a number of ways to do this. As long as we are logged in to SSH, we might as well just run the command:
/usr/sbin/apachectl restart

Now, give it a try. you should be aby to access something like http://itworked.deqb.com and still see your main page.

Technorati Tags: dns, wildcard dns, subdomain, django, cpanel, whm

Comments (3)

Sep 10 2008

Gmail + Thunberbird = WOW

Tag: Programming & Internet — Dustin @ 6:12 am

I’ve been using Gmail as my main email client for about the past 4 years or so. I currently have Thunderbird set up with SMTP to use for certain situations - mainly when I want to copy and past images in - like showing screenshots to people. (I still prefer the speed of the web app - and being able to make it look like an app with Google Chrome/Google Gears is just that much sweeter)

Today I noticed something really cool. I got an email request from a client for updates to his website. I was composing a reply in Thunderbird with screenshots and all. In the process, I had a Gmail client open (in Google Chrome) and I was reading his initial email again to make sure there wasn’t something I missed.

At the bottom of the screen it said there was a new message with a link to update the conversation. I’ve seen this before on rare occassions. I figured he had sent me a follow up email. When I clicked the update link I saw the draft of the message I was composing in Thunderbird - screenshots and all. How cool is that?

Ok, maybe I’m over dramatic. But I thought it was neato!

Technorati Tags: gmail, thunderbird

Comments (3)

Aug 28 2008

Funny Quote

Tag: Humor — Dustin @ 9:11 am

I stumbled across this story on KSL and heard what I though was just a funny quote. Sure, I guess he has a point, but taken out of the context of this story, it just sounds hilarious…

Click the play button below to hear the quote, then see this story if you’re interested.

Sorry, the mini mp3 player didn’t work…

Comments (2)