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

[Claudio V. C. <cv...@us...>]

Hello, I know security3.fdb is not in place because I'm using the Debug dir:

F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql -user sysdba
-pass masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'user.fdb';
SQL> create user secondary pass 'sec';
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 23
-pass

I thought we would allow PASS as a shortcut for PASSWORD. Anyway:

SQL> create user secondary password 'sec';
Statement failed, SQLSTATE = 08001
unsuccessful metadata update
-CREATE USER SECONDARY failed
-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.
SQL>

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.

C.
---
Claudio Valderrama C.
Consultant, SW developer.