https://wiki.pscs.co.uk/ 2026-05-13T05:41:45+00:00 https://wiki.pscs.co.uk/ https://wiki.pscs.co.uk/_media/wiki:dokuwiki.svg 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 text/html 2026-03-16T16:00:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/wiki:syntax?rev=1773676810&do=diff Formatting Syntax DokuWiki supports some simple markup language, which tries to make the datafiles to be as readable as possible. This page contains all possible syntax you may use when editing the pages. Simply have a look at the source of this page by pressing 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/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/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 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 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:users_autoresponderconditions?rev=1542192349&do=diff Users.AutoresponderConditions table The Users.AutoresponderConditions table contains a record of all autoresponder trigger conditions created in VPOP3. These tell VPOP3 when a particular autoresponder should fire for a particular user. Each autoresponder can have zero or more conditions. An autoresponder with zero conditions will never fire but can be reactivated later by adding a new condition. 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/reference:smtp_advanced?rev=1542192349&do=diff SMTP Service -> Advanced Tab Services -> SMTP Server -> Advanced Tab Refuse SMTP Connections from This setting should be rarely needed, and should be normally left blank. It is here for historic purposes. If you put some text in this box, then VPOP3 will refuse any SMTP connections from clients whose 'HELO'/'EHLO' command data contains the text specified here as a substring. Eg, if this setting is set to '.myisp.com', then VPOP3 would refuse SMTP connections from any client which sends the c… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_definerule?rev=1542192349&do=diff Spam Filter Rules: DefineRule Statement DefineRule Version 2.1.9+ Purpose Defines a rule name, default weighting and description. See Rule names and weights The DefineRule statement requires a name, default weight and description, in the format DefineRule "<name>" <default weights> "<description>" text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:vpop3av?rev=1542192349&do=diff What is the VPOP3 Antivirus solution? “VPOP3 Antivirus” is a new product to replace the avast! for VPOP3 product which will no longer be supported after the end of 2012. VPOP3 Antivirus uses the popular 'ClamAV' virus scanner to scan incoming and outgoing messages for viruses. 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: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/mailapi:autoresponderconditionlist?rev=1542192349&do=diff AutoresponderConditionList Replacement Use: ~autoresponderconditionlist~ Required parameter: responderid - the ID of the autoresponder This returns a JSON structure containing an array of the rules associated with the specified autoresponder. The return structure is an array of objects containing: 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: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 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 2020-10-23T16:07:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:spamrules_statement_dnsbl?rev=1603469269&do=diff Spam Filter Rules: DNSBL Statement DNSBL Version 2.1.7+ Purpose Allows the script to perform a DNS blacklist lookup, returning the result into a specified variable The DNSBL statement requires a hostname, DNSBL zone and variable name, 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_startdnsbl?rev=1542192349&do=diff Spam Filter Rules: StartDNSBL Statement StartDNSBL Version 2.2.1+ Purpose Begins an asynchronous DNS blacklist lookup in advance of the result being required in a subsequent DNSBL statement The StartDNSBL statement requires a hostname and DNSBL zone, 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_startsurbl?rev=1542192349&do=diff Spam Filter Rules: StartSURBL Statement StartSURBL Version 2.2.1+ Purpose Begins an asynchronous SURBL lookup in advance of the result being required in a subsequent SURBL statement The StartSURBL statement requires a hostname and SURBL zone, in the format text/html 2022-10-01T11:32:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/wiki:welcome?rev=1664623959&do=diff Welcome to your new DokuWiki Congratulations, your wiki is now up and running. Here are a few more tips to get you started. Enjoy your work with DokuWiki, -- the developers Create your first pages Your wiki needs to have a start page. As long as it doesn't exist, this link will be red: text/html 2019-09-19T13:41:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/faq:dnssec?rev=1568900489&do=diff DNSSEC DNSSEC (Domain Name System Security Extensions) is used to secure DNS records and prevent them from man-in-the-middle attacks and spoofing. DNSSEC has been around for 10 years, but it has generally not been widely adopted for various reasons, but it is 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 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: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. 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: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/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 2023-11-12T09:51:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:dmarc_reporter_script?rev=1699782700&do=diff DMARC Reporter Script (from VPOP3 v8.6 onwards) This script lets you customise how VPOP3 sends DMARC reports to the sending domain. This can be useful in case the sending domain's DMARC configuration is incorrect as that can cause errors sending the reports or cause messages to be 'stuck' in VPOP3's Outqueue. These problems won't cause any lasting damage, but may be inconvenient or annoying, so you can alter the behaviour using Lua scripting 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 2025-08-14T09:24:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:lua_smtp_relay_control?rev=1755163495&do=diff Lua SMTP Relay Control Every time VPOP3 is going to send messages via SMTP Relay, it runs a script called relayout.lua in the VPOP3 directory. Global Variables This script may have global variables, depending on your version of VPOP3. In VPOP3 3.0.0L and later, there are two read-only global variables set at the start of the script: text/html 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 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:misc_advanced?rev=1542192349&do=diff Misc -> Advanced Tab Settings -> Misc Settings -> Advanced You will normally not need to change any settings on this page unless VPOP3 technical support have suggested it. If you do make changes, and want to go back to the original settings, the Restore Defaults button will restore the settings to their defaults. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:pop3_collection?rev=1542192349&do=diff POP3 Mail Collection POP3 Mail Collection is when VPOP3 will collect mail from an external POP3 mailbox - for instance, from an Internet Provider. POP3 General This page tells VPOP3 how to collect mail. * POP3 Server Address - this is the name (or IP address) of the POP3 server from which you want VPOP3 to collect mail text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:sender_direct_settings?rev=1542192349&do=diff SMTP Direct Sender Settings Mail Connectors -> Mail Senders -> SMTP Direct Sender -> Settings tab The SMTP Direct Settings tab lets you set how VPOP3 will send mail using SMTP Direct DNS Servers to Use This setting tells VPOP3 the IP addresses of the DNS servers it should use to find the recipients' mail servers. Separate multiple addresses with commas. text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:smtp_direct?rev=1542192349&do=diff Mail Connectors -> Mail Senders -> SMTP Direct VPOP3 can be configured to send mail directly to the recipient's mail server (or the recipient's mail service provider). Usually this is only used if you have a high-end business class Internet connection - such as a leased line, or your mail server is co-located in a data centre. Attempts to use SMTP Direct sending on a dial-up/ADSL/Cable/FTTC/etc connection may be problematic since the receiving mail server may think you a home user who has been … text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:smtp_ids_ips?rev=1542192349&do=diff SMTP Server -> IDS/IPS The IDS/IPS tab lets you set logging and automatic blocking parameters for the IDS (Intrusion Detection System) and IPS (Intrusion Prevention System) component of the SMTP server. SMTP servers are regularly attacked, both by incoming mail attacks (spam/viruses etc) and relay attacks (by spammers and other malware distributors trying to send mail through them). Because of this, there is a system in VPOP3 which will track attack attempts on the SMTP service and can automat… text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:smtp_vrfy_expn?rev=1542192349&do=diff SMTP Service -> VRFY/EXPN Tab Services -> SMTP Server -> VRFY/EXPN Tab VRFY and EXPN are SMTP commands which allow another computer to verify email addresses without sending mail to them. See RFC 5321 for technical details. Usually, these commands should be disabled for security purposes, but some other software may be able to use these commands for various reasons. In this case, you can enable them, but restrict access to the IP address(es) you trust. 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_surbl?rev=1542192349&do=diff Spam Filter Rules: SURBL Statement SURBL Version 2.1.7+ Purpose Allows a SURBL lookup on the specified hostname or IP address in the specified SURBL zone, and returns the result into the specified variable The SURBL statement requires a hostname, SURBL zone and variable name, in the format text/html 2023-03-27T10:32:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:user_routing_script?rev=1679913138&do=diff User Routing Script If there is a <username>/user_redirect.lua script, this Lua script can override VPOP3's message routing options. You can edit this either in the Settings -> Scripts page in the settings, or via the 'Routing' tab in the user's settings in the VPOP3 administration console. This script affects how VPOP3 will handle how messages text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:vpop3.getfolders?rev=1542192349&do=diff VPOP3.GetFolders Lua function The Lua management function 'VPOP3.GetFolders' retrieves a table containing all the mail folders for a specified user. VPOP3.GetFolders(username); It returns a table where the key is the folder name (in IMAP4 UTF-7 encoded format - see text/html 2018-11-14T10:45:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.pscs.co.uk/reference:vpop3.renamefolder?rev=1542192349&do=diff VPOP3.RenameFolder Lua function The Lua management function 'VPOP3.RenameFolder' renames a folder for the specified user. VPOP3.RenameFolder(username, folder, newname); * username is the username from VPOP3.GetUsers * folder is the folder from VPOP3.GetFolders * newname is the new name for the folder.