[egenix-users] Zope stops to respond
Marcos Iuato
iuato at samurai.com.br
Wed Oct 11 18:21:48 CEST 2006
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?
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
More information about the egenix-users
mailing list