[Fwd: Re: Problem building hdbc-sqlite3 with ghc 6.8.2]

[Christian Maeder]

Hi Emmanuel,

sqlite3 must be installed on your mac, i.e. a file "libsqlite3.dylib".
(I don't have it, too.) If it is say under /opt/local/lib you may need
to pass "-optl-L/opt/local/lib" to ghc's command line (or set
LD_LIBRARY_PATH)

HTH Christian

manu wrote:
> Macintosh:blog_old_with_sqlite3 manu$ ghc --make newArticle.hs -o
> new_article.c
> gi
> [3 of 3] Compiling Main             ( newArticle.hs, newArticle.o )
> Linking new_article.cgi ...
> ld: atom sorting error for
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziTypes_CSqlite3_closure_tbl and
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziTypes_CStmt_closure_tbl in
> /usr/local/lib/HDBC-sqlite3-1.1.3.0/ghc-6.8.2/libHSHDBC-sqlite3-1.1.3.0.a(Types.o)
> 
> ld: atom sorting error for
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziTypes_CSqlite3_closure_tbl and
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziTypes_CStmt_closure_tbl in
> /usr/local/lib/HDBC-sqlite3-1.1.3.0/ghc-6.8.2/libHSHDBC-sqlite3-1.1.3.0.a(Types.o)
> 
> Undefined symbols:
>   "_sqlite3_errmsg", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziUtils_zdwccall_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Utils.o)
>   "_sqlite3_bind_null", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall11_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_bind_text", referenced from:
>       _sqlite3_bind_text2 in
> libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
>   "_sqlite3_column_name", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall6_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_total_changes", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall13_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_close", referenced from:
>       _sqlite3_close_app in
> libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
>   "_sqlite3_column_text", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall8_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_column_type", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall7_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_libversion", referenced from:
>       _r6xt_info in libHSHDBC-sqlite3-1.1.3.0.a(Connection.o)
>   "_sqlite3_finalize", referenced from:
>       _sqlite3_prepare2 in
> libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
>       _sqlite3_finalize_app in
> libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
>   "_sqlite3_changes", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall12_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_open", referenced from:
>       _sqlite3_open2 in libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
>   "_sqlite3_bind_parameter_count", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall2_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_step", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall3_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_busy_timeout", referenced from:
>       _sqlite3_busy_timeout2 in
> libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
>   "_sqlite3_column_count", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall5_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_reset", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall4_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_column_bytes", referenced from:
>      
> _HDBCzmsqlite3zm1zi1zi3zi0_DatabaseziHDBCziSqlite3ziStatement_zdwccall9_info in
> libHSHDBC-sqlite3-1.1.3.0.a(Statement.o)
>   "_sqlite3_prepare", referenced from:
>       _sqlite3_prepare2 in
> libHSHDBC-sqlite3-1.1.3.0.a(hdbc-sqlite3-helper.o)
> ld: symbol(s) not found
> collect2: ld returned 1 exit status
> 
> 
> 
> 
> On Jan 4, 2008, at 6:13 PM, Christian Maeder wrote:
> 
>> Please post the full ld error message
>> (also to glasgow-haskell-users at haskell.org)
>>
>> C.
>>
>> manu wrote:
>>> Hi Christian
>>>
>>> yes it did
>>>
>>> but, when i tried to compile one of my cgi script where I happen to use
>>> HDBC.Sqlite3
>>> it fails with similar 'ld' errors...
>>>
>>> so I can compile HDBC-Sqlite3, but not programs that use the package...
>>>
>>> Thanks
>>>
>>> Emmanuel
>>>
>>>
>>> On Jan 4, 2008, at 11:21 AM, Christian Maeder wrote:
>>>
>>>> Did a final "runhaskell Setup.lhs install" work for you, Emmanuel?
>>
>>
>