Jump to content

Drupal Anyone?


bodsham

Recommended Posts

in cpanel > mysql

create a database like drupal

create a user with a password

add user to database.

 

download the drupal-4.5.1.tar.gz file from drupal site to your computer.

 

Create tables using phpmyadmin located at the bottom of MySql,

go to database (drupal) -> SQL -> load database.mysql file

which comes with drupal in /database/ directory.

 

using cpanel > file manager

click on the folder icon to the left of public_html folder to go inside.

select Upload file(s)

browse to the file from your computer.

After it is uploaded,

click on the name of the file (not the icon)

select on the right

Extract File Contents

after it is done, click on the name of the new folder drupal-4.5.1

and select rename, rename to drupal or whatever.

 

navagate to the drupal folder for your config file

 

Always check the latest installation documentation from the Drupal site to verify where the file is.

Look for something like,

"The default configuration can be found in the

'sites/default/settings.php"

 

Edit the appropriate file,

change the lines

 

# $db_url = "mysql://user:password@hostname/database";

# $db_url = "pgsql://user:password@hostname/database";

$db_url = "mysql://cpanelname_databaseuser:databasepassword@localhost/cpanelname_databasename";

# If $db_prefix is specified all database table names will be

# prepended with this string. Be sure to use valid database

# characters only, usually alphanumeric and underscore. If no

# prefixes are desired, set to empty string "".

$db_prefix = "";

 

#

# Base URL:

#

# The URL of your website's main page. It is not allowed to have

# a trailing slash; Drupal will add it for you.

#

$base_url = "http://yoursite.ext/drupal";

 

 

and goto the bottom of page and save the file

 

now goto yoursite.ext/drupal

and create a super user with e-amail addy

you will be assigned a password

click on login

goto administer

then goto users

and find Public registrations:

and select > Only site administrators can create new user accounts.

and save.

Then you can edit your password under myaccount.

 

Again check the latest install instructions for changes.

 

The rest is up to you.

Link to comment
Share on other sites

Nice work, Don :eek:

 

I have tried Drupal 4.5 and I must say it was the first CMS that almost convinced me to use it. It's still far from what I'd consider perfect but it's definitely the best I've seen so far. I know that others like ezPublish and Typo3 are much more powerfull and have many more features but the ease of use and logical way of working of Drupal pushed it to the top of my list :)

Link to comment
Share on other sites

  • 1 month later...

Hi...I just bought another domain and am attempting to set up Drupal on it. I followed your (wonderfully!) easy directions and I got this:

 

Fatal error: Table 'scratch_drupal.users' doesn't exist query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '78bb72f351913b609ec5b3a9d36d13ef' AND u.status < 3 LIMIT 0, 1 in /home/scratch/public_html/includes/database.mysql.inc on line 125

 

Wow. LOL.

 

Any suggestions?

 

 

 

 

in cpanel > mysql

create a database like drupal

create a user with a password

add user to database.

 

download the drupal-4.5.1.tar.gz file from drupal site to your computer.

 

using cpanel > file manager

click on the folder icon to the left of public_html folder to go inside.

select  Upload file(s)

browse to  the file from your computer.

After it is uploaded,

click on the name of the file (not the icon)

select on the right

Extract File Contents

after it is done, click on the name of the new folder drupal-4.5.1

and select rename, rename to drupal or whatever.

 

navagate to the drupal folder/includes

select config.php, select edit

 

change the lines

 

# $db_url = "mysql://user:password@hostname/database";

# $db_url = "pgsql://user:password@hostname/database";

$db_url = "mysql://cpanelname_databaseuser:databasepassword@localhost/cpanelname_databasename";

#  If $db_prefix is specified all database table names will be

#  prepended with this string.  Be sure to use valid database

#  characters only, usually alphanumeric and underscore.  If no

#  prefixes are desired, set to empty string "".

$db_prefix = "";

 

 

 

 

 

 

#

# Base URL:

#

#  The URL of your website's main page.  It is not allowed to have

#  a trailing slash; Drupal will add it for you.

#

$base_url = "http://yoursite.ext/drupal";

 

 

and goto the bottom of page and save the file

 

now goto yoursite.ext/drupal

and create a super user with e-amail addy

you will be assigned a password

click on login

goto administer

then goto users

and find Public registrations:

and select > Only site administrators can create new user accounts.

and save.

Then you can edit your password under myaccount.

 

The rest is up to you.

Link to comment
Share on other sites

It sounds like you (and that post) missed a major step in the installation. That is the creation of the tables.

 

from Drupal's installation guide:

 

Create tables (using phpmyadmin, go to database -> SQL -> load database.mysql file which comes with drupal in /database/ directory)

 

I don't think you did that, which is exemplified by the table not existing (that's what your error says)

Link to comment
Share on other sites

  • 2 months later...

Don,

 

Thanks for the instructions. I actually figured out how to do it myself, before finding this thread. That would have been nice.

 

However, you might want to update your instructions for the newest Drupal release.

 

This step:

navagate to the drupal folder/includes

select config.php, select edit

 

Has changed. It should now read:

 

>navigate to the following folder: /sites/default
select config.php, select edit

 

Hope that helps the next Drupal installer...

 

Paul P.

Link to comment
Share on other sites

  • 1 month later...

I've been running Drupal on my TCH account (now up to 3 drupal sites) since I signed up. Here's my link to notes which should help anyone using TCH.

 

coacalina drupal notes

 

check out the articles section on the site as well -- i've created a dedicated area for upcoming drupal tips.

 

Attention: the notes span versions 4.4, 4.5 and 4.6, so some may not be accurate anymore.

Link to comment
Share on other sites

It seems I'm the only one that wasn't thrilled with Drupal.

 

It has lots of very good features, but the admin is not straightforward. When I looked at Drupal I was looking for a KISS admin that I could then turn over to my client.

 

I can't imagine teaching them about 'nodes' and some of the other intricacies of the Drupal admin.

 

But I can that once you get up the learning curve, it could be an excellent CMS.

Link to comment
Share on other sites

HI All, My first day as a reseller. I wont be reselling but I am starting several blogs running drupal. I have one question, do I need to install drupal for everysingle site i manage or can i somehow install it "centrally" and run sites of it?

 

Thanks for your help, the forum and support staff has proven incredibly useful.

Link to comment
Share on other sites

HI All, My first day as a reseller. I wont be reselling but I am starting several blogs running drupal. I have one question, do I need to install drupal for everysingle site i manage or can i somehow install it "centrally" and run sites of it?

 

Thanks for your help, the forum and support staff has proven incredibly useful.

 

Welcome to TCH :)

 

Actually it is possible to use the same Drupal installation for more than one site, INSTALL.txt explains how, you need to park all the domains that run Drupal in the same account, more info: (quoted from INSTALL.txt)

  Additional site configurations are created in subdirectories within

  the 'sites' directory. Each subdirectory must have a 'settings.php'

  file which specifies the configuration settings. The easiest way to

  create additional sites is to copy the 'default' directory and modify

  the 'settings.php' file as appropriate. The new directory name is

  constructed from the site's URL. The configuration for www.example.com

  could be in 'sites/example.com/settings.php' (note that 'www.' should

  be omitted if users can access your site at http://example.com/).

 

Using the same installation for all the sites makes it easier to upgade Drupal later on, OTOH, you need to park the domains in the same account as I said.

Edited by Ayman
Link to comment
Share on other sites

Thanks! :thumbup1: Just what i needed. Now, I need to figure out how to list several domains under one account...

 

PG

 

HI All, My first day as a reseller. I wont be reselling but I am starting several blogs running drupal. I have one question, do I need to install drupal for everysingle site i manage or can i somehow install it "centrally" and run sites of it?

 

Thanks for your help, the forum and support staff has proven incredibly useful.

 

Welcome to TCH :)

 

