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

Collapse
2: Re: sqlplus not returning from db_source_sql_file ? (response to 1)
Posted by Don Baccus on 04/17/03 06:01 PM
I don't have any idea, never having run Oracle under Windows, but note that auto-install.tcl doesn't work, and that current plans are to probably further streamline the normal install procedure to ask pertinent questions on the front page (system admin etc) then to do the rest of the install automatically using the install.xml extension I added to 4.6.2.  We'll get rid of the need to hit "next" buttons after the initial questions are asked.  Even today we autoconfigure dotLRN in a way that makes installation from the web interface very simple.

Currently there are no plans to fix auto-install.tcl because scripted install procedures like Peter's tclwebtest-based solution remove the need to use the web interface at all without requiring us to maintain two separate installers, the normal and auto versions.

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.

Collapse
7: Re: sqlplus not returning from db_source_sql_file ? (response to 2)
Posted by Randy O'Meara on 06/14/03 01:24 AM
Is there a possibility that someone can explain in more detail what can go into the install.xml file. I'm interested in using it in 4.6.3.

Don mentions it above and the fact that he added it in 4.6.2.