On 27/05/2020 17:54, Mark Rotteveel wrote:
>
> Not having users at all is just a special case of not having the right
> username or password. The error for the end-user should be the same in
> both cases.
>
> That the administrator gets the same error when he tries to login is not
> really a pro
On 27-05-2020 22:25, Vlad Khorsun wrote:
Then they will get the normal 'Your user name and password are not
defined. Ask your database administrator to set up a Firebird login.'
error, instead of this confusing error.
It is discussed in this thread and I see no success there.
I'm not sure
On 27-05-2020 16:31, Emil Totev wrote:
It seems that it is only possible to CAST() from/to boolean as
char/varchar (values 'TRUE' and 'FALSE'), and the same also applies to
the new SET BIND OF BOOLEAN TO type-to.
Is this restricted by the SQL standard? Wouldn't it also make sense to
be able t
27.05.2020 23:04, Mark Rotteveel wrote:
On 27-05-2020 18:16, Vlad Khorsun wrote:
27.05.2020 17:11, Mark Rotteveel wrote:
On 2020-05-27 13:35, Vlad Khorsun wrote:
27.05.2020 14:29, Dimitry Sibiryakov wrote:
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more inf
On 27-05-2020 22:04, Mark Rotteveel wrote:
I don't think creating random user just to create plugin tables is
good idea.
I wasn't suggesting to create a random plugin, [..]
I meant to say "random user"...
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://list
On 27-05-2020 21:23, Hugo Eyng | Datamais wrote:
Currentelly I am using FB 2.5.9 in Windows 7, 10, 2008, 2012, 2016, 32
and 64 bits.
I will star testing FB 4.
Is there some document or "guide" describing better pratices, what to
care about, what to avoid, best architeture (Classic, SuperClass
On 27-05-2020 18:16, Vlad Khorsun wrote:
27.05.2020 17:11, Mark Rotteveel wrote:
On 2020-05-27 13:35, Vlad Khorsun wrote:
27.05.2020 14:29, Dimitry Sibiryakov wrote:
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more informative for end user,
show waht to do to
Hello.
Currentelly I am using FB 2.5.9 in Windows 7, 10, 2008, 2012, 2016, 32 and
64 bits.
I will star testing FB 4.
Is there some document or "guide" describing better pratices, what to care
about, what to avoid, best architeture (Classic, SuperClassic, SuperServe)
and other important informat
27.05.2020 18:16, Vlad Khorsun wrote:
But how it will solve problem of missing SYSDBA ?
Is it a problem? I'm sure it was said to be a feature, improved security, etc.
How it will solve issue of end user who can't login ?
Next auth plugin in list will be tried. May be even successfully.
27.05.2020 15:14, Adriano dos Santos Fernandes wrote:
On 27/05/2020 08:56, Vlad Khorsun wrote:
isc_missing_data_structures is former
Install incomplete, please read the Compatibility chapter in the
release notes for this version
It could be changed to:
To complete security database initializa
27.05.2020 17:11, Mark Rotteveel wrote:
On 2020-05-27 13:35, Vlad Khorsun wrote:
27.05.2020 14:29, Dimitry Sibiryakov wrote:
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more informative for end user,
show waht to do to fix error and refers to the documentation
It seems that it is only possible to CAST() from/to boolean as char/varchar
(values 'TRUE' and 'FALSE'), and the same also applies to the new SET BIND
OF BOOLEAN TO type-to.
Is this restricted by the SQL standard? Wouldn't it also make sense to be
able to cast /set bind of booleans to any numeric
On 2020-05-27 13:35, Vlad Khorsun wrote:
27.05.2020 14:29, Dimitry Sibiryakov wrote:
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more informative for end
user,
show waht to do to fix error and refers to the documentation only in
order to get a full explanation
On 2020-05-27 14:47, Dimitry Sibiryakov wrote:
27.05.2020 13:42, Alex Peshkoff via Firebird-devel wrote:
But that will do things even more obscure - every user will get
regular message about illegal login/password.
And that's right:
1. It try to login as SYSDBA and get "user not defined" er
On 27/05/2020 08:56, Vlad Khorsun wrote:
>
>
> isc_missing_data_structures is former
> Install incomplete, please read the Compatibility chapter in the
> release notes for this version
>
> It could be changed to:
> To complete security database initialization, please create user using
> @1 or read
27.05.2020 14:33, Alex Peshkoff via Firebird-devel wrote:
On 2020-05-27 14:26, Vlad Khorsun wrote:
27.05.2020 10:58, Alex Peshkoff via Firebird-devel wrote:
On 2020-05-26 19:16, Ivan Přenosil wrote:
Not sure where to report this one ...
When trying to work with uninitialized security database
Another confusing thing about this error is that if server is open, it's
using security database and one cannot attach to it with embedded to
create SYSDBA.
It would be good if server detaches from security when it cannot use, so
the server will not be needed to be closed to create the user with e
27.05.2020 13:42, Alex Peshkoff via Firebird-devel wrote:
But that will do things even more obscure - every user will get regular message about
illegal login/password.
And that's right:
1. It try to login as SYSDBA and get "user not defined" error.
2. It look to list of users and see no SYSD
27.05.2020 14:40, Dimitry Sibiryakov wrote:
27.05.2020 13:35, Vlad Khorsun wrote:
Engine can't add SYSDBA with known to user (DBA) password.
Engine knows nothing about user manager providers.
And that's ok, it can return usual "Your user name or password is not
defined" error.
It is
On 2020-05-27 14:34, Dimitry Sibiryakov wrote:
27.05.2020 13:31, Alex Peshkoff via Firebird-devel wrote:
It does not know what sysdba password to use.
That's fine, let it just create the security database and data
structures but not the user.
But that will do things even more obscure -
27.05.2020 13:35, Vlad Khorsun wrote:
Engine can't add SYSDBA with known to user (DBA) password.
Engine knows nothing about user manager providers.
And that's ok, it can return usual "Your user name or password is not
defined" error.
BTW, isn't whole authentication the server's thing not
27.05.2020 14:29, Dimitry Sibiryakov wrote:
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more informative for end user,
show waht to do to fix error and refers to the documentation only in
order to get a full explanation.
May be it would be better if the eng
27.05.2020 13:31, Alex Peshkoff via Firebird-devel wrote:
It does not know what sysdba password to use.
That's fine, let it just create the security database and data structures but
not the user.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/li
On 2020-05-27 14:26, Vlad Khorsun wrote:
27.05.2020 10:58, Alex Peshkoff via Firebird-devel wrote:
On 2020-05-26 19:16, Ivan Přenosil wrote:
Not sure where to report this one ...
When trying to work with uninitialized security database in FB4 the
server will raise error, e.g.
SQL> connect 'lo
On 2020-05-27 14:29, Dimitry Sibiryakov wrote:
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more informative for end user,
show waht to do to fix error and refers to the documentation only in
order to get a full explanation.
May be it would be better if the e
27.05.2020 13:26, Vlad Khorsun wrote:
In my opinion, the message should be more informative for end user,
show waht to do to fix error and refers to the documentation only in
order to get a full explanation.
May be it would be better if the engine finish initialization instead of throwing
27.05.2020 10:58, Alex Peshkoff via Firebird-devel wrote:
On 2020-05-26 19:16, Ivan Přenosil wrote:
Not sure where to report this one ...
When trying to work with uninitialized security database in FB4 the server will
raise error, e.g.
SQL> connect 'localhost/:Z:\x.fdb' USER SYSDBA PASSWOR
27.05.2020 10:01, Mark Rotteveel wrote:
Shouldn't the filename be last?
No, the command line is fine. I've just created a pull request that fix it.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
26.05.2020 18:20, Vlad Khorsun wrote:
26.05.2020 18:11, Ivan Přenosil wrote:
When I give wrong backup file to NBACKUP.exe -INPLACE, error is reported as
expected:
NBACKUP -inplace -restore localhost/:Z:\export\TESTF2.FDB Z:\export\x05G.nbk
Invalid incremental backup file: Z:\export\x05G.nb
NBACKUP locks db file on error
--
Key: CORE-6319
URL: http://tracker.firebirdsql.org/browse/CORE-6319
Project: Firebird Core
Issue Type: Bug
Components: NBACKUP
Affects Versions: 4.0 Beta 2
On 2020-05-26 23:13, Ivan Přenosil wrote:
I am testing new include_data switch in FB4 Beta2. Any idea what am I
doing wrong?
All these commands seem to work, except the last one which raises the
exception:
GBAK -b -user sysdba -password masterkey localhost/:Z:\xx.FDB
Z:\xx.fbk -skip_data a
On 2020-05-26 19:16, Ivan Přenosil wrote:
Not sure where to report this one ...
When trying to work with uninitialized security database in FB4 the
server will raise error, e.g.
SQL> connect 'localhost/:Z:\x.fdb' USER SYSDBA PASSWORD 'masterkey';
Statement failed, SQLSTATE = 28000
Inst
32 matches
Mail list logo