Plug-in to integrate SAM Broadcaster with your WordPress site
Before you install the WordPress plug-in, you will need to configure both SAM
Broadcaster and your mySQL database to allow your webserver to access them.
It is highly recommended that you set up a mySQL user specifically for use by the plug-in. This user only requires SELECT access on the songlist, requestlist, and queuelist tables of your SAM database. It does not require any global access privileges, nor does it need to be able to modify any data in your database.
For security reasons, the plug-in will NOT allow you to use the “root” user, even if you have configured it to be allowed external access. For instructions on how to add a new mySQL user, please see http://dev.mysql.com/doc/refman/5.1/en/adding-users.html.
It is also recommended that you take steps to secure your installation of mySQL before allowing external access by this, or any other application or user. For information on how to secure your mySQL installation, please see http://www.mysql.com/why-mysql/white-papers/a-guide-to-securing-mysql-on-windows/.
There are lot of different options you configure in SAM Broadcaster related to how it handles incoming requests. Most of these are fairly self explanatory and can (and should) be adjusted over time to best suit your own needs as well as those of your visitors. I will only cover those settings which are necessary to allow the plug-in to function.
For information on the additional Request Policy settings in SAM Broadcaster, please see your SAM Broadcaster documentation or integrated help files.
You will also need to ensure that your firewall and/or router are configured to allow incoming connections on the proper ports for MySQL and SAM Broadcaster. By default, these ports are 1221 for SAM Broadcaster and 3306 for MySQL.
Once this is done, the hard part is out of the way. Installation and configuration of the plug-in itself is very easy and straight forward.
Enter the Connection Details for your SAM Broadcaster Database.
For security reasons, the "root" user should never be used for this or any other web based application. For this reason, the plug-in will not allow to use "root" as the database user name.
It is recommended that you configure a new database user specifically for
use by the plug-in and only give it SELECT access on your SAM Database.
The plug-in does not need, nor would it make use of, any other privileges.