Section 1
Introduction
Section 2
Configuring for First Use
Section 3
Changing Admin Password
Section 4
Creating Accounts
Section 5
Global Component Settings
Section 6
Backups
Section 7
Log Files
Section 8
User Interface Settings
Section 9
Database Connections
9.3 Connecting to a Different Database
9.4 Disabling and Enabling Internal Database
Section 10
Non-Standard Ports
Section 11
Firewalls
Section 12
SSL
Section 13
Tracking and Recipient Profiles
Section 14
Editing INI Files
Section 15
Distributed Components
Section 16
User Interface Branding
Section 17
Evaluation Mode
Section 18
International Character Sets
Appendix A
Standard Default Ports
9.4 Disabling and Enabling the Internal Database
If the Maestro User Interface is connected to a different database, there is no longer a need for the internal database (based on MySQL) to be run together with LISTSERV Maestro. To reduce the resource usage of LISTSERV Maestro, disable the internal database after configuring the Maestro User Interface to use a different database.
To disable the internal
database, execute the following command:
\Program
Files\L-Soft\Application Server\commands\DisableInternalDB.cmd
This will stop the internal MySQL database if it is currently
running and will disable it, so that it will not be started
again if LISTSERV Maestro is restarted. Also, the Windows
service in which the internal database was run is uninstalled.
It is no longer possible to choose the “Use Internal Connection”
choice in the Database Connection subsection of the “Maestro
User Interface” section (located in Global Component Settings
in the Administration Hub). If this choice is selected by
mistake, and LISTSERV Maestro is restarted, the Maestro User
Interface component will not start, as it will not be able
to find the now disabled instance of the internal database.
If, at a later point, the internal database is desired, it
must be re-enabled with this command:
\Program
Files\L-Soft\Application Server\commands\EnableInternalDB.cmd
This will re-enable the internal database and install the necessary Windows service. The next time LISTSERV Maestro is restarted, the internal database will also be restarted, and can then be used.
9.5 Registering a Database Plugin
LISTSERV Maestro uses “database plugins” to give access to different JDBC drivers (and through them to different databases) available to the Maestro User Interface. Before a plugin can be used, it must first be registered in the list of known plugins. Some plugins are already pre-registered when LISTSERV Maestro is installed; while others need to be registered after the corresponding JDBC driver has been installed.
To register a new plugin, log into the Administration Hub and click the Global Component Settings link, next click the Maestro User Interface link, and finally, the Database Plugins link. Click on Register New Database Plugin. In the text box, enter the full class name of the plugin to be registered.
For the L-Soft MySQL driver plugin:
com.lsoft.lui.db.mysql.MySQLDriverPlugin
For the IBM DB2 V7.2 driver plugin:
com.lsoft.lui.db.ibm.DB2V7DriverPlugin
For the Oracle 8i thin driver plugin:
com.lsoft.lui.db.oracle.Oracle8iThinDriverPlugin
For the Microsoft SQL Server 2000 drive plugin:
com.lsoft.lui.db.sqlserver.MSSQLDriverPlugin
For the I-net SPRINTA driver for MS SQL Server 7.0/2000 plugin:
com.lsoft.lui.db.sqlserver.SPRINTADriverPlugin
Figure 29 Add New Database Plugin
Click OK to submit the class name. If the plugin was registered correctly, it will now appear in the list of plugins. If there was a problem during the registration, an error message describing the problem will appear. The most probable causes for problems are misspellings of the class name (which is case sensitive) or a faulty installation of the JDBC driver that is used by the plugin in question (see Section 9.6 Installing JDBC-Drivers for Different Databases for more information).