Cacti (home)ForumsDocumentation

Differences

This shows you the differences between two versions of the page.

usertemplate:host:microsoft:sqlserver [2010/07/28 18:19]
lints
usertemplate:host:microsoft:sqlserver [2012/12/25 01:19] (current)
BSOD2600
Line 4: Line 4:
 usertemplate_nspage: host:microsoft:sqlserver usertemplate_nspage: host:microsoft:sqlserver
 author_page: wiki:user:lints author_page: wiki:user:lints
-description: Host template for Microsoft SQL Server 2000/2005/2008+description:Microsoft SQL Server 2000/2005/2008/2008 R2
 Cacti_Version: 0.8.7e Cacti_Version: 0.8.7e
 date: Jul-28-2010 date: Jul-28-2010
Line 17: Line 17:
 ===== Installation ===== ===== Installation =====
   - Install PHP's MSSQL libraries   - Install PHP's MSSQL libraries
-    * If using Red Hat based systems (RHEL, CentOS, Fedora, etc..), run 'yum install php-mssql' +    * If using Red Hat based systems (RHEL, CentOS, Fedora, etc..), run ''yum install php-mssql'
-    * If using Ubuntu based systems, run 'sudo apt-get install php5-sysbase'+    * If using Ubuntu based systems, run ''sudo apt-get install php5-sysbase'' 
 +    * If using FreeBSD based systems, run: 
 +      - ''cd /usr/ports/databases/php5-mssql''  
 +      - ''make install''  
 +      - ''cp /usr/local/etc/freetds.conf.dist /usr/local/etc/freetds.conf''
   - Un-tar the archive   - Un-tar the archive
   - For each SQL Server 2000 instance you want to graph:   - For each SQL Server 2000 instance you want to graph:
Line 25: Line 29:
       * If you changed the username on line 4, update the @loginname on lines 6, 8 & 10 to match       * If you changed the username on line 4, update the @loginname on lines 6, 8 & 10 to match
     - Run the script     - Run the script
-  - For each SQL 2005/2008 instance you want to graph:+  - For each SQL 2005/2008/2008 R2 instance you want to graph:
     - Launch the SQL Management Studio, open the file ''sql_server_2005-2008.sql'' from under the ''sql scripts'' folder     - Launch the SQL Management Studio, open the file ''sql_server_2005-2008.sql'' from under the ''sql scripts'' folder
     - Update line 4 with the username/password combination you want to use     - Update line 4 with the username/password combination you want to use
Line 43: Line 47:
 ===== Compatability ===== ===== Compatability =====
 These templates have been tested with: These templates have been tested with:
-  - SQL Server 2000, 2005 and 2008+  - SQL Server 2000, 2005, 2008 and 2008 R2
   - Windows 2003, 2008 & 2008 R2   - Windows 2003, 2008 & 2008 R2
  





Personal Tools