Topic: sme9admin no data displayed.

[ber]

Hi Ive migrated my server onto a HP ProLiant ML330 G6 Hardware using the Affa contrib.
Everything worked initially.
After a week i tried to view the data on the sme9admin on the server-manager panel. There is no data displayed??
Ive tried to uninstall and reinstall still no data- network/sensor etc...

[root@server ~]# sensors
acpitz-virtual-0
Adapter: Virtual device
temp1:        +8.3°C  (crit = +31.3°C)

power_meter-acpi-0
Adapter: ACPI interface
power1:       0.00 nW  (interval = 300.00 s)

coretemp-isa-0001
Adapter: ISA adapter
Core 0:      +18.0°C  (high = +85.0°C, crit = +95.0°C)
Core 1:      +30.0°C  (high = +85.0°C, crit = +95.0°C)
Core 9:      +32.0°C  (high = +85.0°C, crit = +95.0°C)
Core 10:     +26.0°C  (high = +85.0°C, crit = +95

I suspect that the problem maybe due to a database problem.
I logged in using phpmyadmin and there is no sme9admin database.

[root@server ~]# config show phpmyadmin
phpmyadmin=configuration
    DbName=phpmyadmin
    DbPassword=###
    DbUser=phpmyadmin
    MemoryLimit=500M
    PostMaxSize=100M
    UploadMaxSize=100M
    access=private
    adminaccess=disabled
    multiaccess=enabled
    sqladminPassword=###
    status=enabled

Any help appreciated.
Regards John

[TerryF]

There is a bug logged Bug 10181 - sme9admin stop on mysql error

[guest22]

Ive tried to uninstall and reinstall still no data- network/sensor etc...

That is something you wouldn't do with existing data. Now it is difficult to find the root cause of your initial problem. Was the data ever there?

[Jean-Philippe Pialasse]

About the suggestion of HF,
In the case of sme*admin the data is kept in place except if you manaully delete. But still indeed this will be harder to debug.

As highlighted Terry,

the biggest probability would be a mysql error;  wrong password, try to copy the password from teh configuration page and set it in the user table of mysql using phpmyadmin as an example.
it could also be an error of mysql unavailable temporary ( mysql stoped at the moment mysqladmin try to write data) or too many connection at this moment.

they are identified and still need to be fixed.

for the moment check on the first page if it is running and launch it . If it fails in the next 5 minutes it should be the mysql password because of the hardware migration ( see this twice this month).