https://wiki.pscs.co.uk/ 2026-05-13T05:01:35+00:00 https://wiki.pscs.co.uk/ https://wiki.pscs.co.uk/_media/wiki:dokuwiki.svg text/html 2025-05-08T08:23:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:lua_smtp_server_script?rev=1746692615&do=diff SMTP Server Lua Scripting The SMTP Server Lua Script is called SMTPSVR.LUA and can be edited from the Settings -> Scripts page in the VPOP3 settings. This script is called whenever an instance of the VPOP3 SMTP server is launched - ie whenever someone opens a connection to port 25 on the VPOP3 server to send it a message, whether from a local user or an incoming SMTP message. text/html 2026-04-21T11:12:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v5_-_move_to_a_new_pc?rev=1776769960&do=diff Move VPOP3 Version 5 (or later) to a new PC Moving VPOP3 Version 5 or later to a new PC is slightly different from moving earlier versions, because of the database system, which was introduced for version 3 and modified for version 5. The summary of steps is: * Stop VPOP3 on the original PC text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_backups?rev=1542192349&do=diff Database -> Backups Tab The Backups tab lets you specify how VPOP3 will make its daily backup of its database. We strongly recommend that you backup the database regularly in case of disk problems or file corruption. You can use the VPOP3 backup feature, or manually backup the PostgreSQL database using the pg_dump command, or use another program to backup the PostgreSQL database if you wish. Note that a simple disk copy will text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:backup_vpop3?rev=1542192349&do=diff How to Backup VPOP3 By default VPOP3 v3 and later will automatically perform a daily backup of the database into a file called DBBACK-x.DMP, where the backup file rotates on a weekly basis (DBBACK-0.DMP is Sunday's backup, DBBACK-1.DMP is Monday's backup, etc). text/html 2019-02-06T17:10:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:postgresql_replication?rev=1549473031&do=diff PostgreSQL Replication PostgreSQL 9.1 (used in VPOP3 5 and later) supports replication from a 'Master' to a 'Slave' database server. This can be used with VPOP3 for having a near-realtime backup of your settings & messages. To use the replication, you need to have a file share which is accessible from both PCs. The thing to watch out for is that the PostgreSQL services may be running as a different user from the currently logged in user, so make sure that the user(s) which the PostgreSQL servi… text/html 2019-11-12T16:09:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_to_a_new_pc?rev=1573574948&do=diff Move VPOP3 Version 3 or 4 to a new PC Moving VPOP3 Version 3 or 4 to a new PC is slightly different from moving earlier versions, because of the database system. The summary of steps is: * Stop VPOP3 on the original PC * Manually make a backup of the database on the original PC text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:autoresponder_commands?rev=1542192349&do=diff Autoresponder Commands This article only applies to VPOP3 v4 and earlier A VPOP3 autoresponder can contain special text strings to create special behaviour, in addition to plain text as part of the response. There are three types of 'command' * text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_restore?rev=1542192349&do=diff Database -> Restore Tab This tab is only in VPOP3 Enterprise (v5 and later), and is for performing a partial (mailbox/mail folder) restore of the database. To do a full restore of the database, or for VPOP3 Basic/Standard, see the “Restore a Backup of VPOP3” topic Using the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:listserver_commands?rev=1542192349&do=diff ListServer Commands The ListServer is an automated process in VPOP3 which manages mailing lists. People can send commands to the ListServer to perform various functions remotely. Whether these commands are allowed, and exactly how they work depends on the particular mailing list's settings. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_maintenance?rev=1542192349&do=diff Database Maintenance VPOP3 uses the PostgreSQL database server for most of its data storage. Normally this will not require any special maintenance, because it will manage itself. To do any special database maintenance you will need to close down VPOP3 first, because PostgreSQL needs exclusive access to the database to perform any operations such as decreasing the size of database files. Note that these operations may take some time! There are some PostgreSQL utility programs in the VPOP3\pgs… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:pop3_client_problem?rev=1542192349&do=diff VPOP3 - POP3 Client Problem These errors occur whilst VPOP3 is communicating with your ISP's POP3 mail server to retrieve your mail. The server connection was closed unexpectedly If the message text is Error with Pop3 Client (XXXX (YY)) The server connection was closed unexpectedly text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_message_store?rev=1542192349&do=diff How to move the VPOP3 Message Store to a new PC Use this option if you want to have VPOP3 running on one PC, but have the message store database on another PC. Manually Install PostgreSQL on the new PC Download the 'pgInstaller' version of PostgreSQL from the text/html 2018-12-05T15:25:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_message_store_folder?rev=1544023524&do=diff v3/4 - Move the message store to a new folder/drive This guide assumes you want to just move the VPOP3 message store/database to a new folder on the same PC, and leave the VPOP3 installation directory where it is. * Stop VPOP3 * Stop PostgreSQL text/html 2019-11-12T16:10:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v5_-_move_the_message_store_to_a_new_folder_drive?rev=1573575042&do=diff v5 - Move the message store to a new folder/drive Here is an alternative method, which may be simpler, but only moves the data, not the whole database store (which is a subtle difference) This guide assumes you want to just move the VPOP3 message store/database to a new folder on the same PC, and leave the VPOP3 installation directory where it is. text/html 2026-02-24T15:49:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:lua_smtp_mx_control?rev=1771948188&do=diff Lua SMTP MX Control Every time VPOP3 is going to send messages using direct MX sending, it runs a script called mxout.lua which can be created/edited in Settings -> Scripts (or in the VPOP3 directory in VPOP3 v6.6 or earlier). Global Variables Starting with v8.8, the following global variables are defined: text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:running_database_updates_within_a_transaction?rev=1542192349&do=diff Running database updates within a transaction This is a trick which database experts use, because they have learned (often the hard way) that a simple mistype can trash a database... Before running any database query which can alter the database (UPDATE, DELETE, INSERT, DROP, CREATE, ALTER) begin a database transaction using the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:command_prompt?rev=1542192349&do=diff How to Open a Command Prompt In Windows do Start -> Run and then type in cmd in the text box. Click on OK. You should then see a black box with white text and a flashing cursor. This is the command prompt. command prompt dos diagnostic test text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:estimate_db_upgrade_time?rev=1542192349&do=diff How to estimate Database Upgrade Time When upgrading from VPOP3 version 3 or 4 to version 5, the PostgreSQL database engine needs to be upgraded. This involves backing up the database data, upgrading the database engine, then restoring the data. This can take some time on large databases. text/html 2025-09-11T13:48:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:recovering_messages_from_corrupted_database_into_fresh_database?rev=1757598487&do=diff Recovering messages from corrupted database into fresh database If the VPOP3 message database is corrupted, then one option is to build a fresh database and restore the settings into it, then recover the messages from the old database using the 'Message Restore' function in VPOP3. This has minimal downtime, but old messages will not all be available until the restore has completed. New messages will be available quickly, and you will be able to send messages. text/html 2024-01-15T11:35:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:repairing_corrupted_database?rev=1705318545&do=diff Repairing corrupted database With PostgreSQL (as with most high-end databases) the database system will automatically recover after power failures etc, if it can. If it can't then there is no manual 'repair' function, because the data cannot totally be recovered (or it would automatically have been recovered). text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:total_rebuild_of_database?rev=1542192349&do=diff Total Rebuild of Database If you suspect database corruption, sometimes the best thing to do is to totally rebuild the database. This involves six steps: * Stop VPOP3 * Backup Database * Delete Database * Re-create Database * Restore/Create Database text/html 2021-03-19T16:01:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v5_-_move_to_a_new_folder?rev=1616169708&do=diff How to move VPOP3 V5+ to a new folder This guide assumes you want to move the whole of VPOP3 (including the message store) to a new folder on the same PC * Stop VPOP3 * Stop VPOP3DB * Remove the VPOP3DB service * Move VPOP3 to the new folder text/html 2025-06-23T10:51:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:imap4_server_script?rev=1750675906&do=diff IMAP4 Server Scripting (Added in V6.12) DoCapability function When the IMAP4 CAPABILITY command is received, VPOP3 generates a capability string based on settings, then calls DoCapability(ipaddr, capabilities) * ipaddr = IP address of the client computer text/html 2025-08-14T09:24:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:lua_smtp_relay_control?rev=1755163495&do=diff Lua SMTP Relay Control Every time VPOP3 is going to send messages via SMTP Relay, it runs a script called relayout.lua in the VPOP3 directory. Global Variables This script may have global variables, depending on your version of VPOP3. In VPOP3 3.0.0L and later, there are two read-only global variables set at the start of the script: text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:smtp_advanced?rev=1542192349&do=diff SMTP Service -> Advanced Tab Services -> SMTP Server -> Advanced Tab Refuse SMTP Connections from This setting should be rarely needed, and should be normally left blank. It is here for historic purposes. If you put some text in this box, then VPOP3 will refuse any SMTP connections from clients whose 'HELO'/'EHLO' command data contains the text specified here as a substring. Eg, if this setting is set to '.myisp.com', then VPOP3 would refuse SMTP connections from any client which sends the c… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_star_ifsupport?rev=1542192349&do=diff Spam Filter Rules: *IFSUPPORT Statement *IFSUPPORT Version 2.2.5+ Purpose Allows the script to determine whether a particular command or function is supported by the installed version of VPOP3 The *IFSUPPORT statement requires a command or a function, in the format text/html 2019-08-19T08:58:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:status_monitor_protocol?rev=1566205125&do=diff Status Monitor (port 5109) protocol This page documents the protocol used between VPOP3 and the Status Monitor. It's not intended for any other purpose, so it's a bit limited, but in certain cases you may find this useful Login Before the Status Monitor receives any updates or can issue commands it must log in using a user's credentials. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:version_5_webadmin_api?rev=1542192349&do=diff Version 5 Web Admin API This section is only relevant for people who may want to access the Administration features from their own scripts, or want to customise the standard administration pages. Note that no free support is available for this. This is not a full list of features, but it will be updated from time to time. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:10503?rev=1542192349&do=diff Socket Error 10503 - No More Data Error 10503 means that the connection between VPOP3 and a remote computer (normally your ISP) was dropped at an unexpected time. This is different from the error 10054 in that this is a controlled line drop. One way this can happen is if the ISP's POP3 server uses an obsolete standard which allows it to drop the connection if a POP3 'LIST' command is performed on an empty mailbox. The current standard requires that the connection is not dropped until the clien… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:data_stream_contained_nul_character?rev=1542192349&do=diff Data stream contained NUL character Description of the problem NUL characters (bytes with value 0) are not allowed in email messages and should not be transmitted over POP3, SMTP or IMAP4 except in certain circumstances. If an attachment contains such a byte it must be encoded using text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_backup_failed?rev=1542192349&do=diff Database Backup Failed VPOP3 version 3 and later will, by default, make a backup of the database used by VPOP3 into a file. This uses the PostgreSQL utility 'pg_dump' If an error occurs whilst running this program, VPOP3 will create a 'Database Backup Failed' error message to the administrator. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:err_can_t_open_the_message_file_-_it_s_gone?rev=1542192349&do=diff -ERR Can't open the message file - it's gone! If VPOP3 receives the error message “-ERR Can't open the message file - it's gone!” from your ISP's POP3 server when it is downloading messages, this is a symptom of a fundamental bug in your ISP's POP3 server. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:error_sending_message_after_authentication?rev=1542192349&do=diff "Error Sending Message After Authentication" in Webmail If you get an error while sending a message using Webmail, such as “Error sending message after authentication - error 0 - text 502 Error: command not implemented” this means that you have another SMTP server running on the VPOP3 computer, and when the VPOP3 Webmail service tries to send the message it is sending it to this other SMTP server, rather than to the VPOP3 server. The Webmail service uses internal commands which the other SMTP… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:move_the_message_store_-_alternative_method?rev=1542192349&do=diff Move the message store - alternative method This method moves the database data storage location, but not the whole database. This means that the database configuration, logs, transaction logs etc are still stored in the VPOP3\pgsql\data folder, but the actual database tables & indexes are stored in the new location. This may be simpler, but, depending on your requirements, text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:moving_messages?rev=1542192349&do=diff How to move messages between users There are several ways to do this, depending on your exact needs Via Administrator Console You can view a user's 'Inbox' messages by clicking on the message count on the Users list, then select the messages, choose the target user, and press the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:ping_test?rev=1542192349&do=diff The ping command is a useful way of diagnosing network problems. It's similar to the sonar ping in a submarine. It sends out a signal to a specified machine and waits for a response to be echoed back. * Open a command prompt * Type ping www.pscs.co.uk. You should see a display like this: text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:postgresql_server_won_t_start_due_to_damaged_log_files?rev=1542192349&do=diff PostgreSQL server won't start due to damaged log files If the PostgreSQL server won't start at all, because its transaction logs are damaged, you will probably need to recreate the database store totally. To rebuild the database: * Open a command prompt and find the VPOP\pgsql folder text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_a_backup_of_vpop3?rev=1542192349&do=diff How to Restore a backup of VPOP3 The instructions below are to restore a full backup. You may also be able to recover deleted messages if you do not need to restore a full backup. Version 5 or later If you just need to restore a database backup, see steps 4 to 7 below. text/html 2025-12-17T09:19:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_a_database_backup?rev=1765963180&do=diff Restore a database backup By default VPOP3 makes a daily backup of the VPOP3 database to a file 'DBBACK-n.DMP' in the VPOP3 installation directory (it is possible to change this in the settings). These are cycled on a weekly basis so you will usually have the last seven days' worth of backups. These can be useful if the database gets damaged somehow. text/html 2022-11-18T11:43:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_deleted_calendars?rev=1668771832&do=diff Restore Deleted Calendars This article will help if a user has been deleted and all their calendars are lost and need to be restored. Note that this functionality is not built into VPOP3, and requires the use of Python3 to run a script First you need to install Python 3.8 or later, and the psycopg2 plugin text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:restore_folder_-_v5?rev=1542192349&do=diff Restore selected mail folders or mailbox in VPOP3 v5 or later (This option is only available in VPOP3 Enterprise) First - if the problem is that messages were deleted very recently (the default is within 3 days), you can probably use the Undelete feature in VPOP3. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:smtp_client_problem?rev=1542192349&do=diff VPOP3 - SMTP Client Problem These errors occur whilst VPOP3 is communicating with your ISP's SMTP mail server to send your mail. If the message text is: Error with SMTP Client (XXXX (YY)) The server connection was closed unexpectedly Then this means that the the connection between VPOP3 and your ISP's SMTP mail server was closed when VPOP3 did not expect it to be. This can be caused by the network connection failing or a bug in the ISP's mail server which drops the connection in abnormal circ… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:start_vpop3?rev=1542192349&do=diff How to start VPOP3 There are two ways to start VPOP3 * as a service * as a normal application For normal operation, you will start VPOP3 as a service, as this means that VPOP3 will run even when no one is logged into the PC. To help with some types of problem diagnosis it can be better to start it as an application. This makes VPOP3 run in the account of the currently logged in user, rather than the service account, so it can eliminate access permission problems. Also, when VPOP3 starts a… text/html 2020-06-29T10:43:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_7?rev=1593427438&do=diff How to upgrade VPOP3 to version 7 or later from version 6 or earlier As usual the process to upgrade is simply to install the later version over your existing installation (do not uninstall anything first). The below is technical information detailing an extra step performed by the installer in this particular upgrade step. text/html 2018-12-05T15:25:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:v3_-_move_to_a_new_folder?rev=1544023541&do=diff How to move VPOP3 V3 to a new folder This guide assumes you want to move the whole of VPOP3 (including the message store) to a new folder on the same PC * Stop VPOP3 * Stop PostgreSQL * Remove the PostgreSQL service * Move VPOP3 to the new folder text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_cannot_access_postgresql_-_timeout_expired?rev=1542192349&do=diff VPOP3 cannot access PostgreSQL - timeout expired This is an error which may be logged in the Windows event log It is event 4547 from the source 'VPOP3' If the event message DLL is not correctly installed it may display as: The description for Event ID ( 4547 ) in Source ( VPOP3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this desc… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_not_starting_properly?rev=1542192349&do=diff VPOP3 Not Starting Properly If VPOP3 is not starting properly, then the first thing to check is whether the database server is starting. In VPOP3 v3 and later, VPOP3 uses a PostgreSQL Database server for data storage, so if the database server is not running, VPOP3 will not be able to start properly. In this case, the VPOP3.EXE process may appear in Task Manager, but it won't respond to anything, or it may appear in Task Manager and then stop after a short period. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3db_service_doesn_t_exist?rev=1542192349&do=diff VPOP3DB Service doesn't exist If VPOP3 v3 or later won't start, and you find that the VPOP3DB (or PostgreSQL-VPOP3) service does not exist in the Windows Services list, it may be that you have just moved VPOP3 and made a mistake following the move procedure or something has removed the service for some reason. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/mailapi:version_5_webmail_api?rev=1542192349&do=diff Version 5 Web Mail API This section is only relevant for people who may want to access the WebMail features from their own scripts, or want to customise the standard Webmail pages. Note that no free support is available for this. This is not a full list of features, but it will be updated from time to time. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:imap4_advanced?rev=1542192349&do=diff IMAP4 -> Advanced tab This page is reached from Services -> IMAP4 Server, then the Advanced tab. Here are some advanced options for the IMAP4 service in VPOP3 Fake access to inaccessible mailboxes In the IMAP4 service you may have folders which do not exist. For instance, if you are accessing a shared Inbox folder from a user called 'Karen', then their folder will be called text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:incoming_smtp?rev=1542192349&do=diff Incoming SMTP Mail If you have an incoming SMTP mail feed, then the mail server sending mail to you will connect to your VPOP3 computer to send the mail. The mail connection is controlled by the sending computer. IMPORTANT If you have a permanent Internet connection with a static IP address, the usual way of having incoming SMTP is to configure your text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:make_lan_forwarding_immediately_attempt_to_dequeue_all_pending_messages?rev=1542192349&do=diff Database query to make LAN Forwarding immediately attempt to dequeue all pending messages If VPOP3 cannot send messages using LAN Forwarding it will queue the message and retry periodically. Usually there is no need to do anything special if there was a problem with the onward mail server which has now been fixed, VPOP3 should soon retry the messages automatically (based on the value of the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:message_archive?rev=1542192349&do=diff Message Archive The Message Archive facility is for VPOP3 to store copies of all messages sent or received. It stores the messages in a central archive store which can be searched by an administrator. The prime purpose of the archive facility is for recording messages in case of possible disputes, as you can see what was sent/received by email. It can also be used as a backup/restore facility in an emergency, but that is not its prime purpose, so it is better to have a proper text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:os.timedexecute?rev=1542192349&do=diff os.timedexecute The Lua function 'os.timedexecute' runs an external program with a time limit It takes three parameters: * The program/command line to execute * The time to wait for completion (in seconds). If this time expires, the program is terminated text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:smtpstats_smtpclientfailures?rev=1542192349&do=diff SMTPStats.SMTPClientFailures table The SMTPStats.SMTPClientFailures table contains logging data about errors/usage for the SMTP Services in VPOP3. These are used for the Intrusion Protection facility & logging. Columns * id - sequential ID for the event * ipaddress - the SMTP client's IP address text/html 2025-10-14T15:43:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:gdpr_hosted_vpop3?rev=1760456581&do=diff GDPR for hosted VPOP3 service (Since Brexit, the UK has “UK GDPR” instead of “EU GDPR”, so this document refers to UK GDPR) Also see GDPR for VPOP3 as most of that applies to the VPOP3 hosting service as well. This Data Processing Agreement is part of our hosted VPOP3 service terms. You can view the revision history by clicking on the 'clock' icon to the right. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:gdpr_other_hosting?rev=1542192349&do=diff GDPR for other hosting services (eg web hosting) As a hosted service provider, we are classed as a “Data Processor” under the GDPR regulations. For our hosting services: * Data is held in the UK. Data is not transmitted outside of the EU except at your explicit request or command. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:10048?rev=1542192349&do=diff Socket Error 10048 - Specified Address Already in Use This error only normally occurs during VPOP3 startup. It occurs if some other software running on the same machine as VPOP3 is using one of the ports that VPOP3 is already using. This could be a proxy like WinGate, WinProxy or anti-virus software that acts as a proxy, an LDAP server (e.g. Active Directory) or another mail server program (e.g. Exchange Server). The latter two causes are particularly common on text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:alternative_method_of_automatically_starting_vpop3?rev=1542192349&do=diff Alternative method of automatically starting VPOP3 VPOP3 usually automatically starts as a Windows service. Sometimes this does not work, either because other services need to start first, or Windows is going very slowly at startup, causing the database service to time out, or there are certain database control files which did not get cleared after a previous Windows shutdown. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:bad_bindings?rev=1542192349&do=diff VPOP3 Webmail/admin service and/or Status service is not listening on correct IP addresses or ports Sometimes, VPOP3 can be configured so that the Webmail/admin service, or Status service is not listening on the correct IP addresses or ports. This can be hard to fix through normal methods, since you may not be able to get into the settings to change the settings. text/html 2026-03-23T10:18:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:create_an_ssl_certificate?rev=1774261123&do=diff How to create an SSL Certificate VPOP3 Enterprise supports SSL certificates for encrypted sessions. The basic mechanism to create an SSL certificate is that you have to generate a CSR (Certificate Signing Request) then send that to a CA (Certificate Authority) who will sign your certificate and give you the certificate back. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:delete_outqueue_messages_directly_from_the_database?rev=1542192349&do=diff Delete OutQueue messages directly from the database If there is an extremely large number of messages (eg hundreds of thousands) in the VPOP3 OutQueue, then it may take a very long time for VPOP3 v5 and later to start as it check the message database tables for consistency during initialisation. text/html 2025-10-06T15:21:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:error_messages?rev=1759764097&do=diff Error Messages This is the place to look if you are trying to trouble shoot a problem and you have received or have access to a specific error message or error code. If instead your problem is that something you think is set up correctly is not working then the best place to look would be the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:find_ip_address_of_vpop3?rev=1542192349&do=diff Find the IP address of the VPOP3 Computer To find the IP address of the VPOP3 computer, in Windows go to Control Panel -> Network and Sharing Center. Press the Local Area Connection link Then press 'Details'. Look for the 'IPv4 Address' setting. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:installing_postgresql_database_on_another_port?rev=1542192349&do=diff How to install PostgreSQL to use another port If the VPOP3 computer has a version of PostgreSQL older than version 8.3 installed for other software, and you can't/don't want to remove that you need to set up the PostgreSQL 8.3 or later for VPOP3 to use a different TCP/IP port number. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:iphone?rev=1542192349&do=diff Setting up an iPhone/iPad/iPod Touch To set up an iPhone to access VPOP3's mail, you first of all need to configure VPOP3 to allow access by remote users (unless you will only be using the iPhone in the office, connected via WiFi to the office LAN). Adding the mail account to your iPhone/iPad text/html 2026-04-06T17:59:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:mail_not_downloading_from_isp?rev=1775498387&do=diff Mail Not Downloading From ISP This normally happens because you have told VPOP3 to Leave Messages On Server (on the Mail Connectors -> Mail Collectors -> (name) -> POP3 General tab). If you do this, VPOP3 will leave messages on the ISP's mail server for several days, and remember that it has already downloaded them. Then, the next time it connects it will see that there are some messages waiting, but it may find that it has already downloaded them, so it won't download them again. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:some_client_pcs_cannot_access_vpop3?rev=1542192349&do=diff Some PCs cannot access VPOP3 when VPOP3 is connected to the Internet This error happens when you have multiple TCP/IP subnets on your network. The computers which are on different subnets from the VPOP3 computer will not be able to see VPOP3 whilst VPOP3 is connected to the Internet (through a dial-up connection). Whenever VPOP3 is offline, it will work correctly. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:troubleshooting_tips?rev=1542192349&do=diff Troubleshooting Tips Telnet One of the most basic, and useful, tools for troubleshooting email systems is a Telnet client. Installing Telnet Client Unfortunately, since Windows XP, Microsoft do not install the Telnet client into Windows by default, so you may need to install the Telnet client yourself. text/html 2020-09-03T15:07:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_8?rev=1599145654&do=diff Upgrading VPOP3 to version 8.x from v7 or earlier VPOP3 v8.x uses PostgreSQL 10 as its database engine, which is the latest supported 32 bit version of PostgreSQL. Later versions of PostgreSQL are 64-bit only, which means we cannot use them while continuing to support 32 bit versions of Windows. text/html 2026-03-18T20:49:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_9?rev=1773866994&do=diff Upgrading VPOP3 to version 9.x from v7 or v8 VPOP3 v9 and later requires a 64 bit version of Windows 8.1 or later VPOP3 v9.x uses PostgreSQL 18 as its database engine. This can only easily be upgraded from PostgreSQL 9.3 or later, which means it must be an upgrade of VPOP3 v7 or later. If you are using an earlier version of VPOP3, then upgrade it to v8.7 first, then upgrade to v9 or later text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_is_using_a_lot_of_disk_space?rev=1542192349&do=diff VPOP3 is using a lot of disk space If VPOP3 is using a lot of disk space, the problem is usually that there is lots of data there, so it has to use the disk space. Message Storage In VPOP3 version 5 and later, all users' messages are stored in the database, so they will occupy space in the VPOP3\pgsql\data folder. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:your_connection_has_been_blocked_temporarily_-_try_again_later?rev=1542192349&do=diff Error message: Your connection has been blocked temporarily - Try again later If you get an error message in your email client software saying Your connection has been blocked temporarily - Try again later or Server access temporarily blocked! Please try again later text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:alter_lan_forwarding_queued_messages_going_to_one_server_to_go_to_another?rev=1542192349&do=diff 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 text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:alter_lan_forwarding_rules_for_one_server_to_go_to_another?rev=1542192349&do=diff 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 text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:autoresponders_v3_v4?rev=1542192349&do=diff Autoresponders - v3 and v4 This section lets you define an autoresponder for a user. An autoresponder is a message which is sent back in response to a message which arrives in this user's mailbox. The Autoresponder Type can be set to None, Simple Autoresponder text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:batch_file_to_end_a_database_backup?rev=1542192349&do=diff Batch file to end a database backup VPOP3 runs pg_dump.exe to perform the regular database backups. Ending this process through Task Manager will not end the back-end database processes creating the backup data. This batch file will do it for you. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:copy_smtp_rules?rev=1542192349&do=diff Copy SMTP Rules - Database Query This is an advanced Database action. There is no simple query that will perform the required operation, so we have to create a custom PostgreSQL function to copy the data. At a command prompt in the VPOP3 directory run text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:delete_list_member_from_all_lists?rev=1542192349&do=diff Delete list member from all lists You can delete an email address from all VPOP3 distribution & mailing lists. Go to Settings → Database → Query Alternatively, at a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:export_lan_forwarding_rules?rev=1542192349&do=diff Database query to export LAN Forwarding rules At a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type \copy (select conditions, address, server, username, password, outaddress as rewriteaddress, matchcount as matches from rules.lanforwarding order by ruleorder) to 'c:/temp/x.csv' csv header; text/html 2019-07-08T08:19:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:find_biggest_messages?rev=1562573942&do=diff Find biggest messages To find the 10 biggest messages in your VPOP3 message store: Go to Settings → Database → Query Alternatively, at a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type SELECT username, folder, subject, fromaddr, PG_SIZE_PRETTY(size) FROM messages.messages INNER JOIN messages.folders f USING(folderid) INNER JOIN users.users u ON u.usernumber=f.userid ORDER BY size DESC LIMIT 10; text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:find_forwards_assistants_etc?rev=1542192349&do=diff Database query to find forwards/assistants etc in user settings Go to Settings -> Database -> Query Alternatively, at a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type select username,dataname,datavalue from users.usersettings inner join users.users using(usernumber) where datavalue ilike '%searchname%'; text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:find_message?rev=1542192349&do=diff Find a message If you know the subject of a message, you can search the entire message store for messages with this subject. Go to Settings → Database → Query Alternatively, at a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:get_all_lists_members?rev=1542192349&do=diff Database query to get all lists and members At a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type \copy (select l.name, address from users.listmembers m inner join users.lists l on m.list=l.id) to 'c:/temp/x.csv' csv header; text/html 2026-03-16T11:12:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:group_a_user_s_folders_into_letter_groups?rev=1773659562&do=diff Group a user's folders into letter groups This is useful in VPOP3 Enterprise if you have a large folder with many subfolders and want to group the subfolders into other subfolders based on their first letter For example, if you have * Customers text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:list_all_messages_in_lan_forwrding_queue?rev=1542192349&do=diff Database query to list ALL messages in the LAN forwarding queue The VPOP3 settings show the first 100 messages in the LAN forwarding queue. Usually this is sufficient as the LAN forwarding queue is usually nearly empty, but in case of a problem it may be much bigger. The database queries below may help in that situation. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:list_failed_message_send_summary?rev=1542192349&do=diff Database query to list failed message sends This will list failed outgoing messages from the last 3 days (with the default VPOP3 settings) At a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type select created,returnpath,subject,username || '@' || domain as recipient, latesterror from outqueue.outrecipients inner join outqueue.outmessages using(msgid) where failedtime is not null order by created desc; text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:list_messages_in_lan_forwrding_queue_waiting_to_go_to_a_specific_server?rev=1542192349&do=diff Database query to list messages in the LAN forwarding queue waiting to go to a specific server The VPOP3 settings show the first 100 messages in the LAN forwarding queue. Usually this is sufficient as the LAN forwarding queue is usually nearly empty, but in case of a problem it may be much bigger. The database queries below let you list just messages going to a specific server. text/html 2026-03-26T23:49:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:lua_scripting?rev=1774568941&do=diff Lua Scripting Lua is a simple scripting programming language often used for embedding in other applications. VPOP3 uses it to customise behaviour in places where most people will be happy with the default behaviour, but occasionally people will want to do something more complicated. Rather than having lots of extra options to complicate things for most users, we have opted to go for a more flexible scripting facility. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:misc_advanced?rev=1542192349&do=diff Misc -> Advanced Tab Settings -> Misc Settings -> Advanced You will normally not need to change any settings on this page unless VPOP3 technical support have suggested it. If you do make changes, and want to go back to the original settings, the Restore Defaults button will restore the settings to their defaults. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:misc_general?rev=1542192349&do=diff Misc -> General Tab VPOP3 Host Name The VPOP3 Host Name is used by VPOP3 when it is telling other mail software what it is called. For instance, when it connects to another SMTP server it will send the host name as the parameter for the HELO or EHLO command, and when an SMTP client connects to VPOP3, it announces its name in the welcome banner as required by the SMTP standard. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:msgaudit?rev=1542192349&do=diff msgaudit Database table This can (optionally) contain data showing how messages have been handled (eg deleted, moved, etc) * id - incrementing ID of msgaudit entry * datetime - the date & time the event occurred * component - which VPOP3 component performed the event text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:reset_message_folder_counts?rev=1542192349&do=diff Reset Message Folder Counts In extremely rare cases, the mail folder message counts in the database may get out of step with the actual stored messages. There are database triggers which will keep the counts in sync during normal operation, but if you have to manipulate the database directly (eg to recover from a corrupted database) it is possible that they will get out of step. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:sent_message_summary?rev=1542192349&do=diff Sent message summary This will display the number of messages sent and total size over the past month. (It counts each recipient as its own message). You must have Historical Logging enabled in VPOP3 (Settings -> Logging) At a command prompt in the VPOP3 directory run text/html 2026-02-19T17:56:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:temporary_files?rev=1771523787&do=diff Temporary Files This is for files in the VPOP3\_temp folder Most of the filename is the hexadecimal timestamp (in Windows 'FILETIME'/65536 form) with a 4 digit hex sequential number afterwards. The first letter or two (usually G-Z) can tell something about what caused the file. text/html 2026-03-16T11:02:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:useful_database_queries?rev=1773658952&do=diff Useful Database Queries Below are some database (SQL) queries which may be useful in some situations. You can run these from the 'psql' program at the command prompt. Some can also be run from the Settings -> Database -> Query page in the VPOP3 settings. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:view_password_change_history?rev=1542192349&do=diff Database query to view password change history At a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type select username,updateuser,updatetime from settingaudit inner join users.users on keyfield=usernumber::varchar where tablename='users.usersettings' and keyfield2='mainpassword' order by updatetime desc;