Accidentally started aleph as "root": blank page in Web; missing z66/z67

• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
We cannot access the web pages on the test server after applying the latest service packs. We backed them off and discovered that we had restarted everything as root instead of aleph. We shut it down and restarted as aleph. The permissions all appear correct now, but we can only see the http://.../F?func=find-b-0 page and nothing else.

http://.../F?func=find-d-0 gives a blank page, for example.

I cant get to the pc server with the GUI client on the test server either. It just tells me that it can't connect that Password not verified on connectable hosts. If I login as ALEPH, it will log in but the "Library is not accessible"

z67 and z66 only have the user Aleph in them on the test server. I don't know why, but

abc50@ALEPH18> select * from z67;
**** Hit return to continue ****
Z67_REC_KEY Z67_L Z67_S Z67_FUNC Z67_SUB_FUNC Z
-------------- ----- ----- -------------------- -------------------- -
ALEPH 0000 ABC50 ABC50 PASSWORD GLOBAL Y
ALEPH 0001 ABC50 ABC50 PROFILE GLOBAL Y
2 rows selected.

abc50@ALEPH18> select count(*) from z66;
**** Hit return to continue ****
COUNT(*)
----------
1
1 row selected.

But then Aleph can't access the data in the gui either. "Library not accessible"

Resolution:
I suggest that you:

1. run p_file_03 on the Production server to export the $pw_library z66 and z67 (specifying "Go" as the "Procedure to Run").
2. ftp the z66.seqaa and z67.seqaa from the $pw_library/files directory on Prod to the $pw_library/files directory on Test.
3. run p_file_04 on Test to import the z66 and z67 into Oracle (specifying "Replace" as the "Procedure to Run").

[From site:] It is working now. This can be closed.

• Article last edited: 10/8/2013