Password Removal

[Nancy Palmquist]

Harold wrote:
> Hi,
>
> Somehow I created a password in input.prc.  How does one remove the 
> password?  Think I will save your reply so that I will know how to remove 
> it if it happens again.
>
> Thanks in advance
>
> Harold
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>   
Harold,

If you saved the file in ASCII, you can remove it with an editor.  If it 
is encrypted, it is very difficult.

Case 1 - it is ASCII.  go to the file in the OS, open it with a text 
editor.  Remove the last part of line one.

Here is the begining of a file with a password:

::in(20,*);le(65);lf(65);ld(20);fd(6);fe(2);lo(1)=",";fx(15);ga(40);gb(40)::hCsquFJk"%?x2]|u:
::le=mid(10,"1","61");lf=mid(10,"62","160");dl=mid(8,"1","6"):
::ty(15,*);tz(3,*);ck(1,*);nr(7,.0)=@RN:
:2 gt "":dd(25,*)="Attention
"<2:
:6 ne "UNK" and 6 gt "":de(45,*)="POLICY NO.
"<6:
:9 ne "UNK" and 9 gt "":df(25,*)="TIME OF LOSS
"<9:
:35 ne "UNK" and 35 gt "":ca(45,*)="DRIVER(s)   
"<35:
:37 ne "UNK" and 37 ne "SAME AS INSURED" and 37 GT "":cb(80,*)="  
"<37:

see the stuff at the end of line one.

remove everything between the colons - including the colons so it looks 
like this:

::in(20,*);le(65);lf(65);ld(20);fd(6);fe(2);lo(1)=",";fx(15);ga(40);gb(40):
::le=mid(10,"1","61");lf=mid(10,"62","160");dl=mid(8,"1","6"):
::ty(15,*);tz(3,*);ck(1,*);nr(7,.0)=@RN:
:2 gt "":dd(25,*)="Attention
"<2:
:6 ne "UNK" and 6 gt "":de(45,*)="POLICY NO.
"<6:
:9 ne "UNK" and 9 gt "":df(25,*)="TIME OF LOSS
"<9:
:35 ne "UNK" and 35 gt "":ca(45,*)="DRIVER(s)   
"<35:
:37 ne "UNK" and 37 ne "SAME AS INSURED" and 37 GT "":cb(80,*)="  
"<37:

I usually start processes with a comment. then just remove line 1 
entirely and you will get the same result.

Case 2)  The process is encrypted.  You need to try obvious passwords, 
such as "Y", "N", (just enter), "password" and any others you have.  
Maybe you will get lucky.  If this happened to all your tables, you 
changed the SITE PASSWORD on the system and just need to restore that as 
before.  It is stored in the /etc/default/fppath file on a *NX system.  
It is stored on the fppath file in the C:/ (root of the main drive set 
it PFDATA on DOS system)

ALWAYS make a copy of these files if you set a site password.  Always 
note the site password on paper, seal in envelope and put in a safe 
place, just in case.

FINALLY, I always suggest you set a site password on a development 
system.  It will then assign the same frickin password to each and every 
table.  No way to accidentally set the password to something else.  If 
your programming is internal, this is usually no problem.  The password 
is intended to protect processing when you move it to another system.

Others on this list - will argue you should never set it.  This 
suggestion always starts a rant.  So enjoy the fireworks.  I stick to my 
guns.  Since the first time, I hit this issue, I have never had any 
problem and I develop for many, many customers.  I always assign a 
password, the only exception is when I do not own the processing, but am 
just helping with debugging.

You can assign a different password to different development - there is 
a environment variable to do it.

FINALLY, for a fee fpTech will remove passwords.  This would be after 
all else fails.

Nancy

-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com