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 <jessica.w...@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:dongda...@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 <terbol...@gmail.com>: > > > On Wed, Nov 5, 2014 at 10:26 PM, Dan Dong <dongda...@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 > > >
