Re: Informix Connect

Posted in 2004

Summary

Tom couldn't connect to Informix SE from a Windows client — telnet to port 1525 on the server failed, so the sqlexecd listener clearly wasn't accepting connections. The group advised checking sqlexecd's log, which only exists if the daemon was started with the -l option. Tom located the startup script (an rc/init.d script, S90informixse) and found it ran $INFORMIXDIR/lib/sqlexecd with no logging; Paul Watson suggested killing the daemon and restarting it as 'sqlexecd pei -l /tmp/mylogfile', and also showed how sqlhosts, /etc/services and netstat should line up. Tom edited the script to add -l logfiles; no final outcome is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Tom — Wed, 21 Apr 2004 12:49:01 -0400 — source: Usenet: comp.databases.informix

On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> wrote: >Tom wrote: >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >> wrote: >snip >> As for telnetting to it: >> >> C:\\ >> >>>telnet 10.254.2.10 1525 >> >> Connecting To 10.254.2.10...Could not open connection to the host, on >> port 1525: Connect failed >It ain't listening > >Anything in the informix log when you start sqlexecd? How do I tell? I don't know if the process is being started with logging or not. And even if it is, I don't know where to look for the log. (It's just been way too long since I've played with this... :( )

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 17:55:37 +0100 — source: Usenet: comp.databases.informix

AFAIR You specify the file you start sqlexecd Tom wrote: > > On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen > <clive@serendipita.com> wrote: > > >Tom wrote: > >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> > >> wrote: > >snip > >> As for telnetting to it: > >> > >> C:\\ > >> > >>>telnet 10.254.2.10 1525 > >> > >> Connecting To 10.254.2.10...Could not open connection to the host, on > >> port 1525: Connect failed > >It ain't listening > > > >Anything in the informix log when you start sqlexecd? > > How do I tell? I don't know if the process is being started with > logging or not. And even if it is, I don't know where to look for the > log. (It's just been way too long since I've played with this... :( ) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Tom

Art S. Kagel — Wed, 21 Apr 2004 13:43:54 -0400 — source: Usenet: comp.databases.informix

On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: > So I need to look in the file that starts the sqlexecd processes. What file > would that be, and where do I find it? Usually it's placed in the system startup (rc) script either in /etc/rc, /etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. Art S. Kagel > (I've tried going thru the docs, but I can't find anything that says one can > find the log if it's running, as in my case. You just have to know.) > > On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: > >>AFAIR You specify the file you start sqlexecd >> >>Tom wrote: >>> >>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >>> wrote: >>> >>> >Tom wrote: >>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >>> >> wrote: >>> >snip >>> >> As for telnetting to it: >>> >> >>> >> C:\\ >>> >> >>> >>>telnet 10.254.2.10 1525 >>> >> >>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >>> >> port 1525: Connect failed >>> >It ain't listening >>> > >>> >Anything in the informix log when you start sqlexecd? >>> >>> How do I tell? I don't know if the process is being started with logging >>> or not. And even if it is, I don't know where to look for the log. (It's >>> just been way too long since I've played with this... :( )

↪ replying to Tom

Art S. Kagel — Wed, 21 Apr 2004 14:25:48 -0400 — source: Usenet: comp.databases.informix

