You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/01/12 17:36:59 UTC
[Bug 124018] New: authentication to database while drag and drop
data from calc
https://issues.apache.org/ooo/show_bug.cgi?id=124018
Bug ID: 124018
Issue Type: DEFECT
Summary: authentication to database while drag and drop data
from calc
Product: Calc
Version: 4.0.1
Hardware: All
OS: Linux64
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: issues@openoffice.apache.org
Reporter: arackhaen@gmail.com
CC: issues@openoffice.apache.org
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124018] authentication to database while drag and drop data
from calc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124018
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |needhelp
--- Comment #3 from Edwin Sharp <el...@apache.org> ---
Thank you.
I don't use databases.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124018] authentication to database while drag and drop data
from calc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124018
arackhaen@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Component|ui |code
Product|Calc |Base
--- Comment #4 from arackhaen@gmail.com ---
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124018] authentication to database while drag and drop data
from calc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124018
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |elish@apache.org
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
How to perform step 2?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124018] authentication to database while drag and drop data
from calc
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124018
--- Comment #2 from arackhaen@gmail.com ---
???
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.