> psql U postgres d SIPXCONFIG
# psql -U postgres -d SIPXCONFIG
Welcome to psql 8.1.22, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
SIPXCONFIG=# select location_id, name, ip_address from location;
location_id | name | ip_address
-------------+----------------+--------------
1 | Primary server | 172.16.60.20
(1 row)
SIPXCONFIG=# Enter \q to exit psql
\q: extra argument "to" ignored
\q: extra argument "exit" ignored
\q: extra argument "psql" ignored
> This IP address is managed on the Server / (select Server) / Configure page
> which a previous post had noted as a step. If you executed that step, the
> database should be correct.
I did this the day I changed the IP on the server.
> Did you Send Profiles after changing the IP address through that page?
No, I didn't do that. I only changed the IP and restarted the services which I
thought would amount to the same thing.
> looked back at previous posts and that is the one step that I did not see
> included in that post. Sending Profile for the server generates new config
> files. You will be required to restart services after sending profiles.
Not sure if it's too late now but ran this.
> We have also found that you may need to reboot the server instead of just
> restarting services.
Rebooted, old IP still in db files.
_______________________________________________
sipx-users mailing list
[email protected]
List Archive: http://list.sipfoundry.org/archive/sipx-users/
