I need to maintain the Tools system configuration ttiex3101m000, but I don't know the password I have tried with Yi984 ("default Baan password"), but It seems be changed..


Does anybody know how to recover it??

thanks

JP

Hi JP

I do not know of a way to recover the password, but I do know how to clear it:

1. bdbpre6.1 -t"|" -N ttadv043 -C 000
2. SAVE THE FILE tttadv043000.S SOMEWHERE VERY SAFE!
3. Recreate the file containing only 0|||| (A zero, followed by four pipe symbols)
4. Place this file in it's own directory
5. bdbpost6.1 -R -t"|" -D.

Now you won't have a password, and you can use ttadv0146m000 to assign a new one. Then modify the tools configuration, and afterwards post the saved tttadv043000.S again. This table contains three encrypted passwords, and I'm not entirely sure of which field is what password, therefore it is better to restore the old contents.

If memory servers correctly, you can also go into change password for system config, enter blank for the old password and then whatever the new password you want. This is if it had been not initialized before and is empty. I believe the other session requires a non blank password. You may want to try that first before reseting the encrypted password. May or may not work, but worth a try.

By printing Current Table Definitions of ttadv043 you can find out that the password for system configuration is stored in ttadv043.cpsc.
If so: Why don't you try this?

- Make a table-dump of ttadv043
- Save it well!!!
- Run ttaad4100 for ttadv043 and empty ttadv043.cpsc.
- Run ttadv0146m000 to assign a new password.

I have never tried it out but I think that should work.

The ttaad4100 route won't work. As soon as you enter the table ttadv043 and try to "Y"es on the command prompt, the following appears (on a Dutch system that is ;) ):

Try your password for ttaad4100 again. It seems like baan is asking for it after entering a table from ttadv.

Nope. Just tried it. As far as I know, it is asking for the Tools password, which is one of the best guarded passwords in Baan world.

Hi Nico,

I just logged on as ROOT and a password wasn't asked.

GN

Nice! Another security hole. :D Thanks GN.

Referring to my first reply, it just struck me that it poses a problem: the pipe symbol could be part of the encrypted string! :o So, it would be better to dump the table as fixed length. Sorry for this mistake! (Nobody's perfect)

When you are able to hook up with MS Access and ODBC to ttadv043, then clearing that password field should be no problem. Access won't ask for a passsword. If you're using TBase, well, hm... that's bad luck then...