cannot to reopen stdin: No such device or address

[okbob]

cannot to reopen stdin: No such device or address

[okbob]

It is related to this code:

    if (freopen("/dev/tty", "rw", stdin) == NULL)
    {
        fprintf(stderr, "cannot to reopen stdin: %s\n", strerror(errno));
        exit(1);
    }

I am changing to switch from stdin (because it is used in pipe, and it is a change to interactive mode). It looks so command executed in this mode has not a access to tty. Now I have not idea, how it should be fixed.

[okbob]

I am not sure if it is fixed correctly, but it looks like good workaround. Please, test it.

[bjne]

Seems it is still a problem, this time with permission:

cannot to reopen stdin: Permission denied

[okbob]

isn't is selinux issue? Now I cannot to reproduce it.

[bjne]

No selinux

root@roadwarrior:~# echo 'testing 1-2-3'| su postgres -c "pspg"
cannot to reopen stdin: Permission denied

[okbob]

I can reproduce it :-(

[okbob]

I found a workaround, but probably not sure how much is secure or unsecure. You can run tty command instead pspg and you get number of pts device. Then you can allow rights:

[pavel@nemesis pspg-master]$ chmod a+rw /dev/pts/3
[pavel@nemesis pspg-master]$ su - postgres -c "PSQL_PAGER='/usr/local/bin/pspg -s 0' /usr/local/pgsql/bin/psql"

This is working

[bjne]

wow-wow-wow, that is a horrible workaround. The problem is not that I am not able to make
use of pspg, but I think it should work the way I am executing it as well, I think you could accomplish
whatever you want with reopening terminal another way, that will also work with su user -c "pspg"

[okbob]

yes, it is horrible workaround and doesn't work in fresh terminal. I have minimal knowledges about terminals, and I miss some about usage of ptsx

[okbob]

su user -c "pspg" is not problem (not now, because the work with streams are ugly in pspg). In this case I have assigned terminal device in good mode. But when it is executed as nested command from psql, then I have not assigned stdin for interactive mode.

[okbob]

@bjne - please, can you check cda02ea ?

[bjne]

This seems to work, great! Thanks for your attention to fixing!

[okbob]

super