[solved] Users managment blank

zain · Post by **zain** » Thu Mar 12, 2009 8:00 am

Hello;
i have just faced an issue with cacti regarding the user management, when i select User management it doesn't display any users at all only the banner. i added a new user and when it directed me back to the list of users there is nothing.
please see attached file

can anyone help please

thanks a lot

Post by **TheWitness** » Fri Mar 13, 2009 9:14 pm

Can you please run the reapair script in the CLI directory. Also, what is your PHP memory set to?

TheWitness

zain · Post by **zain** » Sun Mar 15, 2009 4:30 am

Hello;
i run the cacti under Microsoft windows, IIS webserver. i didnt manage to find the repair script there. the PHP memory in the PHP.ini file is set to 32 and i increased it to 64 but the same issue.

Please help

thanks

BSOD2600 · Post by **BSOD2600** » Sun Mar 15, 2009 11:29 am

Double posting doesn't get you help any faster.

What version of windows, cacti, php, etc?

Post by **TheWitness** » Sun Mar 15, 2009 1:52 pm

I can't seem to figure this one out.

Larry

zain · Post by **zain** » Mon Mar 16, 2009 7:00 am

Hello;
i have double posted because i didnt know if it should be under general problems or Windows specific. anyways, below is the setup.

cacti-0.8.6j
php 5.2.1
MySQL 4.1

windows 2000
IIS Webserver

thanks alot

BSOD2600 · Post by **BSOD2600** » Mon Mar 16, 2009 12:24 pm

There have been so many bugs fixed since cacti-0.8.6j, I suggest you upgrade.

I highly doubt your user accounts no longer exist. To verify logon to the database and check. Post the results.

Code: Select all

mysql -u root -p cacti
select username from user_auth;

As a last resort, you can look in \cacti\cacti.sql and manually re-run the sql commands to import the default user accounts/passwords.

mcutting · Post by **mcutting** » Mon Mar 16, 2009 12:29 pm

zain wrote:Hello;
i run the cacti under Microsoft windows, IIS webserver. i didnt manage to find the repair script there. the PHP memory in the PHP.ini file is set to 32 and i increased it to 64 but the same issue.

Please help

thanks

Open a command prompt on the server, and issue IISRESET. If you've changed anything in php.ini, this won't be reflected until you restart the web services.

zain · Post by **zain** » Tue Mar 17, 2009 6:33 am

Hello;
i have restarted tyhe server it self with no luck. anyways, i have logged in the Mysql database and the users still exist but it seems that the users_log table is corrupted as shown below.

mysql> select * from user_log;
ERROR 145 (HY000): Table '.\cacti\user_log' is marked as crashed and should be r
epaired

Please advize

zain · Post by **zain** » Tue Mar 17, 2009 6:46 am

Hello;
i have repaired the user_log table and everything worked fine.
if anyone is interested please check the below link on how to maintain MySql databases.

http://felipecruz.com/repair-mysql-database.php

Thanks alot

BSOD2600 · Post by **BSOD2600** » Tue Mar 17, 2009 11:51 am

1) The cacti technical support page would've told you the tables were crashed.

2) You should've used the script \cacti\cli\rebuild_poller_cache.php to repair the database.

Post by **TheWitness** » Tue Mar 17, 2009 2:31 pm

I think the first thing I asked was for him to run the repair script...

TheWitness

Cacti

[solved] Users managment blank

[solved] Users managment blank

Users managment

Re: Users managment

Who is online