[Akonadi] [Bug 397634] New: Is it possible to define a port for akonadi mariadb database ?

[Nick]

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 at kde.org
          Reporter: ndordea at 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 at 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.