Can't connect to MySQL server

[kdridi]

Hello,

I'm a beginner in haskell and i have a problem using haskelldb. I've developped this code : http://hpaste.org/76300 When i use ghci, it works like a charm. However, when i compile it using ghc, the program connects sometime to the mysql server and sometime not. The program is quite simple so i'm wondering if you have any clue about the error.

Thank you !

Test: user error (SQL error: SqlError {seState = "", seNativeError = 2003, seErrorMsg = "Can't connect to MySQL server on '192.168.1.10' (4)"})

[kdridi]

One more thing that may help

$ ghc --version The Glorious Glasgow Haskell Compilation System, version 7.4.2

cabal list --installed haskelldb

• haskelldb Synopsis: A library of combinators for generating and executing SQL statements. Default available version: 2.2.1 Installed versions: 2.2.1 Homepage: https://github.com/m4dc4p/haskelldb License: BSD3
• haskelldb-hdbc Synopsis: HaskellDB support for HDBC. Default available version: 2.2.1 Installed versions: 2.2.1 Homepage: https://github.com/m4dc4p/haskelldb License: BSD3
• haskelldb-th Synopsis: Template Haskell utilities for HaskellDB. Default available version: 2.1.0 Installed versions: 2.1.0 Homepage: http://trac.haskell.org/haskelldb-th License: BSD3

cabal list --installed hdbc

• HDBC Synopsis: Haskell Database Connectivity Default available version: 2.3.1.1 Installed versions: 2.3.1.1 Homepage: https://github.com/hdbc/hdbc License: BSD3
• HDBC-mysql Synopsis: MySQL driver for HDBC Default available version: 0.6.6.1 Installed versions: 0.6.6.1 Homepage: http://github.com/bos/hdbc-mysql License: LGPL
• haskelldb-hdbc Synopsis: HaskellDB support for HDBC. Default available version: 2.2.1 Installed versions: 2.2.1 Homepage: https://github.com/m4dc4p/haskelldb License: BSD3

[m4dc4p]

Try connecting by just using HDBC first. It may not be a HaskellDB issue at all.

Finally, GHCi and GHC use different rules to find libraries. You'll need to do some research to determine what's going on.