vtiger

[nsteadman]

I have completed the install but when I try to login it keeps saying "You must specify a valid username and password."

1. I changed the password during the initial installation
2. I then logged into my cpanel, phpmyadmin, and viewed the user table. The username "admin" was there, but the password was a generated one with a combination of letters of numbers.
3. I tried that password, still didn't work
4. I changed the password in mysql to the original one I set up during the installation, still can't login
5. I even changed the password to admin and tried again, but still I can't login.

using vtiger_CRM_4_2_3.tar.gz

[nsteadman]

Can anyone help?

[arivera]

Hi, I hope this helps...

I faced the same problem but then I saw that changing the password logged in with another language than English (in my case, in Spanish), doesn't work...

Try to login in English, change the user's password and then you will be able to login with the new password.

Good luck!

[TNE]

Hi

I think you mistakenly forget the username/password to tiger.
Please try to paste these values into vtiger_users table and login with admin/admin. A simple update vtiger_users set user_password='adpexzg3FUZAk', user_hash='21232f297a57a5a743894a0e4a801fc3', confirm_password='adoY/6Mlw8kqg' will do.

userpassword:adpexzg3FUZAk
userhash:21232f297a57a5a743894a0e4a801fc3
confirm password:adoY/6Mlw8kqg

[indigoleopard]

Hi Sushi!
You WILL mind your language over here. Your mastery in the area, I am sure, can be put to better use.

Your pain is understandable. There is a proper manner of posting an issue and asking for clarifications/questions. Imagine someone barge into your house and start abusing you for something that may/may not actually be an issue. Do you really think that by asking you a query in a similar manner to the one you have, you will be giving an answer, forget even a placatory one?

vtiger community is based on mutual respect and everyone is respected and held close to heart.

I am deleting your post as a warning.
I am sure we will get to see better posts from you.
I know things seem tough for you but pl. try and put things politely.

Richie

[zoomsolution]

Thanks TNE!

You are correct, the fastest way to update your password if you forget is to edit the MYSQL database file. I tried a number of other things and then this finally worked. Thanks to another posting!

1. in cpanel open up phpMyAdmin
2. Select your database
3. Search for the keyword "users" or "vtiger_users"
4. Edit the field user_password='adpexzg3FUZAk'
5. Edit the filed user_hash='21232f297a57a5a743894a0e4a801fc3'
6. Edit the filed confirm_password='adoY/6Mlw8kqg'
7. login with admin/admin

This worked for me on vtigerCRM 5.0.3.

[agcilantro]

zoomsolution wrote: Thanks TNE!

You are correct, the fastest way to update your password if you forget is to edit the MYSQL database file. I tried a number of other things and then this finally worked. Thanks to another posting!

1. in cpanel open up phpMyAdmin
2. Select your database
3. Search for the keyword "users" or "vtiger_users"
4. Edit the field user_password='adpexzg3FUZAk'
5. Edit the filed user_hash='21232f297a57a5a743894a0e4a801fc3'
6. Edit the filed confirm_password='adoY/6Mlw8kqg'
7. login with admin/admin

This worked for me on vtigerCRM 5.0.3.

Do I need to put admin in the user_name field?
I tried this and was still unable to get past the login. I got the same message , You must specify a valid username and password.
When I put these values in phpmyadmin do I put them in the default field? Do I then have to run a query or generate php code?

Thanks, Agcilantro

[zoomsolution]

The username field does not need to be updated. Just make sure that the userid is the same that is the one for the ADMIN. It should be a userid that is 0 or 1 or a low number.

[agcilantro]

zoomsolution wrote: The username field does not need to be updated. Just make sure that the userid is the same that is the one for the ADMIN. It should be a userid that is 0 or 1 or a low number.
Thanks for the speedy answer zoom.

here is a copy of the table from mysql:

Field Type Collation Attributes Null Default Extra Action
id int(11) No auto_increment Change Drop Primary Index Unique Fulltext
user_name varchar(20) latin1_german2_ci No admin Change Drop Primary Index Unique Fulltext
user_password varchar(30) latin1_german2_ci No adpexzg3FUZAk Change Drop Primary Index Unique Fulltext
user_hash varchar(32) latin1_german2_ci No 21232f297a57a5a743894a0e4a801fc3 Change Drop Primary Index Unique Fulltext
cal_color varchar(25) latin1_german2_ci Yes #E6FAD8 Change Drop Primary Index Unique Fulltext
first_name varchar(30) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
last_name varchar(30) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
reports_to_id varchar(36) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
is_admin varchar(3) latin1_german2_ci Yes 0 Change Drop Primary Index Unique Fulltext
currency_id int(19) No 1 Change Drop Primary Index Unique Fulltext
description text latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
date_entered timestamp ON UPDATE CURRENT_TIMESTAMP No CURRENT_TIMESTAMP Change Drop Primary Index Unique Fulltext
date_modified timestamp No 0000-00-00 00:00:00 Change Drop Primary Index Unique Fulltext
modified_user_id varchar(36) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
title varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
department varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
phone_home varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
phone_mobile varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
phone_work varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
phone_other varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
phone_fax varchar(50) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
email1 varchar(100) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
email2 varchar(100) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
yahoo_id varchar(100) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
status varchar(25) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
signature varchar(250) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
address_street varchar(150) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
address_city varchar(100) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
address_state varchar(100) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
address_country varchar(25) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
address_postalcode varchar(9) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
user_preferences text latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
tz varchar(30) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
holidays varchar(60) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
namedays varchar(60) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
workdays varchar(30) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
weekstart int(11) Yes NULL Change Drop Primary Index Unique Fulltext
date_format varchar(30) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
hour_format varchar(30) latin1_german2_ci Yes am/pm Change Drop Primary Index Unique Fulltext
start_hour varchar(30) latin1_german2_ci Yes 10:00 Change Drop Primary Index Unique Fulltext
end_hour varchar(30) latin1_german2_ci Yes 23:00 Change Drop Primary Index Unique Fulltext
homeorder varchar(255) latin1_german2_ci Yes HDB,ALVT,PLVT,QLTQ,CVLVT,HLT,OLV,GRT,OLTSO,ILTI,MNL,OLTPO,LTFAQ Change Drop Primary Index Unique Fulltext
activity_view varchar(25) latin1_german2_ci Yes Today Change Drop Primary Index Unique Fulltext
lead_view varchar(25) latin1_german2_ci Yes Today Change Drop Primary Index Unique Fulltext
imagename varchar(250) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
deleted int(1) No 0 Change Drop Primary Index Unique Fulltext
defhomeview varchar(100) latin1_german2_ci Yes NULL Change Drop Primary Index Unique Fulltext
confirm_password varchar(30) latin1_german2_ci No adoY/6Mlw8kqg

There was nothing originally in the user name field so i put admin in. So I should take that out?
Thanks again for your help,
AG

[zoomsolution]

Make sure to select the vtiger_users field inside phpmyadmin and then click on the the SQL query their should be a small icon at the bottom of the window that says "browse" next to "edit" that looks like a pencil. After you click "user_password" and browse their will be a table with all the user passwords and the top one is most likely your ADMIN click on that and then edit entry.

with the

4. Edit the field user_password='adpexzg3FUZAk'
5. Edit the filed user_hash='21232f297a57a5a743894a0e4a801fc3'
6. Edit the filed confirm_password='adoY/6Mlw8kqg'

SELECT `user_password`
FROM `vtiger_users`