Bug #87783 Preferences not saved under arch linux
Submitted: 17 Sep 2017 4:09 Modified: 20 Sep 2017 21:26
Reporter: Charles Gagnon Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.9 OS:Linux ( x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[17 Sep 2017 4:09] Charles Gagnon 
Description:
Under arch linux, user preferences are not persisted. No wb_options.xml is created and there is no such file after the installation.

How to repeat:
Install workbench on arch linux, try to save a preference.

Suggested fix:
Save preferences.
[17 Sep 2017 4:11] Charles Gagnon 
wb.log

Attachment: wb.log (text/x-log), 1.25 KiB.
[19 Sep 2017 23:51] MySQL Verification Team 
I couldn't repeat on Manjaro which is based on Arch Linux, please check on folder showed below. Thanks.

[miguel@miguel-vb-pc ~]$ cd .mysql/workbench/
[miguel@miguel-vb-pc workbench]$ ls wb_options.xml -la
-rw-r--r-- 1 miguel miguel 48711 set 19 20:33 wb_options.xml
[miguel@miguel-vb-pc workbench]$ cat /etc/lsb-release 
DISTRIB_ID=ManjaroLinux
DISTRIB_RELEASE=17.0.5
DISTRIB_CODENAME=Gellivara
DISTRIB_DESCRIPTION="Manjaro Linux"
[miguel@miguel-vb-pc workbench]$ pwd
/home/miguel/.mysql/workbench
[miguel@miguel-vb-pc workbench]$
[20 Sep 2017 0:04] Charles Gagnon 
Hi, yes this is where I expect the wb_options.xml file to be but it isn't. Please see below, thanks.

➜  workbench pwd
/home/cgagnon/.mysql/workbench
➜  workbench ll
total 40K
drwx------ 2 cgagnon users 4.0K Sep 18 19:53 cache
-rw-r--r-- 1 cgagnon users 3.1K Sep 19 17:11 connections.xml
drwx------ 2 cgagnon users 4.0K Sep 13 16:38 libraries
drwx------ 2 cgagnon users 4.0K Sep 19 17:09 log
drwx------ 2 cgagnon users 4.0K Sep 13 16:38 modules
drwx------ 2 cgagnon users 4.0K Sep 13 16:38 scripts
-rw-r--r-- 1 cgagnon users 1.5K Sep 19 17:09 server_instances.xml
drwx------ 2 cgagnon users 4.0K Sep 13 16:38 snippets
drwx------ 2 cgagnon users 4.0K Sep 19 17:10 sql_history
drwx------ 5 cgagnon users 4.0K Sep 19 17:11 sql_workspaces
➜  workbench find ~/.mysql -iname wb_options.xml
➜  workbench cat /etc/lsb-release 
LSB_VERSION=1.4
DISTRIB_ID=Arch
DISTRIB_RELEASE=rolling
DISTRIB_DESCRIPTION="Arch Linux"
➜  workbench
[20 Sep 2017 15:40] MySQL Verification Team 
Thank you for the bug report. Verified because CentOS 7 presents the issue reported here.
[20 Sep 2017 21:26] Charles Gagnon 
As a workaround, is there a place where I can download the wb_options.xml file to edit it manually? 

When starting the workbench, if I add an empty wb_options.xml, it tries to parse it (I do get an error about not being able to parse the xml since I don't know the xml structure).
[20 Sep 2017 21:26] Charles Gagnon 
As a workaround, is there a place where I can download the wb_options.xml file to edit it manually? 

When starting the workbench, if I add an empty wb_options.xml, it tries to parse it (I do get an error about not being able to parse the xml since I don't know the xml structure).
[20 Nov 2018 13:19] Christian Hesse 
Please check your locale settings. WB does not save its preferences with invalid, unset or unavailable locales.

We had a similar downstream bug:
https://bugs.archlinux.org/task/56213