https://wiki.pscs.co.uk/ 2026-05-13T06:22:24+00:00 https://wiki.pscs.co.uk/ https://wiki.pscs.co.uk/_media/wiki:dokuwiki.svg 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: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 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:sending_mail_from_different_email_addresses_or_domains?rev=1542192349&do=diff Sending mail from different email addresses or domains VPOP3 does not (by default) place any restrictions on which email addresses or domains you can send mail from. However, there may be external restrictions on which email addresses/domains you can send from. For instance, if you send mail through your ISP's mail server, they may only allow you to send mail from specific addresses, or the domain you send mail from may have a sender policy defined, such as 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-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:calendars?rev=1542192349&do=diff Calendars To use the calendar facility in VPOP3 you need a CalDAV aware client. We have tested it with the free Mozilla Sunbird & Lightning products as well as the emClient email client. These products need a URL to be able to access the CalDAV data store. Once you have the URL (see below), copy it into the text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:exchange_2007?rev=1542192349&do=diff Exchange 2007 You can link VPOP3 to Exchange Server, so that Exchange Server sends outgoing mail through VPOP3 and VPOP3 sends any incoming mail directly to Exchange Server. You should first of all set up VPOP3 to send and receive Internet email as normal. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:handling_mail_for_multiple_incoming_domains?rev=1542192349&do=diff Handling mail for multiple incoming domains VPOP3 can easily handle mail for several incoming domains. Exactly how you do it depends on the exact situation. All domains are 'aliases' If the domains are aliases of each other, for instance, you have 'mycompany.com' and 'mycompany.org', both of which are the same, so each address at mycompany.com also exists at mycompany.org, and the emails go to the same people regardless of which domain is used, then you simply configure the domains in the ma… 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:sender_policy_framework?rev=1542192349&do=diff Sender Policy Framework / SPF SPF is a system used to tell mail servers which IP addresses can send mail from which domains. It is designed to reduce 'spoofing' of email addresses. For instance, if you receive an email message from your bank, your mail software can check that it came from an IP address authorised to send mail from your bank, and treat the message with suspicion if it didn't come from an authorised IP address. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:552_5.2.3_message_too_large_-_contact_your_administrator?rev=1542192349&do=diff 552 5.2.3 Message too large - contact your administrator Or 552 5.2.3 Message exceeds fixed maximum message size If this error message is coming from VPOP3 when you are sending a message, it means that the message you are sending is prohibited by your VPOP3 settings. There are two places where the size limit could be set. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:10054?rev=1542192349&do=diff Socket Error 10054 - The virtual circuit was reset by the remote end Error 10054 means that the connection between VPOP3 and a remote computer (eg the ISP or another computer on your LAN) was disconnected by something outside of VPOP3. This is often caused by anti-virus software or Internet security/firewall on the VPOP3 machine but it could be any of a number of things. Any software or hardware that is sitting between VPOP3 and the ISP could be the root cause. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:allow_remote_access_to_vpop3_mailboxes?rev=1542192349&do=diff Allow Remote Access to VPOP3 Mailboxes Sometimes people want to be able to access their office VPOP3 mail server from a remote site or mobile phone etc. These instructions assume you have a permanent Internet connection (eg ADSL, Cable etc). If you don't have a permanent Internet connection, see text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:backscatter?rev=1542192349&do=diff Backscatter In email, “backscatter” is the term used if you send bounce messages back to spam messages. As most spam messages use forged email addresses, then the bounce messages will go to an innocent person, who will find them very annoying. Stopping VPOP3 from sending Backscatter text/html 2022-01-26T10:47:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:calendar_in_mozilla_lightning?rev=1643194055&do=diff Calendars in Mozilla Thunderbird The Thunderbird email client supports CalDAV calendars as standard. This can be used to access VPOP3's CalDAV server. To add a VPOP3 CalDAV calendar to Mozilla Thunderbirdis straightforward * Add the calendar to Thunderbird 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:database_disk_caching?rev=1542192349&do=diff Database & Disk Caching Disk Caching One key point is that, like all other high-end databases, PostgreSQL should not be run on a server with disk level write back caching. With write back caching, the disk will report data as being written to disk when it is still in the disk's cache memory. If the power then fails, this data is lost and can cause database corruption. As long as the database server really knows when the data has been written to disk, power failure will not cause database corru… text/html 2025-09-11T13:02:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_issues?rev=1757595765&do=diff Database Issues VPOP3 version 3 and later use the PostgreSQL] database server. This is an open source enterprise level database server. Several VPOP3 problems are due to problems with the database service. * Database & Disk Caching * Software conflicting with database * VPOP3DB Service not starting * Database Size Database corruption If VPOP3 won't start even though the process is running, then that is often because the PostgreSQL service is not running. If the PostgreSQL service won… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:database_size?rev=1542192349&do=diff VPOP3 Database Size The VPOP3 directory is stored in the VPOP3\pgsql\data folder and subfolders. If you are concerned about the size of the VPOP3 database, there are several factors which may make the database larger than you would expect: * The VPOP3 database contains a lot more information than just messages in mailboxes. This can include settings, outgoing messages, historical logging information, statistical information for the spamfilter, information about archived messages, etc. Also,… 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:full_text_search?rev=1542192349&do=diff Full Text Search In VPOP3 Enterprise v7.0 a facility for full-text-search on message content was added. Because the full-text-search indexes can be quite big, this facility is optional. For several reasons, the full-text-search is stored in a separate PostgreSQL database. This means that it is not backed up with your standard backups. After a restore, the full-text-search index can be rebuilt from the raw message content. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:internet_explorer_10_issues?rev=1542192349&do=diff Internet Explorer 10 Issues If you are using IE10 with VPOP3 prior to v6.2, then you may have issues accessing the VPOP3 Webmail and/or admin settings. These can usually be solved by telling IE10 to use 'compatibility mode'. Alternatively, using another web browsers such as text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:isp_needs_you_to_connect_on_port_587?rev=1542192349&do=diff ISP needs you to connect on port 587 Some ISPs will need you to send mail using port 587, instead of port 25. Port 587 is the 'SMTP Submission' port which is commonly used instead of, or as well as, the standard SMTP port 25 for when users are sending mail to a smart host/relay server. 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:many_instances_of_postgres.exe_running?rev=1542192349&do=diff Many instances of Postgres.exe are running If you are running VPOP3 3.0 or later, and look in the 'Processes' list in Windows TaskManager you will probably see multiple instances of postgres.exe running. This is perfectly normal, and does not indicate a problem. The PostgreSQL database works by having a separate instance of postgres.exe for each connection to the database (as well as a few extra for management and house keeping). This behaviour is documented on the 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:outlook_outlook_express_are_sending_mail_repeatedly?rev=1542192349&do=diff Outlook / Outlook Express is sending mail repeatedly If you are using Outlook or Outlook Express you may occasionally find that mail is being sent repeatedly. There are a couple of possible reasons for this which we know of Sending taking too long 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 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:seeing_where_a_message_came_from?rev=1542192349&do=diff Seeing where a message came from Sometimes you need to check to see where a message really came from. The 'From:' email address is easily forged, so that cannot be relied upon. The first thing you have to do is to get the full message headers. These may look daunting, but are very useful for problem diagnosis. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:smtp_rule_example_-_restrict_who_can_send_to_a_local_email_address?rev=1542192349&do=diff SMTP Rule Example - restrict who can send to a local email address If you have a local email address (a user, group or distribution list) and you want to restrict which email addresses can send messages to this address, you can use SMTP rules. There are a few ways you can configure the SMTP rules for this scenario. 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-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-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/how_to:vpop3_access_security?rev=1542192349&do=diff How To Setup VPOP3 Service Security VPOP3 can be configured to restrict access to its various services depending on the client computer's IP address. This is useful if you want to allow access from only certain IP addresses (eg within your LAN) and prevent access from other IP addresses (eg the Internet). 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.