https://wiki.pscs.co.uk/ 2026-05-13T05:04:51+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: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: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 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 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 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:what_is_postgresql?rev=1542192349&do=diff What is PostgreSQL? PostgreSQL is an SQL database engine. VPOP3 and PostgreSQL In VPOP3 2.x, VPOP3 uses a database engine called SQLite for its database needs. SQLite has limited locking facilities, so on busy systems we encountered problems where databases would need very frequent updates, and the lock limitations would cause the updates to take a long time. For this reason we added optional support for PostgreSQL to later versions of VPOP3 2.x. 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 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: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 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 2021-03-08T10:48:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:install_vpop3?rev=1615200520&do=diff How to Install VPOP3 Simply download VPOP3 from the website, and run the installation program and follow the prompts. Occasionally people may have problems with the PostgreSQL part of the installation. If that happens, please contact us either by email at support@pscs.co.uk or by phone to +44 (0)1484 855800, and we will do our best to help. 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: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 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: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: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/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 2019-11-08T15:37:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3_to_version_5?rev=1573227472&do=diff How To Upgrade VPOP3 to version 5 or later Upgrading VPOP3 is usually a straightforward process. Download VPOP3 from our web site and back up your current installation just in case something goes wrong. Then simply run the installer that you downloaded and install it over the top of your existing VPOP3. All your settings and mail will be preserved. 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-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: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 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_historical_logger_backlog?rev=1542192349&do=diff VPOP3 Historical Logger Backlog This problem is primarily related to VPOP3 versions 2.5 -> 2.6. Theoretically it could happen on later versions, but would be extremely unusual (see the note at the bottom if you are using version 3.0 or later) You get an error message with subject 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/fatal:connection_limit_exceeded_for_non-superusers?rev=1542192349&do=diff FATAL: connection limit exceeded for non-superusers This error means that there are too many connections to the PostgreSQL database server. VPOP3 having exclusive use of database If only VPOP3 is using the PostgreSQL database, then you can reduce the number of connections that VPOP3 will make to the database at once. This is set in the VPOP3 settings at 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 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_files_used_in_vpop3_2.x?rev=1542192349&do=diff Database files used in VPOP3 2.x VPOP3 2.x usually uses SQLite 2.8.3 as its database engine. This stores databases in discrete *.db files in the VPOP3\_database directory on the server PC. We do not recommend that you access these databases directly unless you know what you are doing, and we strongly discourage the alteration of data in the databases directly unless technical support request you to. 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: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 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: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/reference:database?rev=1542192349&do=diff Settings -> Database The Settings -> Database page lets you configure the use of the back-end database which VPOP3 uses for configuration data, message storage and other uses. Tabs * Backups * Query * Connection * Message Store * Restore text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:database_message_store?rev=1542192349&do=diff Database -> Message Store Tab This tab says how VPOP3 handles its message store Message Store The Delay while moving messages setting tells VPOP3 how quickly to import messages into the new database structure if it was upgraded from version 2.x or earlier. Usually this is OK to be left as it is, but if there is some special requirement to import the messages more quickly, you can decrease this number, but that will increase the load on the server. 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 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/reference:logging?rev=1542192349&do=diff Logging Activity Summary Reports You can tell VPOP3 to send you a daily summary report each day. To do this check the box to say Send daily summary logs to, and choose the appropriate user (or “Main Administrator” if you want the reports to be sent to the 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 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:exceptions?rev=1542192349&do=diff Exceptions An exception happens if VPOP3 encounters a problem it did not expect. In some cases it can recover automatically, but in other cases that isn't possible. Common causes VPOP3 2.6 and earlier In VPOP3 2.6 and earlier it was quite common for there to be database corruption problems with the SQLite database which was used in those versions. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:pop3_webmail_imap4_can_t_see_messages_but_admin_can?rev=1542192349&do=diff POP3/Webmail/IMAP4 can't see a user's messages, but the administrator can Version 2.x only. This problem does not occur with version 3 or later. This problem can happen if the user's message index database has become damaged. The POP3, Webmail & IMAP4 services get the message summary data from the database, whereas the administrator console gets the message information directly from the message files on the disk, so if the database is corrupted, the administrator console can still see the mess… 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/reference:database_schema_used_in_vpop3_5.x?rev=1542192349&do=diff Database schema used in VPOP3 5.x Note that all information in this section is subject to change. We do not guarantee that the database schema will remain constant, even between minor upgrade versions, so use this information at your own risk. Do not alter the database schema used by VPOP3 (including indexes, triggers & functions) or your whole VPOP3 data store may collapse. 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/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:installation_checklist?rev=1542192349&do=diff Installation checklist This list contains some things you may want to check before or after installing VPOP3 to make sure it's not going to encounter any common issues. Before installation * Make sure that VPOP3 is not installed on a RAID 5 or RAID 6 array. 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:performance_requirements?rev=1542192349&do=diff Performance Requirements The performance requirements for VPOP3 depends on many factors, so we can't give specific details for any scenario. How to detect limiting factors * Use the Windows Performance Monitor (perfmon.msc) * Add counters for: text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrading_database_software?rev=1542192349&do=diff Upgrading PostgreSQL Database Software To upgrade the PostgreSQL database software used by VPOP3 * stop VPOP3 * backup the database (<http://wiki.pscs.co.uk/how_to;backup_vpop3#manual_database_backup1>) * uninstall PostgreSQL (from within Windows) if necessary * rename the VPOP3\pgsql folder to something else 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 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 2026-03-18T20:20:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:how_to?rev=1773865250&do=diff "How To" Articles Installation/Upgrades * Download VPOP3 * Install VPOP3 * Move VPOP3 * Upgrade VPOP3 * Upgrade VPOP3 to version 5.x or 6.x from version 4 or earlier * Upgrade VPOP3 to version 7.x from version 6 or earlier * Upgrade VPOP3 to version 8.x from version 7 or earlier * Upgrade VPOP3 to version 9 or later from version 7 or 8 * Performance Requirements * Installation Checklist General Configuration * Initial Configuration * Users * Add an Alias * Create… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:install_to_external_pgsql?rev=1542192349&do=diff Install VPOP3 using external PostgreSQL database (VPOP3 version 5 or later) In some cases, advanced users may wish to have VPOP3 use an external PostgreSQL database instead of the one installed with VPOP3. This is possible by telling VPOP3 the connection details during installation. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:installation_errors?rev=1542192349&do=diff Installation Errors This page lists some errors which may occur during installation and the solution. In general, do NOT 'ignore' any errors unless we tell you to. If you have to retry an installation, when it is an upgrade from versions 1 - 4 going to version 5 or later, then make sure you have told the installer to install the database. Sometimes a partial installation will make the installer think that the database is already installed. 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 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/adminapi:smtpclientblocks?rev=1542192349&do=diff SMTPClientBlocks Replacement Use: ~smtpclientblocks~ <format string> ~end~ The format string can have the replacements * address - IP address (returned as host address or CIDR address as appropriate) * date - the date/time the address was added to the database in YYYYMMDDHHMMSS format text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:remove_messages_from_the_outbound_queue?rev=1542192349&do=diff How to remove messages from the outbound queue To delete messages from the VPOP3 'OutQueue': * log into the VPOP3 settings * go to the Users page * click on the OutQueue entry in the accounts list. This will show you a list of all the messages waiting to be sent by VPOP3 text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:upgrade_vpop3?rev=1542192349&do=diff How To Upgrade VPOP3 Note: if you are upgrading to VPOP3 version 5 or later from version 4 or earlier, please see How To Upgrade VPOP3 to version 5 Upgrading VPOP3 is a straightforward process. Download VPOP3 from our web site and ideally back up your current installation just in case something goes wrong. Then simply run the installer that you downloaded and install it over the top of your existing VPOP3. All your settings and mail will be preserved. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_2.x_crashes_when_user_tries_to_download_mail?rev=1542192349&do=diff VPOP3 2.x crashes when user tries to download mail If VPOP3 2.x crashes when a user tries to download mail, there are a few possible causes we know of: * A virus scanner or Internet security software is interfering with the connection between VPOP3 and the email client and is either terminating VPOP3 deliberately, or is blocking VPOP3 causing another part of it to crash 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:calendar?rev=1542192349&do=diff Calendar database schema The Calendar database schema contains the data for the Calendar/CalDAV component of VPOP3. Note that the actual calendar data is stored in iCalendar/.ics file format. The database just stores information for helping with selective retrieval. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:calendar_events?rev=1542192349&do=diff Calendar.Events table The Calendar.Events table contains a record of all the events in calendars managed by VPOP3. An 'event' is an iCalendar event. Note that if an event is a recurring series, there will only be one 'event' in the database, not one event per instance of the recurrence. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb?rev=1542192349&do=diff LogDB database schema The LogDB database schema contains historical logging information for reports etc. Entries are added to this by several components of VPOP3, and the 'reporting' section uses the data here. The LogDB database is only populated if the ' text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dbqueryone?rev=1542192349&do=diff Spam Filter Rules: DBQueryOne Statement DBQueryOne Version 6.16+ Purpose Queries the spam filter database for a single record/aggregate The DBQueryOne statement performs a query on the spam filter database and returns a single value which is either the value of a record or an aggregate of several records. 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/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: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: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:software_conflicting_with_database?rev=1542192349&do=diff Software conflicting with database service We strongly recommend that virus scanners exclude the VPOP3\pgsql\data folder and all subfolders. If a virus scanner decides to quarantine a file from within this folder structure, that can cause VPOP3 not to run, and could lead to data loss or corruption. 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 2026-01-05T09:31:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_re-downloading_old_messages_from_isp_pop3_server?rev=1767605507&do=diff VPOP3 re-downloading old messages from the ISP POP3 server If you tell VPOP3's POP3 mail collector to leave messages on the ISP's server for a few days, you may find that sometimes VPOP3 will redownload all the messages from the ISP mailbox again. text/html 2023-08-02T08:22:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:access_restrictions_internal_format?rev=1690964557&do=diff Access Restrictions Internal Format VPOP3 internally stores service IP Access Restrictions in its settings database using the following format to encode the multiple entries These are stored in the settings database as *ALLOWED*.DAT (using VPOP3SETTINGS GET *ALLOWED*.DAT will list them) 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:db_users?rev=1542192349&do=diff Users database schema The Users database schema contains details of users and their settings etc. Tables * users * usersettings * useraddresses * autoresponders * autorespondercopyto * autoresponderlog * autoresponderconditions * autoresponderattachments * autoresponderto * groups * groupdata * lists * listsubscriptions * listmoderation * listmembers * listdata * listarchive 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 2026-02-19T17:17:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:internals?rev=1771521446&do=diff VPOP3 Internals This section describes some of the internal workings/files of VPOP3. This is not, nor is it intended to be, a complete description, but merely contains information that may be useful to the average, interested (and moderately technical), user. The information here is not guaranteed not to change between versions of VPOP3. 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_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 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: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:smtpstats?rev=1542192349&do=diff SMTPStats database schema The SMTPStats database schema contains details of SMTP usage. Tables * smtpclientfailures * smtpusage text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spam_filter_general?rev=1542192349&do=diff Spamfilter -> General This page has 6 tabs to allow you to configure the VPOP3 spamfilter * General tab * Quarantine Settings tab * Bayesian Database tab * Script Configuration tab * Rule Weights tab * Advanced tab text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_addbayesham?rev=1542192349&do=diff Spam Filter Rules: AddBayesHam Statement AddBayesHam Version 2.1.7+ Purpose Adds the current message to the 'not-spam' (or 'ham') Bayesian database Example Add the message to the 'not-spam' database if score is less than 100 If ${Score} < 100 AddBayesHam EndIf text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_addbayesspam?rev=1542192349&do=diff Spam Filter Rules: AddBayesSpam Statement AddBayesSpam Version 2.1.7+ Purpose Adds the current message to the 'spam' Bayesian database Example Add the message to the 'spam' database if score is 100 or more If ${Score} >= 100 AddBayesSpam EndIf text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_removebayesham?rev=1542192349&do=diff Spam Filter Rules: RemoveBayesHam Statement RemoveBayesHam Version 2.1.7+ Purpose Removes the current message from the 'not-spam' (or 'ham') Bayesian database Example Remove the message from the 'not-spam' database if score is 100 or more If ${Score} >= 100 RemoveBayesHam EndIf text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_removebayesspam?rev=1542192349&do=diff Spam Filter Rules: RemoveBayesSpam Statement RemoveBayesSpam Version 2.1.7+ Purpose Removes the current message from the 'spam' Bayesian database Example Remove the message from the 'spam' database if score is less than 100 If ${Score} < 100 RemoveBayesSpam EndIf text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:user_advanced?rev=1542192349&do=diff User Advanced settings The Edit User → Advanced tab contains some 'advanced' settings for a VPOP3 user. Message Recycle Bin In VPOP3 Enterprise (v5 and later) the Message Recycle Bin will keep messages in the message store for a short time after the user has deleted the messages. This is to allow easier recovery from the inevitable case where a user has deleted messages by mistake, and wants them back. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:smtpclientallowadd?rev=1542192349&do=diff SMTPClientAllowAdd Action (VPOP3 Enterprise Only) This adds an entry to the SMTP Client Allow list. The data specified is: * IPAddress - the IP address to add. This can be an individual IP address or a CIDR address (IPv4 and IPv6 addresses are allowed) text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:smtpclientallowremove?rev=1542192349&do=diff SMTPClientAllowRemove Action (VPOP3 Enterprise Only) This removes an entry to the SMTP Client Allow list. The data specified is: * IPAddress - the IP address to add. This can be an individual IP address or a CIDR address (IPv4 and IPv6 addresses are allowed) text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:smtpclientallows?rev=1542192349&do=diff SMTPClientAllows Replacement Use: ~smtpclientallows~ <format string> ~end~ The format string can have the replacements * address - IP address (returned as host address or CIDR address as appropriate) * date - the date/time the address was added to the database in YYYYMMDDHHMMSS format text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:smtpclientblockadd?rev=1542192349&do=diff SMTPClientBlockAdd Action (VPOP3 Enterprise Only) This adds an entry to the SMTP Client Block list. The data specified is: * IPAddress - the IP address to add. This can be an individual IP address or a CIDR address (IPv4 and IPv6 addresses are allowed) text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:smtpclientblockremove?rev=1542192349&do=diff SMTPClientBlockRemove Action (VPOP3 Enterprise Only) This removes an entry to the SMTP Client Block list. The data specified is: * IPAddress - the IP address to add. This can be an individual IP address or a CIDR address (IPv4 and IPv6 addresses are allowed) text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/adminapi:smtpidsevents?rev=1542192349&do=diff SMTPIDSEvents Replacement Use: ~smtpidsevents~ This returns the latest entries from the SMTP client logging database. It will return 100 entries unless the count parameter is specified in the URL, in which case that will specify the maximum number of entries to return. 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/faq:what_is_the_difference_between_vpop3_standard_and_vpop3_enterprise?rev=1542192349&do=diff What is the difference between VPOP3 Basic and VPOP3 Enterprise? VPOP3 Enterprise includes all the features of VPOP3 Basic, plus: * IMAP4 mail support as well as POP3, SMTP and Webmail * Support for database (ODBC) links for the Global Address Book and Mailing Lists. * Shared calendars & webmail address books text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:450_4.3.2_content_filter_timeout?rev=1542192349&do=diff 450 4.3.2 Content Filter Timeout If you get this error appearing when messages are sent to VPOP3, either in a bounce message, or in the VPOP3 status monitor, it means that the VPOP3 computer filter is taking more than the allowed amount of time (usually 60 seconds). 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 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:c_error_popup?rev=1542192349&do=diff C++ Error Popup If VPOP3 crashes with a C++ error popup window, that means that an 'exception' has been thrown - something unusual has happened, and VPOP3 doesn't know how to recover automatically. Often these are due to database errors. There are two places you can look for the cause of the error: 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:localhost_missing_from_vista_hosts_file?rev=1542192349&do=diff Localhost missing from Vista HOSTS file The PostgreSQL database server needs to be able to resolve the 'localhost' name for it to run. On some Windows Vista installations, the HOSTS file seems to be missing the localhost entry (usually it is there, but it seems to be a common problem for it not to be there). text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:manually_installing_the_postgresql_database_server?rev=1542192349&do=diff Manually installing the PostgreSQL Database Server <flashplayer width=640 height=500>file=<http://wiki.pscs.co.uk/Media/installpgsql91.mp4&image=http://wiki.pscs.co.uk/Media/installpgsql91.png></flashplayer> text/html 2019-11-12T16:09:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:move_vpop3?rev=1573574974&do=diff How To: Move VPOP3 You can usually move VPOP3 without having to uninstall and reinstall. It is best to move VPOP3 rather than reinstalling from scratch on the new PC or in the new location, because that way you can keep all your existing settings, rather than having to try to recreate them. 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:router_problem?rev=1542192349&do=diff Router Problem error messages If you get an error message to the VPOP3 administrator with subject Router Problem and text Local Distribute to <username> Failed Error: Database Error "ERROR: could not open file "base/<number>/<number>": Permission denied" text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:timeout_while_vpop3db_is_starting?rev=1542192349&do=diff Timeout while VPOP3DB is starting (Note that VPOP3 v6.11 and later, the service startup system has changed so it should not suffer from this problem) When VPOP3DB starts up, the service control manager component waits a set time for a response from the database server before it knows the service has started. If the PC is going slow (eg after a Windows update or if the PC is just slow) then this wait may not be long enough. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:tutorials?rev=1542192349&do=diff Video Tutorials * Download & Install VPOP3 * Manually installing the PostgreSQL database server * Move the VPOP3 message store to a new folder/drive - V5 text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:undelete?rev=1542192349&do=diff Undelete Messages in VPOP3 Enterprise v5 or later If a user accidentally deletes messages or a message folder, you can easily undelete this within a few days. The amount of time that messages are stored in the VPOP3 'recycle bin' is set in Settings text/html 2025-10-06T15:24:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_antivirus_update_error_-_error_11?rev=1759764259&do=diff VPOP3 Antivirus Update Error - Error 11 If you receive an “Error 11” when VPOP3 Antivirus is attempting to upgrade, then this means that it cannot download the antivirus updates from the Internet * Make sure you are using the latest version of the VPOP3AV plugin. You can check the version in the Settings text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/how_to:vpop3_antivirus_update_error_-_error_55?rev=1542192349&do=diff VPOP3 Antivirus Update Error - Error 55 If you receive an “Error 55” when VPOP3 Antivirus is attempting to upgrade, then this means that the virus definition database is not readable. If you have VPOP3 Antivirus version 1.0.6 or earlier (check on Settings 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: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/reference:calendar_calendars?rev=1542192349&do=diff Calendar.Calendars table The Calendar.Calendars table contains a list of all 'calendars' created in VPOP3. Each user account has at least one calendar Columns * calid - this is a integer sequential value which identifies the calendar uniquely in the database * 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 2023-11-20T10:18:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:error_handling_script?rev=1700475481&do=diff Error Handling Scripting For most error messages that VPOP3 generates, it allows control of error messages, eg to limit the frequency of error messages if they would be generated repeatedly. These limits are set in Settings -> Admin Settings -> Message Control. However, if you want more granular control, you can use Lua scripting for more fine-grained control 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_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 2023-08-02T08:10:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:internal_data_formats?rev=1690963850&do=diff Internal Data Formats VPOP3 stores some data in specific formats internally, eg to encode some settings in the settings database. This page describes some of those. * Access Restrictions Internal Format text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:ldap_schema_in_vpop3_4.x?rev=1542192349&do=diff LDAP Schema in VPOP3 4.x Hierarchical Structure LDAP data is stored as a hierarchical database with the 'DN' (Distinguished Name) of the object as the key. The DN is made up of the various 'Relative DNs' used to navigate to the desired object, placed in reverse order, separated by commas. 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:lists?rev=1542192349&do=diff Lists The Lists section in VPOP3 lets you view and manage the various types of 'List' which VPOP3 supports * Distribution Lists * Mailing Lists * Forwardings * ODBC Mailing Lists * Groups Using a list A list will contain zero or more 'members' (usually email addresses) which can be messaged all at once. To send a message to all the members of a list, you will usually send an email to the listname at a valid domain. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_attachments?rev=1542192349&do=diff LogDB.Attachments table The LogDB.Attachments table contains a record of the attachments for messages logged by VPOP3. A message may have zero or more attachments Columns * attachid - this is a bigint sequential value which identifies the attachment uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_messages?rev=1542192349&do=diff LogDB.Messages table The LogDB.Messages table contains a record of all messages logged by VPOP3. A message is logged when a message is sent/received/etc. Columns * msgid - this is a bigint sequential value which identifies the message uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_recipients?rev=1542192349&do=diff LogDB.Recipients table The LogDB.Recipients table contains a record of the recipients for messages logged by VPOP3. A message may have one or more recipients Columns * rcptid - this is a bigint sequential value which identifies the recipient uniquely in the database text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_sessions?rev=1542192349&do=diff LogDB.Sessions table The LogDB.Sessions table contains a record of all 'sessions' logged by VPOP3. A session is something like a POP3 server session as an email client downloads messages, or an SMTP client session as VPOP3 sends a message out to the Internet, and so on. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:logdb_spamrules?rev=1542192349&do=diff LogDB.SpamRules table The LogDB.SpamRules table contains a record of the spamfilter rules which matched for messages logged by VPOP3. A message may have zero or more spamrules entries Columns * spamruleid - this is a bigint sequential value which identifies the spam rule entry uniquely in the database text/html 2023-08-15T07:33:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:loginaudit?rev=1692084838&do=diff loginaudit Database table This contains data showing login attempts within the most recent 30 days * id - incrementing ID of loginaudit entry * ipaddress - IP address the login attempt came from * datetime - the date & time the event occurred 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 2024-03-21T10:49:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:outgoing_message_script?rev=1711018194&do=diff Outgoing Message Scripting Every time VPOP3 adds a message to the Outgoing mail queue, it runs a script called outmessage.lua. Scripts are stored as files in the VPOP3 directory in VPOP3 v6.6 and earlier, or managed through the Settings -> Scripts page in VPOP3 v6.7 and later. text/html 2021-11-29T12:06:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:password_lengths?rev=1638187584&do=diff Password Lengths If you want to do an audit of users' password lengths, then go to Settings -> Database -> Queries and run this query: SELECT username,LENGTH(DECODE(SUBSTRING(datavalue FROM 2),'base64')) FROM users.usersettings INNER JOIN users.users USING(usernumber) WHERE dataname='mainpassword'; text/html 2023-08-15T07:28:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:public?rev=1692084502&do=diff Public database Schema * loginaudit * msgaudit text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:reference?rev=1542192349&do=diff VPOP3 Reference This is a reference guide for VPOP3 version 3 or later's settings. For details on how to do things, rather than what a particular button does, see the how to section. Also see the online manual: * Users * Lists * Mappings * Mail Connectors * Services * Settings * Status * Reports * About * Status Monitor * text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:settings?rev=1542192349&do=diff Settings * Admin Settings * Anti-virus * Attachment Processing * Autoresponder Settings * Database * Diagnostics * FaxServer * Global Address Book * Global Signature * Groups * Header Processing * Receipts/Urgent Messages * Global Header Modifiers * Legacy Extensions * Listserver Settings * Local Mail * General * Domain Mappings * LAN Forwarding * Configuration * Queue Status * Logging * Message Archive * Message Monitoring * Misc Se… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:smtp_reputation_stats?rev=1542192349&do=diff SMTP Reputation Stats (Added in v6.20) If you receive email by direct incoming SMTP (not via an ISP or filtering service) then you can tell VPOP3 to report sender reputation statistics back to VPOP3. This is enabled/disabled in the Settings -> Misc Settings page. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamfilter_rule_weights?rev=1542192349&do=diff Spamfilter Rule Weights To edit the spamfilter rule weights, go to Settings -> Spamfilter -> General -> Rule Weights The VPOP3 spamfilter contains several rules which test for certain things, eg 'adult words', or entries in real-time blacklist databases, or whitelisted email addresses etc. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_assignments?rev=1542192349&do=diff Spam Filter Rules: Assignments You can assign values to variables using the syntax ${variable} = value | ${variable} Assignment operators The spam filter rules support the following assignment operators: = Specify the value of the variable to equal the value after the assignment operator text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_db_comparator?rev=1542192349&do=diff Spamfilter database comparators Several Spamfilter DB statements allow comparators which are listed below If the value specified in the statement is numeric: * = or == compare numeric values for equality * <> or != compare numeric values for inequality text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dbdeletetime?rev=1542192349&do=diff Spam Filter Rules: DBDeleteTime Statement DBDeleteTime Version 6.16+ Purpose Deletes records from the spam filter database based on their last update time The DBDeleteTime statement requires a component name, comparator and time value, in the format text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dbinsert?rev=1542192349&do=diff Spam Filter Rules: DBInsert Statement DBInsert Version 6.16+ Purpose Inserts a record into the spam filter database The DBInsert statement requires a type, component name, key and value, in the format DBInsert <type> <component name> <key> <value> text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dbupdate?rev=1542192349&do=diff Spam Filter Rules: DBUpdate Statement DBUpdate Version 6.16+ Purpose Updates a record in the spam filter database The DBUpdate statement requires a component name, key, operator and value, in the format DBUpdate <component name> <key> <operator> <value> text/html 2023-08-14T16:01:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_variables?rev=1692028861&do=diff Spam Filter Rules: Variables The VPOP3 spam filter script language supports simple variables. In most places these are specified as ${<variable name>}, but in some places they are just specified as <variable name> - for instance where a statement always puts its result into a variable. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:useful_other_things?rev=1542192349&do=diff Useful other things Scripts/batch files/etc which may be useful * batch file to end a database backup text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:user_prune_rules?rev=1542192349&do=diff Prune Rules The Edit User -> Prune Rules tab can be used to create/edit rules which cause messages to be automatically deleted according to specified criteria. To add or edit a “prune rule”, press the Add Rule button. This will add a new rule to the table, with a set of default settings. Don't worry, this rule doesn't take effect until you press the Submit button. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:users_users?rev=1542192349&do=diff Users.Users table The Users.Users table contains a record of all users created in VPOP3. Columns * usernumber - this is a number which is used to refer to the user in other database tables * username - this is the text name of the user username is case insensitive and is indexed in lower case, so to take advantage of the index use something like 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; text/html 2018-12-11T17:06:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:vpop3.getsetting?rev=1544547961&do=diff VPOP3.GetSetting The Lua function 'VPOP3.GetSetting' retrieves a general setting from VPOP3 It takes one parameter: * The name of the setting. This can either by the 'Name' field of the 'Settings.Settings' database table or the internal setting name text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:vpop3.postgresquery?rev=1542192349&do=diff VPOP3.PostgresQuery The Lua function 'VPOP3.PostgresQuery' performs a query on the PostgreSQL database and returns the results in a table It takes a single parameter which is the SQL query to perform (Note that any relations used in the query must have the schema specified). text/html 2021-03-09T16:37:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:vpop3.setsetting?rev=1615307830&do=diff VPOP3.SetSetting The Lua function 'VPOP3.SetSetting' sets a general setting forVPOP3 It takes two parameters: * The name of the setting. This can either by the 'Name' field of the 'Settings.Settings' database table or the internal setting name * The data to set (must be a string) text/html 2022-10-01T11:32:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/wiki:dokuwiki?rev=1664623959&do=diff DokuWiki wiki:dokuwiki DokuWiki is a simple to use and highly versatile Open Source wiki software that doesn't require a database. It is loved by users for its clean and readable syntax. The ease of maintenance, backup and integration makes it an administrator's favorite. Built in