My apologies!

I meant to send this directly to Axton, not the entire list.

But now that the damage is done, if any of you have any
suggestions I'd be glad to hear from you.

Sorry!

Dwayne Martin

Dwayne Martin
Computing Support
James Madison University

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"
--- Begin Message ---
Hi Axton,

Some time ago you offered to help me if I ran into problems
doing a non-root install in ARS 7.01.  I hope that offer is
still good.

Here is what happened.  The install went OK, after a few
snags.  But when we restart the system we get all sorts of
messages about improperly defined objects.

Some of these are about filters.  In each case the filter is
not in the filter list in the Admin tool for the new database.
 But when I try to import the missing filter from the old
database I get "This violates a unique index."  The filter IS
in the "filter" table.

I am working with Remedy support.  They sent me a script for
updating the number of actions in the "filter" record.  The
problem is that the "filter" record for each filter has the
same number of actions in the new database as in the old. So I
don't think that the "numactions" is the problem.

There is one message about the number of actions, but it
doesn't say what the filter is.  This is even more worrisome.
There are quite a few messages where they don't even say what
the object is.

I am attaching a screen print of the start-up messages.  If
you have time to look at them I would be glad for your
suggestions.  If not, I realize that we are all busy people.

Like I say, I am working with Support, but I would still be
glad for your opinion.

Best Wishes,
Dwayne Martin

PS: We are installing on RedHat Linux, Oracle 10 db

