Skip to Content.
Sympa Menu

freetds - RE: [freetds] tdspool: Segmentation fault on connect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Carlos S. Alonso de Linaje" <calonso AT i-network.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] tdspool: Segmentation fault on connect
  • Date: Tue, 29 Jul 2003 09:33:22 +0200

:-( .....
I'm trying with user... prueba, passwd..prueba (test in spanish)
all in lowercase and dbname in lowercase, etc...
but nothing.....

In tsql output, when we connect to the pool (./tsql -Spooldesarrollo -Uprueba -Pprueba) we can see this;
locale is "es_ES@euro"
charset is "ISO-8859-15"
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

and the output from pool is like this
Found conf file in /usr/local/freetds/etc/pool.conf reading sections
Listening on port 5000
waiting for a connect
accepting connection
waiting for a connect
Violación de segmento (Segmentation Fault in Spanish)

Perhaps is the charset??? when we connect directly to MS-SQL with tsql

./tsql -Sdesarrollosql -Uprueba -Pprueba

the output is like the other and works fine!... I tried to change and put the locates.conf.
The error is the same, only changing the charset to this one; locale is "C" charset is "ANSI_X3.4-1968"

.....

My pool.conf
[global]
min pool conn = 50
max pool conn = 150
max member age = 180

[pooldesarrollo]
user = prueba
password = prueba
database = desarrollo
server = desarrollosql
min pool conn = 5
max pool conn = 10
port = 5000

My freetds.conf
[global]
tds version = 4.2
initial block size = 512
swap broken dates = no
swap broken money = no
dump file = /var/tmp/freetds/freetds.log
dump file appaned = yes
debug level = 99
timeout = 50;
connect timeout = 10;

[desarrollosql]
host = 192.168.6.205
port = 1433
tds version = 4.2

[pooldesarrollo]
host = 192.168.6.133
port = 5000
tds version = 4.2

Thanks for the help.
Regards.


At 04:16 PM 7/28/2003 -0400, you wrote:

> From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> Sent: July 28, 2003 4:10 PM
> > From: Carlos S. Alonso de Linaje [mailto:calonso AT i-network.com]
> > Sent: July 28, 2003 3:04 PM
> >
> > Also we try to download tdspool files from CVS and compile it
> > but its the same...
>
> It looks like tdspool is broken. I just tried it. It fails
> to connect to
> the server if your username isn't all lower case, which
> wasn't hard to fix.

Withdrawn, my error. I was able to connect, once $U was right!:

$ tdspool mypool 2>pool.err >pool.log &
[7] 8368
LowdenJK@ntc5003$ tsql -Smypool -U$U -P$P
locale is "C"
using default charset "ISO-8859-1"
1> select @@version
2> go

Microsoft SQL Server 7.00 - 7.00.1077 (Intel X86)
Sep 6 2002 15:10:15
Copyright (c) 1988-2002 Microsoft Corporation
Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
1>

Just make sure you're using TDS version 4.2. And that your credentials are
all lower case.

--jkl
-----------------------------------------
The information contained in this transmission may contain privileged and confidential information and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions.


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

Carlos S. Alonso de Linaje García
Director Técnico
I-network
C/Marqués de Riscal 11, 2ª planta
28010 Madrid
Tel: +34. 91.702.17.57
"Si buscas resultados distintos, no hagas lo mismo" (Albert Einstein)

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003



Archive powered by MHonArc 2.6.24.

Top of Page