From owner-freebsd-questions@FreeBSD.ORG Thu Jan 15 05:03:56 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8DD9110656C9 for ; Thu, 15 Jan 2009 05:03:56 +0000 (UTC) (envelope-from tmende@optusnet.com.au) Received: from smtp-2.servers.netregistry.net (smtp.netregistry.net [202.124.241.204]) by mx1.freebsd.org (Postfix) with ESMTP id 9D8158FC1C for ; Thu, 15 Jan 2009 05:03:55 +0000 (UTC) (envelope-from tmende@optusnet.com.au) Received: from [59.167.255.96] (helo=[192.168.18.17]) by smtp-2.servers.netregistry.net protocol: esmtpa (Exim 4.63 #1 (Debian)) id 1LNKOX-0006dc-J7 for ; Thu, 15 Jan 2009 16:03:53 +1100 Message-Id: <906726E3-E109-4A3C-B5A7-2FE233CE1561@optusnet.com.au> From: Tom Mende To: freebsd-questions@freebsd.org In-Reply-To: <64A560B0-B971-4A6C-A245-6D89F802628C@optusnet.com.au> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v930.3) Date: Thu, 15 Jan 2009 16:03:52 +1100 References: <64A560B0-B971-4A6C-A245-6D89F802628C@optusnet.com.au> X-Mailer: Apple Mail (2.930.3) Subject: Re: /usr/ports/databases/dbf segmentation fault X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 15 Jan 2009 05:03:57 -0000 Hi; Problem solved - the source dbf file is somehow corrupted when downloaded from an NT server to a PPC G4 Mac over a Microsoft RDC client connection. This is a repeatable result. Used rdesktop to download the files directly onto the trusty FreeBSD machine and it works fine that way. Cheers, Tom On 10/01/2009, at 12:16 PM, Tom Mende wrote: > Hi; > > Hoping for some help on this application that converts dbf files > into csv format. > > I'm not sure if the problem is with the source dbf file ... my > usage / syntax ... and/or something else... > > BACKGROUND... > > >uname -rs > FreeBSD 7.0-RELEASE > > >dbf --version > dBase Reader and Converter V. 0.8.3.1, (c) 2002 - 2004 by Bjoern Berg > > ...intalled as a port from /usr/ports/databases/dbf ...make install > clean > > ...chmod 777 cardfile.dbf # to avoid permissions problems > > >ls -l cardfile* > -rwxrwxrwx 1 tom tom 549139 Jan 9 18:32 cardfile.dbf > > >dbf --view-info ~/cardfile.dbf > -- File statistics > dBase version.........: Visual FoxPro (without memo) > Date of last update...: 1908-12-15 > Number of records.....: 625 (00000271d) > Length of header......: 2888 (0b48d) > Record length.........: 874 (036ad) > Columns in file.......: 89 > Rows in file..........: 625 > > +---------------+-------+---------------+--------------- > +---------------+ > | field name | type | field adress | length | field dec. | > +---------------+-------+---------------+--------------- > +---------------+ > | CF_NAME | C | 1 | 45 | 0 | > | CF_REGNAME | C | 2e | 45 | 0 | > | CF_ID | C | 5b | 8 | 0 | > | CF_CODE | C | 63 | 8 | 0 | > | CF_EDI_ID | C | 6b | 13 | 0 | > | CABN | C | 78 | 14 | 0 | > | CPARENT_ID | C | 86 | 8 | 0 | > | LINACTIVE | L | 8e | 1 | 0 | > | LCUSTOMER | L | 8f | 1 | 0 | > | LSUPPLIER | L | 90 | 1 | 0 | > | LCREDITOR | L | 91 | 1 | 0 | > | LEMPLOYEE | L | 92 | 1 | 0 | > | LPROSPECT | L | 93 | 1 | 0 | > | LSALESPERS | L | 94 | 1 | 0 | > | CINVOICEST | C | 95 | 35 | 0 | > | CINVOICES2 | C | b8 | 35 | 0 | > | CINVOICECI | C | db | 20 | 0 | > | CINVOICES3 | C | ef | 3 | 0 | > | CINVOICEPO | C | f2 | 6 | 0 | > | CINVOICECO | C | f8 | 25 | 0 | > | CINVOICEPH | C | 111 | 20 | 0 | > | CINVOICEFA | C | 125 | 20 | 0 | > | CINVOICEC2 | C | 139 | 25 | 0 | > | CEMAIL | C | 152 | 35 | 0 | > | CMOBILE | C | 175 | 15 | 0 | > | CDEFSHIPLO | C | 184 | 20 | 0 | > | CDEFINVFOR | C | 198 | 1 | 0 | > | CDEFSELLCU | C | 199 | 3 | 0 | > | CDEFBUYCUR | C | 19c | 3 | 0 | > | CDEFSALESR | C | 19f | 8 | 0 | > | LPARTIALSH | L | 1a7 | 1 | 0 | > | CDEFDEPT | C | 1a8 | 3 | 0 | > | LWEBACCOUN | L | 1ab | 1 | 0 | > | CWEBLOGIN | C | 1ac | 15 | 0 | > | CWEBPASSWD | C | 1bb | 15 | 0 | > | CGROUPCODE | C | 1ca | 4 | 0 | > | CSORTCODE | C | 1ce | 4 | 0 | > | LPRICECAT | L | 1d2 | 1 | 0 | > | NPRICECAT | I | 1d3 | 4 | 0 | > | IPM_ID | I | 1d7 | 4 | 0 | > | LPRICEDISC | L | 1db | 1 | 0 | > | NDISCOUNT | N | 1dc | 7 | 4 | > | LTAXEXEMPT | L | 1e3 | 1 | 0 | > | CREASON | C | 1e4 | 25 | 0 | > | CF_BALANCE | Y | 1fd | 8 | 4 | > | NLIMIT | Y | 205 | 8 | 4 | > | NTERMS | N | 20d | 3 | 0 | > | NSUPPLIERL | Y | 210 | 8 | 4 | > | CSUPPLIERB | C | 218 | 10 | 0 | > | CSUPPLIER2 | C | 222 | 11 | 0 | > | NDISCDAYS | N | 22d | 2 | 0 | > | NDISCPCENT | N | 22f | 7 | 4 | > | CBANKNAME | C | 236 | 35 | 0 | > | CBRANCHBSB | C | 259 | 18 | 0 | > | CCARDTYPE | C | 26b | 17 | 0 | > | CCARDNO | C | 27c | 19 | 0 | > | CCARDEXPIR | C | 28f | 4 | 0 | > | CCARDHOLDE | C | 293 | 35 | 0 | > | CUSER1 | C | 2b6 | 20 | 0 | > | CUSER2 | C | 2ca | 20 | 0 | > | CUSER3 | C | 2de | 20 | 0 | > | CKEYLIST_I | C | 2f2 | 8 | 0 | > | MNOTES | M | 2fa | 4 | 0 | > | ADDEDBY | C | 2fe | 3 | 0 | > | MWATCHOUT | M | 301 | 4 | 0 | > | DCREATED | D | 305 | 8 | 0 | > | LCUSTTAXIN | L | 30d | 1 | 0 | > | LUSEPARENT | L | 30e | 1 | 0 | > | CCONTACTIF | C | 30f | 4 | 0 | > | CCREDTAXCO | C | 313 | 3 | 0 | > | CCREDCACC_ | C | 316 | 10 | 0 | > | LPAYDIRECT | L | 320 | 1 | 0 | > | CSUPPLIERT | C | 321 | 15 | 0 | > | CDEFLOCID | C | 330 | 3 | 0 | > | LOCREQUIRE | L | 333 | 1 | 0 | > | CRM_CY_ID | C | 334 | 10 | 0 | > | CRM_CONTAC | C | 33e | 10 | 0 | > | CUSER4 | C | 348 | 20 | 0 | > | BPAYCODE | C | 35c | 9 | 0 | > | IBACKORDER | I | 365 | 4 | 0 | > | LPRINTBACK | L | 369 | 1 | 0 | > | > fps_data.d | b | 63 | 0 | 0 | > | | | 0 | 0 | 0 | > | | | 0 | 0 | 0 | > | | | 0 | 0 | 0 | > | | | 0 | 0 | 0 | > | | | 0 | 0 | 0 | > | | | 0 | 0 | 0 | > | | | 0 | 0 | 0 | > +---------------+-------+---------------+--------------- > +---------------+ > > ...could the reported date be a problem??? > > >stat cardfile.dbf > 97 918810 -rwxrwxrwx 1 tom tom 3704992 549139 "Jan 10 11:22:17 2009" > "Jan 9 18:32:14 2009" "Jan 10 10:00:05 2009" "Jan 9 18:32:13 2009" > 4096 1120 0 cardfile.dbf > > ...so I don't think I can change the date...seems like the reported > date is a separate date within the dbf file format??? > > THE COMMAND... > > >dbf --csv ~/cardfile.csv ~/cardfile.dbf > dBase Reader and Converter V. 0.8.3.1, (c) 2002 - 2004 by Bjoern Berg > Export from /home/tom/cardfile.dbf to /home/tom/cardfile.csv > Segmentation fault (core dumped) > > >ls -l cardfile* > -rw-r--r-- 1 tom tom 1032192 Jan 10 10:21 cardfile.csv > -rwxrwxrwx 1 tom tom 549139 Jan 9 18:32 cardfile.dbf > > ...tried this as root - same result sig 11... > > ...tried this using cardfile1.csv as output file - same result sig > 11 ... > > ...the file created is a csv format file with just the column > headers from the dbf and part of the first record > > >dmesg > pid 7005 (dbf), uid 1001: exited on signal 11 (core dumped) > > I have a dump file dbf.core if this helps but I thought I shouldn't > post it because it is an address file with at least one record > containing private contact info of one of my colleagues. > > Cheers, > > > Tom > > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org > " >