[egenix-users] Missing eGenix mxODBX Database Connection object

M.-A. Lemburg mal at egenix.com
Mon Jun 14 11:10:49 CEST 2010


[Please keep the mailing list on CC]

Nathan Friend wrote:
> OK so from the command line I need to run *./zopectl stop* and then
> run *.zopectl
> fg *?

You need to open a console, change to the Zope instance directory
and then run:

bin/zopectl fg start

This will print out any error messages that may be relevant
in your case.

E.g. here's an example where the license file expired:

eGenix mxODBC Zope DA: trying iODBC interface... failed: initialization of module mxODBC failed
(mx.ODBC.iODBC.LicenseError:license for mxODBC has expired)
eGenix mxODBC Zope DA: trying unixODBC interface... failed: initialization of module mxODBC failed
(mx.ODBC.unixODBC.LicenseError:license for mxODBC has expired)
eGenix mxODBC Zope DA: No usable mxODBC subpackages found.

Possible reasons:
 * Missing or expired license
 * Missing or unusable iODBC and/or unixODBC installation
 * Mismatch in Python Unicode build version - your Zope
   installation is using: Python 2.4.6 UCS2

> Also what permissions are recommended for /lib/python/mx/ some of the files
> don't have execute bit set.
> 
> drwxr-xr-x 4 plone users   776 2010-06-11 13:32 BeeBase
> -rw-rw-r-- 1 plone users   604 2004-03-15 00:20 COPYRIGHT
> drwxr-xr-x 5 plone users   912 2010-06-11 13:32 DateTime
> drwxr-xr-x 2 plone users   352 2010-06-11 13:32 Doc
> -rw-r--r-- 1 plone users   946 2006-06-30 22:34 __init__.pyc
> -rw-r--r-- 1 plone users   946 2006-06-30 22:34 __init__.pyo
> -rw-rw-r-- 1 plone users   613 2003-08-09 20:26 LICENSE
> -rw-r--r-- 1 plone users 22261 2006-06-30 22:34 Log.pyc
> -rw-r--r-- 1 plone users 22261 2006-06-30 22:34 Log.pyo
> drwxr-xr-x 2 plone users   840 2010-06-11 13:32 Misc
> -rw-r--r-- 1 plone users   587 2006-06-30 22:34 NewBuiltins.pyc
> -rw-r--r-- 1 plone users   587 2006-06-30 22:34 NewBuiltins.pyo
> drwxr-xr-x 7 plone users   552 2010-06-11 13:41 ODBC
> drwxr-xr-x 4 plone users   304 2010-06-11 13:32 Proxy
> drwxr-xr-x 4 plone users   368 2010-06-11 13:32 Queue
> drwxr-xr-x 4 plone users   368 2010-06-11 13:32 Stack
> drwxr-xr-x 6 plone users   368 2010-06-11 13:32 TextTools
> drwxr-xr-x 5 plone users   392 2010-06-11 13:32 Tools
> drwxr-xr-x 4 plone users   288 2010-06-11 13:32 UID
> drwxr-xr-x 4 plone users   416 2010-06-11 13:32 URL

That's fine. Only directories and executables (scripts and
applications) will have the execute bit set.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 14 2010)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2010-07-19: EuroPython 2010, Birmingham, UK                34 days to go

::: Try our new mxODBC.Connect Python Database Interface for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/


> Thanks,
> 
> Nathan.
> 
> On Fri, Jun 11, 2010 at 9:35 PM, M.-A. Lemburg <mal at egenix.com> wrote:
> 
>> Nathan Friend wrote:
>>> Hi,
>>> I'm using version 1.0.10.  In events.log I get a recurring error:
>>>
>>> -----
>>> 2010-06-11T20:26:42 ERROR ZServer uncaptured python exception, closing
>>> channel <ZServer.HTTPServer.zhttp_channel connected 192.168.1.61:30218at
>>> 0x2aaab111a9e0 channel#: 42655 requests:> (socket.error:(32, 'Broken
>> pipe')
>>>
>> [/opt/Plone-2.5.3/Python-2.4.4/lib/python2.4/asynchat.py|initiate_send|219]
>>> [/opt/Plone-2.5.3/lib/python/ZServer/medusa/http_server.py|send|417]
>>> [/opt/Plone-2.5.3/Python-2.4.4/lib/python2.4/asyncore.py|send|332])
>>> ------
>>>
>>> Not sure if its related thought.
>>
>> No, that's not related.
>>
>> When using Zope DA 1.0, you have to open up a console
>> and start Zope/Plone from the command line.
>>
>> The Zope DA 1.0 will then print the debug information to that
>> console.
>>
>> In Zope DA 2.0 we changed that to write to the event log file.
>>
>> Thanks,
>> --
>> Marc-Andre Lemburg
>> eGenix.com
>>
>> Professional Python Services directly from the Source  (#1, Jun 11 2010)
>>>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
>> ________________________________________________________________________
>> 2010-07-19: EuroPython 2010, Birmingham, UK                37 days to go
>>
>> ::: Try our new mxODBC.Connect Python Database Interface for free ! ::::
>>
>>
>>   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
>>    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
>>           Registered at Amtsgericht Duesseldorf: HRB 46611
>>               http://www.egenix.com/company/contact/
>>
>>
>>> Cheers,
>>>
>>> Nathan.
>>>
>>> On Fri, Jun 11, 2010 at 5:31 PM, M.-A. Lemburg <mal at egenix.com> wrote:
>>>
>>>> Nathan Friend wrote:
>>>>> Hello,
>>>>> I've recently installed mxODBC Zope Database adaptor on a test server,
>>>>> everything worked as expected.
>>>>>
>>>>> Today I've attempted to install on a production sever.  When I look in
>>>> the
>>>>> add object list in ZMI I can't find "eGenix mxODBX Database Connection"
>>>>> listed.
>>>>>
>>>>> I've restarted Zope.  Any ideas?
>>>>>
>>>>> Plone 2.5.3
>>>>> Python 2.4.2 (UCS4)
>>>>> Zope 2.9.7
>>>>> SUSE Enterprise Linux 10.1 64-bit
>>>>
>>>> Please check your Zope log for error messages.
>>>>
>>>> Are you using the version 1.0 or version 2.0 of our Zope DA ?
>>>>
>>>> We've only tested (and verified correct operation) of the Zope DA
>>>> 2.0 with Plone 3.3. It may also work with older Plone versions,
>>>> but that's not guaranteed.
>>>>
>>>> Regards,
>>>> --
>>>> Marc-Andre Lemburg
>>>> eGenix.com
>>>>
>>>> Professional Python Services directly from the Source  (#1, Jun 11 2010)
>>>>>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>>>>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>>>>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
>>>> ________________________________________________________________________
>>>> 2010-07-19: EuroPython 2010, Birmingham, UK                37 days to go
>>>>
>>>> ::: Try our new mxODBC.Connect Python Database Interface for free ! ::::
>>>>
>>>>
>>>>   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
>>>>    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
>>>>           Registered at Amtsgericht Duesseldorf: HRB 46611
>>>>               http://www.egenix.com/company/contact/
>>>>
>>>
>>
>>
> 



More information about the egenix-users mailing list