Skip to Content.
Sympa Menu

freetds - [freetds] freetds 0.61 upgrading problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Dmitry Muntean <mechanix AT riscom.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] freetds 0.61 upgrading problem
  • Date: Fri, 14 Nov 2003 16:24:34 +0200

Hi!

I ran into the problem with upgrading freetds from version 0.60 to 0.61
Here's a full story:

On web server I used apache 2.0.48 with php-4.3.4 on freebsd 4.8-RELEASE, after upgrading from sources to 4.9-RELEASE I decided to upgrade all the libraries I used with php. All of them(libraries) were build from freebsd ports collection, e.g. libiconv, freetds , Sablot. So libiconv was upgraded from 1.8. to 1.9 and freetds from 0.60 to 0.61.
After recompiling php with support of new libraries I coudn't connect to BD(which is btw MSSQL7) with report in logs :

Starting log file for FreeTDS 0.61.2 with debug level 99.
2003-11-14 16:14:17.624824 iconv will convert client-side data to the "CP1251" characte
2003-11-14 16:14:17.624874 IP address pointer is NULL
2003-11-14 16:14:17.624899 Server SYBASE not found!

After some googling around I found a clue to cheat freetds and made a substitude in freetds.conf:

[SYBASE]
host = 192.168.2.1
port = 1433
tds version = 7.0
client charset = CP1251

That made some sort of progress but still came with error:

Starting log file for FreeTDS 0.61.2 with debug level 99.
2003-11-14 16:17:26.487611 iconv will convert client-side data to the "CP1251" character set
2003-11-14 16:17:26.487692 Connecting addr 192.168.2.1 port 1433 with TDS version 7.0
2003-11-14 16:17:26.488068 inside tds_process_login_tokens()
Received header @ 2003-11-14 16:17:26.488971
and so on...

debbuging this on a webpage gave me this:

message=Changed language setting to us_english.
message=Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Looking through maillist archives gave me nothing, playing with "try server login" and "try domain login" was useless.
So I installed a old version(0.60) of freetds in another location and compiled php with that version(but still with new version of other libraries) - new errors came up.
All the information that were already stored in database in russian(that the language of almost all info) were displayed correctly, but trying to store some new data in db returns some invalid characters. I found out that data is inserted in db by freetds is in invalid charset.

Now I wonder maybe somthing was changed in the way freetds talks to libiconv?
Or does anybody have a clue what should I try next?

Thanx.




  • [freetds] freetds 0.61 upgrading problem, Dmitry Muntean, 11/14/2003

Archive powered by MHonArc 2.6.24.

Top of Page