Firebird 5.0.1 error on Devuan 5 Daedalus (stable)

[Ismael L. Donis Garcia]

I have tried to install Firebird 5.0.1 on Devuan 5 but so far I have not been able to get it to work properly.

 

It installs correctly and allows adding users, but it gives an error when trying to create, open and restore databases.

 

idonis@pc-ismael:~$ /opt/firebird/bin/isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE '/home/idonis/Documentos/ccs/test.fdb' page_size 8192
CON> user 'SYSDBA' password 'masterke';
Statement failed, SQLSTATE = HY000
operating system directive access failed
-Permission denied
-/tmp/firebird/
SQL>

 

The most intriguing thing is that if I kill the firebird process which runs as the firebird user and run the service from a console with root privileges then it does allow working in firebird.

 

But the user that runs it is root and not firebird.

 

 

 

 

Best Regards

--
Ismael

[Ertan Küçükoglu]

Hello,

I am not very good at Linux but your problem seems to be a permissions issue as you have 

-Permission denied
-/tmp/firebird/

Among your CREATE DATABASE errors. You probably need to give firebird user and group write permission for that directory.

Thanks & Regards,

Ertan

Ismael L. Donis Garcia <sli...@natio.co.cu>, 10 Eyl 2024 Sal, 18:14 tarihinde şunu yazdı:

--
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/AE556BF2C5344A0EB5E57FBE691E9355%40natio.co.cu.

[Ismael L. Donis Garcia]

The /tmp folder is the temporary data folder so the file created by the user, said user is the owner and for this reason has full access to it.

 

Best Regards

--
Ismael

----- Original Message -----

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAH2i4yfGG1xhN%3DJs18qX1yPOLMt6dzHA%3DS0xxBb74vK9RoLZgA%40mail.gmail.com.

[Dimitry Sibiryakov]

Ismael L. Donis Garcia wrote 10.09.2024 17:13:
> I have tried to install Firebird 5.0.1 on Devuan 5 but so far I have not been
> able to get it to work properly.
> It installs correctly and allows adding users, but it gives an error when trying
> to create, open and restore databases.

You must either use network connection to running Firebird server or add
yourself to 'firebird' group. Former is simpler.
Red documentation about connection string paying a special attention to
"embedded mode" words.

--
WBR, SD.

[Ismael L. Donis Garcia]

I can't have a network connection in many cases because it will be used on separate PCs without an Internet connection.

 

I created a virtual PC at my work to test and it doesn't work even with a network connection on the PC.

 

I've been testing at home to later implement it for users. I live in Cuba and there are very few places here that have Internet access, which is why I often delay asking because I have to come to work to be able to send them messages.

 

 

 

Best Regards

--
Ismael

----- Original Message -----

From: "'Dimitry Sibiryakov' via firebird-support" <firebird...@googlegroups.com>

To: <firebird...@googlegroups.com>

Sent: Tuesday, September 10, 2024 12:17 PM

Subject: Re: [firebird-support] Firebird 5.0.1 error on Devuan 5 Daedalus (stable)

> --
> 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/1dade1b1-b87c-455c-8bfa-c6b808784c32%40ibphoenix.com.
>

[Dimitry Sibiryakov]

Ismael L. Donis Garcia wrote 10.09.2024 19:10:
> I can't have a network connection in many cases because it will be used on
> separate PCs without an Internet connection.

Localhost is not dependent on the Internet.

> I've been testing at home to later implement it for users. I live in Cuba and there are very few places here that have Internet access, which is why I often delay asking because I have to come to work to be able to send them messages.

Linux and Firebird documentation is available for download so you can get it
home and read there.

--
WBR, SD.

[Mark Rotteveel]

On 10/09/2024 17:13, Ismael L. Donis Garcia wrote:
> I have tried to install Firebird 5.0.1 on Devuan 5 but so far I have not
> been able to get it to work properly.
> It installs correctly and allows adding users, but it gives an error
> when trying to create, open and restore databases.

> idonis@pc-ismael:~$ <mailto:idonis@pc-ismael:~$> /opt/firebird/bin/isql

> Use CONNECT or CREATE DATABASE to specify a database
> SQL> CREATE DATABASE '/home/idonis/Documentos/ccs/test.fdb' page_size 8192
> CON> user 'SYSDBA' password 'masterke';
> Statement failed, SQLSTATE = HY000
> operating system directive access failed
> -Permission denied
> -/tmp/firebird/
> SQL>

You're creating a database in embedded mode, which means it's using the
permissions of your user account. The error says you can't access
/tmp/firebird, which is probably owned by user firebird and group
firebird. As such, the error indicates you're not a member of the group
firebird. Add yourself to that group.

