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