summaryrefslogtreecommitdiff
path: root/README
diff options
context:
space:
mode:
Diffstat (limited to 'README')
-rw-r--r--README42
1 files changed, 20 insertions, 22 deletions
diff --git a/README b/README
index 14fd3bf..7f5a396 100644
--- a/README
+++ b/README
@@ -1,7 +1,7 @@
-----------------------------------------------------------------------------------
- epgd
-
-- This daemon is used to download EPG data from the internet and manage it in a mysql database.
+- This daemon is used to download EPG data from the internet and manage it in a maria database.
-
- Written by: C++/SQL - Jörg Wendel (vdr at jwendel dot de)
- SQL/Procedures - Christian Kaiser
@@ -23,21 +23,21 @@ Description
EPG Merge
Get the source from git
Requirements
-MySQL Setup
+MariaDb Setup
epgd Installation
epgd Configuration
Starting epgd and init-Scripts
Upgrade from older versions
-MySQL Hints
+MariaDb Hints
Considerations
Description:
------------
-epgd is part of the double team epgd+epg2vdr to effectively retrieve, store and import epg data to vdr. It is designed to handle large amount of data and pictures in a distributed environment with one epg-server and many possible vdr-clients - therefore it relies on mysql.
+epgd is part of the double team epgd+epg2vdr to effectively retrieve, store and import epg data to vdr. It is designed to handle large amount of data and pictures in a distributed environment with one epg-server and many possible vdr-clients - therefore it relies on mariadb.
-Though it is possible to use epgd alone with mysql it only makes sense to use it as backend to the vdr-plugin epg2vdr. That being said you need to install, setup and configure mysql, epgd and epg2vdr in order to get a working environment.
+Though it is possible to use epgd alone with mariadb it only makes sense to use it as backend to the vdr-plugin epg2vdr. That being said you need to install, setup and configure mariadb, epgd and epg2vdr in order to get a working environment.
EPG Merge:
@@ -81,7 +81,7 @@ Requirements:
- libcurl 7.10+
- libxslt 1.1.24+
- libxml2
- - libmysql >= 5.07
+ - libmariadb >= 10.x
- libz
- libssl-dev
- uuid uuid-dev
@@ -94,14 +94,14 @@ Requirements:
- libsystemd-daemon-dev (if you like to use the systemd status interface)
-> debian previous to 'sid' maybe libsystemd-dev?
- Example for Ubuntu (14.10):
+ Example for Ubuntu (21.10):
- libarchive12, libarchive-dev
- libz, libz-dev
- libssl-dev
- libcurl4-nss-dev (oder libcurl3-nss-dev)
- libxslt1.1 libxslt1-dev libxml2 libxml2-dev
- - libmysqlclient-dev libmysqlclient18
+ - libmariadb-dev mariadb-common
- libjpeg62-dev libjpeg62
- uuid uuid-dev
- libjansson4 libjansson-dev
@@ -115,11 +115,11 @@ Requirements:
My-SQL Setup:
-------------
-You need a running mysql database.
-Consult the manual of your linux-flavour how to install and configure mysql.
+You need a running mariadb database.
+Consult the manual of your linux-flavour how to install and configure mariadb.
Remember to put your db-files in a large enough filesystem: with many channels,
many prefetched days and many pictures you will easily need 3 or more Gb of disk space.
-When mysql is up and running you need to prepare the database and
+When mariadb is up and running you need to prepare the database and
access-rights for use with epgd:
- login as root:
@@ -137,8 +137,8 @@ access-rights for use with epgd:
- adjust the bind address in my.cnf:
adjust the line
bind-address = 127.0.0.1
-in youre my.cnf (mostly found here: /etc/mysql/my.cnf) to the address where
-the mysql serve should listen on - Or comment out if it should listen on all interfaces.
+in youre my.cnf (mostly found here: /etc/mysql/...) to the address where
+the mariadb server should listen on - Or comment out if it should listen on all interfaces.
- switch of binary logging:
comment line starting with 'log_bin' in youre my.cnf
@@ -165,7 +165,7 @@ Make sure the server charecter-set is set to latin1, file format is set to BARRA
character-set-server = latin1
innodb_large_prefix = ON
innodb_file_format = BARRACUDA
-Remove all other collations from your mysqld config.
+Remove all other collations from your mariadb config.
We use UTF8 only on client side!
@@ -227,17 +227,17 @@ epgd is configured in /etc/epgd/epgd.conf. But you can overwrite the following o
-p <plugin-dir> load plugins from <plugin-dir>
-l <log-level> set log level
-For production use you should start epgd after net- and mysql services via your init-system. Some start-scripts have been put to ./contrib hopefully serving your needs (or at least giving you an idea of how to proceed).
+For production use you should start epgd after net- and mariadb services via your init-system. Some start-scripts have been put to ./contrib hopefully serving your needs (or at least giving you an idea of how to proceed).
epgd Configuration:
-------------------
DbHost =
- ip/name of mysql server host (default localhost)
+ ip/name of mariadb server host (default localhost)
DbPort =
- port of the mysql server (default 3306)
+ port of the mariadb server (default 3306)
DbName =
name of the database (default epg2vdr)
@@ -344,8 +344,8 @@ HINTS / PITFALLS:
--vfat bzw. --dirnames
-MYSQL HINTS:
------------
+MariaBb HINTS:
+---------------
- If you cannot figure out why you get Access denied, remove all entries from the user table
that have Host values with wildcards contained (entries that match '%' or '_' characters).
A very common error is to insert a new entry with Host='%' and User='some_user',
@@ -359,9 +359,7 @@ MYSQL HINTS:
- *ATTENTION* if you have binary-logging (log_bin) enabled!
- disable it OR add log-bin-trust-function-creators to your configuration:
- > echo "log-bin-trust-function-creators = 1" >> /etc/mysql/my.cnf
- > restart the database
+ disable it OR add log-bin-trust-function-creators to your configuration and restart the database
Considerations: