By: hudson solomon user 13 Aug 2015 at 4:28 a.m. CDT

18 Responses
hudson solomon gravatar
i have added 10 users using import people options(using .xls file). The xls file contains username,firstname,lastname,email,password. After that i try to login with new user it says invalid username and password. So again i login with admin user and change the password of new user.After that only i can login with new user. But i already gave username and password in .xls file.

By Mohib Zico staff 13 Aug 2015 at 4:44 a.m. CDT

Mohib Zico gravatar
>> After that i try to login with new user it says invalid username and password. 'oxauth.log' ( location: /opt/tomcat/logs/ ) will tell you the reason of this failure.

By hudson solomon user 14 Aug 2015 at 3:50 a.m. CDT

hudson solomon gravatar
Thanks for your reply, I found some text from the logs like "Found 1 entries" but below that "Failed to authenticate". I don't know why it comes because i already imported users successfully. Is there any additional steps after importing users?

By Mohib Zico staff 14 Aug 2015 at 4 a.m. CDT

Mohib Zico gravatar
Hudson, Would you mind to share your xls file ( may be you can change the data there but don't change format or row/column name ); it will help us to check if there is really any problem with this bulk upload. There are bunch of other ways to import users: 1. Cache Refresh: You can connect to your backend Active Directory/LDAP server to import / sync users in real time. Cache Refresh [doc](http://www.gluu.org/docs/articles/cache-refresh/) 2. Using SCIM API: Doc available [here](http://www.gluu.org/docs/articles/scim-client/) 3. Or restore LDAP ldif directly into Gluu Server. But in this case, you need to introduce yourself with the LDAP server tree which is inside Gluu Server.

By Aliaksandr Samuseu staff 14 Aug 2015 at 1:45 p.m. CDT

Aliaksandr Samuseu gravatar
Hi, Hudson. Were passwords you put in this xls in clear-text format, or were they somehow encoded? If it was the latter, then using what encoding algorithm? But I agree with Zico, it would have helped a lot if you would shared your xls with us for testing.

By Aliaksandr Samuseu staff 14 Aug 2015 at 4:01 p.m. CDT

Aliaksandr Samuseu gravatar
Btw, while testing this feature we've discovered that all users imported with its help are inactive, i.e. even if you'll set new passwords for them through web UI controls, you won't be able to log into Gluu with them until you set a certain property of user object to "active". And it seems it cannot be done through web UI, only by directly modifying internal LDAP database. Wasn't it a problem for you, too?

By hudson solomon user 17 Aug 2015 at 2:04 a.m. CDT

hudson solomon gravatar
Hi samuseu,there is no password encoded format in .xls file. I upload using the clear text format like(eg:'admin'). is there any way to active a new users without changing their password?

By hudson solomon user 17 Aug 2015 at 5:26 a.m. CDT

hudson solomon gravatar
Hi samuseu,how can i attach my .xls sheet with this post?

By Mohib Zico staff 17 Aug 2015 at 5:49 a.m. CDT

Mohib Zico gravatar
Hi Hudson, Community users can't attach files but you can send your xls file to us through 'support@gluu.org'. Please add your ticket number and name in email subject. Kind regards, Zico

By hudson solomon user 18 Aug 2015 at 5:32 a.m. CDT

hudson solomon gravatar
Hi Mohib, I have send a mail to support@gluu.org with attachment of xls sheet.Please find out.

By Mohib Zico staff 18 Aug 2015 at 5:50 a.m. CDT

Mohib Zico gravatar
We haven't received any. If you want you can re-send that to me directly with 'zico@gluu.org' or 'mohib@gluu.org'. Kind regards, Zico

By Mohib Zico staff 18 Aug 2015 at 6:30 a.m. CDT

Mohib Zico gravatar
Hudson, Received your attachment. Thanks a bunch! Seems like all users have same email address. Can you provide unique email addresses to each of them? And then: 1. Upload the new xls. 2. If uploading is successfully completed then.. 3 Check if these users are available in Gluu Server or not. You can search for people with [oxTrust](http://www.gluu.org/docs/admin-guide/user-management/#people). 4. If you get all people then try to log into Gluu Server with any user's credential. 5. If you fail, let's check oxauth.log. Better tail -f /opt/tomcat/logs/oxauth.log and try to log into Gluu Server. Let's see how it goes.

By hudson solomon user 18 Aug 2015 at 6:34 a.m. CDT

hudson solomon gravatar
Hi Mohib, I forward a mail to zico@gluu.org.Please find the attachment.

By hudson solomon user 18 Aug 2015 at 7:06 a.m. CDT

hudson solomon gravatar
Hi Mohib, Still i am standing in the same error. This is my error log from oxauth.log 2015-08-18 12:03:30,450 INFO [org.xdi.oxauth.auth.Authenticator] Authentication failed for 'client1' 2015-08-18 12:03:30,464 TRACE [org.xdi.oxauth.service.ClientService] Get client from cache by Dn 'inum=@!DE68.082C.9BB3.4E6E!0008!BC06.9C5C,ou=clients,o=@!DE68.082C.9BB3.4E6E!0001!E02F.AFA3,o=gluu' 2015-08-18 12:03:30,464 DEBUG [org.xdi.oxauth.service.ClientService] Found 1 entries for client id = @!DE68.082C.9BB3.4E6E!0008!BC06.9C5C 2015-08-18 12:03:30,469 TRACE [org.xdi.oxauth.service.ClientService] Get client from cache by Dn 'inum=@!DE68.082C.9BB3.4E6E!0008!BC06.9C5C,ou=clients,o=@!DE68.082C.9BB3.4E6E!0001!E02F.AFA3,o=gluu' 2015-08-18 12:03:30,469 DEBUG [org.xdi.oxauth.service.ClientService] Found 1 entries for client id = @!DE68.082C.9BB3.4E6E!0008!BC06.9C5C 2015-08-18 12:03:30,470 TRACE [org.xdi.oxauth.service.ClientService] Get client from cache by Dn 'inum=@!DE68.082C.9BB3.4E6E!0008!BC06.9C5C,ou=clients,o=@!DE68.082C.9BB3.4E6E!0001!E02F.AFA3,o=gluu' 2015-08-18 12:03:30,470 DEBUG [org.xdi.oxauth.service.ClientService] Found 1 entries for client id = @!DE68.082C.9BB3.4E6E!0008!BC06.9C5C 2015-08-18 12:03:46,080 TRACE [org.xdi.service.custom.script.CustomScriptManager] Last finished time '8/18/15 12:03 PM' 2015-08-18 12:04:16,080 TRACE [org.xdi.service.custom.script.CustomScriptManager] Last finished time '8/18/15 12:04 PM' 2015-08-18 12:04:46,074 TRACE [org.xdi.service.custom.script.CustomScriptManager] Last finished time '8/18/15 12:04 PM'

By Mohib Zico staff 18 Aug 2015 at 7:33 a.m. CDT

Mohib Zico gravatar
What is the result of 1 - 3 steps? Also this little log won't give any hint. You need to read at least last 1000 lines to get the actual reason.... we do that. :)

By hudson solomon user 18 Aug 2015 at 7:44 a.m. CDT

hudson solomon gravatar
Hi Mohib, First 3 steps have successfully completed as your suggestions above.I share the xls file to (zico@gluu.org )which one last i imported. I read the full log but it seems like previously which i mentioned.

By Mohib Zico staff 18 Aug 2015 at 8:14 a.m. CDT

Mohib Zico gravatar
Alright. Assigning a Gluu Engineer to check this feature's status. Stay tuned!

By hudson solomon user 18 Aug 2015 at 8:16 a.m. CDT

hudson solomon gravatar
Ok Thanks Mohib..

By Mohib Zico staff 24 Aug 2015 at 6:47 a.m. CDT

Mohib Zico gravatar
Thanks Guys. I was also able to reproduce the issue. Created a github issue: https://github.com/GluuFederation/oxTrust/issues/102