Lost TAC password, admin@company.com disabled

I accidentally clicked on "Forgot Your Password?" on the tac page, and TAC changed my password and I haven't received mail.
The account admin@company.com is disabled.
Other than having another user who has permissions set my password to something I know, what alternatives are there? I take it the TAC passwords are stored encrypted in an h2 database stored in WEB-INF/database/, is that correct, and would it be possible to create a new user, set a password to someone else's password, or anything like that?
Thanks
5 REPLIES
Moderator

Re: Lost TAC password, admin@company.com disabled

Hi,
I accidentally clicked on "Forgot Your Password?" on the tac page, and TAC changed my password and I haven't received mail.

If you forgot your connection password to Talend Administration Center, you can click the Forgot your password? button. An email will be sent to you, holding a link to a password resetting form.
to activate this option and display the button, you have to activate an SMTP protocol in the Configuration page of Talend Administration Center. For more information on how to configure the SMTP protocol.
Please see document TalendHelpCenter:Resetting your password for details
# Password to access to db config page in the web-app:
database.config.password=admin
in the file:
<Tomcat installation path>/webapps/org.talend.administrator/WEB-INF/classes/configuration.properties
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Lost TAC password, admin@company.com disabled

Thanks, the page you referred me to is the kind of thing I was looking for. Meanwhile, I got my password reset by a a co-worker so no urgency but:
I do have the password for the H2 database, which I think is what it's talking about. But what client do I use to get in and issue that update command. Does Talend's Enterprise software include a client? Or is it the customer's choice to find jdbc software they like and set it up?

Below is what was on the web page that I'm asking about:
If you have not configured an email server, you can execute an SQL statement to set the user password to admin again.
In the database, execute the following statement:
UPDATE `user` set `password`=0x21232F297A57A5A743894A0E4A801FC3 where id =<userID>;
where 0x21... corresponds to the encrypted password admin.
Note that you can find the ID (number) corresponding to the user for which you want to edit the password by executing this statement:
select id, login from user;
With this new password, log in to Talend Administration Center again and define a new customized password in the Users page. For more information about the Users page, see the section called ?User settings?.
Moderator

Re: Lost TAC password, admin@company.com disabled

Hi,
I do have the password for the H2 database, which I think is what it's talking about. But what client do I use to get in and issue that update command. Does Talend's Enterprise software include a client? Or is it the customer's choice to find jdbc software they like and set it up?

You can get a client from http://www.h2database.com/html/main.html. You can change the password in user table when login.(With a H2 database file path and password "tisadmin" to login and then you can do the second step
mentioned in document Resetting your password Smiley Frustratedet the password to admin again (without SMTP protocol))
In addition, if you don't change it before, the H2 database file path is located in <webservice Installation path>\webapps\org.talend.administrator\WEB-INF\database. (talend_administrator.h2.db)
Login h2 database: path (webapps\org.talend.administrator\WEB-INF\database) password(tisadmin).
Hope it will be helpful for you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Lost TAC password, admin@company.com disabled

Hi,
Am also facing the same issue, accidentaly selected the forgot password link. I havent received my password.
As suggested here i tried H2 database to reset the password. I have downloaded the H2 from the link provided in this post. I have password and the path but i dont know how to use it. Our talend is inj Linux box.
Can you guys just guide me to reset the password.?
Thanks
Arul
Moderator

Re: Lost TAC password, admin@company.com disabled

Hi,
Please open a ticket on Talend Support Portal, our support colleagues will schedule a webex with you to give a remote assistance.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.