Error with FB 3.12

[Michel Le Clézio]

Hello ,

I've created a database under Firebird 3.012.

I create a table. When I want to open the table or try to add a record I've got this message :

https://www.mesotech-ingenierie.fr/anc_maj_mlc/index_ROLMRE_XLS.html

can't format message 13.98--message file C:\Windows\System32\firebird.msg not found

Use of external file at location C:\Windows\System32\COM_SERVICES is not allowed by server configuration

------------------

SQL CODE : -902

SQLSTATE : 28000

GDSCODE : 33544831

I'm under WIN10 with Norton 360...

How can I fix this , Please ?

With best regards,

Mike.

[Dimitry Sibiryakov]

Michel Le Clézio wrote 12.09.2024 11:57:
> Use of external file at location C:\Windows\System32\COM_SERVICES is not allowed
> by server configuration
> ------------------
> SQL CODE : -902
> SQLSTATE : 28000
> GDSCODE : 33544831
>
> I'm under WIN10 with Norton 360...
>
> How can I fix this , Please ?

Don't put external files into Windows system direction. Ask your
administrator to find a suitable place and configure it in firebird.conf.

https://firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-ddl-table.html#fblangref30-ddl-tbl-external

--
WBR, SD.

[Mark Rotteveel]

This suggests you have an external table defined which wants to read
from or write to the file C:\Windows\System32\COM_SERVICES. You
shouldn't want to fix this.

It is not OK to give access to files in C:\Windows\System32\ to the
Firebird process, especially not as external tables, as it is
potentially exploitable to read all files from there, or worse, create
new files there, which could lead to injection of malware.

Mark
--
Mark Rotteveel

[Michel Le Clézio]

Hello Dimitry,

I've just created a simple table without external files :

CREATE TABLE NEW_TABLE EXTERNAL 'COM_SERVICES' (

    NEW_FIELD  INTEGER

);  

and the problem was the use of EXTERNAL...

I've wrote like this :

CREATE TABLE COM_SERVICES (

    NEW_FIELD  INTEGER

);

no problems, now ! :)

Big thank you for your help.

With best regards,

Mike.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/dc54fb49-9336-41ba-b6d0-c4f4c968bab7%40ibphoenix.com.

[Virgo Pärna]

On 12.09.2024 13:30, Michel Le Clézio wrote:
> Hello Dimitry,
>
> I've just created a simple table without external files :
> CREATE TABLE NEW_TABLE EXTERNAL 'COM_SERVICES' (
>     NEW_FIELD  INTEGER
> );
>

from documentation:

"CREATE [GLOBAL TEMPORARY] TABLE tablename
[EXTERNAL [FILE] 'filespec']
..."
....
"File specification (only for external tables). Full file name and path,
enclosed in single quotes, correct for the local file system and located
on a storage device that is physically connected to Firebird’s host
computer."

You are supposed to use filename there... 'COM_SERVICES' as a filename
means that file on the current directory of Firebird service. ANd since
it runs as System, current directory is C:\Windows\system32

So you need to use full filename

--
Virgo Pärna
Gaiasoft OÜ
vi...@gaiasoft.ee