Trouble With Password Reset Email Template

[sethp]

I've enabled the "Forgot Password" feature on my CRM, but when users receive the email generated by their request, it doesn't have a link or password in it.

This is an example of the email that is being sent out:

The forgotten password information is as follows: $contact_user_pwd

I know that $contact_user_pwd isn't a real variable.

How can I fix this so that the email sends the user a generated password OR sends them to a page where they can reset their password?

[widodude]

I'd like to add to this thread by describing a similar problem. I would like to edit the password reset template, currently this what comes out:
------------------
Here is your account username and temporary password:
Username : XXXXXX
Password : XXXXXX

http://localhost/Sugar/index.php

Once you log in using the above password, you will need to re-set the password to one of your own choice.
---------------------

What i'd like to change is the URL - I imagine it's one of the php files, so if someone can point me in the right direction (and hopefully the original poster) that would be grea

[eitrix]

check out email_templates table inside your sugar database

[widodude]

Not sure what you mean? The Password Reset Email is a system generated email that's already pre-configured. I noticed that the email is configured in SugarCRM/install/seed_data/Advanced_Password_SeedData.php - check the line .$GLOBALS['sugar_config']['site_url'].'/index.php
So i checked out site_url in config.php and changed the url - restarted apache and quick rebuild of Sugar & config.php (the URL is changed to what i want to)

however when i tested it out (password reset) it still came out with the old localhost/Sugar/Index.php url.

[widodude]

I think this one has the Sugar follk stuck

[phild]

Just installed the latest sugarcrm, and despite changing the config.php, the email sent to users for account/password changes still points to 127.0.0.1/sugarcrm

be interesting to see if its a system issue, or im just being an idiot!!!

[phild]

Just installed the latest sugarcrm, and despite changing the config.php, the email sent to users for account/password changes still points to 127.0.0.1/sugarcrm

be interesting to see if its a system issue, or im just being an idiot!!!

Yup, im an idiot!!!

i wasnt saving the email template!!!

[kevinrees]

Hi, I'm a newbie struggling with this one as well!

i've changed the url in the config.php file, but that doesn't seem to have resolved the url from

http://127.0.0.1:80/sugarcrm/index.php

to what i'd like it to be:

http://servername:80/sugarcrm/index.php

I was wondering if someone could tell me the steps to resolve this please?

thanks,

Kevin

[airnat]

I've enabled the "Forgot Password" feature on my CRM, but when users receive the email generated by their request, it doesn't have a link or password in it.

This is an example of the email that is being sent out:

I know that $contact_user_pwd isn't a real variable.

How can I fix this so that the email sends the user a generated password OR sends them to a page where they can reset their password?

Hi Seth,

The variables are the following:
Usarname: $contact_user_user_name
Password: $contact_user_user_hash

[kismert]

I've also been facing this issue, and several posters to this thread provided clues that helped.

To sum up the problem:

1. On installation, if you don't set the 'site_url' parameter correctly, your 'New account information' emails won't have the proper url.
2. widodude is right that Advanced_Password_SeedData.php sets up the templates, but -- it does it only ONCE, when you install Sugar.
3. After installation, you must follow eitrix's advice and modify the email_templates table in the Sugar database directly.
4. I feel this is a bug in Sugar -- the New account email should create its link from the current site_url every time the email is sent, not just once on install.

Sample SQL to fix:

• Note 1: modify the [body] and [body_html] fields from your own email_templates records. Don't use this example -- it may not work for your configuration.
• Note 2: SQL Server syntax; MySQL syntax may vary slightly

UPDATE [sugarcrm].[dbo].[email_templates]
SET 
[body] = 
'Welcome to SugarCRM! 
To register, go to:
   http://yourdomain/sugarcrm/index.php 
Login with your username and one-time, temporary password: 
   Username : $contact_user_user_name 
   Password : $contact_user_user_hash 
On the next screen, enter your permanent SugarCRM password.'
, [body_html] =
'<div>
<h3>Welcome to SugarCRM!</h3>
<ol>
<li>To register, go to:<br/>
&nbsp;&nbsp;&nbsp;<a href="http://yourdomain/sugarcrm/index.php">http://yourdomain/sugarcrm/index.php</a></li>
<li>Login with your username and <i>one-time, temporary</i> password:<br/>
&nbsp;&nbsp;&nbsp;<b>Username : $contact_user_user_name</b><br/>
&nbsp;&nbsp;&nbsp;<b>Password :</b> $contact_user_user_hash</li>
<li>On the next screen, enter your permanent SugarCRM password.</li>
</ol>
</div>'
WHERE 
id = '(id of the new account email template)'