Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 10 Jan 2009 12:16:27 +1100
From:      Tom Mende <tmende@optusnet.com.au>
To:        freebsd-questions@freebsd.org
Subject:   /usr/ports/databases/dbf segmentation fault
Message-ID:  <64A560B0-B971-4A6C-A245-6D89F802628C@optusnet.com.au>

Next in thread | Raw E-Mail | Index | Archive | Help
Hi;

Hoping for some help on this application that converts dbf files into =20=

csv format.

I'm not sure if the problem is with the source dbf file ... my usage / =20=

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 =20
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

+---------------+-------+---------------+---------------=20
+---------------+
| field name	| type	| field adress	| length	| field dec.	=
|
+---------------+-------+---------------+---------------=20
+---------------+
|      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		=
|
|             	|   =00	|        0	|   0		|   0		=
|
|             	|   =00	|        0	|   0		|   0		=
|
|             	|   =00	|        0	|   0		|   0		=
|
|             	|   =00	|        0	|   0		|   0		=
|
|             	|   =00	|        0	|   0		|   0		=
|
|             	|   =00	|        0	|   0		|   0		=
|
|             	|   =00	|        0	|   0		|   0		=
|
+---------------+-------+---------------+---------------=20
+---------------+

...could the reported date be a problem???

 >stat cardfile.dbf
97 918810 -rwxrwxrwx 1 tom tom 3704992 549139 "Jan 10 11:22:17 2009" =20
"Jan  9 18:32:14 2009" "Jan 10 10:00:05 2009" "Jan  9 18:32:13 2009" =20
4096 1120 0 cardfile.dbf

...so I don't think I can change the date...seems like the reported =20
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 =20
11 ...

...the file created is a csv format file with just the column headers =20=

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 =20
post it because it is an address file with at least one record =20
containing private contact info of one of my colleagues.

Cheers,


Tom






Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?64A560B0-B971-4A6C-A245-6D89F802628C>