database programming
Drupal installation - old
Wed, 2009-11-11 14:40 | by finnDrupal is today one of the most used CMSs (Content Management System) that is used around the world. Whitehouse.gov relaunched their web site in October 2009 using Drupal as the basis for their web site. One of the reasons for the popularity is that it can handle a lot of simultanous users, it is secure and you can change it to your liking. You can add and remove modules as you need. Creating a site with blogs, forums, online store, organic groups and other features.
Automated installation
There are several options for installing Drupal on a web site. The easiest is if your hosting company has a control panel that has Simple scripts or Fantastico. Then you push the button for installing Drupal, tell it where to install and the site is ready to work on. Remember that if you install to the root folder of the site, it might remove your front page so be aware of what you want to do.
Manual installation
The manual installation of the core is simple if you know how to use an ftp-client, a browser and know how to create a database on your domain. The following is a brief walk through on how to do it. There are other guides on the internet as well that are more thorough and cover the specifics for each hosting company.
Go to drupal.org and download verson 6.xx. Version 5 is still maintained, but I recommend that you go for the latest version.
.jpg)
Once you have that downloaded, unpack it and upload it to your web site using an ftp-client. Filezilla is one that is very popular, but there are many others.
While the ftp-client is uploading the files you can create the database that is needed for the installation. For most web sites a database based on MySQL is sufficient, but if you are going for a bigger site with thousands of users and a lot of content, look into using PostgreSQL. The information that is important is servername, database name, username and password. The username and password should NOT be the same as your normal login, and they should contain letters, numbers and other characters.
When all the files are uploaded, use your ftp-client and go to the following directory on the server: sites/default and copy the file default.settings.php to settings.php. Make sure the file is readable by changing the security to 777 (or read, write and execute for everyone).
Use your internet browser (Internet explorer, Firefox, Opera or Safari) and type in the url to your web site. You will now see the screen below. Click on Install Drupal in English.

You should now see the following screen if everything is working the way it should:

I have highlighted the options that is necessary. Most times the Advanced options is not necessary to look at as Drupal will figure out the database server/host. For some databases it might be necessary to add a table prefix in case you have other data in there. I use drup_ on some of my installations.
The next screen will be for you to add the name of the site (normally your business name), a system administrator username and password and you are ready to go. Have your site use clean urls if possible. It gives you an option to use friendly names on the information you are posting.

Important last step:
Use your ftp-client and change the security of settings.php to 444 (on some servers it will be 644) and you are ready to explore what Drupal can offer you. Most likely you will like to add modules and change the theme/template of the site.
Books
Note that you have to check out books separate from all other items in the store.
Welcome to Alden Tech and Design
Computer Consulting
We provide setup and maintenance services for businesses and private persons that are using Microsoft products. Our business services include:
- Assessment of your network and what need to be improved/changed out. This can also include both present and future needs in the network.
- Installation and configuration of Microsoft Server 2003 and 2008.
- Installation and configuration of computers that are joining in a Microsoft Active Directory domain.
- Setup and maintenance of software that will be running on servers and PC's.
- Maintenance of servers and PC's in your network. See
Computer services for both businesses and private persons:
- General cleanup that includes most of the list below. Virus cleanup will be done separately.
- Blowing out dust from the computer.
- Installing updates.
- Cleaning up malware (viruses, trojan horses, adware and spyware etc.)
- Changing hard drives.
- Reinstalling operating systems (Windows XP, Windows Vista and Windows 7).
Please let us know if you want to know more about remote monitoring and assistance. We help people all over US and Europe.
During my years as a teacher and computer consultant I have earned several certifications:
- CompTIA A+ software and hardware.
- MCSA certifications on Windows 2000 and XP, 2000 and 2003 server.
Website Services
My goal as a web designer is to work with you in creating a web presence and signature look for you or your business. My goal as a programmer is to build a website design with a clean infrastructure and program solutions to meet your business needs.
As a web designer I specialize in web pages that are beautiful, accessible, fast and easy to download and update.
We will give you a free initial consultation to assess what you need and how we can make your web presence fulfill your needs.
We do database construction for web sites with special needs. Mainly we program for MySQL, but we can also work in PostGreSQL if you prefer that.
All websites will be programmed using HTML, CSS and PHP. Using HTML as the basis for all pages make it easy for you or others to work on the pages as well.
Install, maintain and support of solutions for blogging, e-commerce etc. is some of the tasks that we do. Very often this is done as an add-on to existing web sites as demand increases on the web site.
Installing, configuring, designing templates and maintaing Drupal for high-end web sites or for web sites where you and others need to edit the content or collaborate