Description: I upgraded to LO 6 as a trial (both directly, and via the ubvuntu 17.10 prerelease ppa). On opending my existing Base files that link to Mysql databases requiring password, it did not ask for the password, and was unresponsive. I had to kill it. I tried this in both ubuntu (Xorg) and ubuntu (wayland). Steps to Reproduce: 1.Open a Base file that access Mysql requiring a user name and password 2.The file opens but is unresponsive to any user input 3. Actual Results: I had to kill it Expected Results: Should open and ask for username and password Reproducible: Always User Profile Reset: Yes Additional Info: I tried changing the database access method (using 5.4.4) from Mysql(Native) to Mysql(jdbc) with no success. User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36
The full version (as downloaded, not the ubuntu prerelease ppa version) is: Version: 6.0.0.3 Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: gtk2; Locale: en-GB (en_GB.UTF-8); Calc: group I'm not sure how to provide an example, since all my mysql databases require a user name and password, and would require yourselves to create a similar database. If I find any other way to demonstrate this I will add a post to the report.
I have found out why Base locks up. If most of my databases, I have a macro run when the database is opened, containing: If Not ThisDatabaseDocument.CurrentController.IsConnected Then ThisDatabaseDocument.CurrentController.Connect End If I do this and then open the first form I want to see (often a form selection form). In 6.0.0.3 the Connect locks up and doesn't ask me for the user name and password. Commenting this code out, and not trying to open a form at the start, it works. When I then manually open the first form it does ask me for a user name and password. So this is not a stopper for me, just a nuisance :-)
Created attachment 139710 [details] A sample database This database demonstrates the problem. With previous versions of LO Base the document opens and asks for the user name and password. With version 6 it locks up. The fact that the underlying mysql database doesn't exist on your systems shouldn't matter for the purpose of showing that Base now locks up on the connect statement in the DBOpen macro.
I just test version 6.0.1.1, and the problem persists. Version: 6.0.1.1 Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6 CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: gtk2; Locale: en-GB (en_GB.UTF-8); Calc: group
*** This bug has been marked as a duplicate of bug 114676 ***