Debian10 - Revision history

Leon: pypad system user and group

2022-04-07T16:53:48Z

pypad system user and group

2022-04-06T09:16:59Z

pypad scripts modification to work

2022-04-06T08:59:01Z

‎prepare mysql server

2022-04-06T08:57:33Z

partially disabling mysqld strict mode

2022-03-25T17:53:45Z

"Field 'STATION' doesn't have a default value QMYSQL" error

2022-03-25T17:29:23Z

mariadb-server replaces now mysql-server

2021-05-18T11:48:50Z

‎Bug in utils/rddbmgr/updateschema.cpp

2021-05-18T11:47:30Z

‎get rivendell sources

2021-05-18T11:44:25Z

turning off mysql strict mode

2020-03-25T08:02:20Z

adds the python3-mysqldb requirement

@@ Line 112: / Line 112: @@
   sys.path.append("/usr/local/lib/python3.7/site-packages")
   import pypad
 ====M4A format not supported====

@@ Line 105: / Line 105: @@
 == known problems ==
-M4A format will not be imported, as libmp4v2-dev is no more available.
 ===="Field 'STATION' doesn't have a default value QMYSQL" error====

@@ Line 73: / Line 73: @@
   > create database Rivendell;
   > grant Select, Insert, Update, Delete, Create, Drop, References, Index, Alter, Create Temporary Tables, Lock Tables on Rivendell.* to rduser@'%' identified by 'letmein';
-  > \q
+  > quit;
 == prepare os ==

@@ Line 39: / Line 39: @@
 Just copy/paste in your ../my_patch file and then run :
   patch -p1 <../my_patch
-Another solution is to turn off mysql strict mode, as explined [http://wiki.rivendellaudio.org/index.php/Ubuntu18_04#Getting_MySQL_to_work_and_creating_the_Rivendell_user_and_database here]. I've not tested that method.
+'''Another solution''' is to turn off mysql strict mode, as explined [http://wiki.rivendellaudio.org/index.php/Ubuntu18_04#Getting_MySQL_to_work_and_creating_the_Rivendell_user_and_database here]. Writing these 2 lines in a file called '''/etc/mysql/conf.d/disable_strict_mode.cnf''' will be enough to work with the non-patched code :
 == compile rivendell ==

← Older revision		Revision as of 17:53, 25 March 2022
Line 102:		Line 102:
	== known problems ==		== known problems ==
	M4A format will not be imported, as libmp4v2-dev is no more available.		M4A format will not be imported, as libmp4v2-dev is no more available.
		+
		+	===="Field 'STATION' doesn't have a default value QMYSQL" error====
		+	$ sudo rddbmgr --create --generate-audio
		+	DB connection re-established
		+	invalid SQL or failed DB connection[Field 'STATION' doesn't have a default value QMYSQL: Unable to execute query]: insert into NEXUS_STATIONS set RD_SERVICE="Production"
		+	rddbmgr: sql error: Field 'STATION' doesn't have a default value QMYSQL: Unable to execute query query: insert into NEXUS_STATIONS set RD_SERVICE="Production"
		+	Please (re)read "Bug in utils/rddbmgr/updateschema.cpp" described in a precedent section

@@ Line 65: / Line 65: @@
 == prepare mysql server ==
-  sudo apt install mysql-server
+  sudo apt install mysql-server (or mariadb-server)
   sudo mysql
   > create database Rivendell;

@@ Line 13: / Line 13: @@
   ./autogen.sh
-=== Bug in utils/rddbmgr/updateschema.cpp ===
+===== Bug in utils/rddbmgr/updateschema.cpp =====
 Since 3.1.0, you have to apply this patch :
   diff --git a/utils/rddbmgr/updateschema.cpp b/utils/rddbmgr/updateschema.cpp

@@ Line 44: / Line 44: @@
   sudo apt install libjack-jackd2-dev
   sudo apt install libdiscid-dev libmusicbrainz5-dev libcoverart-dev (since 3.3.0 version)
   export PATH=/sbin:$PATH (since runuser is required)
   ./configure --libexecdir=/var/www/rd-bin --sysconfdir=/etc/apache2/conf-available