By robnym on

Hi,

I have successfully installed Drupal och would now like to create a new account. The problem is that I am running Drupal locally on my Apache webserver (Mac OSx 10.5.6 ) and I' begining to think that Drupal can't send confirmation mails through a local webserver. Have anybody else encountered the same problem?

Best regards/ Rob

⋅ Categories: Drupal 6.x

Comments

crazybite’s picture

crazybite commented

You can find a module for sending e-mails through an smtp server. Several exist, but I am using php mailer module for drupal.

Patroclas’s picture

Patroclas commented

There is a good virtual smtp app called PaperCut if you don't want to connect to a real server.

But as admin you should be able to create a new user without using an email at all.

richardburden’s picture

richardburden commented

How do you create a new user without using an email at all? I have full access to the database (MySQL version 5.1.61), and have installed Drupal 7.12 (standard options) on a virtual machine running Ubuntu 10.04. I have installed the Postfix mail server, but apparently Drupal cannot communicate with it. The installation process failed to create any user that I can use, so I need to create a user with administrator privileges before I can do anything else, but I cannot do that because Drupal cannot send the account activation email.

I have tried the following modifications to the users table in the database: set a user's password to the empty string, or to md5('password'), and set the same user's status to 1. In all cases, the login fails. Probably md5 is not the correct hash algorithm, but I have not been able to determine what is.

richardburden’s picture

richardburden commented

Here's how I did it:
Created a file named 'pwd.php' and put it in the Drupal root directory. Below, the contents of the file:

<?php  
define('DRUPAL_ROOT', getcwd());
require DRUPAL_ROOT . '/includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

require 'includes/password.inc';

print user_hash_password('password'); ?>

Next, I requested this page in the browser
link: http://127.0.0.1/pwd.php (I am running drupal on localhost).

I copied the string that was displayed to the 'pass' field in the 'users' table in the database for the user whose account I am creating. I set the 'status' field for the same user to 1. This allowed me to login with password 'password', but this user had no privileges.

Next, I added a row to the users_roles table, using the uid from the users table and the rid from the role table, making my user an administrator.