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@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?