You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Dan Dong <do...@gmail.com> on 2014/11/05 22:26:20 UTC

Could not open Management UI after global setting change.

Hi, Experts,
  When I modified the global settings for "secstorage.allowed.internal.sites"
to a different network parameter, I found I could not open the
http://localhost:8080/client UI page anymore, so I could not change back to
the original setting again. How to solve this? Where can I find the
configuration file path on the Management Ububtu server so I can modify it
back by hand? Thanks!

Cheers,
Dan

Re: Could not open Management UI after global setting change.

Posted by Dan Dong <do...@gmail.com>.
Thanks, the value is updated and restarted cloudstack-management, but still
could not open the UI, don't know the reason...

2014-11-05 16:39 GMT-06:00 Jessica Wang <Je...@citrix.com>:

> Erik,
>
> You can change the value in database:
>
>
> update configuration set value='xxxxxxx' where
> name='secstorage.allowed.internal.sites'
>
>
> Jessica
>
>
> -----Original Message-----
> From: Erik Weber [mailto:terbolous@gmail.com]
> Sent: Wednesday, November 05, 2014 2:28 PM
> To: users@cloudstack.apache.org
> Subject: Re: Could not open Management UI after global setting change.
>
> On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:
>
> > Hi, Experts,
> >   When I modified the global settings for
> > "secstorage.allowed.internal.sites"
> > to a different network parameter, I found I could not open the
> > http://localhost:8080/client UI page anymore, so I could not change back
> > to
> > the original setting again. How to solve this? Where can I find the
> > configuration file path on the Management Ububtu server so I can modify
> it
> > back by hand? Thanks!
> >
> >
> The setting should be in your cloud database in the table 'configuration'
>
>
> --
> Erik
>

RE: Could not open Management UI after global setting change.

Posted by Jessica Wang <Je...@citrix.com>.
Erik,

You can change the value in database:


update configuration set value='xxxxxxx' where name='secstorage.allowed.internal.sites'


Jessica


-----Original Message-----
From: Erik Weber [mailto:terbolous@gmail.com] 
Sent: Wednesday, November 05, 2014 2:28 PM
To: users@cloudstack.apache.org
Subject: Re: Could not open Management UI after global setting change.

On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:

> Hi, Experts,
>   When I modified the global settings for
> "secstorage.allowed.internal.sites"
> to a different network parameter, I found I could not open the
> http://localhost:8080/client UI page anymore, so I could not change back
> to
> the original setting again. How to solve this? Where can I find the
> configuration file path on the Management Ububtu server so I can modify it
> back by hand? Thanks!
>
>
The setting should be in your cloud database in the table 'configuration'


-- 
Erik

Re: Could not open Management UI after global setting change.

Posted by Dan Dong <do...@gmail.com>.
Hi, Jessica,
  Thanks, turns out to be a firewall problem.
Dan


2014-11-05 18:00 GMT-06:00 Jessica Wang <Je...@citrix.com>:

> Dan,
>
> > but still could not open the UI
>
> What error did you see in browser window?
>
> (If you are using firefox, you can see error in firebug)
>
> Jessica
>
>
> -----Original Message-----
> From: Dan Dong [mailto:dongdan39@gmail.com]
> Sent: Wednesday, November 05, 2014 3:16 PM
> To: users@cloudstack.apache.org
> Subject: Re: Could not open Management UI after global setting change.
>
> Hi, Jessica,
>   Yes, I used the single quote and get the value updated, but still could
> not open the UI even after I reboot the server. I remember after I modified
> this value though the UI this morning, the UI got stuck there and then I
> could not open it anymore, really strange. Any hints?
>
> +----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
> | category | instance | component         |
> name                              | value          |
> description
> | default_value | updated | scope | is_dynamic |
>
> +----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
> | Advanced | DEFAULT  | management-server |
> secstorage.allowed.internal.sites | 192.168.1.0/24 | Comma separated list
> of cidrs internal to the datacenter that can host template download
> servers, please note 0.0.0.0 is not a valid site | NULL          | NULL
> | NULL  |          0 |
>
> +----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
>
>
> Dan
>
>
> 2014-11-05 16:49 GMT-06:00 Jessica Wang <Je...@citrix.com>:
>
> > Dan,
> >
> > You should use single quote instead of double quote like this:
> >
> >
> > update configuration set value='192.168.1.0/24' where
> > name='secstorage.allowed.internal.sites';
> >
> >
> >
> > Jessica
> >
> > -----Original Message-----
> > From: Dan Dong [mailto:dongdan39@gmail.com]
> > Sent: Wednesday, November 05, 2014 2:41 PM
> > To: users@cloudstack.apache.org
> > Subject: Re: Could not open Management UI after global setting change.
> >
> > Thanks Erik, I found it, but when I tried to update it, I got error:
> > mysql> update configuration set "secstorage.allowed.internal.sites"="
> > 192.168.1.0/24";
> > ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual
> > that corresponds to your MySQL server version for the right syntax to use
> > near '"secstorage.allowed.internal.sites"="192.168.0.0/24"' at line 1
> >
> >
> >
> > 2014-11-05 16:28 GMT-06:00 Erik Weber <te...@gmail.com>:
> >
> > > On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:
> > >
> > > > Hi, Experts,
> > > >   When I modified the global settings for
> > > > "secstorage.allowed.internal.sites"
> > > > to a different network parameter, I found I could not open the
> > > > http://localhost:8080/client UI page anymore, so I could not change
> > back
> > > > to
> > > > the original setting again. How to solve this? Where can I find the
> > > > configuration file path on the Management Ububtu server so I can
> modify
> > > it
> > > > back by hand? Thanks!
> > > >
> > > >
> > > The setting should be in your cloud database in the table
> 'configuration'
> > >
> > >
> > > --
> > > Erik
> > >
> >
>

