Pls can anyone help me out urgent!!!

Subject: Problem with Sqlexecd.. Dear Freinds I have upgraded the Informix Online and' Istar' from 5.02 to 5.08UD1 version which compiled on SCO3.2.5' and I followed' and implemented' the scripts as suggested by' Mr. Alejandro which was mentioned' below.. but' We are facing the same problems. Now, We have informix online 5.08.UD1 with Istar ver of 5.08.UD1 on SCO UNIX 5.0 operating system and client side I-net 5.01 ver 5.0 91/96 on windows for workgroups3.11. ' If we run the ilogin from the client side trying to connect to the database it is comming out by 387 ( no connect permission )error even if the perticular user ( eg: informix got DBA permission on perticular database) got DBA permission on the perticular database..If we give a grant connect permission to public then we are able to connect to the database..And second problem is We open the database with pwerbuilder 5.0 tables are listing with ower name' ( eg: xxx.tablename ) even if the ower of table is opens also. And' another problem is' that if we login through powerbuilder After' we open database at backend through using sqlexecd deomon'' If' check for users' through tbstat -u the Online is showing the powerbuilder' users as root and tty is like - we are not able to see by user name sample tbstat -u is follows... RSAM Version 5.08.UD1'' -- On-Line -- Up 02:44:59 -- 9712 Kbytes Users address' flags'' pid'''' user'''' tty''''' wait'''' tout locks nreads'' nwrites 80001a1c ------D 320'''' root'''' -''''''' 0''''''' 0''' 0'''' 1084'''' 4 80001aac ------D 0'''''' root'''' -''''''' 0''''''' 0''' 0'''' 0''''''' 0 80001b3c ------F 321'''' root''''''''''''' 0''''''' 0''' 0'''' 0''''''' 0 80001bcc ------F 322'''' root''''''''''''' 0''''''' 0''' 0'''' 0''''''' 0 80001c5c ------- 912'''' informix ttyp1''' 0''''''' 0''' 1'''' 13'''''' 0 80001e0c ------- 852'''' root'''' -''''''' 0''''''' 0''' 1'''' 0''''''' 0 6 active, 20 total Transactions address' flags user'''' locks log begin isolation retrys coordinator'''''' 8000255c A---- 80001a1c 0'''' 0'''''''' NOTRANS'' 0''''''''''''''''''''''' 80002b80 A---- 80001aac 0'''' 0'''''''' NOTRANS'' 0''''''''''''''''''''''' 800031a4 A---- 80001c5c 1'''' 0'''''''' COMMIT''' 0''''''''''''''''''''''' 80004410 A---- 80001e0c 1'''' 0'''''''' COMMIT''' 0''''''''''''''''''''''' 4 active, 20 total Actually' the perticular user(pid = 852) was loged in through powerbuilder we cannot find out the perticular user is who unless by executing the sqlexecd deomon manually ..' If we kill the process of sqlexecd and reexecute it manually then we are able to connect to the database without anyproblem and even if we were not given any' grant connect' permission to the' public..In the second case if we open the database with pb5.0 the tables are listing without the owner name. we want the solution for this problem by excute the sqlexecd by unix init programme and' do not want to give grant connect permission to public .. RAMA G. MEKALA mrg@fiscal.org.jm 1-876-927-1125 ( Office ) 1-876-978-4922 ( Res.'' ) _____________________________________________________________________________' Hi Rama, For the case I have to tell you the same issue about your products. The MOST IMPORTANT NOTE, I checked your products and S/Ns and all of them are compiled for SCO 3.2.4.2 and you are using those under SCO 3.2.5. This installation is UNSUPPORTED for us and you HAVE to make an upgrade to the right Informix and OS version. Please contact your dealer to place an order for the latest Informix OnLine / STAR version for SCO 3.2.5, don't forget OnLine / STAR MUST be the same version. We have installed and running OnLine/STAR 5.08.UD1 and the sqlexecd deamon starts automatically every time the system reboot. Our configuration : .- We have a file called /etc/istar.sh : #!/bin/csh #'''''' Please see the /etc/rc.nfs to start the daemon #'''''' Informix 5.08.UD1 #'''''' You have to be root to run it. # setenv TBCONFIG "tbconfig.salsa508" setenv INFORMIXDIR /products/5.08.UD1setenv SQLEXEC $INFORMIXDIR/lib/sqlturbo set path = ($INFORMIXDIR/bin $path) $INFORMIXDIR/lib/sqlexecd onl508_salsa -l $INFORMIXDIR/onl508_salsa.sqlexecd.log .- We called/run this file from /etc/nfs script, we added it after '' the /etc/pcnfsd "fi" : ....... ''''''''''''''' pcnfsd & '''''''''' } ''''''' fi ..... ''''''' if [ -x /etc/istar.sh ] ''''''' then '''''''''' /bin/echo "" '''''''''' /bin/echo "Starting sqlexecd daemon, onl508_salsa. OL 5.0x" '''''''''' /bin/echo "" '''''''''' /etc/istar.sh ''''''' fi ...... Tips : .- is Informix STAR installed after OnLine. .- Are the Informix OnLine / STAR the same version. .- Are the sqlturbo permissions and owner right ? must be -rwxr-xr-x'' 1 informix informix' 455539 Sep 23 09:54 sqlexecd -rwsr-sr-x'' 1 root'''' informix 1566466 Sep 23 09:54 sqlturbo I'm closing this case. Thanks, Alejandro Rodriguez, Tech Support Engineer -- -------------------------------------------------------------------- |Alejandro Rodriguez - TSE''''' |' "I'm the man of a thousand face'' | |Informix Software, Inc.''''''' |''''' A little piece of me in'''''' | |e-mail:' alexr@informix.com''' |''''''''' every part I take'''''''' | |6303 Blue Lagoon Dr. Suite 305 |I hold the tape for a thousand races| |Miami-FL, USA 33126''''''''''' |''' A different point of view in''' | |Phone: (305)-265-7545/260-7600 |''''''' every speech I make "'''''' | |FAX:'' (305)-261-5980''''''''' |'''' Steve Hogarth' -' Marillion''' |' -------------------------------------------------------------------- ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com