Where is the application URL stored? How to get it? How to change it?

System Administration
, , ,
1

Where is the application URL stored?

It is stored in the oro_config_value table:

How to get it?

You can get it with the SQL query:

SELECT text_value FROM oro_config_value WHERE name = 'application_url'

E.g., you can run this SQL query with the command line:

mysql --host=<host> --user=<user> --password=<password> --database=<database> -e \
"SELECT text_value FROM oro_config_value WHERE name = 'application_url'"

How to change it?

You can change it with the following SQL query:

UPDATE oro_config_value 
SET text_value = '<new URL>' 
WHERE name = 'application_url';

E.g, you can run this SQL query with the command line:

mysql --host=<host> --user=<user> --password=<password> --database=<database> -e \
UPDATE oro_config_value \
SET text_value = '<new URL>' \
WHERE name = 'application_url';"

Then delete the cache.