Title
#users-public
a

Andreas Sakellariou

11/18/2022, 10:09 AM
I have installed QuestDB in a Windows server and I need to enable the COPY command. The problem is that I cannot find the server.conf file as suggested by the documentation. There is no such file in the installation directory of QuestDB. Any suggestions?
Nicolas Hourcard

Nicolas Hourcard

11/18/2022, 10:18 AM
Eng team will look at this 👍
a

Andreas Sakellariou

11/18/2022, 10:23 AM
Thanks for your feedback. I am attaching a directory snapshot
Bolek Ziobrowski

Bolek Ziobrowski

11/18/2022, 10:43 AM
Hi @Andreas Sakellariou . How do you run qdb ?
a

Andreas Sakellariou

11/18/2022, 10:46 AM
I have installed qdb as a service which runs in automatic mode
Bolek Ziobrowski

Bolek Ziobrowski

11/18/2022, 10:47 AM
server.conf file will appear in $qdb_instance_root/conf dir . It's not the directory you unzipped qdb tar.gz to .
10:47 AM
If you didn't specify the data dir when installing service it should be
C:\Windows\System32\qdbroot\conf\
a

Andreas Sakellariou

11/18/2022, 10:48 AM
Yes, I located the directory and contains a server.conf file. I suppose my issue has been resolved. May be the default location should be shown in the documentation.
Bolek Ziobrowski

Bolek Ziobrowski

11/18/2022, 10:50 AM
Once you make changes to server.conf please make sure to restart service .
a

Andreas Sakellariou

11/18/2022, 10:50 AM
Noted. Many thanks.
Bolek Ziobrowski

Bolek Ziobrowski

11/18/2022, 10:51 AM
10:52 AM
By default, QuestDB's root directory will be the following: Linux/FreeBSD macOS (Homebrew) Windows C:\Windows\System32\qdbroot
a

Andreas Sakellariou

11/18/2022, 11:13 AM
The link you mentioned shows: C:\Windows\System32\questdb see screenshot:
Amy Wang

Amy Wang

11/18/2022, 11:22 AM
@Andreas Sakellariou thanks - I was looking at this thread and thinking we should update the rootdir in the Get started page too. I will look into this. I will also confirm which folder name is correct.
a

Andreas Sakellariou

11/18/2022, 11:28 AM
Another question: the setting of cairo.sql.copy.root is relative to which root?
Amy Wang

Amy Wang

11/18/2022, 11:31 AM
Is you’re using the
COPY
command for one-off CSV import - https://questdb.io/docs/reference/sql/copy/#root-directory
a

Andreas Sakellariou

11/18/2022, 11:35 AM
It is not clear where the setting "cairo.sql.copy.root=/" is pointing to
Amy Wang

Amy Wang

11/18/2022, 11:49 AM
You will need to set it; it is where your source file is.
m

Myrta

11/18/2022, 12:04 PM
Hey. Thank you for the reply! This path is actually set to cairo.sql.copy.root=/test and the file to COPY is within that folder. But we are still getting the "could not open read-only [file=...]" error.
a

Andreas Sakellariou

11/18/2022, 12:27 PM
Can the setting point to an absolute path like "cairo.sql.copy.root=C😕temp"?
12:59 PM
I will answer myself. Yes cairo.sql.copy.root can point to an absolute path.