SmartPants Media Xtras
Products Purchase Download About Help SmartPants Media
MUDBOX Help: MUDBOX

MySQL Database Xtra version 1.0 Release for Macromedia MultiUser Server
(c) 2001 SmartPants Media, Inc.

This Xtra acts as a replacement for the DatabaseObjects Xtra included with
the Macromedia MultiUser Server, using a MySQL database server as a back-end
rather than local DBF files. The current version is intended to be almost
fully compatible with movies utilizing the database functionality offered
by the MultiUser Server.

To get this Xtra running, you must place the included "DBMySQL.x32" file
in the "Xtras" subdirectory of the MultiUser Server, and "libMySQL.dll" in
either the main MultiUser Server directory, or your system directory.

After that, you must edit your "multiuser.cfg" configuration file to use
the new Xtra. Find the line that starts with "ServerExtensionXtras =",
remove "DatabaseObjects" if it exists, and instead put "DatabaseMySQL".

This Xtra also requires some other configurations options to be set up
in "multiuser.cfg", so find the line reading
"XtraConfigCommands for DatabaseObjects" and replace it with
"XtraConfigCommands for DatabaseMySQL." Many of the general configuration
options for DatabaseMySQL use the same commands for both Xtras, including
"Authentication" and the setting of security levels for database commands.

Configuration commands which are not present in DatabaseObjects, but which
may be necessary for proper operation of DatabaseMySQL are as follows:

Server <name>
Specifies the hostname of your MySQL server. The Xtra will connect to
this address to perform database operations. If not specified, the
server defaults to "localhost".

Port <number>
Specifies the port of the MySQL server. Generally this will not need to
be changed or specified. The default is port 3306.

Database <name>
Specifies the name of the database to use on the MySQL server. This is
required.

If the database does not exist on the server, it will be automatically
set up by the Xtra. Do not set up the database yourself.

UserName <name>
Specifies the user name to use when connecting to the MySQL server. This
user should have proper security permissions to the database specified in
the "Database" directive. The quickest way to set up permissions is to
execute the MySQL command:

GRANT ALL ON database.* TO username@% IDENTIFIED BY 'password'

Password <pass>
Specifies the password to use when connecting to the MySQL server.
It would be a good idea to have this correctly match the user name
given in the "UserName" directive.

AttrPrefix <prefix>
Determines the column name prefix to use for attributes in each of the
tables created by the Xtra. For now it is best to use "attr_" as your
prefix, as this option may be removed in future releases. Do not
use the prefix "mus_".

RetryInterval <time>
If the Xtra cannot connect the MySQL server, it will try every
<time> seconds until it succeeds. The default is 60 seconds.