not display current power supply - plugin rack 1.0.0. (glpi .72)

JeanParpaillon · 2009-08-06 16:22:00

Hi,
When I connect a device to a power supply, through dropdown list on rack view, power cables number is incremented but the current power supply is not displayed, dropdown list prints: "----".

regards, and thanks for this excellent plugin.

tsmr · 2009-08-06 16:46:31

Reload page (this is because you have 2 same dropdowns)

JeanParpaillon · 2009-08-06 17:00:35

Hi,
Looking further, it sems that, regardless of the power supply I select, the value of glpi_plugin_rack_content.alim1 is always 127 if I set a power supply, and 0 otherwise. There is no power supply with id 127 in glpi_dropdown_plugin_rack_ways.

Any idea ?
Jean

tsmr · 2009-08-06 19:51:17

screenshots ? i don' understand

JeanParpaillon · 2009-08-07 09:41:07

On the following devices, I set 3 different power supplies, and I have the same value for alim1. For all other devices, I have set no power supply, and the value is 0.

mysql> select * from glpi_plugin_rack_content where alim1=127;
+----+---------+---------+---------+-----------+-------------+----------+-------+-------+--------+-----------+-------------+---------+
| ID | FK_rack | FK_face | FK_spec | FK_device | device_type | position | alim1 | alim2 | amps   | flow_rate | dissipation | weight  |
+----+---------+---------+---------+-----------+-------------+----------+-------+-------+--------+-----------+-------------+---------+
| 83 |       1 |       1 |       8 |       349 |           1 |       38 |   127 |     0 | 0.0000 |    0.0000 |      0.0000 | 14.1000 |
| 84 |       1 |       1 |       8 |       101 |           1 |       39 |   127 |     0 | 0.0000 |    0.0000 |      0.0000 | 14.1000 |
| 85 |       1 |       1 |       8 |       351 |           1 |       40 |   127 |     0 | 0.0000 |    0.0000 |      0.0000 | 14.1000 |
+----+---------+---------+---------+-----------+-------------+----------+-------+-------+--------+-----------+-------------+---------+
3 rows in set (0.00 sec)

There is no power supply with this id, as you can see:

mysql> select * from glpi_dropdown_plugin_rack_ways where id=127;
Empty set (0.00 sec)

Is it clearer ?

Thank you very much for your help.

Jean

JeanParpaillon · 2009-08-07 10:16:00

Hi,
I got it :-)

alim1 and alim2 columns are defined as tinyint, that means values from -127 to 127 which is not enough (I have 240 pwoer supplies). Upgrading the column definition from tinyint to int resolve the problem.

Jean

tsmr · 2009-08-16 11:20:11

Cool. Entre Rennais on aurait pu parler français, ca aurait été plus simple.

Je le corriges pour la prochaine version.

JeanParpaillon · 2009-08-17 09:19:48

Pas en public, tout de même :-)

tsmr · 2009-08-17 09:32:20

J'ai publié une nouvelle version (il y avait un autre bug)

https://forge.indepnet.net/projects/show/racks

Forum GLPI-Project

Announcement

#1 2009-08-06 16:22:00

not display current power supply - plugin rack 1.0.0. (glpi .72)

#2 2009-08-06 16:46:31

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#3 2009-08-06 17:00:35

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#4 2009-08-06 19:51:17

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#5 2009-08-07 09:41:07

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#6 2009-08-07 10:16:00

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#7 2009-08-16 11:20:11

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#8 2009-08-17 09:19:48

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

#9 2009-08-17 09:32:20

Re: not display current power supply - plugin rack 1.0.0. (glpi .72)

Board footer