Windows All-In-One Installer [Cacti 1.2.24] [Updated 2023-03-09]

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
dvc
Posts: 18
Joined: Mon Apr 29, 2013 12:44 am

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by dvc »

BSOD2600 wrote: 1) The MySQL silent installer doesn't give an option on where its installed so it defaults to %ProgramFiles%. I'm not aware of any workaround. On the last page of the Cacti installer it should've listed the paths to review.
Yes, the path list did show that MySQL would be installed on C:
BSOD2600 wrote: 2) can you share more details about the specific error which prevented MySQL from starting? C:\ProgramData\MySQL\MySQL Server 5.6\data\*.err should contain the details. The my.ini was dynamically created by the MySQL installer apparently based off your system resources. I suspect the innodb_buffer_pool_size was dynamically configured. For example on my test Win2K8R2x64 VM with 2GB, the installer set innodb_buffer_pool_size=238M.
Here's the error log from the initial startup:

Code: Select all

2014-06-02 14:57:36 15696 [Note] Plugin 'FEDERATED' is disabled.
2014-06-02 14:57:36 4eec InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-06-02 14:57:36 15696 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-06-02 14:57:36 15696 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-02 14:57:36 15696 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-06-02 14:57:36 15696 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-02 14:57:36 15696 [Note] InnoDB: Not using CPU crc32 instructions
2014-06-02 14:57:36 15696 [Note] InnoDB: Initializing buffer pool, size = 3.0G
InnoDB: VirtualAlloc(181403648 bytes) failed; Windows error 8
2014-06-02 14:57:36 15696 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2014-06-02 14:57:36 15696 [ERROR] Plugin 'InnoDB' init function returned error.
2014-06-02 14:57:36 15696 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-06-02 14:57:36 15696 [ERROR] Unknown/unsupported storage engine: INNODB
2014-06-02 14:57:36 15696 [ERROR] Aborting
The server I used has 8G of memory, with 1.3 Gb used, so why it is failing to allocate 181403648 bytes is a mystery. In the ini file, the innodb buffer pool size was 3Gb with 18 instances so even on a 32 bit version of Windows I would have thought it would be ok. But, as I said, I don't need innodb so I just disabled it. Looking at it now, it may just be a problem with my server. Probably best to disregard my experience unless someone else gets the same result.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by BSOD2600 »

Windows error 8 = ERROR_NOT_ENOUGH_MEMORY. Not enough storage is available to process this command.
http://msdn.microsoft.com/en-us/library ... s.85).aspx

I'd agree, sounds like there is something else going on with your server.
pepsichanhvn
Posts: 1
Joined: Sat Jul 05, 2014 10:25 am

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by pepsichanhvn »

Hi, everybody,
I installed cacti on windown 7 successfully, i added devices and graphs completely, but my graphs don't display traffic. (refesh more 5 minutes and restart server some times. )
Can you guide me to trouble that problem ??

Thanks
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by BSOD2600 »

pepsichanhvn,
Please read through http://forums.cacti.net/viewtopic.php?f=3&t=11747 and then create a new thread, as your problem is not with the installer.
do the graphs display any data from the device in question?
Is snmp functional on the device?
dembo
Posts: 2
Joined: Sun Aug 31, 2014 10:04 pm

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by dembo »

