They don't come any greener.HELP!! Informix/Unixware 2

I am completely in over my head. I administer Mac/Win networks. Here's what I've got; Compaq Proliant 1500 UnixWare 2.1 (Compaq/Sco/Novell) Informix (as near as I can determine) I have spent the last 2+ weeks breaking in to this server because the last admin. is unreachable. I can't login to the UnixWare desktop but I can access everything via root. The database hold the ordering system which is accessed via telnet thru windows. When the order is finished it needs to be printed. Informix is trying to print to a printer that isn't there. We have also recently moved, and down sized, which further compounds the problem. I can print to a default local printer. Additionally I know nothing about Informix. I do not know how to determine what version it is or access any configuration files. Any and all help would be appreciated. adrian@nospam.concreteinformation.com If you need to contact me directly remove "nospam." form the address line

Adrian Stuart <adrian@concreteinformation.com> wrote in message news:3936EE60.771AD685@concreteinformation.com... > I am completely in over my head. I administer Mac/Win networks. Here's > what I've got; > > Compaq Proliant 1500 > UnixWare 2.1 (Compaq/Sco/Novell) > Informix (as near as I can determine) > > I have spent the last 2+ weeks breaking in to this server because the > last admin. is unreachable. I can't login to the UnixWare desktop but I > can access everything via root. The database hold the ordering system > which is accessed via telnet thru windows. When the order is finished it > needs to be printed. Informix is trying to print to a printer that isn't > there. We have also recently moved, and down sized, which further > compounds the problem. I can print to a default local printer. > Additionally I know nothing about Informix. I do not know how to > determine what version it is or access any configuration files. Any and > all help would be appreciated. The Informix server itself knows or cares little about printing. It uses an environment variable called 'DBPRINT' to control printed output. You could perhaps try looking at printing from the UNIX side first. Look at the output from lpstat to see what print queues are set up. Read the man page on lpststat or on lp (man lpstat) for more information on the options to use with lpstat under UnixWare. There should be loads of prints stuck in a queue somewhere. Probably the easiest way to go is to find out how to point this at a printer which still exists. If you want to find out a bit more about Informix, as root you can take on the identity of any user on the UNIX box using the su command. Informix requires a login called 'informix' so if you su - informix (the minus sign is important) you can see all the variables this informix user has set. Including PATH and INFORMIXDIR - try 'echo $PATH' for example. The directory in INFORMIXDIR has the configuration files for Informix. You probably don't want to change these at the moment. Look at the manuals first - they're online at <www.informix.com/answers>. If you want to find out a bit more about how the individual application users are set up, cd to a user's home directory and look around. There should be some "hidden" files (the filenames start with a period - these are hidden from normal users but generally by default visible to root). Anyway, for Korn shells there'll be a file called .profile, for c-shells it's .rcsh I think. Look in this and see what DBPRINT is set to. Is it something like "lp -d inf_printer"? The file may be a link to a standard one somewhere else. If DBPRINT is set, you can change it to a printer that works, and the next time the user logs in they might be able to print... Your mileage may vary though. Maybe a table in the database controls the print destination - there are mmany ways the application builders might have chosen to do things. I suppose we can take it as read that there is no documentation whatsoever? -- Andrew Pearson "exactly what the web needs less of".

Here's what I've found out (thanks to others who have posted similar question!); Command(what I typed): cd $INFORMIXDIR cd etc more *cr Response: ASF -cr INFORMIX LIBASF LIBRARY Version 7.20.UC1 Copyright (C) 1991-1996 Informix Software, Inc. ESQL -cr INFORMIX EMBEDDED SQL for C Version 7.20.UC1 Copyright... GENLIB -cr INFORMIX LIBGEN LIBRARY Version 7.20.UC1 Copyright... ISQL -cr INFORMIX - SQL Version 6.04.UC1 Copyright... ISQLRT -cr INFORMIX - SQL Runtime Facility Version 6.04.UC1 Copyright... OSLIB -cr INFORMIX LIBOS LIBRARY Version 7.20.UC1 Copyright... SE -cr INFORMIX -SE Version 7.20.UC1 Copyright... SQLI -cr INFORMIX LIBSQL LIBRARY Version 7.20.UC1 Command: lpstat -t Response: system default destination: localhp system for hplj5: EPS_oee115_p1 (as printer hplj5) device for localhp: dev/lp hplj5 accepting requests localhp accepting requests printer hplj5 is idle printer localhp is idle note: I have deleted all previous printers in the hope of getting all jobs printed to the default. It didn't work. The EPS_... is a remote printer that doesn't respond. The localhp works Command: echo $path (while logged in as informix) Response: :/usr/informix/bin:/sbin:/usr/sbin:/usr/bin:/etc:/usr/ccs/bin:/usr/ccs/bin I have checked the (default) profile thoroughly. There is no reference what so ever to DBPRINT. Additionally I went to the Informix site, not sure what I'm looking for and therefore found nothing. Like I said before I really do not know what I'm doing.

Adrian Stuart wrote: <snip> > Command: > lpstat -t > > Response: > system default destination: localhp > system for hplj5: EPS_oee115_p1 (as printer hplj5) > device for localhp: dev/lp > hplj5 accepting requests > localhp accepting requests > printer hplj5 is idle > printer localhp is idle > > note: I have deleted all previous printers in the hope of getting all > jobs printed to the default. It didn't work. The EPS_... is a remote > printer that doesn't respond. The localhp works <snip> > I have checked the (default) profile thoroughly. There is no reference > what so ever to DBPRINT. Additionally I went to the Informix site, not > sure what I'm looking for and therefore found nothing. Like I said before > I really do not know what I'm doing. It may well be that the application controls its own print destination, it may for instance have a parameter table somewhere which contains the print command. If you had any manuals or tech support from the application providers they should be able to tell you how to set the print destination. I'm guessing that any manuals are lost in the mists of time. You could try going through the man pages on setting up print queues (man lpadmin I think) and recreating the print queues that were there before, but pointing them at a device you know to work - like the local laser jet. Or maybe recreating the remote printer on the NT print server? -- Andrew Pearson: "exactly what the web needs less of".

Andrew, It worked!!!! I installed a new printer and matched its name to the previous one that informix was looking for. Its now on line and working. Then I had to delete over 2 years of temp log trash to eliminate an error. I appreciate all your help. Adrian Stuart "No sense in being pessimistic, it wouldn't work anyway"

Adrian Stuart wrote: > > Andrew, > > It worked!!!! I installed a new printer and matched its name to the previous > one that informix was looking for. Its now on line and working. Then I had to > delete over 2 years of temp log trash to eliminate an error. I appreciate all > your help. > Aw shucks! I think You earned plenty of congratulations yourself, not least for can-do attitude and delving in there and finding out how to do it. I respect that and hope that your company is properly appreciative of the way you've gone from 0 to lpadmin... Now I have a blue G3 at home and it - Only Kidding! -- Andrew Pearson: "exactly what the web needs less of".