/usr/ports/databases/dbf segmentation fault
Tom Mende
tmende at optusnet.com.au
Wed Jan 14 21:03:57 PST 2009
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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org
> "
>
More information about the freebsd-questions
mailing list