User Tools

Site Tools


reference:alter_lan_forwarding_queued_messages_going_to_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_queued_messages_going_to_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 queued messages to go to the new server. (Note that, if planning ahead, it may be easier to use DNS host names as the targets in the rules, 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 messages.outgoingtargets SET target='<​new server>'​ WHERE target='<​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 messages.outgoingtargets SET target='​192.168.1.53'​ WHERE target='​192.168.1.52:​587';​
 +
 +If you have SMTP authentication on the new server, you can use
 +
 +  UPDATE messages.outgoingtargets SET target='<​new server>',​ username='<​username>'​ password='<​password>'​ WHERE target='<​old server>';​
 +
 +
 +N.B. VPOP3 does not need to be stopped while you do this
reference/alter_lan_forwarding_queued_messages_going_to_one_server_to_go_to_another.txt ยท Last modified: 2018/11/14 10:45 (external edit)