permissions issue on Windows Server 2008 R2
Posted in 2012
Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting, Server Administration, Platform-Specific Issues
I have a server running Windows Server 2008 R2 on an IBM blade server that is
running IDS 11.70.TC3IE which is never able to finish the update of sysmaster.
It has Informix and the Informix Admin group on it.
I try logging in as Informix on the box and also as Informix on the network
domain.
No joy running âoninitâ either way. Any ideas?
I get stuff like this below in buildsmi.out :
Database selected.
load from 'C:\\\\Informix\\\\etc\\\\sysextspaces.unl' insert into sysextspaces;275: The Insert privilege is required for this operation.
275: The Insert privilege is required for this operation.
Error in line 1Near character position 72
Database closed.
"The reload of sysmaster failed."
"See C:\\\\Informix\\\\etc\\\\buildsmi.out for more information."
"The reload of sysmaster after upgrade failed"
Database selected.
511: Cannot modify system catalog (systables).
Error in line 1Near character position 23
511: Cannot modify system catalog (systables).
Error in line 1Near character position 23
Database closed.
389: No DBA permission.
Error in line 1Near character position 22
This file is the output of the dbaccess command in the shell script,
%INFORMIXDIR%\\\\etc\\\\buildsmi.bat. This script is run when IBM Informix
Dynamic Server (IDS) is first initialized. It builds the database and
tables which support the System Monitoring Interface. If you were
directed to see this file, a problem probably occurred while building
the database and/or its tables and views. See below for more
information regarding any problems.
Problems may have occurred if IDS was shutdown after initialization
but before the entire database was created. If this was the case,
login as 'informix', rerun 'oninit', and wait for the message
"'sysmaster' database created successfully"
to appear in the IDS message log before shutting down. Once it is
created successfully, it should never need to be recreated.
Lockmode set.
330: Cannot create or rename the database.
100: ISAM error: duplicate value for a record with unique key.
Error in line 30Near character position 33
Cleaning up whatever was successfully created
Database selected.
511: Cannot modify system catalog (systables).
Error in line 1Near character position 23
Database closed.
If informix user id starts with uppercase that might be your problem. =
Sorry. I actually login as "informix". There is no problem logging in. It is just that onit errs out and will not init the sysmaster. I don't know what problem that may be in future. This all started with the install of 11.70.TC1IE and continues through C3. -----Original Message----- From: Guy Sent: Monday, February 27, 2012 8:10 AM To: ids@iiug.org Subject: RE: permissions issue on Windows Server 2008 R2 [26376] If informix user id starts with uppercase that might be your problem. = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.