[ovirt-users] Re: Changing the Data Warehouse Sampling Scale
Hi Yedidyah, After the fix that Paul pointed out, I can now see the data populating in all the daily tables. Thanks for your response From: Yedidyah Bar David Sent: 05 March 2020 08:59 To: Staniforth, Paul Cc: Anton Louw ; users@ovirt.org Subject: Re: [ovirt-users] Re: Changing the Data Warehouse Sampling Scale On Wed, Mar 4, 2020 at 7:09 PM Staniforth, Paul mailto:p.stanifo...@leedsbeckett.ac.uk>> wrote: > > > Hello Anton, > you can also manually do this > edit /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf > run systemctl restart ovirt-engine-dwhd.service > > if you upgrade your engine it puts the old 10-setup-scale.conf back but it > keeps a copy You can also add your own copy of this file with a later name (say "99-my-stuff.conf"). This will take precedence and won't be touched by upgrades. However: > > > Regards, > Paul S. > > From: anton.l...@voxtelecom.co.za<mailto:anton.l...@voxtelecom.co.za> > mailto:anton.l...@voxtelecom.co.za>> > Sent: 04 March 2020 05:37 > To: users@ovirt.org<mailto:users@ovirt.org> > mailto:users@ovirt.org>> > Subject: [ovirt-users] Changing the Data Warehouse Sampling Scale > > Caution External Mail: Do not click any links or open any attachments unless > you trust the sender and know that the content is safe. > > Hi Everybody, > > I have a question. When oVirt was deployed in our environment by previous > engineers, the DWH was installed as Basic. I would like to change this to > Full, to get the daily stats, as this is now empty due to the scale. If it's completely empty, perhaps there is some other problem, not the scale. To further debug this, check that both the engine and dwh access the same database (this should be ok by default, but perhaps you used non-defaults) by checking the credentials they use in their conf files: grep DWH_DB /etc/ovirt-engine/engine.conf.d/*conf grep DWH_DB /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*conf You might also check /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log . Best regards, > Is this just as simple as described in the following article: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3Dreserved=0> > > Are there any precautions I should take, and has anybody else ever done this > before? > > Thanks a lot > ___ > Users mailing list -- users@ovirt.org<mailto:users@ovirt.org> > To unsubscribe send an email to > users-le...@ovirt.org<mailto:users-le...@ovirt.org> > Privacy Statement: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3Dreserved=0> > oVirt Code of Conduct: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3Dreserved=0> > List Archives: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.ovirt.org%2Farchives%2Flist%2Fusers%40ovirt.org%2Fmessage%2FOXCU4RPMVR7XQUGBKJX63CUAFWPKE3GX%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7
[ovirt-users] Re: Changing the Data Warehouse Sampling Scale
Hi Paul, That is great news! Thanks so much for the reply. Cheers Anton Louw Cloud Engineer: Storage and Virtualization __ D: 087 805 1572 | M: N/A A: Rutherford Estate, 1 Scott Street, Waverley, Johannesburg anton.l...@voxtelecom.co.za www.vox.co.za From: Staniforth, Paul Sent: 04 March 2020 18:35 To: Anton Louw ; users@ovirt.org Subject: Re: [ovirt-users] Changing the Data Warehouse Sampling Scale Hello Anton, you can also manually do this edit /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf run systemctl restart ovirt-engine-dwhd.service if you upgrade your engine it puts the old 10-setup-scale.conf back but it keeps a copy Regards, Paul S. From: anton.l...@voxtelecom.co.za<mailto:anton.l...@voxtelecom.co.za> mailto:anton.l...@voxtelecom.co.za>> Sent: 04 March 2020 05:37 To: users@ovirt.org<mailto:users@ovirt.org> mailto:users@ovirt.org>> Subject: [ovirt-users] Changing the Data Warehouse Sampling Scale Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe. Hi Everybody, I have a question. When oVirt was deployed in our environment by previous engineers, the DWH was installed as Basic. I would like to change this to Full, to get the daily stats, as this is now empty due to the scale. Is this just as simple as described in the following article: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3Dreserved=0> Are there any precautions I should take, and has anybody else ever done this before? Thanks a lot ___ Users mailing list -- users@ovirt.org<mailto:users@ovirt.org> To unsubscribe send an email to users-le...@ovirt.org<mailto:users-le...@ovirt.org> Privacy Statement: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3Dreserved=0> oVirt Code of Conduct: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3Dreserved=0> List Archives: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.ovirt.org%2Farchives%2Flist%2Fusers%40ovirt.org%2Fmessage%2FOXCU4RPMVR7XQUGBKJX63CUAFWPKE3GX%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=S%2B3GTsLTkW28Kk0P1uHCIsqUP087RYxQCdtrASzJfUU%3Dreserved=0<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.ovirt.org%2Farchives%2Flist%2Fusers%40ovirt.org%2Fmessage%2FOXCU4RPMVR7XQUGBKJX63CUAFWPKE3GX%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=S%2B3GTsLTkW28Kk0P1uHCIsqUP087RYxQCdtrASzJfUU%3Dreserved=0> To view the terms under which this email is distributed, please go to:- http://leedsbeckett.ac.uk/disclaimer/email/<http://leedsbeckett.ac.uk/disclaimer/email/> ___ Users mailin
[ovirt-users] Re: Changing the Data Warehouse Sampling Scale
On Wed, Mar 4, 2020 at 7:09 PM Staniforth, Paul wrote: > > > Hello Anton, >you can also manually do this > edit > /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf > run systemctl restart ovirt-engine-dwhd.service > > if you upgrade your engine it puts the old 10-setup-scale.conf back but it > keeps a copy You can also add your own copy of this file with a later name (say "99-my-stuff.conf"). This will take precedence and won't be touched by upgrades. However: > > > Regards, > Paul S. > > From: anton.l...@voxtelecom.co.za > Sent: 04 March 2020 05:37 > To: users@ovirt.org > Subject: [ovirt-users] Changing the Data Warehouse Sampling Scale > > Caution External Mail: Do not click any links or open any attachments unless > you trust the sender and know that the content is safe. > > Hi Everybody, > > I have a question. When oVirt was deployed in our environment by previous > engineers, the DWH was installed as Basic. I would like to change this to > Full, to get the daily stats, as this is now empty due to the scale. If it's completely empty, perhaps there is some other problem, not the scale. To further debug this, check that both the engine and dwh access the same database (this should be ok by default, but perhaps you used non-defaults) by checking the credentials they use in their conf files: grep DWH_DB /etc/ovirt-engine/engine.conf.d/*conf grep DWH_DB /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/*conf You might also check /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log . Best regards, > Is this just as simple as described in the following article: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3Dreserved=0 > > Are there any precautions I should take, and has anybody else ever done this > before? > > Thanks a lot > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > Privacy Statement: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3Dreserved=0 > oVirt Code of Conduct: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3Dreserved=0 > List Archives: > https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.ovirt.org%2Farchives%2Flist%2Fusers%40ovirt.org%2Fmessage%2FOXCU4RPMVR7XQUGBKJX63CUAFWPKE3GX%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=S%2B3GTsLTkW28Kk0P1uHCIsqUP087RYxQCdtrASzJfUU%3Dreserved=0 > To view the terms under which this email is distributed, please go to:- > http://leedsbeckett.ac.uk/disclaimer/email/ > > ___ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > Privacy Statement: https://www.ovirt.org/privacy-policy.html > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/users@ovirt.org/message/FQBQ4ISS5BTVHST7FN44LPKAQSAZW2SL/ -- Didi ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/VEL255YXN25JVSAR2K4L2OVJXAS34JKJ/
[ovirt-users] Re: Changing the Data Warehouse Sampling Scale
Hello Anton, you can also manually do this edit /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf run systemctl restart ovirt-engine-dwhd.service if you upgrade your engine it puts the old 10-setup-scale.conf back but it keeps a copy Regards, Paul S. From: anton.l...@voxtelecom.co.za Sent: 04 March 2020 05:37 To: users@ovirt.org Subject: [ovirt-users] Changing the Data Warehouse Sampling Scale Caution External Mail: Do not click any links or open any attachments unless you trust the sender and know that the content is safe. Hi Everybody, I have a question. When oVirt was deployed in our environment by previous engineers, the DWH was installed as Basic. I would like to change this to Full, to get the daily stats, as this is now empty due to the scale. Is this just as simple as described in the following article: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fdocumentation%2Fdata-warehouse%2FChanging_the_Data_Warehouse_Sampling_Scale.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ywsasun9mV0sNSjCmEeIf%2B94UZdc%2Fc%2Bevx9A1ScodXQ%3Dreserved=0 Are there any precautions I should take, and has anybody else ever done this before? Thanks a lot ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fprivacy-policy.htmldata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=ZKYdi41tiNeR5dDB3urRtPK%2BOact7CM17J8uEaB4obQ%3Dreserved=0 oVirt Code of Conduct: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ovirt.org%2Fcommunity%2Fabout%2Fcommunity-guidelines%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=RYLw8RIpcv3YJPvpE8QcZN9qsSjmkt%2BEzWDTScBuZfg%3Dreserved=0 List Archives: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.ovirt.org%2Farchives%2Flist%2Fusers%40ovirt.org%2Fmessage%2FOXCU4RPMVR7XQUGBKJX63CUAFWPKE3GX%2Fdata=02%7C01%7Cp.staniforth%40leedsbeckett.ac.uk%7Cca53316d625742be286908d7c0414bb2%7Cd79a81124fbe417aa112cd0fb490d85c%7C0%7C1%7C637189258999725533sdata=S%2B3GTsLTkW28Kk0P1uHCIsqUP087RYxQCdtrASzJfUU%3Dreserved=0 To view the terms under which this email is distributed, please go to:- http://leedsbeckett.ac.uk/disclaimer/email/ ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/FQBQ4ISS5BTVHST7FN44LPKAQSAZW2SL/