VERY IMPORTANT!! PLEASE HELP!! Loginproblems...

[gryllz]

Hello,

my name is Chris and I installed SugarCRM Fast Stack CE in my firm. Everything went fine since today. Today I wanted to start Sugar again, but nothing happened. I can't login!! I don't know why, but my account doesn't work anymore?? Does anyone know, what's the problem. I don't want to install it again, because I already added a lot of data!!
Could someone PLEASE help me? It's very urgent, because it have to run in 2 days...

Thx & best regards,
Chris

[andopes]

Hi Chris

When you fill in username and password field and click on Login does SugarCRM redirect to login page without any error message?

If this is the scene so you should edit the config.php and look for session_dir.

Let us know the value.

Regards

[gryllz]

First, thx for your quick reply! ;-)

There is an errormessage, which is informing me that I have to login with a valid username or password.
So what do you think? I have to say that I didn't change any setting, so I don't know if I have to do something in my config.php. My last action was the setup a mailbox for campaigns...

Best regards,
Chris

[SugarDev.net]

Yeah, something went wrong somewhere..definately.

Go to your database, table users, update the database record which describes your user account with a new password. Remember to md5() it. Good luck.

[gryllz]

Hello,

could you please give me a little more details?? I'm not the biggest computer expert
I think that could be the solution Thx in advance!

Chris

[andopes]

Using the phpMyAdmin go to the database linked to SugarCRM and run this sql query:

UPDATE users SET user_hash = MD5(user_name);

It will update the password to the username of the users.
For example, after running this command the password for 'max' is 'max'.

Kind regards

[gryllz]

Thank you, everything's working again!!

Thx, thx & thx a lot!!

[sidh2111]

Hi All,

I am trying to build the import functionality in users module in sugarCE4.5.1i MSSQL.But when I import the records in users table the password goes as it is defined if the csv file as it is it is not converted into md5 format. Because of this I am not able to login into the application with the user id and password of the imported user.So can any1 suggest some solution on this.

Thanks
Sid