Hallo!
Ich möchte für meine 2 Kodi-Devices (Vero 4k+) eine Datenbank verwenden. Dazu habe ich die aktuelle Version von MariaDB auf mein NAS (QNAP-853A) geladen. Nun muss ich noch die my.cnf Datei von MariaDB bearbeiten und den Eintrag bind-address ändern. Die Frage ist nun welche my.cnf ist die richtige.
liefert folgendes:
10591 admin 2836 S /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/usr/local/mariadb/my-mariadb.cnf --basedir=/usr/local/mariadb --datadir=/share/CACHEDEV1_DATA/.system/data --user=admin --default-storage-engine=MyISAM --wait_timeout=2628000 --pid-file=/var/lock/mariadb.pid --tmpdir=/share/CACHEDEV1_DATA/.system/tmp
11009 admin 62656 S /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/mariadb/my-mariadb.cnf --basedir=/usr/local/mariadb --datadir=/share/CACHEDEV1_DATA/.system/data --plugin-dir=/usr/local/mariadb/lib/plugin --user=admin --default-storage-engine=MyISAM --wait-timeout=2628000 --tmpdir=/share/CACHEDEV1_DATA/.system/tmp --log-error=/share/CACHEDEV1_DATA/.system/data/NAS1--8-Bay.err --pid-file=/var/lock/mariadb.pid --socket=/tmp/mysql_mediadb.sock --port=3310
15282 admin 240 S grep -i mysql
26547 admin 3664 S /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/etc/qbox-mariadb.cnf --basedir=/usr/local/mariadb --datadir=/share/CACHEDEV1_DATA/.qbox/mysql/data --user=admin --default-storage-engine=MyISAM --wait_timeout=2628000 --pid-file=/var/lock/mysql_qbox.pid --tmpdir=/share/CACHEDEV1_DATA/.qbox/mysql/tmp
26918 admin 63964 S /usr/local/mariadb/bin/mysqld --defaults-file=/etc/qbox-mariadb.cnf --basedir=/usr/local/mariadb --datadir=/share/CACHEDEV1_DATA/.qbox/mysql/data --plugin-dir=/usr/local/mariadb/lib/plugin --user=admin --default-storage-engine=MyISAM --wait-timeout=2628000 --tmpdir=/share/CACHEDEV1_DATA/.qbox/mysql/tmp --log-error=/share/CACHEDEV1_DATA/.qbox/mysql/data/NAS1--8-Bay.err --pid-file=/var/lock/mysql_qbox.pid --socket=/tmp/qsyncsrv/mysql_qbox.sock --port=23310
29727 admin 3344 S /bin/sh /share/CACHEDEV1_DATA/.qpkg/QMariaDB/bin/mysqld_safe --defaults-file=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/my.cnf --user=admin --basedir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB --datadir=/share/CACHEDEV1_DATA/QMariaDB --plugin-dir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/lib/plugin --tmpdir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/tmp --log-error=/share/CACHEDEV1_DATA/QMariaDB/qmariadb.err --pid-file=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/QMariadDB2.pid --ledir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/bin --mysqld=mysqld --socket=/tmp/QMariadDB2.sock --port=3308
29890 admin 61608 S /share/CACHEDEV1_DATA/.qpkg/QMariaDB/bin/mysqld --defaults-file=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/my.cnf --basedir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB --datadir=/share/CACHEDEV1_DATA/QMariaDB --plugin-dir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/lib/plugin --user=admin --tmpdir=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/tmp --log-error=/share/CACHEDEV1_DATA/QMariaDB/qmariadb.err --pid-file=/share/CACHEDEV1_DATA/.qpkg/QMariaDB/QMariadDB2.pid --socket=/tmp/QMariadDB2.sock --port=3308
[~] #
Dann habe ich noch generell nach my.cnf Dateien gesucht. Dabei kommt das heraus:
[~] # find / -name my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/connect/connect/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/heap/mtr2/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/rocksdb/rocksdb/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/rocksdb/rocksdb_hotbackup/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/rocksdb/rocksdb_rpl/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/rocksdb/rocksdb_stress/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/rocksdb/rocksdb_sys_vars/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/sphinx/sphinx/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/bg/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/bugfix/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/feature/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/handler/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/oracle/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/oracle2/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/regression/e1121/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/regression/e112122/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/spider/spider/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/plugin/wsrep_info/wsrep_info/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/binlog_encryption/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/encryption/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/federated/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/galera/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/galera_3nodes/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/galera_3nodes_sr/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/galera_sr/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/multi_source/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/rpl/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/s3/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/storage_engine/trx/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/storage_engine/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/storage_engine/parts/my.cnf
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/mysql-test/suite/wsrep/my.cnf
/mnt/HDA_ROOT/.config/my.cnf
/mnt/ext/opt/mariadb/my.cnf
find: ‘/proc/1011/task/1011/net’: Invalid argument
find: ‘/proc/1011/net’: Invalid argument
find: ‘/proc/1012/task/1012/net’: Invalid argument
find: ‘/proc/1012/net’: Invalid argument
find: ‘/proc/3298/task/3390/fd/6’: No such file or directory
find: ‘/proc/29875’: No such file or directory
/etc/my.cnf
/etc/default_config/my.cnf
[~] #
Alles anzeigen
Und dann hätte ich noch gerne gewusst wie ich MariaDB über die Konsole neu starten kann. Ich dachte mit systemctl restart, aber das funktioniert nicht:
[~] # systemctl restart mariadb
-sh: systemctl: command not found
[~] #
Ich bedanke mich im Voraus!
LG
G