On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: Use WordPad instead of notepad. WordPad understands UNIX format text files. Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a search for wordpad.exe will find it. Art S. Kagel > I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp > client doesn't convert the Unix EOL characters to Windows, I'm having to > screw with it by hand. (I need it to look reasonably normal, so I can read > the darn thing.) > > I'm working on it... > > On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> > wrote: > >>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: >> >>> So I need to look in the file that starts the sqlexecd processes. What >>> file would that be, and where do I find it? >> >>Usually it's placed in the system startup (rc) script either in /etc/rc, >>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. >> >>Art S. Kagel >> >>> (I've tried going thru the docs, but I can't find anything that says one >>> can find the log if it's running, as in my case. You just have to know.) >>> >>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >>> >>>>AFAIR You specify the file you start sqlexecd >>>> >>>>Tom wrote: >>>>> >>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >>>>> wrote: >>>>> >>>>> >Tom wrote: >>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >>>>> >> wrote: >>>>> >snip >>>>> >> As for telnetting to it: >>>>> >> >>>>> >> C:\\ >>>>> >> >>>>> >>>telnet 10.254.2.10 1525 >>>>> >> >>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >>>>> >> port 1525: Connect failed >>>>> >It ain't listening >>>>> > >>>>> >Anything in the informix log when you start sqlexecd? >>>>> >>>>> How do I tell? I don't know if the process is being started with >>>>> logging or not. And even if it is, I don't know where to look for the >>>>> log. (It's just been way too long since I've played with this... :( )

↪ replying to Paul Watson

Tom — Wed, 21 Apr 2004 14:36:09 -0400 — source: Usenet: comp.databases.informix

So I need to look in the file that starts the sqlexecd processes. What file would that be, and where do I find it? (I've tried going thru the docs, but I can't find anything that says one can find the log if it's running, as in my case. You just have to know.) On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >AFAIR You specify the file you start sqlexecd > >Tom wrote: >> >> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen >> <clive@serendipita.com> wrote: >> >> >Tom wrote: >> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >> >> wrote: >> >snip >> >> As for telnetting to it: >> >> >> >> C:\\ >> >> >> >>>telnet 10.254.2.10 1525 >> >> >> >> Connecting To 10.254.2.10...Could not open connection to the host, on >> >> port 1525: Connect failed >> >It ain't listening >> > >> >Anything in the informix log when you start sqlexecd? >> >> How do I tell? I don't know if the process is being started with >> logging or not. And even if it is, I don't know where to look for the >> log. (It's just been way too long since I've played with this... :( )

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 19:36:59 +0100 — source: Usenet: comp.databases.informix

If you can see sqlexecd just shoot it and restart it by hand, it's in $INFORMIXDIR/lib AFAIR Tom wrote: > > So I need to look in the file that starts the sqlexecd processes. > What file would that be, and where do I find it? > > (I've tried going thru the docs, but I can't find anything that says > one can find the log if it's running, as in my case. You just have to > know.) > > On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> > wrote: > > >AFAIR You specify the file you start sqlexecd > > > >Tom wrote: > >> > >> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen > >> <clive@serendipita.com> wrote: > >> > >> >Tom wrote: > >> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> > >> >> wrote: > >> >snip > >> >> As for telnetting to it: > >> >> > >> >> C:\\ > >> >> > >> >>>telnet 10.254.2.10 1525 > >> >> > >> >> Connecting To 10.254.2.10...Could not open connection to the host, on > >> >> port 1525: Connect failed > >> >It ain't listening > >> > > >> >Anything in the informix log when you start sqlexecd? > >> > >> How do I tell? I don't know if the process is being started with > >> logging or not. And even if it is, I don't know where to look for the > >> log. (It's just been way too long since I've played with this... :( ) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Tom

Art S. Kagel — Wed, 21 Apr 2004 15:02:31 -0400 — source: Usenet: comp.databases.informix

On Wed, 21 Apr 2004 16:01:59 -0400, Tom wrote: > I think I got it... Yes, that's it. > #!/bin/ksh > # S90informixse > # startup/shutdown informix standard engine daemon # # > ******************************************************************* # # VER > DATE WHO COMMENTS > # > # 1.0 03-03-1996 CXT First write. > # 1.1 01-02-1997 CXT Change default informix server name to standard > "pei". > > > # ******************* STANDARD ENGINE 7 PROCESS ********************* > > case $1 in # test 1st argument > start ) INFORMIXDIR=${INFORMIXDIR:-"/usr/informix"} # set informix > dir > export INFORMIXDIR # export > variable > SQLEXEC=$INFORMIXDIR/lib/sqlexec # define engine > export SQLEXEC # export > variable > INFORMIXSERVER=pei # define server> export INFORMIXSERVER # export > variable > $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the > daemon > INFORMIXSERVER=pei2 # define> server > export INFORMIXSERVER # export > variable > $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the > daemon > ;; # terminator > stop ) ;; # do nothing if > shutdown > esac # end-case test > > # ******************* END OF SCRIPT ********************************* > > It doesn't look like it is logging to me. No, it's not. If it was the line would look like: $INFORMIXDIR/lib/sqlexecd -l $INFORMIXDIR/sqexecd.log $INFORMIXSERVER if memory serves (it's been awhile). Art S. Kagel

↪ replying to Art S. Kagel

Tom — Wed, 21 Apr 2004 15:08:07 -0400 — source: Usenet: comp.databases.informix

I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp client doesn't convert the Unix EOL characters to Windows, I'm having to screw with it by hand. (I need it to look reasonably normal, so I can read the darn thing.) I'm working on it... On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: > >> So I need to look in the file that starts the sqlexecd processes. What file >> would that be, and where do I find it? > >Usually it's placed in the system startup (rc) script either in /etc/rc, >/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. > >Art S. Kagel > >> (I've tried going thru the docs, but I can't find anything that says one can >> find the log if it's running, as in my case. You just have to know.) >> >> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >> >>>AFAIR You specify the file you start sqlexecd >>> >>>Tom wrote: >>>> >>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >>>> wrote: >>>> >>>> >Tom wrote: >>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >>>> >> wrote: >>>> >snip >>>> >> As for telnetting to it: >>>> >> >>>> >> C:\\ >>>> >> >>>> >>>telnet 10.254.2.10 1525 >>>> >> >>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >>>> >> port 1525: Connect failed >>>> >It ain't listening >>>> > >>>> >Anything in the informix log when you start sqlexecd? >>>> >>>> How do I tell? I don't know if the process is being started with logging >>>> or not. And even if it is, I don't know where to look for the log. (It's >>>> just been way too long since I've played with this... :( )

↪ replying to Art S. Kagel

Tom — Wed, 21 Apr 2004 15:48:46 -0400 — source: Usenet: comp.databases.informix

Thanks. That's pretty slick. I'm not finding anything that looks like it cranks up sqlexec. But then I don't claim to be able to read Unix. Any chance you could narrow it down a tad further? Or give me an idea of what I should be looking for? On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: > >Use WordPad instead of notepad. WordPad understands UNIX format text files. >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a >search for wordpad.exe will find it. > >Art S. Kagel > >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp >> client doesn't convert the Unix EOL characters to Windows, I'm having to >> screw with it by hand. (I need it to look reasonably normal, so I can read >> the darn thing.) >> >> I'm working on it... >> >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> >> wrote: >> >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: >>> >>>> So I need to look in the file that starts the sqlexecd processes. What >>>> file would that be, and where do I find it? >>> >>>Usually it's placed in the system startup (rc) script either in /etc/rc, >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. >>> >>>Art S. Kagel >>> >>>> (I've tried going thru the docs, but I can't find anything that says one >>>> can find the log if it's running, as in my case. You just have to know.) >>>> >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >>>> >>>>>AFAIR You specify the file you start sqlexecd >>>>> >>>>>Tom wrote: >>>>>> >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >>>>>> wrote: >>>>>> >>>>>> >Tom wrote: >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >>>>>> >> wrote: >>>>>> >snip >>>>>> >> As for telnetting to it: >>>>>> >> >>>>>> >> C:\\ >>>>>> >> >>>>>> >>>telnet 10.254.2.10 1525 >>>>>> >> >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >>>>>> >> port 1525: Connect failed >>>>>> >It ain't listening >>>>>> > >>>>>> >Anything in the informix log when you start sqlexecd? >>>>>> >>>>>> How do I tell? I don't know if the process is being started with >>>>>> logging or not. And even if it is, I don't know where to look for the >>>>>> log. (It's just been way too long since I've played with this... :( )

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 20:54:08 +0100 — source: Usenet: comp.databases.informix

Search and download winvi32 Tom wrote: > > I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my > ftp client doesn't convert the Unix EOL characters to Windows, I'm > having to screw with it by hand. (I need it to look reasonably > normal, so I can read the darn thing.) > > I'm working on it... > [cutting] -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 20:55:49 +0100 — source: Usenet: comp.databases.informix

It should be in /etc/init.d, all the files in /etc/rc?.d should link back to /etc/init.d If they don't I'd expect it to be in /etc/rc2.d and hopefully called something like S80informix Tom wrote: > > Thanks. That's pretty slick. > > I'm not finding anything that looks like it cranks up sqlexec. But > then I don't claim to be able to read Unix. Any chance you could > narrow it down a tad further? Or give me an idea of what I should be > looking for? > > On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" > <kagel@bloomberg.net> wrote: > > >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: > > > >Use WordPad instead of notepad. WordPad understands UNIX format text files. > >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a > >search for wordpad.exe will find it. > > > >Art S. Kagel > > > >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp > >> client doesn't convert the Unix EOL characters to Windows, I'm having to > >> screw with it by hand. (I need it to look reasonably normal, so I can read > >> the darn thing.) > >> > >> I'm working on it... > >> > >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> > >> wrote: > >> > >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: > >>> > >>>> So I need to look in the file that starts the sqlexecd processes. What > >>>> file would that be, and where do I find it? > >>> > >>>Usually it's placed in the system startup (rc) script either in /etc/rc, > >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. > >>> > >>>Art S. Kagel > >>> > >>>> (I've tried going thru the docs, but I can't find anything that says one > >>>> can find the log if it's running, as in my case. You just have to know.) > >>>> > >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: > >>>> > >>>>>AFAIR You specify the file you start sqlexecd > >>>>> > >>>>>Tom wrote: > >>>>>> > >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> > >>>>>> wrote: > >>>>>> > >>>>>> >Tom wrote: > >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> > >>>>>> >> wrote: > >>>>>> >snip > >>>>>> >> As for telnetting to it: > >>>>>> >> > >>>>>> >> C:\\ > >>>>>> >> > >>>>>> >>>telnet 10.254.2.10 1525 > >>>>>> >> > >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on > >>>>>> >> port 1525: Connect failed > >>>>>> >It ain't listening > >>>>>> > > >>>>>> >Anything in the informix log when you start sqlexecd? > >>>>>> > >>>>>> How do I tell? I don't know if the process is being started with > >>>>>> logging or not. And even if it is, I don't know where to look for the > >>>>>> log. (It's just been way too long since I've played with this... :( ) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Art S. Kagel

Tom — Wed, 21 Apr 2004 16:01:59 -0400 — source: Usenet: comp.databases.informix

I think I got it... #!/bin/ksh # S90informixse # startup/shutdown informix standard engine daemon # # ******************************************************************* # # VER DATE WHO COMMENTS # # 1.0 03-03-1996 CXT First write. # 1.1 01-02-1997 CXT Change default informix server name to standard "pei". # ******************* STANDARD ENGINE 7 PROCESS ********************* case $1 in # test 1st argument start ) INFORMIXDIR=${INFORMIXDIR:-"/usr/informix"} # set informix dir export INFORMIXDIR # export variable SQLEXEC=$INFORMIXDIR/lib/sqlexec # define engine export SQLEXEC # export variable INFORMIXSERVER=pei # define server export INFORMIXSERVER # export variable $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the daemon INFORMIXSERVER=pei2 # defineserver export INFORMIXSERVER # export variable $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the daemon ;; # terminator stop ) ;; # do nothing if shutdown esac # end-case test # ******************* END OF SCRIPT ********************************* It doesn't look like it is logging to me. On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: > >Use WordPad instead of notepad. WordPad understands UNIX format text files. >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a >search for wordpad.exe will find it. > >Art S. Kagel > >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp >> client doesn't convert the Unix EOL characters to Windows, I'm having to >> screw with it by hand. (I need it to look reasonably normal, so I can read >> the darn thing.) >> >> I'm working on it... >> >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> >> wrote: >> >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: >>> >>>> So I need to look in the file that starts the sqlexecd processes. What >>>> file would that be, and where do I find it? >>> >>>Usually it's placed in the system startup (rc) script either in /etc/rc, >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. >>> >>>Art S. Kagel >>> >>>> (I've tried going thru the docs, but I can't find anything that says one >>>> can find the log if it's running, as in my case. You just have to know.) >>>> >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >>>> >>>>>AFAIR You specify the file you start sqlexecd >>>>> >>>>>Tom wrote: >>>>>> >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >>>>>> wrote: >>>>>> >>>>>> >Tom wrote: >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >>>>>> >> wrote: >>>>>> >snip >>>>>> >> As for telnetting to it: >>>>>> >> >>>>>> >> C:\\ >>>>>> >> >>>>>> >>>telnet 10.254.2.10 1525 >>>>>> >> >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >>>>>> >> port 1525: Connect failed >>>>>> >It ain't listening >>>>>> > >>>>>> >Anything in the informix log when you start sqlexecd? >>>>>> >>>>>> How do I tell? I don't know if the process is being started with >>>>>> logging or not. And even if it is, I don't know where to look for the >>>>>> log. (It's just been way too long since I've played with this... :( )

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 21:02:53 +0100 — source: Usenet: comp.databases.informix

Kill the running sqlexecd and run /usr/informix/lib/sqlexecd pei -l /tmp/mylogfile Tom wrote: > > I think I got it... > > #!/bin/ksh > # S90informixse > # startup/shutdown informix standard engine daemon > # > # ******************************************************************* > # > # VER DATE WHO COMMENTS > # > # 1.0 03-03-1996 CXT First write. > # 1.1 01-02-1997 CXT Change default informix server name to > standard "pei". > > # ******************* STANDARD ENGINE 7 PROCESS ********************* > > case $1 in # test 1st > argument > start ) INFORMIXDIR=${INFORMIXDIR:-"/usr/informix"} # set informix > dir > export INFORMIXDIR # export > variable > SQLEXEC=$INFORMIXDIR/lib/sqlexec # define engine > export SQLEXEC # export > variable > INFORMIXSERVER=pei # define server> export INFORMIXSERVER # export > variable > $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the > daemon > INFORMIXSERVER=pei2 # define> server > export INFORMIXSERVER # export > variable > $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the > daemon > ;; # terminator > stop ) ;; # do nothing if > shutdown > esac # end-case test > > # ******************* END OF SCRIPT ********************************* > > It doesn't look like it is logging to me. > > On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" > <kagel@bloomberg.net> wrote: > > >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: > > > >Use WordPad instead of notepad. WordPad understands UNIX format text files. > >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a > >search for wordpad.exe will find it. > > > >Art S. Kagel > > > >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp > >> client doesn't convert the Unix EOL characters to Windows, I'm having to > >> screw with it by hand. (I need it to look reasonably normal, so I can read > >> the darn thing.) > >> > >> I'm working on it... > >> > >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> > >> wrote: > >> > >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: > >>> > >>>> So I need to look in the file that starts the sqlexecd processes. What > >>>> file would that be, and where do I find it? > >>> > >>>Usually it's placed in the system startup (rc) script either in /etc/rc, > >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. > >>> > >>>Art S. Kagel > >>> > >>>> (I've tried going thru the docs, but I can't find anything that says one > >>>> can find the log if it's running, as in my case. You just have to know.) > >>>> > >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: > >>>> > >>>>>AFAIR You specify the file you start sqlexecd > >>>>> > >>>>>Tom wrote: > >>>>>> > >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> > >>>>>> wrote: > >>>>>> > >>>>>> >Tom wrote: > >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> > >>>>>> >> wrote: > >>>>>> >snip > >>>>>> >> As for telnetting to it: > >>>>>> >> > >>>>>> >> C:\\ > >>>>>> >> > >>>>>> >>>telnet 10.254.2.10 1525 > >>>>>> >> > >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on > >>>>>> >> port 1525: Connect failed > >>>>>> >It ain't listening > >>>>>> > > >>>>>> >Anything in the informix log when you start sqlexecd? > >>>>>> > >>>>>> How do I tell? I don't know if the process is being started with > >>>>>> logging or not. And even if it is, I don't know where to look for the > >>>>>> log. (It's just been way too long since I've played with this... :( ) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 21:07:26 +0100 — source: Usenet: comp.databases.informix

On our running se724 for Solaris root[luey_net]: ps -ef | egrep sqle root 13860 13849 0 21:04:20 pts/2 0:00 egrep sqle root 10305 1 0 Mar 19 ? 0:00 /home/informix/lib/sqlexecd luey_net cutting from netstat -a luey.oninit.com.lueynet *.* 0 0 0 0 LISTEN cutting from sqlhosts luey_net setlitcp luey lueynet luey_920 ontlitcp luey luey920 root[luey_net]: egrep luey /etc/services lueynet 1531/tcp luey920 1533/tcp luey731 1534/tcp Tom wrote: > > I think I got it... > > #!/bin/ksh > # S90informixse > # startup/shutdown informix standard engine daemon > # > # ******************************************************************* > # > # VER DATE WHO COMMENTS > # > # 1.0 03-03-1996 CXT First write. > # 1.1 01-02-1997 CXT Change default informix server name to > standard "pei". > > # ******************* STANDARD ENGINE 7 PROCESS ********************* > > case $1 in # test 1st > argument > start ) INFORMIXDIR=${INFORMIXDIR:-"/usr/informix"} # set informix > dir > export INFORMIXDIR # export > variable > SQLEXEC=$INFORMIXDIR/lib/sqlexec # define engine > export SQLEXEC # export > variable > INFORMIXSERVER=pei # define server> export INFORMIXSERVER # export > variable > $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the > daemon > INFORMIXSERVER=pei2 # define> server > export INFORMIXSERVER # export > variable > $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the > daemon > ;; # terminator > stop ) ;; # do nothing if > shutdown > esac # end-case test > > # ******************* END OF SCRIPT ********************************* > > It doesn't look like it is logging to me. > > On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" > <kagel@bloomberg.net> wrote: > > >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: > > > >Use WordPad instead of notepad. WordPad understands UNIX format text files. > >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a > >search for wordpad.exe will find it. > > > >Art S. Kagel > > > >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp > >> client doesn't convert the Unix EOL characters to Windows, I'm having to > >> screw with it by hand. (I need it to look reasonably normal, so I can read > >> the darn thing.) > >> > >> I'm working on it... > >> > >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> > >> wrote: > >> > >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: > >>> > >>>> So I need to look in the file that starts the sqlexecd processes. What > >>>> file would that be, and where do I find it? > >>> > >>>Usually it's placed in the system startup (rc) script either in /etc/rc, > >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. > >>> > >>>Art S. Kagel > >>> > >>>> (I've tried going thru the docs, but I can't find anything that says one > >>>> can find the log if it's running, as in my case. You just have to know.) > >>>> > >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: > >>>> > >>>>>AFAIR You specify the file you start sqlexecd > >>>>> > >>>>>Tom wrote: > >>>>>> > >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> > >>>>>> wrote: > >>>>>> > >>>>>> >Tom wrote: > >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> > >>>>>> >> wrote: > >>>>>> >snip > >>>>>> >> As for telnetting to it: > >>>>>> >> > >>>>>> >> C:\\ > >>>>>> >> > >>>>>> >>>telnet 10.254.2.10 1525 > >>>>>> >> > >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on > >>>>>> >> port 1525: Connect failed > >>>>>> >It ain't listening > >>>>>> > > >>>>>> >Anything in the informix log when you start sqlexecd? > >>>>>> > >>>>>> How do I tell? I don't know if the process is being started with > >>>>>> logging or not. And even if it is, I don't know where to look for the > >>>>>> log. (It's just been way too long since I've played with this... :( ) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Paul Watson

Tom — Wed, 21 Apr 2004 16:23:17 -0400 — source: Usenet: comp.databases.informix

I changed: $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the daemon $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the daemon to: $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER -l /tmp/pei.log # run the daemon $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER -l /tmp/pei2.log # run the daemon This should get me logging, no? On Wed, 21 Apr 2004 20:55:49 +0100, Paul Watson <paul@oninit.com> wrote: >It should be in /etc/init.d, all the files in /etc/rc?.d should >link back to /etc/init.d If they don't I'd expect it to be >in /etc/rc2.d and hopefully called something like S80informix > >Tom wrote: >> >> Thanks. That's pretty slick. >> >> I'm not finding anything that looks like it cranks up sqlexec. But >> then I don't claim to be able to read Unix. Any chance you could >> narrow it down a tad further? Or give me an idea of what I should be >> looking for? >> >> On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" >> <kagel@bloomberg.net> wrote: >> >> >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: >> > >> >Use WordPad instead of notepad. WordPad understands UNIX format text files. >> >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a >> >search for wordpad.exe will find it. >> > >> >Art S. Kagel >> > >> >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp >> >> client doesn't convert the Unix EOL characters to Windows, I'm having to >> >> screw with it by hand. (I need it to look reasonably normal, so I can read >> >> the darn thing.) >> >> >> >> I'm working on it... >> >> >> >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> >> >> wrote: >> >> >> >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: >> >>> >> >>>> So I need to look in the file that starts the sqlexecd processes. What >> >>>> file would that be, and where do I find it? >> >>> >> >>>Usually it's placed in the system startup (rc) script either in /etc/rc, >> >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. >> >>> >> >>>Art S. Kagel >> >>> >> >>>> (I've tried going thru the docs, but I can't find anything that says one >> >>>> can find the log if it's running, as in my case. You just have to know.) >> >>>> >> >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >> >>>> >> >>>>>AFAIR You specify the file you start sqlexecd >> >>>>> >> >>>>>Tom wrote: >> >>>>>> >> >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >> >>>>>> wrote: >> >>>>>> >> >>>>>> >Tom wrote: >> >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >> >>>>>> >> wrote: >> >>>>>> >snip >> >>>>>> >> As for telnetting to it: >> >>>>>> >> >> >>>>>> >> C:\\ >> >>>>>> >> >> >>>>>> >>>telnet 10.254.2.10 1525 >> >>>>>> >> >> >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >> >>>>>> >> port 1525: Connect failed >> >>>>>> >It ain't listening >> >>>>>> > >> >>>>>> >Anything in the informix log when you start sqlexecd? >> >>>>>> >> >>>>>> How do I tell? I don't know if the process is being started with >> >>>>>> logging or not. And even if it is, I don't know where to look for the >> >>>>>> log. (It's just been way too long since I've played with this... :( )

↪ replying to Paul Watson

Tom — Wed, 21 Apr 2004 16:26:42 -0400 — source: Usenet: comp.databases.informix

How do I kill it? On Wed, 21 Apr 2004 21:02:53 +0100, Paul Watson <paul@oninit.com> wrote: >Kill the running sqlexecd and run > >/usr/informix/lib/sqlexecd pei -l /tmp/mylogfile > >Tom wrote: >> >> I think I got it... >> >> #!/bin/ksh >> # S90informixse >> # startup/shutdown informix standard engine daemon >> # >> # ******************************************************************* >> # >> # VER DATE WHO COMMENTS >> # >> # 1.0 03-03-1996 CXT First write. >> # 1.1 01-02-1997 CXT Change default informix server name to >> standard "pei". >> >> # ******************* STANDARD ENGINE 7 PROCESS ********************* >> >> case $1 in # test 1st >> argument >> start ) INFORMIXDIR=${INFORMIXDIR:-"/usr/informix"} # set informix >> dir >> export INFORMIXDIR # export >> variable >> SQLEXEC=$INFORMIXDIR/lib/sqlexec # define engine >> export SQLEXEC # export >> variable >> INFORMIXSERVER=pei # define server>> export INFORMIXSERVER # export >> variable >> $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the >> daemon >> INFORMIXSERVER=pei2 # define>> server >> export INFORMIXSERVER # export >> variable >> $INFORMIXDIR/lib/sqlexecd $INFORMIXSERVER # run the >> daemon >> ;; # terminator >> stop ) ;; # do nothing if >> shutdown >> esac # end-case test >> >> # ******************* END OF SCRIPT ********************************* >> >> It doesn't look like it is logging to me. >> >> On Wed, 21 Apr 2004 14:25:48 -0400, "Art S. Kagel" >> <kagel@bloomberg.net> wrote: >> >> >On Wed, 21 Apr 2004 15:08:07 -0400, Tom wrote: >> > >> >Use WordPad instead of notepad. WordPad understands UNIX format text files. >> >Usually it's in \\Program Files\\Windows NT\\Accessories for Win2000, but a >> >search for wordpad.exe will find it. >> > >> >Art S. Kagel >> > >> >> I found it, er, them. I have an rc, rc0, rc1, rc2 and rc3. Since my ftp >> >> client doesn't convert the Unix EOL characters to Windows, I'm having to >> >> screw with it by hand. (I need it to look reasonably normal, so I can read >> >> the darn thing.) >> >> >> >> I'm working on it... >> >> >> >> On Wed, 21 Apr 2004 13:43:54 -0400, "Art S. Kagel" <kagel@bloomberg.net> >> >> wrote: >> >> >> >>>On Wed, 21 Apr 2004 14:36:09 -0400, Tom wrote: >> >>> >> >>>> So I need to look in the file that starts the sqlexecd processes. What >> >>>> file would that be, and where do I find it? >> >>> >> >>>Usually it's placed in the system startup (rc) script either in /etc/rc, >> >>>/etc/rc<something>, or in /etc/init.d and linked to a link in /etc/rc. >> >>> >> >>>Art S. Kagel >> >>> >> >>>> (I've tried going thru the docs, but I can't find anything that says one >> >>>> can find the log if it's running, as in my case. You just have to know.) >> >>>> >> >>>> On Wed, 21 Apr 2004 17:55:37 +0100, Paul Watson <paul@oninit.com> wrote: >> >>>> >> >>>>>AFAIR You specify the file you start sqlexecd >> >>>>> >> >>>>>Tom wrote: >> >>>>>> >> >>>>>> On Wed, 21 Apr 2004 17:33:48 +0100, Clive Eisen <clive@serendipita.com> >> >>>>>> wrote: >> >>>>>> >> >>>>>> >Tom wrote: >> >>>>>> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >> >>>>>> >> wrote: >> >>>>>> >snip >> >>>>>> >> As for telnetting to it: >> >>>>>> >> >> >>>>>> >> C:\\ >> >>>>>> >> >> >>>>>> >>>telnet 10.254.2.10 1525 >> >>>>>> >> >> >>>>>> >> Connecting To 10.254.2.10...Could not open connection to the host, on >> >>>>>> >> port 1525: Connect failed >> >>>>>> >It ain't listening >> >>>>>> > >> >>>>>> >Anything in the informix log when you start sqlexecd? >> >>>>>> >> >>>>>> How do I tell? I don't know if the process is being started with >> >>>>>> logging or not. And even if it is, I don't know where to look for the >> >>>>>> log. (It's just been way too long since I've played with this... :( )

Related threads

Different instances with markedly different times