Apache OpenOffice (AOO) Bugzilla – Issue 22718
endless database login messages when open lable document
Last modified: 2017-05-20 11:19:47 UTC
I created a set of mailing labels from a mysql datasource. I then printed the labels, saved them for later use, and closed the document. When I went in to reopen the labels, the following happened. 1. The program asked me to update all links. I clicked yes 2. The program then popped up a username and password request to my datasource. I entered my username and password. 3. An hour glass appeared for a couple of seconds, and then the screen popped back up again. The saved document never opened no matter how many times that I entered my username and password. I confirmed that MySQL was running on my computer and confirmed my username and password by getting into MySQL from the command line. Also, I am able to open and save and reopen mail merge letters from the same datasource. I can also make a fresh set of labels from the label autopilot for the datasource. I just can't save and reopen the labels. Vaughn L. Reid III
I seem to get the same result of not being able to re-open the document after saving, closing, and reopening regardless of whether I add data fields during the label auto-pilot creation dialog box, or if I add them after creating a new blank set of labels from the auto-pilot. I'm creating Avery Letter Size 5160 labels. Also, I noticed that, when I add the datasource fields during the label auto-pilot, not all of my records print. When I add the labels manually after closing the auto-pilot, all of my records print. In addition, when I get the prompt asking for my username and password on reopening. OpenOffice locks up and I have to do a ctrl + alt + del to end the program. Vaughn L. Reid III
correcting sub component (see http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access, please), and default owner
Created attachment 12374 [details] bugdoc to reproduce this issue
Hi, I can reproduce this. 1. create a new datasource called "Data source 2" via TOOLS/DATASOURCE 2. type is jdbc 3. on the jdbc tabpage check the "Password required" checkbox. 4. open the attached document 5. answer the "Update all links" with YES 6. a password dialog pops up. ==>> you can't cancel the dialog This problem occurr everytime when you try to connect to a datasource with is not reachable. Set Component to word processor and send to the right developer. Bye Marc
This password box is not a Writer password but a database password. What does Writer do wrong here?
It requests the same connection too often, even if already the first request failed. We, in DBA, cannot do anything - if somebody requests a connection, we have to try to provide it. We cannot remotely know in which situations we could silently ignore this request. However, the Writer *can* know this - during a field update (and not longer), Writer should request every connection only once - if the first request fails, it should not do additionaly request, until the field update is done.
.
Reset assigne to the default "issues@openoffice.apache.org".