---- Original message ----
>Date: Thu, 7 Dec 2006 14:50:28 -0500
>From: Axton <[EMAIL PROTECTED]>  
>Subject: Re: ARS 7.0 Install as non-root user  
>To: [email protected]
>
>   **
>   Installing as non-root works well on solaris for the
>   7.0.01 release.  Here are the steps I used:
>    
>   Step 1: Upload Installation Media
>   Step 2: Identify and remove server side direct sql
>   workflow (there is a known bug in the upgrade
>   process if there is direct sql server side workflow;
>   not sure if related to unicode upgrade or not)
>   Step 3: Stop Remedy
>   Step 4: set the necessary environment variables
>     LC_ALL
>     LANG
>     Oracle Env Vars for 10g
>     unset ARNONROOTINSTALL; ARNONROOTINSTALL=TRUE;
>   export ARNONROOTINSTALL
>     unset AROS; AROS=SOLARIS; export AROS
>     # Precautions to work around SW00253401 - certain
>   custom background images cause arserverd to core
>   dump - solaris specific solution
>     LD_PRELOAD=libumem.so; export LD_PRELOAD
>     unset UMEM_DEBUG
>     unset UMEM_LOGGING
>   Step 5: Create a backup of the filesystem
>   Step 6: Upgrade ARServer - run ar_install using your
>   non-root account
>    
>   The key here is the env var ARNONROOTINSTALL.
>    
>   Axton Grams
>    
>   On 12/7/06, Dwayne Martin <[EMAIL PROTECTED]> wrote:
>
>     I am planning to install ARS 7.0.01 as non-root on
>     a Red-Hat
>     Linux server (Oracle 10 db).  I came upon the
>     exchange shown
>     below, which suggests installing as root, then
>     changing the
>     object ownerships afterwards.
>
>     The only disadvantage I see is that I would need
>     to get root
>     permissions, which I don't normally have.
>
>     Has anyone succeed in installing ARS 7 as non-root
>     on a Unix
>     or Linux platform?
>
>     Does anyone have any additional advice to offer?
>
>     Dwayne Martin
>     James Madison University
>
>     ******* previous exchange *************
>
>     Date:         Tue, 25 Jul 2006 11:47:14 -0400
>     Reply-To:     [email protected]
>     Sender:       "Action Request System discussion
>     list(ARSList)"
>                  <[email protected] >
>     From:         Kevin Shaffer
>     <[EMAIL PROTECTED]>
>     Subject:      ARS 7.0 Install as non-root user
>     Content-Type: text/plain; charset="iso-8859-1"
>
>     We are unable to get 7.0 to install successfully
>     as a non-root
>     user, however it works fine installing as a root
>     user.  Has
>     anyone successfully installed ARS 7.0, ITSM 7.0
>     and CMDB as
>     root user and then converted it after the install
>     to run as
>     non-root.
>     Any gotchas or recommendations.  Is there a list
>     of all files
>     that need updated?  I have pulled the KB's off the
>     web site,
>     but they all are outdated.  I am more interested
>     in experience
>     doing this with 7.x.
>     TIA
>     Kevin
>     **************
>     From:         Dave Zifchock <[EMAIL PROTECTED]>
>     Subject:      Re: ARS 7.0 Install as non-root user
>
>     Kevin,
>     Every install I have made has been as the root
>     user and
>     converted over to a
>     non-root user.  On HPUX, I would just chown the
>     <remedy
>     install dir> and
>     the /etc/arsystem and /etc/arinstall directories
>     and it ran
>     without any
>     flaws.  Just make sure you shut down all of your
>     current ARS
>     processes and
>     then change the permissions.
>     *******************
>     Subject:      Re: ARS 7.0 Install as non-root user
>     In-Reply-To:
>     <
>    
[EMAIL PROTECTED]>
>     Content-Type: text/plain; charset=ISO-8859-1;
>     format=flowed
>     Content-Disposition: inline
>
>     See my other thread, entitled "ARS 7.0 p001
>     Install Issues"
>
>     This was done as non-root
>
>     What problem are you having
>
>     Axton Grams
>
>     *************
>     From:         Axton Grams <[EMAIL PROTECTED]>
>     Subject:      ARS 7.0 p001 Install Issues
>     Content-Type: text/plain; charset=ISO-8859-1
>
>     Has anyone successfully installed ARServer 7.0
>     p001 with all
>     languages
>     in the following environment:
>
>     - Solaris 9
>     - Oracle 10g client
>     - Remote Oracle 9.2 db (unicode)
>     - non-root install
>     - new install
>
>     The installer crashes at the beginning of the
>     import of the FB
>     forms,
>     stating dbVersion is an invalid operator.
>
>     Other relevant install settings:
>     - all languages
>     - new install
>     - area plugin
>     - no portmapper
>     - webservices plugin
>     - all other plugins/daemons not installed (arsnmp,
>     ardbc)
>     - Solaris LANG en_US.UTF-8
>     - Oracle NLS_LANG american
>
>     One thing I noticed is a whole bunch of arx import
>     errors for the
>     localized messages form, simply because of the
>     number of
>     records exceeds
>     2000.
>
>     Thanks,
>     Axton Grams
>     From:         Axton < [EMAIL PROTECTED]>
>     Subject:      Re: ARS 7.0 p001 Install Issues
>     In-Reply-To:  <[EMAIL PROTECTED]>
>     Content-Type: text/plain; charset=ISO-8859-1;
>     format=flowed
>     Content-Disposition: inline
>
>     Here is the exact error.  I reproduced it.
>
>     Installing Flash Objects: Mon Jul 24 21:05:36 EDT
>     2006
>
>     ./ar_install: test: unknown operator dbVersion
>
>     Looking at the install script, it looks like the
>     installer
>     dies at this point:
>
>     In the stage 6 of the install script:
>
>     12299          # Import required and selected
>     plugins
>     12300          ImportPlugins
>     >>> 12301          ImportFlash
>
>     Now in the importFlash function:
>
>     3279
>    
##############################################################
>     3280  # ImportFlash - Upgrade and import
>     FlashObject Forms
>     3281  #
>     3282
>    
##############################################################
>     3283  ImportFlash()
>     3284  {
>     3285      lecho "Installing Flash Objects: `date`
>     "
>     3286      lecho
>     3287      SAMPLE_FORMS="$INSTALL_DIR/samples/en"
>     3288      $CD $SAMPLE_FORMS
>     3289
>     >>>  3290      if [ ${DB_UPGRADE} -eq 1 -a
>     ${ARS_VER} -lt 21
>     ]; then
>     3291          LoadSchemaWithRIK FlashForms
>     "${IMPORT_MODE}"
>     "${UPGRD_USER}" "${UPGRD_PASS}"
>     3292          if [ $? -ne 0 ]; then
>     3293              lecho "FlashForms  failed to
>     import."
>     3294              lecho "Problems encountered
>     while
>     importing the
>     form FlashForms.def"
>     3295              lecho "Please refer to the log
>     in
>     $INSTALL_DIR/Logs/ for further details."
>     3296          else
>     3297              note "FlashForms successfully
>     installed."
>     3298          fi
>     3299      fi
>
>     From the output, I can tell that the first line of
>     this
>     function ran.
>
>     In the ArEnvHistory file, these are the values of
>     the vars
>     used in the
>     if statement:
>
>     DB_UPGRADE=0
>     ARS_VER=select dbVersion from control
>
>     Obviously the if statement can't handle the sql
>     statement.
>
>     Here is the diff to fix this (sloppy hack, for new
>     installs only):
>
>    
[EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem>
>     diff
>     -u ar_install.bak ar_install
>     --- ar_install.bak      Mon Jul 24 10:41:19 2006
>     +++ ar_install  Mon Jul 24 21:36:28 2006
>     @@ -11780,6 +11785,7 @@
>     ############################################
>     # Stage 6 : Set up sample forms and Demo
>     ############################################
>     +ARS_VER=0; export ARS_VER
>     STAGE=6
>     LogOnly "Stage 6: `date`"
>     if [ $FRESH_INSTALL -eq 1 ]; then
>
>     Axton Grams
>
>     Dwayne Martin
>     Computing Support
>     James Madison University
>
>   __20060125_______________________This posting was
>   submitted with HTML in it___

Dwayne Martin
Computing Support
James Madison University

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"
[EMAIL PROTECTED] bin]$ ./arsystem stop
Action Request System shutdown in progress.
Action Request System shutdown process complete.
[EMAIL PROTECTED] bin]$ ./arsystem start
Action Request System initializing.
Starting AR System Server

 (ARNOTE 0)
   AR Monitor version 7.0.01  200609271856 started.

 (ARNOTE 0)
   AR Monitor started.
