PSCS Wiki

Database query to view autoresponder condition enable history - created

paul (paul@undisclosed.example.com) — 2026-06-11T13:40:45+00:00

Database query to view autoresponder condition enable history At a command prompt in the VPOP3 directory run psql (The password is 'vpop3pass') Then, type select * from users.users; Take note of the 'usernumber' for the relevant user select * from users.autoresponderconditions where usernumber=;

Useful Database Queries - [Logs/etc]

paul (paul@undisclosed.example.com) — 2026-06-11T13:35:50+00:00

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.

Repairing corrupted database - [Finding the problem table/index]

paul (paul@undisclosed.example.com) — 2026-06-05T07:26:39+00:00

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).

User Manager Script - [ProcessCopySettings]

paul (paul@undisclosed.example.com) — 2026-05-29T13:47:01+00:00

User Manager Script If you want people to be able to log in using a different username than their VPOP3 username (eg if you want them to be able to log in using an email address), then you can use the UserManager Lua script The Lua script is managed through the Settings → Scripts page in VPOP3 v8.0 and later and is called 'UserManager.LUA'

End() - [LoadLimits()]

paul (paul@undisclosed.example.com) — 2026-05-29T10:39:35+00:00

End() End() This function is called by VPOP3 when the SMTP service session ends 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.

IMAP4 Server Scripting - [GetEncryption function]

paul (paul@undisclosed.example.com) — 2026-05-26T16:46:24+00:00

IMAP4 Server Scripting (Added in V6.12) DoCapability function When the IMAP4 CAPABILITY command is received, VPOP3 generates a capability string based on settings, then calls DoCapability(ipaddr, capabilities) * ipaddr = IP address of the client computer

Quarantine Report Mailer Scripting - [GetSortOrder]

paul (paul@undisclosed.example.com) — 2026-05-26T12:55:21+00:00

Quarantine Report Mailer Scripting (Added in v9.1) This script is called when VPOP3 is mailing out (or considering mailing out) spamfilter quarantine reports. It allows customisation of the emailed reports and whether they're generated AreMailsNeeded

Attachment Processing Script - [Attachment Processing Script]

paul (paul@undisclosed.example.com) — 2026-05-22T21:08:32+00:00

Attachment Processing Script (Added in v7.6) This is the AttachmentProcess.lua script which can be edited in Settings -> Scripts. This script has functions to allow message attachments to be altered: * NeedsRecode * NeedsRewrite * GetRename

Lua Scripting - [Lua Scripting]

paul (paul@undisclosed.example.com) — 2026-05-20T10:22:36+00:00

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.

Connection Hook Script - created

paul (paul@undisclosed.example.com) — 2026-05-14T16:46:31+00:00

Connection Hook Script Added in v9.1 Connection.lua function PostConnect(ConnectionID, ConnectionName, RAS) function PreDisconnect(ConnectionID, ConnectionName, RAS)

quarantineserveraddress.png - created

paul (paul@undisclosed.example.com) — 2017-02-10T09:34:06+00:00

accessrestrictions1.png - created

paul (paul@undisclosed.example.com) — 2017-01-19T14:01:13+00:00

smtpmxmultiple4.png

paul (paul@undisclosed.example.com) — 2017-01-19T13:42:34+00:00

smtpmxmultiple3.png - created

paul (paul@undisclosed.example.com) — 2017-01-19T10:56:21+00:00

smtpmxmultiple2.png - created

paul (paul@undisclosed.example.com) — 2017-01-19T10:50:21+00:00

smtpmxmultiple1.png - created

paul (paul@undisclosed.example.com) — 2017-01-19T10:49:01+00:00

endbackup.cmd - created

paul (paul@undisclosed.example.com) — 2016-12-22T13:14:53+00:00

2016-12-20_12-08-23.png - created

paul (paul@undisclosed.example.com) — 2016-12-20T12:11:26+00:00

newscript.png - created

paul (paul@undisclosed.example.com) — 2016-03-10T14:47:43+00:00

service_smtp_add.png - created

paul (paul@undisclosed.example.com) — 2016-03-01T09:55:01+00:00