Statistics empty

Hello,

When I click on statistics,
I've got this message :
No Inventory data has been found - add some hosts and facts and try
again

lot of hosts and facts are actually in foreman so what's wrong ?

Vincent

what does the log say? its probably failing on one of statistics
generation…

··· On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote: > Hello, > > When I click on statistics, > I've got this message : > No Inventory data has been found - add some hosts and facts and try > again > > lot of hosts and facts are actually in foreman so what's wrong ? > > Vincent >

not very explicit

Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22
09:42:01) [GET]
skipped as it has has no label
skipped as it has has no label
skipped as it has has no label
Unknown string
Rendering template within layouts/application
Completed in 167ms (View: 26, DB: 17) | 200 OK [http://foreman.bc/
statistics]

··· On Jun 21, 3:37 pm, Ohad Levy wrote: > On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote: > > Hello, > > > When I click on statistics, > > I've got this message : > > No Inventory data has been found - add some hosts and facts and try > > again > > > lot of hosts and facts are actually in foreman so what's wrong ? > > > Vincent > > what does the log say? its probably failing on one of statistics > generation..

any tips to remove quickly the esc color key ?

on debug :

Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22
15:46:05) [GET]
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE (users.id = 2) ESC[0m
Setting current user thread-local variable to vincent
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count() AS count_all,
operatingsystem_id AS operatingsystem_id FROM hosts GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROM operatingsystems WHERE (operatingsystems.id IN
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY
LOWER(operatingsystems.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(
) AS count_all,
architecture_id AS architecture_id FROM hosts GROUP BY
architecture_id ESC[0m
ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
architectures WHERE (architectures.id IN (1,2,3)) ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count() AS count_all,
environment_id AS environment_id FROM hosts GROUP BY environment_id
ESC[0m
ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
environments WHERE (environments.id IN (1,2)) ORDER BY
LOWER(environments.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT
hosts.id) AS count_all, puppetclass_id AS puppetclass_id FROM
hosts LEFT OUTER JOIN hosts_puppetclasses ON
hosts_puppetclasses.host_id = hosts.id LEFT OUTER JOIN
puppetclasses ON puppetclasses.id =
hosts_puppetclasses.puppetclass_id GROUP BY puppetclass_id ESC[0m
ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 1) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 2) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
'processorcount') ESC[0m
ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
'manufacturer') ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name = 'memorysize')
ESC[0m
Unknown string
Rendering template within layouts/application
Rendered home/_topbar (0.9ms)
ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM notices
INNER JOIN user_notices ON notices.id = user_notices.notice_id
WHERE (user_notices.user_id = 2 ) ESC[0m
ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT
usergroups.
FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.usergroup_id WHERE
((usergroup_members.member_type = 'User') AND
(usergroup_members.member_id = 2)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT
usergroups.* FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.member_id AND
usergroup_members.member_type = 'Usergroup' WHERE
((usergroup_members.usergroup_id = 1)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT users.* FROM
users INNER JOIN usergroup_members ON users.id =
usergroup_members.member_id AND usergroup_members.member_type =
'User' WHERE ((usergroup_members.usergroup_id = 1)) ESC[0m
ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
bookmarks WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id in
(1) AND bookmarks.owner_type = 'Usergroup') OR (bookmarks.owner_id = 2
AND bookmarks.owner_type = 'User'))) ORDER BY nameESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE (users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (2.0ms)
Rendered bookmarks/_list (0.7ms)
Rendered bookmarks/_list (0.5ms)
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (0.1ms)
Rendered home/_settings (1.2ms)
Rendered home/_menu (15.6ms)
Completed in 121ms (View: 20, DB: 14) | 200 OK [http://foreman.bc/
statistics]

··· On Jun 22, 9:43 am, Vincent wrote: > not very explicit > > Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 > 09:42:01) [GET] > skipped as it has has no label > skipped as it has has no label > skipped as it has has no label > Unknown string > Rendering template within layouts/application > Completed in 167ms (View: 26, DB: 17) | 200 OK [http://foreman.bc/ > statistics] > > On Jun 21, 3:37 pm, Ohad Levy wrote: > > > > > > > > > On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote: > > > Hello, > > > > When I click on statistics, > > > I've got this message : > > > No Inventory data has been found - add some hosts and facts and try > > > again > > > > lot of hosts and facts are actually in foreman so what's wrong ? > > > > Vincent > > > what does the log say? its probably failing on one of statistics > > generation..

can you simply paste it again it pastie.org or similar?

thanks

··· On Wed, Jun 22, 2011 at 4:53 PM, Vincent wrote: > any tips to remove quickly the esc color key ? > > > on debug : > > Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 > 15:46:05) [GET] > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM `users` > WHERE (`users`.`id` = 2) ESC[0m > Setting current user thread-local variable to vincent > ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > operatingsystem_id AS operatingsystem_id FROM `hosts` GROUP BY > operatingsystem_id ESC[0m > ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT * > FROM `operatingsystems` WHERE (`operatingsystems`.`id` IN > (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY > LOWER(operatingsystems.name)ESC[0m > skipped as it has has no label > ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > architecture_id AS architecture_id FROM `hosts` GROUP BY > architecture_id ESC[0m > ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > `architectures` WHERE (`architectures`.`id` IN (1,2,3)) ESC[0m > skipped as it has has no label > ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > environment_id AS environment_id FROM `hosts` GROUP BY environment_id > ESC[0m > ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > `environments` WHERE (`environments`.`id` IN (1,2)) ORDER BY > LOWER(environments.name)ESC[0m > skipped as it has has no label > ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT > `hosts`.id) AS count_all, puppetclass_id AS puppetclass_id FROM > `hosts` LEFT OUTER JOIN `hosts_puppetclasses` ON > `hosts_puppetclasses`.host_id = `hosts`.id LEFT OUTER JOIN > `puppetclasses` ON `puppetclasses`.id = > `hosts_puppetclasses`.puppetclass_id GROUP BY puppetclass_id ESC[0m > ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > `puppetclasses` WHERE (`puppetclasses`.`id` = 1) ORDER BY > LOWER(puppetclasses.name)ESC[0m > ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM > `puppetclasses` WHERE (`puppetclasses`.`id` = 2) ORDER BY > LOWER(puppetclasses.name)ESC[0m > ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = > 'processorcount') ESC[0m > ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = > 'manufacturer') ESC[0m > ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = 'memorysize') > ESC[0m > Unknown string > Rendering template within layouts/application > Rendered home/_topbar (0.9ms) > ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM `notices` > INNER JOIN `user_notices` ON `notices`.id = `user_notices`.notice_id > WHERE (`user_notices`.user_id = 2 ) ESC[0m > ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT > `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON > `usergroups`.id = `usergroup_members`.usergroup_id WHERE > ((`usergroup_members`.member_type = 'User') AND > (`usergroup_members`.member_id = 2)) ORDER BY > LOWER(usergroups.name)ESC[0m > ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT > `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON > `usergroups`.id = `usergroup_members`.member_id AND > `usergroup_members`.member_type = 'Usergroup' WHERE > ((`usergroup_members`.usergroup_id = 1)) ORDER BY > LOWER(usergroups.name)ESC[0m > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT `users`.* FROM > `users` INNER JOIN `usergroup_members` ON `users`.id = > `usergroup_members`.member_id AND `usergroup_members`.member_type = > 'User' WHERE ((`usergroup_members`.usergroup_id = 1)) ESC[0m > ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM > `bookmarks` WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id in > (1) AND bookmarks.owner_type = 'Usergroup') OR (bookmarks.owner_id = 2 > AND bookmarks.owner_type = 'User'))) ORDER BY nameESC[0m > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM `users` > WHERE (`users`.`id` = 1) ESC[0m > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > (`users`.`id` = 2) ESC[0m > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > (`users`.`id` = 1) ESC[0m > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > (`users`.`id` = 1) ESC[0m > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > (`users`.`id` = 1) ESC[0m > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > (`users`.`id` = 2) ESC[0m > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > (`users`.`id` = 1) ESC[0m > Rendered bookmarks/_list (0.1ms) > Rendered bookmarks/_list (2.0ms) > Rendered bookmarks/_list (0.7ms) > Rendered bookmarks/_list (0.5ms) > Rendered bookmarks/_list (0.1ms) > Rendered bookmarks/_list (0.1ms) > Rendered home/_settings (1.2ms) > Rendered home/_menu (15.6ms) > Completed in 121ms (View: 20, DB: 14) | 200 OK [http://foreman.bc/ > statistics] > > > On Jun 22, 9:43 am, Vincent wrote: >> not very explicit >> >> Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 >> 09:42:01) [GET] >> skipped as it has has no label >> skipped as it has has no label >> skipped as it has has no label >> Unknown string >> Rendering template within layouts/application >> Completed in 167ms (View: 26, DB: 17) | 200 OK [http://foreman.bc/ >> statistics] >> >> On Jun 21, 3:37 pm, Ohad Levy wrote: >> >> >> >> >> >> >> >> > On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote: >> > > Hello, >> >> > > When I click on statistics, >> > > I've got this message : >> > > No Inventory data has been found - add some hosts and facts and try >> > > again >> >> > > lot of hosts and facts are actually in foreman so what's wrong ? >> >> > > Vincent >> >> > what does the log say? its probably failing on one of statistics >> > generation.. > > -- > You received this message because you are subscribed to the Google Groups "Foreman users" group. > To post to this group, send email to foreman-users@googlegroups.com. > To unsubscribe from this group, send email to foreman-users+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/foreman-users?hl=en. > >

not sure it helps

http://pastie.org/2115062

··· On Jun 22, 3:58 pm, Ohad Levy wrote: > can you simply paste it again it pastie.org or similar? > > thanks > > > > > > > > On Wed, Jun 22, 2011 at 4:53 PM, Vincent wrote: > > any tips to remove quickly the esc color key ? > > > on debug : > > > Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 > > 15:46:05) [GET] > > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM `users` > > WHERE (`users`.`id` = 2) ESC[0m > > Setting current user thread-local variable to vincent > > ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > > operatingsystem_id AS operatingsystem_id FROM `hosts` GROUP BY > > operatingsystem_id ESC[0m > > ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT * > > FROM `operatingsystems` WHERE (`operatingsystems`.`id` IN > > (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY > > LOWER(operatingsystems.name)ESC[0m > > skipped as it has has no label > > ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > > architecture_id AS architecture_id FROM `hosts` GROUP BY > > architecture_id ESC[0m > > ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > > `architectures` WHERE (`architectures`.`id` IN (1,2,3)) ESC[0m > > skipped as it has has no label > > ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > > environment_id AS environment_id FROM `hosts` GROUP BY environment_id > > ESC[0m > > ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > > `environments` WHERE (`environments`.`id` IN (1,2)) ORDER BY > > LOWER(environments.name)ESC[0m > > skipped as it has has no label > > ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT > > `hosts`.id) AS count_all, puppetclass_id AS puppetclass_id FROM > > `hosts` LEFT OUTER JOIN `hosts_puppetclasses` ON > > `hosts_puppetclasses`.host_id = `hosts`.id LEFT OUTER JOIN > > `puppetclasses` ON `puppetclasses`.id = > > `hosts_puppetclasses`.puppetclass_id GROUP BY puppetclass_id ESC[0m > > ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > > `puppetclasses` WHERE (`puppetclasses`.`id` = 1) ORDER BY > > LOWER(puppetclasses.name)ESC[0m > > ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM > > `puppetclasses` WHERE (`puppetclasses`.`id` = 2) ORDER BY > > LOWER(puppetclasses.name)ESC[0m > > ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM > > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = > > 'processorcount') ESC[0m > > ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM > > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = > > 'manufacturer') ESC[0m > > ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM > > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = 'memorysize') > > ESC[0m > > Unknown string > > Rendering template within layouts/application > > Rendered home/_topbar (0.9ms) > > ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM `notices` > > INNER JOIN `user_notices` ON `notices`.id = `user_notices`.notice_id > > WHERE (`user_notices`.user_id = 2 ) ESC[0m > > ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT > > `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON > > `usergroups`.id = `usergroup_members`.usergroup_id WHERE > > ((`usergroup_members`.member_type = 'User') AND > > (`usergroup_members`.member_id = 2)) ORDER BY > > LOWER(usergroups.name)ESC[0m > > ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT > > `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON > > `usergroups`.id = `usergroup_members`.member_id AND > > `usergroup_members`.member_type = 'Usergroup' WHERE > > ((`usergroup_members`.usergroup_id = 1)) ORDER BY > > LOWER(usergroups.name)ESC[0m > > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT `users`.* FROM > > `users` INNER JOIN `usergroup_members` ON `users`.id = > > `usergroup_members`.member_id AND `usergroup_members`.member_type = > > 'User' WHERE ((`usergroup_members`.usergroup_id = 1)) ESC[0m > > ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM > > `bookmarks` WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id in > > (1) AND bookmarks.owner_type = 'Usergroup') OR (bookmarks.owner_id = 2 > > AND bookmarks.owner_type = 'User'))) ORDER BY nameESC[0m > > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM `users` > > WHERE (`users`.`id` = 1) ESC[0m > > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > > (`users`.`id` = 2) ESC[0m > > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > > (`users`.`id` = 1) ESC[0m > > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > > (`users`.`id` = 1) ESC[0m > > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > > (`users`.`id` = 1) ESC[0m > > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > > (`users`.`id` = 2) ESC[0m > > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > > (`users`.`id` = 1) ESC[0m > > Rendered bookmarks/_list (0.1ms) > > Rendered bookmarks/_list (2.0ms) > > Rendered bookmarks/_list (0.7ms) > > Rendered bookmarks/_list (0.5ms) > > Rendered bookmarks/_list (0.1ms) > > Rendered bookmarks/_list (0.1ms) > > Rendered home/_settings (1.2ms) > > Rendered home/_menu (15.6ms) > > Completed in 121ms (View: 20, DB: 14) | 200 OK [http://foreman.bc/ > > statistics] > > > On Jun 22, 9:43 am, Vincent wrote: > >> not very explicit > > >> Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 > >> 09:42:01) [GET] > >> skipped as it has has no label > >> skipped as it has has no label > >> skipped as it has has no label > >> Unknown string > >> Rendering template within layouts/application > >> Completed in 167ms (View: 26, DB: 17) | 200 OK [http://foreman.bc/ > >> statistics] > > >> On Jun 21, 3:37 pm, Ohad Levy wrote: > > >> > On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote: > >> > > Hello, > > >> > > When I click on statistics, > >> > > I've got this message : > >> > > No Inventory data has been found - add some hosts and facts and try > >> > > again > > >> > > lot of hosts and facts are actually in foreman so what's wrong ? > > >> > > Vincent > > >> > what does the log say? its probably failing on one of statistics > >> > generation.. > > > -- > > You received this message because you are subscribed to the Google Groups "Foreman users" group. > > To post to this group, send email to foreman-users@googlegroups.com. > > To unsubscribe from this group, send email to foreman-users+unsubscribe@googlegroups.com. > > For more options, visit this group athttp://groups.google.com/group/foreman-users?hl=en.

always no statistics …
any update ?

··· On Jun 24, 10:16 am, Vincent wrote: > not sure it helps > > http://pastie.org/2115062 > > On Jun 22, 3:58 pm, Ohad Levy wrote: > > > > > > > > > can you simply paste it again it pastie.org or similar? > > > thanks > > > On Wed, Jun 22, 2011 at 4:53 PM, Vincent wrote: > > > any tips to remove quickly the esc color key ? > > > > on debug : > > > > Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 > > > 15:46:05) [GET] > > > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM `users` > > > WHERE (`users`.`id` = 2) ESC[0m > > > Setting current user thread-local variable to vincent > > > ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > > > operatingsystem_id AS operatingsystem_id FROM `hosts` GROUP BY > > > operatingsystem_id ESC[0m > > > ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT * > > > FROM `operatingsystems` WHERE (`operatingsystems`.`id` IN > > > (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY > > > LOWER(operatingsystems.name)ESC[0m > > > skipped as it has has no label > > > ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > > > architecture_id AS architecture_id FROM `hosts` GROUP BY > > > architecture_id ESC[0m > > > ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > > > `architectures` WHERE (`architectures`.`id` IN (1,2,3)) ESC[0m > > > skipped as it has has no label > > > ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count(*) AS count_all, > > > environment_id AS environment_id FROM `hosts` GROUP BY environment_id > > > ESC[0m > > > ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > > > `environments` WHERE (`environments`.`id` IN (1,2)) ORDER BY > > > LOWER(environments.name)ESC[0m > > > skipped as it has has no label > > > ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT > > > `hosts`.id) AS count_all, puppetclass_id AS puppetclass_id FROM > > > `hosts` LEFT OUTER JOIN `hosts_puppetclasses` ON > > > `hosts_puppetclasses`.host_id = `hosts`.id LEFT OUTER JOIN > > > `puppetclasses` ON `puppetclasses`.id = > > > `hosts_puppetclasses`.puppetclass_id GROUP BY puppetclass_id ESC[0m > > > ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM > > > `puppetclasses` WHERE (`puppetclasses`.`id` = 1) ORDER BY > > > LOWER(puppetclasses.name)ESC[0m > > > ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM > > > `puppetclasses` WHERE (`puppetclasses`.`id` = 2) ORDER BY > > > LOWER(puppetclasses.name)ESC[0m > > > ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM > > > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > > > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = > > > 'processorcount') ESC[0m > > > ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM > > > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > > > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = > > > 'manufacturer') ESC[0m > > > ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM > > > `fact_values` INNER JOIN `fact_names` ON `fact_names`.id = > > > `fact_values`.fact_name_id WHERE (`fact_names`.`name` = 'memorysize') > > > ESC[0m > > > Unknown string > > > Rendering template within layouts/application > > > Rendered home/_topbar (0.9ms) > > > ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM `notices` > > > INNER JOIN `user_notices` ON `notices`.id = `user_notices`.notice_id > > > WHERE (`user_notices`.user_id = 2 ) ESC[0m > > > ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT > > > `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON > > > `usergroups`.id = `usergroup_members`.usergroup_id WHERE > > > ((`usergroup_members`.member_type = 'User') AND > > > (`usergroup_members`.member_id = 2)) ORDER BY > > > LOWER(usergroups.name)ESC[0m > > > ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT > > > `usergroups`.* FROM `usergroups` INNER JOIN `usergroup_members` ON > > > `usergroups`.id = `usergroup_members`.member_id AND > > > `usergroup_members`.member_type = 'Usergroup' WHERE > > > ((`usergroup_members`.usergroup_id = 1)) ORDER BY > > > LOWER(usergroups.name)ESC[0m > > > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT `users`.* FROM > > > `users` INNER JOIN `usergroup_members` ON `users`.id = > > > `usergroup_members`.member_id AND `usergroup_members`.member_type = > > > 'User' WHERE ((`usergroup_members`.usergroup_id = 1)) ESC[0m > > > ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM > > > `bookmarks` WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id in > > > (1) AND bookmarks.owner_type = 'Usergroup') OR (bookmarks.owner_id = 2 > > > AND bookmarks.owner_type = 'User'))) ORDER BY nameESC[0m > > > ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM `users` > > > WHERE (`users`.`id` = 1) ESC[0m > > > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > > > (`users`.`id` = 2) ESC[0m > > > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > > > (`users`.`id` = 1) ESC[0m > > > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > > > (`users`.`id` = 1) ESC[0m > > > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > > > (`users`.`id` = 1) ESC[0m > > > ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM `users` WHERE > > > (`users`.`id` = 2) ESC[0m > > > ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM `users` WHERE > > > (`users`.`id` = 1) ESC[0m > > > Rendered bookmarks/_list (0.1ms) > > > Rendered bookmarks/_list (2.0ms) > > > Rendered bookmarks/_list (0.7ms) > > > Rendered bookmarks/_list (0.5ms) > > > Rendered bookmarks/_list (0.1ms) > > > Rendered bookmarks/_list (0.1ms) > > > Rendered home/_settings (1.2ms) > > > Rendered home/_menu (15.6ms) > > > Completed in 121ms (View: 20, DB: 14) | 200 OK [http://foreman.bc/ > > > statistics] > > > > On Jun 22, 9:43 am, Vincent wrote: > > >> not very explicit > > > >> Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22 > > >> 09:42:01) [GET] > > >> skipped as it has has no label > > >> skipped as it has has no label > > >> skipped as it has has no label > > >> Unknown string > > >> Rendering template within layouts/application > > >> Completed in 167ms (View: 26, DB: 17) | 200 OK [http://foreman.bc/ > > >> statistics] > > > >> On Jun 21, 3:37 pm, Ohad Levy wrote: > > > >> > On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote: > > >> > > Hello, > > > >> > > When I click on statistics, > > >> > > I've got this message : > > >> > > No Inventory data has been found - add some hosts and facts and try > > >> > > again > > > >> > > lot of hosts and facts are actually in foreman so what's wrong ? > > > >> > > Vincent > > > >> > what does the log say? its probably failing on one of statistics > > >> > generation.. > > > > -- > > > You received this message because you are subscribed to the Google Groups "Foreman users" group. > > > To post to this group, send email to foreman-users@googlegroups.com. > > > To unsubscribe from this group, send email to foreman-users+unsubscribe@googlegroups.com. > > > For more options, visit this group athttp://groups.google.com/group/foreman-users?hl=en.

> always no statistics …
> any update ?
since its a bit hard to debug this way, I would suggest the following

look at app/controllers/statistics_controller.rb and try to comment out
each variable (you can probably comment out the whole json thing).

then you should also comment out the graph view it self at
pp/views/statistics/index.html.erb.

This will probably allow you to figure out which graph is breaking…

Ohad

··· On Tue, 2011-06-28 at 04:26 -0700, Vincent wrote:

On Jun 24, 10:16 am, Vincent vlouvi...@gmail.com wrote:

not sure it helps

http://pastie.org/2115062

On Jun 22, 3:58 pm, Ohad Levy ohadl...@gmail.com wrote:

can you simply paste it again it pastie.org or similar?

thanks

On Wed, Jun 22, 2011 at 4:53 PM, Vincent vlouvi...@gmail.com wrote:

any tips to remove quickly the esc color key ?

on debug :

Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22
15:46:05) [GET]
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE (users.id = 2) ESC[0m
Setting current user thread-local variable to vincent
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count() AS count_all,
operatingsystem_id AS operatingsystem_id FROM hosts GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROM operatingsystems WHERE (operatingsystems.id IN
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY
LOWER(operatingsystems.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(
) AS count_all,
architecture_id AS architecture_id FROM hosts GROUP BY
architecture_id ESC[0m
ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
architectures WHERE (architectures.id IN (1,2,3)) ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count() AS count_all,
environment_id AS environment_id FROM hosts GROUP BY environment_id
ESC[0m
ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
environments WHERE (environments.id IN (1,2)) ORDER BY
LOWER(environments.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT
hosts.id) AS count_all, puppetclass_id AS puppetclass_id FROM
hosts LEFT OUTER JOIN hosts_puppetclasses ON
hosts_puppetclasses.host_id = hosts.id LEFT OUTER JOIN
puppetclasses ON puppetclasses.id =
hosts_puppetclasses.puppetclass_id GROUP BY puppetclass_id ESC[0m
ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 1) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 2) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘processorcount’) ESC[0m
ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘manufacturer’) ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name = ‘memorysize’)
ESC[0m
Unknown string
Rendering template within layouts/application
Rendered home/_topbar (0.9ms)
ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM notices
INNER JOIN user_notices ON notices.id = user_notices.notice_id
WHERE (user_notices.user_id = 2 ) ESC[0m
ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT
usergroups.
FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.usergroup_id WHERE
((usergroup_members.member_type = ‘User’) AND
(usergroup_members.member_id = 2)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT
usergroups.* FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.member_id AND
usergroup_members.member_type = ‘Usergroup’ WHERE
((usergroup_members.usergroup_id = 1)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT users.* FROM
users INNER JOIN usergroup_members ON users.id =
usergroup_members.member_id AND usergroup_members.member_type =
‘User’ WHERE ((usergroup_members.usergroup_id = 1)) ESC[0m
ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
bookmarks WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id in
(1) AND bookmarks.owner_type = ‘Usergroup’) OR (bookmarks.owner_id = 2
AND bookmarks.owner_type = ‘User’))) ORDER BY nameESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE (users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (2.0ms)
Rendered bookmarks/_list (0.7ms)
Rendered bookmarks/_list (0.5ms)
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (0.1ms)
Rendered home/_settings (1.2ms)
Rendered home/_menu (15.6ms)
Completed in 121ms (View: 20, DB: 14) | 200 OK [http://foreman.bc/
statistics]

On Jun 22, 9:43 am, Vincent vlouvi...@gmail.com wrote:

not very explicit

Processing StatisticsController#index (for 10.115.23.53 at 2011-06-22
09:42:01) [GET]
skipped as it has has no label
skipped as it has has no label
skipped as it has has no label
Unknown string
Rendering template within layouts/application
Completed in 167ms (View: 26, DB: 17) | 200 OK [http://foreman.bc/
statistics]

On Jun 21, 3:37 pm, Ohad Levy ohadl...@gmail.com wrote:

On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote:

Hello,

When I click on statistics,
I’ve got this message :
No Inventory data has been found - add some hosts and facts and try
again

lot of hosts and facts are actually in foreman so what’s wrong ?

Vincent

what does the log say? its probably failing on one of statistics
generation…


You received this message because you are subscribed to the Google Groups “Foreman users” group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/foreman-users?hl=en.

The trouble is coming with

@mem_size = FactValue.mem_average "memorysize"

and in the log


FactValue Load (6.2ms) SELECT value FROM fact_values INNER JOIN
fact_names ON fact_names.id = fact_values.fact_name_id WHERE
(fact_names.name = 'memorysize')
Unknown string

the sql output look like that, I suspect an error to convert GB or MB to
number

Vincent

··· > 1.96 GB | > 3.96 GB | > 3.96 GB | > 7.92 GB | > 3.21 GB | > 1.96 GB | > 3.21 GB | > 1010.87 MB | > 3.96 GB | > 3.21 GB | > 3.96 GB | > 3.21 GB | > 3.96 GB | > 3.21 GB | > 3.96 GB | > 3.96 GB | > 3.96 GB | > 3.96 GB | > 3.87 GB | > 3.90 GB | > 4.73 GB | > 2.95 GB | > 3.96 GB | > 3.12 GB | > 1000.18 MB | > 200.14 MB | > 3.96 GB | > 3.96 GB | > 1010.87 MB | > 3.96 GB | > 3.96 GB | > 3.96 GB | > 3.90 GB | > 15.86 GB | > 1.98 GB | > 3.21 GB | > 3.87 GB | > 3.21 GB | > 3.96 GB | > 3.21 GB | > 3.87 GB | > 249.79 MB | > 3.21 GB | > 3.90 GB | > 3.47 GB | > 3.96 GB |

2011/6/28 Ohad Levy ohadlevy@gmail.com

On Tue, 2011-06-28 at 04:26 -0700, Vincent wrote:

always no statistics …
any update ?
since its a bit hard to debug this way, I would suggest the following

look at app/controllers/statistics_controller.rb and try to comment out
each variable (you can probably comment out the whole json thing).

then you should also comment out the graph view it self at
pp/views/statistics/index.html.erb.

This will probably allow you to figure out which graph is breaking…

Ohad

On Jun 24, 10:16 am, Vincent vlouvi...@gmail.com wrote:

not sure it helps

http://pastie.org/2115062

On Jun 22, 3:58 pm, Ohad Levy ohadl...@gmail.com wrote:

can you simply paste it again it pastie.org or similar?

thanks

On Wed, Jun 22, 2011 at 4:53 PM, Vincent vlouvi...@gmail.com > wrote:

any tips to remove quickly the esc color key ?

on debug :

Processing StatisticsController#index (for 10.115.23.53 at
2011-06-22

15:46:05) [GET]
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE (users.id = 2) ESC[0m
Setting current user thread-local variable to vincent
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count() AS count_all,
operatingsystem_id AS operatingsystem_id FROM hosts GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROM operatingsystems WHERE (operatingsystems.id IN
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY
LOWER(operatingsystems.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(
) AS count_all,
architecture_id AS architecture_id FROM hosts GROUP BY
architecture_id ESC[0m
ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
architectures WHERE (architectures.id IN (1,2,3)) ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count(*) AS count_all,
environment_id AS environment_id FROM hosts GROUP BY
environment_id

ESC[0m
ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
environments WHERE (environments.id IN (1,2)) ORDER BY
LOWER(environments.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT
hosts.id) AS count_all, puppetclass_id AS puppetclass_id FROM
hosts LEFT OUTER JOIN hosts_puppetclasses ON
hosts_puppetclasses.host_id = hosts.id LEFT OUTER JOIN
puppetclasses ON puppetclasses.id =
hosts_puppetclasses.puppetclass_id GROUP BY puppetclass_id ESC[0m
ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 1) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 2) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value
FROM

fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘processorcount’) ESC[0m
ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘manufacturer’) ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value
FROM

fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘memorysize’)

ESC[0m
Unknown string
Rendering template within layouts/application
Rendered home/_topbar (0.9ms)
ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
notices

INNER JOIN user_notices ON notices.id =
user_notices.notice_id

WHERE (user_notices.user_id = 2 ) ESC[0m
ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT
usergroups.* FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.usergroup_id WHERE
((usergroup_members.member_type = ‘User’) AND
(usergroup_members.member_id = 2)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT
usergroups.* FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.member_id AND
usergroup_members.member_type = ‘Usergroup’ WHERE
((usergroup_members.usergroup_id = 1)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT users.* FROM
users INNER JOIN usergroup_members ON users.id =
usergroup_members.member_id AND usergroup_members.member_type =
‘User’ WHERE ((usergroup_members.usergroup_id = 1)) ESC[0m
ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
bookmarks WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id
in

(1) AND bookmarks.owner_type = ‘Usergroup’) OR (bookmarks.owner_id
= 2

AND bookmarks.owner_type = ‘User’))) ORDER BY nameESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE (users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users WHERE
(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (2.0ms)
Rendered bookmarks/_list (0.7ms)
Rendered bookmarks/_list (0.5ms)
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (0.1ms)
Rendered home/_settings (1.2ms)
Rendered home/_menu (15.6ms)
Completed in 121ms (View: 20, DB: 14) | 200 OK [http://foreman.bc/
statistics]

On Jun 22, 9:43 am, Vincent vlouvi...@gmail.com wrote:

not very explicit

Processing StatisticsController#index (for 10.115.23.53 at
2011-06-22

09:42:01) [GET]
skipped as it has has no label
skipped as it has has no label
skipped as it has has no label
Unknown string
Rendering template within layouts/application
Completed in 167ms (View: 26, DB: 17) | 200 OK [
http://foreman.bc/

statistics]

On Jun 21, 3:37 pm, Ohad Levy ohadl...@gmail.com wrote:

On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote:

Hello,

When I click on statistics,
I’ve got this message :
No Inventory data has been found - add some hosts and facts
and try

again

lot of hosts and facts are actually in foreman so what’s wrong
?

Vincent

what does the log say? its probably failing on one of statistics
generation…


You received this message because you are subscribed to the Google
Groups “Foreman users” group.

To post to this group, send email to
foreman-users@googlegroups.com.

To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.

For more options, visit this group athttp://
groups.google.com/group/foreman-users?hl=en.


You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.

> The trouble is coming with
>
> @mem_size = FactValue.mem_average "memorysize"
>
> and in the log
>
> …
> FactValue Load (6.2ms) SELECT value FROM fact_values INNER JOIN
> fact_names ON fact_names.id = fact_values.fact_name_id WHERE
> (fact_names.name = 'memorysize')
> Unknown string
> …
>
> the sql output look like that, I suspect an error to convert GB or MB to
> number
>
> Vincent
>
> > 1.96 GB |
> > 3.96 GB |
> > 3.96 GB |
> > 7.92 GB |
> > 3.21 GB |
> > 1.96 GB |
> > 3.21 GB |
> > 1010.87 MB |
> > 3.96 GB |
> > 3.21 GB |
> > 3.96 GB |
> > 3.21 GB |
> > 3.96 GB |
> > 3.21 GB |
> > 3.96 GB |
> > 3.96 GB |
> > 3.96 GB |
> > 3.96 GB |
> > 3.87 GB |
> > 3.90 GB |
> > 4.73 GB |
> > 2.95 GB |
> > 3.96 GB |
> > 3.12 GB |
> > 1000.18 MB |
> > 200.14 MB |
> > 3.96 GB |
> > 3.96 GB |
> > 1010.87 MB |
> > 3.96 GB |
> > 3.96 GB |
> > 3.96 GB |
> > 3.90 GB |
> > 15.86 GB |
> > 1.98 GB |
> > 3.21 GB |
> > 3.87 GB |
> > 3.21 GB |
> > 3.96 GB |
> > 3.21 GB |
> > 3.87 GB |
> > 249.79 MB |
> > 3.21 GB |
> > 3.90 GB |
> > 3.47 GB |
> > 3.96 GB |
>
> thats interesting, I've took the exact list (for your output above) and
foreman was able to process it correctly… is that the complete list?

Ohad

··· On Tue, Jun 28, 2011 at 4:00 PM, vincent wrote:

2011/6/28 Ohad Levy ohadlevy@gmail.com

On Tue, 2011-06-28 at 04:26 -0700, Vincent wrote:

always no statistics …
any update ?
since its a bit hard to debug this way, I would suggest the following

look at app/controllers/statistics_controller.rb and try to comment out
each variable (you can probably comment out the whole json thing).

then you should also comment out the graph view it self at
pp/views/statistics/index.html.erb.

This will probably allow you to figure out which graph is breaking…

Ohad

On Jun 24, 10:16 am, Vincent vlouvi...@gmail.com wrote:

not sure it helps

http://pastie.org/2115062

On Jun 22, 3:58 pm, Ohad Levy ohadl...@gmail.com wrote:

can you simply paste it again it pastie.org or similar?

thanks

On Wed, Jun 22, 2011 at 4:53 PM, Vincent vlouvi...@gmail.com >> wrote:

any tips to remove quickly the esc color key ?

on debug :

Processing StatisticsController#index (for 10.115.23.53 at
2011-06-22

15:46:05) [GET]
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
users

WHERE (users.id = 2) ESC[0m
Setting current user thread-local variable to vincent
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS
count_all,

operatingsystem_id AS operatingsystem_id FROM hosts GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROM operatingsystems WHERE (operatingsystems.id IN
(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20)) ORDER BY
LOWER(operatingsystems.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.3ms)ESC[0m ESC[0mSELECT count(*) AS
count_all,

architecture_id AS architecture_id FROM hosts GROUP BY
architecture_id ESC[0m
ESC[4;36;1mArchitecture Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROM

architectures WHERE (architectures.id IN (1,2,3)) ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (1.2ms)ESC[0m ESC[0mSELECT count(*) AS
count_all,

environment_id AS environment_id FROM hosts GROUP BY
environment_id

ESC[0m
ESC[4;36;1mEnvironment Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
environments WHERE (environments.id IN (1,2)) ORDER BY
LOWER(environments.name)ESC[0m
skipped as it has has no label
ESC[4;35;1mSQL (6.7ms)ESC[0m ESC[0mSELECT count(DISTINCT
hosts.id) AS count_all, puppetclass_id AS puppetclass_id FROM
hosts LEFT OUTER JOIN hosts_puppetclasses ON
hosts_puppetclasses.host_id = hosts.id LEFT OUTER JOIN
puppetclasses ON puppetclasses.id =
hosts_puppetclasses.puppetclass_id GROUP BY puppetclass_id
ESC[0m

ESC[4;36;1mPuppetclass Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 1) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;35;1mPuppetclass Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
puppetclasses WHERE (puppetclasses.id = 2) ORDER BY
LOWER(puppetclasses.name)ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value
FROM

fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘processorcount’) ESC[0m
ESC[4;35;1mFactValue Load (0.3ms)ESC[0m ESC[0mSELECT value FROM
fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘manufacturer’) ESC[0m
ESC[4;36;1mFactValue Load (0.3ms)ESC[0m ESC[0;1mSELECT value
FROM

fact_values INNER JOIN fact_names ON fact_names.id =
fact_values.fact_name_id WHERE (fact_names.name =
‘memorysize’)

ESC[0m
Unknown string
Rendering template within layouts/application
Rendered home/_topbar (0.9ms)
ESC[4;35;1mNotice Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
notices

INNER JOIN user_notices ON notices.id =
user_notices.notice_id

WHERE (user_notices.user_id = 2 ) ESC[0m
ESC[4;36;1mUsergroup Load (0.1ms)ESC[0m ESC[0;1mSELECT
usergroups.* FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.usergroup_id WHERE
((usergroup_members.member_type = ‘User’) AND
(usergroup_members.member_id = 2)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;35;1mUsergroup Load (0.1ms)ESC[0m ESC[0mSELECT
usergroups.* FROM usergroups INNER JOIN usergroup_members ON
usergroups.id = usergroup_members.member_id AND
usergroup_members.member_type = ‘Usergroup’ WHERE
((usergroup_members.usergroup_id = 1)) ORDER BY
LOWER(usergroups.name)ESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT users.*
FROM

users INNER JOIN usergroup_members ON users.id =
usergroup_members.member_id AND usergroup_members.member_type
=

‘User’ WHERE ((usergroup_members.usergroup_id = 1)) ESC[0m
ESC[4;35;1mBookmark Load (0.1ms)ESC[0m ESC[0mSELECT * FROM
bookmarks WHERE (((bookmarks.public = 1) OR (bookmarks.owner_id
in

(1) AND bookmarks.owner_type = ‘Usergroup’) OR (bookmarks.owner_id
= 2

AND bookmarks.owner_type = ‘User’))) ORDER BY nameESC[0m
ESC[4;36;1mUser Load (0.1ms)ESC[0m ESC[0;1mSELECT * FROM
users

WHERE (users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users
WHERE

(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROM users
WHERE

(users.id = 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROM users
WHERE

(users.id = 1) ESC[0m
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (2.0ms)
Rendered bookmarks/_list (0.7ms)
Rendered bookmarks/_list (0.5ms)
Rendered bookmarks/_list (0.1ms)
Rendered bookmarks/_list (0.1ms)
Rendered home/_settings (1.2ms)
Rendered home/_menu (15.6ms)
Completed in 121ms (View: 20, DB: 14) | 200 OK [
http://foreman.bc/

statistics]

On Jun 22, 9:43 am, Vincent vlouvi...@gmail.com wrote:

not very explicit

Processing StatisticsController#index (for 10.115.23.53 at
2011-06-22

09:42:01) [GET]
skipped as it has has no label
skipped as it has has no label
skipped as it has has no label
Unknown string
Rendering template within layouts/application
Completed in 167ms (View: 26, DB: 17) | 200 OK [
http://foreman.bc/

statistics]

On Jun 21, 3:37 pm, Ohad Levy ohadl...@gmail.com wrote:

On Tue, 2011-06-21 at 06:13 -0700, Vincent wrote:

Hello,

When I click on statistics,
I’ve got this message :
No Inventory data has been found - add some hosts and facts
and try

again

lot of hosts and facts are actually in foreman so what’s
wrong ?

Vincent

what does the log say? its probably failing on one of
statistics

generation…


You received this message because you are subscribed to the Google
Groups “Foreman users” group.

To post to this group, send email to
foreman-users@googlegroups.com.

To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.

For more options, visit this group athttp://
groups.google.com/group/foreman-users?hl=en.


You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.


You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.