[unixODBC-support] RE: Problems with freetds and unixodbc

Stefan Radman Stefan.Radman at CTBTO.ORG
Mon Dec 12 15:54:38 GMT 2005


Hmm. Now is probably the moment to post this to the rlib mailing list
;-)

Cheers
Stefan

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com 
> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of 
> Brian Morton
> Sent: Monday, 12 December, 2005 16:40
> To: 'Support for the unixODBC project'
> Subject: RE: [unixODBC-support] RE: Problems with freetds and unixodbc
> 
> These are the lines I was referring to
> 
> access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or
> directory)
> access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or
> directory)
> 
> That first one repeats itself several times.
> 
> Then there's a block like this
> 
> open("/home/brian/rlib-1.3.7/libsrc/.libs/tls/i686/cmov/libr.so.1",
> O_RDONLY) = -1 ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/tls/i686/cmov", 
> 0xbfffcb6c) = -1
> ENOENT (No such file or directory)
> open("/home/brian/rlib-1.3.7/libsrc/.libs/tls/i686/libr.so.1",
>  O_RDONLY) =
> -1 ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/tls/i686", 
> 0xbfffcb6c) = -1
> ENOENT (No such file or directory)
> open("/home/brian/rlib-1.3.7/libsrc/.libs/tls/cmov/libr.so.1",
>  O_RDONLY) =
> -1 ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/tls/cmov", 
> 0xbfffcb6c) = -1
> ENOENT (No such file or directory)
> open("/home/brian/rlib-1.3.7/libsrc/.libs/tls/libr.so.1", 
> O_RDONLY) = -1
> ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/tls", 0xbfffcb6c) 
> = -1 ENOENT
> (No such file or directory)
> open("/home/brian/rlib-1.3.7/libsrc/.libs/i686/cmov/libr.so.1"
> , O_RDONLY) =
> -1 ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/i686/cmov", 
> 0xbfffcb6c) = -1
> ENOENT (No such file or directory)
> open("/home/brian/rlib-1.3.7/libsrc/.libs/i686/libr.so.1", 
> O_RDONLY) = -1
> ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/i686", 
> 0xbfffcb6c) = -1 ENOENT
> (No such file or directory)
> open("/home/brian/rlib-1.3.7/libsrc/.libs/cmov/libr.so.1", 
> O_RDONLY) = -1
> ENOENT (No such file or directory)
> stat64("/home/brian/rlib-1.3.7/libsrc/.libs/cmov", 
> 0xbfffcb6c) = -1 ENOENT
> (No such file or directory) 
> 
> -----Original Message-----
> From: Stefan Radman [mailto:Stefan.Radman at ctbto.org] 
> Sent: Monday, December 12, 2005 10:11 AM
> To: Support for the unixODBC project
> Subject: RE: [unixODBC-support] RE: Problems with freetds and unixodbc
> 
> > Looks like it can't find any of my ld shared object 
> files?!?  The only
> They are all found.
> 
> open("/usr/lib/php5/20041030/odbc.so", O_RDONLY) = 3
> open("/usr/lib/libodbc.so.1", O_RDONLY) = 3 
> open("/usr/lib/libltdl.so.3",
> O_RDONLY) = 3 open("/var/www/apache2-default/rlib/odbc.php", 
> O_RDONLY) = 3
> open("/usr/lib/php5/20041030/rlib.so", O_RDONLY) = 3
> open("/usr/local/lib/libr-odbc.so", O_RDONLY) = 3
> open("/etc/odbcinst.ini", O_RDONLY)     = 3
> access("/etc/odbc.ini", F_OK)           = 0
> open("/root/.odbc.ini", O_RDONLY)       = 3
> open("/etc/odbc.ini", O_RDONLY)         = 3
> open("/etc/odbc.ini", O_RDONLY)         = 3
> open("/root/.odbc.ini", O_RDONLY)       = 3
> 
> 
> The above looks quite logical to me and I have no clue why it 
> cannot find
> the DSN.
> All files involved are obviously accessible.
> 
> Stefan
> 
> 
> > -----Original Message-----
> > From: unixodbc-support-bounces at easysoft.com
> > [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Brian 
> > Morton
> > Sent: Monday, 12 December, 2005 15:37
> > To: 'Support for the unixODBC project'
> > Subject: RE: [unixODBC-support] RE: Problems with freetds 
> and unixodbc
> > 
> > Looks like it can't find any of my ld shared object 
> files?!?  The only 
> > debian package I see that is related is 
> ld.so.preload-manager.  What 
> > do you think my problem is all about?
> > 
> > -----Original Message-----
> > From: Stefan Radman [mailto:Stefan.Radman at ctbto.org]
> > Sent: Monday, December 12, 2005 3:37 AM
> > To: Support for the unixODBC project
> > Subject: RE: [unixODBC-support] RE: Problems with freetds 
> and unixodbc
> > 
> > 
> > strace -e trace=file 2>log php 
> /var/www/apache2-default/rlib/odbc.php
> > 
> > should log what files the process references (*.so,
> > odbc*.ini) This includes
> > all shared libraries it tries to access and load.
> > See "man strace" for more.
> > 
> > Stefan
> > 
> > > -----Original Message-----
> > > From: unixodbc-support-bounces at easysoft.com
> > > [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Brian 
> > > Morton
> > > Sent: Thursday, 08 December, 2005 15:51
> > > To: 'Support for the unixODBC project'
> > > Subject: RE: [unixODBC-support] RE: Problems with freetds
> > and unixodbc
> > > 
> > > Rlib.so isn't dynamically linked at all.  I ran ldd on 
> php and then 
> > > realized that php is loaded into apache as a module and
> > odbc and rlib
> > > are loaded into php as extensions in php.ini.  How can I see that 
> > > they're being called correctly if they're loaded at runtime?
> > > 
> > > -----Original Message-----
> > > From: Stefan Radman [mailto:Stefan.Radman at ctbto.org]
> > > Sent: Thursday, December 08, 2005 3:39 AM
> > > To: Support for the unixODBC project
> > > Subject: RE: [unixODBC-support] RE: Problems with freetds
> > and unixodbc
> > > 
> > > You're right.
> > > 
> > > The Error you see ("Data source name not found and no 
> default driver
> > > specified") happens at a pretty early state (IM002) and
> > indicates that
> > > the driver manager cannot find your DSN and consequently
> > doesn't find
> > > the driver associated with it.
> > > Looks like it does not find your configuration (files).
> > > 
> > > Hint: Make sure that rlib.so is (dynamically) linked to the same 
> > > unixODBC instance that php and odbcinst are using.
> > > "strace" might help isolating the problem.
> > > 
> > > Good luck
> > > 
> > > Stefan
> > > 
> > > > -----Original Message-----
> > > > From: unixodbc-support-bounces at easysoft.com
> > > > [mailto:unixodbc-support-bounces at easysoft.com] On 
> Behalf Of Brian 
> > > > Morton
> > > > Sent: Wednesday, 07 December, 2005 19:51
> > > > To: 'Support for the unixODBC project'
> > > > Cc: 'Bob Doan'
> > > > Subject: RE: [unixODBC-support] RE: Problems with freetds
> > > and unixodbc
> > > > 
> > > > I have run tests with php using standard odbc_connect
> > calls, and it
> > > > succeeds.  I think the problem lies with the package I am
> > trying to
> > > > use.
> > > > Not an odbc issue it seems. 
> > > > 
> > > > -----Original Message-----
> > > > From: Brian Morton
> > > > Sent: Wednesday, December 07, 2005 12:57 PM
> > > > To: 'Support for the unixODBC project'
> > > > Cc: 'Bob Doan'
> > > > Subject: RE: [unixODBC-support] RE: Problems with freetds
> > > and unixodbc
> > > > 
> > > > So here's what I've run into in this process.  It is not
> > a problem
> > > > with setup as much as a problem with usage (I want to make sure 
> > > > everything works before I make the tutorial).  My driver is
> > > registered
> > > > via odbcinst and my datasource is as well.  I can see
> > them both by
> > > > doing odbcinst -q -s or -d.
> > > > Isql connects to my datasource with no problem.  However,
> > I cannot
> > > > connect to the datasource via php.  This is a package
> > > called Rlib for
> > > > php that does reporting.
> > > > 
> > > > majorpacketloss:/var/www/apache2-default/rlib# php 
> > > > /var/www/apache2-default/rlib/odbc.php
> > > > SQLError = [unixODBC][Driver Manager]Data source name not
> > > found, and
> > > > no default driver specified Error SQLConnect -1
> > [[unixODBC][Driver
> > > > Manager]Data source name not found, and no default driver
> > specified]
> > > > ERROR: Could not connect to ODBC
> > > > 
> > > > But the DSN I am using is clearly registered.  I know this
> > > isn't a php
> > > > mailing list, but has anyone seen anything like this before?
> > > > 
> > > > -----Original Message-----
> > > > From: Stefan Radman [mailto:Stefan.Radman at ctbto.org]
> > > > Sent: Wednesday, December 07, 2005 11:34 AM
> > > > To: Support for the unixODBC project
> > > > Subject: RE: [unixODBC-support] RE: Problems with freetds
> > > and unixodbc
> > > > 
> > > > Hi Brian,
> > > > 
> > > > Thanks for volunteering to write the HOWTO.
> > > > Below you'll find a summary of my findings.
> > > > Use it and distill it as you like ;-)
> > > > 
> > > > Cheers
> > > > Stefan
> > > > 
> > > > ========================================================
> > > > The ODBC-only configuration does not need any FreeTDS
> > configuration
> > > > files or environment variables.
> > > > It lives and works solely from the configuration found in
> > > odbc.ini and
> > > > odbcinst.ini.
> > > > 
> > > > Here is a sample configuration that worked very well for me
> > > on Solaris
> > > > and Linux with unixODBC 2.2.9 and FreeTDS ODBC driver 0.62.3:
> > > > 
> > > > FreeTDS driver entry in odbcinst.ini:
> > > > -------------------------------------
> > > > [FreeTDS]
> > > > Description=FreeTDS ODBC Driver for Sybase and MS-SQL 
> > > > Driver=/usr/lib/libtdsodbc.so Setup=/usr/lib/libtdsodbc.so
> > > > UsageCount=1
> > > > 
> > > > DSN entry in odbc.ini:
> > > > ----------------------
> > > > [testdb]
> > > > Description     = Test Sybase Database with FreeTDS
> > > > Driver          = FreeTDS
> > > > Server          = sybase.example.com
> > > > Port            = 5050
> > > > TDS_Version     = 5.0
> > > > Database        = testdb
> > > > 
> > > > 
> > > > unixODBC has two handy tools for adding these entries:
> > > >   1) the "ODBCConfig" GUI and
> > > >   2) the "odbcinst" command line tool 
> > > >      for non-interactive processing (e.g. odbcinst -i -d -r)
> > > > 
> > > > 
> > > > Valid attributes for use in odbc.ini (or the connection
> > > > string) can be found
> > > > at:
> > > >   http://www.freetds.org/userguide/odbcconnattr.htm
> > > > 
> > > > For ODBC-only configurations these are:
> > > > 
> > > >   Server       database server DNS hostname or IP address
> > > >   Port         TCP port the database server is listening
> > > >   TDS_Version
> > > > http://www.freetds.org/userguide/choosingtdsprotocol.htm#TAB.P
> > > > ROTOCOL.BY
> > > > .PRODUCT
> > > >   Database     databse name on the server
> > > >   APP
> > > >   LANGUAGE
> > > >   TextSize
> > > >   PacketSize
> > > >   Address
> > > > 
> > > > Note: 
> > > > * do NOT use "Servername" in an ODBC-only configuration!
> > > > * use of "Server" should be preferred over "Address"
> > > >   (see
> > > > http://lists.ibiblio.org/pipermail/freetds/2004q2/016086.html et
> > > > al)
> > > > 
> > > > A summary of the Q&A regarding "Server","Servername" and
> > "Address" 
> > > > would help people a great deal.
> > > > 
> > > > What I haven't found is a comprehensive reference about
> > the default
> > > > TCP port numbers that different versions of Microsoft and
> > > Sybase SQL
> > > > Server
> > > > use:
> > > > 
> > > >   http://www.iana.org/assignments/port-numbers
> > > >     ms-sql-s        1433/tcp   Microsoft-SQL-Server 
> > > >     sybase-sqlany   1498/tcp    Sybase SQL Any
> > > > 
> > > >  
> > > > http://www.ibiblio.org/pub/Linux/docs/HOWTO/other-formats/html
> > > > _single/Sy
> > > > base-ASE-HOWTO.html#AEN382  
> > > >     4100 Sybase ASE SQL Server default
> > > >     2025 old Sybase ASE SQL Server default??
> > > > 
> > > > 
> > > > > -----Original Message-----
> > > > > From: unixodbc-support-bounces at easysoft.com
> > > > > [mailto:unixodbc-support-bounces at easysoft.com] On
> > Behalf Of Brian
> > > > > Morton
> > > > > Sent: Wednesday, 07 December, 2005 15:26
> > > > > To: 'unixodbc-support at easysoft.com'
> > > > > Subject: [unixODBC-support] RE: Problems with freetds
> > and unixodbc
> > > > > 
> > > > > I read the FreeTDS article I was sent about the three 
> possible 
> > > > > configuration options for FreeTDS and ODBC.  Can anyone
> > shed some
> > > > > light on tips for the only ODBC method?  I have done pure
> > > > FreeTDS, and
> > > > > also done the config file mix, which is the one documented on 
> > > > > unixODBC's site.  How do I do it with ODBC being the only
> > > > connection
> > > > > method?  Once I figure it out, I will write a howto for
> > the site.
> > > > > 
> > > > > >  -----Original Message-----
> > > > > > From: 	Brian Morton  
> > > > > > Sent:	Tuesday, December 06, 2005 10:59 AM
> > > > > > To:	'unixodbc-support at easysoft.com'
> > > > > > Subject:	Problems with freetds and unixodbc
> > > > > > 
> > > > > > I have a Debian 3.1 machine with FreeTDS and unixODBC
> > > > > installed.  I am
> > > > > > able to connect to my MSSQL 2000 server via tsql (which is
> > > > > the command
> > > > > > line interface for FreeTDS).  However, I cannot connect via
> > > > > isql or any
> > > > > > odbc connect functions in PHP.  I have read the HOWTO on
> > > > this on the
> > > > > > unixODBC site, but it has not helped me.  Where can I
> > begin to
> > > > > > troubleshoot my problems between FreeTDS and unixODBC?
> > > > > Thanks for your
> > > > > > help in advance.
> > > > > > 
> > > > > > Brian Morton
> > > > > > 
> > > > > > CRM Developer
> > > > > > SecureWorks, Inc.
> > > > > > 11 Executive Park Drive
> > > > > > Atlanta, GA 30329
> > > > > > tel  (404) 417-3728
> > > > > > fax (404) 327-8835
> > > > > > www.secureworks.com
> > > > > > 
> > > > > _______________________________________________
> > > > > unixODBC-support mailing list
> > > > > unixODBC-support at easysoft.com
> > > > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > > > > 
> > > > > 
> > > > 
> > > > _______________________________________________
> > > > unixODBC-support mailing list
> > > > unixODBC-support at easysoft.com
> > > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > > > _______________________________________________
> > > > unixODBC-support mailing list
> > > > unixODBC-support at easysoft.com
> > > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > > > _______________________________________________
> > > > unixODBC-support mailing list
> > > > unixODBC-support at easysoft.com
> > > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > > > 
> > > > 
> > > 
> > > _______________________________________________
> > > unixODBC-support mailing list
> > > unixODBC-support at easysoft.com
> > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > > _______________________________________________
> > > unixODBC-support mailing list
> > > unixODBC-support at easysoft.com
> > > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > > 
> > > 
> > 
> > _______________________________________________
> > unixODBC-support mailing list
> > unixODBC-support at easysoft.com
> > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > 
> > 
> > 
> 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 




More information about the unixODBC-support mailing list