Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 15 Jan 2009 16:03:52 +1100
From:      Tom Mende <tmende@optusnet.com.au>
To:        freebsd-questions@freebsd.org
Subject:   Re: /usr/ports/databases/dbf segmentation fault
Message-ID:  <906726E3-E109-4A3C-B5A7-2FE233CE1561@optusnet.com.au>
In-Reply-To: <64A560B0-B971-4A6C-A245-6D89F802628C@optusnet.com.au>
References:  <64A560B0-B971-4A6C-A245-6D89F802628C@optusnet.com.au>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
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 
> "
>




Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?906726E3-E109-4A3C-B5A7-2FE233CE1561>