RE: Could not open Management UI after global setting change.

Posted by Jessica Wang <Je...@citrix.com>.
Dan,

> but still could not open the UI

What error did you see in browser window?

(If you are using firefox, you can see error in firebug)

Jessica


-----Original Message-----
From: Dan Dong [mailto:dongdan39@gmail.com] 
Sent: Wednesday, November 05, 2014 3:16 PM
To: users@cloudstack.apache.org
Subject: Re: Could not open Management UI after global setting change.

Hi, Jessica,
  Yes, I used the single quote and get the value updated, but still could
not open the UI even after I reboot the server. I remember after I modified
this value though the UI this morning, the UI got stuck there and then I
could not open it anymore, really strange. Any hints?
+----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
| category | instance | component         |
name                              | value          |
description
| default_value | updated | scope | is_dynamic |
+----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
| Advanced | DEFAULT  | management-server |
secstorage.allowed.internal.sites | 192.168.1.0/24 | Comma separated list
of cidrs internal to the datacenter that can host template download
servers, please note 0.0.0.0 is not a valid site | NULL          | NULL
| NULL  |          0 |
+----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+


Dan


2014-11-05 16:49 GMT-06:00 Jessica Wang <Je...@citrix.com>:

> Dan,
>
> You should use single quote instead of double quote like this:
>
>
> update configuration set value='192.168.1.0/24' where
> name='secstorage.allowed.internal.sites';
>
>
>
> Jessica
>
> -----Original Message-----
> From: Dan Dong [mailto:dongdan39@gmail.com]
> Sent: Wednesday, November 05, 2014 2:41 PM
> To: users@cloudstack.apache.org
> Subject: Re: Could not open Management UI after global setting change.
>
> Thanks Erik, I found it, but when I tried to update it, I got error:
> mysql> update configuration set "secstorage.allowed.internal.sites"="
> 192.168.1.0/24";
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '"secstorage.allowed.internal.sites"="192.168.0.0/24"' at line 1
>
>
>
> 2014-11-05 16:28 GMT-06:00 Erik Weber <te...@gmail.com>:
>
> > On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:
> >
> > > Hi, Experts,
> > >   When I modified the global settings for
> > > "secstorage.allowed.internal.sites"
> > > to a different network parameter, I found I could not open the
> > > http://localhost:8080/client UI page anymore, so I could not change
> back
> > > to
> > > the original setting again. How to solve this? Where can I find the
> > > configuration file path on the Management Ububtu server so I can modify
> > it
> > > back by hand? Thanks!
> > >
> > >
> > The setting should be in your cloud database in the table 'configuration'
> >
> >
> > --
> > Erik
> >
>

Re: Could not open Management UI after global setting change.

Posted by Dan Dong <do...@gmail.com>.
Hi, Jessica,
  Yes, I used the single quote and get the value updated, but still could
not open the UI even after I reboot the server. I remember after I modified
this value though the UI this morning, the UI got stuck there and then I
could not open it anymore, really strange. Any hints?
+----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
| category | instance | component         |
name                              | value          |
description
| default_value | updated | scope | is_dynamic |
+----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+
| Advanced | DEFAULT  | management-server |
secstorage.allowed.internal.sites | 192.168.1.0/24 | Comma separated list
of cidrs internal to the datacenter that can host template download
servers, please note 0.0.0.0 is not a valid site | NULL          | NULL
| NULL  |          0 |
+----------+----------+-------------------+-----------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------+---------+-------+------------+


