FreeTDS Development Group

["Andrew J. Hutson" <andrewh AT advfn.com>]

> > From: Andrew J. Hutson [mailto:andrewh AT advfn.com]
> > Sent: February 12, 2004 10:19 AM
> >
> > Have just upgraded PHP to 4.3.3, and consequently had to
> > change from freetds0 0.53-7 to libct1 0.61-5. The upgrade has
> > worked fine, apart from the fact that the date format
> > returned from Sybase queries has changed. It used be in the
> > following format (example):
> >
> > May 14 2002 8:58AM
> >
> > but is now in this format:
> >
> > Tue May 14 08:58:00 2002
> >
> > I have tried putting the following in /etc/freetds/locales.conf:
> >
> > [default]
> >         date format = %b %d %Y %I:%M%p
> >
> > [en_US]
> >         date format = %b %d %Y %I:%M%p
> >         language = us_english
> >         char set = iso_1
> >
> > But nothing changes. It does appear to be paying any
> > attention to the locales.conf file.
>
> The default prefix changed after 0.53.  Unless you altered configure's
default, you installed into /usr/local, and you need to edit
/usr/local/etc/locales.conf.  You > can double check which file is being
consulted with TDSDUMPCONFIG.

There is no /usr/local/etc directory. I tried making one and copying the
config into it, but it made no difference. I didn't compile it from source,
as it was a Debian package, so it did everything itself. TDSDUMPCONFIG
doesn't seem to say anything about locales.conf, however it does indicate
that it is reading from /etc/freetds/ rather than /usr/local/etc/. I have
pasted it's output below:

Starting log file with debug level 99.
2004-02-12 23:59:01.930187 Attempting to read conf files.
2004-02-12 23:59:01.930243 ...$FREETDSCONF not set.  Trying $HOME.
2004-02-12 23:59:01.930400 Found conf file '/etc/freetds/freetds.conf'
(default). Reading section 'DB1'.
2004-02-12 23:59:01.930446 Looking for section global.
2004-02-12 23:59:01.930541 ... Found section global.
2004-02-12 23:59:01.930575 Got a match.
2004-02-12 23:59:01.930608 option = 'tds version' value = '5.0'.
2004-02-12 23:59:01.930648 option = 'initial block size' value = '512'.
2004-02-12 23:59:01.930688 option = 'swap broken dates' value = 'no'.
2004-02-12 23:59:01.930722 no is a 'no/off/false'.
2004-02-12 23:59:01.930759 option = 'swap broken money' value = 'no'.
2004-02-12 23:59:01.930792 no is a 'no/off/false'.
2004-02-12 23:59:01.930832 option = 'try server login' value = 'yes'.
2004-02-12 23:59:01.930865 yes is a 'yes/on/true'.
2004-02-12 23:59:01.930900 option = 'try domain login' value = 'no'.
2004-02-12 23:59:01.930933 no is a 'no/off/false'.
2004-02-12 23:59:01.930975 option = 'cross domain login' value = 'no'.
2004-02-12 23:59:01.931008 no is a 'no/off/false'.
2004-02-12 23:59:01.931052 ... Found section db1.
2004-02-12 23:59:01.931092 ... Found section db1_back.
2004-02-12 23:59:01.931131 ... Found section db1_mon.
2004-02-12 23:59:01.931169 ... Found section db2.
2004-02-12 23:59:01.931209 ... Found section db2_back.
2004-02-12 23:59:01.931248 ... Found section db2_mon.
2004-02-12 23:59:01.931286 ... Found section db3.
2004-02-12 23:59:01.931326 ... Found section db3_back.
2004-02-12 23:59:01.931365 ... Found section db3_mon.
2004-02-12 23:59:01.931404 ... Found section db4.
2004-02-12 23:59:01.931443 ... Found section db4_back.
2004-02-12 23:59:01.931482 ... Found section db4_mon.
2004-02-12 23:59:01.931521 ... Found section sybase.
2004-02-12 23:59:01.931561 ... Found section sybase_back.
2004-02-12 23:59:01.931601 ... Found section sybase_mon.
2004-02-12 23:59:01.931641 ... Found section database1.
2004-02-12 23:59:01.931680 ... Found section db8.
2004-02-12 23:59:01.931724 Looking for section db1.
2004-02-12 23:59:01.931794 ... Found section global.
2004-02-12 23:59:01.931874 ... Found section db1.
2004-02-12 23:59:01.931905 Got a match.
2004-02-12 23:59:01.931935 option = 'host' value = 'db1'.
2004-02-12 23:59:01.931969 Found host entry db1.
2004-02-12 23:59:01.932466 IP addr is 10.0.2.1.
2004-02-12 23:59:01.932505 option = 'port' value = '4100'.
2004-02-12 23:59:01.932544 ... Found section db1_back.
2004-02-12 23:59:01.932584 ... Found section db1_mon.
2004-02-12 23:59:01.932623 ... Found section db2.
2004-02-12 23:59:01.932662 ... Found section db2_back.
2004-02-12 23:59:01.932702 ... Found section db2_mon.
2004-02-12 23:59:01.932740 ... Found section db3.
2004-02-12 23:59:01.932780 ... Found section db3_back.
2004-02-12 23:59:01.932819 ... Found section db3_mon.
2004-02-12 23:59:01.932858 ... Found section db4.
2004-02-12 23:59:01.932897 ... Found section db4_back.
2004-02-12 23:59:01.932936 ... Found section db4_mon.
2004-02-12 23:59:01.932976 ... Found section sybase.
2004-02-12 23:59:01.933016 ... Found section sybase_back.
2004-02-12 23:59:01.933055 ... Found section sybase_mon.
2004-02-12 23:59:01.933095 ... Found section database1.
2004-02-12 23:59:01.933134 ... Found section db8.
2004-02-12 23:59:01.933173 ...Success.
2004-02-12 23:59:01.933213 Setting 'dump_file' to '/temp/freetds.log' from
$TDSDUMP.

I found an article from someone else who had this problem, but it seems
there was never a resolution. Is this a common problem? What would you
suggest? Using the newer version? Will this actually help? I am concerned
that there might be problems with it if it hasn't been packaged with Debian
yet...

>
> We never issued a "0.61-5" release; we had a 0.61.x and a month ago issued
0.62.1.

It might have been a good idea for me to mention that it's a Debian system:
http://packages.debian.org/testing/libs/libct1 This shows 0.61-5 - the same
version is in unstable, so it seems 0.62.1 hasn't been put into Debian yet.

>
> HTH.
>
> --jkl