summaryrefslogtreecommitdiff
path: root/README.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'README.mysql')
-rw-r--r--README.mysql85
1 files changed, 85 insertions, 0 deletions
diff --git a/README.mysql b/README.mysql
new file mode 100644
index 0000000..bbf71a0
--- /dev/null
+++ b/README.mysql
@@ -0,0 +1,85 @@
+/*! \mainpage Muggle: Usage with mysql
+
+This is a plugin for the Video Disk Recorder (VDR).
+
+Written by: Andi Kellner,
+ Lars von Wedel <vonwedel@web.de>,
+ Ralf Klueber <r@lf-klueber.de>,
+ Wolfgang Rohdewald <wolfgang@rohdewald.de>
+
+Project's homepage: http://www.htpc-tech.de/htpc/muggle.htm
+
+Latest version available at: http://www.htpc-tech.de/htpc/muggle-dev.htm
+
+See the file COPYING for license information.
+
+\section prereq PREREQUISITES
+
+You will need:
+
+ - mySQL client libraries
+ (Debian package libmysqlclient-dev or
+ http://www.mysql.org)
+ - mySQL server (tested with 4.0.18) (Debian packages mysql-server, mysql-client)
+ only needed, if you want to run the database server on a remote machine
+
+The developer versions are needed because their headers are required for compilation.
+The server need not be on the same machine as the VDR. Also, music tracks can reside somewhere else,
+if they are available through a remote filesystem (NFS, Samba). However, in this case you should
+know what you are doing in terms of networking and security issues.
+
+\section install INSTALLING
+
+Adapt the Makefile or Make.config to your system. Define HAVE_MYSQL and HAVE_ONLY_SERVER if
+you do not want the embedded version.
+
+HAVE_MYSQL=1
+HAVE_ONLY_SERVER=1
+
+NOTE: If the package mysql-server is not installed on your machine you might
+see an error message like this:
+
+050306 9:29:14 Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
+050306 9:29:14 Aborting
+
+In this case you need to obtain these files and put them there.
+
+Then you can build and install the plugin as described in README
+
+
+\section SET UP MUGGLE WITH EMBEDDED MYSQL
+
+Embedded MySQL means simpler configuration because you do not have
+to login into a remote data base server. You will only need the argument
+-d Directory. muggle will store the data base in that directory. Start
+mugglei without arguments for details.
+
+NOTE: The embedded MySQL server cannot be used by other programs.
+
+NOTE: The GiantDisc web interface only works with remote MySQL.
+
+
+\section SET UP MUGGLE WITH REMOTE MYSQL
+
+If you already have a MySQL server running in your network (e.g. as a basis
+for a webserver) or want to access the music database with other programs
+(e.g. the GiantDisc web interface) you may be interested in using
+
+\section config MUGGLE CONFIGURATION
+
+When using the remote MySQL server, muggle and mugglei use a small set of
+parameters in order to control the interaction with the mySQL server. Let's
+look at an example:
+
+\verbatim
+ -P'muggle -h localhost -u vdr -p pw -n GiantDisc -t/home/music'
+\endverbatim
+
+The -h parameter specifies the database host, -u specifies the user,
+-p specifies the password, -n is the database name.
+
+Start mugglei without arguments to see a list and explanation of
+all available options. They can vary slightly depending on the
+chosen data base software.
+
+*/