Error received when connecting to Spotlight with Monitor OS option enabled:
"An error occurred while refreshing the table "FileSystems" in connection"####"
An error occurred while refreshing the table "RunQueue" in connection"####"
An error occurred while refreshing the table "ProcessorsAdvanced" in connection"####"
An error occurred while refreshing the table "Processors" in connection"####"
An error occurred while refreshing the table "LogicalDisks" in connection"####"
An error occurred while refreshing the table "Memory" in connection"####"
An error occurred while refreshing the table "Paging" in connection"####""
On SUSE Linux Enterprise Server 9, the PasswordAuthentication parameter in file in the /etc/ssh/sshd_config is set to "no".
Set the PasswordAuthentication parameter in the /etc/ssh/sshd_config file to "yes".
1. Modify the sshd_config file in the /etc/ssh/ directory:
a. Login to the Suse Linux server as root.
b. Navigate to the /etc/ssh/ sshd_config file.
c. Change the PasswordAuthentication parameter to allow password authentication:
PasswordAuthentication yes
2. Restart the daemon, by issuing the following commands at the Linux command prompt:
a. ps -ef | grep sshd ( this will list the PID of the ssh daemon in the second column).
b. kill -HUP <PID> ( execute as root - this will reinitialize the ssh daemon - use PID found in ps command above.
3. Monitoring the OS again and connect to the database using Spotlight with the Monitor OS option enabled.
Additional Environment info:
SUSE Linux Enterprise Server 9 (SLES)
# ssh -V
OpenSSH_3.8p1, SSH protocols 1.5/2.0, OpenSSL 0.9.7d 17 Mar 2004
# uname -a
Linux linux 2.6.5-7.193-smp #1 SMP Wed Jul 20 14:39:18 UTC 2005 x86_64 x86_64 x86_64 GNU/Linux
This solution is also applicable to Spotlight on Oracle.
