Forum OpenACS Q&A: sqlplus not returning from db_source_sql_file ?
sqlplus openacs/openacs @acs-kernel-create.sql > outputfile
from the command line, it also hangs.
When I type
sqlplus openacs/openacs @acs-kernel-create.sql
it doesn't return to the command line, but the the SQL prompt.
The only way I can see getting it to return is appending "EXIT" to the end of the sql file. There's got to be a better way. Anyone?
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.
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.
So the problem seems to be in how pipes (" open "| sqlplus...") or sqlplus might work differently inside or outside AOLServer (?) Weird.
Either Peter or I will probably do the question/install re-ordering not long after HEAD (i.e. the future 4.7) gets fixed, which we expect in about three weeks (Jeff Davis, who will take the lead on merging 4.6 changes with HEAD, is on vacation for about 10 days and will start on this upon his return)
Don mentions it above and the fact that he added it in 4.6.2.