Field Name

Description

Version Added

AdminEmail

The email address of the administrator responsible for this server. (varchar(50), NULL)

AllowCsvUpdateNonNormal

Specifies whether ListManager will allow CSV imports to update non- normal members (e.g., held or unsubscribed) to be normal. (bool)

AllowNntp

Specifies whether ListManager will allow connections via NNTP. (bool)

BanCacheTimeoutMinutes

How many minutes to cache the bannedmembers_ table. "0" means don't cache. (int, '0')

Added in 8.8

BannedFrom

Bans all email from a particular address. ListManager will terminate connections with these address(es) in the SMTP MAIL FROM:.(text(16), NULL)

BillingCustomerTypes

(varchar(255), NULL)

BillingEmail

The address used as the default From: for bills. (varchar(100), NULL)

BillingName

(varchar(100), NULL)

BillingTestEmail

The email address billing tests should be sent to. (varchar(100), NULL)

Added in 8.8

BindDNSPort

The IP address ListManager should bind to for the purposes of DNS lookups. (smallint(2), NULL)

CheckCommandMailForSpam

char: 1

nullable: 0

CheckJoinLeaveMailForSpam

char: 1

nullable: 0

CheckJoinMailForSpam

Whether ListManager should check incoming email subscriptions for spam. (bool)

CreateLogEntries

Whether ListManager should log mailings sent to lists. (bool)

DbVersion

What version of ListManager is this database for. (int(4), default '0')

DefaultDomain

What, if any, should be added to the domain if not provided by the user? For example, if mail is sent to 'bob' with no @, what @domain should be appended? (varchar(50), NULL)

DigestFooter

Sever level digest footer. (text, NULL)

DigestHeader

Server level digest header. (text, NULL)

DisableRegexBadFirstLines

Whether ListManager should check first lines of mailings. (bool)

DisableRegexBadFrom

Whether ListManager should check From: addresses. (bool)

DisableRegexBadSubject

Whether ListManager should check subject lines. (bool)

DNSServer

IP address of DNS proxy server; leave blank to use integrated DNS server (recommended) (varchar(15), NULL)

Added in 8.0

DNSUseRemote

Whether ListManager should use a remote DNS server. T or F, defaults to 'F' (bool)

Added in 8.8

EAEmailAddress