I installed 0.8.8b. I cant access from internet(http://xxx.xxx.xxx.xxx/cacti). Few days ago it was normal. Now, localhost/cacti and local network(192.168.100.69/cacti) work. Help!!!
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by BSOD2600 »

dembo:
Please read through http://forums.cacti.net/viewtopic.php?f=3&t=11747 and then create a new thread, as your problem is not with the installer.
User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by smlick »

I tried last version 0.8.8b in my test environment.
I have the mysql on a separate server.
I set properly the authorization on the mysql to get connection from the Cacti server test (with the new version from your installer except mysql).
In the Cacti server i edited the "global" and the "config" file with the correct grant to access the cacti db on the remote server but I get "FATAL: Cannot connect to MySQL server".......
So it seems a connection denied to the db.
Have you any idea to solve step by step and test every step?

Regards
Alessio
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map
User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by smlick »

I solved in part!!
After rebooting the mysql server finally I was able to connect to it from the cacti server with the cactiuser grant.
After I logged with the browser the upgrade started and completed succesfully (all success).
After that only login page and then auth a blank page, I tried to reboot each server but doesn't happen anymore....only blank page.

Tell me if I have to move the post in the general windows topic or not because it could be a possible issue on the installer.

A PHP issue in the installer?

I saw a lot of post about the blank page but are for old Cacti version and about PHP or MySQL patch/php.ini

Any idea?

Regards
Alessio
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by BSOD2600 »

Does a phpinfo() page work?
Any errors logged into c:\php\php_errors.txt, windows event logs, IIS logs, mysql error log, etc?
User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by smlick »

I'll try to get all the log tomorrow.

I tried also a fresh install of your installer in a Windows 2008 X32 system but the setup wasn't able to start the mysql service.

Photo attached.

Why? I see a lot of post about this mysql issue (a problem in .ini file and allocation for innoDB if I'm not wrong)



Regards
Alessio
Attachments
cactierror.jpg
cactierror.jpg (124.85 KiB) Viewed 10361 times
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by BSOD2600 »

Again, look in the Windows event log and mysql error log for why it wouldnt start.
User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by smlick »

As I told you an issue with the Inno DB aperture size in my.ini
This is a known issue, but I don't know why at someone goes right and to other goes wrong.

This is the window error:

The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Shutting down plugin 'INNODB_LOCK_WAITS'

Do you need some additional info?
Is possible to delete o rem the innodb config part in my.ini?

Regards
Alessio
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by BSOD2600 »

smlick wrote:As I told you an issue with the Inno DB aperture size in my.ini
This is a known issue, but I don't know why at someone goes right and to other goes wrong.
What is the exact wording of the error you're seeing that makes you believe its innodb?
C:\ProgramData\MySQL\MySQL 5.6\Log\*.err should have the details needed.
smlick wrote:Is possible to delete o rem the innodb config part in my.ini?
Should be. Cacti uses MyISAM.
User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by smlick »

I know that Cacti use MyISAM infact I asked you if it's possible to delete or rem the innoDB part in my.ini
I solved a lot of installation with this trick.
Tomorrow I'll look at the MySQL log file and I'll give you also some link that talk about this installation issue.


Regards
Alessio
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map
User avatar
smlick
Cacti User
Posts: 267
Joined: Tue May 20, 2008 4:09 am
Location: Italy, Rome

Re: Windows Installer [Cacti 0.8.8b] [Updated 2014-06-01]

Post by smlick »

This is the .err log


2014-10-29 15:23:30 2604 [Note] Plugin 'FEDERATED' is disabled.
2014-10-29 15:23:30 a84 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-10-29 15:23:30 2604 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-29 15:23:30 2604 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-29 15:23:30 2604 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-29 15:23:30 2604 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-29 15:23:30 2604 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-29 15:23:30 2604 [Note] InnoDB: Initializing buffer pool, size = 2.0G
InnoDB: VirtualAlloc(272105472 bytes) failed; Windows error 8
2014-10-29 15:23:31 2604 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2014-10-29 15:23:31 2604 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-29 15:23:31 2604 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-29 15:23:31 2604 [ERROR] Unknown/unsupported storage engine: INNODB
2014-10-29 15:23:31 2604 [ERROR] Aborting

2014-10-29 15:23:31 2604 [Note] Binlog end
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'partition'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_METRICS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_CMP'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'INNODB_TRX'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'BLACKHOLE'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'ARCHIVE'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'MRG_MYISAM'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'MyISAM'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'MEMORY'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'CSV'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'sha256_password'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'mysql_old_password'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'mysql_native_password'
2014-10-29 15:23:31 2604 [Note] Shutting down plugin 'binlog'
2014-10-29 15:23:31 2604 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: Shutdown complete


Regards
Alessio
Cacti Version 0.8.8c production / 0.8.8c test W2008 -- Plugin:Weathermap - Monitor - CAMM 1.6.7 :) - Nectar - GPS Map
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests