Re: [Users] ovirt-report Forbidden access error
Il 04/02/2014 14:55, Yedidyah Bar David ha scritto: As I said, not having this line might imply there are other problems. You can try solve this one by adding it. In psql connected to db engine: select fn_db_add_config_value('RedirectServletReportsPage','https://YOUR_FQDN:443/ovirt-engine-reports','general'); (replace YOUR_FQDN with your engine fqdn). -- Didi ok got it -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare i...@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
> From: "Alessandro Bianchi" > To: "Yedidyah Bar David" > Cc: "Gianluca Cecchi" , "users" > Sent: Tuesday, February 4, 2014 3:35:47 PM > Subject: Re: [Users] ovirt-report Forbidden access error > Il 04/02/2014 14:06, Yedidyah Bar David ha scritto: > > - Original Message - > > > > From: "Alessandro Bianchi" To: "Yedidyah Bar David" > > > Cc: "Gianluca Cecchi" , > > > "users" Sent: Tuesday, February 4, 2014 2:49:47 PM > > > > > > Subject: Re: [Users] ovirt-report Forbidden access error > > > > > [snip] > > > (for now I'll ignore the confs (which seem ok) and the logs (which will > > > require more time to understand) > > > > postgres-# select * from vdc_options where > > > > > > option_name='RedirectServletReportsPage' > > > > > > postgres-# > > > > > > (no results) > > > > > This is probably the source of the problem. > > > Can you post all the setup log files (engine, dwh, reports)? > > > The line is normally inserted by engine-setup and updated by reports-setup. > > Engine setup is quite older since I didn't install reports at that time It's not supposed to be rotated, you should be able to find it with find /var/log/ovirt-engine -iname "*setup*" 3.3 engine setup keeps them under a subdir setup/, the rest (<=3.2 engine and <=3.3 dwh/reports) keep them directly there (and in 3.4 all will keep in setup/). > Let me know if anything else may help As I said, not having this line might imply there are other problems. You can try solve this one by adding it. In psql connected to db engine: select fn_db_add_config_value('RedirectServletReportsPage','https://YOUR_FQDN:443/ovirt-engine-reports','general'); (replace YOUR_FQDN with your engine fqdn). -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
- Original Message - > From: "Gianluca Cecchi" > To: "Yedidyah Bar David" > Cc: "Alessandro Bianchi" , "users" > Sent: Tuesday, February 4, 2014 3:25:37 PM > Subject: Re: [Users] ovirt-report Forbidden access error > > On Tue, Feb 4, 2014 at 2:06 PM, Yedidyah Bar David wrote: > > - Original Message - > >> From: "Alessandro Bianchi" > >> To: "Yedidyah Bar David" > >> Cc: "Gianluca Cecchi" , "users" > >> > >> Sent: Tuesday, February 4, 2014 2:49:47 PM > >> Subject: Re: [Users] ovirt-report Forbidden access error > > [snip] > > > > (for now I'll ignore the confs (which seem ok) and the logs (which will > > require more time to understand) > > > >> postgres-# select * from vdc_options where > >> option_name='RedirectServletReportsPage' > >> postgres-# > >> (no results) > > > > This is probably the source of the problem. > > > > Can you post all the setup log files (engine, dwh, reports)? > > > > The line is normally inserted by engine-setup and updated by reports-setup. > > -- > > Didi > > In fact in my case where it is working I have: > > engine=# select * from vdc_options where > option_name='RedirectServletReportsPage'; > option_id |option_name | > option_value| version > ---++---+- >281 | RedirectServletReportsPage | > https://my-engine:443/ovirt-engine-reports | general > (1 row) Indeed, that's updated to be so by reports setup. But Alessandro reported he does not have this row at all, which is probably some bug or problem in engine-setup. We can quite easily patch reports setup to add this row if it does not exist, but it might imply some deeper problems in the setup which should probably be fixed anyway. -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
On Tue, Feb 4, 2014 at 2:06 PM, Yedidyah Bar David wrote: > - Original Message - >> From: "Alessandro Bianchi" >> To: "Yedidyah Bar David" >> Cc: "Gianluca Cecchi" , "users" >> Sent: Tuesday, February 4, 2014 2:49:47 PM >> Subject: Re: [Users] ovirt-report Forbidden access error > [snip] > > (for now I'll ignore the confs (which seem ok) and the logs (which will > require more time to understand) > >> postgres-# select * from vdc_options where >> option_name='RedirectServletReportsPage' >> postgres-# >> (no results) > > This is probably the source of the problem. > > Can you post all the setup log files (engine, dwh, reports)? > > The line is normally inserted by engine-setup and updated by reports-setup. > -- > Didi In fact in my case where it is working I have: engine=# select * from vdc_options where option_name='RedirectServletReportsPage'; option_id |option_name | option_value| version ---++---+- 281 | RedirectServletReportsPage | https://my-engine:443/ovirt-engine-reports | general (1 row) Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
- Original Message - > From: "Alessandro Bianchi" > To: "Yedidyah Bar David" > Cc: "Gianluca Cecchi" , "users" > Sent: Tuesday, February 4, 2014 2:49:47 PM > Subject: Re: [Users] ovirt-report Forbidden access error [snip] (for now I'll ignore the confs (which seem ok) and the logs (which will require more time to understand) > postgres-# select * from vdc_options where > option_name='RedirectServletReportsPage' > postgres-# > (no results) This is probably the source of the problem. Can you post all the setup log files (engine, dwh, reports)? The line is normally inserted by engine-setup and updated by reports-setup. -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
Il 04/02/2014 12:55, Yedidyah Bar David ha scritto: *From: *"Alessandro Bianchi" *To: *"Gianluca Cecchi" *Cc: *"Yedidyah Bar David" , "users" *Sent: *Tuesday, February 4, 2014 1:19:43 PM *Subject: *Re: [Users] ovirt-report Forbidden access error Il 04/02/2014 11:30, Gianluca Cecchi ha scritto: On Tue, Feb 4, 2014 at 11:10 AM, Alessandro Bianchi wrote: Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: in working directory '/usr/share/ovirt-engine-dwh/db-scripts' 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: autenticazione con password fallita per l'utente "engine_history" password retrieved from file "/tmp/pgpassNkKGNp.tmp" (autenticazione con password fallita per l'utente "engine_history" = authentication failed for user "engine_history" system language is italian) so it seems a user creation permission problem on the database since I'm not too familiar with pgsql how is it supposed to fix this? It look like it misses the password in some ovirt configuration file but where to edit and how o fix it? Any hint? Thank you See this thread of mine if you want to start from scratch and you don't have any previous reports/dwh data or you don't mind to loose them. Engine and its data is not impacted at all. Eventually I'm going to open a bug for bad mgmt of pre-existing DB user during setup (eg due to a previously failed in the middle install). http://lists.ovirt.org/pipermail/users/2014-February/020740.html Let us know how it goes. Gianluca Ok with this 2b extra step it works I have installed everything with no errors, but still have Forbidden access right clicking on Vms -> reports If I click on the "reports portal" I see this link *ATTENZIONE: i link numerici sono spesso utilizzati da malintenzionati* http://10.0.0.5/OvirtEngineWeb/ReportsRedirectServlet I suspect this is something related to apache configuration access.log shows nothing so were may I see a log of what's happening? Thank you Alessandro I too see that redirect and then when I click I land to https://my-engine/ovirt-engine-reports/login.html and then after login/pwd : https://my-engine/ovirt-engine-reports/flow.html?_flowId=searchFlow I have SpiceProxy configured. Don't know if this impacts apache configuration. In my case it works and in /etc/httpd/conf.d Ihave # ls -lrt total 68 -rw-r--r--. 1 root root 926 Mar 31 2013 BackupPC.conf -rw-r--r--. 1 root root 298 Jul 23 2013 squid.conf -rw-r--r--. 1 root root 516 Jul 31 2013 welcome.conf -rw-r--r--. 1 root root 1252 Jul 31 2013 userdir.conf -rw-r--r--. 1 root root 9426 Jul 31 2013 ssl.conf.20131003112151 -rw-r--r--. 1 root root 2893 Jul 31 2013 autoindex.conf -rw-r--r--. 1 root root 366 Jul 31 2013 README -rw-r--r--. 1 root root 2778 Oct 3 11:21 z-ovirt-engine-proxy.conf.20131119125706 -rw-r--r--. 1 root root 33 Oct 3 11:21 ovirt-engine-root-redirect.conf -rw-r--r--. 1 root root 9444 Oct 3 11:21 ssl.conf -rw-r--r--. 1 root root 2775 Nov 19 12:57 z-ovirt-engine-proxy.conf.20140115003015 -rw-r--r--. 1 root root 1251 Jan 7 15:54 z-ovirt-engine-reports-proxy.conf -rw-r--r--. 1 root root 2788 Jan 15 00:30 z-ovirt-engine-proxy.conf z-ovirt-engine-reports-proxy.conf: # This is needed to make sure that connections to the application server # are recovered in a short time interval (5 seconds at the moment) # otherwise when the application server is restarted the web server will # refuse to connect during 60 seconds. ProxySet retry=5 # This is needed to make sure that long RESTAPI requests have time to # finish before the web server aborts the request as the default timeout # (controlled by the Timeout directive in httpd.conf) is 60 seconds. ProxySet timeout=3600 ProxyPass ajp://localhost:8702/ovirt-engine-reports AddOutpu
Re: [Users] ovirt-report Forbidden access error
> From: "Alessandro Bianchi" > To: "Gianluca Cecchi" > Cc: "Yedidyah Bar David" , "users" > Sent: Tuesday, February 4, 2014 1:19:43 PM > Subject: Re: [Users] ovirt-report Forbidden access error > Il 04/02/2014 11:30, Gianluca Cecchi ha scritto: > > On Tue, Feb 4, 2014 at 11:10 AM, Alessandro Bianchi > > wrote: > > > > Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: > > > > > > On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: > > > > > > in working directory '/usr/share/ovirt-engine-dwh/db-scripts' > > > > > > 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = > > > > > > 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: > > > FATALE: > > > > > > autenticazione con password fallita per l'utente "engine_history" > > > > > > password retrieved from file "/tmp/pgpassNkKGNp.tmp" > > > > > > (autenticazione con password fallita per l'utente "engine_history" = > > > > > > authentication failed for user "engine_history" system language is > > > italian) > > > > > > so it seems a user creation permission problem on the database > > > > > > since I'm not too familiar with pgsql how is it supposed to fix this? > > > > > > It look like it misses the password in some ovirt configuration file but > > > > > > where to edit and how o fix it? > > > > > > Any hint? > > > > > > Thank you > > > > > > See this thread of mine if you want to start from scratch and you > > > > > > don't have any previous reports/dwh data or you don't mind to loose > > > > > > them. Engine and its data is not impacted at all. > > > > > > Eventually I'm going to open a bug for bad mgmt of pre-existing DB > > > > > > user during setup (eg due to a previously failed in the middle > > > > > > install). > > > http://lists.ovirt.org/pipermail/users/2014-February/020740.html > > > Let us know how it goes. > > > > > > Gianluca > > > > > > Ok with this 2b extra step it works > > > > > > I have installed everything with no errors, but still have Forbidden > > > access > > > > > > right clicking on Vms -> reports > > > > > > If I click on the "reports portal" I see this link > > > http://10.0.0.5/OvirtEngineWeb/ReportsRedirectServlet I suspect this is > > > something related to apache configuration > > > > > > access.log shows nothing so were may I see a log of what's happening? > > > > > > Thank you > > > > > > Alessandro > > > > > I too see that redirect and then when I click I land to > > https://my-engine/ovirt-engine-reports/login.html and then after login/pwd > > : > > https://my-engine/ovirt-engine-reports/flow.html?_flowId=searchFlow I have > > SpiceProxy configured. > > > Don't know if this impacts apache configuration. > > > In my case it works and in /etc/httpd/conf.d > > > Ihave > > > # ls -lrt > > > total 68 > > > -rw-r--r--. 1 root root 926 Mar 31 2013 BackupPC.conf > > > -rw-r--r--. 1 root root 298 Jul 23 2013 squid.conf > > > -rw-r--r--. 1 root root 516 Jul 31 2013 welcome.conf > > > -rw-r--r--. 1 root root 1252 Jul 31 2013 userdir.conf > > > -rw-r--r--. 1 root root 9426 Jul 31 2013 ssl.conf.20131003112151 > > > -rw-r--r--. 1 root root 2893 Jul 31 2013 autoindex.conf > > > -rw-r--r--. 1 root root 366 Jul 31 2013 README > > > -rw-r--r--. 1 root root 2778 Oct 3 11:21 > > > z-ovirt-engine-proxy.conf.20131119125706 > > > -rw-r--r--. 1 root root 33 Oct 3 11:21 ovirt-engine-root-redirect.conf > > > -rw-r--r--. 1 root root 9444 Oct 3 11:21 ssl.conf > > > -rw-r--r--. 1 root root 2775 Nov 19 12:57 > > > z-ovirt-engine-proxy.conf.20140115003015 > > > -rw-r--r--. 1 root root 1251 Jan 7 15:54 z-ovirt-engine-reports-proxy.conf > > > -rw-r--r--. 1 root root 2788 Jan 15 00:30 z-ovirt-engine-proxy.conf > > > z-ovirt-engine-reports-proxy.conf: > > > > > > > > > # This is needed to make sure that connections to the application server > > > # are recovered in a short time interval (5 second
Re: [Users] ovirt-report Forbidden access error
Il 04/02/2014 11:30, Gianluca Cecchi ha scritto: On Tue, Feb 4, 2014 at 11:10 AM, Alessandro Bianchi wrote: Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: in working directory '/usr/share/ovirt-engine-dwh/db-scripts' 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: autenticazione con password fallita per l'utente "engine_history" password retrieved from file "/tmp/pgpassNkKGNp.tmp" (autenticazione con password fallita per l'utente "engine_history" = authentication failed for user "engine_history" system language is italian) so it seems a user creation permission problem on the database since I'm not too familiar with pgsql how is it supposed to fix this? It look like it misses the password in some ovirt configuration file but where to edit and how o fix it? Any hint? Thank you See this thread of mine if you want to start from scratch and you don't have any previous reports/dwh data or you don't mind to loose them. Engine and its data is not impacted at all. Eventually I'm going to open a bug for bad mgmt of pre-existing DB user during setup (eg due to a previously failed in the middle install). http://lists.ovirt.org/pipermail/users/2014-February/020740.html Let us know how it goes. Gianluca Ok with this 2b extra step it works I have installed everything with no errors, but still have Forbidden access right clicking on Vms -> reports If I click on the "reports portal" I see this link http://10.0.0.5/OvirtEngineWeb/ReportsRedirectServlet I suspect this is something related to apache configuration access.log shows nothing so were may I see a log of what's happening? Thank you Alessandro I too see that redirect and then when I click I land to https://my-engine/ovirt-engine-reports/login.html and then after login/pwd : https://my-engine/ovirt-engine-reports/flow.html?_flowId=searchFlow I have SpiceProxy configured. Don't know if this impacts apache configuration. In my case it works and in /etc/httpd/conf.d Ihave # ls -lrt total 68 -rw-r--r--. 1 root root 926 Mar 31 2013 BackupPC.conf -rw-r--r--. 1 root root 298 Jul 23 2013 squid.conf -rw-r--r--. 1 root root 516 Jul 31 2013 welcome.conf -rw-r--r--. 1 root root 1252 Jul 31 2013 userdir.conf -rw-r--r--. 1 root root 9426 Jul 31 2013 ssl.conf.20131003112151 -rw-r--r--. 1 root root 2893 Jul 31 2013 autoindex.conf -rw-r--r--. 1 root root 366 Jul 31 2013 README -rw-r--r--. 1 root root 2778 Oct 3 11:21 z-ovirt-engine-proxy.conf.20131119125706 -rw-r--r--. 1 root root 33 Oct 3 11:21 ovirt-engine-root-redirect.conf -rw-r--r--. 1 root root 9444 Oct 3 11:21 ssl.conf -rw-r--r--. 1 root root 2775 Nov 19 12:57 z-ovirt-engine-proxy.conf.20140115003015 -rw-r--r--. 1 root root 1251 Jan 7 15:54 z-ovirt-engine-reports-proxy.conf -rw-r--r--. 1 root root 2788 Jan 15 00:30 z-ovirt-engine-proxy.conf z-ovirt-engine-reports-proxy.conf: # This is needed to make sure that connections to the application server # are recovered in a short time interval (5 seconds at the moment) # otherwise when the application server is restarted the web server will # refuse to connect during 60 seconds. ProxySet retry=5 # This is needed to make sure that long RESTAPI requests have time to # finish before the web server aborts the request as the default timeout # (controlled by the Timeout directive in httpd.conf) is 60 seconds. ProxySet timeout=3600 ProxyPass ajp://localhost:8702/ovirt-engine-reports AddOutputFilterByType DEFLATE text/_javascript_ text/css text/html text/xml text/json application/xml application/json application/x-yaml Uuh enterig the URL you showed directely I can login and see reports ok so it looks link in ovirt main page is somehow wrong! Thank you -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare i...@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo
Re: [Users] ovirt-report Forbidden access error
On Tue, Feb 4, 2014 at 11:10 AM, Alessandro Bianchi wrote: > > > Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: > > On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: > > in working directory '/usr/share/ovirt-engine-dwh/db-scripts' > 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = > 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: > autenticazione con password fallita per l'utente "engine_history" > password retrieved from file "/tmp/pgpassNkKGNp.tmp" > > (autenticazione con password fallita per l'utente "engine_history" = > authentication failed for user "engine_history" system language is italian) > > so it seems a user creation permission problem on the database > > since I'm not too familiar with pgsql how is it supposed to fix this? > > It look like it misses the password in some ovirt configuration file but > where to edit and how o fix it? > > Any hint? > > Thank you > > See this thread of mine if you want to start from scratch and you > don't have any previous reports/dwh data or you don't mind to loose > them. Engine and its data is not impacted at all. > Eventually I'm going to open a bug for bad mgmt of pre-existing DB > user during setup (eg due to a previously failed in the middle > install). > > http://lists.ovirt.org/pipermail/users/2014-February/020740.html > > Let us know how it goes. > > Gianluca > > Ok with this 2b extra step it works > > I have installed everything with no errors, but still have Forbidden access > right clicking on Vms -> reports > > If I click on the "reports portal" I see this link > > http://10.0.0.5/OvirtEngineWeb/ReportsRedirectServlet > > I suspect this is something related to apache configuration > > access.log shows nothing so were may I see a log of what's happening? > > Thank you > > Alessandro I too see that redirect and then when I click I land to https://my-engine/ovirt-engine-reports/login.html and then after login/pwd : https://my-engine/ovirt-engine-reports/flow.html?_flowId=searchFlow I have SpiceProxy configured. Don't know if this impacts apache configuration. In my case it works and in /etc/httpd/conf.d Ihave # ls -lrt total 68 -rw-r--r--. 1 root root 926 Mar 31 2013 BackupPC.conf -rw-r--r--. 1 root root 298 Jul 23 2013 squid.conf -rw-r--r--. 1 root root 516 Jul 31 2013 welcome.conf -rw-r--r--. 1 root root 1252 Jul 31 2013 userdir.conf -rw-r--r--. 1 root root 9426 Jul 31 2013 ssl.conf.20131003112151 -rw-r--r--. 1 root root 2893 Jul 31 2013 autoindex.conf -rw-r--r--. 1 root root 366 Jul 31 2013 README -rw-r--r--. 1 root root 2778 Oct 3 11:21 z-ovirt-engine-proxy.conf.20131119125706 -rw-r--r--. 1 root root 33 Oct 3 11:21 ovirt-engine-root-redirect.conf -rw-r--r--. 1 root root 9444 Oct 3 11:21 ssl.conf -rw-r--r--. 1 root root 2775 Nov 19 12:57 z-ovirt-engine-proxy.conf.20140115003015 -rw-r--r--. 1 root root 1251 Jan 7 15:54 z-ovirt-engine-reports-proxy.conf -rw-r--r--. 1 root root 2788 Jan 15 00:30 z-ovirt-engine-proxy.conf z-ovirt-engine-reports-proxy.conf: # This is needed to make sure that connections to the application server # are recovered in a short time interval (5 seconds at the moment) # otherwise when the application server is restarted the web server will # refuse to connect during 60 seconds. ProxySet retry=5 # This is needed to make sure that long RESTAPI requests have time to # finish before the web server aborts the request as the default timeout # (controlled by the Timeout directive in httpd.conf) is 60 seconds. ProxySet timeout=3600 ProxyPass ajp://localhost:8702/ovirt-engine-reports AddOutputFilterByType DEFLATE text/javascript text/css text/html text/xml text/json application/xml application/json application/x-yaml ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: in working directory '/usr/share/ovirt-engine-dwh/db-scripts' 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: autenticazione con password fallita per l'utente "engine_history" password retrieved from file "/tmp/pgpassNkKGNp.tmp" (autenticazione con password fallita per l'utente "engine_history" = authentication failed for user "engine_history" system language is italian) so it seems a user creation permission problem on the database since I'm not too familiar with pgsql how is it supposed to fix this? It look like it misses the password in some ovirt configuration file but where to edit and how o fix it? Any hint? Thank you See this thread of mine if you want to start from scratch and you don't have any previous reports/dwh data or you don't mind to loose them. Engine and its data is not impacted at all. Eventually I'm going to open a bug for bad mgmt of pre-existing DB user during setup (eg due to a previously failed in the middle install). http://lists.ovirt.org/pipermail/users/2014-February/020740.html Let us know how it goes. Gianluca Ok with this 2b extra step it works I have installed everything with no errors, but still have Forbidden access right clicking on Vms -> reports If I click on the "reports portal" I see this link http://10.0.0.5/OvirtEngineWeb/ReportsRedirectServlet I suspect this is something related to apache configuration access.log shows nothing so were may I see a log of what's happening? Thank you Alessandro -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare i...@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
On Tue, Feb 4, 2014 at 10:39 AM, Alessandro Bianchi wrote: > > > Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: > > On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: > > in working directory '/usr/share/ovirt-engine-dwh/db-scripts' > 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = > 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: > autenticazione con password fallita per l'utente "engine_history" > password retrieved from file "/tmp/pgpassNkKGNp.tmp" > > (autenticazione con password fallita per l'utente "engine_history" = > authentication failed for user "engine_history" system language is italian) > > so it seems a user creation permission problem on the database > > since I'm not too familiar with pgsql how is it supposed to fix this? > > It look like it misses the password in some ovirt configuration file but > where to edit and how o fix it? > > Any hint? > > Thank you > > See this thread of mine if you want to start from scratch and you > don't have any previous reports/dwh data or you don't mind to loose > them. Engine and its data is not impacted at all. > Eventually I'm going to open a bug for bad mgmt of pre-existing DB > user during setup (eg due to a previously failed in the middle > install). > > http://lists.ovirt.org/pipermail/users/2014-February/020740.html > > Let us know how it goes. > > Gianluca > > Thank you > > I'm following the post but I'm stuck at 3) > > drop user engine_history; > ERRORE: il ruolo "engine_history" non può essere eliminato perché alcuni > oggetti ne dipendono > DETTAGLI: proprietario di database ovirt_engine_history > 300 oggetti nel database ovirt_engine_history > > it says "Error: can't remove role engine_history because some object depend > on it. Detail: database owner ovirt_engine_history 300 objects in database > ovirt_engine history" > > Any hint? > > Thank you for your help It seems I forgot a step... let us call 2bis) you have to drop the two DBS before of users: as postgres user - psql drop database ovirt_engine_history; drop database ovirtenginereports; and then you can drop users Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
Il 04/02/2014 09:55, Gianluca Cecchi ha scritto: On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: in working directory '/usr/share/ovirt-engine-dwh/db-scripts' 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: autenticazione con password fallita per l'utente "engine_history" password retrieved from file "/tmp/pgpassNkKGNp.tmp" (autenticazione con password fallita per l'utente "engine_history" = authentication failed for user "engine_history" system language is italian) so it seems a user creation permission problem on the database since I'm not too familiar with pgsql how is it supposed to fix this? It look like it misses the password in some ovirt configuration file but where to edit and how o fix it? Any hint? Thank you See this thread of mine if you want to start from scratch and you don't have any previous reports/dwh data or you don't mind to loose them. Engine and its data is not impacted at all. Eventually I'm going to open a bug for bad mgmt of pre-existing DB user during setup (eg due to a previously failed in the middle install). http://lists.ovirt.org/pipermail/users/2014-February/020740.html Let us know how it goes. Gianluca Thank you I'm following the post but I'm stuck at 3) drop user engine_history; ERRORE: il ruolo "engine_history" non può essere eliminato perché alcuni oggetti ne dipendono DETTAGLI: proprietario di database ovirt_engine_history 300 oggetti nel database ovirt_engine_history it says "Error: can't remove role engine_history because some object depend on it. Detail: database owner ovirt_engine_history 300 objects in database ovirt_engine history" Any hint? Thank you for your help Alessandro -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare i...@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
On Tue, Feb 4, 2014 at 9:10 AM, Alessandro Bianchi wrote: > in working directory '/usr/share/ovirt-engine-dwh/db-scripts' > 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = > 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: > autenticazione con password fallita per l'utente "engine_history" > password retrieved from file "/tmp/pgpassNkKGNp.tmp" > > (autenticazione con password fallita per l'utente "engine_history" = > authentication failed for user "engine_history" system language is italian) > > so it seems a user creation permission problem on the database > > since I'm not too familiar with pgsql how is it supposed to fix this? > > It look like it misses the password in some ovirt configuration file but > where to edit and how o fix it? > > Any hint? > > Thank you See this thread of mine if you want to start from scratch and you don't have any previous reports/dwh data or you don't mind to loose them. Engine and its data is not impacted at all. Eventually I'm going to open a bug for bad mgmt of pre-existing DB user during setup (eg due to a previously failed in the middle install). http://lists.ovirt.org/pipermail/users/2014-February/020740.html Let us know how it goes. Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
Il 02/02/2014 07:40, Yedidyah Bar David ha scritto: - Original Message - From: "Alessandro Bianchi" To: users@ovirt.org Sent: Friday, January 31, 2014 4:13:51 PM Subject: [Users] ovirt-report Forbidden access error Hi all I installed ovirt-engine-reports-3.3.2-1.fc19.noarch using yum Now I have reports listed when right clicking on Vms but on any report i see this error: Forbidden You don't have permission to access /ovirt-engine-reports/flow.html on this server. This seems to be related to apache redirection but how to fix it? I have three files in conf.d ovirt-engine-root-redirect.conf z-ovirt-engine-proxy.conf z-ovirt-engine-reports-proxy.conf but can't figure how to fix them I applied no changes to these files Did you also run 'ovirt-engine-reports-setup' after installing it? Was it a new installation or an upgrade from 3.2? Both engine and reports. Did you install and setup dwh? Note that there are several bugs in dwh/reports 3.3.2, targeted to be fixed in 3.3.3. So you might want to wait till 3.3.3 is released. Regards, Ok after upgrading to 3.3.3 it asks me to setup dwh again so ovirt-engine-dwh-setup ends with error, log says 2014-02-04 09:01:26::DEBUG::common_utils::907::root:: Executing command --> '/usr/share/ovirt-engine-dwh/db-scripts/upgrade.sh -s localhost -p 5432 -u engine_history -d ovirt_engine_history -l /var/log/ovirt-engine/ovirt-history-db-upgrade-2014_02_04_09_01_26.log -g' in working directory '/usr/share/ovirt-engine-dwh/db-scripts' 2014-02-04 09:01:26::DEBUG::common_utils::962::root:: output = 2014-02-04 09:01:26::DEBUG::common_utils::963::root:: stderr = psql: FATALE: autenticazione con password fallita per l'utente "engine_history" password retrieved from file "/tmp/pgpassNkKGNp.tmp" (autenticazione con password fallita per l'utente "engine_history" = authentication failed for user "engine_history" system language is italian) so it seems a user creation permission problem on the database since I'm not too familiar with pgsql how is it supposed to fix this? It look like it misses the password in some ovirt configuration file but where to edit and how o fix it? Any hint? Thank you Best regards -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it <http://www.skynet.it/> Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare i...@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
Il 02/02/2014 07:40, Yedidyah Bar David ha scritto: - Original Message - From: "Alessandro Bianchi" To: users@ovirt.org Sent: Friday, January 31, 2014 4:13:51 PM Subject: [Users] ovirt-report Forbidden access error Hi all I installed ovirt-engine-reports-3.3.2-1.fc19.noarch using yum Now I have reports listed when right clicking on Vms but on any report i see this error: Forbidden You don't have permission to access /ovirt-engine-reports/flow.html on this server. This seems to be related to apache redirection but how to fix it? I have three files in conf.d ovirt-engine-root-redirect.conf z-ovirt-engine-proxy.conf z-ovirt-engine-reports-proxy.conf but can't figure how to fix them I applied no changes to these files Hi and thank you for your answer Did you also run 'ovirt-engine-reports-setup' after installing it? yes: I had to fix the pg file setting the user as locally enabled as reported by others to avoid the installation "missing password" error Was it a new installation or an upgrade from 3.2? Both engine and reports. Engine was upgraded from 3.2 and reports are newly installed (not preoviously installed) Did you install and setup dwh? yes Note that there are several bugs in dwh/reports 3.3.2, targeted to be fixed in 3.3.3. So you might want to wait till 3.3.3 is released. Regards, I'll wait Thank you Best rgards -- SkyNet SRL Via Maggiate 67/a - 28021 Borgomanero (NO) - tel. +39 0322-836487/834765 - fax +39 0322-836608 http://www.skynet.it <http://www.skynet.it/> Autorizzazione Ministeriale n.197 Le informazioni contenute in questo messaggio sono riservate e confidenziali ed è vietata la diffusione in qualunque modo eseguita. Qualora Lei non fosse la persona a cui il presente messaggio è destinato, La invitiamo ad eliminarlo ed a distruggerlo non divulgandolo, dandocene gentilmente comunicazione. Per qualsiasi informazione si prega di contattare i...@skynet.it (e-mail dell'azienda). Rif. D.L. 196/2003 ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] ovirt-report Forbidden access error
- Original Message - > From: "Alessandro Bianchi" > To: users@ovirt.org > Sent: Friday, January 31, 2014 4:13:51 PM > Subject: [Users] ovirt-report Forbidden access error > > Hi all > > I installed > > ovirt-engine-reports-3.3.2-1.fc19.noarch using yum > > Now I have reports listed when right clicking on Vms but on any report i > see this error: > > > Forbidden > > You don't have permission to access /ovirt-engine-reports/flow.html on > this server. > > This seems to be related to apache redirection but how to fix it? > > I have three files in conf.d > > ovirt-engine-root-redirect.conf > z-ovirt-engine-proxy.conf > z-ovirt-engine-reports-proxy.conf > > but can't figure how to fix them > > I applied no changes to these files Did you also run 'ovirt-engine-reports-setup' after installing it? Was it a new installation or an upgrade from 3.2? Both engine and reports. Did you install and setup dwh? Note that there are several bugs in dwh/reports 3.3.2, targeted to be fixed in 3.3.3. So you might want to wait till 3.3.3 is released. Regards, -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] ovirt-report Forbidden access error
Hi all I installed ovirt-engine-reports-3.3.2-1.fc19.noarch using yum Now I have reports listed when right clicking on Vms but on any report i see this error: Forbidden You don't have permission to access /ovirt-engine-reports/flow.html on this server. This seems to be related to apache redirection but how to fix it? I have three files in conf.d ovirt-engine-root-redirect.conf z-ovirt-engine-proxy.conf z-ovirt-engine-reports-proxy.conf but can't figure how to fix them I applied no changes to these files Any hint? Thank you ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users