Cacti (home)ForumsDocumentation

Differences

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

manual:100:1_installation.2_install_windows.5_install_mysql [2016/08/30 00:36]
BSOD2600
manual:100:1_installation.2_install_windows.5_install_mysql [2017/01/08 23:47] (current)
BSOD2600 timezone updates
Line 55: Line 55:
 </code> </code>
  
-=== Configure Database ===+=== Install TimeZone Database === 
 +  - Download TimeZone database from: http://dev.mysql.com/downloads/timezones.html  
 +  - Extract file 
 +  - Import:<code> 
 +c:\> mysql --user=root --password mysql < C:\downloads\timezone_posix.sql 
 +</code>  
 +  - Validate it works. The two queries below should return the same result in the form of central US time 2007-03-11 01:00:00<code> 
 +c:\> mysql --user=root --password mysql 
 +mysql> SELECT CONVERT_TZ('2007-03-11 2:00:00','US/Eastern','US/Central'); 
 +  +------------------------------------------------------------+ 
 +  | CONVERT_TZ('2007-03-11 2:00:00','US/Eastern','US/Central') | 
 +  +------------------------------------------------------------+ 
 +  | 2007-03-11 01:00:00                                        | 
 +  +------------------------------------------------------------+ 
 +  1 row in set (0.01 sec) 
 + 
 +mysql> SELECT CONVERT_TZ('2007-03-11 3:00:00','US/Eastern','US/Central'); 
 +  +------------------------------------------------------------+ 
 +  | CONVERT_TZ('2007-03-11 3:00:00','US/Eastern','US/Central') | 
 +  +------------------------------------------------------------+ 
 +  | 2007-03-11 01:00:00                                        | 
 +  +------------------------------------------------------------+ 
 +  1 row in set (0.00 sec) 
 +</code>  
 + 
 +=== Install Cacti Database ===
   - Create the MySQL database:<code>   - Create the MySQL database:<code>
 c:\> mysqladmin --user=root --password create cacti c:\> mysqladmin --user=root --password create cacti





Personal Tools