(SOLVED) Failed to Upgrade to 1.0.1 ( Windows )

[zetoo]

I have installed :


MySQL 5.7.16
MySQL Workbench 6.3.8
PHP 5.5.33
Spine 0.8.8a
Net-SNMP 5.5.0-2
OpenSSL OpenSSL Light-1_0_2j
RRDTool 1.2.15-cygwin-1.5.20
VC++ 11 x64
VC++ 12 x64
Cacti 0.8.8f => 1.0.1
IIS 8.5
Window Server 2012


I tried to upgrade to 1.0.1 according to this link http://docs.cacti.net/manual:088:1_inst ... _upgrading

After all steps, I tried to access cacti http://serverip/cacti and got that HTTP 500 Internal Server Error.

This is my config :

$database_type = "mysql";
$database_dafault = "cacti";
$database_hostname = "127.0.0.1";
$database_username = "xxxx";
$database_password = "xxxx";
$database_port = "3306";
$database_ssl = false;

$url_path = "/cacti/";
$cacti_session_name = "Cacti";
$poller_id = 1;
$cacti_db_session = true;

Please help me to solve my issue

[canislupus]

I have had the same problem and could fixit by enabling php error reporting within the index.php:

enabling error reporting:
ini_set('Display_startup_errors',1);
ini_set('Display_errors',1);
error_reporting(-1);

The problem was some missing PHP extensions, so I have adjusted my php.ini with the missing extensions:
- php_openssl.dll
- php_pdo_mysql.dll
- php_com_dotnet.dll (this missed extension was the reason for the http 500 error! The other 2 extensions are mandatory for Cacti upgrade)
Restart of Apache or IIS is mandatory!

Hope I could help to get it started.

[zetoo]

I have had the same problem and could fixit by enabling php error reporting within the index.php:

enabling error reporting:
ini_set('Display_startup_errors',1);
ini_set('Display_errors',1);
error_reporting(-1);

The problem was some missing PHP extensions, so I have adjusted my php.ini with the missing extensions:
- php_openssl.dll
- php_pdo_mysql.dll
- php_com_dotnet.dll (this missed extension was the reason for the http 500 error! The other 2 extensions are mandatory for Cacti upgrade)
Restart of Apache or IIS is mandatory!

Hope I could help to get it started.

I can not find these in index.php

- ini_set('Display_startup_errors',1);
- ini_set('Display_errors',1);
- error_reporting(-1);


Then I check my php_errors which displaying :
- undefined class constant 'MYSQK_ATTR_FOUND_ROWS' in C:\inetpub\wwwroot\Cacti\lib\database.php on line 52

[zuessi]

Same issue here

[zetoo]

I have had the same problem and could fixit by enabling php error reporting within the index.php:

enabling error reporting:
ini_set('Display_startup_errors',1);
ini_set('Display_errors',1);
error_reporting(-1);

The problem was some missing PHP extensions, so I have adjusted my php.ini with the missing extensions:
- php_openssl.dll
- php_pdo_mysql.dll
- php_com_dotnet.dll (this missed extension was the reason for the http 500 error! The other 2 extensions are mandatory for Cacti upgrade)
Restart of Apache or IIS is mandatory!

Hope I could help to get it started.

I can not find these in index.php

- ini_set('Display_startup_errors',1);
- ini_set('Display_errors',1);
- error_reporting(-1);


Then I check my php_errors which displaying :
- undefined class constant 'MYSQK_ATTR_FOUND_ROWS' in C:\inetpub\wwwroot\Cacti\lib\database.php on line 52

Same issue here

Well, turns out after removing semicolon (;) or 'activating' these modules from php.ini:
- php_openssl.dll
- php_pdo_mysql.dll
- php_com_dotnet.dll

EDIT : Adding '?>' in config.php since the file I got from downloading 1.0.1 seems like forgot to add that tag.

Now I can continue to upgrade to 1.0.1. Thanks for solving my problem.

[cigamit]

EDIT : Adding '?>' in config.php since the file I got from downloading 1.0.1 seems like forgot to add that tag.

That shouldn't be necessary at all. Any closing tags should technically be removed otherwise trailing whitespace could be added to any output (and cause some headers to fail).

[zetoo]

EDIT : Adding '?>' in config.php since the file I got from downloading 1.0.1 seems like forgot to add that tag.

That shouldn't be necessary at all. Any closing tags should technically be removed otherwise trailing whitespace could be added to any output (and cause some headers to fail).

Well, another knowledge for me. Thanks

[zetoo]

Now, I am confused toward how to set up my.ini in mysql 5.7

Already tried to add these in C:\Program Files\MySQL\MySQL 5.7\my.ini and restart MYSQL57 service

[mysqld]
default_time_zone=xx/xx
max_allowed_packet=18M
join_buffer_size=64M
innodb_doublewrite = OFF
innodb_flush_log_at_timeout=3
innodb_read_io_threads=32
innodb_write_io_threads=16

*Got my.ini from copying my-default and rename to my.ini

But nothings happens, could someone give me some idea for what I am missing now?

Link : https://dev.mysql.com/doc/refman/5.7/en ... aults.html

[zetoo]

Fixed !

Populate my timezone table according to this https://dev.mysql.com/doc/refman/5.7/en ... pport.html

Also changed my.ini in C:\ProgramData\MySQL\MySQL Server 5.7 (Hidden), according to this http://stackoverflow.com/questions/8062 ... acket-size