Forum OpenACS Q&A: Re: sqlplus not returning from db_source_sql_file ?

Collapse
3: Re: sqlplus not returning from db_source_sql_file ? (response to 2)
Posted by John Sequeira on 04/17/03 06:20 PM
I've had auto-install working fine with portable.nsd for a few months,  with openacs 4.5/postgres 7.2 on Redhat Linux 8 and Windows 2K.  I didn't realize it doesn't work with AOLServer.

I've had a great deal of success running web-page based code from the command line,  so I expect I'll be able to use your install.xml-based stuff if/when I move to 4.6 (and thereby not require separately maintained installers.)

Unless you've modified db_source_sql_file,  I still expect your code won't run on Windows,  however.

Collapse
4: Re: sqlplus not returning from db_source_sql_file ? (response to 3)
Posted by John Sequeira on 04/17/03 07:41 PM
I take that last bit back.  I'm testing this out on a W2K VM I set up several years ago,  that contains a working installation of ACS,  that was installed using the stock ACS 3.x installer running on AOLServer.  I looked at the code for db_source_sql_file,  and it was identical to the 4.5 code I'm trying to get running.

So the problem seems to be in how pipes (" open "| sqlplus...") or sqlplus might work differently inside or outside AOLServer (?)  Weird.