Unix Technical Forum

Informix permission !!!!

This is a discussion on Informix permission !!!! within the Informix forums, part of the Database Server Software category; --> hello all, can anyone help me with this errors, - error -409 : Sqlexec was not found or was ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 11:02 AM
maca
 
Posts: n/a
Default Informix permission !!!!

hello all,
can anyone help me with this errors,
- error -409 : Sqlexec was not found or was not executable by the
current user.

-error : The type of your terminal is unknown to the system

what i must I do,
i think that the problem is how to use usermod/chmod
any help
thanks

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 11:03 AM
scottishpoet
 
Posts: n/a
Default Re: Informix permission !!!!

DO NOT set the permissions to 777

you need to install the software properly

the installation script sets the correct permissions

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 11:03 AM
maca
 
Posts: n/a
Default Re: Informix permission !!!!

hi, the software is al installed years ago and there is information on
it, but with some reason some permision are changed
i want to know the permission for
fglgo, dbaccess, and what about user account,
cause when i tried to run dbaccess I get this error:
The type of your Terminal is unknown to the system.
any suggestion
thanks a lot

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 11:03 AM
Surfer!
 
Posts: n/a
Default Re: Informix permission !!!!

In message <1136463700.877756.149890@o13g2000cwo.googlegroups .com>, maca
<macanede@hotmail.com> writes
>hello all,
>can anyone help me with this errors,
>- error -409 : Sqlexec was not found or was not executable by the
>current user.
>
>-error : The type of your terminal is unknown to the system
>
>what i must I do,
>i think that the problem is how to use usermod/chmod
>any help
>thanks
>


You have two separate errors.

Best advise is to read the manual - you can download them from IBM (and
also oninit.com I believe) and the Informix 4GL reference contains
details for the termcap/terminfo stuff.

However...

1) it looks like whoever installed Informix was not logged in as 'root'
so the permissions on some of the files in $INFORMIXDIR are not set
correctly. Reinstallation, paying attention to the installation
instructions, is called for. It's fine to install on top - just take a
copy of $INFORMIXDIR/etc/sqlhosts first as I suspect it will need
re-editing afterwards.

2) It would have been very useful if we knew which version of Informix
you are using, but let's assume some variant of V7 - sqlexec tells us
it's standard engine. Let's also assuming it's some kind of UNIX
platform. Anyway, Informix can use either termcap or terminfo. If you
don't know what those are you will struggle with the rest of this - you
need to find someone who does. The following is taken from the manual,
so there may be some typos. Read the source is the best advice.

Anyway, start by finding the values of $INFORMIXTERM, $TERM, $TERMCAP
and $TERMINFO - they may not all be set but $TERM should be.
$INFORMIXTERM tells Informix if it's to use $TERMCAP or $TERMINFO and
will have the values termcap or terminfo. If it's set to termcap then
$TERMCAP must be set, and if it's set to terminfo then $TERMINFO must be
set. If it's not set, termcap will be assumed.

If you are using termcap, then $TERMCAP must point to a file that
contains a valid terminal description for you terminal (such as
/etc/termcap).

If you are using terminfo, then $TERMINFO must point to a directory
holding the correct sub directories for your terminal - for example if
$TERM=doc18, then $TERMINFO should contain a directory 'd' and that
should contain an entry 'doc18'. If $TERM = wyse60, then it's 'w' and
'wyse60'.



--
Surfer!
Email to: ramwater at uk2 dot net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-20-2008, 11:03 AM
Paul Watson
 
Posts: n/a
Default Re: Informix permission !!!!

look in $INFORMIXDIR/etc there is a file that will match *file* for
your install. the permissions are in there.

There is/used an option of NOBRAND when you run the install script and
will not request the key/serial.

Also there is script that will fix the perms for you at
www.oninit.com/scripts, look for Perm Fix, it should work on most Unix's



maca wrote:

> hi, the software is al installed years ago and there is information on
> it, but with some reason some permision are changed
> i want to know the permission for
> fglgo, dbaccess, and what about user account,
> cause when i tried to run dbaccess I get this error:
> The type of your Terminal is unknown to the system.
> any suggestion
> thanks a lot
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-20-2008, 11:04 AM
scottishpoet
 
Posts: n/a
Default Re: Informix permission !!!!

If the software was installed years ago and you are not very familiar
with it, I'd suggest you may want to pay for a consultant to help. They
may not even need to comeon site to fix this if you can provide modem
access to the server.

You could contact your local IBM sales office who may be able to quote
you. You may find some other organisations around that are able to
provide this assistance.

This would, in my opinion, be better than possibly causing further
problems meaning you lose all your data.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-20-2008, 11:04 AM
Captain Pedantic
 
Posts: n/a
Default Re: Informix permission !!!!


"scottishpoet" <dryburghj@yahoo.com> wrote in message
news:1136568565.634005.282980@o13g2000cwo.googlegr oups.com...
> If the software was installed years ago and you are not very familiar
> with it, I'd suggest you may want to pay for a consultant to help. They
> may not even need to comeon site to fix this if you can provide modem
> access to the server.
>
> You could contact your local IBM sales office who may be able to quote
> you.


But make sure you are sitting down.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:37 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com