Forum OpenACS Q&A: Re: sqlplus not returning from db_source_sql_file ?
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.
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.