These settings are used by all machines in a ListManager cluster.
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) |
|
ComplaintBanLevel | This setting allows user to determine what will happen to recipients that mark a mailing as spam (int, NOT NULL) | Added in 10.0 |
ConnAttemptAsSendTryForCluster | for clusters, 'T' means each connection attempt counts as a sendtry | Added in 10.0 |
DALPurgeAgeHours | maximum age of lyrDeliveryAttemptLog entries before purging (in hours), default 1 week (smallint, NOT NULL) | Added in 10.0 |
DAOLoggingLevel | This setting determines what level of logging will occur in the DeliveryAttemptLog (varchar(255), NULL) | Added in 10.0 |
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) |
|
IncrBlockedExpireHours | (added to the sum of retry times) determines how long to wait before expiring blocked recipients(smallint, NOT NULL) | Added in 10.0 |
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 |
|
MaxCommandBodyLinesText |
smallint size: 2 nullable: 0 |
|
MaxIncomingConnections | regulates the maximum number of simultaneous incoming connections | Added in 10.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) |
|
MaxSubUnsubBodyLinesHtml |
smallint size: 2 nullable: 0 |
|
MaxSubUnsubBodyLinesText |
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) |
|
MinBlockedExpireHours | The minimum amount of time to wait before expiring blocked recipients (smallint, NOT NULL) | Added in 10.0 |
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) |
|
NextConnectionRetryMinutes | how long to wait before retrying a connection to a non-responding host | Added in 10.0 |
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) |
|
Session_Enable | 'T' if sessions are enabled (char(1), NOT NULL) | Added in 10.0 |
Session_IdleTimeout | idle time (in minutes) before a session times out (smallint, NOT NULL) | Added in 10.0 |
Session_LoginUrl | redirection URL for the login page (varchar(2000), NOT NULL) | Added in 10.0 |
Session_MaxLifeTimeout | total time (in minutes) before a user is force to reauthenticate (smallint, NOT NULL) | Added in 10.0 |
Session_NoSSLMessage | Warning message if the user isn't logged in via SSL (varchar(2000), NULL) | Added in 10.0 |
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) |
|
SuppressErrorResponse | if 'T', do not respond to failed email commands; helps prevent backspatter | Added in 10.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) |
|
TcpipAPIAdmin | IP addresses allowed to connect for API operations (text(2147483647), NULL) | Added in 10.0 |
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) |
|
UseBlockingModeSpf |
Whether ListManager should block incoming mail that takes too much time during the SPF check. (bool) |
|
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) |
|