Actually it is possible to use the same Drupal installation for more than one site, INSTALL.txt explains how, you need to park all the domains that run Drupal in the same account, more info: (quoted from INSTALL.txt)

   Additional site configurations are created in subdirectories within

   the 'sites' directory. Each subdirectory must have a 'settings.php'

   file which specifies the configuration settings. The easiest way to

   create additional sites is to copy the 'default' directory and modify

   the 'settings.php' file as appropriate. The new directory name is

   constructed from the site's URL. The configuration for www.example.com

   could be in 'sites/example.com/settings.php' (note that 'www.' should

   be omitted if users can access your site at http://example.com/).

 

Using the same installation for all the sites makes it easier to upgade Drupal later on, OTOH, you need to park the domains in the same account as I said.

Link to comment
Share on other sites

Actually, must all domains be part of the same account or package? I am struggling to understand the difference between the two... and since i have not found a way of adding multiple domains to an account...

 

PG

 

 

Thanks!  :thumbup1: Just what i needed. Now, I need to figure out how to list several domains under one account...

 

PG

 

HI All, My first day as a reseller. I wont be reselling but I am starting several blogs running drupal. I have one question, do I need to install drupal for everysingle site i manage or can i somehow install it "centrally" and run sites of it?

 

Thanks for your help, the forum and support staff has proven incredibly useful.

 

Welcome to TCH :)

 

Actually it is possible to use the same Drupal installation for more than one site, INSTALL.txt explains how, you need to park all the domains that run Drupal in the same account, more info: (quoted from INSTALL.txt)

   Additional site configurations are created in subdirectories within

   the 'sites' directory. Each subdirectory must have a 'settings.php'

   file which specifies the configuration settings. The easiest way to

   create additional sites is to copy the 'default' directory and modify

   the 'settings.php' file as appropriate. The new directory name is

   constructed from the site's URL. The configuration for www.example.com

   could be in 'sites/example.com/settings.php' (note that 'www.' should

   be omitted if users can access your site at http://example.com/).

 

Using the same installation for all the sites makes it easier to upgade Drupal later on, OTOH, you need to park the domains in the same account as I said.

Link to comment
Share on other sites

  • 1 month later...

Hi,

 

I've got Drupal all set up, but the only thing I cannot figure out is enabling Clean URLs. The error I'm getting on the settings page is

It appears your host is not configured correctly for Clean URLs. Please check for ModRewrite support with your administrator.
Is there something special I have to do in order for it to work on a TCH server?

 

Thanks.

Link to comment
Share on other sites

To get a url like

drupal/node/7

go into the admin settings and enable clean urls

 

if you are in a subfolder

mod the drupal .htaccess file part

 

# Modify the RewriteBase if you are using Drupal in a subdirectory and the

# rewrite rules are not working properly:

#RewriteBase /drupal

 

remove the # in front of

RewriteBase /drupal

 

 

not sure if that is what you mean.

Link to comment
Share on other sites

How about just

RewriteBase /

 

 

 

I did not work for me the first time

I removed the #

and had

RewriteBase /drupal

in the drupal .htaccess file

 

then I had to login and goto admin/settings to enable clean urls

and then the long urls changed to

things like

domain/drupal/taxonomy/term/2

and

domain/drupal/node/3

Link to comment
Share on other sites

I have multiple sites and a reseller account here at TCH. I've got separate packages and separate installations of drupal on each. I'm trying to figure out how to run them from one code base. I've sucessfully set up a multisite installation on my home computer but I am a little confused how to do this on TCH. If I park domains what effect does this have on other site functions (mail, cpanel, email forwarding)? It should be as simple as creating a symlink in the base directory, but TCH doesn't have a command prompt to do this. Alternately I've tried using a php script to create a symlink but it responds with a permission denied error.

 

I'd like to preserve the webmail setups, email forwarding, and generally speaking the cpanel interface for each site. I'm also keeping separate databases for each site. I just want to only have to maintain one codebase.

 

Can anyone offer any solutions or tips on how to suceed at this?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...