uploaded users but they cant login in until I re-enter PWD

A forum where issues related to the DataPort utility can be discussed.
Post Reply
brick
Ensign (ENS)
Ensign (ENS)
Posts: 12
Joined: Fri Aug 06, 2010 10:39 am

uploaded users but they cant login in until I re-enter PWD

Post by brick » Wed Oct 20, 2010 11:28 am

using this method discussed here "Re: Any way to add 100's of users to existing groups" I uploaded my users and their data imcluding passwords, but unless i re-enter the password by hand in the administration interface they can't login in. Its like the password did not get set on the original upload. How can i see or tell whats going on. The users are there when i serach for them in the administration interface but the passwords dont seem to work. Help please.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: uploaded users but they cant login in until I re-enter PWD

Post by jmestep » Wed Oct 20, 2010 1:01 pm

You can look in the database and it will show something in the field. We have run into trouble in the past where passwords have been imported in bulk from somewhere and have had to trim beginning/ending spaces out of them.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

brick
Ensign (ENS)
Ensign (ENS)
Posts: 12
Joined: Fri Aug 06, 2010 10:39 am

Re: uploaded users but they cant login in until I re-enter PWD

Post by brick » Tue Nov 02, 2010 3:16 pm

jmestep wrote:You can look in the database and it will show something in the field. We have run into trouble in the past where passwords have been imported in bulk from somewhere and have had to trim beginning/ending spaces out of them.
Judy when i query the ac_UserPasswords table the passwords are not human readable so how do i tell if there is a problem with the content of the password field. for example with something like this Z2UXkMbxR3XkShcVCZ7NHOdlNIC3Fz5V2A== how can I tell.

thanks for you response

Brick

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: uploaded users but they cant login in until I re-enter PWD

Post by jmestep » Wed Nov 03, 2010 6:50 am

I think I posted the wrong info- I had to put a trim() on the username field because of spaces. You could try that on the password field, but that might not be the problem. The problem could be the encryption method you used on the passwords before you uploaded them-you didn't specify in this post where the data came from.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

brick
Ensign (ENS)
Ensign (ENS)
Posts: 12
Joined: Fri Aug 06, 2010 10:39 am

Re: uploaded users but they cant login in until I re-enter PWD

Post by brick » Wed Nov 03, 2010 7:40 am

Judy, these user records and unencrypted passwords came from a csv that I uploaded with the dataport tool. I dont know how they got encrypted. I guess its the default on the field maybe? What do you think the problem is now that you have this additional info.

thanks

Brick

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: uploaded users but they cant login in until I re-enter PWD

Post by jmestep » Wed Nov 03, 2010 4:43 pm

Well, I'm out of ideas.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
s_ismail
Commander (CMDR)
Commander (CMDR)
Posts: 162
Joined: Mon Nov 09, 2009 12:20 am
Contact:

Re: uploaded users but they cant login in until I re-enter PWD

Post by s_ismail » Thu Nov 04, 2010 6:39 am

I think you need to make sure when exporting users in your CSV file then no spaces are added in password fields.

brick
Ensign (ENS)
Ensign (ENS)
Posts: 12
Joined: Fri Aug 06, 2010 10:39 am

Re: uploaded users but they cant login in until I re-enter PWD

Post by brick » Thu Nov 04, 2010 7:19 am

Yea i think that has to be where the problem is/was i'll try and run trim against the db field and see if that helps.

thanks all.

Brick

Post Reply