 |
| << | September 2010 | >> |
| Su |
Mo |
Tu |
We |
Th |
Fr |
Sa |
| |
|
|
1 |
2 |
3 |
4 |
| 5 |
6 |
7 |
8 |
9 |
10 |
11 |
| 12 |
13 |
14 |
15 |
16 |
17 |
18 |
| 19 |
20 |
21 |
22 |
23 |
24 |
25 |
| 26 |
27 |
28 |
29 |
30 |
|
|
|
|
|
 |
|
|
| Goto page 1, 2 Next |
 ravindra Post subject: how to retrive admin password if we forgot
|
Wed Feb 28, 2007 5:55 am
Posts: 1
|
| |
 |
Hello friends,
I had forgotten the admin password of vtiger ,so can you please help me to find the password?
|
|
|
|
|
 |
greggster Post subject: how to retrive admin password if we forgot
|
Wed Feb 28, 2007 8:12 am
Posts: 66
Location: San Francisco
|
|
|
|
|
Balduin Post subject: how to retrive admin password if we forgot
Senior Member
|
Wed Feb 28, 2007 11:07 am
Posts: 2898
Location: Berlin
|
| |
|
For security reasons there is no password recovery function available for the CRM system. If an user forgets a password the CRM system administrator is able to set a new password at Settings -> User -> Username. If the password of the administrator has been lost a new password must be created. Follow these steps:
Create a new text file and name it password.php. Include the following code:
<?php
$user_name = 'admin';
$user_password = 'admin';
$salt = substr($user_name, 0, 2);
$encrypted_password = crypt($user_password, salt);
echo $encrypted_password;
?php>
The 3rd line includes the user name of the administrator. If you use a different name at your CRM system you need to change this name in the code accordingly. Save this file to the CRM home directory.
Start the code at your browser by entering the proper URL, e.g. <Your_CRM_Directory>/password.php. An alphanumerical value will be presented, such as for instance sjsu78DjJk. Copy this value.
Open your MySQL database and execute the following instruction:
mysql> update users set user_password ='sjsu78DjJk', user_name ='admin'where id =1
This will set your administrator password to the value
>admin<. You may login with your administrator login name and the admin password. Do not forget to delete the password.php and to issue a new password for the administrator.
By the way, this instruction set was part of the vtiger Wiki but someone deleted it. It will be part of the FAQ section of the new vtiger CRM book coming out shortly after the v5.0.3 release. You may watch the progress at http://blog.vtiger-handbuch.de/
_________________
http://www.crm-now.de --> professional vtiger CRM based SaaS for Europeans
http://www.illuminetic.com--> professional vtiger CRM based SaaS for USA
http://www.vtigerserver.com --> sophisticated vtiger CRM hosting
|
|
|
|
rolandm Post subject: how to retrive admin password if we forgot
|
Wed May 23, 2007 12:51 pm
Posts: 21
|
| |
|
I don't have the ability to change out a user's password in my admin screen for Settings>User> and then I click on edit user from the icon, right? When I do that, I can edit everything EXCEPT the password. Am I looking in the wrong place?
Running on 5.0.0 here, having upgraded to 5.0.2 and had a very unsuccesful go of it. Seems there were some bugs in what was going on.
|
|
|
|
rolandm Post subject: how to retrive admin password if we forgot
|
Wed May 23, 2007 5:19 pm
Posts: 21
|
| |
|
| I see what I was doing wrong ... I was clicking on the edit user icon, as opposed to clicking on the username ... it shows up there.
|
|
|
|
zoomsolution Post subject: Re: how to retrive admin password if we forgot
|
Fri Jun 15, 2007 6:20 pm
Posts: 32
|
| |
|
There is a slight typo in the above post.
<?php
$user_name = 'admin';
$user_password = 'admin';
$salt = substr($user_name, 0, 2);
$encrypted_password = crypt($user_password, salt);
echo $encrypted_password;
?>
You also need to be sure to make the file chmod 755 (word executable)
This works for vtiger CRM 5.0.3.
|
|
|
|
zoomsolution Post subject: Re: how to retrive admin password if we forgot
|
Fri Jun 15, 2007 7:03 pm
Posts: 32
|
| |
|
Also for vtiger CRM 5.0.3 the correct command is...
update vtiger_users set user_password ='BLALAAAHPASSWORDINSERT', user_name ='admin'where id =1
|
|
|
|
| |