Dan


2014-11-05 16:49 GMT-06:00 Jessica Wang <Je...@citrix.com>:

> Dan,
>
> You should use single quote instead of double quote like this:
>
>
> update configuration set value='192.168.1.0/24' where
> name='secstorage.allowed.internal.sites';
>
>
>
> Jessica
>
> -----Original Message-----
> From: Dan Dong [mailto:dongdan39@gmail.com]
> Sent: Wednesday, November 05, 2014 2:41 PM
> To: users@cloudstack.apache.org
> Subject: Re: Could not open Management UI after global setting change.
>
> Thanks Erik, I found it, but when I tried to update it, I got error:
> mysql> update configuration set "secstorage.allowed.internal.sites"="
> 192.168.1.0/24";
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '"secstorage.allowed.internal.sites"="192.168.0.0/24"' at line 1
>
>
>
> 2014-11-05 16:28 GMT-06:00 Erik Weber <te...@gmail.com>:
>
> > On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:
> >
> > > Hi, Experts,
> > >   When I modified the global settings for
> > > "secstorage.allowed.internal.sites"
> > > to a different network parameter, I found I could not open the
> > > http://localhost:8080/client UI page anymore, so I could not change
> back
> > > to
> > > the original setting again. How to solve this? Where can I find the
> > > configuration file path on the Management Ububtu server so I can modify
> > it
> > > back by hand? Thanks!
> > >
> > >
> > The setting should be in your cloud database in the table 'configuration'
> >
> >
> > --
> > Erik
> >
>

RE: Could not open Management UI after global setting change.

Posted by Jessica Wang <Je...@citrix.com>.
Dan,

You should use single quote instead of double quote like this:


update configuration set value='192.168.1.0/24' where name='secstorage.allowed.internal.sites';



Jessica

-----Original Message-----
From: Dan Dong [mailto:dongdan39@gmail.com] 
Sent: Wednesday, November 05, 2014 2:41 PM
To: users@cloudstack.apache.org
Subject: Re: Could not open Management UI after global setting change.

Thanks Erik, I found it, but when I tried to update it, I got error:
mysql> update configuration set "secstorage.allowed.internal.sites"="
192.168.1.0/24";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '"secstorage.allowed.internal.sites"="192.168.0.0/24"' at line 1



2014-11-05 16:28 GMT-06:00 Erik Weber <te...@gmail.com>:

> On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:
>
> > Hi, Experts,
> >   When I modified the global settings for
> > "secstorage.allowed.internal.sites"
> > to a different network parameter, I found I could not open the
> > http://localhost:8080/client UI page anymore, so I could not change back
> > to
> > the original setting again. How to solve this? Where can I find the
> > configuration file path on the Management Ububtu server so I can modify
> it
> > back by hand? Thanks!
> >
> >
> The setting should be in your cloud database in the table 'configuration'
>
>
> --
> Erik
>

Re: Could not open Management UI after global setting change.

Posted by Dan Dong <do...@gmail.com>.
Thanks Erik, I found it, but when I tried to update it, I got error:
mysql> update configuration set "secstorage.allowed.internal.sites"="
192.168.1.0/24";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '"secstorage.allowed.internal.sites"="192.168.0.0/24"' at line 1



2014-11-05 16:28 GMT-06:00 Erik Weber <te...@gmail.com>:

> On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:
>
> > Hi, Experts,
> >   When I modified the global settings for
> > "secstorage.allowed.internal.sites"
> > to a different network parameter, I found I could not open the
> > http://localhost:8080/client UI page anymore, so I could not change back
> > to
> > the original setting again. How to solve this? Where can I find the
> > configuration file path on the Management Ububtu server so I can modify
> it
> > back by hand? Thanks!
> >
> >
> The setting should be in your cloud database in the table 'configuration'
>
>
> --
> Erik
>

Re: Could not open Management UI after global setting change.

Posted by Erik Weber <te...@gmail.com>.
On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <do...@gmail.com> wrote:

> Hi, Experts,
>   When I modified the global settings for
> "secstorage.allowed.internal.sites"
> to a different network parameter, I found I could not open the
> http://localhost:8080/client UI page anymore, so I could not change back
> to
> the original setting again. How to solve this? Where can I find the
> configuration file path on the Management Ububtu server so I can modify it
> back by hand? Thanks!
>
>
The setting should be in your cloud database in the table 'configuration'


-- 
Erik