On Sun, 24 Feb 2002, Scott S. Goodwin wrote: > You have logsqlerrors set to true; I guess that's why you're seeing the > NSINT in the log file. You'll want to figure out how to identify which SQL > statement causes this error.
The logsqlerrors param is intended to help identify the SQL statement; when set to true, logsqlerrors will cause the database module to log the SQL statement that caused an error. It exists so that you don't have to keep verbose on in a production system -- you can just turn logsqlerrors on, and then you'll see SQL only when there's a problem statement. (Since logsqlerrors only deals with logging of the SQL statement, it has nothing to do with the NSINT.) > With nspostgres, I turn on verbose mode. I don't know if the sybase db > module uses the verbose param The verbose param, like logsqlerrors, is part of the database module, so it doesn't matter which driver you're using. When using the Sybase driver, make sure you're running the nssybpd proxy in localdaemon mode; you suffer a big performance hit if you run the proxy as a remote daemon because the ns_pd protocol is stop-and-wait. The ns_pd protocol only allows the database driver to return one error message per SQL statement. Since Sybase can return multiple error messages, it logs all of the errors to the syslog, and you only get the last one in the AOLserver error log. Checking the syslog may reveal errors that can be corrected that may help things along. > > ns_param datasource "datasource_name" Datasources for sybase must have the format "SERVER:database" where "SERVER" is a Sybase server name, as defined in $SYBASE/interfaces, and "database" is the name of the specific database. Including the database is required; I can't remember the exact behavior, but I think if you don't include it the DB won't open. If there's a problem with the datasource name, the syslog may be helpful. > > Any way could you explain to me what it does mean with "exception NISNT" > > from email subject? Sorry I came in late on this. What was the logged message containing NSINT? Pete.
