Re: [Firebird-devel] Confusing message when security3 is not found

[Alex P. <pes...@ma...>]

On 02/06/14 10:28, Claudio Valderrama C. wrote:
>> -----Original Message-----
>> From: Alex Peshkoff [mailto:pes...@ma...]
>> Sent: Viernes, 31 de Enero de 2014 10:46
>>
>> On 01/03/14 13:47, Claudio Valderrama C. wrote:
>>
>>> The final part of the path is confusing for the user:
>>> firebird\/security3.fdb
>>>
>>> I don't know if firebird is really looking for
>>> temp/Win32/Debug/firebird//security3.fdb
>>> or only the message contains an extra directory separator.
>>>
>> Fixed.
>> Claudio, please check on windows when you have time.
> I had to comment an assertion in the engine to compile.
>
> Now it's the correct path:
> -I/O error during "CreateFile (open)" operation for file
> "F:\FB3DEV\FBBUILD\FIREBIRD30\TEMP\WIN32\DEBUG\FIREBIRD\SECURITY3.FDB"
> -Error while trying to open file
> -The system cannot find the file specified.
>
> I also did a crazy test in the same session:
>
> SQL> create database 'security3.fdb';
> Commit current transaction (y/n)?y
> Committing.
> SQL> create user secondary password 'sec';
> Statement failed, SQLSTATE = HY000
> unsuccessful metadata update
> -CREATE USER SECONDARY failed
> -bad parameters on attach or create database
> -incompatible security database mode
>
> I think the outcome is expected, but it doesn't depend if I'm running isql
> alone (that runs the embedded engine) or I start firebird with -m -a before
> isql.
>

I know about this bug. Will be fixed soon.