10 Replies Latest reply on Oct 14, 2015 2:16 PM by Glauber Ribeiro

Tabcmd 9.0 can no longer change an existing users password

Richard Thorne Apr 25, 2015 12:20 AM

In previous releases of Tabcmd you were able to use the "Tabcmd createusers" command to change an existing users password. Now when I try doing that I receive the following error "Update of local site user requires empty or matching password (errrorCode=10055)"

This a major problem for us since we use local authentication and have scripts setup to manually add users and reset password via tab command. Anyone know of a work around besides the Rest API?

1. Re: Tabcmd 9.0 can no longer change an existing users password

Glauber Ribeiro Apr 29, 2015 2:28 PM (in response to Richard Thorne)

Yikes, this will cause us problems too. Have you tried the REST API?
Like Show 0 Likes(0)

Actions
2. Re: Tabcmd 9.0 can no longer change an existing users password

Richard Thorne Apr 29, 2015 3:47 PM (in response to Glauber Ribeiro)

Yeah the rest api works however we were not expecting the change so we were not familiar with or prepared to use the api calls. Also tabadmin works and you could script it but it is much slower. We are in the process of moving to the rest api now. We did open a ticket and the response it is unsupported.
Like Show 0 Likes(0)

Actions
3. Re: Tabcmd 9.0 can no longer change an existing users password

Toby Erkson Apr 30, 2015 6:33 AM (in response to Richard Thorne)

What exactly is "unsupported"? The API or "Tabcmd createusers" or ???
Like Show 0 Likes(0)

Actions
4. Re: Tabcmd 9.0 can no longer change an existing users password

Richard Thorne Apr 30, 2015 7:26 AM (in response to Toby Erkson)

The use of Tabcmd to change a users password using the "createusers" comamnd
Like Show 0 Likes(0)

Actions
5. Re: Tabcmd 9.0 can no longer change an existing users password

Glauber Ribeiro Oct 14, 2015 12:58 PM (in response to Richard Thorne)

As expected, this is hurting us now.

Unfortunately the REST API is still very messy for doing password changes.
Like Show 0 Likes(0)

Actions
6. Re: Tabcmd 9.0 can no longer change an existing users password

Glauber Ribeiro Oct 14, 2015 1:04 PM (in response to Glauber Ribeiro)

I created an "idea" for the functionality to be restored. Please be so kind and upvote.
Like Show 0 Likes(0)

Actions
7. Re: Tabcmd 9.0 can no longer change an existing users password

Richard Thorne Oct 14, 2015 1:07 PM (in response to Glauber Ribeiro)

I agree the Rest API leaves a lot to be desired especially for someone that is brand new to API calls. However I was able to get it to work and we have been using that ever since. I use PHP to do the calls and would be happy to help ya out wherever I can.
Like Show 0 Likes(0)

Actions
8. Re: Tabcmd 9.0 can no longer change an existing users password

Glauber Ribeiro Oct 14, 2015 1:11 PM (in response to Richard Thorne)

Thanks, i appreciate the offer!

The main problem i see in the API is there is no good way to convert an user login id ("name" in the database) to the new UUID-type IDs you need to act on the account. How did you solve that? We have several hundreds of users in the database, and the prospect of scanning the whole user list to find one account doesn't make me happy.
Like Show 0 Likes(0)

Actions
9. Re: Tabcmd 9.0 can no longer change an existing users password

Richard Thorne Oct 14, 2015 2:02 PM (in response to Glauber Ribeiro)

You can actually gather the UUID via Postgresql schema table is public.users users. The column name is "user.luid". The luid is unique for each user and does not change unless the user is removed from the system. We join "public.users users" and "public.licensing_roles" to "public.system_users system_users" make a view that has all the important user information i.e. userid to UUID "luid". I can dig up the exact syntax if you need it. The rest is up to you how to use that within your script.

We export it and house it in a separate DB/table and that new table is what I use to query anytime a user needs a password reset or requests a new login for the system.
Like Show 0 Likes(0)

Actions
10. Re: Tabcmd 9.0 can no longer change an existing users password

Glauber Ribeiro Oct 14, 2015 2:16 PM (in response to Richard Thorne)

That's funny. I just implemented exactly that. I already had a REST servlet of my own to collect user information and return XML, and it was trivial to add the LUID to it. I think doing it this way, I have a fighting chance of replacing the tabcmd code I have with REST within a day or two. (I don't call tabcmd from the command line, I reimplemenented the tabcmd API without tabcmd's single-threadness and slowness.)

They say great minds think alike - we must be great.

It does annoy me. It's such a simple thing for them to implement a lookup call in their REST interface. They have such a almost-great product, and keep missing the trivial but important stuff.

Not to mention the general sloppiness of the thing too - how many unique user ids do we need? We had 2, now we have 3. How long until there are 4?
Like Show 1 Likes(1)

Actions