The contact email address displayed in EmailAdvisor for rebrandable licenses. (varchar(255NULL)

Added in 8.8

EAImageURL

The image URL number displayed in EmailAdvisor for rebrandable licenses. (varchar(255NULL)

Added in 8.8

EATelephone

The contact telephone number displayed in EmailAdvisor for rebrandable licenses. (varchar(255NULL)

Added in 8.8

EnableContentInternational

Whether ListManager should allow different character sets when creating Content or Mailings. (bool)

EnableReportLegends

Whether ListManager should display legends for reports. (bool)

ExtensionsDirectory

What directory ListManager should use for program extensions. (varchar(100), NULL)

ForwardMailIP

IP address to forward non-ListManager mail to. (varchar(15), NULL)

ForwardMailPort

Port to forward non-ListManager mail to.(smallint(2), NULL)

FCCUrl

URL from which to download wireless domain for automatic banning. Defaults to “http://ftp.fcc.gov/Bureaus/CGB/DomainNames/

DomainNames.txt”

(varchar(255), NULL).

Added in 8.95.

GlobalBanServerAddress

IP address of global ban server. (varchar(15), NULL)

GlobalBanServerPassword

Password for global ban server. (varchar(50), NULL)

GlobalBanServerPort

Port of global ban server. (smallint(2), NULL)

GuiTimeOut

Length of time, in minutes, before the administrator GUI should time out (int (NULL)

Added in 8.8

HomepageNotice

Through the interface, administrators can set up a message to be displayed on the home page. This message can be seen by all nodes in the cluster and is stored here.

HideDisclaimerMenus

Whether ListManager should display menu items disabled by the server's activation code. (bool)

InmailPurgeDays

The number of days ListManager should keep incoming mail before purging it. (smallint(2), default 5)

LastAutoDocSendID

Internal use only. The last Member ID checked for sending a document. (int(4), default 0)

LastUpdate

Internal use only. The last time this table was updated. (datetime(8))

LogFileCount

Maximum number of log files to allow in debug log directory. Default is 0, or forever. Lowest number allowed is 10. (int (4), default 0)

Added in 8.8

LogFileLines

The number of debug log lines to keep in file before rotating. (int(4), default 100000)

LoggingErrorLevel

What level of logging ListManager should display in the debug log. (tinyint(1), default 30)

LogToConsole

Whether ListManager should log errors to the console window. (bool)

LogToFile

Whether ListManager should log errors to a file. (bool)

LogWhatSubsystems

Which subsystems should ListManager log. (int(4), default 2147483647)

LoopBreak

How many repeated messages should ListManager accept before blocking it as a loop. (smallint(2), default 50)

LoopExceptions

Which email addresses should not be subject to loop restrictions. (text, NULL)

DisableMemberHolds

Whether putting members on hold should be disabled for the entire server. (bool)

MaxCommandBodyLinesHtml

smallint size: 2

nullable: 0

smallint size: 2

nullable: 0

MaxMessageSize

The maximum size message ListManager should receive, in bytes. (int(4), default 10485760)

MaxSubscribeBodyLines

The maximum number of lines allowed in a subscription email before considering it spam. (smallint(2), default 6, NULL)

MaxSubscribeBodyLinesHTML

The maximum number of lines allowed in a subscription HTML email message before considering it spam. (smallint(2), default 16, NULL)

smallint size: 2

nullable: 0

smallint size: 2

nullable: 0

MergeAllowBody

Whether ListManager should allow scripting in message bodies. (bool)

MergeCapabilities

What level of scripting should ListManager allow in messages. (tinyint(1), default 1)

MergeRcptToInTestMailing

Whether ListManager should merge in the recipient's email address into test mailings. 'F' (default) merges in the sample member email address. (bool, 'F').

MessageFooter

Sever level message footer. (text, NULL)

MessageHeader

Sever level message header. (text, NULL)

MessageFooterHTML

and

MessageHeaderHTML

Added to separate text footers from html footers.

Added in 8.95.

MetricsPurgeDays

How many days should ListManager keep system metrics, such as server sending speed. (int(4), default 0)

MimeModerationNotice

Whether ListManager should send notification of messages to moderate in MIME format. (bool)

MriShowAllSites

Whether ListManager should show lists from all sites in the Discussion Forum Interface. (bool)

NameCheck

When receiving a posting to a list, whether ListManager should try to match the name of the poster to an authorized sender if the email address does not match. (bool)

NumInmailRetries

Number of times to retry processing of incoming mail that fails to process the first time (default=10) (int, NOT NULL)

Added in 8.95

OutmailPurgeDays

The number of days ListManager keeps outmail records that are not mailings to lists. (int(4), default 5)

PgmAfter

Program ListManager should run after messages sent to the listmanager@address. (varchar(255), NULL)

PgmBefore

Program ListManager should run before messages sent to the listmanager@address. (varchar(255), NULL)

PiperCompany

Company name used for EmailAdvisor service (varchar(100), NULL)

Added in 8.8

PiperPassword

Password used for EmailAdvisor service (varchar(25) or (varchar2(50) : Oracle only), NULL)

Added in 8.8

PiperUserName

User name used for EmailAdvisor service (varchar(50) or (varchar2(50) : Oracle only), NULL)

Added in 8.8

RebrandEmail

Word to replace "lyris" in messages sent from the server. (varchar(50), NULL)

RebrandName

Name to replace "Lyris ListManager" in messages sent from the server. (varchar(50), NULL)

RcvDomains

Domains for which ListManager should receive mail. (text, NULL)

RegexBadFirstLine

This field is currently unused. (text, NULL)

RegexBadFrom

This field is currently unused. (text, NULL)

RegexBadSubject

This field is currently unused. (text, NULL)

RemoveCommandAddrs

What command addresses should ListManager not respond to. (text, NULL)

RetryTiming

The amount of time since the last attempt before another attempt is made. (varchar(100), default '30,720')

Rewrite

Rewrites incoming "From" header. (text, NULL)

RunExtensions

Whether ListManager should allow programs to be run after it performs tasks. (bool)

SegmentPermissions

What level of segmentation should ListManager grant to list administrators. (tinyint(1), default 1)

ServerEncryptionId

Internal number used for web session uniqueness. (int(4), NULL)

SPFAllowedIPs

IP addresses exempted from SPF checks (text, NULL)

Added in 8.8

SmtpInPort

The port ListManager should listen to for incoming SMTP connections. (int(4), default 25)

SpfLevel

What level of SPF checking ListManager should perform on incoming mail. (tinyint(1) default 0)

TclMergeInit

The server level Tcl initialization string. (text, NULL)

Added in 8.8

TclPortHosts

The IP addresses ListManager should allow to connect via Tclport. (text, NULL)

TclPortPassword

The password required by machines connecting via Tclport. (varchar(25), 'TCLPORTPasswd')

TclPortTimeout

The amount of time TclPort should wait before closing an inactive, unresponsive connection.(smallint(2), default 100000)

TclPortRecvPort

The port ListManager should listen to for Tclport connections. (smallint(2), default 2021)

TcpipWebReading

What IP addresses are allowed to access the Discussion Forum Interface. (text, NULL)

TcpipWebListAdmin

What IP addresses are allowed to log in as list administrators. (text, NULL)

TcpipWebSiteAdmin

What IP addresses are allowed to log in as site administrators. (text, NULL)

TcpipWebServerAdmin

What IP addresses are allowed to log in as server administrators. (text, NULL)

ToForward

Incoming forwarding rules. (text, NULL)

ToRewrite

Incoming To: rewrite rules. (text, NULL)

NntpPort

The port ListManager uses for NNTP. (smallint(2), default 119)

TranslateLangID

The default language used by ListManager. (int(4), NULL)

TzDstEndDay

Day of the month that Daylight Savings Time ends (smallint(2), NULL)

TzDstEndMonth

Month of the year thatDaylight Savings Time ends (smallint(2), NULL)

TzDstEndTime

Time that Daylight Savings Time ends (example 7200/60 = 120 which is 2 hours thus 2am) (int(4), NULL)

TzDstEndType

Determines whether your Daylight Savings Time rules are set to end on a specific day of the week or by an exact date (1 for exact date 0 for day of the week) (smallint(2), NULL)

TzDstEndWeek

Week of the month that Daylight Savings Time ends (smallint(2), NULL)

TzDstObserved

If Daylight Savings Time is observed: 1 for yes, 0 for no (smalllint(2), NULL)

TzDstStartDay

Day of the month that Daylight Savings Time starts (smallint(2), NULL)

TzDstStartMonth

Month of the year that Daylight Savings Time starts (smallint(2), NULL)

TzDstStartTime

Time that Daylight Savings Time starts (example 7200/60 = 120 which is 2 hours thus 2am) (int(4), NULL)

TzDstStartType

Determines whether your Daylight Savings Time rules are set to start on a specific day of the week or by an exact date (1 for exact date 0 for day of the week) (smallint(2), NULL)

TzDstStartWeek

Week of the month that Daylight Savings Time starts (smallint(2), NULL)

TzOffset

Time in minutes offset from Greenwich Mean Time (smallint(2), NULL)

TzRuleID

If you are using a pre-defined time zone rule, it's the rule ID of this rule (int(4), NULL)

WebAccessPurgeDays

The length of time ListManager should keep web access longs. (int(4), '0')

UseFastErrorMail

Whether ListManager should process error mail in memory or in the Inmail queue. (bool)