Re: PlPython with pyodbc error DLL load failed: A dynamic link library (DLL) initialization routine failed.

I try install plpython on PostgreSQL 9.3, Ubuntu 12.04 64bit but it has
error when CREATE EXTENSION plpython3u;
2013-09-27 22:09:26 ICT LOG: database system was shut down at 2013-09-27
22:09:20 ICT
2013-09-27 22:09:26 ICT LOG: database system is ready to accept connections
2013-09-27 22:09:26 ICT LOG: autovacuum launcher started
Traceback (most recent call last):
File "/usr/lib/python3.2/sysconfig.py", line 354, in _init_posix
_parse_makefile(makefile, vars)
File "/usr/lib/python3.2/sysconfig.py", line 240, in _parse_makefile
with open(filename, errors="surrogateescape") as f:
IOError: [Errno 2] No such file or directory:
'/usr/lib/python3.2/config-3.2m/Makefile'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/lib/python3.2/site.py", line 549, in <module>
main()
File "/usr/lib/python3.2/site.py", line 537, in main
known_paths = addusersitepackages(known_paths)
File "/usr/lib/python3.2/site.py", line 269, in addusersitepackages
user_site = getusersitepackages()
File "/usr/lib/python3.2/site.py", line 244, in getusersitepackages
user_base = getuserbase() # this will also set USER_BASE
File "/usr/lib/python3.2/site.py", line 234, in getuserbase
USER_BASE = get_config_var('userbase')
File "/usr/lib/python3.2/sysconfig.py", line 597, in get_config_var
return get_config_vars().get(name)
File "/usr/lib/python3.2/sysconfig.py", line 494, in get_config_vars
_init_posix(_CONFIG_VARS)
File "/usr/lib/python3.2/sysconfig.py", line 359, in _init_posix
raise IOError(msg)
IOError: invalid Python installation: unable to open
/usr/lib/python3.2/config-3.2m/Makefile (No such file or directory)

My python 3.2 is

tuan(at)tuan-VirtualBox:/$ python3.2 --version
Python 3.2.3
tuan(at)tuan-VirtualBox:/$ python3.2 --version
Python 3.2.3
tuan(at)tuan-VirtualBox:/$ python3.2
Python 3.2.3 (default, Apr 10 2013, 06:11:55)
[GCC 4.6.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> exit()
tuan(at)tuan-VirtualBox:/$

On Fri, Sep 27, 2013 at 11:53 AM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:

> If i run import pyodbc from python command and run pyodbc sql command,
> everything work well.
> Please help me.
>
> Tuan Hoang Anh
>
>
> On Fri, Sep 27, 2013 at 10:05 AM, John R Pierce <pierce(at)hogranch(dot)com>wrote:
>
>> On 9/26/2013 8:00 PM, tuanhoanganh wrote:
>>
>>>
>>> I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64
>>> bit. But my plpython function have "ERROR: ImportError: DLL load failed: A
>>> dynamic link library (DLL) initialization routine failed." after import
>>> pyodbc
>>> My Python version is ActivePython-3.2.2.3-win64-**x64, pyodbc version
>>> is pyodbc-3.0.2.win-amd64-py3.2.
>>> On windows 7 SP1 64bit everything run fine.
>>> Please help me. Thanks in advance.
>>>
>>
>> I just heard from a developer friend that a recent windows update broke
>> all KINDA dll-related things with Windows. maybe thats what is happening
>> here. maybe not. he hasn't gotten to the bottom of it yet.
>>
>> --
>> john r pierce 37N 122W
>> somewhere on the middle of the left coast
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>>
>
>