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
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…
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]
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]
can you simply paste it again it pastie.org or similar?
thanks
not sure it helps
always no statistics …
any update ?
> 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
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 * FROMusers
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 FROMhosts
GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROMoperatingsystems
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 FROMhosts
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 FROMhosts
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 JOINhosts_puppetclasses
ON
hosts_puppetclasses
.host_id =hosts
.id LEFT OUTER JOIN
puppetclasses
ONpuppetclasses
.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 JOINfact_names
ONfact_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 JOINfact_names
ONfact_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 JOINfact_names
ONfact_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 * FROMnotices
INNER JOINuser_notices
ONnotices
.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
. FROMusergroups
INNER JOINusergroup_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
.* FROMusergroups
INNER JOINusergroup_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;1mSELECTusers
.* FROM
users
INNER JOINusergroup_members
ONusers
.id =
usergroup_members
.member_id ANDusergroup_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 * FROMusers
WHERE (users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
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
againlot 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
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 followinglook 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
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 * FROMusers
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 FROMhosts
GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROMoperatingsystems
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 FROMhosts
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 FROMhosts
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 JOINhosts_puppetclasses
ON
hosts_puppetclasses
.host_id =hosts
.id LEFT OUTER JOIN
puppetclasses
ONpuppetclasses
.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 JOINfact_names
ONfact_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 JOINfact_names
ONfact_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 JOINfact_names
ONfact_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 JOINuser_notices
ONnotices
.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
. FROMusergroups
INNER JOINusergroup_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
.* FROMusergroups
INNER JOINusergroup_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;1mSELECTusers
.* FROM
users
INNER JOINusergroup_members
ONusers
.id =
usergroup_members
.member_id ANDusergroup_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 * FROMusers
WHERE (users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
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
againlot 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
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 followinglook 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
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 FROMhosts
GROUP BY
operatingsystem_id ESC[0m
ESC[4;36;1mOperatingsystem Load (0.1ms)ESC[0m ESC[0;1mSELECT *
FROMoperatingsystems
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 FROMhosts
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 FROMhosts
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 JOINhosts_puppetclasses
ON
hosts_puppetclasses
.host_id =hosts
.id LEFT OUTER JOIN
puppetclasses
ONpuppetclasses
.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 JOINfact_names
ONfact_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 JOINfact_names
ONfact_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 JOINfact_names
ONfact_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 JOINuser_notices
ONnotices
.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
. FROMusergroups
INNER JOINusergroup_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
.* FROMusergroups
INNER JOINusergroup_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;1mSELECTusers
.*
FROM
users
INNER JOINusergroup_members
ONusers
.id =
usergroup_members
.member_id ANDusergroup_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 * FROMusers
WHERE
(users
.id
= 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
WHERE
(users
.id
= 1) ESC[0m
ESC[4;35;1mCACHE (0.0ms)ESC[0m ESC[0mSELECT * FROMusers
WHERE
(users
.id
= 2) ESC[0m
ESC[4;36;1mCACHE (0.0ms)ESC[0m ESC[0;1mSELECT * FROMusers
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
againlot 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.