Issue Details (XML | Word | Printable)

Key: CORE-3534
Type: Improvement Improvement
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Popa Adrian Marius
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

rename isql tool to isql-fb , fbsql , firebirdsql

Created: 23/Jun/11 01:29 PM   Updated: 23/Jun/11 04:43 PM
Component/s: ISQL
Affects Version/s: 3.0 RC2
Fix Version/s: None

Environment: Linux


 Description  « Hide
on any type of linux firebird isql utility conflicts with the isql from odbc , the solution is the rename the utility to something more userfriendly
like firebirdsql or fbsql (for mysql the utility is mysql , for postgresql is psql ...)

Here is what usually happens on Linux sistems : Ubuntu
./run_full.sh
start test FB3_transition
CREATE DATABASE


**********************************************
* unixODBC - isql *
**********************************************
* Syntax *
* *
* isql DSN [UID [PWD]] [options] *
* *
* Options *
* *
* -b batch.(no prompting etc) *
* -dx delimit columns with x *
* -x0xXX delimit columns with XX, where *
* x is in hex, ie 0x09 is tab *
* -w wrap results in an HTML table *
* -c column names on first row. *
* (only used when -d) *
* -mn limit column display width to n *
* -v verbose. *
* -lx set locale to x *
* -q wrap char fields in dquotes *
* -3 Use ODBC 3 calls *
* -n Use new line processing *
* --version version *
* *
* Commands *
* *
* help - list tables *
* help table - list columns in table *
* help help - list all help options *
* *
* Examples *
* *
* isql WebDB MyID MyPWD -w < My.sql *
* *
* Each line in My.sql must contain *
* exactly 1 SQL command except for the *
* last line which must be blank (unless *
* -n option specified). *
* *
* Please visit; *
* *
* http://www.unixodbc.org *
* pharvey@codebydesign.com *
* nick@easysoft.com *
**********************************************


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dimitry Sibiryakov added a comment - 23/Jun/11 01:39 PM - edited
For the same reason ODBC isql should be renamed to osql... Have you posed the ticket to ODBC tracker too?
In the name conflict with Mozilla Firebird won. Why should it surrender to ODBC?..

Philippe Makowski added a comment - 23/Jun/11 01:48 PM
isql is not the only collision
gstat confilct with ganglia-gmond (rh #515510)

packagers of each distro take care of that
under Fedora, RHEL, Centos, Mandriva, Mageia, OpenSuse in /usr/bin you have isql-fb and gstat-fb
under Debian /usr/bin/fbstat and /usr/bin/isql-fb
but yes it could simplify the job


Popa Adrian Marius added a comment - 23/Jun/11 01:53 PM
Well the problem is easy to fix on our side and it's easy to fix this conflict , at least on debian we renamed it from isql to isql-fb but long term solution is to have a consistent named console utility (brains expects fbsql or firebirdsql)

Also we do have a conflict with TDS that includes isql utility
also with microsoft and sybase with their isql utility
http://msdn.microsoft.com/en-us/library/aa214007(v=sql.80).aspx


Sean Leyne added a comment - 23/Jun/11 03:33 PM
I do not recall any discussion about renaming isql to isql-fb!

It is not appropriate for the port maintainers to rename any of the project files, without the express approval of the project admins.

Philippe Makowski added a comment - 23/Jun/11 03:57 PM
Sean, please
Distro have rules and conflicts are avoid, and about conflict into distro package first packaged often win
that's all
so if we (packager) want firebird into distro, we have to follow the rules, and express approval of the project admins is not need, because /usr/bin/isql-fb and /usr/bin/gstat-fb are only symlinks to isql and gstat (for example under Mageia /usr/bin/isql-fb can be a symink to usr/lib/firebird/bin-classic/isql )

now, if you want to package under various distro, you're welcome



Popa Adrian Marius added a comment - 23/Jun/11 04:03 PM
There were many discussions in the past just one notice
http://firebird.1100200.n4.nabble.com/isql-rename-to-fbsql-td1119801.html
and many others

Debian and other distros must make small changes and symlinks so the files should not conflict when installed from packages
If is decided we can rename/symlink back to fb-* firebird* or *-fb

ps: of we would wait for comitee many years would pass without doing nothing

Sean Leyne added a comment - 23/Jun/11 04:15 PM
Guys, let use clear language!!!

Creating symlinks and *renaming* the binary are NOT the same thing!

If it was clearly been outlined that the current distros maintainers have created symlinks to meet rules of the linux masters, then I would have been fine with that.

(No, I didn't recall the mail thread from *2007*!!!)

Philippe Makowski added a comment - 23/Jun/11 04:18 PM
Marius please stop
Committee have nothing to do with that
as said Roman in the thread :
But anyway, decision to change the names of the utilities is a major one
and requires long talk here or in fb-architect before any changes are made.

That's a project and admin team decision, not in Foundation's hand


Popa Adrian Marius added a comment - 23/Jun/11 04:43 PM
Ok i stop , i missunderstood who votes on what (i thought that foundation will vote)
I will start a thread on architect then