secleanup not working
A poster running Informix SE 7.25 on Linux got 'error in opening the process database' from secleanup (version UC3, downloaded from IIUG) even as root, and after copying it to the bin directory. TBP questioned the version mismatch, path and user. Art S. Kagel asked about the owner, group and permissions of the new secleanup versus the original. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I'm attempting to run secleanup to remove dead sqlexec sessions.
when I run the command as root i get the error (se below).
my informix environment is configured and $INFORMIXDIR/bin is in my
path.
The only caveat might be that i'm running 7.25.UC1 of standard-engine.
what am I doing wrong?
Thx.
arcdev1:/tmp# ./secleanup
SECLEANUP: Engine Process Cleanup and Synchronisation Utility
INFORMIX-SQL Version 7.25.UC3
Copyright (C) 1981-1997 Informix Software, Inc.
Software Serial Number RDS#N000000
PID USER TIME CONNECTED
--- ---- --------------
There was an error in opening the process database.
This utility must be run by the super user.
Verify that the INFORMIXDIR is set correctly.
arcdev1:/tmp#
arcdev1:/tmp# set | grep INF;
INFORMIXDIR=/usr/informix
INFORMIXSERVER=host_se
junkmail2345@gmail.com wrote:
>
> I'm attempting to run secleanup to remove dead sqlexec sessions.
> when I run the command as root i get the error (se below).
> my informix environment is configured and $INFORMIXDIR/bin is in my
> path.
> The only caveat might be that i'm running 7.25.UC1 of standard-engine.
> what am I doing wrong?
> Thx.
>
> arcdev1:/tmp# ./secleanup
> SECLEANUP: Engine Process Cleanup and Synchronisation Utility
> INFORMIX-SQL Version 7.25.UC3
> Copyright (C) 1981-1997 Informix Software, Inc.
> Software Serial Number RDS#N000000
>
> PID USER TIME CONNECTED
> --- ---- --------------
> There was an error in opening the process database.
> This utility must be run by the super user.
> Verify that the INFORMIXDIR is set correctly.
> arcdev1:/tmp#
> arcdev1:/tmp# set | grep INF;
> INFORMIXDIR=/usr/informix
> INFORMIXSERVER=host_se>
Inneresting :
1. $INFORMIXDIR/bin is /usr/informix/bin
yet you issue from /tmp
./secleanup
What secleanup is in the /tmp directory??
2. You state "...i'm running 7.25.UC1"
yet the output states
"INFORMIX-SQL Version 7.25.UC3"
which is it I wonder?
3. You have not shown the ouput from "id" or "whoami"
Are you root? Really?
4. You have not stated what O/S this is.
Oh well ...
i'm running informix-se on linux UC1.
secleanup version stated UC3 because i downlaoded/extracted it
from iiug.org which had the lastest version.
i did run it as root. (that's why the username isn't displayed).
i copied secleanup to /usr/informix/bin and got the same error.
here's the output again. everything works but secleanup.
thx,
dbuser@arcdev1:/usr/informix/bin$ uname -a
Linux arcdev1 2.4.24 #3 Wed Mar 10 10:22:13 EST 2004 i686 unknown
dbuser@arcdev1:/usr/informix/bin$ dbaccess -v
DB-Access Version 7.25.UC1
Software Serial Number ACN#J334914
dbuser@arcdev1:/usr/informix/bin$ su
Password:
arcdev1:/usr/informix/bin# id
uid=0(root) gid=0(root) groups=0(root)
arcdev1:/usr/informix/bin# ./secleanup
SECLEANUP: Engine Process Cleanup and Synchronisation Utility
INFORMIX-SQL Version 7.25.UC3
Copyright (C) 1981-1997 Informix Software, Inc.
Software Serial Number RDS#N000000
PID USER TIME CONNECTED
--- ---- --------------
There was an error in opening the process database.
This utility must be run by the super user.
Verify that the INFORMIXDIR is set correctly.
TBP wrote:
> junkmail2345@gmail.com wrote:
> >
> > I'm attempting to run secleanup to remove dead sqlexec sessions.
> > when I run the command as root i get the error (se below).
> > my informix environment is configured and $INFORMIXDIR/bin is in my
> > path.
> > The only caveat might be that i'm running 7.25.UC1 of standard-engine.
> > what am I doing wrong?
> > Thx.
> >
> > arcdev1:/tmp# ./secleanup
> > SECLEANUP: Engine Process Cleanup and Synchronisation Utility
> > INFORMIX-SQL Version 7.25.UC3
> > Copyright (C) 1981-1997 Informix Software, Inc.
> > Software Serial Number RDS#N000000
> >
> > PID USER TIME CONNECTED
> > --- ---- --------------
> > There was an error in opening the process database.
> > This utility must be run by the super user.
> > Verify that the INFORMIXDIR is set correctly.
> > arcdev1:/tmp#
> > arcdev1:/tmp# set | grep INF;
> > INFORMIXDIR=/usr/informix
> > INFORMIXSERVER=host_se> >
>
> Inneresting :
>
> 1. $INFORMIXDIR/bin is /usr/informix/bin
> yet you issue from /tmp
> ./secleanup
> What secleanup is in the /tmp directory??
>
> 2. You state "...i'm running 7.25.UC1"
> yet the output states
> "INFORMIX-SQL Version 7.25.UC3"
> which is it I wonder?
>
> 3. You have not shown the ouput from "id" or "whoami"
> Are you root? Really?
>
> 4. You have not stated what O/S this is.
>
> Oh well ...
junkmail2345@gmail.com wrote:
What are the owner, group, and permissions on the new secleanup? Are they
identical to those for the original one?
Art S. Kagel
> i'm running informix-se on linux UC1.
> secleanup version stated UC3 because i downlaoded/extracted it
> from iiug.org which had the lastest version.
> i did run it as root. (that's why the username isn't displayed).
> i copied secleanup to /usr/informix/bin and got the same error.
> here's the output again. everything works but secleanup.
> thx,
>
> dbuser@arcdev1:/usr/informix/bin$ uname -a
> Linux arcdev1 2.4.24 #3 Wed Mar 10 10:22:13 EST 2004 i686 unknown
>
> dbuser@arcdev1:/usr/informix/bin$ dbaccess -v
> DB-Access Version 7.25.UC1
> Software Serial Number ACN#J334914
>
> dbuser@arcdev1:/usr/informix/bin$ su
> Password:
>
> arcdev1:/usr/informix/bin# id
> uid=0(root) gid=0(root) groups=0(root)
>
> arcdev1:/usr/informix/bin# ./secleanup
> SECLEANUP: Engine Process Cleanup and Synchronisation Utility
> INFORMIX-SQL Version 7.25.UC3
> Copyright (C) 1981-1997 Informix Software, Inc.
> Software Serial Number RDS#N000000
>
> PID USER TIME CONNECTED
> --- ---- --------------
> There was an error in opening the process database.
> This utility must be run by the super user.
> Verify that the INFORMIXDIR is set correctly.
>
>
> TBP wrote:
>
>>junkmail2345@gmail.com wrote:
>>
>>>I'm attempting to run secleanup to remove dead sqlexec sessions.
>>>when I run the command as root i get the error (se below).
>>>my informix environment is configured and $INFORMIXDIR/bin is in my
>>>path.
>>>The only caveat might be that i'm running 7.25.UC1 of standard-engine.
>>>what am I doing wrong?
>>>Thx.
>>>
>>>arcdev1:/tmp# ./secleanup
>>>SECLEANUP: Engine Process Cleanup and Synchronisation Utility
>>>INFORMIX-SQL Version 7.25.UC3
>>>Copyright (C) 1981-1997 Informix Software, Inc.
>>>Software Serial Number RDS#N000000
>>>
>>>PID USER TIME CONNECTED
>>>--- ---- --------------
>>>There was an error in opening the process database.
>>>This utility must be run by the super user.
>>>Verify that the INFORMIXDIR is set correctly.
>>>arcdev1:/tmp#
>>>arcdev1:/tmp# set | grep INF;
>>>INFORMIXDIR=/usr/informix
>>>INFORMIXSERVER=host_se>>>
>>
>>Inneresting :
>>
>>1. $INFORMIXDIR/bin is /usr/informix/bin
>>yet you issue from /tmp
>>./secleanup
>>What secleanup is in the /tmp directory??
>>
>>2. You state "...i'm running 7.25.UC1"
>>yet the output states
>>"INFORMIX-SQL Version 7.25.UC3"
>>which is it I wonder?
>>
>>3. You have not shown the ouput from "id" or "whoami"
>>Are you root? Really?
>>
>>4. You have not stated what O/S this is.
>>
>>Oh well ...
>
>