User Tools

Site Tools


reference:alter_lan_forwarding_rules_for_one_server_to_go_to_another

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

reference:alter_lan_forwarding_rules_for_one_server_to_go_to_another [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======Database query to alter LAN Forwarding rules for one server to go to another======
  
 +If a LAN forwarding destination server fails, you may wish to change the LAN forwarding rules to point to the new server. (Note that, if planning ahead, it may be easier to use DNS host names as the targets, so you can simply change the IP address associated with the server host name instead)
 +
 +As this database query updates the database, be sure to take care doing it as you can damage your VPOP3 installation if you do it incorrectly. Make sure you have a database backup before performing the query.
 +
 +If you want an extra bit of safety, see the [[running database updates within a transaction]] article.
 +
 +At a command prompt in the VPOP3 directory run
 +
 +  psql
 +  ​
 +(The password is '​vpop3pass'​)
 +
 +Then, type
 +
 +  UPDATE rules.lanforwarding SET server='<​new server>'​ WHERE server='<​old server>';​
 +  ​
 +Where <new server> and <old server> are the IP address (and optional port number if not 25) of the new & old LAN forward target servers respectively. Don't include the <>.
 +
 +eg
 +
 +  UPDATE rules.lanforwarding SET server='​192.168.1.53'​ WHERE server='​192.168.1.52:​587';​
 +
 +If you have SMTP authentication on the new server, you can use
 +
 +  UPDATE rules.lanforwarding SET server='<​new server>',​ username='<​username>'​ password='<​password>'​ WHERE server='<​old server>';​
 +
 +
 +N.B. VPOP3 does not need to be stopped while you do this
reference/alter_lan_forwarding_rules_for_one_server_to_go_to_another.txt ยท Last modified: 2018/11/14 10:45 (external edit)