Re: Problem with pl/python procedure connecting to the internet

On 08/23/2015 10:38 AM, Igor Sosa Mayor wrote:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>
>>> I tried both... in my system (archlinux) there is plpython2u and
>>> plpythonu. I think the 2nd one is python3.
>>
>> How did they get there?
>>
>> Or more to the point how where they built?
>
> just installed with postgresql which comes with archlinux. I did not
> built anything. But, really: I dont think the problem is plpython2u o 3:
> 1. I have in my system both and both have the same libraries (in this
> case, geopy);
> 2. other procedures with plpython (2 or 3) which DO NOT CONNECT to the
> internet work perfectly.
>
> The problem is the connection, either the setup in my laptop or the
> setup in my network (but I get the same problem at home and at work...)

You are using the same machine, the laptop, in both locations, correct?

If so then the problem is some sort of access control issue.

When you try an INSERT, what shows in?:

1) The Postgres logs.

2) The system log.

>
>> What happens if you change your geocodificar to use plpythonu?
>
> exactly the same. I tested all combinations...
>
> (thanks again!)
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com