Connecting to DB with any user/password [CORE6493] #6723
Comments
|
Commented by: @mrotteveel This is expected behaviour as you're connecting using Firebird Embedded as you only specify a database path, not a host name and database path. Connecting with Firebird Embedded, since Firebird 3, does not check passwords on Linux any more (see https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-compat-embedded). See also my answer on StackOverflow: https://stackoverflow.com/questions/66301920/i-can-log-into-a-firebird-3-database-with-any-user-and-password |
|
Commented by: @mrotteveel Please use the firebird-support Google Group (https://groups.google.com/g/firebird-support) for support questions. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Haik Hairapetyan (haik_h)
In a newly created database, I don't get any error message when I connect to the DB with the wrong user and password (the users TTT and AAA don't even exist)
[root@fewww bin]# ./isql /opt/db/treewww/ftree.db -user ttt -password bbb;
Database: /opt/db/treewww/ftree.db, User: TTT
SQL> exit;
[root@fewww bin]# ./isql /opt/db/treewww/ftree.db -user aaa -password ccc;
Database: /opt/db/treewww/ftree.db, User: AAA
SQL> SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database;
RDB$GET_CONTEXT
3.0.2
At the same time, I get a 'regular' error message in another database when I try to connect the DB with the wrong credentials:
[root@fewww bin]# ./isql /opt/db/testwww/ftest.db -user aaa -password ddd
Statement failed, SQLSTATE = 08001
I/O error during "lock" operation for file "/opt/db/testwww/ftest.db"
-Database already opened with engine instance, incompatible with current
Use CONNECT or CREATE DATABASE to specify a database
Could you please explain the matter?
Thank you.
The text was updated successfully, but these errors were encountered: