We are upgrading 7.1 to 7.6 and previously we used an Oracle database to validate the WebConsole login and that login information would be stored as an encrypted cookie whenever you needed to go to the database - to refresh a synonym, for instance.


The profiles directory in an installation contains a file admin.cfg with a simple list of names that once validated against Oracle will be given admin access. The default is to allow Administration Level: Basic User

admin_id = ifsappreport
BEGIN
  admin_level = SRV
  admin_password = B9F5C3704FE116EE830EC3653886DB1C
END
admin_id = webfocus.admin
BEGIN
  admin_password = 5C5B9D17AA33DBBA
  admin_level = SRV
END
admin_id = PNB\webfocus.admin
BEGIN
  admin_password = 5C5B9D17AA33DBBA
  admin_level = SRV
END

The admin id, ifsappreport, was added by using the following as suggested by IBI.

You can change/ADD your userid/password by doing the following:
 
1. Open a DOS box
2. Navigate to your ibi/srv/wfs/bin  directory
3. Type the following:  edastart -addadmin userid:password SRV

Now I ran the server start from the command line version not the service. This is contained in the Webfocus Server menu

C:\Documents and Settings\All Users\Start Menu\Programs\Information Builders\WebFOCUS 76 Server\Start With Alternative Security Modes\Start Security DBMS

The output in C:\wf76\ibi\srv76\wfs\edaprint.log clearly shows that it has been started in DBMS mode and that the admin id is ifsappreport

07/17/2007 19:08:51 Configured security is 'DBMS' as set by EDAEXTSEC variable
07/17/2007 19:08:51 Please note configured database must be up to ensure proper functionality of
07/17/2007 19:08:51 >  server
07/17/2007 19:08:51 NOT accept trusted connections
07/17/2007 19:08:51 Configured 4 services
07/17/2007 19:08:51 Configured 5 administrators
07/17/2007 19:08:51 creating Workspace Manager memory (PTH)
07/17/2007 19:08:51 shared memory size is 790024 bytes
07/17/2007 19:08:51 NLS Config: Codepage = 437
07/17/2007 19:08:51 NLS Config: Language = AMENGLISH   
07/17/2007 19:08:51 Main Configuration:
07/17/2007 19:08:51   configuration date:                       12/07/2005 11:50:57
07/17/2007 19:08:51   build date:                               06/26/2007 20:41:53
07/17/2007 19:08:51   gen number:                               209
07/17/2007 19:08:51   release:                                  762
07/17/2007 19:08:51   source date:                              06/26/2007 18:26:02
07/17/2007 19:08:51   wf jar seq number:                        129
07/17/2007 19:08:51   wf jar release:                           7.6.2
07/17/2007 19:08:51   build sys:                                Windows NT-5.0 x86 32bit
07/17/2007 19:08:51   support sys:                              Windows
07/17/2007 19:08:51   host name:                                ELECTRA
07/17/2007 19:08:51   server name:                              WebFOCUS 76 Server
07/17/2007 19:08:51   maximum number of adapters:               3
07/17/2007 19:08:51   security:                                 DBMS
07/17/2007 19:08:51   effective server admin:                   ifsappreport
07/17/2007 19:08:51   server admin:                             ifsappreport, webfocus.admin,
07/17/2007 19:08:51 >  PNB\webfocus.admin, userid, johnhammond
07/17/2007 19:08:51   application admin:                        -
07/17/2007 19:08:51   server operator:                          -
07/17/2007 19:08:51   security dbms:                            SQLORA
07/17/2007 19:08:51   security connection:                      WF_IFS
07/17/2007 19:08:51   total maximum queued connections:         10

And later when I try to access the console the login to Oracle is clearly successful since no error message is generated

07/17/2007 19:10:07 disconnect cmrpht000003 tscomid=5,sesid=1
07/17/2007 19:10:08 request by cmrpht000003 to exec <webconsole> u=ifsappreport, wsesid=1
07/17/2007 19:10:15 request by cmrpht000003 to get <wcblank.gif>
07/17/2007 19:10:15 accepting  cmrpht000004 tcp=electra-ext:3826
07/17/2007 19:10:15 request by cmrpht000004 to get <wcblank.gif>
07/17/2007 19:10:15 request by cmrpht000003 to get <wcblank.gif>
07/17/2007 19:27:25 accepting  cmrpht000005 tcp=electra-ext:3887

