Cacti user management not showing users list.

[cccchheekkiiee]

Dear Experts,

i am using cacti 0.8.7g, i have more than 150 users on the system.
Recently when loading the user management page (calling the user_admin.php function), the page wasn't loading properly, and immediately returning a white page.However i can see the number of users and i can filter the users.
This problem is only appearing every Wednesday and get back to normal all other weekdays.
Moreover, when using mysql queries to select users, i am getting normal results.

I tried to replace the user_admin.php with the latest one from svn with no changes.
no error logs are showing from the http nor from mysql.

Please advice

[TheWitness]

Does it immediately return with the blank page, or does it loop for a while? If it's loops, and then exists, you should clear the user log (Console->System Utilities). If it immediately goes to a blank page, edit Apache's PHP.INI file and increase the memory limit and restart Apache. Your Apache Error Log should also hold the answer.

TheWitness

[cccchheekkiiee]

Dear Witness,

Thank you for the reply.
the blank page is returned immediately.the memory in /etc/php.ini is already 200M.even-though i increased it to 300M and restart httpd and still the same problem.

Any idea?
Thank you in advance

[TheWitness]

What's in the apache error log?

[cccchheekkiiee]

nothing in the apache error log

[TheWitness]

Edit php.ini for Apache and change 'display_errors=On', restart apache and try again.

[cccchheekkiiee]

i enabled all apache logs:
display_error = On
error_reporting = E_ALL

there is no error logs related the user_admin.php.
All what i noticed is a PHP Notice: Undefined index: height in /var/www/html/lib/html.php on line 147

Thank you

[TheWitness]

Try this:

Code: Select all

select count(*) from user_log;

[cccchheekkiiee]

the query succeeded with 1 row set value=66637

[TheWitness]

Code: Select all

rename table user_log to user_log_backup;
create table user_log like user_log_backup;

Then bring up User Management again.

TheWitness

[cccchheekkiiee]

without doing any changes on the user_log table, When i just restart mysql the page is loading properly.

i will keep monitoring it for tomorrow and see if it will disapear again, so i will delete "user_log" table contents.

Thank you

[TheWitness]

You should tune mysql and php memory if you have enough, or purge that table from time to time.

[cccchheekkiiee]

Dear Witness,

I tried the purge option and flushed the user logs history, and things is going fine for the last 2 days.
I will keep checking it daily to see if the problem will occur again.

Thanks a million!
you saved my life:)

[TheWitness]

Definitely a memory limit issue either in the "memory_limit"or the "max_execution_time" settings in the Apache version of the php.ini file. If you have a lot of logins, you should purge this file regularly.

TheWitness

[cccchheekkiiee]

Absolutely right.
It was the max-table-limit of 64M in the my.cnf file.

Till now all is fine after the purge.

Thanks a lot...