> The most intriguing thing is that if I kill the firebird process which
> runs as the firebird user and run the service from a console with root
> privileges then it does allow working in firebird.
> But the user that runs it is root and not firebird.

The problem of the screenshot (which BTW, really should have been posted
as text), means you are trying to connect through the Firebird server,
and the user running Firebird (user firebird) does not have permission
to read the files in your home directory (which is a good thing!).

If you want to access files through the server, you should put the files
elsewhere outside your home directory, with permissions granted to user
firebird and group firebird. Or you need to ensure that the group
firebird has sufficient permission to access files in your home
directory (which personally, I wouldn't recommend).

Mark
--
Mark Rotteveel

[Ismael L. Donis Garcia]

I have read and re-read the documentation without any results.

But the same thing works for me in Windows, but not in Linux.

Also, as you can see, flamerobin doesn't work. I don't know if you've ever
tried flamerobin. But it's very easy to use.

I've been using Firebird for several years since version 2.1 and I've never
had a problem with the connection.

I just asked after hours of reading and trying without result.

I'm just asking after hours of reading and trying without success.

If you can install a virtual PC with Devuan 5 so you can see what happens.

One aspect that I didn't mention and that may be affecting it is that Devuan
doesn't use Systemd

Best Regards
--
MSc Ismael Lorenzo Donis Garcia
Especialista en Informática
UEB Industrial
Empresa Agroindustrial Ceballos
Telf. 33237261 Ext 118
Email: sli...@natio.co.cu
Devuan User: http://distrowatch.com/table.php?distribution=devuan
Web Site:
https://gitlab.uic.cu/ismael.donis/sistema-de-contabilidad-general/

----- Original Message -----
From: "'Dimitry Sibiryakov' via firebird-support"
<firebird...@googlegroups.com>
To: <firebird...@googlegroups.com>
Sent: Tuesday, September 10, 2024 1:15 PM
Subject: Re: [firebird-support] Firebird 5.0.1 error on Devuan 5 Daedalus
(stable)

> --
> 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/f39905e2-de3a-48db-9d2b-3529bc7a65c7%40ibphoenix.com.
>

[Dimitry Sibiryakov]

Ismael L. Donis Garcia wrote 10.09.2024 19:32:
> I have read and re-read the documentation without any results.

man 6 path_resolution
man 7 credentials

> Also, as you can see, flamerobin doesn't work. I don't know if you've ever tried flamerobin. But it's very easy to use.

Your problem is not with Flamerobin but Linux basics.

> I've been using Firebird for several years since version 2.1 and I've never had a problem with the connection.

Linux is not Windows.

> If you can install a virtual PC with Devuan 5 so you can see what happens.

We can see what happens even without that. Mark's description was very good.

> One aspect that I didn't mention and that may be affecting it is that Devuan doesn't use Systemd

Completely irrelevant.

--
WBR, SD.

[Ismael L. Donis Garcia]

Perfect Mark.

 

It worked for me here at work. I'm going to try it when I get home.

 

I had the databases in the user folder.

 

But the weird thing is that it doesn't work even when changing the permissions with chmod.

 

 

Best Regards

--
Ismael

----- Original Message -----

From: "'Mark Rotteveel' via firebird-support" <firebird...@googlegroups.com>

To: <firebird...@googlegroups.com>

Sent: Tuesday, September 10, 2024 1:32 PM

Subject: Re: [firebird-support] Firebird 5.0.1 error on Devuan 5 Daedalus (stable)

> /opt/firebird/bin/isql

> --
> 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/24aae97f-336e-450a-b502-bd8f197aef78%40lawinegevaar.nl.
>

[Mark Rotteveel]

On 10/09/2024 19:49, Ismael L. Donis Garcia wrote:
> Perfect Mark.
> It worked for me here at work. I'm going to try it when I get home.
> I had the databases in the user folder.
> But the weird thing is that it doesn't work even when changing the
> permissions with chmod.

What do you mean?

--
Mark Rotteveel

[Ismael L. Donis Garcia]

Mark's already gave me the solution.

It seems that I will have to study Linux more since I tried to change the
permissions with:
chmod -R 777 /home/idonis/Documentos/ccs/*

But without any result. I don't understand that behavior yet.
--
Ismael

----- Original Message -----
From: "'Dimitry Sibiryakov' via firebird-support"
<firebird...@googlegroups.com>
To: <firebird...@googlegroups.com>
Sent: Tuesday, September 10, 2024 1:41 PM
Subject: Re: [firebird-support] Firebird 5.0.1 error on Devuan 5 Daedalus
(stable)

> --
> 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/03f0c38b-543e-4be6-9832-e5620e38801f%40ibphoenix.com.
>

[Scott Morgan]

On 10/09/2024 18:15, 'Dimitry Sibiryakov' via firebird-support wrote:
> Localhost is not dependent on the Internet.

Side note here, but on Windows you can lose 'localhost' resolution
without a net connection. They removed it from the hosts file at some
point, relying on the resolver to return it, but without a connection,
the resolver is off.

127.0.0.1 or ::1 still work, thankfully.

Found this out the hard way, hope it helps others.

Scott

[Mark Rotteveel]

On 10/09/2024 19:55, Ismael L. Donis Garcia wrote:
> Mark's already gave me the solution.
>
> It seems that I will have to study Linux more since I tried to change
> the permissions with:
> chmod -R 777 /home/idonis/Documentos/ccs/*
>
> But without any result. I don't understand that behavior yet.

Don't chmod 777 on files in your user directory! That gives everyone all
permissions.

In any case, to be able to access files in your user directory, the user
(or its group) needs to have +x permission on all intermediate
directories, otherwise they can't access the directory.

Mark
--
Mark Rotteveel

[Mark Rotteveel]

As far as I'm aware that was only an issue back in Windows XP time.

Mark
--
Mark Rotteveel

[Dimitry Sibiryakov]

'Mark Rotteveel' via firebird-support wrote 11.09.2024 9:35:
>> Side note here, but on Windows you can lose 'localhost' resolution without a
>> net connection. They removed it from the hosts file at some point, relying on
>> the resolver to return it, but without a connection, the resolver is off.
>>
>> 127.0.0.1 or ::1 still work, thankfully.
>>
>> Found this out the hard way, hope it helps others.
>
> As far as I'm aware that was only an issue back in Windows XP time.

No, but it is still solved by disabling DHCP media sense.

--
WBR, SD.

[Ismael L. Donis Garcia]

Thanks, I've already had that problem. I just didn't know why.

Nor why it worked by setting it to 127.0.0.1

For me it's a bit inconvenient, because sometimes it works and other times
it doesn't.

Best Regards
--
Ismael
----- Original Message -----
From: "'Scott Morgan' via firebird-support"
<firebird...@googlegroups.com>
To: <firebird...@googlegroups.com>
Sent: Tuesday, September 10, 2024 9:56 PM
Subject: Re: [firebird-support] Firebird 5.0.1 error on Devuan 5 Daedalus
(stable)

> --
> 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/2b250d6e-29a2-4af6-9848-5259f2e634a7%40blueyonder.co.uk.
>

[Ismael L. Donis Garcia]

> From: "'Mark Rotteveel' via firebird-support"
> <firebird...@googlegroups.com>
> To: <firebird...@googlegroups.com>
> Sent: Wednesday, September 11, 2024 3:35 AM

> Subject: Re: [firebird-support] Firebird 5.0.1 error on Devuan 5 Daedalus
> (stable)
>

It also happens with Windows 10

>
> Mark
> --
> Mark Rotteveel
>

Best Regards
--
Ismael

[Dimitry Sibiryakov]

Ismael L. Donis Garcia wrote 11.09.2024 15:15:
> Thanks, I've already had that problem. I just didn't know why.
>
> Nor why it worked by setting it to 127.0.0.1
>
> For me it's a bit inconvenient, because sometimes it works and other times it
> doesn't.

Did you read my previous message?

https://www.google.com/search?q=DHCP+media+sense

--
WBR, SD.

[Scott Morgan]

Not really a solution if a client's machine is locked down by admin, or
worse, they allow it but it gets reset by some random system management
util later on.

Outsourced IT support is hell :)

[Dimitry Sibiryakov]

'Scott Morgan' via firebird-support wrote 11.09.2024 16:35:
>
> Not really a solution if a client's machine is locked down by admin, or worse,
> they allow it but it gets reset by some random system management util later on.

That's why embedded mode and XNET protocol are supported by Firebird.

--
WBR, SD.

[hamacker]

Firebird is a service that use 'firebird' account to access any file, not you.

Please see this video explanation:

https://www.youtube.com/watch?v=w_6ShOVcDz4

--

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/AE556BF2C5344A0EB5E57FBE691E9355%40natio.co.cu.

[Mark Rotteveel]

On 11/09/2024 18:17, hamacker wrote:
> Firebird is a service that use 'firebird' account to access any
> file, not you.
> Please see this video explanation:

> https://www.youtube.com/watch?v=w_6ShOVcDz4 <https://www.youtube.com/
> watch?v=w_6ShOVcDz4>

But not in the first example of the OP, as that used embedded mode, and
thus the access rights of the user running isql.

Mark
--
Mark Rotteveel