2023-01-21, 23:17
Thanks will do tonight. Sorry
2023-02-12, 10:23
so who actually has kodi running with mariadb 8 ?
even trying fresh installs I only get kodi as far as creating version.ibd file
default_authentication_plugin=mysql_native_password
CREATE USER 'kodi' IDENTIFIED WITH mysql_native_password BY 'kodi123#';
GRANT ALL ON *.* TO 'kodi';
SET GLOBAL log_bin_trust_function_creators = 1;
flush privileges;
https://pastebin.com/xTyttjPt
even trying fresh installs I only get kodi as far as creating version.ibd file
default_authentication_plugin=mysql_native_password
CREATE USER 'kodi' IDENTIFIED WITH mysql_native_password BY 'kodi123#';
GRANT ALL ON *.* TO 'kodi';
SET GLOBAL log_bin_trust_function_creators = 1;
flush privileges;
xml:
2023-02-12 18:15:20.551 T:665362 info <general>: -----------------------------------------------------------------------
2023-02-12 18:15:20.551 T:665362 info <general>: Starting Kodi (21.0-ALPHA1 (20.90.101) Git:20230203-64f9286f79). Platform: Linux x86 64-bit
2023-02-12 18:15:20.551 T:665362 info <general>: Using Release Kodi x64
2023-02-12 18:15:20.551 T:665362 info <general>: Kodi compiled 2023-02-03 by GCC 11.3.0 for Linux x86 64-bit version 5.15.74 (331594)
2023-02-12 18:15:20.551 T:665362 info <general>: Running on Ubuntu 22.04.1 LTS, kernel: Linux x86 64-bit version 5.18.19-051819-generic
2023-02-12 18:15:20.551 T:665362 info <general>: FFmpeg version/source: 5.1.2-Kodi
2023-02-12 18:15:20.551 T:665362 info <general>: Host CPU: AMD Ryzen 9 3900X 12-Core Processor , 24 cores available
...
2023-02-12 18:15:23.270 T:665362 info <general>: MYSQL: Connected to version 8.0.30-22.1
...
2023-02-12 18:15:24.393 T:665362 debug <general>: Mysql Start transaction
2023-02-12 18:15:24.393 T:665362 info <general>: creating version table
2023-02-12 18:15:24.393 T:665362 debug <general>: Mysql execute: CREATE TABLE version (idVersion integer, iCompressCount integer)
CHARACTER SET utf8 COLLATE utf8_general_ci
2023-02-12 18:15:28.014 T:665362 debug <general>: Mysql execute: INSERT INTO version (idVersion,iCompressCount) values(121,0)
2023-02-12 18:15:28.015 T:665362 error <general>: SQL: [AnimeTestversionvideo121] Undefined MySQL error: Code (1105)
Query: INSERT INTO version (idVersion,iCompressCount) values(121,0)
2023-02-12 18:15:28.015 T:665362 error <general>: CreateDatabase unable to create database:0
2023-02-12 18:15:28.016 T:665362 debug <general>: Mysql rollback transaction
2023-02-12 18:15:28.016 T:665362 info <general>: Running database version TV40
2023-02-12 18:15:28.017 T:665362 info <general>: Running database version Epg16
2023-02-12 18:15:28.017 T:665362 debug <general>: Initialize, updating databases... DONE
https://pastebin.com/xTyttjPt
2023-02-12, 10:48
(2023-02-12, 10:23)MasterCATZ Wrote: so who actually has kodi running with mariadb 8 ?
I take it you mean MySQL 8.x? MariaDB is in the 10.x series for a while now.
I'm running 8.0.32 on Ubuntu Server 22.04.2, basically with all defaults but one, using the mysql_native_password option for the kodi user.
It's a bit unnecessary to paste log file snippets into the forum when you also link the full log. From what I found after some searching:
MySQL error 1049: This MySQL error usually happens when the MySQL data directory (datadir) does not belong to the user under which the mysqld process runs. For example the data directory belongs to the user root and the mysqld process runs as user mysql. AKA, your server setup is not configured properly.
MySQL error 1105: https://techyaz.com/sql-server/troublesh...rror-1105/ With suggestions that you do a REPAIR on your database tables...
2023-02-12, 11:13
2023-02-12, 11:24
(2023-02-12, 11:13)MasterCATZ Wrote: literally fresh installs , and it does manage to write 1 file before it fails
Just an observation:
I use MySQL 8.0 'official', you use 'Percoma XtraDB Cluster' something.
I don't use the "log_bin_trust_function_creators" variable, you do use it.
I use Ubuntu Server 22.04, you use Debian.
All minute differences, but still differences that apparently add up to some SQL problem.
What happens if you install MySQL 8.x directly, instead of the whole Percoma package?
2023-02-12, 11:34
log_bin_trust_function_creators makes no difference either its how others were solving the issue
https://forum.kodi.tv/showthread.php?tid=186325&page=2
and I use Ubuntu and Debian tho heading back to Debian
has to be a MariaDB Galera Cluster type so I can have offsite backups
I will try
sudo apt -y install mariadb-server mariadb-client
soon just making another Fresh debian11 base install for now
and for some odd reason because I was screen recording step by step for the last hour during deb 11 install it worked .... so now even more puzzled , tries again ...
https://forum.kodi.tv/showthread.php?tid=186325&page=2
and I use Ubuntu and Debian tho heading back to Debian
has to be a MariaDB Galera Cluster type so I can have offsite backups
I will try
sudo apt -y install mariadb-server mariadb-client
soon just making another Fresh debian11 base install for now
and for some odd reason because I was screen recording step by step for the last hour during deb 11 install it worked .... so now even more puzzled , tries again ...
2023-02-12, 12:52
Server version: 8.0.31-23 Percona Server (GPL), Release '23', Revision '71449379'
works (fresh debian 11 install )
and my running debian 11 install has Server version: 8.0.29-21.1 Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3
Server version: 8.0.30-22.1 Percona XtraDB Cluster (GPL), Release rel22, Revision aff6a8b, WSREP version 26.4.3
fails (something I installed on a old debian 10 install I had sitting around a few hours ago )
looks like an update literally came through
works (fresh debian 11 install )
and my running debian 11 install has Server version: 8.0.29-21.1 Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3
Server version: 8.0.30-22.1 Percona XtraDB Cluster (GPL), Release rel22, Revision aff6a8b, WSREP version 26.4.3
fails (something I installed on a old debian 10 install I had sitting around a few hours ago )
looks like an update literally came through
