SudoerWithAnOpinion
commented
5 years ago @GeoffMontee: How difficult would it be to ask the error handler to check for SELinux when connections fail, or at least add a note to its output?
Open zimonth opened 6 years ago
SudoerWithAnOpinion
commented
5 years ago @GeoffMontee: How difficult would it be to ask the error handler to check for SELinux when connections fail, or at least add a note to its output?
I was struggling few hours why I couldn't get connection to work to foreign MS SQL server, until I figured and remembered Fedora is SELinux enabled system. It did not allow PostgreSQL server just to make external net connections.
It started to work after: $ sudo semanage permissive -a postgresql_t
There may be a strict tighter way of allowing it (tds-fdw) to work, but right now I'll go with that.
If I google now, it is obvious; there is similar problems with php and freetds, but couldn't find it right away few hours ago, so wrote this note (issue) here also. It can be confusing problem when tds_fdw just says "Permission denied", and you wonder why when you have double checked server/port/user/passwrd/database/schema several times to be correct and working with tsql command.