Issue 124018

Summary: authentication to database while drag and drop data from calc
Product: Base Reporter: arackhaen
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: elish, issues
Version: 4.0.1Keywords: needhelp
Target Milestone: ---   
Hardware: All   
OS: Linux 64-bit   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description arackhaen 2014-01-12 16:36:59 UTC
When you have data source browser (F4) open with Calc, you can drag and drop data to database. This is great and important functionality. But if you have not authenticated to datasource before, whilst you are like dragging data to datasource's table (to create a new table), whole OOo hangs up. Situation seems pretty clear: OOo starts to request input to database authentication dialog window, but you cannot type anything, because you were in dragNdropping with mouse.
I get out of this by terminating whole OOo process with remote login to host (as whole graphical environment becomes unresponsive, as you were dragNdropping and still you have activated a dialog). I have only tested this on KDE.

How to replicate this:
1. Open Calc and create data to sheet
2. Create registered connection to database, which requires authentication with password
3. Open Data Source Browser with F4 (but do not open "tables" view, so you are still NOT authenticated to datasource)
4. Select data from calc sheet
5. Drag selected data from calc to datasource's "tables" (which would allow you to create a table into database)
6. Now you get authentication window, but you can't interact with it and OOo freezes your KDE environment.
Comment 1 Edwin Sharp 2014-01-12 17:00:42 UTC
How to perform step 2?
Comment 2 arackhaen 2014-01-12 17:12:00 UTC
???

Easy if you use databases.
You need database (mysql,postgres,etc), where to connect to. You will need jar-archives added to your OOo installation to have clients for your db.
Naturally, you also need a username and password to this database.

Then with OOo Base, create data source connection to it (in window that opens when you start OOo Base). When you create connection, in screen that asks for username, type your username and you NEED to check "Requires password" -box.
Comment 3 Edwin Sharp 2014-01-12 18:25:17 UTC
Thank you.
I don't use databases.
Comment 4 arackhaen 2014-01-15 09:27:35 UTC
If it helps anyone capable of handling this, I think this should be connected to OOo Base, instead of Calc, because Data Source Browser is mo related to Base - so changing product to Base.