server: locale=[[ en_US.UTF-8 ]],
 LANG=[[ en_US.UTF-8 ]]NLS_LANG=[[ american_america.AL32UTF8 ]]

Action Request System(R)  Server   Version 7.0.01  200609271856
Copyright (c) 1991 - 2006 BMC Software, Inc.
All rights reserved.

390600 : This version of the Action Request System(R) is ready for use or 
evaluation without purchasing or activating an authorization key.
For unlimited capabilities, contact your sales representative. (ARNOTE 27)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Incorrect format in the definition file (bad action value -- \(null)\) 
(ARERR 402)

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   PCS:CE-Create EMPAC Work File 600 Create file

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   IT:Project-Calc cost and email Manager when Completed 700

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   CMIB:Assignment-Set flags and SQL update 527 chg FROM coord chg TeamDay`!

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   GN:CE:PCS:Create EMPAC Work File 640 Create OBS

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   GN:CE:HD:Retrieve:Email to other group 500 Not PCS`!

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   GN:CE:HD:Retrieve:Email to other group 501 PCS`!

390600 : Missing data in the SQL database (filter.numActions) (ARERR 556)

390600 : Error in definition for a filter (ARERR 343)
   GN:CE:PCS:Create EMPAC Work File OBS

390600 : Failure during SQL operation to the database : ORA-01031: insufficient 
privileges (ARERR 552)

390600 : Problem encountered during creation of one of the application forms 
(ARERR 4550)

390600 : Form does not exist on server : Business Segment-Entity 
Association_Join (ARERR 303)

390600 : Problem encountered during creation of one of the application forms 
(ARERR 4550)
Action Request System initialization is complete.
[EMAIL PROTECTED] bin]$
Action Request System(R)  Fork Daemon   Version 7.0.01  200609271856
Copyright (c) 2000 - 2006 BMC Software, Inc.
All rights reserved.

 (ARNOTE 0)
   Server indicates that it's up.


Action Request System(R)  Plug-In Server   Version 7.0.01  200609271856
Copyright (c) 2001 - 2006 BMC Software, Inc.
All rights reserved.

Action Request System  AR System Application Command Dispatcher   Version 
7.0.01  200609271856
Copyright (c) 1998 - 2006 BMC Software, Inc.
All rights reserved.

Authentication failed ()  ARERR - 623

AR System Application server terminated -- fatal error encountered (ARAPPNOTE 
4501)

 (ARNOTE 0)
   Server (pid:2605) died with 65280.


Action Request System  AR System Application Command Dispatcher   Version 
7.0.01  200609271856
Copyright (c) 1998 - 2006 BMC Software, Inc.
All rights reserved.

Authentication failed ()  ARERR - 623

AR System Application server terminated -- fatal error encountered (ARAPPNOTE 
4501)

 (ARNOTE 0)
   Server (pid:2620) died with 65280.


Action Request System  AR System Application Command Dispatcher   Version 
7.0.01  200609271856
Copyright (c) 1998 - 2006 BMC Software, Inc.
All rights reserved.

Authentication failed ()  ARERR - 623

AR System Application server terminated -- fatal error encountered (ARAPPNOTE 
4501)

 (ARNOTE 0)
   Server (pid:2631) died with 65280.


Action Request System  AR System Application Command Dispatcher   Version 
7.0.01  200609271856
Copyright (c) 1998 - 2006 BMC Software, Inc.
All rights reserved.

Authentication failed ()  ARERR - 623

AR System Application server terminated -- fatal error encountered (ARAPPNOTE 
4501)

 (ARNOTE 0)
   Server (pid:2639) died with 65280.


Action Request System  AR System Application Command Dispatcher   Version 
7.0.01  200609271856
Copyright (c) 1998 - 2006 BMC Software, Inc.
All rights reserved.

Authentication failed ()  ARERR - 623

AR System Application server terminated -- fatal error encountered (ARAPPNOTE 
4501)

 (ARNOTE 0)

Tried 4 restarts in 30 seconds. I give up at Tue Jan 30 14:12:30 2007


[EMAIL PROTECTED] bin]$

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

--- End Message ---

Reply via email to