https://bugs.kde.org/show_bug.cgi?id=397634
Bug ID: 397634 Summary: Is it possible to define a port for akonadi mariadb database ? Product: Akonadi Version: 5.8.3 Platform: openSUSE RPMs OS: Linux Status: UNCONFIRMED Severity: wishlist Priority: NOR Component: server Assignee: kdepim-bugs@kde.org Reporter: ndor...@gmail.com Target Milestone: --- Hello , This is not a bug. It is a request for information . A). The only way of accessing kmail mysql /mariadb data base is via mysql -h localhost -S /tpm/akonadi-xxxxx.T2YTcF/mysql.socket B). I tried to get more info via Percoma tools .... B.1). pt-mysql-summary --host localhost --socket /tmp/akonadi-rocco.T2YTcF/mysql.socket # Percona Toolkit MySQL Summary Report ####################### System time | 2018-08-19 17:07:09 UTC (local TZ: CDT -0500) # Instances ################################################## Port Data Directory Nice OOM Socket ===== ========================== ==== === ====== 0 0 /home/<uname>/.local/share/akonadi/db_data/ 0 0 /tmp/akonadi-<uid>.T2YTcF/mysql.socket # MySQL Executable ########################################### Path to executable | /usr/sbin/mysqld Has symbols | No # Report On Port 0 ########################################### User | @ Time | 2018-08-19 12:07:09 (CDT) Hostname | SuSE4<uname>.dom Version | 10.2.15-MariaDB openSUSE package Built On | Linux x86_64 Started | 2018-08-19 06:57 (up 0+05:09:31) Databases | 5 Datadir | /home/<uname>/.local/share/akonadi/db_data/ Processes | 6 connected, 1 running Replication | Is not a slave, has 0 slaves connected Pidfile | /tmp/akonadi-<uname>.T2YTcF/mysql.pid (exists) # Processlist ################################################ B.2) pt-mysql-summary --host localhost --user root --password # Percona Toolkit MySQL Summary Report ####################### System time | 2018-08-19 17:11:51 UTC (local TZ: CDT -0500) # Instances ################################################## Port Data Directory Nice OOM Socket ===== ========================== ==== === ====== 0 0 /home/<uname>/.local/share/akonadi/db_data/ 0 0 /tmp/akonadi-<uname>.T2YTcF/mysql.socket # MySQL Executable ########################################### Path to executable | /usr/sbin/mysqld Has symbols | No # Report On Port 3306 ######################################## User | root@localhost Time | 2018-08-19 12:11:51 (CDT) Hostname | SuSE4Rocco Version | 10.2.15-MariaDB openSUSE package Built On | Linux x86_64 Started | 2018-08-19 06:54 (up 0+05:17:25) Databases | 6 Datadir | /var/lib/mysql/ Processes | 1 connected, 1 running Replication | Is not a slave, has 0 slaves connected Pidfile | /var/lib/mysql/SuSE4<uname>.pid (does not exist) # Processlist ################################################ C.) I would like to use adminer and/or any mysql workbench to have access to akonadi database . Unfortunately the only options to define a database connection are : host port user password The only option I know is that mysql user name = akonadi Base : ~./config/akonadi/akonadiserverrc [Debug] Tracer=null [%General] Driver=QMYSQL [QMYSQL] Host= Name=akonadi Options="UNIX_SOCKET=/tmp/akonadi-<uname>.T2YTcF/mysql.socket" ServerPath=/usr/sbin/mysqld StartServer=true D.) Questions : 1. What are the akonadi's password and port of akonadi mariaDB database ? 2. Is it appropriate/recommended to switch akonadi MariaDB from internal to external ? 3. Is it possible to move the MariaDB akonadi database to the system's location /var/log/mysql or any other/better one ? [ I have disk space issues and I have hard time to move the entire /home to another location ] 4. Is it possible/recommended to switch from MariaDB 10.2.15 to Oracle's mysql 8.0.2 community data server ? [ Unfortunately these two database servers can not coexist on the same machine ] 5. If it is possible what would be the procedure [ dump from MariaDB and import ... ? ] Thank you very much Nick -- You are receiving this mail because: You are the assignee for the bug.