Download it now!
Bug 106428 - RFE: diagnose non-existent file earlier
Summary: RFE: diagnose non-existent file earlier
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: x86-64 (AMD64) All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Wizard
  Show dependency treegraph
 
Reported: 2017-03-08 04:35 UTC by Terrence Enger
Modified: 2017-11-05 23:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2017-03-08 04:35:36 UTC
Description:
The program could helpfully diagnose a reference to a non-existent firebird database file as soon as the user enters the URL.

Steps to Reproduce:
1. Run soffice with parameter --base
2. In step 1 of database wizard, click "Connect to existing database" and in the dropdown list select "Firebird File".
3. In step 2 of wizard, in datasource url, type a well-formed url for a non-existent file.  My example was
       file:///home/terry/x/bug_10xxxx/bug_106427/thing.fdb
4. Continue and save the new .odb.

Actual Results:  
From step 2 of database wizard, the program proceeds happily.

Upon displaying the main database window, the program presents message (a line split for readability):
    The connection to the data source "thing" could not be established.
    Error code: 1
    firebird_sdbc error:
    *I/O error during "open O_CREAT" operation for file
        "/vista/Users/terry/lo_hacking/notes/bug_106247/thing.fdb"
    *Error while trying to create file
    *No such file or directory
    caused by
    'isc_create_database'


Expected Results:
It would be more helpful for the program to present the message in step two of the database wizard.


Reproducible: Didn't try

User Profile Reset: No

Additional Info:
There is a slightly obscure workaround available.  Menu options Edit > Database > Properties... allow correction (and immediate validation) of the URL.


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Firefox/45.0
Comment 1 Alex Thurgood 2017-03-13 08:05:15 UTC
Confirming on 

Version: 5.4.0.0.alpha0+
Build ID: 6de4ecbe1372c0242f406d45cf999969616f87dc
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.3; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group