[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Julien Nabet changed: What|Removed |Added Status|NEW |RESOLVED Assignee|libreoffice-b...@lists.free |serval2...@yahoo.fr |desktop.org | Resolution|--- |FIXED --- Comment #16 from Julien Nabet --- Let's put this one to FIXED since the string freeze is finished on 7.2 branch. About specific string for each DBMS, if someone wants to submit a new bugtracker, don't hesitate of course! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #15 from Commit Notification --- Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d4e4e273a5960fcf933729d153de76ecf796aca5 tdf#126624: do at least the generic solution It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Commit Notification changed: What|Removed |Added Whiteboard||target:7.3.0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #14 from Alex Thurgood --- Bug is still present in LO7152, 7204 and LODev73alpha. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #13 from QA Administrators --- Dear Alex Thurgood, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #12 from Lionel Elie Mamane --- (In reply to Alex Thurgood from comment #10) > Ideally, the dialog itself would provide for separate fields for each part > of the connection string and an extra field for supplementary parameters > (where daisychaining of such connection string parameters is allowed), and > would only provide those fields that would correspond to the selected DB > type. In such a case, we could have example resource strings for each type > of DB connection, but we are talking about at least of tens of different DB > engines (certainly all of the main ones out there in use today). It seems to > me that there is currently no way to do this simply (from a UI perspective) > without causing frustration for the end user (...) It *is* possible, it is just more work. It means making a separate dialog for each DBMS, like e.g. MySQL already has. It is completely possible, it just needs work in LibreOffice UI and/or documentation for each DBMS. There are two things in my mind: * the one-line patch that we should do *now* to remove, from the prompt that is used for _all_ DBMS (that don't have a specific UI dialog in LibreOffice), the misleading / wrong example. * the "more work, but better for the user" solution, which would be something like a combination of: - lots of examples in documentation - several DB-specific UI in the LibreOffice "new connection" dialog But anyway, even if we do the "more work better" version, we _still_ need to have a generic fallback for the unknown DBMS, so we _still_ need to do this one-line patch. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #11 from Alex Thurgood --- The irony of the situation in which we find ourselves wrt Java is quite striking, as JDBC drivers seem to be far more prevalent than any other kind of driver in the FOSS world. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #10 from Alex Thurgood --- (In reply to Heiko Tietze from comment #7) > Can't we give a proper example like "127.0.0.1:8001/mydatabase"? And perhaps > split the database name from the url. Ultimately it's also a documentation > topic since help is missing. The problem with the example you suggest is that it is specific to certain kinds of database engine, i.e. it isn't generic enough to work with our current connection string handling. Ideally, the dialog itself would provide for separate fields for each part of the connection string and an extra field for supplementary parameters (where daisychaining of such connection string parameters is allowed), and would only provide those fields that would correspond to the selected DB type. In such a case, we could have example resource strings for each type of DB connection, but we are talking about at least of tens of different DB engines (certainly all of the main ones out there in use today). It seems to me that there is currently no way to do this simply (from a UI perspective) without causing frustration for the end user, which is why having an entirely generic comment like Lionel suggests, or nothing at all, would be more appropriate. Our help files have improved in this regard and do provide the connection strings for at least some (certainly not all) of the DB connection types we support. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #9 from Alex Thurgood --- (In reply to Lionel Elie Mamane from comment #6) > I vote for some very generic text, such as "Connection string", without the > "(e.g. ...)" part. +1 from me for that. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #8 from Xisco Faulí --- Yep, another option would be to have a generic text like in comment 6 + the specific info for each ddbb in the help -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Heiko Tietze changed: What|Removed |Added CC||olivier.hallot@libreoffice. ||org --- Comment #7 from Heiko Tietze --- Can't we give a proper example like "127.0.0.1:8001/mydatabase"? And perhaps split the database name from the url. Ultimately it's also a documentation topic since help is missing. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #6 from Lionel Elie Mamane --- I would rather write "connection string" than "connection URL" since not all databases use URLs; e.g. the new PostgreSQL format does not use an URL. The use of "URL" in the text is probably just inherited from JDBC. I vote for some very generic text, such as "Connection string", without the "(e.g. ...)" part. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Julien Nabet changed: What|Removed |Added CC||heiko.tietze@documentfounda ||tion.org, lio...@mamane.lu --- Comment #5 from Julien Nabet --- Lionel/Xisco/Heiko: what would you prefer between: 1) A very generic comment like "Enter the DB-specific connection URL here" 2) No comment at all 3) Other ? Personally, I agree for no comment at all here. (I remember too that Lionel indicated Postgresql should have its own dialog, I agree of course but that's another story) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #4 from Alex Thurgood --- Alternatively, we could use something like : "Enter the DB-specific connection URL here" but given that removing the string in the first place reduces the number of resource string translations by one, and that that must be a good thing, perhaps it is easier to do that ;-) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #3 from Alex Thurgood --- I agree, removing it would be easier, especially seeing as most of the connection strings can be found elsewhere (help, guides, internet, forums, etc) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 --- Comment #2 from Julien Nabet --- I don't remember why I had done this but no pb to revert it. In fact, I think we should completely remove the example part. Someone who uses Base and needs an URL, knows what he/she does so not a beginner. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||7021 Keywords|regression |bibisected, bisected CC||serval2...@yahoo.fr, ||xiscofa...@libreoffice.org --- Comment #1 from Xisco Faulí --- I don't think this is a regression. It changed in https://cgit.freedesktop.org/libreoffice/core/commit/?id=842812a01c9ff959308a1d373fc5daae10304005 though We can either remove it or add a specific example for each ddbb. @Alex, what do you prefer? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Alex Thurgood changed: What|Removed |Added Component|Base|UI -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126623] JDBC mysql/mariadb connection string parameters wrong in help
https://bugs.documentfoundation.org/show_bug.cgi?id=126623 Olivier Hallot changed: What|Removed |Added Status|UNCONFIRMED |NEW Assignee|libreoffice-b...@lists.free |olivier.hallot@libreoffice. |desktop.org |org Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126623] JDBC mysql/mariadb connection string parameters wrong in help
https://bugs.documentfoundation.org/show_bug.cgi?id=126623 Alex Thurgood changed: What|Removed |Added Component|Base|Documentation CC||olivier.hallot@libreoffice. ||org -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Alex Thurgood changed: What|Removed |Added Keywords||regression -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126624] New: Suggested database connection string parameters incorrect in URL entry dialog
https://bugs.documentfoundation.org/show_bug.cgi?id=126624 Bug ID: 126624 Summary: Suggested database connection string parameters incorrect in URL entry dialog Product: LibreOffice Version: 6.2.0.0.alpha0+ Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ipla...@tuta.io Description: 1) Try to create an ODB file using the DB creation wizard and choose the option JDBC. 2) In the connection string URL entry dialog (above the field for entry of the string), a suggestion is made to use the following string: Datasource URL (e.g. host=$host:$port dbname=$database) This suggestion is completely wrong and will lead to a user spending hours trying to guess what the correct string might be (or trawling the internet for it) Steps to Reproduce: See above Actual Results: Incorrect suggestion for datasource connection parameters leading to failure to establish valid connection Expected Results: The suggestion should either be removed completely, or else tailored to the chosen type of database for which a connection is desired Reproducible: Always User Profile Reset: No Additional Info: -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126623] New: JDBC mysql/mariadb connection string parameters wrong in help
https://bugs.documentfoundation.org/show_bug.cgi?id=126623 Bug ID: 126623 Summary: JDBC mysql/mariadb connection string parameters wrong in help Product: LibreOffice Version: 6.2.0.0.alpha0+ Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ipla...@tuta.io Description: Using the DB creation wizard, try to create a connection to a mysql or mariadb database server via the JDBC option in the first dialog. The URL connection parameter window is preceded by jdbc: The help indicates that the complete string to enter here is jdbc:mysql://networkaddress:port/dbname?anyotherparameters However, the documentation is incorrect in the current iteration of that JDBC configuration dialog. In fact, the user now only has to enter mysql://networkaddress:port/dbname?anyotherparameters The documentation should be corrected in this respect. Steps to Reproduce: See above Actual Results: The help indicates the incorrect string to enter, and as a result, connection will fail, and the user will be unable to setup a valid ODB file. Expected Results: The documentation should reflect the current requirements for string entry Reproducible: Always User Profile Reset: No Additional Info: -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
Re: string parameters
Before you dive deeper in the code, Lubos made a great job to simplify the use of RTL_CONSTASCII_USTRINGPARAM, you should read this : http://nabble.documentfoundation.org/RTL-CONSTASCII-U-STRINGPARAM-officially-obsolete-tp3881536p3881536.html Ah, I've already seen this mail, but just missed that part: functionFoo( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(X))) can be written as functionFoo( X ); So, the problem is already solved, right ? cu ___ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