However when I get into the console and check my console > login status I am clearly not an administrator.

Updated: July 17 19:39:45  
 Security: DBMS  
 User: ifsappreport  
 Administration Level: Basic User  
 Authentication:explicit  
 Total Web Sessions: 1  

I tried various login combinations thinking it may have become case sensitive and with and without the password but to no avail. The id ifsappreport clearly has been validated because it is able to run reports against the password protected Oracle database by using password passthru.

Help!

Has anyone encountered anything like this?

I have now tried starting the server with security off and then going to the Workspace - Access Control - Security Mode and then changing the Security Mode to dbms. It then prompts you to confirm that you can login with the dbms (Oracle) credentials before you reboot. I do this test and it confirms you can you can login.

On confirmation that you wish to change the Security Mode you reboot the Server but when you login and it attempts to go to the administrator page it reports back that you have insufficient server role privilege to look at the page ie I am not being allowed on as an administrator.

To confirm that the admin.cfg that fails in 7.6.2 works in 7.1.3, I copied it back to our working server and recycled and was able to log straight on as ifsappreport with admin rights.

I am going to raise this as a hottrack.

Now I ran the server start from the command line version not the service. This is contained in the Webfocus Server menu

C:\Documents and Settings\All Users\Start Menu\Programs\Information Builders\WebFOCUS 76 Server\Start With Alternative Security Modes\Start Security DBMS

Here is the trace which involves the start up of the server and the attempt to use ifsappreport to log in at the webconsole.

