On Fri, Jan 07, 2005 at 10:08:28PM +0530, Rakesh Mahajan wrote:
> I am trying it on linux as well as on windows.
> I am facing problem on both platform.
>
> I am attaching tcl files for both windows and linux.
> Please check it and inform what i am doing wrong.
> filename="oracleLinux.tcl"
> set home \usr\local\aolserver
> set address $host
That's broken, those backslashes need to be forward slashes -
ESPECIALLY because your running this on Linux, but from inside Tcl,
you should always use "/" as the directory separator, even on Windows.
> ns_section "ns/servers/${sname}/db"
> ns_param Pools *
> ns_param defaultpool users
> ns_section "ns/servers/${sname}/modules"
> ns_param nsthread nsthread.so
> ns_param nssock nssock.so
> ns_param nslog nslog.so
> ns_param nsperm nsperm.so
> ns_param nsd nsd.so
> ns_param nsdb nsdb.so
> ns_param nscp nscp.so
Why are you trying to load nsd.so and nsthread.so as modules? That
makes no sense.
The other modules shouldn't hurt anything, but you certainly don't
need that many just to get AOLserver up and running. For a minimal
config just to let you test Oracle connectivity, try loading ONLY
these:
ns_section "ns/servers/${sname}/modules"
ns_param nssock nssock.so
ns_param nslog nslog.so
ns_param nsdb nsdb.so
> ns_section "ns/db/drivers"
> ns_param ora8 nsoracle.so
>
> ns_section "ns/db/pools"
> ns_param users users
Where is your "users" pool defined? I don't see it anywhere in your
config file.
> ns_section "ns/db/pool/users"
> ns_param Driver ora8
> ns_param Connections 5
> ns_param User system
> ns_param Password manager
> ns_param LogSQLErrors on
> ns_param Datasource "orcl"
> ns_param ExtendedTableInfo On
Can you connect to "orcl" via sqlplus? Try this:
sqlplus system/[EMAIL PROTECTED]
If that does not work, then your problem is that your Oracle client
configuration on this box is wrong. Most likely you need to fix your
"$ORACLE_HOME/network/admin/tnsnames.ora" file.
Where is this Oracle database running, on a remote machine? If
remote, then you need to use it as above. If the server is local, you
can also use 'ns_param Driver {}' above, to connect to Oracle using
it's Bequeath connection method.
> ns_section "ns/server/${servername}/db"
> ns_param pools * ;# Wildcard gives access to all
> ns_param defaultpool "main"
You have no "main" pool configured at all, so that's definitely
broken.
> ns_section ns/servers/${server}/db
> ns_param pools "*"
> ns_param defaultpool pool1
You've just repeated the same section as above, but using a different
server name variable. That makes little sense. Do you really have
both a $servername and $server Tcl variables defined in your config
file? Why? Looks like you have several simple Tcl bugs in your
config file.
--
Andrew Piskorski <[EMAIL PROTECTED]>
http://www.piskorski.com/
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
