[egenix-users] Zope stops to respond
M.-A. Lemburg
mal at egenix.com
Wed Oct 11 23:33:10 CEST 2006
Marcos Iuato wrote:
> Hi,
>
> unixODBC + FreeTDS seems to be working, testing with isql
>
> debian:/etc# isql mssql samurai samurai
> +---------------------------------------+
> | Connected! |
> | |
> | sql-statement |
> | help [tablename] |
> | quit |
> | |
> +---------------------------------------+
> SQL> select count(*) from a_class
> +------------+
> | |
> +------------+
> | 85 |
> +------------+
> 1 rows affected
> 1 rows returned
> SQL>
>
>
> At ZMI the eGenix mxODBC Database Connection connects succesfull to the
> database, but when I run any query, it blocks all threads and zope
> doesnt respond anymore. I don't know where could be the problem, could
> someone give me some directions?
It is likely that one of the ODBC calls to unixODBC/FreeTDS blocks
and doesn't return for some reason.
If you run unixODBC in trace mode, you should be able to see which
ODBC call does not return. This might be a firewall issue or a DNS
problem on the client and/or server side.
FWIW, we have FreeTDS running with SQL Server 2k. Even though we don't
recommend using FreeTDS's ODBC driver and recommend other drivers
for this combination instead, we do test this setup.
> Thanks in advance,
> Marcos Iuato
>
>
> Marcos Iuato escreveu:
>> Hi Jean,
>>
>> I have installed the unixodbc-bin and freetds-dev, and made the
>> configurations changes that you suggested, but it still not working.
>> How can I debug that problem? Could somebody points some directions?
>>
>> debian:/etc# dpkg -l|grep MS
>> ii freetds-dev 0.61-6.2 MS SQL and Sybase client library
>> (static lib
>> ii libct1 0.61-6.2 libraries for connecting to MS SQL
>> and Sybas
>> ii libsybdb3 0.61-6.2 libraries for connecting to MS SQL
>> and Sybas
>> ii mtools 3.9.9-2.1 Tools for manipulating MSDOS files
>> ii sqsh 2.1-6 commandline SQL client for MS SQL
>> and Sybase
>>
>> debian:/etc# dpkg -l|grep odbc
>> ii gtkodbcconfig0 2.2.4-11 GTK-based ODBC configuration library
>> ii libodbcinstq1 2.2.4-11 Qt-based ODBC configuration library
>> ii odbcinst1 2.2.4-11 Support library and helper program
>> for acces
>> ii unixodbc 2.2.4-11 ODBC tools libraries
>> ii unixodbc-bin 2.2.4-11 Graphical tools for ODBC management
>> and brow
>> ii unixodbc-dev 2.2.4-11 ODBC libraries for UNIX (development
>> files)
>>
>> Thanks in advance,
>> Marcos Iuato
>>
>> BALTUS Jean escreveu:
>>
>>> Hi,
>>> Install the development package for freetds (and unix-odbc-bin?):
>>>
>>> apt-get -V install unixodbc
>>> apt-get -V install unixodbc-bin
>>> apt-get -V install freetds-dev
>>>
>>> Also, in the freetds.conf file, you can add:
>>> client charset = strip high-order byte
>>>
>>> Try to create a odbcinst.ini file :
>>> [FreeTDS]
>>> Description = TDS driver (Sybase/MS SQL)
>>> Driver = /usr/lib/odbc/libtdsodbc.so
>>> Setup = /usr/lib/odbc/libtdsS.so
>>> CPTimeout = CPReuse = FileUsage = 1
>>>
>>> And in your odbc.ini file, use the 'FreeTDS' entry that you created in
>>> odbcinst.ini :
>>>
>>> [mssql]
>>> Driver = FreeTDS
>>> Description = MS SQL running on monet
>>> Trace = No
>>> Servername = MONET
>>> Database = AfariaDB
>>>
>>> On our Debian server, it did the trick...
>>>
>>> -- Jean Baltus
>>>
>>>
>>> -----Original Message-----
>>> From: egenix-users-bounces at egenix.com
>>> [mailto:egenix-users-bounces at egenix.com] On Behalf Of Marcos Iuato
>>> Sent: mardi 10 octobre 2006 19:10
>>> To: egenix-users at egenix.com
>>> Subject: [egenix-users] Zope stops to respond
>>>
>>> I am trying to connect from a linux machine to a MS SQL Server, all
>>> the installation and configuration seems to be working, but when I
>>> run some query, the zope stops to respond. Someone knows what I am
>>> missing or could be wrong?
>>>
>>> ----------------------
>>> :Packets and versions:
>>> ----------------------
>>>
>>> debian:/opt/zopes/279-mxodbczopeda# dpkg -l|grep odbc
>>> ii odbcinst1 2.2.4-11 Support library and helper program for
>>>
>>> acces
>>> ii unixodbc 2.2.4-11 ODBC tools libraries
>>>
>>> debian:/opt/zopes/279-mxodbczopeda# dpkg -l|grep "MS SQL"
>>> ii libct1 0.61-6.2 libraries for connecting to MS SQL and
>>>
>>> Sybas
>>> ii sqsh 2.1-6 commandline SQL client for MS SQL
>>> and Sybase
>>>
>>> Zope Version
>>> (Zope 2.7.9-final, python 2.3.5, linux2)
>>> Python Version 2.3.5 (#2, Sep 4 2005, 22:01:42) [GCC 3.3.5 (Debian
>>> 1:3.3.5-13)]
>>>
>>> mxODBCZopeDA-1.0.10
>>>
>>> ---------------
>>> :Configuration:
>>> ---------------
>>>
>>> debian:/etc# cat /etc/freetds/freetds.conf
>>> [MONET]
>>> host = 192.168.0.130
>>> port = 1433
>>> tds version = 8.0
>>>
>>>
>>>
>>> debian:/etc# cat /etc/odbc.ini
>>> [mssql]
>>> Driver = /usr/lib/odbc/libtdsodbc.so
>>> Description = MS SQL running on monet
>>> Trace = No
>>> Servername = MONET
>>> Database = AfariaDB
>>>
>>>
>>> eGenix mxODBC Database Connection eGenix mxODBC Database Connection
>>> at /mssqlserver:
>>>
>>> Connection Id mssqlserver Connection Title Database
>>> Connection Source DSN=mssql ODBC Manager/Driver
>>> unixODBC Connection Information Connected database: SQL
>>> Server, unknown version
>>> ODBC driver: libtdsodbc.so, 0.61 Database Timezone Local Time
>>> Zone Connection Options
>>> * Database Warnings are reported as Python exceptions.
>>> * Connection uses transactions.
>>> * Time columns are returned as DateTime values.
>>> * Date/time columns are returned as Zope DateTime values.
>>> * Short integers are fetched as short integers.
>>> * NULL values are returned as None.
>>> * Scale 0 floats are converted to integers.
>>> * The first available result set is fetched in queries.
>>> * Don't ignore the max_rows query parameter (this is a Z SQL
>>> parameter).
>>> Connection Pool Pool size: 1
>>> Physical connections: 1 open
>>> Total number of mxODBC connections/cursors: (1, 0)
>>> Connection State connected (since 2006/10/10 12:36:20.323 GMT-3)
>>>
>>> -------------------
>>> :Testing with sqsh:
>>> -------------------
>>>
>>> debian:/opt/zopes/279-mxodbczopeda# sqsh -D AfariaDB -U samurai -S
>>> 192.168.0.130
>>> sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
>>> This is free software with ABSOLUTELY NO WARRANTY
>>> For more information type '\warranty'
>>> Password:
>>> 1> select count(*) from a_class
>>> 2> go
>>>
>>> -----------
>>> 85
>>>
>>> (1 row affected)
>>>
>>>
>>> Thanks in advance,
>>> Marcos Iuato
>>>
>>>
>>> _______________________________________________________________________
>>> eGenix.com User Mailing List http://www.egenix.com/
>>> https://www.egenix.com/mailman/listinfo/egenix-users
>>> ###########################################
>>>
>>> This message has been scanned by ICT - Africa Museum
>>>
>>> ________________________________________
>>> 11/10/2006 - Filtered through antispam by ICT
>>>
>>
>>
>> _______________________________________________________________________
>> eGenix.com User Mailing List http://www.egenix.com/
>> https://www.egenix.com/mailman/listinfo/egenix-users
>
>
> _______________________________________________________________________
> eGenix.com User Mailing List http://www.egenix.com/
> https://www.egenix.com/mailman/listinfo/egenix-users
--
Marc-Andre Lemburg
eGenix.com
Professional Python Services directly from the Source (#1, Oct 11 2006)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
________________________________________________________________________
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
More information about the egenix-users
mailing list