Forum OpenACS Q&A: Unable to change SystemURL

Collapse
1: Unable to change SystemURL
Posted by Chiru Chiru on 12/21/04 01:29 AM
Hi,

I was trying to publish the site and changed they SystemURL value from the kernel options in the admin menu.

But unfortunately, I changed it to the wrong address and now I cannot access my site. How can I get back in to change the URL back?

I tried changing the acs-kernel.info file but it didnt work as it seems to be having a default value.

What else can I do? How can I change it back?

Thanks

Collapse
2: Re: Unable to change SystemURL (response to 1)
Posted by Jade Rubick on 12/21/04 01:39 AM
Chiru: do you know how to get into the database? You can use psql or sqlplus to query the preferences tables and change it back.

You should probably also file a bug. There should be a big warning to change this carefully, if it's not already there!

Collapse
3: Re: Unable to change SystemURL (response to 1)
Posted by Chiru Chiru on 12/21/04 04:36 PM
Ok,
Figured it out!

Had to go into the database to do it. There are two table apm_parameters and apm_parameter_values.

The second one had the values in it including the SystemURL. I just updated the row and it worked.

I knew the wrong value I gave in, otherwise, I would have to join both tables and do some searching.

Its quite interesting, I changed the SystemURL value from http://mysite.com:8000 to http://mysite.com:8000/, an extra '/' at the end.