https://bugs.documentfoundation.org/show_bug.cgi?id=148192
--- Comment #16 from [email protected] --- (In reply to Robert Großkopf from comment #15) > (In reply to jcsanz from comment #14) > > Comment on attachment 179137 [details] > > Connection to localhost Ubuntu Linux KDE > > > > As can see in the image the connection is established by server, and not by > > user JC whom haven't rights on the /data folder > > OK, could connect this way. > Server config file here says > DatabaseAccess = Restrict /srv/firebird > so the path in OpenSUSE will be localhost:/srv/firebird/externtest.fdb > > Thanks for this tests! > > This path isn't available in normal way through the GUI of a user. So it > couldn't be fund by the database wizard, if I browse through my system. And > server will only be available in this path, which is also be set by the > system for all Firebird data files, which will connect to the server. > It depends on the configuration. I restricted all rights just to test, but it is possible allow read and/or execution to all users, but usually is not a good idea. > If we will offer this option also the connector to server database should > → connect to localhost directly, means he must read the path for data from > the Firebird server (DatabaseAccess) Not necessarily, according with documentation, firebird can establish tree different kinds o connections, and the kind depends on the connection string: -- if you use "file://..." you establish a embedded (serverless) connection, just as you do before ver 7.3. In this case you can navigate and create a database file in anywhere you have rights (may be your /home folder) -- if you use "localhost[/port]:..." you establish a loopback connection through the server -- if you use "ServerName[/port]:..." you establish a remote connection, also if you are in the same computer than the server > → allow all user-management as it is possible through JDBC I hope the same in "direct" connection too > → must also connect to a server, which will allow to open files in Firebird > versions like Firebird 4.0 > > The internal driver will produce an error with Firebird 4 files. yes, this is a limitation, the internal driver is ver 3 >But the > internal databases won't be changed from Firebird 3 to Firebird 4. (I think it could be changed but not tested by now) > Databases, which have been used by other people, should be also usable in > future. So it could be we need different drivers for the internal and the > external server database. May be only offer the possibility of a backup/restore that is the usual way of migrate old to new database format > > At this moment the only database, which could be created without problems, > using the wizard, is the simple external file. And this should be available > under "Create database", not under "Connect to an existing database". Yes, completely agree with this -- You are receiving this mail because: You are the assignee for the bug.
