Hello Etienne Tourigny, Returned to repositories. Now have stack smashing.
Katie Urey =========== PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0 PGeo: MDB Tools driver installed successfully! PGeo: EstablishSession(sample_pgeo) ODBC: SQLConnect(sample_pgeo) *** stack smashing detected ***: ogrinfo terminated ======= Backtrace: ========= /lib/i386-linux-gnu/libc.so.6(__fortify_fail+0x50)[0x4e3df0] /lib/i386-linux-gnu/libc.so.6(+0xe5d9a)[0x4e3d9a] /usr/lib/libgdal1.8.0.so.1(+0x5cc194)[0x112d194] /usr/lib/libgdal1.8.0.so.1(_ZN16CPLODBCStatement5FetchEii+0x77f)[0xee280f] [0x302c2274] ======= Memory map: ======== [ lines removed..] odbcinst -j unixODBC 2.2.14 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /home/GISData/CurbCuts/ USER DATA SOURCES..: /home/katie/.odbc.ini SQLULEN Size.......: 4 SQLLEN Size........: 4 SQLSETPOSIROW Size.: 2 mdb-ver -M mdbtools v0.6pre1 uname -a Linux Edith-1 2.6.38-8-generic #42-Ubuntu SMP Mon Apr 11 03:31:50 UTC 2011 i686 i686 i386 GNU/Linux On Fri, Mar 2, 2012 at 9:35 AM, Etienne Tourigny <[email protected]> wrote: > Your best bet is to uninstall what you installed manually, and stick > to the repositories. > > cd ~/Downloads/unixODBC-2.3.1 > make uninstall > > And for the repositories, try > > sudo apt-get install mdbtools unixodbc-bin > > For gdal-1.9.0 I'm not sure it is available yet in ubuntugis-unstable > ppa, but it should be coming shortly. > Your other option is to build it manually, but it is somewhat involved. > > Etienne > > On Fri, Mar 2, 2012 at 2:22 PM, Katie Urey <[email protected]> wrote: >> Hi Etienne Tourigny, >> >> Thank you for the suggestions and questions. >> >> I looked around for gdal-1.9 and did not find instructions that I >> thought I could follow. I may later try gdal-1.9. >> >> About my installation. Its been a few days. I believe that I >> followed the instructions, but as a newbie, its possible >> that I made many mistakes. So: >> >> cd ~/Downloads/unixODBC-2.3.1 >> ./configure >> make >> make install >> >> If I uninstall, (not sure how...) and re-install from repositories, I >> will have from apt-cache- >> >> Package: mdbtools >> Versions: >> 0.5.99.0.6pre1.0.20051109-7ubuntu1 >> (/var/lib/apt/lists/us.archive.ubuntu.com_ubuntu_dists_natty_main_binary-i386_Packages) >> (/v >> ar/lib/dpkg/status) >> >> Package: unixodbc >> Versions: >> 2.2.14p2-2ubuntu1 >> (/var/lib/apt/lists/us.archive.ubuntu.com_ubuntu_dists_natty_main_binary-i386_Packages) >> (/var/lib/dpkg/statu >> s) >> >> best regards, >> >> Katie Urey >> Portland, Oregon >> >> >> On Fri, Mar 2, 2012 at 5:57 AM, Etienne Tourigny >> <[email protected]> wrote: >>> Have you tried the MDB driver with gdal-1.9 ? It might be more easy >>> to setup -> http://gdal.org/ogr/drv_mdb.html >>> >>> If not - How did you install ODBC? Have you followed the installation >>> instructions in the document you linked to? >>> >>> Etienne >>> >>> On Thu, Mar 1, 2012 at 7:07 PM, Katie Urey <[email protected]> wrote: >>>> Friends, >>>> >>>> Per notes on this web page, http://gdal.org/ogr/drv_pgeo.html >>>> >>>> I believe that I should be able to read tables from a Microsoft/ESRI >>>> personal geodatabase by using ogr* commands. >>>> >>>> Not yet. The Current error is "ODBC: Invalid install path". It >>>> would be simple if a typo or an install mistake was confirmed. >>>> For instance- did I err in the install to get >>>> ODBCSYSINI set to my home dir? If so, do I re-install or >>>> override? >>>> >>>> Also, please advise if I should send to another list. >>>> >>>> -best >>>> Katie Urey >>>> Portland, Oregon >>>> >>>> >>>> some details: >>>> >>>> -1:/home/GISData/CurbCuts$ ogrinfo --debug on PGeo:sample_pgeo >>>> PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0 >>>> ODBC: HOME=/home/katie >>>> ODBC: ODBCSYSINI=/home/katie >>>> **ERROR 1: ODBC: Invalid install path >>>> Warning 1: Unable to install MDB driver for ODBC, MDB access may not >>>> supported. >>>> >>>> PGeo: EstablishSession(sample_pgeo) >>>> ODBC: SQLConnect(sample_pgeo) >>>> ODBC: ... failed: [unixODBC][Driver Manager]Data source name not >>>> found, and no default driver specified >>>> ODBC: SQLDisconnect() >>>> ERROR 1: Unable to initialize ODBC connection to DSN for sample_pgeo, >>>> [unixODBC][Driver Manager]Data source name not found, and no default >>>> driver specified >>>> PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0 >>>> ERROR 1: ODBC: Invalid install path >>>> Warning 1: Unable to install MDB driver for ODBC, MDB access may not >>>> supported. >>>> >>>> PGeo: EstablishSession(sample_pgeo) >>>> ODBC: SQLConnect(sample_pgeo) >>>> ODBC: ... failed: [unixODBC][Driver Manager]Data source name not >>>> found, and no default driver specified >>>> ODBC: SQLDisconnect() >>>> ERROR 1: Unable to initialize ODBC connection to DSN for sample_pgeo, >>>> [unixODBC][Driver Manager]Data source name not found, and no default >>>> driver specified >>>> FAILURE: >>>> Unable to open datasource `PGeo:sample_pgeo' with the following >>>> drivers. >>>> >>>> >>>> I am working on a Ubuntu/Natty OS with unixODBC 2.3.1, which I installed >>>> from a >>>> tar download using the defaults. (I am ignorant of make/configure..) >>>> >>>> I am able to see the tables in the ESRI Personal Geodatabase by using >>>> DataManager >>>> and mdb-tables. >>>> >>>> The gdal info: >>>> GDAL 1.8.0, released 2011/01/12 >>>> >>>> >>>> ============== >>>> >>>> odbcinst -j >>>> unixODBC 2.3.1 >>>> DRIVERS............: /usr/local/etc/odbcinst.ini >>>> SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini >>>> FILE DATA SOURCES..: /home/GISData/CurbCuts/ >>>> USER DATA SOURCES..: /home/katie/.odbc.ini >>>> SQLULEN Size.......: 4 >>>> SQLLEN Size........: 4 >>>> SQLSETPOSIROW Size.: 2 >>>> >>>> ==== >>>> >>>> mdb-tables WPC_study_area_data_from_PBOT.mdb >>>> GDB_ReleaseInfo GDB_FeatureDataset GDB_ObjectClasses GDB_FeatureClasses >>>> GDB_RelClasses GDB_ValidRules GDB_AttrRules GDB_RelRules >>>> GDB_EdgeConnRules GDB_JnConnRules GDB_Topologies GDB_TopoRules >>>> GDB_TopoClasses GDB_DefaultValues GDB_Subtypes GDB_Domains >>>> GDB_RangeDomains GDB_CodedDomains GDB_UserMetadata GDB_FieldInfo >>>> GDB_Extensions GDB_Replicas GDB_ReplicasEx GDB_ReplicaDatasets >>>> GDB_Toolboxes GDB_RasterCatalogs GDB_ExtensionDatasets GDB_ReplicaLog >>>> GDB_AnnoSymbols GDB_SpatialRefs GDB_GeomColumns Streets_pdx_Shape_Index >>>> Streets_pdx Selections SelectedObjects Tax_Parcels_Shape_Index >>>> Tax_Parcels Sidewalks_Shape_Index Sidewalks Curb_Ramps_Shape_Index >>>> Curb_Ramps Driveways_Shape_Index Driveways PM_Symbols_Shape_Index >>>> PM_Symbols PM_Lines_Shape_Index PM_Lines MAX_Shape_Index MAX >>>> LH_Intersections_Shape_Index LH_Intersections LH_Nodelegs_Shape_Index >>>> LH_Nodelegs LH_Blockfaces_Shape_Index LH_Blockfaces >>>> LH_Segments_Shape_Index LH_Segments >>>> >>>> ============Access DSN in /usr/local/etc/odbcinst.ini >>>> >>>> 1:~$ grep -A7 Access /usr/local/etc/odbcinst.ini >>>> [Microsoft Access Driver (*.mdb)] >>>> Description = MDB Tools ODBC drivers >>>> Driver = /usr/lib/libmdbodbc.so.0 >>>> Setup = >>>> FileUsage = 1 >>>> CPTimeout = >>>> CPReuse = >>>> >>>> and in ~/.odbc.ini >>>> [sample_pgeo] >>>> Description = Sample PGeo Database for Curb Cuts >>>> Driver = Microsoft Access Driver (*.mdb) >>>> Database = /home/GISData/CurbCuts/WPC_study_area_data_from_PBOT.mdb >>>> Host = localhost >>>> Port = 1360 >>>> User = katie >>>> Password = >>>> Trace = Yes >>>> _______________________________________________ >>>> UbuntuGIS mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/ubuntu >>>> http://trac.osgeo.org/ubuntugis/wiki _______________________________________________ UbuntuGIS mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/ubuntu http://trac.osgeo.org/ubuntugis/wiki