>>> tscom300.trc <<<
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAGEN ) 
 18.41.43 AS r1envget: <EDAGEN> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAGEN ) 
 18.41.43 AS r1envget: <EDAGEN> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAHOME ) 
 18.41.43 AS r1envget: <EDAHOME> contains: <C:\wf76\ibi\srv76\home> 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRIV ) 
 18.41.43 AS r1envget: <EDAPRIV> is not set 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\openlaszlo> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF\lps> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF\lps\server> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF\lps\server\bin\lzc> 
 18.41.43 AS r1fustat: calling stat( C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF\lps\server\bin\lzc ) 
 18.41.43 AS r1fustat: calling GetFileAttributesEx(C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF\lps\server\bin\lzc)
 18.41.43 AS r1fustat: object C:\wf76\ibi\srv76\home\openlaszlo\WEB-INF\lps\server\bin\lzc exists 
 18.41.43 AS r1fustat: done 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( LPS_HOME ) 
 18.41.43 AS r1envget: <LPS_HOME> is not set 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: LPS_HOME=C:\wf76\ibi\srv76\home\openlaszlo 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( CLASSPATH ) 
 18.41.43 AS r1envget: C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Drive
          AS r for JD
 18.41.43 AS r1envget: BC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\oracle\ora92\jdbc\lib;
          AS C:\oracl
 18.41.43 AS r1envget: e\ora92\jdbc\lib\classes12.jar;C:\ibi\srv71\home\etc;
 18.41.43 AS r1envget: message length = 313 
 18.41.43 AS r1strtok: token = 'C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar' 
 18.41.43 AS r1strtok: token = 'C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar' 
 18.41.43 AS r1strtok: token = 'C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar' 
 18.41.43 AS r1strtok: token = 'C:\oracle\ora92\jdbc\lib' 
 18.41.43 AS r1strtok: token = 'C:\oracle\ora92\jdbc\lib\classes12.jar' 
 18.41.43 AS r1strtok: token = 'C:\ibi\srv71\home\etc' 
 18.41.43 AS r1strtok: Input string is NULL 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: CLASSPATH=C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 
          AS 2000 Dri
 18.41.43 AS r1envset: ver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\oracle\ora92
          AS \jdbc\li
 18.41.43 AS r1envset: b;C:\oracle\ora92\jdbc\lib\classes12.jar;C:\ibi\srv71\home\etc
 18.41.43 AS r1envset: message length = 322 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( PATH ) 
 18.41.43 AS r1envget: C:\j2sdk1.4.2_10\jre\bin\client;C:\Program Files\Windows Resource Kits\Tools\;C:\oracle\ora92\bin;C:\Program Files\Oracle\
          AS jre\1.3.
 18.41.43 AS r1envget: 1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Micro
          AS soft SQL
 18.41.43 AS r1envget:  Server\80\Tools\BINN
 18.41.43 AS r1envget: message length = 281 
 18.41.43 AS r1strtok: token = 'C:\j2sdk1.4.2_10\jre\bin\client' 
 18.41.43 AS r1strtok: token = 'C:\Program Files\Windows Resource Kits\Tools\' 
 18.41.43 AS r1strtok: token = 'C:\oracle\ora92\bin' 
 18.41.43 AS r1strtok: token = 'C:\Program Files\Oracle\jre\1.3.1\bin' 
 18.41.43 AS r1strtok: token = 'C:\Program Files\Oracle\jre\1.1.8\bin' 
 18.41.43 AS r1strtok: token = 'C:\WINDOWS\system32' 
 18.41.43 AS r1strtok: token = 'C:\WINDOWS' 
 18.41.43 AS r1strtok: token = 'C:\WINDOWS\System32\Wbem' 
 18.41.43 AS r1strtok: last token = 'C:\Program Files\Microsoft SQL Server\80\Tools\BINN' 
 18.41.43 AS r1strtok: Input string is NULL 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: PATH=C:\j2sdk1.4.2_10\jre\bin\client;C:\Program Files\Windows Resource Kits\Tools\;C:\oracle\ora92\bin;C:\Program Files\Or
          AS acle\jre
 18.41.43 AS r1envset: \1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\
          AS Microsof
 18.41.43 AS r1envset: t SQL Server\80\Tools\BINN
 18.41.43 AS r1envset: message length = 286 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1pathlb: nodbg = TRUE  
 18.41.43 AS r1pathlb: rundir is <bin> 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( PATH ) 
 18.41.43 AS r1envget: C:\j2sdk1.4.2_10\jre\bin\client;C:\Program Files\Windows Resource Kits\Tools\;C:\oracle\ora92\bin;C:\Program Files\Oracle\
          AS jre\1.3.
 18.41.43 AS r1envget: 1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Micro
          AS soft SQL
 18.41.43 AS r1envget:  Server\80\Tools\BINN
 18.41.43 AS r1envget: message length = 281 
 18.41.43 AS r1pathlb: adding to PATH: edahome + rundir (bin) 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\bin> 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: PATH=C:\wf76\ibi\srv76\home\bin;C:\j2sdk1.4.2_10\jre\bin\client;C:\Program Files\Windows Resource Kits\Tools\;C:\oracle\or
          AS a92\bin;
 18.41.43 AS r1envset: C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Syst
          AS em32\Wbe
 18.41.43 AS r1envset: m;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
 18.41.43 AS r1envset: message length = 313 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1furemo: calling remove( ibisnap.log ) 
 18.41.43 AS r1furemo: err#2, No such file or directory 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDATEMP ) 
 18.41.43 AS r1envget: <EDATEMP> is not set 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDAPRINT=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRINT ) 
 18.41.43 AS r1envget: <EDAPRINT> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1secful: create full name for logged on (impersonated) user... 
 18.41.43 AS r1getusr: calling GetUserName 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( QBS9999 ) 
 18.41.43 AS r1envget: <QBS9999> is not set 
 18.41.43 AS r1getusr: returns uidL=14, buf='webfocus.admin' 
 18.41.43 AS r1getdom: calling OpenThreadToken( GetCurrentThread( ) ) 
 18.41.43 AS r1getdom: calling OpenProcessToken( GetCurrentProcess( ) ) 
 18.41.43 AS r1getdom: calling GetTokenInformation( ) 
 18.41.43 AS r1getdom: calling GetTokenInformation( ) 
 18.41.43 AS r1getdom: calling LookupAccountSid( ) 
 18.41.43 AS r1getdom: calling GetComputerName( ) 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( QBS9999 ) 
 18.41.43 AS r1envget: <QBS9999> is not set 
 18.41.43 AS r1getdom: returns domainL=3, buf='PNB' 
 18.41.43 AS r1getdom: calling CloseHandle( h = 00000780 ) 
 18.41.43 AS r1secful: user fullname is 'PNB\webfocus.admin' 
 18.41.43 AS pthsver:  checking admin level and group
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRIV_ADMIN_ID ) 
 18.41.43 AS r1envget: <EDAPRIV_ADMIN_ID> is not set 
 18.41.43 AS pthsverc: validating user 'PNB\webfocus.admin' against admin_id... 
 18.41.43 AS cfgnadmg: get configured administrator info... 
 18.41.43 AS cfgQuery: key 'server_admin_id' not found 
 18.41.43 AS cfgnadmg: admin_id='ifsappreport'
 18.41.43 AS cfgnadmg: admin_password=' '
 18.41.43 AS cfgnadmg: admin_level='SRV'
 18.41.43 AS cfgnadmg: more members left...
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 18.41.43 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 18.41.43 AS cfgnadmg: get configured administrator info... 
 18.41.43 AS cfgnadmg: admin_id='webfocus.admin'
 18.41.43 AS cfgnadmg: decrypting password 
 18.41.43 AS ntdecasc: entered, outLen=49 
 18.41.43 AS ntdecasc: cipher=0
 18.41.43 AS ntdecasc: calling r1strwc2mb(5C5B9D17AA33DBBA) 
 18.41.43 AS ntdecasc: calling ntdecasc() 
 18.41.43 AS ntdecasc: OK 
 18.41.43 AS cfgnadmg: admin_password='5C5B9D17AA33DBBA'
 18.41.43 AS cfgnadmg: admin_level='SRV'
 18.41.43 AS cfgnadmg: more members left...
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 18.41.43 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 18.41.43 AS cfgnadmg: get configured administrator info... 
 18.41.43 AS cfgnadmg: admin_id='PNB\webfocus.admin'
 18.41.43 AS cfgnadmg: decrypting password 
 18.41.43 AS ntdecasc: entered, outLen=49 
 18.41.43 AS ntdecasc: cipher=0
 18.41.43 AS ntdecasc: calling r1strwc2mb(5C5B9D17AA33DBBA) 
 18.41.43 AS ntdecasc: calling ntdecasc() 
 18.41.43 AS ntdecasc: OK 
 18.41.43 AS cfgnadmg: admin_password='5C5B9D17AA33DBBA'
 18.41.43 AS cfgnadmg: admin_level='SRV'
 18.41.43 AS cfgnadmg: more members left...
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 18.41.43 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 18.41.43 AS pthsverc: user 'PNB\webfocus.admin' verified
 18.41.43 AS pthsver:  user 'PNB\webfocus.admin'- authorization Ok
 18.41.43 AS pthtrace: user 'PNB\webfocus.admin' is 'SRV' 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> is not set 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDASHARE=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS pthtst:   calling r1shmopn just to test for shared memory presence 
 18.41.43 AS r1shmope: called to open id=1, size=0 
 18.41.43 AS r1shmope: shared mode 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\share\001> 
 18.41.43 AS r1shmope: file mapping name=Global\C:/WF76/IBI/SRV76/WFS/SHARE/001 
 18.41.43 AS r1shmope: OpenFileMapping(Global\C:/WF76/IBI/SRV76/WFS/SHARE/001) 
 18.41.43 AS r1trcerr: r1shmopen: err#2, The system cannot find the file specified.   
 18.41.43 AS r1shmope: open failed 
 18.41.43 AS r1shmclo: called to remove id=1 
 18.41.43 AS r1shmclo: OK 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDASHARE=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDACS3 ) 
 18.41.43 AS r1envget: <EDACS3> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRIV ) 
 18.41.43 AS r1envget: <EDAPRIV> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDACONF ) 
 18.41.43 AS r1envget: <EDACONF> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\etc\odin.cfg> 
 18.41.43 AS ngReadFl: Use C:\wf76\ibi\srv76\wfs\etc\odin.cfg as config file  
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDACS3 ) 
 18.41.43 AS r1envget: <EDACS3> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRIV ) 
 18.41.43 AS r1envget: <EDAPRIV> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDACONF ) 
 18.41.43 AS r1envget: <EDACONF> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\etc\odin.cfg> 
 18.41.43 AS ngWritFl: Use C:\wf76\ibi\srv76\wfs\etc\odin.cfg as config file  
 18.41.43 AS r1fopen:  calling fopen( C:\wf76\ibi\srv76\wfs\etc\odin.cfg, r ) 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;HTTP Listener 
 18.41.43 AS cfgRead:  NODE = LST_HTTP 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    PROTOCOL = HTTP 
 18.41.43 AS cfgRead:    PORT = 9121 
 18.41.43 AS cfgRead:    CLASS = AGENT 
 18.41.43 AS cfgRead:    SESSION_EXPIRATION = 36000 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;TCP Listener 
 18.41.43 AS cfgRead:  NODE = LST_TCP 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    PROTOCOL = TCP 
 18.41.43 AS cfgRead:    PORT = 9120 
 18.41.43 AS cfgRead:    CLASS = AGENT 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;TCP Loopback Client 
 18.41.43 AS cfgRead:  NODE = LOOPBACK 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    PROTOCOL = TCP 
 18.41.43 AS cfgRead:    CLASS = CLIENT 
 18.41.43 AS cfgRead:    HOST = localhost 
 18.41.43 AS cfgRead:    HTTP_PORT = 9121 
 18.41.43 AS cfgRead:    PORT = 9120 
 18.41.43 AS cfgRead:    SECURITY = IWA 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;FOCUS Database Server 
 18.41.43 AS cfgRead:  NODE = FOCSU 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    PROTOCOL = TCP 
 18.41.43 AS cfgRead:    CLASS = SUSERVER 
 18.41.43 AS cfgRead:    PORT = 9122 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;FOCUS Database Client 
 18.41.43 AS cfgRead:  NODE = FOCSU01 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    PROTOCOL = TCP 
 18.41.43 AS cfgRead:    CLASS = SUCLIENT 
 18.41.43 AS cfgRead:    HOST = localhost 
 18.41.43 AS cfgRead:    PORT = 9122 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;JSCOM3 Listener 
 18.41.43 AS cfgRead:  NODE = JSS 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    PROTOCOL = TCP 
 18.41.43 AS cfgRead:    CLASS = JAVASERVER 
 18.41.43 AS cfgRead:    PORT = 9123 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS cfgRead:   
 18.41.43 AS cfgRead:  ;SMTP mail server client 
 18.41.43 AS cfgRead:  NODE = EMAIL 
 18.41.43 AS cfgRead:  BEGIN 
 18.41.43 AS cfgRead:    SMTP_HOST = HYDRAVS01 
 18.41.43 AS cfgRead:    SENDER_EMAIL = testwebfocuserror@fleet-support.co.uk 
 18.41.43 AS cfgRead:    PROTOCOL = SMTP 
 18.41.43 AS cfgRead:    CLASS = SMTPCLIENT 
 18.41.43 AS cfgRead:  END 
 18.41.43 AS r1fclose: closing file <C:\wf76\ibi\srv76\wfs\etc\odin.cfg> 
 18.41.43 AS r1fclose: done, rc=0 
 18.41.43 AS ngFind4:  entered k1=CLASS, v1=AGENT, k2=PROTOCOL, v2=TCP 
 18.41.43 AS ngFind4:  found node 'LST_TCP'
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRIV_PORT ) 
 18.41.43 AS r1envget: <EDAPRIV_PORT> is not set 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDASHARE=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS pthtst:   calling r1shmopn just to test for shared memory presence 
 18.41.43 AS r1shmope: called to open id=1, size=0 
 18.41.43 AS r1shmope: shared mode 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\share\001> 
 18.41.43 AS r1shmope: file mapping name=Global\C:/WF76/IBI/SRV76/WFS/SHARE/001 
 18.41.43 AS r1shmope: OpenFileMapping(Global\C:/WF76/IBI/SRV76/WFS/SHARE/001) 
 18.41.43 AS r1trcerr: r1shmopen: err#2, The system cannot find the file specified.   
 18.41.43 AS r1shmope: open failed 
 18.41.43 AS r1shmclo: called to remove id=1 
 18.41.43 AS r1shmclo: OK 
 18.41.43 AS r1sgbutl: OpenProcessToken(h=FFFFFFFF) 
 18.41.43 AS r1sgbutl: LookupPrivilegeValue... 
 18.41.43 AS r1sgbutl: AdjustTokenPrivileges... 
 18.41.43 AS r1sgbutl: CloseHandle(h=00000780) 
 18.41.43 AS r1fifocr: name is <tscom300> 
 18.41.43 AS r1fifocr: rc = 0 
 18.41.43 AS r1sgbutl: OpenProcessToken(h=FFFFFFFF) 
 18.41.43 AS r1sgbutl: LookupPrivilegeValue... 
 18.41.43 AS r1sgbutl: AdjustTokenPrivileges... 
 18.41.43 AS r1sgbutl: CloseHandle(h=00000780) 
 18.41.43 AS r1sgbutl: OpenProcessToken(h=FFFFFFFF) 
 18.41.43 AS r1sgbutl: LookupPrivilegeValue... 
 18.41.43 AS r1sgbutl: AdjustTokenPrivileges... 
 18.41.43 AS r1sgbutl: CloseHandle(h=00000780) 
 18.41.43 AS r1fifoop: name is<tscom300>, type is <read> only 
 18.41.43 AS r1fifoop: calling CreateMutex( Global\c:.wf76.ibi.srv76.wfs.tscom300Mutex ) 
 18.41.43 AS r1fifoop: calling CreateEvent( Global\c:.wf76.ibi.srv76.wfs.tscom300Event ) 
 18.41.43 AS r1fifoop: calling CreateMailslot( \\.\mailslot\c:.wf76.ibi.srv76.wfs.tscom300 ) 
 18.41.43 AS r1fifoop: rc = 0 
 18.41.43 AS r1sgbutl: OpenProcessToken(h=FFFFFFFF) 
 18.41.43 AS r1sgbutl: LookupPrivilegeValue... 
 18.41.43 AS r1sgbutl: AdjustTokenPrivileges... 
 18.41.43 AS r1sgbutl: CloseHandle(h=0000073C) 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDASHARE=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDATEMP ) 
 18.41.43 AS r1envget: <EDATEMP> is not set 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\edatemp> 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDATEMP0=C:\wf76\ibi\srv76\wfs\edatemp 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDATEMP ) 
 18.41.43 AS r1envget: <EDATEMP> is not set 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDAPRINT=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAPRINT ) 
 18.41.43 AS r1envget: <EDAPRINT> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\edaprint.log> 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS r1envset: adding 'varname=value' string to environment: 
 18.41.43 AS r1envset: EDASHARE=C:\wf76\ibi\srv76\wfs 
 18.41.43 AS r1penv:   calling _putenv 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 18.41.43 AS r1envget: <EDASHARE> contains: <C:\wf76\ibi\srv76\wfs> 
 18.41.43 AS pthtst:   calling r1shmopn just to test for shared memory presence 
 18.41.43 AS r1shmope: called to open id=1, size=0 
 18.41.43 AS r1shmope: shared mode 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\share\001> 
 18.41.43 AS r1shmope: file mapping name=Global\C:/WF76/IBI/SRV76/WFS/SHARE/001 
 18.41.43 AS r1shmope: OpenFileMapping(Global\C:/WF76/IBI/SRV76/WFS/SHARE/001) 
 18.41.43 AS r1trcerr: r1shmopen: err#2, The system cannot find the file specified.   
 18.41.43 AS r1shmope: open failed 
 18.41.43 AS r1shmclo: called to remove id=1 
 18.41.43 AS r1shmclo: OK 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( IBI_DEBUG ) 
 18.41.43 AS r1envget: <IBI_DEBUG> is not set 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\home\bin\edapth.exe> 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAJCLRUN ) 
 18.41.43 AS r1envget: <EDAJCLRUN> is not set 
 18.41.43 AS cfgQuery: key 'server_system_id' not found 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 18.41.43 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 18.41.43 AS r1prcatt: "C:\wf76\ibi\srv76\home\bin\edapth.exe 9120 C:\wf76\ibi\srv76\wfs -traceon" 
 18.41.43 AS r1prcatt: flags = 0x14 
 18.41.43 AS cfgQuery: key 'ibi_debug_console' not found 
 18.41.43 AS r1prcatt: C:\wf76\ibi\srv76\home\bin\edapth.exe 9120 C:\wf76\ibi\srv76\wfs -traceon
 18.41.43 AS r1prcatt: message length = 73 
 18.41.43 AS r1prcatt: CloseHandle( h = 0000072C ) 
 18.41.43 AS r1prcatt: CloseHandle( h = 00000738 ) 
 18.41.43 AS r1prcatt: done, pid=2660 
 18.41.43 AS r1pathnm: result is <C:\wf76\ibi\srv76\wfs\edaprint.log> 
 18.41.43 AS r1envget: calling GetEnvironmentVariable( TSCQ_TIME_FACTOR ) 
 18.41.43 AS r1envget: <TSCQ_TIME_FACTOR> is not set 
 18.41.43 AS r1prcsle: calling Sleep( 1 * 1000 ) 
 18.41.44 AS r1prcexi: calling OpenProcess( PROCESS_QUERY_INFORMATION, pid <2660> ) 
 18.41.44 AS r1prcexi: calling GetExitCodeProcess 
 18.41.44 AS r1prcexi: calling CloseHandle( h = 00000738 ) 
 18.41.44 AS r1prcexi: tested pid = 2660 - exists 
 18.41.44 AS r1fustat: calling stat( C:\wf76\ibi\srv76\wfs\edaprint.log ) 
 18.41.44 AS r1fustat: calling GetFileAttributesEx(C:\wf76\ibi\srv76\wfs\edaprint.log)
 18.41.44 AS r1fustat: last write time=1184694104
 18.41.44 AS r1fustat: <C:\wf76\ibi\srv76\wfs\edaprint.log> is a file 
 18.41.44 AS r1fustat: done 
 18.41.44 AS r1prcexi: case R1PRC_EXIT_CTRLC: 
 18.41.44 AS r1fifore: timeout = 1 seconds 
 18.41.44 AS r1fifore: calling SetMailslotInfo( 1000 millisecs ) 
 18.41.44 AS r1fifore: calling ReadFile( ) 
 18.41.44 AS r1fifore: calling GetMailslotInfo( ) 
 18.41.44 AS r1fifore: calling SetEvent( h = 00000744 ) 
 18.41.44 AS r1fifore: rc = 0 
 18.41.44 AS r1prcexi: calling OpenProcess( PROCESS_QUERY_INFORMATION, pid <2660> ) 
 18.41.44 AS r1prcexi: calling GetExitCodeProcess 
 18.41.44 AS r1prcexi: calling CloseHandle( h = 0000072C ) 
 18.41.44 AS r1prcexi: tested pid = 2660 - exists 
 19.02.50 AS r1fifocl: name is <\\.\mailslot\c:.wf76.ibi.srv76.wfs.tscom300> 
 19.02.50 AS r1fifocl: calling CloseHandle( h = 00000740 ) 
 19.02.50 AS r1fifocl: calling ReleaseMutex( h = 00000780 ) 
 19.02.50 AS r1fifocl: calling CloseHandle( h = 00000780 ) 
 19.02.50 AS r1fifocl: calling CloseHandle( h = 00000744 ) 
 19.02.50 AS r1fifocl: rc = 0 
 19.02.50 AS r1sgbutl: OpenProcessToken(h=FFFFFFFF) 
 19.02.50 AS r1sgbutl: LookupPrivilegeValue... 
 19.02.50 AS r1sgbutl: AdjustTokenPrivileges... 
 19.02.50 AS r1sgbutl: CloseHandle(h=00000744) 
 19.02.50 AS r1fifode: name is <tscom300> 
 19.02.50 AS r1fifode: rc = 0 
 19.02.50 AS r1sgbutl: OpenProcessToken(h=FFFFFFFF) 
 19.02.50 AS r1sgbutl: LookupPrivilegeValue... 
 19.02.50 AS r1sgbutl: AdjustTokenPrivileges... 
 19.02.50 AS r1sgbutl: CloseHandle(h=00000744) 
 19.02.50 AS r1secdel: entered 
 19.02.50 AS r1secdel: ok 
 19.02.50 AS r1sgbdel: entered
 19.02.50 AS r1sgbdel: Calling FreeLibrary to unload NetApi32.dll 
 19.02.50 AS r1sgbdel: calling mtxdel 
 19.02.50 AS r1mtxdel: stub entered 
 19.02.50 AS r1mtxdel: OK 

