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 >