Anyone know what EDAPRIV_ADMIN_ID does as I cant find it in the docs anywhere?

This message has been edited. Last edited by: hammo1j,

Tried setting EDAPRIV_ADMIN_ID which is totally undocumented to ifsappreport in the environmental variables but still this only checks the windows id the server process is running under

 10.56.05 AS r1secful: user fullname is 'PNB\webfocus.admin' 
 10.56.05 AS pthsver:  checking admin level and group
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDAPRIV_ADMIN_ID ) 
 10.56.05 AS r1envget: <EDAPRIV_ADMIN_ID> contains: <ifsappreport> 
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 10.56.05 AS r1envget: <EDASHARE> is not set 
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 10.56.05 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 10.56.05 AS pthsverc: validating user 'PNB\webfocus.admin' against admin_id... 
 10.56.05 AS cfgnadmg: get configured administrator info... 
 10.56.05 AS cfgQuery: key 'server_admin_id' not found 
 10.56.05 AS cfgnadmg: admin_id='ifsappreport'
 10.56.05 AS cfgnadmg: decrypting password 
 10.56.05 AS ntdecasc: entered, outLen=49 
 10.56.05 AS ntdecasc: cipher=0
 10.56.05 AS ntdecasc: calling r1strwc2mb(B9F5C3704FE116EE830EC3653886DB1C) 
 10.56.05 AS ntdecasc: calling ntdecasc() 
 10.56.05 AS ntdecasc: OK 
 10.56.05 AS cfgnadmg: admin_password='B9F5C3704FE116EE830EC3653886DB1C'
 10.56.05 AS cfgnadmg: admin_level='SRV'
 10.56.05 AS cfgnadmg: more members left...
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 10.56.05 AS r1envget: <EDASHARE> is not set 
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 10.56.05 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 10.56.05 AS cfgnadmg: get configured administrator info... 
 10.56.05 AS cfgnadmg: admin_id='webfocus.admin'
 10.56.05 AS cfgnadmg: decrypting password 
 10.56.05 AS ntdecasc: entered, outLen=49 
 10.56.05 AS ntdecasc: cipher=0
 10.56.05 AS ntdecasc: calling r1strwc2mb(5C5B9D17AA33DBBA) 
 10.56.05 AS ntdecasc: calling ntdecasc() 
 10.56.05 AS ntdecasc: OK 
 10.56.05 AS cfgnadmg: admin_password='5C5B9D17AA33DBBA'
 10.56.05 AS cfgnadmg: admin_level='SRV'
 10.56.05 AS cfgnadmg: more members left...
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDASHARE ) 
 10.56.05 AS r1envget: <EDASHARE> is not set 
 10.56.05 AS r1envget: calling GetEnvironmentVariable( EDAEXTSEC ) 
 10.56.05 AS r1envget: <EDAEXTSEC> contains: <DBMS> 
 10.56.05 AS cfgnadmg: get configured administrator info... 
 10.56.05 AS cfgnadmg: admin_id='PNB\webfocus.admin'
 10.56.05 AS cfgnadmg: decrypting password 
 10.56.05 AS ntdecasc: entered, outLen=49 
 10.56.05 AS ntdecasc: cipher=0
 10.56.05 AS ntdecasc: calling r1strwc2mb(5C5B9D17AA33DBBA) 
 10.56.05 AS ntdecasc: calling ntdecasc() 
 10.56.05 AS ntdecasc: OK 
 10.56.05 AS cfgnadmg: admin_password='5C5B9D17AA33DBBA'
 10.56.05 AS cfgnadmg: admin_level='SRV'

That it is checking the windows id as well as the oracle id seems to be a new innovation in 7.6.

Under 7.1.3 you didnt need an entry in admin.cfg for the pnb/webfocus.admin process as administrator in order to stop and start the server but it seems you do now.

Perhaps IB put the additional check in but then forgot to reset things to check the Oracle login against the list of server ids once the console was being accessed rather than started.

Of course it is impossible to set up a user of pnb/webfocus.admin under Oracle security which would be a workaround.

ibi have admitted this is a bug and are awaiting a fix in 7.6.3

meanwhile a way of working around is to make the default level of security administrator in admin.cfg which will suffice for us as we only on dev server until the release comes.

default_admin_level = SRV

Have to say the support has been good on this one thanks Raoul and IBI Europe.